Re: custom class name

On Sun, Feb 05, 2017 at 07:16:48PM +0100, janemba <[email protected]> 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) 
)

> Cheers,

Oleg.
-- 
     Oleg Broytman            http://phdru.name/            [email protected]
           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