cintrab98/dbmysql repository overview

FROM mysql:8.0

ENV MYSQL_ROOT_PASSWORD=1998

ENV MYSQL_DATABASE=nba_api_node_database

COPY init.sql /docker-entrypoint-initdb.d/

CREATE DATABASE IF NOT EXISTS nba_api_node_database;

USE nba_api_node_database;

CREATE TABLE teams (
    id INT PRIMARY KEY AUTO_INCREMENT, 
    teamname VARCHAR(255) NOT NULL UNIQUE, 
    conference VARCHAR(255) NOT NULL, 
    wins INT NOT NULL, 
    losses INT NOT NULL, 
    estimated_value DECIMAL(10, 2) NOT NULL, 
    coach VARCHAR(255) NOT NULL
);

CREATE TABLE stats (
    team_id INT PRIMARY KEY, 
    average_age DECIMAL(3, 1) NOT NULL, 
    average_height DECIMAL(5, 2) NOT NULL, 
    average_wingspan DECIMAL(5, 2) NOT NULL, 
    FOREIGN KEY (team_id) REFERENCES teams (id)
);

-- Script to populate the "teams" table

SET FOREIGN_KEY_CHECKS = 0;

TRUNCATE TABLE teams;

INSERT INTO
    teams (
        teamname, conference, wins, losses, estimated_value, coach
    )
VALUES (
        'Boston Celtics', 'Leste', 62, 17, 3.20, 'Joe Mazzulla'
    ),
    (
        'Milwaukee Bucks', 'Leste', 48, 31, 2.85, 'Mike Budenholzer'
    ),
    (
        'Golden State Warriors', 'Oeste', 44, 35, 5.20, 'Steve Kerr'
    ),
    (
        'Brooklyn Nets', 'Leste', 31, 48, 4.25, 'Jacque Vaughn'
    ),
    (
        'Phoenix Suns', 'Oeste', 46, 33, 2.75, 'Monty Williams'
    ),
    (
        'Philadelphia 76ers', 'Leste', 45, 35, 2.90, 'Doc Rivers'
    ),
    (
        'Los Angeles Clippers', 'Oeste', 51, 28, 2.60, 'Tyronn Lue'
    ),
    (
        'Utah Jazz', 'Oeste', 29, 50, 1.75, 'Will Hardy'
    ),
    (
        'Denver Nuggets', 'Oeste', 55, 24, 2.20, 'Michael Malone'
    ),
    (
        'Memphis Grizzlies', 'Oeste', 27, 52, 1.55, 'Taylor Jenkins'
    ),
    (
        'Dallas Mavericks', 'Oeste', 49, 30, 2.00, 'Jason Kidd'
    ),
    (
        'Toronto Raptors', 'Leste', 25, 54, 1.90, 'Nick Nurse'
    ),
    (
        'Miami Heat', 'Leste', 44, 35, 2.10, 'Erik Spoelstra'
    ),
    (
        'Minnesota Timberwolves', 'Oeste', 55, 24, 1.80, 'Chris Finch'
    ),
    (
        'Chicago Bulls', 'Leste', 37, 42, 2.35, 'Billy Donovan'
    ),
    (
        'Atlanta Hawks', 'Leste', 36, 43, 1.65, 'Nate McMillan'
    ),
    (
        'Portland Trail Blazers', 'Oeste', 21, 58, 1.40, 'Chauncey Billups'
    ),
    (
        'New Orleans Pelicans', 'Oeste', 47, 32, 1.35, 'Willie Green'
    ),
    (
        'Cleveland Cavaliers', 'Leste', 46, 33, 1.25, 'J.B. Bickerstaff'
    ),
    (
        'Sacramento Kings', 'Oeste', 45, 34, 1.15, 'Mike Brown'
    ),
    (
        'Los Angeles Lakers', 'Oeste', 45, 35, 4.00, 'Darvin Ham'
    ),
    (
        'Indiana Pacers', 'Leste', 46, 34, 1.05, 'Rick Carlisle'
    ),
    (
        'New York Knicks', 'Leste', 47, 32, 1.85, 'Tom Thibodeau'
    ),
    (
        'Charlotte Hornets', 'Leste', 19, 60, 1.00, 'Steve Clifford'
    ),
    (
        'Oklahoma City Thunder', 'Oeste', 54, 25, 1.30, 'Mark Daigneault'
    ),
    (
        'Houston Rockets', 'Oeste', 39, 40, 1.20, 'Stephen Silas'
    ),
    (
        'Washington Wizards', 'Leste', 15, 65, 0.85, 'Wes Unseld Jr.'
    ),
    (
        'Detroit Pistons', 'Leste', 13, 66, 0.75, 'Dwane Casey'
    ),
    (
        'San Antonio Spurs', 'Oeste', 20, 59, 0.90, 'Gregg Popovich'
    ),
    (
        'Orlando Magic', 'Leste', 46, 33, 1.85, 'Jamahl Mosley'
    );

SET FOREIGN_KEY_CHECKS = 1;

-- Script to populate the "stats" table

INSERT INTO
    stats (
        team_id, average_age, average_height, average_wingspan
    )
VALUES (1, 27.0, 200.3, 208.0),
    (2, 27.2, 202.9, 210.8),
    (3, 28.3, 198.1, 205.7),
    (4, 27.8, 203.2, 211.4),
    (5, 27.4, 198.8, 207.8),
    (6, 25.4, 202.4, 209.3),
    (7, 27.1, 199.4, 207.0),
    (8, 26.1, 201.2, 208.3),
    (9, 25.3, 201.9, 209.5),
    (10, 24.6, 198.1, 205.4),
    (11, 25.5, 202.7, 209.8),
    (12, 27.3, 200.7, 208.3),
    (13, 27.9, 198.8, 206.4),
    (14, 24.7, 202.4, 209.8),
    (15, 26.4, 200.7, 207.3),
    (16, 25.2, 198.8, 206.7),
    (17, 26.2, 201.9, 209.3),
    (18, 24.9, 202.7, 210.2),
    (19, 25.6, 201.9, 209.3),
    (20, 25.0, 200.7, 207.3),
    (21, 27.9, 201.2, 209.3),
    (22, 25.7, 200.7, 208.0),
    (23, 25.9, 199.4, 207.3),
    (24, 24.6, 198.8, 206.7),
    (25, 24.2, 198.8, 206.4),
    (26, 25.3, 199.4, 207.0),
    (27, 24.4, 201.2, 208.3),
    (28, 24.1, 198.1, 205.7),
    (29, 26.8, 201.9, 209.3),
    (30, 25.8, 199.7, 207.8);

$ docker network create net-api
$ docker run --name db-api-nba -p 3306:3306 --network net-api cintrab98/dbmysql:1.0