[Twisted-Python] DBReflector.loadObjectFrom question

[carball at hush.com]

greetings,

using loadObjectsFrom, it seems the RowClass i am passing in
should have dbColumns with data in it in order to build a
correct sql query. .

where does said data come from?
my dbColumns is just an empty list

also, i dont understand why i have to tell an instantiated
DBReflector what tablename, keys, and RowClass to use again in
loadObjectsFrom?

i apologize if i'm missing something obvious
i've read 'some' T.enterprise code, not enough to
understand it all. .

thanks in advance,
cary

--------------code-----------------------------
#!/usr/bin/env python
from twisted.enterprise import adbapi, row
from twisted.internet import app

class AcctRow( row.RowObject ):
rowColumns = [
'id',
't_id',
'name',
'label'
]
dbKeyColumns = [( 'id', 'int4' )]
def __repr__( self ):
return '%d %s' % ( self.id, self.name )

def refInit( result ):
print 'refInit', result

dbpool = adbapi.ConnectionPool( 'pyPgSQL.PgSQL' )
reflector = row.DBReflector( dbpool,
[( AcctRow,
'acct',
AcctRow.dbKeyColumns )],
refInit )

reflector.loadObjectsFrom( 'acct',
AcctRow.dbKeyColumns,
None,
AcctRow )

application = app.Application('rowTest')
application.run(save=0)

---------------------------
this fails in DBReflector._objectLoader, dbColumns is []??????
i'm using twisted 0.99.0

-----------output------------------
car at platypus car $ ./rowTest.py
Installing SelectReactor, since unspecified.
Connecting to database: pyPgSQL.PgSQL ('',) {}
Enabling Multithreading.
adbapi connecting: pyPgSQL.PgSQL ('',)
Exception in SQL interaction! rolling back...
Traceback (most recent call last):
File '/usr/lib/python2.2/site-packages/twisted/enterprise/adbapi.py', line 154
, in _runInteraction
result = apply(interaction, (trans,)+args, kw)
File '/usr/lib/python2.2/site-packages/twisted/enterprise/row.py', line 245, i
n _objectLoader
transaction.execute(sql)
File '/usr/lib/python2.2/site-packages/pyPgSQL/PgSQL.py', line 2393, in execut
e
adbapi connecting: pyPgSQL.PgSQL ('',)
raise OperationalError, msg
libpq.OperationalError: ERROR: parser: parse error at or near 'FROM'

Traceback (most recent call last):
File '/usr/lib/python2.2/site-packages/twisted/internet/threads.py', line 33,
in _putResultInDeferred
result = apply(f, args, kwargs)
File '/usr/lib/python2.2/site-packages/twisted/enterprise/adbapi.py', line 154
, in _runInteraction
result = apply(interaction, (trans,)+args, kw)
File '/usr/lib/python2.2/site-packages/twisted/enterprise/row.py', line 245, i
n _objectLoader
transaction.execute(sql)
File '/usr/lib/python2.2/site-packages/pyPgSQL/PgSQL.py', line 2393, in execut
e
raise OperationalError, msg
libpq.OperationalError: ERROR: parser: parse error at or near 'FROM'

refInit None
Main loop terminated.





Get your free encrypted email at https://www.hushmail.com