import sys sys.path.append("..") import mysql_connect query = """ SELECT OUTS.ANIMAL_ID, OUTS.NAME FROM ANIMAL_INS AS INS RIGHT JOIN ANIMAL_OUTS AS OUTS ON INS.ANIMAL_ID = OUTS.ANIMAL_ID WHERE INS.ANIMAL_ID IS NULL ORDER BY OUTS.ANIMAL_ID """ result = mysql_connect.query_result(query)
import sys sys.path.append("..") import mysql_connect query1 = """ SELECT DATETIME AS 시간 FROM ANIMAL_INS ORDER BY DATETIME DESC LIMIT 1 """ query2 = """ SELECT MAX(DATETIME) AS 시간 FROM ANIMAL_INS """ result1 = mysql_connect.query_result(query1) result2 = mysql_connect.query_result(query2)