This repository provides an example of how to use Flask-Dance with a SQLAlchemy storage. This particular repository uses Facebook as an OAuth provider, and it wires together the following Flask extensions:

• Flask-Dance
• Flask-SQLAlchemy
• Flask-Login

You can run this code locally, or deploy it to Heroku to test it out.

Visit https://developers.facebook.com/apps to register an app on Facebook. You must set the application's authorization callback URL to http://127.0.0.1:5000/login/facebook/authorized.

Once you've registered your application on Facebook, Facebook will give you an app ID and app secret, which we'll use in step 4.

Run the following commands on your computer:

git clone https://github.com/singingwolfboy/flask-dance-facebook-sqla.git
cd flask-dance-facebook-sqla
python3 -m venv venv
source venv/bin/activate
pip install -r requirements.txt

These commands will clone this git repository onto your computer, create a virtual environment for this project, activate it, and install the dependencies listed in requirements.txt.

Also note that if you have trouble installing psycopg2, it's OK to skip it. That dependency is only needed if you are using PostgreSQL for your database, and if you're running locally, then you can use SQLite instead, which is simpler. SQLite is also the default option, so you don't need to reconfigure anything.

Since we're storing OAuth data in the SQLAlchemy storage, we need to create the database to hold that data. Fortunately, this project includes basic command line support, so doing so is pretty straightforward. Run this code:

flask createdb

If it worked, you should see the message "Database tables created".

Many applications use environment variables for configuration, and Flask-Dance is no exception. You'll need to set the following environment variables:

• FLASK_APP: set this to app. Since this is the default value, you can leave it unset it you prefer.
• FLASK_SECRET_KEY: set this to a random string. This is used for signing the Flask session cookie.
• FACEBOOK_OAUTH_CLIENT_ID: set this to the client ID you got from Facebook.
• FACEBOOK_OAUTH_CLIENT_SECRET: set this to the client secret you got from Facebook.
• OAUTHLIB_INSECURE_TRANSPORT: set this to true. This indicates that you're doing local testing, and it's OK to use HTTP instead of HTTPS for OAuth. You should only do this for local testing. Do not set this in production! [oauthlib docs]

The easiest way to set these environment variables is to define them in an .env file. You can then install the python-dotenv package to make Flask automatically read this file when you run the dev server. This repository has a .env.example file that you can copy to .env to get a head start.

If you're setting environment variables manually, run your app using the flask command:

flask run

Then, go to http://localhost:5000/ to visit your app and log in with Facebook!

If your application isn't loading the environment variables from your .env file, then you need to install the python-dotenv package using pip:

pip install python-dotenv

Once the package is installed, try the flask run command again