def _Find(EMPLOYEE, id, conn): c = conn.cursor() x = c.execute('select * from EMPLOYEE where id=' + str(id)) e = EMPLOYEE() Json.GetOne(x, e, c.fetchone()) c.close() return e
def _Find(id, conn): c = conn.cursor() x = c.execute('SELECT * FROM EMPLOYEE WHERE id=' + str(id)) e = EMPLOYEE() Json.GetOne(x, e, c.fetchone()) c.close() return e
def _FindNth(POST, id, n, conn): c = conn.cursor() x = c.execute('select * from POST where empid=' + str(id)) h = HOLIDAY() if n > 1: for i in range(1, n): c.fetchone() text = Json.GetOne(x, h, c.fetchone()) c.close() return text