Android Open Source - Netball Game

From Project

Back to project page Netball.

License

The source code is released under:

GNU General Public License

If you think the Android project Netball listed in this page is inappropriate, such as containing malicious code/tools or violating the copyright, please email info at java2s dot com, thanks.

Java Source Code

package com.prisch.model;
/*from  w ww. j a  va 2  s.  co  m*/
import android.database.sqlite.SQLiteDatabase;

public class Game {

    // ===== Convenience Methods =====

    public static String prefixTable(String column) {
        return TABLE + "." + column;
    }

    // ===== Database Scaffolding =====

    public static void onCreate(SQLiteDatabase db) {
        db.execSQL(CREATE_SCRIPT);
    }

    public static void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL(DROP_SCRIPT);
        onCreate(db);
    }

    // ===== Constants =====

    public static final String ID = "_id";
    public static final String DATE = "date";
    public static final String NAME = "name";
    public static final String TEAM_SCORE = "team_score";
    public static final String OPPONENT_SCORE = "opponent_score";
    public static final String ACTIVE = "active";

    public static final String TABLE = "game";

    private static final String CREATE_SCRIPT = "CREATE TABLE " + TABLE + " ("
                                                + ID             + " INTEGER PRIMARY KEY AUTOINCREMENT, "
                                                + DATE           + " INTEGER NOT NULL UNIQUE,"
                                                + NAME           + " TEXT NOT NULL,"
                                                + TEAM_SCORE     + " INTEGER NOT NULL,"
                                                + OPPONENT_SCORE + " INTEGER NOT NULL,"
                                                + ACTIVE         + " NUMERIC NOT NULL);";
    private static final String DROP_SCRIPT = "DROP TABLE " + TABLE;

}

Java Source Code List