Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import zipfile, sqlite3
- from pprint import pprint
- inpx_zip = zipfile.ZipFile('flibusta_fb2_local.inpx')
- filelistt = inpx_zip.namelist()
- print(filelistt)
- finall = []
- f = open(str(filelistt[1]))
- strlistt = f.readlines()
- for i in range(len(strlistt)):
- finall.append(strlistt[i].split('\x04'))
- #print(finall)
- class Bookbase:
- def __init__(self):
- connection = sqlite3.connect('books.db')
- self.connection = connection
- def get_connection(self):
- return self.connection
- def init_table(self):
- cursor = self.connection.cursor()
- cursor.execute('''CREATE TABLE IF NOT EXISTS users
- (id INTEGER PRIMARY KEY AUTOINCREMENT,
- author_name VARCHAR(40),
- genre VARCHAR(15),
- cycle VARCHAR(40),
- book_name VARCHAR(40),
- numb_1 VARCHAR(10),
- numb_2 VARCHAR(10),
- numb_3 VARCHAR(10),
- numb_4 VARCHAR(10),
- numb_5 VARCHAR(10),
- format VARCHAR(5),
- date VARCHAR(10),
- language VARCHAR(5),
- numb_6 VARCHAR(10))''')
- cursor.close()
- self.connection.commit()
- def insert(self, arg1, arg2, arg3, arg4, arg5, arg6, arg7, arg8, arg9, arg10, arg11, arg12, arg13):
- cursor = self.connection.cursor()
- cursor.execute(''' INSERT INTO users
- (author_name, genre, cycle, book_name, numb_1, numb_2, numb_3, numb_4, numb_5, format, date,
- language, numb_6)
- VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,) ''',
- (arg1, arg2, arg3, arg4, arg5, arg6, arg7, arg8, arg9, arg10, arg11, arg12, arg13))
- cursor.close()
- self.connection.commit()
- def get_all(self):
- cursor = self.connection.cursor()
- cursor.execute("SELECT * FROM author name")
- rows = cursor.fetchall()
- return rows
- exam = Bookbase()
- exam.init_table()
- for i in range(len(finall)):
- exam.insert(arg1=finall[0], arg2=finall[1], arg3=finall[2], arg4=finall[3], arg5=finall[4],
- arg6=finall[5], arg7=finall[6], arg8=finall[7], arg9=finall[8], arg10=finall[9],
- arg11=finall[10], arg12=finall[11], arg13=finall[12])
- print(exam.get_all())
- inpx_zip.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement