Thread: [SQLObject] More connections for more tables

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Hello is it possible to set a specific connections database for each class?

because i have 2 class and one of them is temporary so i would like to use
sqlite in memory.

From: Visgean Skeloru <vi...@gm...>
To: sql...@li...
Date: Tuesday 13 April 2010
> Hello is it possible to set a specific connections database for each class?
> 
> because i have 2 class and one of them is temporary so i would like to use
> sqlite in memory.

Yes, it's possible. One way is to pass a connection parameter at class 
creation (that's at least the way I do it). This may look like:

from sqlobject import SQLObject, connectionForURI

class AnObject(SQLObject):
	one_attr = StringCol()

con = connectionForURI("sqlite:/:memory:")
obj = AnObject(one_attr="one attr", connection=con)

 The other way is defining the _connection attribute on the class definition. I 
have never tried it but from reading the doc I think I remember it quite like 
this:

con = connectionForURI("sqlite:/:memory:")

class AnObject(SQLObject)
	one_attr = StringCol()
	_connection = con

With the first one you have to keep in mind to pass the connection parameters 
in later operations, such as select (again, that's at least the way I do it). 
I have never fiddled with the second one, so I can't provide some experience on 
the matter.

Please do post your results :)

Cheers
Juan Manuel Santos

On Tue, Apr 13, 2010 at 11:49:47PM +0200, Visgean Skeloru wrote:
> Hello is it possible to set a specific connections database for each class?

   Yes. Every SQLObject class has a classmethod setConnection. Call it
MyTable.setConnection(connection); connection can be a string or an open
connection (SQLObject's DBConnection, not a Python DB API connection).
   Every method has a connection parameter.

Oleg.
-- 
     Oleg Broytman            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.

On 14 April 2010 12:11, Oleg Broytman <ph...@ph...> wrote:

> On Tue, Apr 13, 2010 at 11:49:47PM +0200, Visgean Skeloru wrote:
> > Hello is it possible to set a specific connections database for each
> class?
>
>   Yes. Every SQLObject class has a classmethod setConnection. Call it
> MyTable.setConnection(connection); connection can be a string or an open
> connection (SQLObject's DBConnection, not a Python DB API connection).
>   Every method has a connection parameter.
>
> Or you can define your connection directly in the Class as an attribute,
for example:

_connection = connectionRAMdisk

I do not know, if this is the cleanest way, but works great.

Petr

>
> By the way: How are you solving problem with new creating new database? I
> mean do you check if the table exist? Because I am using this code:
>
> try:
>     alreadyUsed.createTable()
>     Pathject.createTable()
>     print "I couldn´t find any table so I h´ve created one!"
>
> except dberrors.OperationalError:
>     pass
>
> But I think it´s a dirty...  And one more thing: it would be nice if there
> was some direct link to http://wiki.sqlobject.org/ from
> http://www.sqlobject.org/ because on wiki are really useful information...
>
>
>
>
   1. do not top post, please

   2. try to reply/send to sql...@li... instead
   of the direct mail

   3. maybe you are looking for this:

   Pathject.dropTable(ifExists=True), Pathject.createTable(ifNotExists=True)

HTH

Petr

Thread: [SQLObject] More connections for more tables

SQLObject is a Python ORM.

sqlobject-discuss