Creating SQLite DB in Android From Script

Question

Is it possible to use some kind of ddl script in SQLiteHelper to create database?

Rich · Accepted Answer · 2012-01-17 13:14:59Z

1

Yes. I usually have a main DB class in my application that encapsulates an inner class that derives from SQLiteOpenHelper. In the onCreate, you get a SQLiteDatabase instance as a parameter. Call db.execSQL(String) with the appropriate script(s) to create your tables and populate them.

answered Jan 17, 2012 at 13:14

Rich

36.9k31 gold badges119 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Orest Over a year ago

Well it sounds I still have to convert my ddl to string with my hands(I was hoping that there is something like runScript method). As I understood to upgrade I have to increment db version and in onUpgrade() method exec script which will include commands for deleting old tables, creating few new tables, and inserting some default data, am I right?

Rich Over a year ago

Yeah...that's correct. What format is your DDL in? You don't have to convert your scripts to java strings by typing them out manually. You can load your scripts to text and parse them in code.

Orest Over a year ago

You don't have to convert your scripts to java strings by typing them out manually. I knew that (= Thanks for response.

Collectives™ on Stack Overflow

Creating SQLite DB in Android From Script

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related