[Ironpython-users] DataSet --> SQLite
Sven.Thomas at prov.ca
Fri Mar 16 17:23:13 CET 2012
So far I've worked out a solution iterating through the dataset. It's
slow and the hard drive pins, but this report is only intended to be run
once a year so performance isn't exactly a priority:
for i in range(self.oraData2.Tables.Rows.Count -1):
title = self.oraData2.Tables.Rows[i]
bcode = self.oraData2.Tables.Rows[i]
callno = str(self.oraData2.Tables.Rows[i])
stat1 = str(self.oraData2.Tables.Rows[i])
stat2 = str(self.oraData2.Tables.Rows[i])
(prep and execute SQL)
I'm on a bit of a timeline with this project before the end of the
semester so I'll explore a more performance friendly method once our
library gets underway with this version.
To be honest; System.Data.SQLite wasn't working because I've no idea how
to do it! :0 I kept translating code examples from VB and C# but it
didn't work. I'm sure it can be done quite well, I'm just a little too
green on the subject. :)
> -----Original Message-----
> From: Jeff Hardy [mailto:jdhardy at gmail.com]
> Sent: March-16-12 10:49 AM
> To: Vernon Cole
> Cc: Sven Thomas; ironpython-users at python.org
> Subject: Re: [Ironpython-users] DataSet --> SQLite
> On Wed, Mar 14, 2012 at 3:34 PM, Vernon Cole
> <vernondcole at gmail.com> wrote:
> > I would suggest opening both databases in their native form, then
> > the comparison using Python code rather than a complex SQL query.
> > may take a while to run, but should work okay. SQLite select
> are quite fast.
> > Trying to do the whole thing in one swallow may be too much.
> > do lots of querys sequentially and build your result set as you
> I agree with Vernon, but of course it depends on the operations you
> to do.
> You'll need to provide a little more information about why
> System.Data.SQLite isn't working for you. You could also try
> sqlite3 support, which is more Pythonic.
> - Jeff
More information about the Ironpython-users