Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #import logging
- #logging.basicConfig(filename='example.log',level=logging.DEBUG)
- #logging.debug('This message should go to the log file')
- #logging.info('So should this')
- #logging.warning('And this, too')
- import sqlalchemy
- print(sqlalchemy.__version__)
- from sqlalchemy import create_engine, Column, Integer, String
- engine = create_engine('sqlite:///:memory:', echo=True)
- from sqlalchemy.ext.declarative import declarative_base
- Base = declarative_base()
- class User(Base):
- __tablename__ = 'users'
- id = Column(Integer, primary_key=True)
- name = Column(String)
- fullname = Column(String)
- password = Column(String)
- def __repr__(self):
- return "<User(name='%s', fullname='%s', password='%s')>" % (
- self.name, self.fullname, self.password)
- from sqlalchemy.orm import sessionmaker
- Session = sessionmaker(bind=engine)
- Session = sessionmaker()
- Session.configure(bind=engine) # once engine is available
- session = Session()
- ed_user = User(name='ed', fullname='Ed Jones', password='edspassword')
- session.add(ed_user)
- our_user = session.query(User).filter_by(name='ed').first()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement