Exemple #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
Exemple #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
Exemple #3
0
def door_get_logged_in():
    query = "SELECT istID FROM DAILY_REGISTER;"
    return mysqljoao.db_query(query)
Exemple #4
0
def door_get_authorized():
    query = "SELECT istID FROM AUTHORIZED_STUDENTS;"
    return mysqljoao.db_query(query)
Exemple #5
0
def door_get_logged_in():
    query = "SELECT istID FROM DAILY_REGISTER;"
    return mysqljoao.db_query(query)
Exemple #6
0
def door_get_authorized():
    query = "SELECT istID FROM AUTHORIZED_STUDENTS;"
    return mysqljoao.db_query(query)