from connection.db import DbConnection, db
from app_logger import AppLogger
logger = AppLogger.get_logger(__name__)
#
# Internal representation of Item
#
class ItemModel(db.Model):
# sqlalchemy configuration
__tablename__ = "items"
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(80))
price = db.Column(db.Float(precision=2))
def __init__(self, name, price, _id=None):
self.id = _id
self.name = name
self.price = price
def json(self):
return {"id": self.id, "name": self.name, "price": self.price}
@classmethod
def find_by_name(cls, name):
with DbConnection() as db:
query = "SELECT name, price, id FROM items WHERE name = ?"
result = db.cursor.execute(query, (name, ))
row = result.fetchone()
import os, sys
currentdir = os.path.dirname(os.path.realpath(__file__))
parentdir = os.path.dirname(currentdir)
sys.path.append(parentdir)
# Import parent libs
from app_logger import AppLogger
from config_manager import ConfigManager
import logging
from user import User
logger = AppLogger.get_logger(__name__,
level=logging.INFO,
log_file="test.log")
if __name__ == "__main__":
logger.info("info statement")
logger.debug("debug statement")
jwt_secret = ConfigManager.get("jwt_secret", "jose")
logger.info(f"jwt_secret: {jwt_secret}")
user = User.find_by_username("douglas")
logger.info(f"user: {user}")
currentdir = os.path.dirname(os.path.realpath(__file__))
parentdir = os.path.dirname(currentdir)
logger.info(f"currentdir: {currentdir}, parentdir: {parentdir}")
