SQLObject

On Thu, Mar 23, 2006 at 06:43:40PM +0100, Felix wrote:
> class tableAtDB(sqlobject.SQLObject):
>         def __init__(self, connection, tableFromDB):
>                 self._connection = connection
>                 class sqlmeta:
>                         table = tablaFromDB
> 			#print table
>                         fromDatabase = True

   sqlmeta must be defined at the class level:

class tableAtDB(sqlobject.SQLObject):
       class sqlmeta:
               table = "table_name"
               fromDatabase = True

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            phd@...
           Programmers don't die, they just GOSUB without RETURN.

On Thu, 23 Mar 2006 20:56:26 +0300
Oleg Broytmann <phd@...> wrote:

> On Thu, Mar 23, 2006 at 06:43:40PM +0100, Felix wrote:
> > class tableAtDB(sqlobject.SQLObject):
> >         def __init__(self, connection, tableFromDB):
> >                 self._connection = connection
> >                 class sqlmeta:
> >                         table = tablaFromDB
> > 			#print table
> >                         fromDatabase = True
> 
>    sqlmeta must be defined at the class level:
> 
> class tableAtDB(sqlobject.SQLObject):
>        class sqlmeta:
>                table = "table_name"
>                fromDatabase = True
> 
> Oleg.

class tablaBD(sqlobject.SQLObject):
        def __init__(self, conexion, tabla):
                SQLObject.__init__(self)
                self._connection = conexion
                self.tabla = tabla
        class sqlmeta:
                table = self.tabla
                fromDatabase = True

Then i try like upthere. but sqlmeta don't knows about "self". How can i do it ?

On Thu, Mar 23, 2006 at 07:09:14PM +0100, Felix wrote:
> sqlmeta don't knows about "self". How can i do it ?

   You cannot.

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            phd@...
           Programmers don't die, they just GOSUB without RETURN.

On Thu, 23 Mar 2006 21:20:48 +0300
Oleg Broytmann <phd@...> wrote:

Well, but must be a way to pass parameters to sqlmeta attributes, isn't??

Felix wrote:
> On Thu, 23 Mar 2006 20:56:26 +0300
> Oleg Broytmann <phd@...> wrote:
> 
>> On Thu, Mar 23, 2006 at 06:43:40PM +0100, Felix wrote:
>>> class tableAtDB(sqlobject.SQLObject):
>>>         def __init__(self, connection, tableFromDB):
>>>                 self._connection = connection
>>>                 class sqlmeta:
>>>                         table = tablaFromDB
>>> 			#print table
>>>                         fromDatabase = True
>>    sqlmeta must be defined at the class level:
>>
>> class tableAtDB(sqlobject.SQLObject):
>>        class sqlmeta:
>>                table = "table_name"
>>                fromDatabase = True
>>
>> Oleg.
> 
> class tablaBD(sqlobject.SQLObject):
>         def __init__(self, conexion, tabla):
>                 SQLObject.__init__(self)
>                 self._connection = conexion
>                 self.tabla = tabla
>         class sqlmeta:
>                 table = self.tabla
>                 fromDatabase = True
> 
> Then i try like upthere. but sqlmeta don't knows about "self". How can i do it ?
class tablaBD(sqlobject.SQLObject):
        class sqlmeta:
                table = self.tabla
                fromDatabase = True
        def __init__(self, conexion, tabla):
                SQLObject.__init__(self)
                self._connection = conexion
                self.sqlmeta.table = tabla

At least Python accepts this, dunno if SQLObject accepts it.

> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting language
> that extends applications into web and mobile media. Attend the live webcast
> and join the prime developer group breaking into this new coding territory!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642


-- 

---------------------------------------------------
Jürgen Kartnaller   mailto:juergen_at_kartnaller.at
                    http://www.kartnaller.at
                    http://www.mcb-bregenz.at
---------------------------------------------------

On Thu, 23 Mar 2006 19:46:08 +0100
j=FCrgen Kartnaller <juergen@...> wrote:

> class tablaBD(sqlobject.SQLObject):
>         class sqlmeta:
>                 table =3D self.tabla
>                 fromDatabase =3D True
>         def __init__(self, conexion, tabla):
>                 SQLObject.__init__(self)
>                 self._connection =3D conexion
>                 self.sqlmeta.table =3D tabla
>=20
> At least Python accepts this, dunno if SQLObject accepts it.

Thanks but no success: sqlmeta dont know about self.tabla
but i tried:

class tablaBD(sqlobject.SQLObject):
        def __init__(self, conexion, tabla):
                sqlobject.SQLObject.__init__(self)
                self._connection =3D conexion
                self.sqlmeta.table =3D tabla

And it's no python problem but sqlobject:

Traceback (most recent call last):
  File "conexionBD2.py", line 31, in ?
    tabla =3D tablaBD(manejador.connection, manejador.tabla)
  File "conexionBD2.py", line 24, in __init__
    sqlobject.SQLObject.__init__(self)
  File "/usr/lib/python2.3/site-packages/SQLObject-0.7.0-py2.3.egg/sqlobjec=
t/main.py", line 1183, in __init__
    self._create(id, **kw)
  File "/usr/lib/python2.3/site-packages/SQLObject-0.7.0-py2.3.egg/sqlobjec=
