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

[rarevesselt]

You create the database yourself?
There is no database file to which you connect.

Yes, I have a file for that in user.py for the database.
here is the file.I mistakenly copied the wrong one-product.py

import sqlalchemy
from sqlalchemy import exists
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import DateTime,ForeignKey,Boolean
from sqlalchemy.orm import relationship,backref
from datetime import datetime
Base = declarative_base()

class User(Base):
    __tablename__   = 'users'   
    user_id     = sqlalchemy.Column(sqlalchemy.Integer, primary_key=True)
    name            = sqlalchemy.Column(sqlalchemy.String(35), nullable=False)
    password        = sqlalchemy.Column(sqlalchemy.String(35), nullable=False)
    email           = sqlalchemy.Column(sqlalchemy.String(35))
    contact         = sqlalchemy.Column(sqlalchemy.String(50))

    def __repr__(self):
       return "<User(name='%s',password='%s',contact='%s', email='%s')>" % (self.name,self.password,self.contact, self.email)
    

class Product(Base):
    __tablename__   = 'products'   
    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))
    updated_on      = sqlalchemy.Column(DateTime(),default=datetime.now())
    Created_on =    sqlalchemy.Column(DateTime(),default=datetime.now())
    user    = relationship('User',backref=backref('products',order_by=product_id))
    user_id =   sqlalchemy.Column(sqlalchemy.Integer, ForeignKey('users.user_id'))

    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)


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