Python Connection.stored_procedure Examples

Example #1

#!/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

File: tpcc_stockLevel.py Project: EvilMcJerkface/hyrise

#!/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

File: payment.py Project: yousraabdullah/hyrise

#!/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

File: tpcc_newOrder.py Project: EvilMcJerkface/hyrise

#!/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

File: tpcc_payment.py Project: EvilMcJerkface/hyrise

#!/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

File: stockLevel.py Project: yousraabdullah/hyrise

#!/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

#!/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

#!/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

File: tpcc_delivery.py Project: EvilMcJerkface/hyrise

#!/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