Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- def setup():
- if not os.path.exists('datas.db'):
- conn = sqlite3.connect('datas.db')
- cur = conn.cursor()
- cur.execute("CREATE TABLE users (user TEXT, email TEXT)")
- conn.close()
- def enter_datas(user, email):
- conn = sqlite3.connect('datas.db')
- cur = conn.cursor()
- for user_db in cur.execute('SELECT * from users'):
- if user == user_db[0]:
- return False
- cur.execute("INSERT INTO users (user, email) VALUES (?, ?)"
- , (user, email))
- conn.commit()
- conn.close()
- return True
- def read_datas():
- conn = sqlite3.connect('datas.db')
- cur = conn.cursor()
- print(" USERS ".center(80, '-'))
- for row in cur.execute('SELECT * FROM users'):
- print(row)
- conn.close()
Advertisement
Add Comment
Please, Sign In to add comment