if __name__ == "__main__": import sys try: conn = MySQLdb.connect (host = "localhost", user = "******", db = "test") except MySQLdb.Error, e: print "Error %d: %s" % (e.args[0], e.args[1]) sys.exit (1) try: conn.cursor().execute("DROP TABLE IF EXISTS ContractedTransactions"); conn.cursor().execute("DROP TABLE IF EXISTS ContractedItems"); conn.cursor().execute("DROP TABLE IF EXISTS Invoices"); from PurchaseOrderList import PurchaseOrderList list=PurchaseOrderList(conn) contract1=list.add({'PlanningItemId':1, 'PurchaseOrder':1234, 'ContractorId':23, 'StartDate':"3/4/89", 'EndDate':"3/4/99"}); contract2=list.add({'PlanningItemId':2, 'PurchaseOrder':5477, 'ContractorId':23, 'StartDate':"3/4/89", 'EndDate':"3/4/99"}); def ap(d,v): d.update(v) return d tc=HarvesterTransactionCreator(conn) trans1=tc.createtransaction(ap(contract1,{'QtyCompleted':12, 'CompletionDate':30-12-2004, 'PurchaseOrder':1234})) tc.createtransaction(ap(contract1,{'QtyCompleted':34000, 'CompletionDate':30-1-2003, 'PurchaseOrder':1234})) tc.createtransaction(ap(contract2,{'QtyCompleted':237, 'CompletionDate':30-12-2005, 'PurchaseOrder':3456})) tc.createtransaction(ap(contract2,{'QtyCompleted':786, 'CompletionDate':02-12-2004, 'ContractedUnitPrice':12.99, 'PurchaseOrder':5678})) print tc.get()
from PlanningList import PlanningList,planninglistitems_generator planlist=PlanningList(conn) planlist.add(join(planninglistitems_generator(conn)[0],{'Quantity':12, 'EstPrice':100}) ); planlist.add(join(planninglistitems_generator(conn)[1],{'Quantity':12, 'EstPrice':100}) ); planlist.add(join(planninglistitems_generator(conn)[3],{'Quantity':32, 'EstPrice':100}) ); planlist.add(planninglistitems_generator(conn)[3] ); from ContractorCreator import ContractorCreator cc=ContractorCreator(conn) con_d=cc.add({'Name':"Dave's Dodgy Dealings"}) con_k=cc.add({'Name':"Kevin's Krazy Kontracting"}) con_s=cc.add({'Name':"Steve's Shifty Silviculture",'CUIT':'0123456789ABCDEF'}) from PurchaseOrderList import PurchaseOrderList polist=PurchaseOrderList(conn) if polist.addpurchaseorder({'PurchaseOrder':2342, 'ContractorId':23, 'StartDate':"3/4/89", 'EndDate':"3/4/99",'PropId':07, 'TaskGroupId':1}): for i in planlist.get(): polist.addpurchaseorderitem(join(con_d, {'PlanningItemId':i['PlanningItemId'], 'PurchaseOrder':2342, 'StartDate':"3/4/89", 'EndDate':"3/4/99"})); else: print "add failed for purchase order 2342" sys.exit(1) if polist.addpurchaseorder({'PurchaseOrder':1234, 'ContractorId':23, 'StartDate':"3/4/89", 'EndDate':"3/4/99",'PropId':07, 'TaskGroupId':1}): for i in planlist.get(): polist.addpurchaseorderitem(join(con_d, {'PlanningItemId':i['PlanningItemId'], 'PurchaseOrder':2342, 'StartDate':"3/4/89", 'EndDate':"3/4/99"})); else: print "add failed for purchase order 1234" sys.exit(1) from TransactionCreator import TransactionCreator