Python error handling when working with SQLite database using Peewee ORM

graphicsilvr · July 2, 2023, 10:18am

Problem Description

I’m facing issues with three functions in my Betsy electronics project, and I’m having trouble solving the errors. Here are the possible causes I have identified:

There might be indentation errors.
The functions might be missing imports.
The functions might not be written correctly, resulting in a syntax error.

File Structure

Here is the file structure of my application:

Tree

├── README.md
├── betsy.db
├── license.txt
├── main.py
├── models.py
└── test_data.py

Functions Not Populating SQLite Database

The following functions are not populating the SQLite database, and I’m unable to determine the cause:

ProductTag
User
UserProduct

Output and Error Messages

When running my program, I receive the following output:
Product 1 created: True
Product 2 created: True
Product 3 created: True
Product 4 created: True

Tag Electronics updated:

True Tag Apple updated:
True Tag Headphones updated: True
Tag Laptops updated: True

Test database created and populated successfully.

betsy.db

Test database created and populated successfully.

betsy.db

linting Output

I ran tool for error handling on my code, and here are some of the issues it reported:

File: ‘main.py’

github.com

graphicsilvr/betsy-electronics/blob/main/main.py

import sqlite3
import logging

from peewee import DoesNotExist

from models import Product
from models import User
from models import Tag
from models import ProductTag
from models import Transaction

logger = logging.getLogger(__name__)
logger = logging.getLogger("peewee")
logger.addHandler(logging.StreamHandler())
logger.setLevel(logging.DEBUG)


def purchase_product(product_id, buyer_id, quantity):
    """
    Purchase a specific quantity of a product.

This file has been truncated. show original

File: ‘models.py’

github.com

graphicsilvr/betsy-electronics/blob/main/models.py

import datetime
from datetime import date


from peewee import (
    SqliteDatabase,
    Model,
    CharField,
    TextField,
    DecimalField,
    IntegerField,
    ForeignKeyField,
    DateTimeField,
    BooleanField,
    DateField,
)

db = SqliteDatabase("betsy.db")

class BaseModel(Model):

This file has been truncated. show original

Additional Information

Please let me know if you require any additional information or code snippets to assist with debugging.

j.tranquilli · September 26, 2023, 3:01am

I don’t totally understand your problem so I just want to clarify. Are you seeing that you have errors when you run your program? You mention that there might be syntax or indentation errors, but I’m not sure if that means you do know that you have those or you’re just not sure? If you had syntax errors that should be resulting in a compile time error telling you exactly what those are. This is true for all of the errors that you described as far as syntax, indentation, and functions not being written incorrectly, which also falls under a syntax error.

graphicsilvr · September 29, 2023, 11:04pm

Hi, Tranquilli. This problem is already solved my database is populating fine. Now there are other challenges with improving my application that i have to solve. Thanks for your reply.