Re: [SQLObject] Is there a way to configure kinterbasdb (Firebird)?

[Frank Wagner]

i'm using sqlobject happily with interbase 7 via kinterbasdb.though not
directly but together with the turbogears framework.

connection uri is "interbase://user:p...@localhost
:3050//path/to/file.IB?debug=True"
it connects just fine

i then define my classes as usual (already existed in database):

class Teilnehmer(SQLObject):
class sqlmeta:
 #fromDatabase=True # works more or less, but
                                               # there's trouble with string
encodings
 idName="NR"
cacheValues = True
BUCHUNGSNR    = IntCol(dbName="BUCHUNGSNR")
 NAME          = StringCol(length=40, dbName="NAME")
HOTELCODE     = StringCol(length=8, dbName="HOTELCODE")
        ...

finally i need some finetuning as the database doesn't have a charset
defined:
for each attribute/column:
def _get_NAME(self):
 return self._SO_get_NAME() and unicode(self._SO_get_NAME(),
'iso-8859-1').strip() or u''


that's it.
finally u can use all the convenient magic that comes with SQLObj.

hth,
frank




2009/9/16 Petr Jakeš <petr.ja...@tpc.cz>

> Hi,
>
> Working on the Firebird, I just wonder if exists some way how to push
> SQLObjects to configure kinterbasdb.
>
> I mean: I was able to use following snippet when I was working with the
> database directly (using kinterbasdb).
>
> import kinterbasdb
> kinterbasdb.init(type_conv=200)
>
> Is this possible using SQLObjects?
>
> Regards
>
> Petr
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry&reg; Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9&#45;12, 2009. Register now&#33;
> http://p.sf.net/sfu/devconf
> _______________________________________________
> sqlobject-discuss mailing list
> sqlobject-discuss@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
>
>

------------------------------------------------------------------------------
Come build with us! The BlackBerry&reg; Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9&#45;12, 2009. Register now&#33;
http://p.sf.net/sfu/devconf
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss