sqlobject-discuss

[SQLObject] SQLObject Database connection

[Hong Y. <hon...@ho...>]

I am using SQLObject with a PostgreSQL database. Part of my program uses 
SQLObject to access the database, part of it uses psycopg directly.

The question is, do I have to initiailze two separate database 
connections, one with psycopg.connect for my own code, and another with 
connectionForURI('postgres://...') for use with SQLObject?

Can I create a connectino for SQLObject from an existing psycopg 
connection of vice versa, get an psycopg connection back from an 
SQLObject connection object?

Greetings,

-- 
HONG Yuan
Homemaster Trading Co., Ltd.
No. 601, Bldg. 41, 288 Shuangyang Rd. (N)
Shanghai 200433, P.R.C.
Tel: +86 21 55056553
Fax: +86 21 55067325
E-mail: hon...@ho...

Re: [SQLObject] SQLObject Database connection

[Sam N. <sa...@se...>]

Hong Yuan wrote:
> I am using SQLObject with a PostgreSQL database. Part of my program uses 
> SQLObject to access the database, part of it uses psycopg directly.
> 
> The question is, do I have to initiailze two separate database 
> connections, one with psycopg.connect for my own code, and another with 
> connectionForURI('postgres://...') for use with SQLObject?
> 
> Can I create a connectino for SQLObject from an existing psycopg 
> connection of vice versa, get an psycopg connection back from an 
> SQLObject connection object?
> 
> Greetings,
> 

Here is a simplified version of how I am handling this. If I have an 
SQLObject class called Image then:

sqlstring = "SELECT id FROM imagelist"
imagelist = Image._connection.queryAll(sqlstring)
idlist = [row[0] for row in imagelist]
print "list: ", idlist
return idlist

Good Luck!
- Sam Nilsson

Re: [SQLObject] SQLObject Database connection

[Sam N. <sa...@se...>]

Sam Nilsson wrote:
> Here is a simplified version of how I am handling this. If I have an 
> SQLObject class called Image then:
> 
> sqlstring = "SELECT id FROM imagelist"

sorry, it would probably look more like this:

sqlstring = "SELECT id FROM Image"

- Sam