Hello,

I'm trying to create a simple warehouse app on GAE, but I'm stuck with the design of my models.

Here are my thoughts about the design:
 Inventory -> Goods (id, quantity, prices and etc) -> Groups
 Customer (id,name) -> Order(Date) -> OrderItem(GoodId, price, quantity)

Operation: Order single item

In this case when new sale is performed a new record need to be added to the Order table and after that inventory table need to be updated too. And here is the problem, on GAE transactions can be applied only on a single entity group where in this case I have 2 different entity groups and I need to update both of them.

Other operations: View Customer Orders for a period, View Quantity of a given Good, View Goods of a given group with quantity lower then specified value

Any idea how to handle this?


Regards,
 Miroslav
-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine for Java" 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/google-appengine-java?hl=en.


Reply via email to