Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Perl > Perl Misc > XML, DBI::AnyData and mySQL

Thread Tools

XML, DBI::AnyData and mySQL

Federico Bari
Posts: n/a
.... many of you suggested me to give a look to DBI::AnyData. I have the
necessity to insert and update a mySQL database taking datas fom xml files
that have *more tha one table*; infact the xml file (and it's xsd) is just a
copy of the structure of the final mySLQ database. Somebody of you noted me
that to say "XML with multi-tables datas" means all and nothing ... with
more detail I can say that I realized this xml file using the export
function of the last version of Access exporting the Access database to XML
file and its structure in a separate XSD file. Both have more than one table
inside, with relations.

What I found about DBI::AnyData is that:

1) it cannot import, manage in memory-tables XML that have more than one
table inside
2) it cannot automatically import datas from in-memory tables to mySQL

do you think this is right? What does this mean for me? Have i to separate
each table of the original XML file in a lot of new, distinct XMLs, each for
every table? And than? Have i to manually insert each each row, each field
of each table of each XML file in each table of mySQL database? I have mybe
more than 70 tables with 20 fields each one ... to become mad!!!!!



Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Python and Connecting to MySQL remotely WITHOUT MySQL installedon local computer dave Python 4 11-18-2010 04:19 AM
Re: How to insert PDF file in to MySql and read it from MySql toJAVA App Jeffrey H. Coffield Java 1 07-24-2009 12:29 AM
Re: How to insert PDF file in to MySql and read it from MySql to JAVA App Roedy Green Java 0 07-23-2009 05:30 PM
mySQL Ruby Gem and MAMP mySQL Mark Meijer Ruby 3 02-03-2008 04:19 AM
Has Anyone build A Mysql Module for ruby1.8.2 and Mysql 4.1.8 bin liu Ruby 1 12-22-2004 03:39 AM