Python sql插入的简便写法

Peaunt_Python

已于 2022-11-02 11:02:36 修改

阅读量2.2k

点赞数

文章标签： python sql 开发语言

于 2021-11-02 09:31:59 首次发布

本文链接：https://blog.csdn.net/peaunt_python/article/details/121093668

版权

# 插入操作

def insert_sql(conn,cursor,tablename, toinserts_values):
    keys = ", ".join(toinserts_values.keys())
    qmark = ", ".join(["%s"] * len(toinserts_values))
    sql_insert = "insert into %s (%s) values (%s)" % (tablename, keys, qmark)
    try:
        cursor.execute(sql_insert, list(toinserts_values.values()))
        conn.commit()
    except Exception as e:
        print(e)
        print(sql_insert)
        conn.rollback()
        print("插入失败")

# 批量插入操作
def batch_insert_sql(tablename, toinsert_list):
    if len(toinsert_list) <= 0:
        print('无值插入')
    else:
        toinsert_tuple_list = []
        for dictdd in toinsert_list:
            toinsert_tuple_list.append(tuple(dictdd.values()))
        toinserts_values = toinsert_list[0]
        keys = ", ".join(toinserts_values.keys())
        qmark = ", ".join(["%s"] * len(toinserts_values))
        sql_insert = "insert into %s (%s) values (%s)" % (tablename, keys, qmark)
        try:
            cursor.executemany(sql_insert, toinsert_tuple_list)
            conn.commit()
        except Exception as e:
            print(toinserts_values)
            print(e)
            print(sql_insert)
            self.conn.rollback()
            print("插入失败")

关于参数

第一个是链接coon

第二个是创建的游标

第三个是要插入的表名

第四个是键值对字典