I have the following three tables and trying to do a join. See below for
details:
g_main (
gene_id serial primary key,
.....
);
g_refseq (
refseq varchar references refseq(refseq),
gene_id int references g_main(gene_id)
);
refseq (
refseq varchar primary key
);
from sqlalchemy.ext.sqlsoup import SqlSoup
db = SqlSoup('postgres://user:[EMAIL PROTECTED]/annodb4')
genes = db.g_main.select_by(symbol='ADAM12')
len(genes)
2
refseqs = db.g_refseq.select_by(gene_id=672)
len(refseqs)
13
join1 = db.join(db.g_main,db.g_refseq)
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "build/bdist.linux-x86_64/egg/sqlalchemy/ext/sqlsoup.py", line 410, in
join
File "build/bdist.linux-x86_64/egg/sqlalchemy/ext/sqlsoup.py", line 402, in
map
File "build/bdist.linux-x86_64/egg/sqlalchemy/ext/sqlsoup.py", line 369, in
class_for_table
File "build/bdist.linux-x86_64/egg/sqlalchemy/orm/query.py", line 19, in
__init__
File "build/bdist.linux-x86_64/egg/sqlalchemy/orm/mapper.py", line 252, in
compile
File "build/bdist.linux-x86_64/egg/sqlalchemy/orm/mapper.py", line 270, in
_compile_all
File "build/bdist.linux-x86_64/egg/sqlalchemy/orm/mapper.py", line 497, in
_initialize_properties
AttributeError: 'Mapper' object has no attribute '_Mapper__props'
I am using:
SQLAlchemy-0.3.3-py2.5.egg
Any suggestions on what I am missing?
Thanks,
Sean
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
