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
