How can I dump my database to make it build on the fly?
BEGIN TRANSACTION;
CREATE TABLE android_metadata (locale TEXT);
INSERT INTO "android_metadata" VALUES('en_US');
CREATE TABLE 'olddominionuniversity' (_id integer primary key
autoincrement, university text not null, building text not null,
locode text not null);
INSERT INTO "olddominionuniversity" VALUES(1,'Old Dominion
University','Kaufman Hall','IDEA-7TCL');
INSERT INTO "olddominionuniversity" VALUES(2,'Old Dominion
University','Perry Library','RE3S-XR5T');
DELETE FROM sqlite_sequence;
INSERT INTO "sqlite_sequence" VALUES('olddominionuniversity',2);
CREATE TABLE harvarduniversity (
"_id" INTEGER,
"university" TEXT,
"building" TEXT,
"locode" TEXT
);
INSERT INTO "harvarduniversity" VALUES('_id','Harvard','Building
1','TBA');
COMMIT;
I tried to put it as a string and execute it but I get all sorts of
error. When I did line by line, it worked, but I am talking bout a
HUGE database
On Jun 21, 1:47 pm, Georgy <[email protected]> wrote:
> my only way to do it was to dump the database and get the code and
> insert it in the database to build it on the fly just like Burton
> Miller suggested.
>
> I think this is not the best approach and could slow things down
> tremendously
>
> On Jun 20, 4:51 pm, burton miller <[email protected]> wrote:
>
> > this was not possible in previous versions of the os - maybe it is
> > now.
>
> > up until now, you have three options:
> > 1) build db on the fly
> > 2) put db in assets, then copy it to db directory when you first run
> > (2x space).
> > 3) install db from internet as a secondary installation
>
> > if things have changed - then i'll rewrite one of my apps!
>
> > On Jun 19, 12:43 pm, Georgy <[email protected]> wrote:
>
> > > Hello
>
> > > I have an SQL lite database that I am trying to copy to the device. I
> > > was able to copy it to the emulator easily using DDMS however with the
> > > protection in the device, I cannot access the database files from the
> > > DDMS perspective.
>
> > > I read many attempts here but couldn't find an easy solution.
>
> > > Is there any way to attach the database (let's say named 'proj') and
> > > replace the currently created database proj in he device files?
>
> > > thanks
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
-~----------~----~----~----~------~----~------~--~---
