Example #1
0
#!/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
Example #2
0
#!/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
Example #3
0
#!/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
Example #4
0
#!/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
Example #5
0
#!/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
Example #6
0
#!/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
Example #7
0
#!/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
Example #8
0
#!/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
Example #9
0
#!/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