Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- from sqlalchemy import create_engine
- from sqlalchemy.orm import sessionmaker
- from sqlalchemy_Cincy_boy_declarative import Base, Statement
- engine = create_engine('sqlite:///sqlalchemy_twitter_bot.db')
- Base.metadata.bind = engine
- DBSession = sessionmaker(bind=engine)
- session = DBSession()
- def update(kind, phrase):
- new_statement = kind(phrase=str(tweet))
- session.add(new_statement)
- session.commit()
- more = 1
- while more == 1:
- decide = input("Would you like to enter a new statement?(Yes/No): ")
- if decide == 'Yes':
- tweet = input("Please enter your statement as a string:")
- update(Statement, tweet)
- print("Your statement has been added to our database")
- else:
- more = 0
Add Comment
Please, Sign In to add comment