1Cn0PFP6

1import sqlalchemy
2from sqlalchemy import create_engine, Column
3from sqlalchemy.types import Integer, Text, VARCHAR
4from sqlalchemy.ext import declarative
5from sqlalchemy.orm import sessionmaker
6# print(dir(declarative))
7engine = create_engine('sqlite:///app.db', echo = True)
8# print(dir(engine))
9# query = """CREATE TABLE IF NOT EXISTS users(
10#             id integer primary key,
11#             username varchar(20) unique not null)"""
12# engine.execute(query)           
13# engine.execute('SELECT * from users')
14
15Base = declarative.declarative_base()
16class User(Base):
17  __tablename__ = 'users'
18  id = Column(Integer, primary_key=True)
19  username = Column(VARCHAR(20), unique=True, nullable=False)
20  password = Column(VARCHAR(20), nullable=False)
21
22  def __str__(self):
23    return f'{self.id}, {self.username}, {self.password}'
24
25Base.metadata.create_all(engine)
26
27Session = sessionmaker(bind=engine)
28session = Session()
29# user1 = User(id=1, username='Mary',password='hhgj899vfvrk9')
30# user2 = User(id=2, username='Sally',password='hhgj899efrefrt')
31# user3 = User(id=3, username='Jonny',password='hhgj899wfr59')
32# session.add_all([user2, user3])
33# session.commit()
34# session.close()
35
36data = session.query(User).filter(User.id<3).all()
37for i in data:
38  print(i)