<p>I would suggest opening both databases in their native form, then do the comparison using Python code rather than a complex SQL query. It may take a while to run, but should work okay. SQLite select statements are quite fast. Trying to do the whole thing in one swallow may be too much. Better to do lots of querys sequentially and build your result set as you go.</p>
<div class="gmail_quote">On Mar 14, 2012 10:55 AM, "Sven Thomas" <<a href="mailto:Sven.Thomas@prov.ca">Sven.Thomas@prov.ca</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-CA" link="blue" vlink="purple"><div><p class="MsoNormal"><span lang="EN-GB">Greetings all,<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-GB"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-GB">I’m sort of new to IP and brand new on this mailing list. </span><span lang="EN-GB" style="font-family:Wingdings">J</span><span lang="EN-GB"> <u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-GB">Here’s my situation: I need to build a report of everything missing from our institution's library that isn't accounted for (i.e. we want to find what's been stolen/lost, etc.) That means the librarians will scan every item to build a table in SQLite ("LibTBL") - this portion of the code is already working. To build the report, I need to compare LibTBL (physical items in the library) to the records on the server.<br>
<br>My plan is to pull every record from the server (nearly 100k+) into an SQLite table ("ServerTBL") so I can run queries from one table against the other (LibTBL vs. ServerTBL. The end result of this will be a third table that contains only the items on the server that were not scanned in the library. These are the items that are either checked out or missing.<br>
<br>What's the best way to go about this? So far I’m using System.Data.SQLite oracle’s <a href="http://ADO.NET" target="_blank">ADO.NET</a> connector and I’m pulling a table from Oracle to a .Net dataset. I can fill the DataSet with the table from Oracle, but my attempts at using the SQLite data adapter to put into the SQLite db have failed. How would I go about dumping a dataset into an SQLite file?<br>
<br>Any help or direction would be greatly appreciated.<br><br>Thanks,</span><u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal"><span>Sven<u></u><u></u></span></p></div></div><br>_______________________________________________<br>
Ironpython-users mailing list<br>
<a href="mailto:Ironpython-users@python.org">Ironpython-users@python.org</a><br>
<a href="http://mail.python.org/mailman/listinfo/ironpython-users" target="_blank">http://mail.python.org/mailman/listinfo/ironpython-users</a><br>
<br></blockquote></div>