游标
# WorldCup=[]
# WorldCup.append(
# [id, date, count, time, group, name, score, status, logo]
# )
# WorldCup为列表套列表
import pymysql
db = pymysql.connect(
host='localhost',
user='root',
password='123456',
port=3306,
charset='utf8',
database='20221129'
)
c1 = db.cursor()
# # # ---------创建表--------------
# # sql = """create table WorldCup(id int primary key ,date varchar(100),count varchar(10),
# # time varchar(10),group_s varchar(10),name varchar(10),score varchar(10),status varchar(10),logo varchar(256));"""
# #
# # c1.execute(sql)
# # db.close()
#
# ---------插入数据--------------
c1.executemany(
"insert into WorldCup""(`id`,`date`,`count`,`time`,`group_s`,`name`,`score`,`status`,`logo`) "
"values(%s, %s, %s,%s,%s,%s,%s,%s,%s)", WorldCup) # WorldCup 一个列表套列表
try:
db.commit()
except Exception as e:
# 发生错误回滚
print(e)
print('1')
db.rollback()
db.close()
Django环境导入模型类
import os
if __name__ == '__main__':
os.environ.setdefault('DJANGO_SETTINGS_MODULE', 'p9_s.settings') # 引入Django环境
import django
django.setup() # 运行Django环境,之后可以使用Django中的其他文件
from user import models
import random
from faker import Faker
fake = Faker(locale='zh_CN')
list1 = []
for i in range(1, 10):
obj = models.Shop(
name='知名商家%s' % i,
logo='https://img0.baidu.com/it/u=3156141425,2881398916&fm=253&fmt=auto&app=138&f=JPEG?w=500&h=500',
account='shop_' + str(random.randint(1000, 9999)),
password='shop_' + str(random.randint(1000, 9999)),
phone=fake.phone_number(),
address=fake.address(),
status=1
)
list1.append(obj)
models.Shop.objects.bulk_create(list1)