Finance: Full Stack Web App using Flask and SQL

• Ensure that python3 and python3-pip are installed on your system
• In your terminal, navigate to the root project directory and run the following commands
• Activate the virtual environment

$ pipenv shell

• Install the dependencies

$ pipenv install -r requirements.txt

• You'll need to register for an API key in order to be able to query IEX’s data
  • Register for an account
  • Enter your email address and a password, and click “Create account”
  • On the next page, scroll down to choose the Start (free) plan
  • Once you’ve confirmed your account via a confirmation email, sign in to iexcloud.io
  • Click API Tokens
  • Copy the key that appears under the Token column (it should begin with pk_) into the <value> in the next step
• Create a .env file and paste the following into it: API_KEY=<value>
• To start the web server, execute (without debugging):

$ python application.py 

• Alternatively, execute (with debugging):

$ export FLASK_APP=application.py
$ flask run

• Lastly, create a SQL database named finances.db
• To initialize the SQL database within application.py, add db.create_all() below Initialize Schemas. Once the code runs and the you've verified the database exists, remove db.create_all()
• To initialize the SQL database in the python shell, execute:

$ python
$ from application import db
$ db.create_all()

• To initialize the database with SQL command-line arguemnts (using MySQL syntax) run each CREATE TABLE command (one at a time):

CREATE TABLE users (
	id INTEGER PRIMARY KEY AUTO_INCREMENT,
	username VARCHAR(50) UNIQUE, 
	hash VARCHAR(200) NOT NULL, 
	cash INTEGER
);
CREATE TABLE portfolio (
	id INTEGER PRIMARY KEY AUTO_INCREMENT,
	user_id INTEGER, 
	symbol VARCHAR(5), 
	current_shares INTEGER
);
CREATE TABLE bought (
	id INTEGER PRIMARY KEY AUTO_INCREMENT,
	buyer_id INTEGER, 
	time VARCHAR(100), 
	symbol VARCHAR(5), 
	shares_bought INTEGER, 
	price_bought FLOAT
);
CREATE TABLE sold (
	id INTEGER PRIMARY KEY AUTO_INCREMENT,
	seller_id INTEGER, 
	time VARCHAR(100), 
	symbol VARCHAR(5), 
	shares_sold INTEGER, 
	price_sold FLOAT
);

• Stock prices pulled from IEX Stock Quote API
• Hat icon made by Alice Noir from the Noun Project
• Feather icon made by Jacopo Mencacci from the Noun Project
• Illustrations by Freepik Storyset

Copyright Notice and Statement: currently not offering any license. Permission only to view and download. Refer to choose a license for more info.