Please reread carefully all my comments and the code in the previous
message. I already pointed to the root of the problem.
On Sun, Feb 05, 2017 at 09:01:15PM +0100, janemba <cap.jane...@gmail.com> wrote:
> On 02/05/2017 07:43 PM, Oleg Broytman wrote:
> > On Sun, Feb 05, 2017 at 07:16:48PM +0100, janemba <cap.jane...@gmail.com>
> > wrote:
> >> Hi,
> >>
> >> I have an issue with table name. I use my own naming for class name but
> >> it doesn't correspond to the table
> >> name. So, I use sql_meta with table attribute but it doesn't work.
> > sqlmeta, not sql_meta.
> >
> >> I have the following error :
> >>
> >> sqlobject.dberrors.ProgrammingError: Table 'foo.bar' doesn't exist
> >>
> >> Is it possible to use custom class name that do not correspond to table
> >> name ?
> > Works for me. Example:
> >
> > from sqlobject import *
> >
> > __connection__ = "sqlite:/:memory:?debug=1&debugOutput=1"
> >
> > class Person(SQLObject):
> > class sqlmeta:
> > table = 'city_person'
> > name = StringCol()
> > pets = MultipleJoin('Animal', joinColumn='owner_id')
> >
> > class Animal(SQLObject):
> > class sqlmeta:
> > table = 'city_animal'
> > name = StringCol()
> > owner = ForeignKey('Person')
> >
> > Person.createTable()
> > Animal.createTable()
> >
> > Debug output:
> >
> > 1/QueryR : CREATE TABLE city_person (
> > id INTEGER PRIMARY KEY AUTOINCREMENT,
> > name TEXT
> > )
> > 2/QueryR : CREATE TABLE city_animal (
> > id INTEGER PRIMARY KEY AUTOINCREMENT,
> > name TEXT,
> > owner_id INT CONSTRAINT owner_id_exists REFERENCES city_person(id)
> > )
> >
>
> That's strange, here what I do :
>
> class User(sqlobject.SQLObject):
> class sql_meta:
> table = 'tbl_user'
> idName = 'user_id'
> idType = int
>
> 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)
>
> User.get(1)
>
> 1/QueryOne: SELECT user_firstname, user_lastname, user_email,
> user_phone, user_password, user_city, user_country FROM user WHERE
> ((user.id) = (1))
Oleg.
--
Oleg Broytman http://phdru.name/ p...@phdru.name
Programmers don't die, they just GOSUB without RETURN.
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
