VC116AYB

1
2    @Override
3    public void onCreate(SQLiteDatabase db)
4    {
5        final String ratedFestivalTable = "CREATE TABLE IF NOT EXISTS ratedFestivals ( " +
6                "title TEXT PRIMARY KEY NOT NULL, " +
7                "value REAL )";
8        db.execSQL(ratedFestivalTable);
9
10        Log.v("created database tables", "new tables");
11        final String scienceFestivalCache = "CREATE TABLE IF NOT EXISTS scienceFestivalCache (" +
12                "title TEXT PRIMARY KEY NOT NULL, " +
13                "description_teaser TEXT, " +
14                "description TEXT, " +
15                "genre TEXT, " +
16                "start TEXT, " +
17                "end TEXT, " +
18                "lat REAL, " +
19                "long REAL)";
20        db.execSQL(scienceFestivalCache);
21    }
22
23    @Override
24    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
25
26    }
27
28    public void toScienceCache(FestivalEvent event)
29    {
30        SQLiteDatabase db = this.getWritableDatabase();
31        //db.delete("scienceFestivalCache", "title=?", new String[]{event.title});
32
33        ContentValues values = new ContentValues();
34        values.put("title", event.title);
35        values.put("description_teaser", event.description_teaser);
36        values.put("description", event.description);
37        values.put("genre", event.genre);
38        values.put("start", event.start());
39        values.put("end", event.end());
40        values.put("lat", event.latitude);
41        values.put("long", event.longitude);
42        try
43        {
44            db.insert("scienceFestivalCache", null, values);
45        }
46        catch (Exception e)
47        {
48            Log.v("exception: ", e.getMessage());
49        }
50        db.close();
51    }