package chris.allan.awesome;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

/**
 * Created by Allan on 16-09-2014.
 */
public class SQLController
{
    private GameDatabase gd;

    private SQLiteDatabase database;

    public final static String HIGHSCORES_TABLE="highscores"; // name of table

    public final static String PLAYER_NAME="name";  // name of player
    public final static String SCORE="score"; //Score of player
    /**
     *
     * @param context
     */
    public SQLController(Context context){
        gd = new GameDatabase(context);
        database = gd.getWritableDatabase();
    }


    public void createRecords(String name, String score){
        ContentValues values = new ContentValues();
        values.put(PLAYER_NAME, name);
        values.put(SCORE, score);
        database.insert(HIGHSCORES_TABLE, null, values);
    }

    public Cursor getAll() {
        if (database == null) {
            return null;
        }
        return database.rawQuery("select * from highscores",null);
    }





}