Add SQLAlchemy

[ledomone]

Add Flask-SQLAlchemy folder db -> dbold (later to delete) Intents in sqlite database but with SQLAlchemy ORM

[kubaodias]

Please review @ledomone

2016-06-18T19:04:37.56+0200 [App/0]      OUT Webhook request data: {"object":"page","entry":[{"id":"215380638847054","time":1466269477373,"messaging":[{"sender":{"id":"10208414992228182"},"recipient":{"id":"215380638847054"},"timestamp":1466269474538,"message":{"mid":"mid.1466269474531:06a5ec8e21ac12b829","seq":3487,"text":"a"}}]}]}
2016-06-18T19:04:38.87+0200 [App/0]      ERR [2016-06-18 17:04:38,868] ERROR in app: Exception on /webhook [POST]
2016-06-18T19:04:38.87+0200 [App/0]      ERR Traceback (most recent call last):
2016-06-18T19:04:38.87+0200 [App/0]      ERR   File "/app/.heroku/python/lib/python2.7/site-packages/flask/app.py", line 1988, in wsgi_app
2016-06-18T19:04:38.87+0200 [App/0]      ERR     response = self.full_dispatch_request()
2016-06-18T19:04:38.87+0200 [App/0]      ERR   File "/app/.heroku/python/lib/python2.7/site-packages/flask/app.py", line 1641, in full_dispatch_request
2016-06-18T19:04:38.87+0200 [App/0]      ERR     rv = self.handle_user_exception(e)
2016-06-18T19:04:38.87+0200 [App/0]      ERR   File "/app/.heroku/python/lib/python2.7/site-packages/flask/app.py", line 1544, in handle_user_exception
2016-06-18T19:04:38.87+0200 [App/0]      ERR     reraise(exc_type, exc_value, tb)
2016-06-18T19:04:38.87+0200 [App/0]      ERR   File "/app/.heroku/python/lib/python2.7/site-packages/flask/app.py", line 1639, in full_dispatch_request
2016-06-18T19:04:38.87+0200 [App/0]      ERR     rv = self.dispatch_request()
2016-06-18T19:04:38.87+0200 [App/0]      ERR   File "/app/.heroku/python/lib/python2.7/site-packages/flask/app.py", line 1625, in dispatch_request
2016-06-18T19:04:38.87+0200 [App/0]      ERR     return self.view_functions[rule.endpoint](**req.view_args)
2016-06-18T19:04:38.87+0200 [App/0]      ERR   File "/app/.heroku/python/lib/python2.7/site-packages/flask/views.py", line 84, in view
2016-06-18T19:04:38.87+0200 [App/0]      ERR     return self.dispatch_request(*args, **kwargs)
2016-06-18T19:04:38.87+0200 [App/0]      ERR   File "/app/.heroku/python/lib/python2.7/site-packages/flask/views.py", line 149, in dispatch_request
2016-06-18T19:04:38.87+0200 [App/0]      ERR     return meth(*args, **kwargs)
2016-06-18T19:04:38.87+0200 [App/0]      ERR   File "/home/vcap/app/web.py", line 53, in post
2016-06-18T19:04:38.87+0200 [App/0]      ERR     response_body = webhook.handle_message(event['sender'], event['message'])
2016-06-18T19:04:38.87+0200 [App/0]      ERR   File "/home/vcap/app/prayer.py", line 37, in handle_message
2016-06-18T19:04:38.87+0200 [App/0]      ERR     "payload": json.dumps({"user_event": "update_prayer", "prayer_id": prayer[label_id], "description": text})
2016-06-18T19:04:38.87+0200 [App/0]      ERR NameError: global name 'label_id' is not defined

[kubaodias]

Please check again :-)

2016-06-18T20:01:19.72+0200 [App/0]      OUT Webhook request data: {"object":"page","entry":[{"id":"215380638847054","time":1466272879506,"messaging":[{"sender":{"id":"10208414992228182"},"recipient":{"id":"215380638847054"},"timestamp":1466272859058,"message":{"mid":"mid.1466272859048:976b6bce95ac205c98","seq":3537,"text":"a"}},{"sender":{"id":"10208414992228182"},"recipient":{"id":"215380638847054"},"timestamp":1466272865203,"message":{"mid":"mid.1466272865193:7d26015bf4f0d15090","seq":3538,"text":"pomoc"}}]}]}
2016-06-18T20:01:19.72+0200 [App/0]      ERR [2016-06-18 18:01:19,727] ERROR in app: Exception on /webhook [POST]
2016-06-18T20:01:19.72+0200 [App/0]      ERR Traceback (most recent call last):
2016-06-18T20:01:19.72+0200 [App/0]      ERR   File "/app/.heroku/python/lib/python2.7/site-packages/flask/app.py", line 1988, in wsgi_app
2016-06-18T20:01:19.72+0200 [App/0]      ERR     response = self.full_dispatch_request()
2016-06-18T20:01:19.72+0200 [App/0]      ERR   File "/app/.heroku/python/lib/python2.7/site-packages/flask/app.py", line 1641, in full_dispatch_request
2016-06-18T20:01:19.72+0200 [App/0]      ERR     rv = self.handle_user_exception(e)
2016-06-18T20:01:19.72+0200 [App/0]      ERR   File "/app/.heroku/python/lib/python2.7/site-packages/flask/app.py", line 1544, in handle_user_exception
2016-06-18T20:01:19.72+0200 [App/0]      ERR     reraise(exc_type, exc_value, tb)
2016-06-18T20:01:19.72+0200 [App/0]      ERR   File "/app/.heroku/python/lib/python2.7/site-packages/flask/app.py", line 1639, in full_dispatch_request
2016-06-18T20:01:19.72+0200 [App/0]      ERR     rv = self.dispatch_request()
2016-06-18T20:01:19.72+0200 [App/0]      ERR   File "/app/.heroku/python/lib/python2.7/site-packages/flask/app.py", line 1625, in dispatch_request
2016-06-18T20:01:19.72+0200 [App/0]      ERR     return self.view_functions[rule.endpoint](**req.view_args)
2016-06-18T20:01:19.72+0200 [App/0]      ERR   File "/app/.heroku/python/lib/python2.7/site-packages/flask/views.py", line 84, in view
2016-06-18T20:01:19.72+0200 [App/0]      ERR     return self.dispatch_request(*args, **kwargs)
2016-06-18T20:01:19.72+0200 [App/0]      ERR   File "/app/.heroku/python/lib/python2.7/site-packages/flask/views.py", line 149, in dispatch_request
2016-06-18T20:01:19.72+0200 [App/0]      ERR     return meth(*args, **kwargs)
2016-06-18T20:01:19.72+0200 [App/0]      ERR   File "/home/vcap/app/web.py", line 50, in post
2016-06-18T20:01:19.72+0200 [App/0]      ERR     response_body = webhook.handle_message(event['sender'], event['message'])
2016-06-18T20:01:19.72+0200 [App/0]      ERR   File "/home/vcap/app/prayer.py", line 28, in handle_message
2016-06-18T20:01:19.72+0200 [App/0]      ERR     initialized_prayers = Intent.query.filter_by(user_id == sender_id, description == "").all()
2016-06-18T20:01:19.72+0200 [App/0]      ERR NameError: global name 'user_id' is not defined

[ledomone]

Related to #8

[kubaodias]

Thanks for the hot fixes.