def get_rendered_services(id):
db = connection.establish_default()[2]
cursor = db.cursor()
#print(services)
ids = cursor.arrayvar(cx_Oracle.NUMBER, [-1 for i in range(10)])
res = cursor.callproc('array_test_tapi.get', [ids, id])
return res[0]
def set_holdings(id, holdings):
db = connection.establish_default()[2]
cursor = db.cursor()
#print(services)
ids = cursor.arrayvar(cx_Oracle.NUMBER, [int(holding[0]) for holding in holdings])
quantity = cursor.arrayvar(cx_Oracle.NUMBER, [int(holding[1]) for holding in holdings])
cursor.callproc('requests_holdings_tapi.ins', [ids, quantity, id])
db.commit()
def set_rendered_services(id, services):
db = connection.establish_default()[2]
cursor = db.cursor()
print(services)
ids = cursor.arrayvar(cx_Oracle.NUMBER,
[int(service) for service in services])
cursor.callproc('array_test_tapi.ins', [ids, id])
db.commit()
def delete_date_states(id, date_states):
db = connection.establish_default()[2]
cursor = db.cursor()
#print(services)
dates = cursor.arrayvar(cx_Oracle.DATETIME, [date_state[0] for date_state in date_states])
states = cursor.arrayvar(cx_Oracle.NUMBER, [int(date_state[1]) for date_state in date_states])
#print(date_states)
cursor.callproc('worker_date_states_tapi.del', [states, dates, id])
db.commit()
def get_holdings(id):
db = connection.establish_default()[2]
cursor = db.cursor()
#print(services)
ids = cursor.arrayvar(cx_Oracle.NUMBER, [-1 for i in range(10)])
quantities = cursor.arrayvar(cx_Oracle.NUMBER, [-1 for i in range(10)])
res = cursor.callproc('requests_holdings_tapi.get', [ids, quantities, id])
#print(res)
#print(res[0])
ret = []
for i in range(len(res[0])):
ret.append([res[0][i], res[1][i]])
return ret
def get_date_states(id):
db = connection.establish_default()[2]
cursor = db.cursor()
#print(services)
ids = cursor.arrayvar(cx_Oracle.NUMBER, [-1 for i in range(10)])
dates = cursor.arrayvar(cx_Oracle.DATETIME, [datetime.datetime(2006,6,6) for i in range(10)])
res = cursor.callproc('worker_date_states_tapi.get', [ids, dates, id])
#print(res)
#print(res[0])
ret = []
#print(res)
for i in range(len(res[0])):
ret.append([res[0][i], res[1][i].strftime('%d.%m.%Y')])
return ret
from pony.orm import *
import cx_Oracle
import configparser
import connection
db = connection.establish_default()[1]
class Contacts(db.Entity):
id = PrimaryKey(int, auto=True)
person_status = Required(str)
person_id = Required(int)
type = Required(str)
contact = Required(str)
#position = Position(name = "General hairdresser")
#session.flush_all()
import list_all_commands
import command_storage
import connection
import configparser
import expire_controller
from threading import Thread
connection.establish_default()[1].generate_mapping(create_tables=True)
thread = Thread(target=expire_controller.inspect, args=(10, ))
thread.start()
if __name__ == '__main__':
while (True):
command = input(
'\nType a command (\'list\' to get available commands or \'exit\' to exit): \n\n'
).split(' ')
if command[0] == 'list':
list_all_commands.execute()
elif command[0] == 'exit':
expire_controller.executing = False
break
else:
print('\n\nresult:\n\n')
command_storage.get_handler(command[0])(command)