Advertisement
Guest User

Untitled

a guest
Aug 8th, 2017
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.14 KB | None | 0 0
  1. #import logging
  2. #logging.basicConfig(filename='example.log',level=logging.DEBUG)
  3. #logging.debug('This message should go to the log file')
  4. #logging.info('So should this')
  5. #logging.warning('And this, too')
  6.  
  7. import sqlalchemy
  8. print(sqlalchemy.__version__)
  9.  
  10. from sqlalchemy import create_engine, Column, Integer, String
  11. engine = create_engine('sqlite:///:memory:', echo=True)
  12.  
  13. from sqlalchemy.ext.declarative import declarative_base
  14. Base = declarative_base()
  15.  
  16. class User(Base):
  17. __tablename__ = 'users'
  18.  
  19. id = Column(Integer, primary_key=True)
  20. name = Column(String)
  21. fullname = Column(String)
  22. password = Column(String)
  23.  
  24. def __repr__(self):
  25. return "<User(name='%s', fullname='%s', password='%s')>" % (
  26. self.name, self.fullname, self.password)
  27.  
  28. from sqlalchemy.orm import sessionmaker
  29. Session = sessionmaker(bind=engine)
  30. Session = sessionmaker()
  31. Session.configure(bind=engine) # once engine is available
  32. session = Session()
  33.  
  34. ed_user = User(name='ed', fullname='Ed Jones', password='edspassword')
  35. session.add(ed_user)
  36. our_user = session.query(User).filter_by(name='ed').first()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement