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)