ruby on rails - Save loop of xml to database table -

-

please see below xml file:

<event id="12987613" link="https://www.skiddle.com/whats-on/bolton/bolton-arena/dldk---dont-let-daddy-know/12987613/?sktag=xxx">   <name><![cdata[dldk - don't let daddy know]]></name>   <date>2017-10-07</date>   <eventcode>club</eventcode>   <shortdesc><![cdata[don't let daddy know returns greater manchester october biggest ever uk show! featuring steve angello, knife party, blasterjaxx]]></shortdesc>   <doorsopen>21:00</doorsopen>   <doorsclose>06:00</doorsclose>   <image>https://d31fr2pwly4c4s.cloudfront.net/9/f/f/962862_3_dont-let-daddy-know_th.jpg</image>   <venue id="3764">     <name><![cdata[bolton arena]]></name>     <address>bolton arena, arena approach, horwich</address>     <city>bolton</city>     <town>bolton</town>     <citycode>bl6</citycode>     <postcode>bl6 6lb</postcode>   </venue>   <tickets>     <ticket id="351828">       <name><![cdata[vip ticket]]></name>       <facevalue>50.00</facevalue>       <bookingfee>6.00</bookingfee>       <quantity>more 10 available</quantity>       <status statuscode="1">available</status>     </ticket>     <ticket id="357740">       <name><![cdata[vip upgrade ticket]]></name>       <facevalue>17.50</facevalue>       <bookingfee>2.10</bookingfee>       <quantity>more 10 available</quantity>       <status statuscode="1">available</status>     </ticket>   </tickets>  </event>

i have file filled on 1000 events. i'm wanting potentially pretty easy. i'm making new database table called skiddle_tickets. each ticket belong event. i'm right in thinking in need belongs in model , has many in events model.

what i'm wanting each ticket match event id. tickets placed event table when event created. way works event created via rake task. using same xml file. can capture event id when created.

so want each ticket saved against in table against event if called event.tickets.each can each ticket (or similar)

how go doing this? difficult part xml database part

at moment i'm putting data in database this:

      event = {         'custom_event_id' => node['id'],         'eventname' => children.css('name').first.inner_text,       } event.create(event)

any ideas, thoughts or suggestions amazing!


Comments

Post a Comment

Popular posts from this blog

ZeroMQ on Windows, with Qt Creator -

-
i have installed zmq link given below on windows 7. http://zeromq.org/distro:microsoft-windows 1) have c++ project in qt-creator , i'm using zmq c++ binding (zhelpers.hpp etc). 2) have added .lib installed zmq folder qtcreator 3) while compiling, compiler looks _imp__zmq_verion, in .dll files present in .lib have __imp_zmq_version. 4) causing undefined reference zmq_version. anyone else faced problem , has solution ?
Read more

unity3d - Unity SceneManager.LoadScene quits application -

-
i have 2 different scenes 1 named 'main' , other 'game' both added scenes in load. when use scenemanager.loadscene("game"); works no problem when tried return main scene code if (input.getkeydown (keycode.escape)) { scenemanager.loadscene("main"); } strangely game quits. thanks. sorry interruption. somewhere on other script found code. if (input.getkeydown (keycode.escape)) { application.quit (); } that's bad, know...
Read more

python - Error while using APScheduler: 'NoneType' object has no attribute 'now' -

-
i have python app hosting on heroku. use apscheduler call function every day @ time. strange thing 1 time function runs after while have following error log: exception in thread apscheduler (most raised during interpreter shutdown): 2017-09-06t15:03:28.347848+00:00 app[web.1]: traceback (most recent call last): 2017-09-06t15:03:28.347858+00:00 app[web.1]: file "/app/.heroku/python/lib/python2.7/threading.py", line 810, in __bootstrap_inner 2017-09-06t15:03:28.347859+00:00 app[web.1]: file "/app/.heroku/python/lib/python2.7/threading.py", line 763, in run 2017-09-06t15:03:28.347861+00:00 app[web.1]: file "/app/.heroku/python/lib/python2.7/site-packages/apscheduler/schedulers/blocking.py", line 27, in _main_loop 2017-09-06t15:03:28.348167+00:00 app[web.1]: <type 'exceptions.attributeerror'>: 'nonetype' object has no attribute 'now' any guesses? the full code long here key parts: def startdayauto(): global ...
Read more