Hi Dan This is a little "off topic" for this group, however, I consider myself a "specialist" in the area you question, so I'm delighted to be on the "helping" end for a change :-)
We can continue this one-on-one outside the group. Send your questions to me. I prefer Skype for this type of thing - see my Skype id below. Cheers Warwick Warwick Prince CEO mobile: +61 411 026 992 skype: warwickprince phone: +61 7 3102 3730 fax: +61 7 3319 6734 web: www.mushroomsys.com On 29/10/2010, at 8:12 PM, Dan @ Austria wrote: > Hi, > > i have a question to database/design specialist. How can (should!) i > implement a stock management system in sql-alchemy and python? I get > the following data from another system via files > > - movements: bills from a scanner at a cash deck > - movements: from goods-receipt > > Of course i have also master data on an per article basis. > > What i want do is keep charge of the stock available in our warehouse. > Should i built a warehouse table with > [ article / amount of article available ] > > and update the articles with an update statement like UPDATE > warehouse_table SET amount = amount - (bill amount) where article = > bill_article ? Would that be a good solution? > > Is there any literature or reference implementations around? Any hint > is much apreciated. Although i have written a couple of database > applications, i never had the probleme to change a field (amount field > per article) so often. I guess there is a lot of data comming in ... > > Thanks in advance, > Dan > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to sqlalch...@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. > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@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.