Ok,
from sqlalchemy import *
from sqlalchemy.ext.assignmapper import assign_mapper
from sqlalchemy.ext.sessioncontext import SessionContext
meta = DynamicMetaData()
ctx = SessionContext(create_session)
def make_engine(uri=None):
if uri is None:
uri = 'sqlite:///:memory:'
engine = create_engine(uri, echo=True)
return engine
def connect(uri=None):
meta.connect(make_engine(uri=uri))
users_table = Table('user', meta,
Column('id', Integer, autoincrement=True, primary_key=True),
Column('name', String),
Column('password', String),
Column('registration', String),
)
class User(object):
"""User"""
def get_is_admin(self):
return self.id == 1
is_admin = property(get_is_admin)
def __str__(self):
s = self.name
if self.registration:
s = '%s (%s)' % (s, self.registration)
return s
assign_mapper(ctx, User, users_table)
stockreceipt_table = Table('stockreceipt', meta,
Column('id', Integer, autoincrement=True, primary_key=True),
Column('drug_id', Integer, ForeignKey('drug.id')),
Column('date', Date),
Column('quantity', Integer),
Column('supplier_id', Integer, ForeignKey('supplier.id')),
Column('user_id', Integer, ForeignKey('user.id')),
Column('cancelled', Boolean),
Column('cancelled_reason', String),
Column('cancelled_user_id', Integer, ForeignKey('user.id')),
Column('internal_transfer', Boolean),
Column('invoice_number', String),
Column('internal_from', String),
)
class Receipt(object):
"""Stock Receipt"""
def get_cancelled_user_hack(self):
return User.get_by(id=self.cancelled_user_id)
cancelled_user_hack = property(get_cancelled_user_hack)
assign_mapper(ctx, Receipt, stockreceipt_table,
properties=dict(
user=relation(User, backref='receipts',
primaryjoin=stockreceipt_table.c.user_id ==
users_table.c.id),
cancelled_user=relation(User, backref='cancelled_receipts',
lazy=False,
primaryjoin=stockreceipt_table.c.cancelled_user_id ==
users_table.c.id),
supplier=relation(Supplier, backref='receipts'),
drug=relation(Drug, backref='receipts'),
)
)
meta.create_all()
connect()
>>> u = User(name='Ali')
>>> u.flush()
>>> r = Receipt(user_id=u.id)
>>> r.flush()
>>> r.user is u
True
>>> r.cancelled_user_id = u.id
>>> r.flush()
>>> r.cancelled_user is u
True
Now, as I mentioned, r.cancelled_user is set correctly in this
example, but not (always) in my application, although it is used
similarly. (I am happy to paste 2000 lines of PyGTK if you like). When
the attribute is accessed, there is no SQL output at all, although in
this example there is.
Thanks for any assistance,
Ali
On Feb 20, 6:04 pm, "Michael Bayer" <[EMAIL PROTECTED]> wrote:
> why dont you attach a script that runs completely ? use a "sqlite://"
> database.
>
> On Feb 20, 12:14 pm, "Ali" <[EMAIL PROTECTED]> wrote:
>
> > By "both", I mean user and receipt tables
>
> > On 20 Feb, 17:12, "Ali" <[EMAIL PROTECTED]> wrote:
>
> > > I left out the fields for brevity of example. They both have an id
> > > column defined as primary keys.
>
> > > On 20 Feb, 17:11, "Michael Bayer" <[EMAIL PROTECTED]> wrote:
>
> > > > On Feb 20, 12:01 pm, "Ali" <[EMAIL PROTECTED]> wrote:
>
> > > > > Here is my code (with other fields removed):
>
> > > > > stockreceipt_table = Table('stockreceipt', meta,
> > > > > Column('user_id', Integer, ForeignKey('user.id')),
> > > > > # Cancellation
> > > > > Column('cancelled_user_id', Integer, ForeignKey('user.id')),
> > > > > )
>
> > > > > class Receipt(object):
> > > > > """Stock Receipt"""
>
> > > > > assign_mapper(ctx, Receipt, stockreceipt_table,
> > > > > properties=dict(
> > > > > user=relation(User, backref='receipts',
> > > > > primaryjoin=stockreceipt_table.c.user_id ==
> > > > > users_table.c.id),
> > > > > cancelled_user=relation(User, backref='cancelled_receipts',
> > > > > lazy=False,
> > > > > primaryjoin=stockreceipt_table.c.cancelled_user_id ==
> > > > > users_table.c.id),
> > > > > )
>
> > > > that cant be right, since theres no primary key expressed either in
> > > > the stockreceipt_table or in your Receipt mapper.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
