How to execute .sql file into android?

Question

I saw that i can execute a .sql file with shell commands...

Process process = Runtime.getRuntime().exec(commandLine);
BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(process.getInputStream()));

The "commandLine" attribute must be something like that?

commandLine = "sqlite> .read database.sql";

And another doubt... Where should i keep my "database.sql" file? Into assets? I've tryed to do that but not worked... Someone knows how to do it?

I got the same need actually. Waiting for an answer.

Hüseyin Z.
– Hüseyin Z.

2012-04-15 15:15:54 +00:00
Commented Apr 15, 2012 at 15:15 — Hüseyin Z.
– Hüseyin Z., Commented Apr 15, 2012 at 15:15

CommonsWare · Accepted Answer · 2012-04-15 15:37:54Z

2

I saw that i can execute a .sql file with shell commands

That would be a really bad idea. There are no shell commands that are part of the Android SDK and therefore are guaranteed to be on all devices.

Read in the SQL script and execute its statements via execSQL() and kin on SQLiteDatabase, perhaps wrapping them in your own transaction using beginTransaction() and kin.

answered Apr 15, 2012 at 15:37

CommonsWare

1.0m195 gold badges2.4k silver badges2.7k bronze badges

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

6 Comments

Igor Over a year ago

Well, so how can i read that sql script into application? i read directly from assets?

CommonsWare Over a year ago

@Igor: "Well, so how can i read that sql script into application?" -- use Java file I/O. "i read directly from assets?" -- you are welcome to do that too, if that is where your scripts are stored.

Igor Over a year ago

Some advice about where should i keep my script? is there any problema to keep sql file into the assets?

CommonsWare Over a year ago

@Igor: "Some advice about where should i keep my script?" -- you should be asking yourself why you have such a script in the first place. "is there any problema to keep sql file into the assets?" -- probably not, but that is impossible to answer in the abstract.

Igor Over a year ago

well.. so now im having another problem... im reading as you said... and it really worked when i tested with around 10 lines into my database.sql but the problem is when i put there around 50.000 lines and the file get 3MB or something like that... When i put the real script the file code to read the file line by line dont work...

|

Collectives™ on Stack Overflow

How to execute .sql file into android?

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related