Python学习笔记Day6
HTTP 403问题
只需要在头部加上header和cookie的信息就可以
将前几次的数据保存在sqlite数据库中
创建一个表movie
def init_db(dbpath):
sql = '''
create table movie(
id integer primary key autoincrement,
info_link text,
pic_link text,
name varchar ,
ename varchar ,
score number ,
rated number ,
introdution text,
info text
)
'''
conn = sqlite3.connect(dbpath)
cursor = conn.cursor()
cursor.execute(sql)
conn.commit()
conn.close()
将数据插入
def saveDataDB(dataList,DBpath):
conn = sqlite3.connect(DBpath)
cur = conn.cursor()
i = 1
for data in dataList:
for index in range(len(data)):
data[index] ="".join(data[index].split())
data[index] = '"'+data[index]+'"'
sql = '''
insert into movie (info_link,pic_link,name,ename,score,rated,introdution,info)values(%s)
'''%",".join(data)
cur.execute(sql)
conn.commit()
print('已执行%d条'%(i))
i += 1
cur.close()
conn.close()
“”.join(data[].splite()) 用来去除列表中的每一项的空格