python批量插入数据小脚本

osc_j3111wl4 2021-01-21 08:43:32
Python Mysql def pymysql specs


说时迟那时快,一分钟复制下自己的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()

版权声明
本文为[osc_j3111wl4]所创,转载请带上原文链接,感谢
https://my.oschina.net/u/4309857/blog/4917116

  1. Python 爬虫进阶 - 前后端分离有什么了不起,过程超详细!
  2. 【python】使用pip提示ModuleNotFoundError
  3. 【python】虚拟环境搭建
  4. Advanced test | Python written test questions
  5. Fire! Open source Python ticket grabbing artifact, come home to see this wave of New Year!
  6. Python crawler advanced - before and after the end of the separation of what great, super detailed process!
  7. [Python] prompt modulenotfounderror with PIP
  8. Building a virtual environment
  9. Serverless 架构下用 Python 轻松搞定图像分类和预测
  10. Easy image classification and prediction with Python under serverless architecture
  11. python协程爬取某网站的老赖数据
  12. Python coroutine crawls Laolai data of a website
  13. 使用Python分析姿态估计数据集COCO的教程
  14. Using Python to analyze the data set coco of attitude estimation
  15. win环境 python3 flask 上手整理 环境搭建(一)
  16. Getting started with win environment python3 flash
  17. Python实现一个论文下载器,赶紧收藏
  18. win环境 python3 flask 上手整理 快速上手-基础操作(二)
  19. Python 中常见的配置文件写法
  20. Python to achieve a paper Downloader, quickly collect
  21. Python批量 png转ico
  22. 使用line_profiler对python代码性能进行评估优化
  23. 使用line_profiler对python代码性能进行评估优化
  24. Getting started with Python 3 flash in win environment
  25. Common ways to write configuration files in Python
  26. Python会在2021年死去吗? Python 3.9最终版本的回顾
  27. Python batch PNG to ICO
  28. Using line_ Profiler evaluates and optimizes the performance of Python code
  29. Using line_ Profiler evaluates and optimizes the performance of Python code
  30. Will Python die in 2021? A review of the final version of Python 3.9
  31. Python3 SMTP send mail
  32. Understanding closures in Python: getting started with closures
  33. Python日志实践
  34. Python logging practice
  35. [python opencv 计算机视觉零基础到实战] 十、图片效果毛玻璃
  36. [python opencv 计算机视觉零基础到实战] 九、模糊
  37. 10. Picture effect ground glass
  38. [Python opencv computer vision zero basis to actual combat] 9. Fuzzy
  39. 使用line_profiler對python程式碼效能進行評估優化
  40. Using line_ Profiler to evaluate and optimize the performance of Python code
  41. LeetCode | 0508. 出现次数最多的子树元素和【Python】
  42. Leetcode | 0508
  43. LeetCode | 0530. 二叉搜索树的最小绝对差【Python】
  44. LeetCode | 0515. 在每个树行中找最大值【Python】
  45. Leetcode | 0530. Minimum absolute difference of binary search tree [Python]
  46. Leetcode | 0515. Find the maximum value in each tree row [Python]
  47. 我来记笔记啦-搭建python虚拟环境
  48. Let me take notes - building a python virtual environment
  49. LeetCode | 0513. 找树左下角的值【Python】
  50. Leetcode | 0513. Find the value in the lower left corner of the tree [Python]
  51. Python OpenCV 泛洪填充,取经之旅第 21 天
  52. Python opencv flood fill, day 21
  53. Python爬虫自学系列(二)
  54. Python crawler self study series (2)
  55. 【python】身份证号码有效性检验
  56. [Python] validity test of ID number
  57. Python ORM - pymysql&sqlalchemy
  58. Python ORM - pymysql&sqlalchemy
  59. centos7 安装python3.8
  60. centos7 安装python3.8