Method execute

feapder/db/mysqldb.py:384–409

Args: sql: Returns: 影响行数

(self, sql)

        return affect_count

    def execute(self, sql) -> int:
        """

        Args:
            sql:

        Returns: 影响行数
        """
        affect_count = None
        conn, cursor = None, None
        try:
            conn, cursor = self.get_connection()
            affect_count = cursor.execute(sql)
            conn.commit()
        except Exception as e:
            log.error(
                """
                error:%s
                sql:  %s
            """
                % (e, sql)
            )
        finally:
            self.close_connection(conn, cursor)

        return affect_count