Sqlalchemytest.py

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


Base = declarative_base()


class User(Base):
    __tablename__ = 'users'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    fullname = Column(String)
    password = Column(String)

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

#  engine = create_engine('sqlite:///:memory:', echo=True)
engine = create_engine('sqlite:///data.db', echo=True)
metadata = MetaData()
users_table = Table('users', metadata,
    Column('id', Integer, primary_key=True),
    Column('name', String),
    Column('fullname', String),
    Column('password', String)
)

metadata.create_all(engine)
Session = sessionmaker(bind=engine)
session = Session()

user = User("Вася", "Василий", "qweasdzxc")
#  print(user)
print(user.id)


session.add_all([User("kolia", "Cool Kolian[S.A.]","kolia$$$"), User("zina", "Zina Korzina", "zk18")])


session.add(user)
session.commit()
print(user.id)

for row in session.query(User, User.name).all():
   print( row.User, row.name)