Importing an XML document into a Rails database? -


i've been reading through tutorial after tutorial, nothing seems working out me. goal take xml document elements , attributes , insert data in database. each element/attribute column in database, , each entry row. here made-up xml doc i've been working with:

<?xml version="1.0"?> <library> <name><![cdata[favorite books]]></name> <book isbn="11342343"> <title>to kill mockingbird</title> <description><![cdata[description#1]]></description> <author>harper lee</author> </book> <book isbn="989894781234"> <title>catcher in rye</title> <description><![cdata[this extremely intense description.]]></description> <author>j. d. salinger</author> </book> <book isbn="123456789"> <title>murphy's gambit</title> <description><![cdata[daughter finds dad!]]></description> <author>syne mitchell</author> </book> </library>

so want have table 2 entries, each entry having isbn, title, description, , author. that's basics. (the cdata optional suppose. if that's part of problem, means let's rid of it...)

end goal bit more complicated. multiple libraries multiple books. databases have relationship between them, can reference library database book database, , vice versa. i'm lost, rookie, have working computer knowledge , willing test , try things out.

i'm using rails 3.2.6 default sqlite3 database (3.6.20). i've installed rexml, roxml, libxml, etc , read through apis , walkthroughs, things aren't working out. there has easy way turn xml doc library object (with .name method) book objects (having .title, .author, .isbn, , .description methods).

any apprecaited!

update!

okay, next question. i've been fooling around logic behind this, , wanted know best way following...

suppose have new , improved xml file.

<?xml version="1.0"?> <randomtag> <library name='favorite books'> <book isbn="11342343"> <title>tkam</title> <description>desc1</description> <author>h lee</author> </book> <book isbn="989894781234"> <title>catcher in rye</title> <description>desc2</description> <author>jd s</author> </book> </library> <library name='other books'> <book isbn="123456789"> <title>murphy\'s gambit</title> <description>desc3</description> <author>syne m</author> </book> </library> </randomtag>

so have 2 libraries, first titled "favorite books" , having 2 books, second titled "other books" , having single book.

what best way each book know library belongs to? originally, created library database , book database. each book object had library_id field, referenced correct library. thus, each database correctly fill in using syntax "@library.books.each |b| b.title". this, however, worked when had 1 library.

i tried nesting book loop gave me inside similar library loop, .css method finds every single match, regardless of resides. there .css method finds until specific point?

to rephrase, i'd able import each book respective library. can't add fields xml file.

thanks again.

i did similar using nokogiri library.

doc = nokogiri::xml(xml_data) doc.css('book').each |node| children = node.children book.create( :isbn => node['isbn'], :title => children.css('title').inner_text, :description => children.css('description').inner_text, :author => children.css('author').inner_text ) end

update

you create quick test doing this:

first install nokogiri gem:

gem install nokogiri

then create file called text_xml.rb contents:

require 'nokogiri' doc = nokogiri::xml('<?xml version="1.0"?> <library> <name><![cdata[favorite books]]></name> <book isbn="11342343"> <title>to kill mockingbird</title> <description><![cdata[description#1]]></description> <author>harper lee</author> </book> <book isbn="989894781234"> <title>catcher in rye</title> <description><![cdata[this extremely intense description.]]></description> <author>j. d. salinger</author> </book> <book isbn="123456789"> <title>murphy\'s gambit</title> <description><![cdata[daughter finds dad!]]></description> <author>syne mitchell</author> </book> </library>') doc.css('book').each |node| children = node.children book = { "isbn" => node['isbn'], "title" => children.css('title').inner_text, "description" => children.css('description').inner_text, "author" => children.css('author').inner_text } puts book end

and run:

ruby test_xml.rb

i suspect weren't escaping single quote in murphy's gambit when pasted in xml.


Comments

Post a Comment

Popular posts from this blog

javascript - backbone.js Collection.add() doesn't `construct` (`initialize`) an object -

<!doctype html public "-//w3c//dtd xhtml 1.0 strict//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-strict.dtd"> <html> <head> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script> <script src="http://documentcloud.github.com/underscore/underscore-min.js"></script> <script src="http://documentcloud.github.com/backbone/backbone-min.js"></script> </head> <body> <button id="cmd_create_event" name="cmd_create_event" type="button">create new `event`</button> <script type="text/javascript"> var eventmodel = backbone.model.extend({ initialize : function() { console.log("`event` initialized. id: " + this.cid); this.bind("change:status", function() { console.log(this.get("status") + " value `status`"); }); this.bind("error", function(model, e...
Read more

php - Get uncommon values from two or more arrays -

is there function in php give array of uncommon values 2 or more arrays? for example: $array1 = array( "green", "red", "blue"); $array2 = array( "green", "yellow", "red"); .... $result = function_needed($array1, $array2,...); print_r($result); should give output: array("blue", "yellow", ...); use array_diff , array_merge : $result = array_merge(array_diff($array1, $array2), array_diff($array2, $array1)); here's demo. for multiple arrays, combine callback , array_reduce : function unique(&$a, $b) { return $a ? array_merge(array_diff($a, $b), array_diff($b, $a)) : $b; } $arrays = array( array('green', 'red', 'blue'), array('green', 'yellow', 'red') ); $result = array_reduce($arrays, 'unique'); and here's demo of that.
Read more

Adding duplicate array rows in Php -

i create function in php adds rows of array shared column value. so input. $test = array( array("c", 5, 6), array("c", 2, 3), array("test", 5, 6) ); and output. $testduplicatefree = array( array("c", 7, 9), array("test", 5, 6) ) ); i'm thinking function combine_duplicates($array,$col){ ... ... return $duplicatefreearray; } where $col duplicate free array. so, in case, combine_duplicates($test,0); would me desired output. this. <?php function combine_duplicates($array,$col) { $index = array(); foreach ($array $row) { $key = $row[$col]; if (!isset($index[$key])) { $index[$key] = $row; } else { ($i = 0; $i < count($row); ++$i) { if ($i != $col) { $index[$key][$i] += $row[$i]; } } } } return array_values($index); } $array = array( array("c", 5, 6), array("c", 2, 3), array("test", 5, 6) ); print_r(combine_duplicates($array, 0)); try here: http://codepad.org/mdhesqhi
Read more