def get_default_for(setting_name): sql = """SELECT default_value FROM setting_types WHERE setting_name = %s""" data = backend._query_for_one(sql, setting_name) return data['default_value']
def get_controller(controller_ip, serial_number): sql = """SELECT * FROM `controllers` WHERE `ip` = %s AND `installation` = %s""" return backend._query_for_one(sql, controller_ip, serial_number)
def get_setting_by_name(installation, setting_name): sql = """SELECT * FROM settings WHERE setting_name = %s AND installation = %s""" data = backend._query_for_one(sql, setting_name, installation) return data
def get_cookie_id(username): sql = "SELECT cookie_id, cookie_expire FROM users WHERE username = %s" return backend._query_for_one(sql, username)
def username_exists(username): sql = """SELECT COUNT(username) `exists` FROM users WHERE username = %s""" return backend._query_for_one(sql, username)['exists']
def get_user(username): sql = """SELECT * from users WHERE username = %s""" data = backend._query_for_one(sql , username) return data
def get_user_by_id(userid): sql = """SELECT * from users WHERE id = %s""" data = backend._query_for_one(sql, userid) return data
def get(serial_number): sql = """SELECT * FROM `installations` where `serial_number` = %s;""" data = backend._query_for_one(sql, serial_number) return data;
def get_by_id(id): return backend._query_for_one("""SELECT * FROM sync_queue WHERE id = ?""", id)
def get(serial_number, controller_ip, name): sql = """SELECT * FROM tags WHERE `installation` = %s AND `controller_ip` = %s AND `name` = %s""" return backend._query_for_one(sql, serial_number, controller_ip, name)
def get_last_entry(installation, controller_ip): sql = """SELECT * FROM log WHERE installation = %s AND controller_ip = %s ORDER BY `time` DESC LIMIT 1""" return backend._query_for_one(sql, installation, controller_ip)
def get(customer_id): sql = """SELECT * FROM customers WHERE `id` = %s""" return backend._query_for_one(sql, customer_id)