t/main.py", line 1210, in _create
    self._SO_finishCreate(id)
  File "/usr/lib/python2.3/site-packages/SQLObject-0.7.0-py2.3.egg/sqlobjec=
t/main.py", line 1233, in _SO_finishCreate
    id =3D self._connection.queryInsertID(self,
  File "/usr/lib/python2.3/site-packages/SQLObject-0.7.0-py2.3.egg/sqlobjec=
t/dbconnection.py", line 848, in __get__
    return self.getConnection()
  File "/usr/lib/python2.3/site-packages/SQLObject-0.7.0-py2.3.egg/sqlobjec=
t/dbconnection.py", line 860, in getConnection
    raise AttributeError(
AttributeError: No connection has been defined for this thread or process

On Thu, Mar 23, 2006 at 07:29:12PM +0100, Felix wrote:
> Well, but must be a way to pass parameters to sqlmeta attributes, isn't??

def makeTable(name):
   class Table(SQLObject):
      class sqlmeta:
         table = name

atable = makeTable("test")

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            phd@...
           Programmers don't die, they just GOSUB without RETURN.

In SQLObject, a class is a table, an instance is a row of that table. You
appear to be confusing object initialization with class initialization -
things in sqlmeta apply to how the class is defined, basically happens at
import time. __init__ is not called until you try to create an instance of =
the
class.

I'm not entirely sure what your end goal is here, maybe you could 
describe what
you're trying to accomplish as opposed to how you're trying to accomplish i=
t?

- Luke

Quoting Felix <felixonta@...>:

> On Thu, 23 Mar 2006 19:46:08 +0100
> j=FCrgen Kartnaller <juergen@...> wrote:
>
>> class tablaBD(sqlobject.SQLObject):
>>         class sqlmeta:
>>                 table =3D self.tabla
>>                 fromDatabase =3D True
>>         def __init__(self, conexion, tabla):
>>                 SQLObject.__init__(self)
>>                 self._connection =3D conexion
>>                 self.sqlmeta.table =3D tabla
>>
>> At least Python accepts this, dunno if SQLObject accepts it.
>
> Thanks but no success: sqlmeta dont know about self.tabla
> but i tried:
>
> class tablaBD(sqlobject.SQLObject):
>         def __init__(self, conexion, tabla):
>                 sqlobject.SQLObject.__init__(self)
>                 self._connection =3D conexion
>                 self.sqlmeta.table =3D tabla
>
> And it's no python problem but sqlobject:
>
> Traceback (most recent call last):
>   File "conexionBD2.py", line 31, in ?
>     tabla =3D tablaBD(manejador.connection, manejador.tabla)
>   File "conexionBD2.py", line 24, in __init__
>     sqlobject.SQLObject.__init__(self)
>   File 
> "/usr/lib/python2.3/site-packages/SQLObject-0.7.0-py2.3.egg/sqlobject/mai=
n.py", line 1183, in 
> __init__
>     self._create(id, **kw)
>   File 
> "/usr/lib/python2.3/site-packages/SQLObject-0.7.0-py2.3.egg/sqlobject/mai=
n.py", line 1210, in 
> _create
>     self._SO_finishCreate(id)
>   File 
> "/usr/lib/python2.3/site-packages/SQLObject-0.7.0-py2.3.egg/sqlobject/mai=
n.py", line 1233, in 
> _SO_finishCreate
>     id =3D self._connection.queryInsertID(self,
>   File 
> "/usr/lib/python2.3/site-packages/SQLObject-0.7.0-py2.3.egg/sqlobject/dbc=
onnection.py", line 848, in 
> __get__
>     return self.getConnection()
>   File 
> "/usr/lib/python2.3/site-packages/SQLObject-0.7.0-py2.3.egg/sqlobject/dbc=
onnection.py", line 860, in 
> getConnection
>     raise AttributeError(
> AttributeError: No connection has been defined for this thread or process
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting langua=
ge
> that extends applications into web and mobile media. Attend the live webc=
ast
> and join the prime developer group breaking into this new coding territor=
y!
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=110944&bid$1720&dat=121642
> _______________________________________________
> sqlobject-discuss mailing list
> sqlobject-discuss@...
> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
>



--
The Pursuit of Counterfactual Histories

On Thu, Mar 23, 2006 at 11:11:38PM +0300, Oleg Broytmann wrote:
> def makeTable(name):
>    class Table(SQLObject):
>       class sqlmeta:
>          table = name
> 
> atable = makeTable("test")

   Oops, forgot to return it:

def makeTable(name):
   class Table(SQLObject):
      class sqlmeta:
         table = name
   return Table

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            phd@...
           Programmers don't die, they just GOSUB without RETURN.

On Thu, 23 Mar 2006 14:15:56 -0600
Luke Opperman <luke@...> wrote:

> In SQLObject, a class is a table, an instance is a row of that table. You
> appear to be confusing object initialization with class initialization -
> things in sqlmeta apply to how the class is defined, basically happens at
> import time. __init__ is not called until you try to create an instance of the
> class.

Yeah Luke, i'm little troubled with instances, objects and class, maybe i need 
to look back to the oop study books ;P. Thanks anyway.

> def makeTable(name):
>    class Table(SQLObject):
>       class sqlmeta:
>          table = name
>    return Table
> 
> Oleg.

Thanks Oleg !!! That was exactly what i was looking for.