import sqlite3
conn = sqlite3.connect("hotel.db")
cursor = conn.cursor()
cursor.execute('''
CREATE TABLE IF NOT EXISTS clientes(
id INTEGER PRIMARY KEY,
nome TEXT,
email TEXT
)
''')
cursor.execute(
"""
INSERT INTO clientes(nome,email) \
VALUES (?, ?)
""",
("Cleber","teste@gmail.com")
)
cursor.execute(
"""
INSERT INTO clientes(nome,email) \
VALUES (?, ?)
""",
("Cleberiano","test2e@gmail.com")
)
conn.commit()
cursor.execute('SELECT * FROM clientes')
clientes = cursor.fetchall()
for cliente in clientes:
print(cliente)
conn.close()
