Two problems:
CREATE TABLE
syntax doesn't have a VALUES
clause. You just put the table name there.You have to use string formatting.
cursr.execute(f"""CREATE TABLE IF NOT EXISTS {username} (
site_name TEXT,
user_id TEXT,
user_password TEXT)""")
As an aside, creating a table for each user is probably a poor design. Dynamic data should be in table data, not table and column names. Why not just have a single table user_sites
like this:
CREATE TABLE user_sites (
username TEXT,
site_name TEXT,
user_id TEXT,
user_password TEXT)
actually i am creating password storage app where u save the user name ,table gets created and when you log in using that name it opens that table data for you
It could just select all the records in the table
WHERE username = ?
i am not getting exe file in dist folder after converting main.py into exe using pyinstaller
Sorry, I don't know anything about pyinstaller.
ok thanks for solving upper one problem