sqlobject-discuss

[SQLObject] Select does not work with some fieldname

[Wolfgang M. <wol...@gm...>]

Hi,
please help.
how do i this SQL
SELECT *
FROM `TAthlet`
WHERE TCountry_id = 'AUT'

The table "TAthlet" have this fields:
TUnion_id
id
short
name
TGender_id
TGoup_id
TCountry_id

This does not work:
from sqlobject import *
sqlhub.processConnection =
connectionForURI('mysql://archer:xxxxxx@localhost/adb')

class TAthlet(SQLObject):
    class sqlmeta:
        #if i dont do this i get a wrong tathlet table
        table = "TAthlet"
        fromDatabase = True

TAthlet._connection.debug = True
r = TAthlet.select(TAthlet.q.Tcountry_id=='AUT')

The Error:
AttributeError: TAthlet instance has no attribute 'Tcountry_id'

Thanks
Wolfgang Morawetz

Re: [SQLObject] Select does not work with some fieldname

[Petr J. <pet...@tp...>]

> please help.
> how do i this SQL
> SELECT *
> FROM `TAthlet`
> WHERE TCountry_id = 'AUT'
>
> The table "TAthlet" have this fields:
> TUnion_id
> id
> short
> name
> TGender_id
> TGoup_id
> TCountry_id
>
> This does not work:
> from sqlobject import *
> sqlhub.processConnection =
> connectionForURI('mysql://archer:xxxxxx@localhost/adb')
>
> class TAthlet(SQLObject):
>    class sqlmeta:
>        #if i dont do this i get a wrong tathlet table
>        table = "TAthlet"
>        fromDatabase = True
>
> TAthlet._connection.debug = True
> r = TAthlet.select(TAthlet.q.Tcountry_id=='AUT')
>
> The Error:
> AttributeError: TAthlet instance has no attribute 'Tcountry_id'
>

what about:
r = TAthlet.select(TAthlet.q.TcountryId=='AUT')

Petr

Re: [SQLObject] Select does not work with some fieldname

[Petr J. <pet...@tp...>]

2009/11/10 Wolfgang Morawetz <wol...@gm...>

> Petr Jakeš schrieb:
> >
> >     Maybe you can printout the names SQLObject reads from the database
> >     and than use this names:
> >     for col in TCountry.sqlmeta.columnList:
> >         print col
> >
> > Or maybe:
> >
> > print col.origName, col.dbName
> >
> > Petr
> >
> Hmmm,
> for TAthlet i get:
> TUnionID TUnion_id
> short short
> name name
> TGenderID TGender_id
> TGroupID TGroup_id
> TCountryID TCountry_id
>
> and for TCountry:
> name name
>
> So SQLObject removes the underline ok, but i get no id fields?
>
> BTW Thanks for helping Petr!
>

You can define (name) existing columns (names) explicitly. Even existing ID
column. I am using existing database as well and I am connecting to it this
way:

class Cenktgm01(SQLObject):
#    _connection = connection
    class sqlmeta:
        idType = str
        idName = 'OID$CENKTGM01'
    ktgi = StringCol(dbName="ktginterni")

BTW, you do not need to know about the id. SQLObject is treating id
automatically beneath the scene.

Sometime wiki can help: http://wiki.sqlobject.org/
I am experimenting with the SQLite inMemory database a lot as well (as shown
in following exampe).

from sqlobject import *
connectionInMemory = connectionForURI('sqlite:/:memory:')
class Person(SQLObject):
    _connection = connectionInMemory
    firstName = StringCol()
    middleInitial = StringCol(length=1, default=None)
    lastName = StringCol()

Regards

Petr

PS: please try to "reply to all", so other peeople in the mailing list can
help/comment as well.