Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement