mfullen/cs6400-dbsys_docker-compose.yml

## cs6400-dbsys_docker-compose.yml
version: "3.3"
services:
  mysql:
    #image: mysql:5.6.26
    build: ./sql
    container_name: cs6400-mysql
    ports:
     - 3306:3306
    environment:
      MYSQL_USER: "cs6400u"
      MYSQL_PASSWORD: "password"
      MYSQL_ROOT_PASSWORD: "mypassword"
      MYSQL_DATABASE: "cs6400"
    volumes:
      - db-data:/var/lib/mysql/data
    restart: always
    networks:
      - overlay

  web:
    build: ./web
    depends_on:
      - mysql
    container_name: web
    ports:
      - 4000:8080
    volumes:
      - .:/code
    links:
      - mysql:mysql
    restart: always
    networks:
      - overlay

volumes:
  db-data:

networks:
  overlay:

## cs6400-dbsys_sql_Dockerfile
FROM mysql:5.6.26
ADD example-schema.sql /docker-entrypoint-initdb.d/

## cs6400-dbsys_sql_example-schema.sql
CREATE TABLE Persons (
    PersonID int,
    LastName varchar(255),
    FirstName varchar(255),
    Address varchar(255),
    City varchar(255)
);

INSERT INTO Persons(`PersonID`, `LastName`, `FirstName`, `Address`, `City`)
values (1, "Wayne", "Bruce", "Wayne Manor", "Gotham");

INSERT INTO Persons(`PersonID`, `LastName`, `FirstName`, `Address`, `City`)
values (2, "Parker", "Peter", "123 Main Street", "New York");

INSERT INTO Persons(`PersonID`, `LastName`, `FirstName`, `Address`, `City`)
values (3, "Kent", "Clark", "Farmland", "Metropolis");

## cs6400-dbsys_web_app.py
from flask import Flask, render_template
from flaskext.mysql import MySQL
import os
import socket

app = Flask(__name__)
mysql = MySQL()
app.config['MYSQL_DATABASE_USER'] = 'root'
app.config['MYSQL_DATABASE_PASSWORD'] = 'mypassword'
app.config['MYSQL_DATABASE_DB'] = 'cs6400'
#app.config['MYSQL_DATABASE_HOST'] = 'localhost'
app.config['MYSQL_DATABASE_HOST'] = 'mysql' #mysql is the name of the docker container
mysql.init_app(app)


@app.route("/")
def hello():
    visits = "<i>cannot connect to Redis, counter disabled</i>"

    html = "<h3>Hello {name}!</h3>" \
           "<b>Hostname:</b> {hostname}<br/>" \
           "<b>Visits:</b> {visits}" \
            "<a href='/myindex'>Load from DB </a>"
    return html.format(name=os.getenv("NAME", "world"), hostname=socket.gethostname(), visits=visits)


@app.route("/myindex")
def myindex():
    cursor = mysql.connect().cursor()
    cursor.execute("SELECT * from Persons")
    data = cursor.fetchall()

    return render_template('index.html', data=data)


if __name__ == "__main__":
    app.run(host='0.0.0.0', port=8080)

## cs6400-dbsys_web_Dockerfile
# Use an official Python runtime as a parent image
FROM python:2.7-slim

RUN apt-get update && apt-get install -y gcc python-mysqldb libmysqlclient-dev

# Set the working directory to /app
WORKDIR /app

# Copy the current directory contents into the container at /app
ADD . /app

# Install any needed packages specified in requirements.txt
RUN pip install -r requirements.txt

# Make port 80 available to the world outside this container
EXPOSE 8080

# Define environment variable
ENV NAME World

# Run app.py when the container launches
CMD ["python", "app.py"]

## cs6400-dbsys_web_requirements.txt
Flask
MySQL-python
flask-mysql

## cs6400-dbsys_web_templates_index.html
<!DOCTYPE html>
<html lang="en">

<head>
    <title>Example Python Flask App</title>


    <link href="http://getbootstrap.com/dist/css/bootstrap.min.css" rel="stylesheet">

    <link href="http://getbootstrap.com/examples/jumbotron-narrow/jumbotron-narrow.css" rel="stylesheet">


</head>

<body>

<div class="container">
    <div class="header">
        <!--<nav>-->
            <!--<ul class="nav nav-pills pull-right">-->
                <!--<li role="presentation" class="active"><a href="#">Home</a>-->
                <!--</li>-->
                <!--<li role="presentation"><a href="#">Sign In</a>-->
                <!--</li>-->
                <!--<li role="presentation"><a href="showSignUp">Sign Up</a>-->
                <!--</li>-->
            <!--</ul>-->
        <!--</nav>-->
        <h3 class="text-muted">Python Flask App</h3>
    </div>

    <div>
        <table class="table">
            <thead>
            <tr>
                <th>Id</th>
                <th>Last Name</th>
                <th>First Name</th>
                <th>Address</th>
                <th>City</th>
            </tr>
            </thead>
            {% for row in data %}
            <tr>
                {% for d in row %}
                <td>{{ d }}</td>
                {% endfor %}
            </tr>
            {% endfor %}
        </table>
    </div>


    <footer class="footer">
        <p>&copy; Company 2015</p>
    </footer>

