bradenlance

Random_select.py

Dec 7th, 2016
45
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.55 KB | None | 0 0
  1. import random
  2. from sqlalchemy_Cincy_boy_declarative import Base, Statement
  3. from sqlalchemy import create_engine
  4. engine = create_engine('sqlite:///sqlalchemy_twitter_bot.db')
  5. Base.metadata.bind = engine
  6. from sqlalchemy.orm import sessionmaker
  7. DBSession = sessionmaker()
  8. DBSession.bind = engine
  9. session = DBSession()
  10. def Tweet():
  11.     statement = session.query(Statement).all()
  12.  
  13.     a = len(statement)
  14.  
  15.     n = random.randint(1, a-1)
  16.     print(statement[n].phrase)
  17.     return statement[n].phrase
  18.     session.delete(statement[n])
  19.     session.commit()
Add Comment
Please, Sign In to add comment