import sqlite3
conn = sqlite3.connect('test.db')
cursor = conn.cursor()
#cursor.execute('create table page_url(url varchar(120) primary key,sta varchar(1))')
#建表3
#cursor.execute('create table xq_url(url varchar(120) primary key,sta varchar(1))')
#建表3
#cursor.execute('create table data_tb(title varchar(300),date varchar(30),ticker varchar(30),url varchar(120),body TEXT)')
def insert_2(urls):
cursor.execute('insert into xq_url (url, sta) values ("{0}","0")'.format(urls))
conn.commit()
def insert_data(title, date,ticker,url,body):
cursor.execute('insert into data_tb (title, date,ticker,url,body) values ("{0}","{1}","{2}","{3}","{4}")'.format(title, date,ticker,url,body))
conn.commit()
#插入数据
#zong=5964
# for i in range(zong):
# urls = 'https://seekingalpha.com/earnings/earnings-call-transcripts/{0}'.format(i)
# cursor.execute('insert into page_url (url, sta) values ("{0}","0")'.format(urls))
# conn.commit()
def select_1():
cursor.execute('select * from page_url where sta="0"')
return cursor.fetchall()
def select_2():
cursor.execute('select * from xq_url where sta="0"')
return cursor.fetchall()
#查询
# cursor.execute('select * from page_url where sta="0"')
# print(cursor.fetchall())
# cursor.execute('select * from page_url where sta="0"')
# print(cursor.fetchall())
def up_1(url):
cursor.execute(
'UPDATE page_url SET sta = "1" where url="{0}";'.format(url))
conn.commit()
def up_2(url):
cursor.execute(
'UPDATE xq_url SET sta = "1" where url="{0}";'.format(url))
conn.commit()
# cursor.close()
# conn.close()
if __name__ == '__main__':
pass