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() trans1['InvoiceNo']=1234