/whacktwilio

Primary LanguagePython

WHACK

Setup:

virtualenv env
cd env/
source bin/activate

Dependencies to install:

env/bin/pip install flask flask-mysql flask-mysqldb twilio pyenchant

or

pip install flask
pip install flask-mysql
pip install flask-mysqldb
pip install twilio
pip install pyenchant

To run app:

python app.py

To start sql:

mysql -u root -p

See all database info

use Whack;
show tables;
describe city;
describe postalcode;
describe metal;
describe paper;
describe glass;
describe plastic;
describe battery;
describe bulb;
describe electronic;

See all table info:

SELECT * FROM city;
SELECT * FROM metal;
SELECT * FROM paper;
SELECT * FROM glass;
SELECT * FROM plastic;
SELECT * FROM battery;
SELECT * FROM bulb;
SELECT * FROM electronic;

Example command to add city:

CALL add_city(1, "Worcester", "MA", "http://www.worcesterma.gov");