Re: variable expansion with sqlite

2008-08-08 Thread Kris Kennaway
marc wyburn wrote: 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. The '?' substitution is there to safely handle untrusted input. You *don't* want to pass in arbitrary user dat

Re: variable expansion with sqlite

2008-07-30 Thread 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 <[EMAIL PROTECTED]> wrote: > Gerhard Häring wrote: > > My code would probably look very

Re: variable expansion with sqlite

2008-07-30 Thread Tim Golden
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 so

Re: variable expansion with sqlite

2008-07-30 Thread Gerhard Häring
Tim Golden wrote: marc wyburn wrote: Hi I'm using SQlite and the CSV module and trying to create a class that converts data from CSV file into a SQLite table. My script curently uses functions for everything and I'm trying to improve my class programming. The problem I'm having is with variabl

Re: variable expansion with sqlite

2008-07-30 Thread Tim Golden
marc wyburn wrote: Hi I'm using SQlite and the CSV module and trying to create a class that converts data from CSV file into a SQLite table. My script curently uses functions for everything and I'm trying to improve my class programming. The problem I'm having is with variable expansion. self.