Re: Pysqlite storing file as blob example

2007-07-31 Thread Carsten Haese
On Tue, 2007-07-31 at 00:13 -0700, 7stud wrote: > On Jul 30, 6:25 pm, [EMAIL PROTECTED] wrote: > > I'm trying to store binary data in a sqlite database and call into the > > db using pysqlite 3. > > What I've got so far is this: > > > > import sqlite > > con = sqlite.connect(DB_PATH) > > cur = con.

Re: Pysqlite storing file as blob example

2007-07-31 Thread 7stud
On Jul 30, 6:25 pm, [EMAIL PROTECTED] wrote: > I'm trying to store binary data in a sqlite database and call into the > db using pysqlite 3. > What I've got so far is this: > > import sqlite > con = sqlite.connect(DB_PATH) > cur = con.cursor() > query = """create table t1( > ID INTEGER

Re: Pysqlite storing file as blob example

2007-07-30 Thread Carsten Haese
On Tue, 2007-07-31 at 00:25 +, [EMAIL PROTECTED] wrote: > I'm trying to store binary data in a sqlite database and call into the > db using pysqlite 3. > What I've got so far is this: > > import sqlite > con = sqlite.connect(DB_PATH) > cur = con.cursor()mean > query = """create table t1( >

Pysqlite storing file as blob example

2007-07-30 Thread rustyhowell
I'm trying to store binary data in a sqlite database and call into the db using pysqlite 3. What I've got so far is this: import sqlite con = sqlite.connect(DB_PATH) cur = con.cursor() query = """create table t1( ID INTEGER PRIMARY KEY, dataBLOB );""" cur.execute(query)