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
Ejemplo n.º 2
0
 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