last question... Do I really need to bother with PRIMARY KEY , KEY, CONSTRAINT, ENGINE and UNIQUE KEY ?
thanks, Mart :) On Jun 21, 9:55 pm, mart <[email protected]> wrote: > sounds good, will do that then. > > Thanks, > Mart :) > > On Jun 21, 9:53 pm, Massimo Di Pierro <[email protected]> > wrote: > > > > > > > > > The easiest way is make a web2py model that matches these fields: > > > db.define_table('bitmap', > > Field('bitmap_id','id'), > > Field('filename'), > > Field('kdb_id','integer'), > > Field('isDeleted','integer')) # 0 or 1 > > > parse the XML into CSV (excel may be able to do it) and import the > > CSV. > > > On Jun 21, 8:21 pm, mart <[email protected]> wrote: > > > > also, I found that they gave me the equivalent data in a .sql file.... > > > would that be understood by DAL? > > > > thanks again, > > > Mart :) > > > > On Jun 21, 9:14 pm, mart <[email protected]> wrote: > > > > > Hi, > > > > > let's say someone gave me a dump of a mySQL DB in xml format... > > > > something that looks like this: > > > > > <pma:structure_schemas> > > > > <pma:database name="test" collation="latin1_swedish_ci" > > > > charset="latin1"> > > > > <pma:table name="bitmap"> > > > > CREATE TABLE `bitmap` ( > > > > `bitmap_id` int(11) NOT NULL AUTO_INCREMENT, > > > > `filename` varchar(100) NOT NULL, > > > > `kdb_id` int(11) NOT NULL, > > > > `isDeleted` tinyint(1) NOT NULL DEFAULT '0', > > > > PRIMARY KEY (`bitmap_id`), > > > > KEY `kdb_id` (`kdb_id`), > > > > CONSTRAINT `bitmap_ibfk_1` FOREIGN KEY (`kdb_id`) > > > > REFERENCES `kdb` (`kdb_id`) ON DELETE CASCADE ON UPDATE CASCADE > > > > ) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT > > > > CHARSET=latin1; > > > > </pma:table> > > > > > what would be the best way to migrate this to an SQLite DB, something > > > > that web2py could use? > > > > > I know that DAL can export to xml, but does it also import from xml as > > > > well? Perhaps, this can be converted to CSV? > > > > > As usual, any help is much appreciated, > > > > > thanks, > > > > Mart :)
