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