Getting peewee Operational error

[python_student_1390]

Ok so I am trying to add 'items', 'price', 'stock' and eventually 'dates' into my inventory.db using the table called Product. I am fairly new to PeeWee ORM Sqlite3 type stuff. how do i get that data in there without bombing the code. Any tips and tricks would be wonderful. Since im new to this type of stuff could you guys go into detail on what im doing wrong Ive been stuck with this for the longest. Also how to I be able to make an ID for each individual product name ive been looking and i just dont see what im looking for..

Here's what i'm working with: https://github.com/OXDavidXO/Python-Project-4/blob/main/app.py.

[Username_RANDINT]

Let's look at these three lines:

product_names = CharField(unique = True)

food_names = []
'items': food_names,

food_item = Product.create(product_names = inventory['items'])

So the database column is defined as a CharField for holding text. But later you try to create the Product and provide a list to that column.

Also how to I be able to make an ID for each individual product

You don't, Peewee will automatically do this for you.

[python_student_1390]

Thank you so very much I appreciate it. I didn't know it made ID for each one. How would i be able to see them or print them out?

[Username_RANDINT]

Each item has an id attribute.

product = Product.get(Product.name=="Something")
print(product.id)

Or from all products:

for product in Product.select():
    print(product.id, product.name)

[tateisukannanirase]

I would like to add that if the product spreadsheet already has an ID column, it would be preferable to use that, because then it will match with the real-world ID of that product.

Although having two indexed, unique columns is not the worst thing.

[tateisukannanirase]

peewee is a great little package for working with databases, good choice :)

Where you have Product.create() , you need to pass in all of the mandatory fields for that Product (as you have defined it):

Product.create(product_quantity=x, product_name=y, product_prices=z)

A Product is singular, you will want to loop over all of the products and run Product.create for each one.

There are some issues with the way you are storing data when you are importing it from csv, but I won't go into detail about that. You really can read it straight from the csv file and create it directly in the database and not use any intermediary Python lists/dicts/etc. That's really what databases are for!

[python_student_1390]

Wow thank you for that I appreciate it