python and MySQL

databse_students.sql

use db;

CREATE TABLE students(
    StudentID int not null AUTO_INCREMENT,
    FirstName varchar(100) NOT NULL,
    Surname varchar(100) NOT NULL,
    PRIMARY KEY (StudentID)
);

INSERT INTO students(FirstName, Surname)
VALUES("John", "Andersen"), ("Emma", "Smith");  

docker-compose.yml

services:
  pythonapp:
    build: ./python/
    command: sh -c "sleep 10s ; python3 ./hello_world.py"
    depends_on:
      - mysql

  mysql:
    build: ./mysql/
    restart: always
    environment:
      MYSQL_DATABASE: 'db'
      MYSQL_ROOT_PASSWORD: 'root'
    ports:
      - '3306:3306'

Dockerfile_mysql

# NOTE name need to be Dockerfile
FROM mysql:latest
COPY ./databse_students.sql /docker-entrypoint-initdb.d/

Dockerfile_python

# NOTE name need to be Dockerfile
FROM python:3.9

RUN pip install mysql-connector-python

WORKDIR /usr/app/src

COPY hello_world.py ./

hello_world.py

import mysql.connector

connection = mysql.connector.connect(
    user='root', password='root', host='mysql', port="3306", database='db')
print("DB connected")

cursor = connection.cursor()
cursor.execute('Select * FROM students')
students = cursor.fetchall()
connection.close()

print(students)