from sqlalchemy import Column,String,Integer,create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker

Base = declarative_base()

class User(Base):
    __tablename__ = "User"

    id = Column(Integer,primary_key = True)
    name = Column(String)
    fullname = Column(String)
    password = Column(String)

    def __repr__(self):

        return "< User (name = {}, password = {}) >".format(self.name,self.password)

engine = create_engine("sqlite:///:memory",echo=True)
Session = sessionmaker(engine)
session = Session()

frst_user = User(name="dev",password="joking",fullname = "dbayly")
session.add(frst_user)

req_user = session.query(User).filter_by(name = "dev")
req_user.first()