Android Open Source - game_guess_lib Guess S Q L

• Back to Game/guess  ↑

From Project

Back to project page game_guess_lib.

License

The source code is released under:

MIT License

Java Source Code

package com.wkmf.guess.lib.data;
//w w  w . j  a v  a2 s .  co m
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

/**
 * Created by ernestofndz on 9/02/14.
 */
public class GuessSQL extends SQLiteOpenHelper {

    // tabla de niveles
    private final String sqlCreateGuessGame = "CREATE TABLE "+ GuessGameBDDHandler.tableName+" ("
            + "ID TEXT PRIMARY KEY NOT NULL"
            + ",VALUE TEXT NOT NULL"
            + ",DATE_CREATED CURRENT_TIMESTAMP"
            + ")";

    // constructor
    public GuessSQL(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) {
        super(context, name, factory, version);
    }

    // creamos las tablas
    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL(sqlCreateGuessGame);
    }

    // se actualizan las tablas de ser necesario
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("DROP TABLE IF EXIST "+ GuessGameBDDHandler.tableName);
        // y se crean las nuevas
        onCreate(db);
    }
}

Java Source Code List

• Back to Game/guess  ↑