Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- def init_db():
- conn = sqlite3.connect(db)
- c = conn.cursor()
- c.execute('''
- CREATE TABLE site
- (id INTEGER PRIMARY KEY ASC, name varchar(250) NOT NULL, Lang varchar(20),URL CLOB,CSE varchar(250),searchkey varchar(100))
- ''')
- c.execute('''
- CREATE TABLE post
- (id INTEGER PRIMARY KEY ASC, url varchar(250), title varchar(250),
- abstract varchar(250), abstract_en varchar(250), preview CLOB NOT NULL, preview_en varchar(250), hash CLOB, stamp varchar(20), site_id INTEGER NOT NULL,
- FOREIGN KEY(site_id) REFERENCES site(id))
- ''')
- c.execute('''INSERT INTO site VALUES(NULL, "meh","lang",{0},"RSS","argh")'''.format(rss_link))
- conn.commit()
- conn.close()
- init_db()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement