Advertisement
Guest User

Untitled

a guest
Aug 27th, 2017
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.49 KB | None | 0 0
  1. from sqlalchemy import create_engine, func
  2. from sqlalchemy.orm import sessionmaker
  3.  
  4. url = 'mysql+pymysql://{user}:{password}@{host}/{db}?charset=utf8'.format(
  5. user=db_username,
  6. password=db_password,
  7. host=config.db_host,
  8. db=db_name
  9. )
  10. engine = create_engine(url, echo=True)
  11. Session = sessionmaker(bind=self.engine)
  12. session = Session()
  13.  
  14. response = session.query(
  15. func.defined_function(value).label('result')
  16. ).first()
  17.  
  18. response.result
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement