package edu.ktu.lab;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import java.util.ArrayList;
public class LeaderboardDatabaseHandler extends SQLiteOpenHelper {
private static final int DATABASE_VERSION = 1;
private static final String DATABASE_NAME = "leaderboard.db";
private static String SCORES_TABLE_NAME = "scores";
private final static String KEY_ID = "id";
private final static String KEY_NAME = "name";
private final static String KEY_SCORE = "score";
public LeaderboardDatabaseHandler(Context context)
{
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db)
{
String query = "CREATE TABLE " + SCORES_TABLE_NAME + "(" +
KEY_ID + " INTEGER PRIMARY KEY," +
KEY_NAME + " TEXT," +
KEY_SCORE + " INTEGER" +
")";
db.execSQL(query);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
{
String query = "DROP TABLE IF EXISTS " + SCORES_TABLE_NAME;
db.execSQL(query);
onCreate(db);
}
}