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 :)
