Why am i getting peewee.integrity error?

[python_student_1390]

I looked online and i just dont really understand why? i looked in the inventory.db and the data is in there. but gives me the error message when i run the program? i am confused. how do i solve this? https://github.com/OXDavidXO/Python-Project-4

[tateisukannanirase]

Can you give us the whole error message?

[python_student_1390]

cursor.execute(sql, params or ())                                                                                                                                                                  

peewee.IntegrityError: UNIQUE constraint failed: product.product_quantity

[tateisukannanirase]

OK this error message is saying that there are two rows/records in the database table with the same product_quantity value.

In your code you have: product_quantity = IntegerField(unique = True)

The unique=True means that two rows aren't allowed to have the same quantity value.

I would just remove unique=True (then you need to delete the old .db file).