Esempio n. 1
0
def door_get_ellegible():
    query = "SELECT    name,AUTHORIZED_STUDENTS.istID, AUTHORIZED_STUDENTS.hashUID  FROM ist176550.AUTHORIZED_STUDENTS " \
            "JOIN DAILY_REGISTER where (AUTHORIZED_STUDENTS.istID = DAILY_REGISTER.istID);"

    result = mysqljoao.db_query(query)

    return result
Esempio n. 2
0
def door_get_ellegible():
    query = "SELECT    name,AUTHORIZED_STUDENTS.istID, AUTHORIZED_STUDENTS.hashUID  FROM ist176550.AUTHORIZED_STUDENTS " \
            "JOIN DAILY_REGISTER where (AUTHORIZED_STUDENTS.istID = DAILY_REGISTER.istID);"

    result = mysqljoao.db_query(query)

    return result
Esempio n. 3
0
def door_get_logged_in():
    query = "SELECT istID FROM DAILY_REGISTER;"
    return mysqljoao.db_query(query)
Esempio n. 4
0
def door_get_authorized():
    query = "SELECT istID FROM AUTHORIZED_STUDENTS;"
    return mysqljoao.db_query(query)
Esempio n. 5
0
def door_get_logged_in():
    query = "SELECT istID FROM DAILY_REGISTER;"
    return mysqljoao.db_query(query)
Esempio n. 6
0
def door_get_authorized():
    query = "SELECT istID FROM AUTHORIZED_STUDENTS;"
    return mysqljoao.db_query(query)