JuricaBarta / plant-watering-simulator

Work in progress, have fun :)
0 stars 0 forks source link

Greška prilikom logina #5

Closed davorsk closed 1 year ago

davorsk commented 1 year ago

https://github.com/JuricaBarta/plant-watering-simulator/blob/96cf12fbea55a530b6a6d6c5f72370237afafd34/Prijava/MAIN_RUN_HERE.py#L61

Nad kojom će se bazom izvršiti ovaj upit? Nakon što kliknem Prijavi me, dobijem sljedeće:

sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: users
[SQL: SELECT users.user_id, users.name, users.surname, users.username, users.password 
FROM users 
WHERE users.username = ? AND users.password = ?]
[parameters: ('Davor', '1234')]

gdje je naravno ključna informacija (sqlite3.OperationalError) no such table: users.

JuricaBarta commented 1 year ago

query = db.select(User).where(User.username == entered_username).where(User.password == entered_password)

engine = db.create_engine("sqlite:///database.db") Prije se db zvao, users, a u adapcijama sam promijenio naziv db iz users u database, te sam sada to i promijenio u navedenoj liniji koda, tako da sada radi.