Advertisement
Guest User

Untitled

a guest
Nov 3rd, 2017
623
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. def init_db():
  2. conn = sqlite3.connect(db)
  3. c = conn.cursor()
  4. c.execute('''
  5. CREATE TABLE site
  6. (id INTEGER PRIMARY KEY ASC, name varchar(250) NOT NULL, Lang varchar(20),URL CLOB,CSE varchar(250),searchkey varchar(100))
  7. ''')
  8. c.execute('''
  9. CREATE TABLE post
  10. (id INTEGER PRIMARY KEY ASC, url varchar(250), title varchar(250),
  11. 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,
  12. FOREIGN KEY(site_id) REFERENCES site(id))
  13. ''')
  14.  
  15. c.execute('''INSERT INTO site VALUES(NULL, "meh","lang",{0},"RSS","argh")'''.format(rss_link))
  16. conn.commit()
  17. conn.close()
  18.  
  19. init_db()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement