import sqlite3

DATABASE = 'my_db.db'

def get_db():
    return sqlite3.connect(DATABASE)
    

############################################
# All predefined queries
############################################

def get_all_data():
    try:
        query = '''select distinct device_latitude,device_longitude,device_position_accuracy,user_id,timestamp,sim_operator,sim_mcc,sim_mnc,cell_signal_strength_dbm from networkmonitor where sim_state='READY' and device_latitude not NULL'''
        cursor = get_db().cursor()
        cursor.execute(query)
        result = cursor.fetchall()
        if result is None:
            return (False, "Failed to find data in database","")
        else:
            return (True, "Found data", result)
    except:
        return (False, "Failed to get data from database","")

def get_all_lte():
    try:
        query = '''select device_latitude,device_longitude,device_position_accuracy,timestamp,sim_operator,sim_mcc,sim_mnc,cell_signal_strength_dbm from networkmonitor where sim_state='READY' and network_type='MOBILE/LTE' or network_type='mobile/LTE' '''
        cursor = get_db().cursor()
        cursor.execute(query)
        result = cursor.fetchall()
        if result is None:
            return (False, "Failed to find data in database","")
        else:
            return (True, "Found data", result)
    except:
        return (False, "Failed to get data from database","")

def get_all_hspa():
    try:
        query = '''select device_latitude,device_longitude,device_position_accuracy,timestamp,sim_operator,sim_mcc,sim_mnc,cell_signal_strength_dbm from networkmonitor where network_type='MOBILE/HSPA' and sim_state='READY' '''
        cursor = get_db().cursor()
        cursor.execute(query)
        result = cursor.fetchall()
        if result is None:
            return (False, "Failed to find data in database","")
        else:
            return (True, "Found data", result)
    except:
        return (False, "Failed to get data from database","")

    
def get_all_hspa_plus():
    try:
        query = '''select device_latitude,device_longitude,device_position_accuracy,timestamp,sim_operator,sim_mcc,sim_mnc,cell_signal_strength_dbm from networkmonitor where network_type='MOBILE/HSPA+' and sim_state='READY' '''
        cursor = get_db().cursor()
        cursor.execute(query)
        result = cursor.fetchall()
        if result is None:
            return (False, "Failed to find data in database","")
        else:
            return (True, "Found data", result)
    except:
        return (False, "Failed to get data from database","")

def get_all_wifi():
    try:
        query = ''' select device_latitude,device_longitude,device_position_accuracy,timestamp,wifi_bssid,wifi_frequency,wifi_channel,wifi_rssi from networkmonitor where  network_type='WIFI' '''
        cursor = get_db().cursor()
        cursor.execute(query)
        result = cursor.fetchall()
        if result is None:
            return (False, "Failed to find data in database","")
        else:
            return (True, "Found data", result)
    except:
        return (False, "Failed to get data from database","")

def count_signal_strength_intervals(data):
    return False