txt2db
2021/5/21 10:31:48
本文主要是介绍txt2db,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!
code
#!/usr/bin/python3 import os import csv import sqlite3 curDir = os.getcwd() class Txt2Db: def startLoad(self): # open the database self.connection = sqlite3.connect('xx.db') self.cursor = self.connection.cursor() def endLoad(self): self.connection.commit() self.connection.close() def load(self, file_dir): for root, dirs, files in os.walk(file_dir): for i in range(len(files)): # 当前路径下所有非目录子文件 head = os.path.splitext(files[i])[0] tail = os.path.splitext(files[i])[1] if tail == '.txt': if head[0:4] == 'tra-': self.loadJsonFile(files[i]) def loadJsonFile(self, fileName): oriTableName = os.path.splitext(fileName)[0] tableName = "[" + oriTableName + "]" # drop table sql = "DROP TABLE IF EXISTS" + tableName self.cursor.execute(sql) # create table sql = "CREATE TABLE" + tableName + \ "(offset int PRIMARY KEY,json Text);" self.cursor.execute(sql) # drop index # sql = "DROP INDEX IF EXISTS offset_index;" # cursor.execute(sql) # connection.commit() # create index indexName = "index_" + oriTableName.split('-')[1] sql = "CREATE INDEX " + indexName + " ON " + tableName + "(offset)" self.cursor.execute(sql) self.connection.commit() # Load the CSV file into CSV reader csvfile = open(fileName, 'r') creader = csv.reader(csvfile, delimiter='\t', quotechar='"') # Iterate through the CSV reader, inserting values into the database for t in creader: sql = "INSERT INTO" + tableName + "VALUES (?,?)" self.cursor.execute(sql, t) # Close the csv file, commit changes, and close the connection csvfile.close() txt2Db = Txt2Db() txt2Db.startLoad() txt2Db.load(curDir) txt2Db.endLoad()
这篇关于txt2db的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!
- 2024-10-01基于Python+Vue开发的医院门诊预约挂号系统
- 2024-10-01基于Python+Vue开发的旅游景区管理系统
- 2024-10-01RestfulAPI入门指南:打造简单易懂的API接口
- 2024-10-01初学者指南:了解和使用Server Action
- 2024-10-01Server Component入门指南:搭建与配置详解
- 2024-10-01React 中使用 useRequest 实现数据请求
- 2024-10-01使用 golang 将ETH账户的资产平均分散到其他账户
- 2024-10-01JWT用户校验课程:从入门到实践
- 2024-10-01Server Component课程入门指南
- 2024-09-30Dnd-Kit学习:新手快速入门指南