Hello all,
I am trying to run the following code:
#!/usr/bin/env python2.4
#
# Problem with ForeignKey??
#
from sqlobject import *
import os
class A( SQLObject ):
class sqlmeta:
table = 'A'
idName = 'a_id'
aName = StringCol( length=25, dbName='a_name', default='A Name' )
class B( SQLObject ):
class sqlmeta:
table = 'B'
idName = 'b_id'
bAfk = ForeignKey( 'A', dbName='b_afk', default=None )
bName = StringCol( length=25, dbName='b_name', default='B Name' )
bDesc = StringCol( length=25, dbName='b_desc', default='B Desc' )
def __str__( self ):
return self.bName + ' ' + self.bDesc
if __name__ == '__main__':
sqlhub.processConnection = connectionForURI( 'sqlite:%
s/proj/src/sqlobject/test.db' % os.environ['HOME'] )
a = A.selectBy( aName='AObject1' )[0]
bs = B.select( B.q.bAfk == a )
print bs
#for b in bs:
# print b
But I am getting the following error:
[EMAIL PROTECTED] [sqlobject]$ ./SqlTest.py
Traceback (most recent call last):
File "./SqlTest.py", line 31, in ?
bs = B.select( B.q.bAfk == a )
File
"/usr/lib/python2.4/site-packages/SQLObject-0.7rc1-py2.4.egg/sqlobject/sqlbuilder.py",
line 360, in __getattr__
self.soClass.sqlmeta.columns[attr].dbName,
KeyError: 'bAfk'
With the following DB schema:
CREATE TABLE A (
a_id INTEGER PRIMARY KEY,
a_name VARCHAR(25)
);
CREATE TABLE B (
b_id INTEGER PRIMARY KEY,
b_afk INTEGER, -- Foreign Key
b_name VARCHAR(25),
b_desc VARCHAR(25)
);
INSERT INTO A VALUES( 1, 'AObject1' );
INSERT INTO A VALUES( 2, 'AObject2' );
INSERT INTO B VALUES( 1, 1, 'BObject1', '1 desc' );
INSERT INTO B VALUES( 2, 1, 'BObject2', '2 desc' );
INSERT INTO B VALUES( 3, 1, 'BOBJECT3', '3 desc' );
Any Ideas??
Thanks,
Chuck
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
