def get_user(self, user):
query = "SELECT * FROM %s WHERE %s='%s'" % (self.table, self.pk, user)
results = core.Connection().select_query(query)
if results == []:
return None
else:
return results[0]
def get_modules_by_status(self, status):
query = "SELECT * FROM %s WHERE status='%s'" % (self.table, status)
results = core.Connection().select_query(query)
if results == []:
return None
else:
return results
def get_modules_by_type(self, type):
query = "SELECT * FROM %s WHERE type='%s'" % (self.table, type)
results = core.Connection().select_query(query)
if results == []:
return None
else:
return results
def connect(self, addr):
self.timer.stop()
if addr is None:
if self.conn is not None:
self.conn.send({"type": "init"})
self.conn.drop()
self.conn = None
self.handle.call("setconn", None)
return
if ":" not in addr:
port = 5556
else:
addr, port = tuple(addr.split(":"))
try:
self.conn = core.Connection(addr, port)
except core.ConnectionError as ce:
QMessageBox.warning(self, "Error", str(ce))
self.conn.send({"type": "init"})
if self.conn is not None:
self.timer.start(100)
def get_users(self):
query = "SELECT * FROM %s " % self.table
results = core.Connection().select_query(query)
if results == []:
return None
else:
return results
def get_object_by_id(self, object):
query = "SELECT * FROM object WHERE object_id=$$%s$$" % (object)
results = core.Connection().select_query(query)
if results == []:
return None
else:
return results[0]
def get_database_by_id(self, object, database):
query = "SELECT * FROM obj_database WHERE object_id=$$%s$$ and database_id=$$%s$$" % (
object, database)
results = core.Connection().select_query(query)
if results == []:
return None
else:
return results[0]
def get_warehouse_by_id(self, object):
query = "SELECT * FROM %s WHERE object_id=$$%s$$" % (self.table,
object)
results = core.Connection().select_query(query)
if results == []:
return None
else:
return results
def get_databases_by_object(self, object):
query = "SELECT * FROM obj_database WHERE object_id=$$%s$$ ORDER BY database_id" % (
object)
results = core.Connection().select_query(query)
if results == []:
return None
else:
return results
def get_objects_by_module(self, module):
query = "SELECT * FROM %s WHERE module_id=$$%s$$" % (self.table,
module)
results = core.Connection().select_query(query)
if results == []:
return None
else:
return results
def get_warehouses(self):
query = "SELECT * FROM %s WHERE module_id='warehouse' ORDER BY name" % (
self.table)
results = core.Connection().select_query(query)
if results == []:
return None
else:
return results
def get_column_by_id(self, object, database, table, column):
query = "SELECT * FROM obj_column WHERE object_id=$$%s$$ and database_id=$$%s$$ and table_id=$$%s$$ and column_id=$$%s$$" % (
object, database, table, column)
results = core.Connection().select_query(query)
if results == []:
return None
else:
return results[0]
def get_columns_by_table(self, object, database, table):
query = "SELECT * FROM obj_column WHERE object_id=$$%s$$ and database_id=$$%s$$ and table_id=$$%s$$ ORDER BY column_id" % (
object, database, table)
results = core.Connection().select_query(query)
if results == []:
return None
else:
return results
def get_user_by_session(self, session):
# current time - the timeout (in minutes)
timeout = time.ctime(core.Common().now() -
(int(core.config['user']['timeout']) * 60))
query = "SELECT * FROM %s WHERE session='%s' AND session_time > '%s'" % (
self.table, session, timeout)
results = core.Connection().select_query(query)
if results == []:
return None
else:
return results[0]
def synchronise(self, user):
where = "WHERE %s='%s'" % (self.pk, user[self.pk])
set = "SET "
for k, v in user.iteritems():
if v == None:
set = set + "%s=NULL," % k
else:
set = set + "%s='%s'," % (k, v)
set = set.strip(',')
query = "UPDATE %s %s %s" % (self.table, set, where)
results = core.Connection().modify_query(query)
return None
def synchronise(self, values):
where = "WHERE %s=$$%s$$" % (self.table, self.pk)
set = "SET "
for k, v in values.iteritems():
if v == None:
set = set + "%s=NULL," % k
else:
set = set + "%s=$$%s$$," % (k, v)
set = set.strip(',')
query = "UPDATE %s %s %s" % (self.table, set, where)
results = core.Connection().modify_query(query)
return None
def create(self, module):
set = ''
key = ''
for k, v in module.iteritems():
if v == None:
set += "NULL,"
key += "%s," % k
else:
set += "'%s'," % v
key += "%s," % k
set = set.strip(',')
key = key.strip(',')
query = "INSERT INTO %s (%s) VALUES (%s)" % (self.table, key, set)
results = core.Connection().modify_query(query)
return None
def create_object(self, catalogue, sequence=None):
(table, pk) = self._get_table(catalogue)
set = ''
key = ''
for k, v in catalogue.iteritems():
if v == None:
set += "NULL,"
key += "%s," % k
else:
set += "$$%s$$," % v
key += "%s," % k
set = set.strip(',')
key = key.strip(',')
query = "INSERT INTO %s (%s) VALUES (%s)" % (table, key, set)
results = core.Connection().modify_query(query, sequence)
return results
def delete(self, id):
query = "DELETE FROM %s WHERE %s=$$%s$$" % (self.table, self.pk, id)
results = core.Connection().modify_query(query)
return None