K
K
kodbiprog2021-03-25 17:11:04
Python
kodbiprog, 2021-03-25 17:11:04

How to fix error in sqlite3 python?

Whatever I enter in Login, password and secret, it shows that such an entry already exists...
Login: 11
Password: 11
Secret: 11
Such an entry already exists!
('123', '123', 0)

My code:
import sqlite3

db = sqlite3.connect('server.db')
sql = db.cursor()

sql.execute("""CREATE TABLE IF NOT EXISTS users (
login TEXT,
password TEXT,
secret TEXT,
cash BIGINT
)""")

db.commit()

user_login = input('Login: ')
user_password = input('Password: ')
user_secret = input('Secret: ')

sql.execute ("SELECT login FROM users")
if sql.
sql.execute("INSERT INTO users VALUES (?, ?, ?, ?)", (user_login, user_password, user_secret, 0))
db.commit()

print('Login succeeded!')
else:
print('This record already exists!')

for value in sql.execute("SELECT * FROM users"):
print(value)

Answer the question

In order to leave comments, you need to log in

2 answer(s)
E
Evgeniy _, 2021-03-25
@GeneD88

Remove sql.execute("SELECT login FROM users") before if

S
soremix, 2021-03-25
@SoreMix

In the query sql.execute("SELECT login FROM users"), no data from the inputs is used.
then so

sql.execute("SELECT 1 FROM users WHERE login = ?", (user_login,))
if sql.fetchone() is None:

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question