# import sqlalchemy
#
# class Table:
#
#     def __init__(self, db_name, t_name):
#         self.table_name = t_name
#         self.engine = sqlalchemy.create_engine(f"sqlite:///{db_name}")
#
#     def select(self):
#         return list(self.engine.execute(f"select * from {self.table_name}"))
#
#     def insert(self, name, value):
#         return self.engine.execute(f"insert into {self.table_name} (name, author) values ('{name}', '{value}')")
#
#
#
# t = Table(db_name='onliner.db', t_name='books')
# t.insert('hui', 'v rot')
# print(t.select())



# -------------------------------
from dataclasses import dataclass

from sqlalchemy import create_engine, MetaData, Table, Column, Integer, String, select, insert

engine = create_engine('sqlite:///on.db', echo=True)
meta = MetaData()


@dataclass
class Students:
   id: int
   name: int
   lastname: int


students = Table(
    'students', meta,
    Column('id', Integer, primary_key=True),
    Column('name', String),
    Column('lastname', String),
)
meta.create_all(engine)


stmt = insert(students).values(name='username', lastname='lastname')

engine.execute(stmt)

stmt = select(students)

first = list(engine.execute(stmt))[0]
print(first[1])

student = Students(id=first[0], name=first[1], lastname=first[2])
print(student)

# ---------------------------------------------------

# from sqlalchemy import Column, Integer, String
# from sqlalchemy import create_engine
# from sqlalchemy.ext.declarative import declarative_base
# from sqlalchemy.orm import sessionmaker
#
#
# engine = create_engine('sqlite:///onliner.db', echo=True)
# Base = declarative_base()
#
#
#
# class Books(Base):
#     __tablename__ = 'books'
#
#     id = Column(Integer, primary_key=True)
#     name = Column(String)
#     author = Column(String)
#
#     def __str__(self):
#        return f"{self.name} - {self.author}"
#
#
# c = Books(
#    name='a',
#    author='a',
# )
#
#
# Session = sessionmaker(bind=engine)
# session = Session()
# # session.add(c)
# # session.commit()
#
# result = session.query(Books).filter(Books.name == "a").all()
# print([book.name for book in result])