引发err.ProgrammingError(“execute()first”)pymysql.err.ProgrammingError:execute()first

我有一个返回游标的连接函数,使用pymysql连接数据库,还有一个使用连接函数执行sql语句的文件,但是当我获取行时,它返回一个错误 raise err.ProgrammingError("execute() first")

下面是从我的数据库配置文件扩展的连接函数

def kasaa():
    try:
        conn = mysql.connect()
        cursor = conn.cursor(pymysql.cursors.DictCursor)
        return cursor
   except Exception as e:
      print(e)

kasaa() 在employee类中,它引发了一个错误 execute() 第一

def get_multiple_info(self,employees_ids):
    """Get info of multiple Employees in database"""
    try:
        for employee_id in employees_ids:
            kasaa().execute(
                 "SELECT * FROM ospos_employees WHERE ospos_employees.deleted = 0 AND ospos_employees.person_id = %s ",
                 employee_id
             )
            row = kasaa().fetchone()
            return row()
    except Exception as e:
        print(e)
    finally:
        kasaa().close()