Function update_execute

apps/common/db/sql_execute.py:30–41

执行一条sql :param sql: 需要执行的sql :param params: sql参数 :return: 执行结果

(sql: str, params)

def update_execute(sql: str, params):
    """
      执行一条sql
      :param sql:     需要执行的sql
      :param params:  sql参数
      :return:        执行结果
      """
    with connection.cursor() as cursor:
        cursor.execute(sql, params)
        affected_rows = cursor.rowcount
        cursor.close()
        return affected_rows


def select_list(sql: str, params: List):