Re: [SQLObject] ForeignKey not using the right column name on request

[Oleg B. <ph...@ph...>]

Hi!

On Tue, Feb 07, 2017 at 12:34:36AM +0100, janemba <cap...@gm...> wrote:
> Hi,
> 
> I'm experiencing an issue with ForeignKey. First of all, all my primary
> keys use idName attribute as classes use a different name. So I built
> the following classes :
> 
> ------
> 
> class User(sqlobject.SQLObject):
> 
>     class sqlmeta:
>         table  = 'tbl_user'
>         idName = 'user_id'
>         idType = int

   By default idType is int so you don't need it. But you can do it if
you want to be extra explicit.

>     user_firstname  = sqlobject.StringCol(length=45)
>     user_lastname   = sqlobject.StringCol(length=45)
>     user_email      = sqlobject.StringCol(length=45)
>     user_phone      = sqlobject.StringCol(length=20)
>     user_password   = sqlobject.StringCol(length=128)
>     user_city       = sqlobject.StringCol(length=45)
>     user_country    = sqlobject.StringCol(length=45)

   Please remove anything that's not related to your question. Too much
information could be worse than too little.

>     user_section  = sqlobject.ForeignKey('Section')
> 
> class Section(sqlobject.SQLObject):
> 
>     class sqlmeta:
>         table  = 'tbl_section'
>         idName = 'section_id'
>         idType = int
> 
>         section_name = sqlobject.StringCol(length=128)
> 
> ------
> 
> 
> And then the debug output :
> 
>  1/QueryOne:  SELECT user_firstname, user_lastname, user_email,
> user_phone, user_password, user_city, user_country, user_section_id FROM
> tbl_user WHERE ((tbl_user.user_id) = (1))
> 
> As you can see the column "user_section_id" has been generated by
> SQLObject. But that column doesn't exists. It should be "user_section"
> from table "tbl_user". I tried with the attribute "name" with ForeignKey
> method but the requests remain the same.
> 
> Do you know how to fix that ?

   'name' in SQLObject is a pythonic name of column; if you want to
provide a database name it's called 'dbName':

class User(sqlobject.SQLObject):

    class sqlmeta:
        table  = 'tbl_user'
        idName = 'user_id'

    user_section = sqlobject.ForeignKey('Section', dbName='user_section')

   Also you have to know that translation from names to dbName's is
performed by an instance of Style. See styles.py and
tests/test_style.py. If you don't want to submit to default SQLObject
style (which, among other things, adds '_id' to ForeignKey's) and don't
want to provide dbName for every column you can create your own Style
and override the default.

> Cheers,

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