bradenlance

Statement_def.py

Dec 7th, 2016
35
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.73 KB | None | 0 0
  1. from sqlalchemy import create_engine
  2. from sqlalchemy.orm import sessionmaker
  3. from sqlalchemy_Cincy_boy_declarative import Base, Statement
  4. engine = create_engine('sqlite:///sqlalchemy_twitter_bot.db')
  5. Base.metadata.bind = engine
  6.  
  7. DBSession = sessionmaker(bind=engine)
  8. session = DBSession()
  9.  
  10. def update(kind, phrase):
  11.     new_statement = kind(phrase=str(tweet))
  12.     session.add(new_statement)
  13.     session.commit()
  14.  
  15. more = 1
  16. while more == 1:
  17.     decide = input("Would you like to enter a new statement?(Yes/No): ")
  18.     if decide == 'Yes':
  19.         tweet = input("Please enter your statement as a string:")
  20.         update(Statement, tweet)
  21.         print("Your statement has been added to our database")
  22.     else:
  23.         more = 0
Add Comment
Please, Sign In to add comment