PyQt, Open a Table when a row is selected populating it with the row values

[rarevesselt]

Do you use a database?

Yes.

This is my product.py

import sqlalchemy
#from whooshalchemy import IndexService
from sqlalchemy import exists  
from sqlalchemy.ext.declarative import declarative_base
Base = declarative_base()
from sqlalchemy import create_engine, MetaData,Table
from sqlalchemy.orm import mapper,Session


    

class Product(Base):
    __tablename__   = 'products'   
   # __searchable__ = ['product_name','inventory_received','starting_inventory','inventory_on_hand','minimum_required']
    product_id     = sqlalchemy.Column(sqlalchemy.Integer, primary_key=True)
    product_name            = sqlalchemy.Column(sqlalchemy.String(35), nullable=False)
    inventory_received      = sqlalchemy.Column(sqlalchemy.String(35), nullable=False)
    starting_inventory        = sqlalchemy.Column(sqlalchemy.String(35), nullable=False)
    inventory_on_hand           = sqlalchemy.Column(sqlalchemy.String(35))
    minimum_required         = sqlalchemy.Column(sqlalchemy.String(50))

    def __repr__(self):
       return "<Product(product_name='%s',starting_inventory ='%s',inventory_received ='%s',inventory_on_hand='%s', minimum_required='%s')>" % (self.product_name,self.starting_inventory,self.inventory_on_hand, self.minimum_required,self.inventory_received)


 
engine = sqlalchemy.create_engine("sqlite:///user.db", echo='debug')
Base.metadata.create_all(engine)
metadata = MetaData()

DBsession = sqlalchemy.orm.sessionmaker(bind=engine) 
session = DBsession()