Example #1
0
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']
Example #2
0
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)
Example #3
0
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)
Example #4
0
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
Example #5
0
def get_cookie_id(username):
    sql = "SELECT cookie_id, cookie_expire FROM users WHERE username = %s"
    return backend._query_for_one(sql, username)
Example #6
0
def username_exists(username):
    sql = """SELECT COUNT(username) `exists` FROM users WHERE username = %s"""
    return backend._query_for_one(sql, username)['exists']
Example #7
0
def get_user(username):
    sql = """SELECT * from users WHERE username = %s"""
    data = backend._query_for_one(sql , username)
    return data
Example #8
0
def get_user_by_id(userid):
    sql = """SELECT * from users WHERE id = %s"""
    data = backend._query_for_one(sql, userid)
    return data
Example #9
0
def get(serial_number):
    sql = """SELECT * FROM `installations` where `serial_number` = %s;"""
    data = backend._query_for_one(sql, serial_number)
    return data;
Example #10
0
def get_by_id(id):
    return backend._query_for_one("""SELECT * FROM sync_queue WHERE id = ?""", id)
Example #11
0
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)
Example #12
0
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)
Example #13
0
def get(customer_id):
    sql = """SELECT * FROM customers WHERE `id` = %s"""
    return backend._query_for_one(sql, customer_id)