Some of the code got cut off. Here is the full version.
Here is the start of data.py from sqlalchemy import create_engine from zope.sqlalchemy import ZopeTransactionExtension from sqlalchemy.orm import ( scoped_session, sessionmaker, ) from sqlalchemy.ext.declarative import declarative_base session = scoped_session(sessionmaker(extension=ZopeTransactionExtension())) Base = declarative_base() from deal import Deal and here is Deal.py from sqlalchemy import ( ForeignKey, Column, String, Integer, Text, Date, Float, ) from sqlalchemy.orm import ( backref, relationship, ) from data import Base class Deal(Base): # Define class On Saturday, March 9, 2013 6:37:12 PM UTC, Brendan Condon wrote: > > Everything was working fine, but I started to get this error when I run > deal.py: > > :\Python27\lib\site-packages\sqlalchemy\ext\declarative.py:1343: > SAWarning: The classname 'Deal' is already in the registry of this > declarative base, mapped to <class 'plexus.cfm.deal.Deal'> > _as_declarative(cls, classname, cls.__dict__) > Traceback (most recent call last): > File "<stdin>", line 1, in <module> > File > "C:\Python27\lib\site-packages\spyderlib\widgets\externalshell\sitecustomize.py", > > line 487, in runfile > execfile(filename, namespace) > File "C:\env\plexus\plexus\cfm\deal.py", line 33, in <module> > class Deal(Base): > File "C:\Python27\lib\site-packages\sqlalchemy\ext\declarative.py", line > 1343, in __init__ > _as_declarative(cls, classname, cls.__dict__) > File "C:\Python27\lib\site-packages\sqlalchemy\ext\declarative.py", line > 1244, in _as_declarative > **table_kw) > File "C:\Python27\lib\site-packages\sqlalchemy\schema.py", line 305, in > __new__ > "existing Table object." % key) > sqlalchemy.exc.InvalidRequestError: Table 'deal' is already defined for > this MetaData instance. Specify 'extend_existing=True' to redefine options > and columns on an existing Table object. > > I have two modeles data.py and deal.py. I use data.py to run my queries > and define the declarative_base. There are other models that import it, so > I decided to keep it in a central place. > > Here is the start of data.py > > from sqlalchemy import create_engine > > from zope.sqlalchemy import ZopeTransactionExtension > > > from sqlalchemy.orm import ( > > scoped_session, > > sessionmaker, > > ) > > > from sqlalchemy.ext.declarative import declarative_base > > > from deal import Deal > > > and here is Deal.py > > > from sqlalchemy import ( > > ForeignKey, > > Column, > > String, > > Integer, > > Text, > > Date, > > Float, > > ) > > > from sqlalchemy.orm import ( > > backref, > > relationship, > > ) > > > from plexus.cfm.data import Base > > > class Deal(Base): > > # Define class > > > I really appreciate any help. > > > Thanks, > > On Saturday, March 9, 2013 6:37:12 PM UTC, Brendan Condon wrote: > > Everything was working fine, but I started to get this error when I run > deal.py: > > :\Python27\lib\site-packages\sqlalchemy\ext\declarative.py:1343: > SAWarning: The classname 'Deal' is already in the registry of this > declarative base, mapped to <class 'plexus.cfm.deal.Deal'> > _as_declarative(cls, classname, cls.__dict__) > Traceback (most recent call last): > File "<stdin>", line 1, in <module> > File > "C:\Python27\lib\site-packages\spyderlib\widgets\externalshell\sitecustomize.py", > > line 487, in runfile > execfile(filename, namespace) > File "C:\env\plexus\plexus\cfm\deal.py", line 33, in <module> > class Deal(Base): > File "C:\Python27\lib\site-packages\sqlalchemy\ext\declarative.py", line > 1343, in __init__ > _as_declarative(cls, classname, cls.__dict__) > File "C:\Python27\lib\site-packages\sqlalchemy\ext\declarative.py", line > 1244, in _as_declarative > **table_kw) > File "C:\Python27\lib\site-packages\sqlalchemy\schema.py", line 305, in > __new__ > "existing Table object." % key) > sqlalchemy.exc.InvalidRequestError: Table 'deal' is already defined for > this MetaData instance. Specify 'extend_existing=True' to redefine options > and columns on an existing Table object. > > I have two modeles data.py and deal.py. I use data.py to run my queries > and define the declarative_base. There are other models that import it, so > I decided to keep it in a central place. > > Here is the start of data.py > > from sqlalchemy import create_engine > > from zope.sqlalchemy import ZopeTransactionExtension > > > from sqlalchemy.orm import ( > > scoped_session, > > sessionmaker, > > ) > > > from sqlalchemy.ext.declarative import declarative_base > > > from deal import Deal > > > and here is Deal.py > > > from sqlalchemy import ( > > ForeignKey, > > Column, > > String, > > Integer, > > Text, > > Date, > > Float, > > ) > > > from sqlalchemy.orm import ( > > backref, > > relationship, > > ) > > > from plexus.cfm.data import Base > > > class Deal(Base): > > # Define class > > > I really appreciate any help. > > > Thanks, > > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy?hl=en. For more options, visit https://groups.google.com/groups/opt_out.