def statement(self, statement, params): # retrieve the keywords in the statement keywords = Strings.keywords(statement, ':') # replace the keywords with the expected binding character, differs per databases. s = statement for keyword in keywords: s = s.replace(":" + keyword, '%s', 1) # create the database typical binding parameters, a tuple if isinstance(params, list): bindings = Helper.list_to_tuple(keywords, params) else: bindings = Helper.dict_to_tuple(keywords, params) return s, bindings
def _list(self, statement, params): connector = self.get_connector() cursor = connector.cursor() statement, parameters = self.statement(statement, params) cursor.execute(statement, parameters) return Helper.cursor_to_json(cursor) or []
def get_property(self, key): connection = self.get_connection() cursor = connection.cursor() params = {"name": key} statement = "select value from application_properties where name=:name" statement, parameters = self.statement(statement, params) cursor.execute(statement, parameters) results = Helper.cursor_to_json(cursor) if len(results) == 0: return None return results[0]['value']
def list_by_username(self, username): connection = self.get_connection() cursor = connection.cursor() message = {} message['username'] = username statement = "select * from activations where username=:username" statement, parameters = self.statement(statement, message) cursor.execute(statement, parameters) return Helper.cursor_to_json(cursor)
def _find(self, statement, params): connector = self.get_connector() cursor = connector.cursor() statement, parameters = self.statement(statement, params) cursor.execute(statement, parameters) result = Helper.cursor_to_json(cursor) or [] cursor.close() if len(result) == 0: return None return result[0]
def list(self): connection = self.get_connection() cursor = connection.cursor() params = {} statement = "select * from actions" statement, parameters = self.statement(statement, params) cursor.execute(statement, parameters) result = Helper.cursor_to_json(cursor) if len(result) == 0: return [] return result
def list(self): connection = self.get_connection() cursor = connection.cursor() params = {} statement = "select dpt.*, get_trigger_trigger_type(tgr_id) as tte from deployments dpt where active=1 order by id desc" statement, parameters = self.statement(statement, params) cursor.execute(statement, parameters) result = Helper.cursor_to_json(cursor) if len(result) == 0: return [] return result
def list(self): connection = self.get_connection() cursor = connection.cursor() params = {} statement = "select * from trigger_types where active=1 order by name" statement, parameters = self.statement(statement, params) cursor.execute(statement, parameters) result = Helper.cursor_to_json(cursor) if len(result) == 0: return [] return result
def list_hooks(self): connection = self.get_connection() cursor = connection.cursor() params = {} statement = "select tgr.*, get_trigger_type(tte_id) as tte from triggers tgr where active=1 and get_trigger_type(tte_id)='hook' order by name" statement, parameters = self.statement(statement, params) cursor.execute(statement, parameters) result = Helper.cursor_to_json(cursor) if len(result) == 0: return [] return result
def find_by_hashkey(self, hashkey): connection = self.get_connection() cursor = connection.cursor() m = {} m['hashkey'] = hashkey statement = "select * from resets where hashkey=:hashkey and active=1" statement, parameters = self.statement(statement, m) cursor.execute(statement, parameters) result = Helper.cursor_to_json(cursor) cursor.close() if len(result) == 0: return None return result[0]
def list_by_tte_id(self, tte_id): connection = self.get_connection() cursor = connection.cursor() params = {} params['tte_id'] = tte_id statement = "select * from action_groups where tte_id=:tte_id" statement, parameters = self.statement(statement, params) cursor.execute(statement, parameters) result = Helper.cursor_to_json(cursor) if len(result) == 0: return [] return result
def list_by_tte_name(self, name): connection = self.get_connection() cursor = connection.cursor() params = {} params['name'] = name statement = "select * from action_groups where tte_id=get_trigger_type_id(:name)" statement, parameters = self.statement(statement, params) print statement, parameters cursor.execute(statement, parameters) result = Helper.cursor_to_json(cursor) if len(result) == 0: return [] return result
def find_by_color(self, color): connection = self.get_connection() cursor = connection.cursor() params = {} params['color'] = color statement = "select * from actions where color=:color" statement, parameters = self.statement(statement, params) cursor.execute(statement, parameters) result = Helper.cursor_to_json(cursor) if len(result) == 0: return None return result[0]
def find_by_id(self, id): connection = self.get_connection() cursor = connection.cursor() m = {} m['id'] = id statement = "select * from users where id=:id" statement, parameters = self.statement(statement, m) cursor.execute(statement, parameters) result = Helper.cursor_to_json(cursor) cursor.close() if len(result) == 0: return None return result[0]
def find_all_by_username(self, username): connection = self.get_connection() cursor = connection.cursor() m = {} m['username'] = username statement = "select * from users where username=:username" statement, parameters = self.statement(statement, m) cursor.execute(statement, parameters) result = Helper.cursor_to_json(cursor) cursor.close() if len(result) == 0: return None return result[0]
def list_by_agp_id(self, agp_id): connection = self.get_connection() cursor = connection.cursor() params = dict() params['agp_id'] = agp_id statement = "select * from actions where agp_id=:agp_id" statement, parameters = self.statement(statement, params) cursor.execute(statement, parameters) result = Helper.cursor_to_json(cursor) if len(result) == 0: return [] return result
def find_by_hashcode(self, hashcode): connection = self.get_connection() cursor = connection.cursor() params = {} params['hashcode'] = hashcode statement = "select * from flows where hashcode=:hashcode" statement, parameters = self.statement(statement, params) cursor.execute(statement, parameters) result = Helper.cursor_to_json(cursor) if len(result) == 0: return None return result[0]
def find_by_name(self, name): connection = self.get_connection() cursor = connection.cursor() params = dict() params['name'] = name statement = "select * from repetitions where name=:name and active=1" statement, parameters = self.statement(statement, params) cursor.execute(statement, parameters) result = Helper.cursor_to_json(cursor) if len(result) == 0: return None return result[0]
def find_by_username(self, username): connection = self.get_connection() cursor = connection.cursor() message = {} message['username'] = username statement = "select * from activations where username=:username and active=1 and used=0" statement, parameters = self.statement(statement, message) cursor.execute(statement, parameters) result = Helper.cursor_to_json(cursor) cursor.close() if len(result) == 0: return None return result[0]
def find_by_name(self, name): connection = self.get_connection() cursor = connection.cursor() params = {} params['name'] = name statement = "select * from trigger_types where name=:name" statement, parameters = self.statement(statement, params) cursor.execute(statement, parameters) result = Helper.cursor_to_json(cursor) if len(result) == 0: return None return result[0]
def list_by_groupname(self, groupname, icon): connection = self.get_connection() cursor = connection.cursor() params = {} params['groupname'] = groupname params['icon'] = icon statement = "select * from actions where groupname=:groupname and icon=:icon" statement, parameters = self.statement(statement, params) cursor.execute(statement, parameters) result = Helper.cursor_to_json(cursor) if len(result) == 0: return [] return result
def nextval(self): sequence = self.get_sequence() if sequence: with self.get_connection() as cursor: params = dict() statement = "select " + sequence + ".nextval from dual" statement, parameters = self.statement(statement, params) cursor.execute(statement, parameters) result = Helper.cursor_to_json(cursor) if len(result) == 0: return None return result[0].get('nextval') return None
def list(self): connection = self.get_connection() cursor = connection.cursor() cursor.execute("select * from users") return Helper.cursor_to_json(cursor)