Getting an SQLite working within Android and accessing data

I am trying to get an SQLite database to work in Android and have a few questions!

I have put the following in the onCreate method of my database class, which extends SQLiteOpenHelper.

db.execSQL("CREATE TABLE IF NOT EXISTS `challenge` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `date` TEXT )");

I then have the following method.

public void addChallenge(){

    SQLiteDatabase db = this.getWritableDatabase();

    Date cDate = new Date();
    String fDate = new SimpleDateFormat("yyyy-MM-dd").format(cDate);

    ContentValues values = new ContentValues();
    values.put("date", fDate);

    db.insert("challenge", null, values);

}

And the following would grab the challenge added above back.

public int getChallengeId(){

    SQLiteDatabase db = this.getWritableDatabase();

    Date cDate = new Date();
    String fDate = new SimpleDateFormat("yyyy-MM-dd").format(cDate);

    String countQuery = "SELECT id FROM challenge WHERE date = " + fDate;

    Cursor cursor = db.rawQuery(countQuery, null);

    int challenge_id = 0;

    if(cursor.moveToFirst()){
        challenge_id = cursor.getInt(0);
    }

    return challenge_id;

}

My issue is that the challenge ID is returning as 0.

So I have a few questions.

• Where is the database stored by default within Android?


• Am I calling this correctly?

The code I use to access the above methods is as follows

Database db_add = new Database(context);
db_add.addChallenge();
db_add.close();

Database db_get = new Database(context);
challenge_id = db_get.getChallengeId();
db_get.close();

Any ideas? Thanks.