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
