示例#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)