</div>
</body>

</html>
	version: "3.3"
	services:
	mysql:
	#image: mysql:5.6.26
	build: ./sql
	container_name: cs6400-mysql
	ports:
	- 3306:3306
	environment:
	MYSQL_USER: "cs6400u"
	MYSQL_PASSWORD: "password"
	MYSQL_ROOT_PASSWORD: "mypassword"
	MYSQL_DATABASE: "cs6400"
	volumes:
	- db-data:/var/lib/mysql/data
	restart: always
	networks:
	- overlay

	web:
	build: ./web
	depends_on:
	- mysql
	container_name: web
	ports:
	- 4000:8080
	volumes:
	- .:/code
	links:
	- mysql:mysql
	restart: always
	networks:
	- overlay

	volumes:
	db-data:

	networks:
	overlay:
	FROM mysql:5.6.26
	ADD example-schema.sql /docker-entrypoint-initdb.d/
	CREATE TABLE Persons (
	PersonID int,
	LastName varchar(255),
	FirstName varchar(255),
	Address varchar(255),
	City varchar(255)
	);

	INSERT INTO Persons(`PersonID`, `LastName`, `FirstName`, `Address`, `City`)
	values (1, "Wayne", "Bruce", "Wayne Manor", "Gotham");

	INSERT INTO Persons(`PersonID`, `LastName`, `FirstName`, `Address`, `City`)
	values (2, "Parker", "Peter", "123 Main Street", "New York");

	INSERT INTO Persons(`PersonID`, `LastName`, `FirstName`, `Address`, `City`)
	values (3, "Kent", "Clark", "Farmland", "Metropolis");
	from flask import Flask, render_template
	from flaskext.mysql import MySQL
	import os
	import socket

	app = Flask(__name__)
	mysql = MySQL()
	app.config['MYSQL_DATABASE_USER'] = 'root'
	app.config['MYSQL_DATABASE_PASSWORD'] = 'mypassword'
	app.config['MYSQL_DATABASE_DB'] = 'cs6400'
	#app.config['MYSQL_DATABASE_HOST'] = 'localhost'
	app.config['MYSQL_DATABASE_HOST'] = 'mysql' #mysql is the name of the docker container
	mysql.init_app(app)


	@app.route("/")
	def hello():
	visits = "<i>cannot connect to Redis, counter disabled</i>"

	html = "<h3>Hello {name}!</h3>" \
	"<b>Hostname:</b> {hostname}<br/>" \
	"<b>Visits:</b> {visits}" \
	"<a href='/myindex'>Load from DB </a>"
	return html.format(name=os.getenv("NAME", "world"), hostname=socket.gethostname(), visits=visits)


	@app.route("/myindex")
	def myindex():
	cursor = mysql.connect().cursor()
	cursor.execute("SELECT * from Persons")
	data = cursor.fetchall()

	return render_template('index.html', data=data)


	if __name__ == "__main__":
	app.run(host='0.0.0.0', port=8080)
	# Use an official Python runtime as a parent image
	FROM python:2.7-slim

	RUN apt-get update && apt-get install -y gcc python-mysqldb libmysqlclient-dev

	# Set the working directory to /app
	WORKDIR /app

	# Copy the current directory contents into the container at /app
	ADD . /app

	# Install any needed packages specified in requirements.txt
	RUN pip install -r requirements.txt

	# Make port 80 available to the world outside this container
	EXPOSE 8080

	# Define environment variable
	ENV NAME World

	# Run app.py when the container launches
	CMD ["python", "app.py"]
	<!DOCTYPE html>
	<html lang="en">

	<head>
	<title>Example Python Flask App</title>


	<link href="http://getbootstrap.com/dist/css/bootstrap.min.css" rel="stylesheet">

	<link href="http://getbootstrap.com/examples/jumbotron-narrow/jumbotron-narrow.css" rel="stylesheet">


	</head>

	<body>

	<div class="container">
	<div class="header">
	<!--<nav>-->
	<!--<ul class="nav nav-pills pull-right">-->
	<!--<li role="presentation" class="active"><a href="#">Home</a>-->
	<!--</li>-->
	<!--<li role="presentation"><a href="#">Sign In</a>-->
	<!--</li>-->
	<!--<li role="presentation"><a href="showSignUp">Sign Up</a>-->
	<!--</li>-->
	<!--</ul>-->
	<!--</nav>-->
	<h3 class="text-muted">Python Flask App</h3>
	</div>

	<div>
	<table class="table">
	<thead>
	<tr>
	<th>Id</th>
	<th>Last Name</th>
	<th>First Name</th>
	<th>Address</th>
	<th>City</th>
	</tr>
	</thead>
	{% for row in data %}
	<tr>
	{% for d in row %}
	<td>{{ d }}</td>
	{% endfor %}
	</tr>
	{% endfor %}
	</table>
	</div>



	<footer class="footer">
	<p>© Company 2015</p>
	</footer>

	</div>
	</body>

	</html>