NON activity class calling an SqlLite Dtabase For android

NON activity class calling an SqlLite Dtabase For android

package com.example.beachvolley;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;
public class DBAdapter {
public static final String DATABASE_NAME = "MyDb";
private static final String TAG = "DBAdapter";
private final Context context;
private DatabaseHelper myDBHelper;
private SQLiteDatabase db;
public static final int DATABASE_VERSION = 21;
// I CREATED A TOURNAMENT TABLE public static final String
TOURNAMENT_TABLE = "Tournament";
public static final String KEY_TOURNAMENT_ID = "IdTournament";
public static final int COL__TOURNAMENT_ID = 0;
public static final String KEY_NAME_TOURNAMENT = "TournamentName";
public static final int COL_NAME_TOURNAMENT = 1;
public static final String KEY_YEAR_TOURNAMENT = "Year";
public static final int COL_YEAR_TOURNAMENT = 2;
public static final String KEY_MYTEAM_TOURNAMENT = "MyTeam";
public static final int COL_MYTEAM_TOURNAMENT = 2;
public static final String[] ALL_TOURNAMENT_KEYS = new String[] {
KEY_TOURNAMENT_ID, KEY_NAME_TOURNAMENT, KEY_YEAR_TOURNAMENT,
KEY_MYTEAM_TOURNAMENT};
private static final String TOURNAMEN_TABLE_CREATE_SQL =
"create table " + TOURNAMENT_TABLE
+ " (" + KEY_TOURNAMENT_ID + " integer primary key autoincrement, "
+ KEY_NAME_TOURNAMENT + " string not null, "
+ KEY_YEAR_TOURNAMENT + " string not null, "
+ KEY_MYTEAM_TOURNAMENT + " string not null "
+ ");";
public Cursor getAllTournamentRows() {
String where = null;
Cursor c = db.query(true, TOURNAMENT_TABLE, ALL_TOURNAMENT_KEYS,
where, null, null, null, null, null);
if (c != null) {
c.moveToFirst();
}
return c;
}
public long insertTournamentRow(String nameTournament, String
yearTournament, String teamTournament) {
ContentValues initialValues = new ContentValues();
initialValues.put(KEY_NAME_TOURNAMENT, nameTournament);
initialValues.put(KEY_YEAR_TOURNAMENT, yearTournament);
initialValues.put(KEY_MYTEAM_TOURNAMENT, teamTournament);
return db.insert(TOURNAMENT_TABLE, null, initialValues);
}
//END OF TOURNAMENT TABLE
public DBAdapter(Context ctx) {
this.context = ctx;
myDBHelper = new DatabaseHelper(context);
}
// Open the database connection.
public DBAdapter open() {
db = myDBHelper.getWritableDatabase();
return this;
}
// Close the database connection.
public void close() {
myDBHelper.close();
}
//START OF MY DB HELPER
private static class DatabaseHelper extends SQLiteOpenHelper
{
DatabaseHelper(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase _db) {
_db.execSQL(TOURNAMEN_TABLE_CREATE_SQL);
_db.execSQL(GAME_TABLE_CREATE_SQL);
_db.execSQL(PLAYER_TABLE_CREATE_SQL);
_db.execSQL(PLAYER_SET_CREATE_SQL);
_db.execSQL(PLAYER_MOVE_CREATE_SQL);
_db.execSQL(PLAYER_STATS_CREATE_SQL);
_db.execSQL(PLAYER_PLAYERMOVES_CREATE_SQL);
_db.execSQL(PLAYER_ROSTER_CREATE_SQL);
_db.execSQL(TOURNAMENT_PLAYER_CREATE_SQL);
}
@Override
public void onUpgrade(SQLiteDatabase _db, int oldVersion, int
newVersion) {
Log.w(TAG, "Upgrading application's database from version " +
oldVersion
+ " to " + newVersion + ", which will destroy all old
data!");
// Destroy old database:
_db.execSQL("DROP TABLE IF EXISTS " + TOURNAMENT_TABLE);
_db.execSQL("DROP TABLE IF EXISTS " + GAME_TABLE);
_db.execSQL("DROP TABLE IF EXISTS " + PLAYER_TABLE);
_db.execSQL("DROP TABLE IF EXISTS " + SET_TABLE);
_db.execSQL("DROP TABLE IF EXISTS " + MOVE_TABLE);
_db.execSQL("DROP TABLE IF EXISTS " + STATS_TABLE);
_db.execSQL("DROP TABLE IF EXISTS " + PLAYERMOVE_TABLE);
_db.execSQL("DROP TABLE IF EXISTS " + PLAYER_ROSTER_TABLE);
_db.execSQL("DROP TABLE IF EXISTS " + TOURNAMENT_PLAYER_TABLE);
// Recreate new database:
onCreate(_db);
}
}
&& // HOW Am i able to store my data INTO MY TOURNAMENT TABLE I CAN'T CALL
THE method open(); top open my database package com.example.beachvolley;
import java.util.ArrayList;
import java.util.Observable;
import android.content.Context;
import android.database.Cursor;
import android.database.DatabaseErrorHandler;
import android.provider.OpenableColumns;
public class TournamentModel extends Observable { //NOTE it does not
extend activity only observable
public String TournamentName;// = getTournamentName();
public String TournamentYear;
public String TeamRecorded;
public boolean ToggeTname = true;
public boolean ToggeTyear = true;
public boolean ToggeTteam= true;
public boolean ToggePlayerNames= true;
Player[] ListOfPlayers;
public boolean CheckIfInvalid(String TournamentName, String Year,
String teamName, String FirstName1, String LastName1,String
FirstName2, String LastName2, String FirstName3, String LastName3,
String p1, String p2, String p3 ){
ToggeTname = true;
ToggeTyear = true;
ToggeTteam= true;
if(TournamentName.equals(""))
this.ToggeTname = false;
else
this.ToggeTname = true;
if(Year.equals(""))
this.ToggeTyear = false;
else
this.ToggeTyear = true;
if(teamName.equals(""))
this.ToggeTteam = false;
else
this.ToggeTteam = true;
if(FirstName1.equals("") || LastName1.equals("") ||
FirstName2.equals("") || LastName2.equals("")||
FirstName3.equals("") || LastName3.equals("") || p1.equals("")||
p2.equals("")|| p3.equals(""))
this.ToggePlayerNames = false;
else
this.ToggePlayerNames = true;
triggerObservers();
if(this.ToggeTname && this.ToggeTyear && this.ToggeTteam &&
this.ToggePlayerNames)
return true;
else
return false;
}
public void StoreInputsForTournament(boolean tog , String
TournamentName, String Year, String teamName, ArrayList<Player>
playerList ){
if(tog == true){
//code goes here to STORE INTO THE TOURNAMENT TABLE
}
}
private void triggerObservers() {
setChanged();
notifyObservers();
}
public boolean isToggeTname() {
return ToggeTname;
}
public void setToggeTname(boolean toggeTname) {
ToggeTname = toggeTname;
}
public boolean isToggeTyear() {
return ToggeTyear;
}
public void setToggeTyear(boolean toggeTyear) {
ToggeTyear = toggeTyear;
}
public boolean isToggeTteam() {
return ToggeTteam;
}
public void setToggeTteam(boolean toggeTteam) {
ToggeTteam = toggeTteam;
}
public boolean isToggePlayerNames() {
return ToggePlayerNames;
}
public void setToggePlayerNames(boolean toggePlayerNames) {
ToggePlayerNames = toggePlayerNames;
}
public String getTournamentYear() {
return TournamentYear;
}
public void setTournamentYear(String tournamentYear) {
TournamentYear = tournamentYear;
}
public String getTeamRecorded() {
return TeamRecorded;
}
public void setTeamRecorded(String teamRecorded) {
TeamRecorded = teamRecorded;
}
public String getTournamentName() {
return TournamentName;
}
public void setTournamentName(String tournamentName) {
this.TournamentName = tournamentName;
}
}