def insertData(): DBName = 'dytt.db' db = sqlite3.connect('./' + DBName, 10) conn = db.cursor() SelectSql = 'Select * from sqlite_master where type = "table" and name="lastest_moive";' CreateTableSql = ''' Create Table lastest_moive ( 'm_id' INTEGER PRIMARY KEY, 'm_type' varchar(100), 'm_trans_name' varchar(200), 'm_name' varchar(100), 'm_decade' varchar(30), 'm_conutry' varchar(30), 'm_level' varchar(100), 'm_language' varchar(30), 'm_subtitles' varchar(100), 'm_publish' varchar(30), 'm_IMDB_socre' varchar(50), 'm_douban_score' varchar(50), 'm_format' varchar(20), 'm_resolution' varchar(20), 'm_size' varchar(10), 'm_duration' varchar(10), 'm_director' varchar(50), 'm_actors' varchar(1000), 'm_placard' varchar(200), 'm_screenshot' varchar(200), 'm_ftpurl' varchar(200), 'm_dytt8_url' varchar(200) ); ''' InsertSql = ''' Insert into lastest_moive(m_type, m_trans_name, m_name, m_decade, m_conutry, m_level, m_language, m_subtitles, m_publish, m_IMDB_socre, m_douban_score, m_format, m_resolution, m_size, m_duration, m_director, m_actors, m_placard, m_screenshot, m_ftpurl, m_dytt8_url) values(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?); ''' if not conn.execute(SelectSql).fetchone(): conn.execute(CreateTableSql) db.commit() print('==== 创建表成功 ====') else: print('==== 创建表失败, 表已经存在 ====') count = 1 while not TaskQueue.isContentQueueEmpty(): item = TaskQueue.getContentQueue().get() conn.execute(InsertSql, Utils.dirToList(item)) db.commit() print('插入第 ' + str(count) + ' 条数据成功') count = count + 1 db.commit() db.close()
def SaveMysql(): import pymysql conn = pymysql.connect(host='127.0.0.1', port=3306, user='******', password="******", database='dytt', charset="utf8") cursor = conn.cursor() CreateTableSql = """ Create Table lastest_moive( m_id int not null auto_increment, m_type varchar(100), m_trans_name varchar(200), m_name varchar(100), m_decade varchar(30), m_conutry varchar(30), m_level varchar(100), m_language varchar(30), m_subtitles varchar(100), m_publish varchar(30), m_IMDB_socre varchar(50), m_douban_score varchar(50), m_format varchar(20), m_resolution varchar(20), m_size varchar(10), m_duration varchar(10), m_director varchar(50), m_actors varchar(1000), m_placard varchar(200), m_screenshot varchar(200), m_ftpurl varchar(200), m_dytt8_url varchar(200), primary key (m_id) ); """ InsertSql = ''' Insert into lastest_moive(m_type, m_trans_name, m_name, m_decade, m_conutry, m_level, m_language, m_subtitles, m_publish, m_IMDB_socre, m_douban_score, m_format, m_resolution, m_size, m_duration, m_director, m_actors, m_placard, m_screenshot, m_ftpurl, m_dytt8_url) values(%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s); ''' # if not cursor.execute(SelectSql).fetchone(): # cursor.execute(CreateTableSql) # conn.commit() # print('==== 创建表成功 ====') # else: # print('==== 创建表失败, 表已经存在 ====') table_name = 'lastest_moive' if (table_exists(cursor, table_name) != 1): cursor.execute(CreateTableSql) conn.commit() print('==== 创建表成功 ====') count = 1 # while not TaskQueue.isContentQueueEmpty(): item = TaskQueue.getContentQueue().get() cursor.execute(InsertSql, Utils.dirToList(item)) conn.commit() print('插入第 ' + str(count) + ' 条数据成功') count = count + 1 conn.commit() conn.close()
def insertData(): try: DBName = 'dytt.db' db = MySQLdb.connect("127.0.0.1", "root", "we3613040", "movie", charset='utf8') # db = sqlite3.connect('./' + DBName, 10) conn = db.cursor() tableName = 'lastest_movie' CreateTableSql = ''' Create Table lastest_movie ( `m_id` int unsigned auto_increment PRIMARY KEY, `m_type` varchar(100), `m_trans_name` varchar(200), `m_name` varchar(100), `m_decade` varchar(30), `m_conutry` varchar(30), `m_level` varchar(100), `m_language` varchar(30), `m_subtitles` varchar(100), `m_publish` varchar(80), `m_IMDB_socre` varchar(50), `m_douban_score` varchar(50), `m_format` varchar(20), `m_resolution` varchar(20), `m_size` varchar(10), `m_duration` varchar(10), `m_director` varchar(50), `m_actors` varchar(1000), `m_placard` varchar(200), `m_screenshot` varchar(200), `m_ftpurl` varchar(200), `m_dytt8_url` varchar(200) ); ''' InsertSqlPrefix = ''' Insert into lastest_movie(m_type, m_trans_name, m_name, m_decade, m_conutry, m_level, m_language, m_subtitles, m_publish, m_IMDB_socre, m_douban_score, m_format, m_resolution, m_size, m_duration, m_director, m_actors, m_placard, m_screenshot, m_ftpurl, m_dytt8_url) values('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s'); ''' if not table_exists(conn, tableName): conn.execute(CreateTableSql) db.commit() print('==== 创建表成功 ====') else: print('==== 创建表失败, 表已经存在 ====') count = 1 while not TaskQueue.isContentQueueEmpty(): item = TaskQueue.getContentQueue().get() InsertSql = InsertSqlPrefix % Utils.dirToList(item) conn.execute(InsertSql) db.commit() print('插入第 ' + str(count) + ' 条数据成功') count = count + 1 db.commit() db.close() except Exception as e: print('mysql error:') print(e) db.close() insertData()