How to keep SQLite queries in seperate text files and access them in Android?

Question

I want to keep database creation queries and data accessing queries in text file format (those text files will be in a folder like "res" folder) and access them from android.

Let's say I want to execute the createDB() query, then I should be able to call by the relevant text file name and query should be executed.

I searched the internet and couldn't end up with a suitable tutorial or solution. So I am seeking some idea/solution or at least a good tutorial which satisfy my requirement.

in strings.xml, or in a separate strings file named queries.xml — Christine, Jun 26 '12 at 13:36
Thanks gtumca-MAC and Christine.can you please explain bit about how to do it with xml and/or how should I call the xml? — S.Basnagoda, Jun 26 '12 at 13:42

Caner · Answer 1 · 2012-06-26T13:45:02.207

1

I don't know why you want to do that but this is how you can do it:

1) Put those files in assets folder
2) You can open them like this:

InputStream input = context.getAssets().open("example.xml");

edited Jun 26 '12 at 13:45

answered Jun 26 '12 at 13:39

Caner

57,267
35
174
180

Is `fileName` a string or a `File`? – Alex Lockwood Jun 26 '12 at 13:41
It is a `String`, only the file name without path; for example: "example.xml" – Caner Jun 26 '12 at 13:41
Is it prefixed with `file:///`? – Alex Lockwood Jun 26 '12 at 13:44
OK, I was just making sure. Because apparently accessing files with `file:///` crashes your app on ICS and I was wondering if you knew how to fix that because I could never figure it out :P – Alex Lockwood Jun 26 '12 at 13:49
i.e. this: http://stackoverflow.com/questions/8390985/android-4-0-1-breaks-webview-html-5-local-storage – Alex Lockwood Jun 26 '12 at 13:49

How to keep SQLite queries in seperate text files and access them in Android?

1 Answers1