POC: معماری سه لایه در AWS با RDS، Flask Microservice و PHP Frontend

sudo yum install -y mysql-community-client --nogpgcheck
mysql --version
mysql -h [masked] -u [masked] -p [masked]

CREATE DATABASE pocdb;
USE pocdb;

CREATE TABLE employee (
    employee_id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL
);

INSERT INTO employee (name) VALUES ('John Doe'), ('Jane Smith');

import mysql.connector

def read_employee_data():
    # RDS database connection details (masked)
    host = "[masked]"
    user = "[masked]"
    password = "[masked]"
    database = "pocdb"

    try:
        # Establish a connection to the MySQL database
        connection = mysql.connector.connect(
            host=host,
            user=user,
            password=password,
            database=database
        )

        if connection.is_connected():
            print("Connected to the database.")
            cursor = connection.cursor()

            # Define the SQL query to retrieve all data from the employee table
            sql_query = "SELECT * FROM employee"

            # Execute the query
            cursor.execute(sql_query)

            # Fetch all rows from the result set
            rows = cursor.fetchall()

            # Process the result set and print the data
            for row in rows:
                employee_id = row[0]
                name = row[1]
                print(f"Employee ID: {employee_id}, Name: {name}")

            # Close the cursor and connection
            cursor.close()
            connection.close()
        else:
            print("Database connection failed.")

    except mysql.connector.Error as e:
        print(f"Error connecting to the database: {e}")

if __name__ == "__main__":
    read_employee_data()

pip install Flask

from flask import Flask, jsonify
import mysql.connector

app = Flask(__name__)

@app.route('/employees', methods=['GET'])
def get_employees():
    # RDS database connection details (masked)
    host = "[masked]"
    user = "[masked]"
    password = "[masked]"
    database = "pocdb"

    try:
        # Establish a connection to the MySQL database
        connection = mysql.connector.connect(
            host=host,
            user=user,
            password=password,
            database=database
        )

        if connection.is_connected():
            cursor = connection.cursor()

            # Define the SQL query to retrieve all data from the employee table
            sql_query = "SELECT * FROM employee"

            # Execute the query
            cursor.execute(sql_query)

            # Fetch all rows from the result set
            rows = cursor.fetchall()

            # Close the cursor and connection
            cursor.close()
            connection.close()

            # Process the result set and build a list of employees
            employees = []
            for row in rows:
                employee_id = row[0]
                name = row[1]
                employee_data = {"employee_id": employee_id, "name": name}
                employees.append(employee_data)

            # Return the list of employees as JSON response
            return jsonify(employees)
        else:
            return "Database connection failed.", 500

    except mysql.connector.Error as e:
        return f"Error connecting to the database: {e}", 500

if __name__ == "__main__":
    app.run(host="172.31.95.155", port=5000)

python3 Microservice.py

curl http://[Masked]:5000/employees

sudo yum update
sudo yum install php
sudo service httpd start
sudo mv hello.php /var/www/html/
sudo chown apache:apache /var/www/html/hello.php

<?php echo 'Hello, World!'; ?>

http://[masked]/hello.php

<?php
// Replace the API endpoint with the correct URL of your microservice
$apiUrl="http://[Masked]:5000/employees";

// Make an HTTP GET request to the API endpoint
$response = file_get_contents($apiUrl);

// Check if the response is valid
if ($response === false) {
    echo "Error fetching data from the microservice.";
} else {
    // Decode the JSON response into an associative array
    $data = json_decode($response, true);

    // Check if the JSON decoding was successful
    if ($data === null) {
        echo "Error decoding JSON data from the microservice.";
    } else {
        // Loop through the data and display the employee information
        echo "<h1>Employee List</h1>";
        echo "<ul>";
        foreach ($data as $employee) {
            echo "<li>Employee ID: " . $employee['employee_id'] . ", Name: " . $employee['name'] . "</li>";
        }
        echo "</ul>";
    }
}
?>