import os
from tinytag import TinyTag
import mysql.connector
# database 链接数据库
mydb = mysql.connector.connect(
host="localhost",
user="root",
passwd="123456",
auth_plugin='mysql_native_password',
database="Testdatabase"
)
mycursor = mydb.cursor()
#c 创建数据库
'''
mycursor = mydb.cursor()
mycursor.execute("CREATE DATABASE mydatabase")
'''
#创建表单
#mycursor.execute("CREATE TABLE Tname6 (place VARCHAR(255), artist VARCHAR(255), duration VARCHAR(255), album VARCHAR(255), title VARCHAR(255),id INT AUTO_INCREMENT PRIMARY KEY))")
#mycursor.execute("CREATE TABLE Tname7 (place VARCHAR(255), artist VARCHAR(255), duration VARCHAR(255), album VARCHAR(255), title VARCHAR(255), id INT AUTO_INCREMENT PRIMARY KEY)")
#插入数据
sql = "INSERT INTO Tname7 (place, artist,duration,album,title) VALUES (%s, %s, %s, %s,%s)"
#val = ("fff", "ssss", "fsdfsdf", "Highway 21", "Highway 21")
#批量录入数据
path="E:\\KwDownload\\抖音伤感抖音伤感热歌"
MusicFileList=[]
MusicFileCount=0
for root,dirs,files in os.walk(path):
for name in files:
MusicFileTuple=()
if name.endswith(".mp3") or name.endswith(".wav") or name.endswith(".mp4"):
print(os.path.join(root,name))
#MusicFileList.append(os.path.join(root,name))
tag = TinyTag.get(os.path.join(root,name))
print(tag.artist)
#MusicFileList.append(tag.artist)
print(tag.duration)
#MusicFileList.append(tag.duration)
print(tag.album)
#MusicFileList.append(tag.album)
print(tag.title)
#MusicFileList.append(tag.title)
MusicFileTuple=(os.path.join(root,name),tag.artist,tag.duration,tag.album,tag.title)
MusicFileCount=MusicFileCount+1
DBval=(str(os.path.join(root,name)),str(tag.artist),str(tag.duration),str(tag.album),str(tag.title))
mycursor.execute(sql,DBval)
MusicFileList.append(MusicFileTuple)
print(MusicFileCount)
print("&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&")
print(MusicFileList)
print("&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&")
mydb.commit()
print(mycursor.rowcount, "条记录已插入")
python sql 批量插入添加数据
最新推荐文章于 2024-07-31 15:02:27 发布