DevOps Assignment #3: Docker & Python

DevOps Assignment #3

• Step 1: Network Creation
  • Created a network named "app-network" using Docker.
  • Network ID: 9cb7974abfcf6dec3e7f664eb5853f536795a73a7d3fc94eda2467bf2a34a737
  • Other networks listed, including "bridge," "docker-app_app-network," and "host."
  • Network drivers and scope noted (bridge, local, null).

Step 2: Pull SQL & Python Images

• Pulled the latest MySQL image from Docker Hub.
• Image status: up to date for mysql:latest.
• Image details include digest (sha256:0255b469f0135a0236d672d60e3154ae2f4538b146744966d96440318cc822c6) and source (docker.io/library/mysql:latest).
• Also pulled the Python 3.9-slim image.

Step 3: Python Script

• Python script imports mysql.connector for database interaction.
• Connects to a database ('mysql') using credentials (user='testuser', password='testpassword', database='testdb').
• Executes a SQL query ("Select * from users") to retrieve data.
• Iterates through the result set (result) and prints each row.

Step 4: Dockerfile

• Uses a Python 3.9-slim base image.
• Sets the working directory to /app.
• Copies the application code from an unspecified location into the /app directory.
• Installs dependencies (mysql-connector-python) using requirements.txt (no caching).
• Runs the application using python3 app.py.

Step 5: Build Docker Python App Container

• Created a Docker container (python-app) using Docker.
• Specifics: network (app-network), environment variables (DB_HOST=new-mysql-container-name), port mapping (5000:5000), and the docker-app-python-app image.

Step 6: Run Container

• Ran the container (python-app).
• Container ID: a95f67f0dd65
• Container exited with status 1 (14 seconds ago).

SQL Queries

• Creates a database: Creates a database named testdb.
• Selects a database: Switches to the testdb database.
• Creates a table: Creates a table named users with columns id (auto-incrementing integer primary key), name (string, length 100), and email (string, length 100).
• Inserts data: Inserts a row into the users table with name 'test user' and email '[email protected]'.