android generic SQLite database

Question

i developed a small java.lang.reflect.InvocationHandler that intercepts method calls (from a json webservice) and cache the results to a local SQLite db. if there is no internet connection results are read from local cache.

everything works fine; my problem is the following:

every method intercepted can return a different entity, and i save using reflection each entity on a different table. i don't know in advance all the tables i need to create, so every time i create a SQLiteOpenHelper that "create table if not exists {ENTITY_NAME}", and every time i increase the database version by 1 so the method onUpgrade is called.

this works on development environment but i don't like that at all.

someone can recommend a better solution to update the database with new tables?

thank you

Answer 1

Try mYourDbHelper.getWritableDatabase().execSQL("CREATE TABLE ....") from where you need to create another table