python批量插入数据小脚本

最新推荐文章于 2024-04-26 23:30:08 发布

星辰_mya

最新推荐文章于 2024-04-26 23:30:08 发布

阅读量200

点赞数

本文链接：https://blog.csdn.net/ma15732625261/article/details/112890652

版权

该脚本演示了如何使用Python的pymysql库批量插入数据到MySQL数据库。通过连接数据库，执行SQL语句，将数据从一个数据源读取并插入到`sku_loading`表中。

摘要由CSDN通过智能技术生成

说时迟那时快，一分钟复制下自己的demo，欸不能完全的复制粘贴

#!/usr/bin/python
# -*- coding: UTF-8 -*-
import pymysql
import datetime

host = "10.10.0.10"
mysql_user_name = "10"
password_test = "10"

now = datetime.datetime.now()

def read_order_excel():
zone_list = find_ps_storage_zone()
db = pymysql.connect(host=host, user=mysql_user_name, password=password_test, database="warebasic")
cursor = db.cursor()
insert_frame_sql = 'insert into `sku_loading` (`sku_code`, `specs_id`, `loading_amount`, ' \
'`loading_weight`,`create_time`, `update_time`) values ' \
'(%s, %s, %s, %s, %s, %s)'
container_code_list = []
for row in zone_list:
container_code_list.append((row,"c1598584945674",10,100,now,now))
cursor.executemany(insert_frame_sql, container_code_list)
db.commit()
db.close()
return

def find_ps_storage_zone():
sql = 'SELECT DISTINCT sku_code from sku_package WHERE sku_code not in (SELECT sku_code from sku_loading );'
db = pymysql.connect(host=host, user=mysql_user_name, password=password_test, database="warebasic")
cursor = db.cursor()
cursor.execute(sql)
rows = cursor.fetchall()
db.commit()
db.close()
return rows

def main():
read_order_excel()
return

if __name__ == '__main__':
main()