I want a sqlite query to read xml file ..

Question

Can anyone help me with the sqlite? i want a sqlite query for reading my xml file and then i want a function that will convert my xml file to the sqlite table...

please help me with this.

thanks, kruti

Answer 1

There's no query or function to do this. The way to go is to write a stylesheet (.xsl) that produces output consumable by sqlite's .import command.

Answer 2

Hey, yup, there is no way to read XML by sqlite commands, but you can create your own function which takes XML path as parameter. and then follow following steps.. assuming that u r using .NET, and you know the structure of the XML (nodes, elements and attributes) 1) load XML in XmlDocument, so that you can read xml elements, 2) iterate one FOR loop for number of times equal to node count in XML 3) build one dynamic string which prepares "Insert" command of Sqlite, with all required node values as column values. 4) execute dynamically prepared "Insert" command in SQlite.

I hope this will work.

Thanks, Chirag Patel Sr. System analyst, Xerox Corp.