I have tables which linked as a one to many relationship:
user ---(one to many)---> order --(many to one)-->product
Product has been populated and served as a lookup table.
class User:
member_id
purchase_total
order = relationship(Order....)
def add_product(self, orderObj):
session = DBSession()
session.add(orderObj)
session.flush()
self.purchase_total += orderObj.product.price
self.order.append(orderObj)
transaction.commit()
class Product:
product_id
price
class Order:
order_id
product_id (FK)
member_id (FK)
product = relationship(Product.....)
# user purchasing product
user = session.query(User).get(id)
newOrder = Order()
newOrder.product_id = 1
user.add_product(newOrder)
I'm wondering if the above coding is safe in a multi-thread
application such as web app. Especially for the flush and session
method.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
