Tic-Tac-Toe

Description

This project creates a simple tic tac toe multiplayer game. In this game, all the users who join the server are added to a queue. The first two users in the queue are assigned X and O respectively. The rest of the users are considered spectators, they cannot make a move but can see the live game. As the players in front of the queue logs out, the players behind are promoted. This game also tracks the score for each user who logged in and saves it in a database.

Link: https://sleepy-wave-01676.herokuapp.com/

Flask and create-react-app

Requirements

Run following commands in your terminal:

1. npm install

2. pip install -r requirements.txt

   Alternate

3. sudo pip install -r requirements.txt

Setup

1. Run the following code in the project direcotry

echo "DANGEROUSLY_DISABLE_HOST_CHECK=true" > .env.development.local

Run Application

1. Run command in terminal (in your project directory): python app.py
2. Run command in another terminal, cd into the project directory, and run npm run start
3. Preview web page in browser '/'

Deploy to Heroku

1. Create a Heroku app:

heroku create --buildpack heroku/python

2. Add nodejs buildpack:

heroku buildpacks:add --index 1 heroku/nodejs

3. Push to Heroku:

git push heroku main

Create a new database on Heroku and connect to our code

1. In your terminal, go to the directory with app.py.
2. Let's set up a new remote Postgres database with Heroku and connect to it locally.

• Login and fill creds: heroku login -i
• Create a new Heroku app: heroku create
• Create a new remote DB on your Heroku app: heroku addons:create heroku-postgresql:hobby-dev (If that doesn't work, add a -a {your-app-name} to the end of the command, no braces)
• See the config vars set by Heroku for you: heroku config. Copy paste the value for DATABASE_URL
• Set the value of DATABASE_URL as an environment variable by entering this in the terminal: export DATABASE_URL='copy-paste-value-in-here' (mine looked like this export DATABASE_URL='postgres://lkmlrinuazynlb:b94acaa351c0ecdaa7d60ce75f7ccaf40c2af646281bd5b1a2787c2eb5114be4@ec2-54-164-238-108.compute-1.amazonaws.com:5432/d1ef9avoe3r77f')

Use Python code to update this new database

9. In the terminal, run python to open up an interactive session. Let's initialize a new database and add some dummy data in it using SQLAlchemy functions. Then type in these Python lines one by one:

>> from app import db
>> import models
>> db.create_all()
>> admin = models.Person(username='admin', email='admin@example.com')
>> guest = models.Person(username='guest', email='guest@example.com')
>> db.session.add(admin)
>> db.session.add(guest)
>> db.session.commit()

10. In your same python session, let's now make sure that data was added successfully by doing some queries.

>> models.Person.query.all()
[<Person u'admin'>, <Person u'guest'>] # output
>> models.Person.query.filter_by(username='admin').first()
<Person u'admin'> # output

11. Now let's make sure this was written to our Heroku remote database! Let's connect to it using: heroku pg:psql
12. \d to list all our tables. person should be in there now.
13. Now let's query the data with a SQL query (you will submit screenshots of the output in Canvas):

SELECT * FROM person;

SELECT email FROM person WHERE username='admin';