renix1

test with db

Feb 19th, 2017
154
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.77 KB | None | 0 0
  1. def setup():
  2.     if not os.path.exists('datas.db'):
  3.         conn = sqlite3.connect('datas.db')
  4.         cur = conn.cursor()
  5.         cur.execute("CREATE TABLE users (user TEXT, email TEXT)")
  6.         conn.close()
  7.  
  8. def enter_datas(user, email):
  9.     conn = sqlite3.connect('datas.db')
  10.     cur = conn.cursor()
  11.     for user_db in cur.execute('SELECT * from users'):
  12.         if user == user_db[0]:
  13.             return False
  14.     cur.execute("INSERT INTO users (user, email) VALUES (?, ?)"
  15.         , (user, email))
  16.     conn.commit()
  17.     conn.close()
  18.     return True
  19.  
  20. def read_datas():
  21.     conn = sqlite3.connect('datas.db')
  22.     cur = conn.cursor()
  23.     print(" USERS ".center(80, '-'))
  24.     for row in cur.execute('SELECT * FROM users'):
  25.         print(row)
  26.     conn.close()
Advertisement
Add Comment
Please, Sign In to add comment