Re: [sqlite] 回复: [sqlite] Re: Newbie sqlite questions: check existence of column

2006-11-16 Thread Florent THIERY
Yup i updated too. I had only sqlite-2 python bindings installed (debian) On 11/16/06, Linker M Lin <[EMAIL PROTECTED]> wrote: And mine is: >>> import sqlite >>> sqlite.version '1.1.8' >>>

Re: [sqlite] Re: unrecognized token error

2006-11-15 Thread Florent THIERY
THANK YOU A LOT, it works like a charm now :) In fact, my hash wasn't calculated the same way before, and the hash wasn't starting with a number, so i did'nt realized why it was malfunctioning. Have a nice evening Florent On 11/15/06, Igor Tandetnik <[EMAIL PROTECTED]> wr

[sqlite] unrecognized token error

2006-11-15 Thread Florent THIERY
Hi My request: "create table %s (profileID char(32) etc...)" % (tableID) # Where tableID is a 32 char hexstring (hash) 4b0c25789ab124628444951dd995fdcc in this case create table 4b0c25789ab124628444951dd995fdcc (profileID char(32) , _soi char(7) etc. ) The unswear: _sqlite.DatabaseError:

Re: [sqlite] Newbie sqlite questions: check existence of column

2006-11-14 Thread Florent THIERY
e: On 11/14/06, Florent THIERY <[EMAIL PROTECTED]> wrote: > If i follow your saying, it would be best to create a new table when i > encounter a new file-structure scheme, but keep a general purpose table with > minimal and univeral information. Just to clarify, for simple key-va

Re: [sqlite] Newbie sqlite questions: check existence of column

2006-11-14 Thread Florent THIERY
If i follow your saying, it would be best to create a new table when i encounter a new file-structure scheme, but keep a general purpose table with minimal and univeral information. That's a great idea :) Thanks It allows me to distinguish clearly the types of organization. Will require more sql

Re: [sqlite] Newbie sqlite questions: check existence of column

2006-11-14 Thread Florent THIERY
s Regards Florent On 11/14/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote: On 11/13/06, Florent THIERY <[EMAIL PROTECTED]> wrote: > - check first if the column already exists; that, i have no idea how to > achieve it Hello Florent, Try this: select * from sqlite_master; This gives a l

Re: [sqlite] Re: Newbie sqlite questions: check existence of column

2006-11-13 Thread Florent THIERY
Thanks for this quick reply :) On 11/13/06, Igor Tandetnik <[EMAIL PROTECTED]> wrote: Florent THIERY <[EMAIL PROTECTED]> wrote: > Some files have optional fields, so what i'd like to do is, whenever > such a file is scanned and parsed, i want my software to > -

[sqlite] Re: Newbie sqlite questions: check existence of column

2006-11-13 Thread Florent THIERY
I'd add : python import sqlite sqlite.version '1.0.1'

[sqlite] Newbie sqlite questions: check existence of column

2006-11-13 Thread Florent THIERY
Hi First of all i must say i'm pretty much impressed of how easy it is to buid a sqlite db up within minutes/hours of work. I'm... amazed :) Still, i'm lacking answears. My (soon-to-be-open-source-when-there-will-be-interesting-source-to-open) project is the following: i scan for files recursi