Open
Description
Inserting any item into an inventory responds with this error:
{
"error": "(psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint \"item_pkey\"\nDETAIL: Key (id)=(2) already exists.\n\n[SQL: INSERT INTO item (brand, category, count, created_at, deleted_at, expiration_date, item_size, name, purchase_date, serving, subcategory, unit, inventory_id) VALUES (%(brand)s, %(category)s, %(count)s, %(created_at)s, %(deleted_at)s, %(expiration_date)s, %(item_size)s, %(name)s, %(purchase_date)s, %(serving)s, %(subcategory)s, %(unit)s, %(inventory_id)s) RETURNING item.id]\n[parameters: {'brand': 'asdf', 'category': 'dairy', 'count': Decimal('3'), 'created_at': datetime.datetime(2024, 7, 12, 4, 1, 1, 570061, tzinfo=datetime.timezone.utc), 'deleted_at': None, 'expiration_date': None, 'item_size': Decimal('1'), 'name': 'asdf', 'purchase_date': None, 'serving': None, 'subcategory': 'eggs', 'unit': 'oz', 'inventory_id': 1}]\n(Background on this error at: http://sqlalche.me/e/13/gkpj)",
"message": null,
"code": "IntegrityError",
"cause": {
"error": "duplicate key value violates unique constraint \"item_pkey\"\nDETAIL: Key (id)=(2) already exists.\n",
"message": null,
"code": "UniqueViolation"
}
}
Metadata
Metadata
Assignees
Labels
No labels