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)
