#!/bin/env python2
from client import Connection
c = Connection()
response = c.stored_procedure("TPCC-OrderStatus",
"""{ "W_ID": 1, "D_ID": 1, "C_ID": 1}""")
print response
d = Connection()
response = d.stored_procedure(
"TPCC-OrderStatus", """{ "W_ID": 1, "D_ID": 1, "C_LAST": "CLName1"}""")
print response
#!/bin/env python2
from client import Connection
c = Connection()
response = c.stored_procedure("TPCC-StockLevel", """{ "W_ID": 1, "D_ID": 1, "threshold": 35 }""")
print response
#!/bin/env python2
from client import Connection
c = Connection()
response = c.stored_procedure(
"TPCC-Payment",
"""{ "W_ID": 1, "D_ID": 1, "C_W_ID": 1, "C_D_ID": 1, "H_AMOUNT": 150.0, "C_ID": 1 }"""
)
print response
d = Connection()
response = d.stored_procedure(
"TPCC-Payment",
"""{ "W_ID": 1, "D_ID": 1, "C_W_ID": 1, "C_D_ID": 1, "H_AMOUNT": 150.0, "C_LAST": "CLName2" }"""
)
print response
#!/bin/env python2
from client import Connection
c = Connection()
response = c.stored_procedure("TPCC-NewOrder", """{ "W_ID": 1, "D_ID": 1, "C_ID": 1, "O_CARRIER_ID": 5, "OL_DIST_INFO": "lalala", "items": [{"I_ID":1, "I_W_ID": 1, "quantity": 1},
{"I_ID":2, "I_W_ID": 1, "quantity": 1},
{"I_ID":7, "I_W_ID": 1, "quantity": 1},
{"I_ID":11, "I_W_ID": 1, "quantity": 1},
{"I_ID":3, "I_W_ID": 1, "quantity": 1}]}""")
print response
#!/bin/env python2
from client import Connection
c = Connection()
#response = c.stored_procedure("TPCC-Payment", """{ "W_ID": 1, "D_ID": 1, "C_W_ID": 1, "C_D_ID": 1, "H_AMOUNT": 150.0, "C_ID": 1 }""")
#print response
d = Connection()
response = d.stored_procedure("TPCC-Payment", """{ "W_ID": 1, "D_ID": 1, "C_W_ID": 1, "C_D_ID": 1, "H_AMOUNT": 150.0, "C_LAST": "CLName2" }""")
print response
#!/bin/env python2
from client import Connection
c = Connection()
response = c.stored_procedure("TPCC-StockLevel",
"""{ "W_ID": 1, "D_ID": 1, "threshold": 15 }""")
print response
#!/bin/env python2
from client import Connection
c = Connection()
response = c.stored_procedure(
"TPCC-NewOrder",
"""{ "W_ID": 1, "D_ID": 1, "C_ID": 1, "O_CARRIER_ID": 5, "OL_DIST_INFO": "lalala", "items": [{"I_ID":1 , "I_W_ID": 1, "quantity": 1},
{"I_ID":2 , "I_W_ID": 1, "quantity": 1},
{"I_ID":7 , "I_W_ID": 1, "quantity": 1},
{"I_ID":11, "I_W_ID": 1, "quantity": 1},
{"I_ID":3 , "I_W_ID": 1, "quantity": 1}]}"""
)
print response
#!/bin/env python2
from client import Connection
c = Connection()
response = c.stored_procedure(
"TPCC-Delivery", """{ "W_ID": 1, "D_ID": 1, "O_CARRIER_ID": 1}""")
print response
#!/bin/env python2
from client import Connection
c = Connection()
response = c.stored_procedure("TPCC-Delivery", """{ "W_ID": 1, "D_ID": 1, "O_CARRIER_ID": 1}""")
print response
