Odtnhj

I have created a database table which is basically a simple atm database which has records of some people with their pin as the primary key. Now I need to create another file where a user can enter their pin and then it checks if the pin exists in the database and if it does it shows how much money he has and on entering the amount to withdraw, the database gets updated with a new value of amount in that person's record. The table I created is as such:

import sqlite3
conn = sqlite3.connect('pin.db')
print("opened successfully")

conn.execute('''CREATE TABLE CUSTOMERS
(ID INT PRIMARY KEY NOT NULL,
NAME TEXT NOT NULL,
AGE INT NOT NULL,
ADDRESS CHAR(50),
AMOUNT INT);''')

print("table created")


conn.execute("INSERT INTO CUSTOMERS (ID,NAME,AGE,ADDRESS,AMOUNT) 
 VALUES (1234, 'Paul', 32, 'California', 20000.00 )");

conn.execute("INSERT INTO CUSTOMERS (ID,NAME,AGE,ADDRESS,AMOUNT) 
 VALUES (2345, 'Allen', 25, 'Texas', 15000.00 )");

conn.execute("INSERT INTO CUSTOMERS (ID,NAME,AGE,ADDRESS,AMOUNT) 
 VALUES (3456, 'Teddy', 23, 'Norway', 20000.00 )");

conn.execute("INSERT INTO CUSTOMERS (ID,NAME,AGE,ADDRESS,AMOUNT) 
 VALUES (4567, 'Mark', 25, 'Rich-Mond ', 65000.00 )");

conn.commit()
print ("Records created successfully")

conn.close()

The other file will be something like this I guess:

import sqlite3

conn = sqlite3.connect('pin.db')
print ("Opened database successfully")

pin=int(input("enter the 4 digit pin: "))
conn.row_factory = lambda cursor, row: row[0]
c = conn.cursor()
ids = c.execute('SELECT id FROM CUSTOMERS').fetchall()
if pin in ids:
 query= f"SELECT AMOUNT FROM CUSTOMERS WHERE ID=?"
 c.execute(query,(pin))
 print(c.fetchone())
else:
 print("no")

The problem is that I'm getting a Value Error as such: ValueError: parameters are of unsupported type, I know the solution might be something very simple and basic but the thing is I'm completely new to this sqlite3 thing and so not good with it. Explanation will be of great help for me to learn.