How to execute the query in a plain text file in Android?

Question

I can read a text file which is in the assets folder. But now I have a DB creation query in the text file; how can I execute that query in Android? Please don't ask why I want to keep queries in a plain text file.

here is example of that http://www.vogella.com/articles/AndroidSQLite/article.html#sqliteoverview_rawquery — rajpara, Jun 27 '12 at 07:01

score 4 · Answer 1 · edited May 23 '17 at 12:16

You should use a SqliteOpenHelper and override the onCreate method. Inside that method you should read the file from resources and execute it.

See this for how to use an SqliteOpenHelper

Then for reading file from resources just do this (from here):

    @Override
    public void onCreate(SQLiteDatabase database) {
      Resources res = getResources();
      InputStream in_s = res.openRawResource(R.raw.sql);
      byte[] b = new byte[in_s.available()];
      in_s.read(b);
      String sql = new String(b);
      database.execSQL(sql);
    }

Then you also need to implement onUpgrade (since it is marked as abstract) but you don't need to do anything in that method until you decide to change the structure of your database.

How to execute the query in a plain text file in Android?

1 Answers1