two-tier-flask-app

KO | EN

gitlite — search

#javascript #react #golang #rust #deep-learning #docker #java #nodejs #awesome #kubernetes #pytorch #ios #mcp #open-source

two-tier-flask-app

(★ 238)

No description available.

파일 탐색기

최종 버전 다운로드 (.zip)

- mysql-configmap.yml
- mysql-deployment.yml
- mysql-secrets.yml
- mysql-svc.yml
- two-tier-app-deployment.yml
- two-tier-app-svc.yml
- mysql-deployment.yml
- mysql-pv.yml
- mysql-pvc.yml
- mysql-svc.yml
- README.md
- two-tier-app-deployment.yml
- two-tier-app-pod.yml
- two-tier-app-svc.yml
- index.html
app.py
docker-compose.yml
Dockerfile
Dockerfile-multistage
dummy.txt
Jenkinsfile
Makefile
message.sql
README.md
requirements.txt

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# Flask App with MySQL Docker Setup

This is a simple Flask app that interacts with a MySQL database. The app allows users to submit messages, which are then stored in the database and displayed on the frontend.

## Prerequisites

Before you begin, make sure you have the following installed:

- Docker
- Git (optional, for cloning the repository)

## Setup

1. Clone this repository (if you haven't already):

```bash
   git clone https://github.com/your-username/your-repo-name.git
   ```

2. Navigate to the project directory:

```bash
   cd your-repo-name
   ```

3. Create a `.env` file in the project directory to store your MySQL environment variables:

```bash
   touch .env
   ```

4. Open the `.env` file and add your MySQL configuration:

```
   MYSQL_HOST=mysql
   MYSQL_USER=your_username
   MYSQL_PASSWORD=your_password
   MYSQL_DB=your_database
   ```

## Usage

1. Start the containers using Docker Compose:

```bash
   docker-compose up --build
   ```

2. Access the Flask app in your web browser:

- Frontend: http://localhost
   - Backend: http://localhost:5000

3. Create the `messages` table in your MySQL database:

- Use a MySQL client or tool (e.g., phpMyAdmin) to execute the following SQL commands:
   
     ```sql
     CREATE TABLE messages (
         id INT AUTO_INCREMENT PRIMARY KEY,
         message TEXT
     );
     ```

4. Interact with the app:

- Visit http://localhost to see the frontend. You can submit new messages using the form.
   - Visit http://localhost:5000/insert_sql to insert a message directly into the `messages` table via an SQL query.

## Cleaning Up

To stop and remove the Docker containers, press `Ctrl+C` in the terminal where the containers are running, or use the following command:

```bash
docker-compose down
```

## To run this two-tier application using  without docker-compose

- First create a docker image from Dockerfile
```bash
docker build -t flaskapp .
```

- Now, make sure that you have created a network using following command
```bash
docker network create twotier
```

- Attach both the containers in the same network, so that they can communicate with each other

i) MySQL container 
```bash
docker run -d \
    --name mysql \
    -v mysql-data:/var/lib/mysql \
    --network=twotier \
    -e MYSQL_DATABASE=mydb \
    -e MYSQL_ROOT_PASSWORD=admin \
    -p 3306:3306 \
    mysql:5.7

```
ii) Backend container
```bash
docker run -d \
    --name flaskapp \
    --network=twotier \
    -e MYSQL_HOST=mysql \
    -e MYSQL_USER=root \
    -e MYSQL_PASSWORD=admin \
    -e MYSQL_DB=mydb \
    -p 5000:5000 \
    flaskapp:latest

```

## Notes

- Make sure to replace placeholders (e.g., `your_username`, `your_password`, `your_database`) with your actual MySQL configuration.

- This is a basic setup for demonstration purposes. In a production environment, you should follow best practices for security and performance.

- Be cautious when executing SQL queries directly. Validate and sanitize user inputs to prevent vulnerabilities like SQL injection.

- If you encounter issues, check Docker logs and error messages for troubleshooting.

```

two-tier-flask-app

파일 탐색기

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

two-tier-flask-app

파일 탐색기

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

Download README