variable expansion with sqlite

[marc wyburn]

Hi and thanks,

I was hoping to avoid having to weld qmarks together but I guess
that's why people use things like SQL alchemy instead.  It's a good
lesson anyway.

Thanks, Marc.


On Jul 30, 2:24 pm, Tim Golden <m... at timgolden.me.uk> wrote:
> Gerhard Häring wrote:
> > My code would probably look very similar. Btw you don't need to use
> > list() on an iterable to pass to executemany(). pysqlite's executemany()
> > accepts anything iterable (so generators work fine, too).
>
> Thanks for that. My finger-memory told me to do that, possibly
> because some *other* dbapi interface only accepts lists. Can't
> quite remember. I'm usually all in favour of non-crystallised
> iterators.
>
> > Also, with SQLite you can just skip data type definitions like
> > VARCHAR(200). They're ignored anyway.
>
> Heh. Once again, finger memory forced me to put *something*
> in there. I've been developing Enterprise databases for too
> long :)
>
> TJG