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