Backend application [Room acoustics UI]

This repository contains the backend application for the project room acoustics user interface, implemented in Python using the Flask framework. Currently, it has been tested only in the development environment. Future plans include support for Docker and deployment in production environments. The application supports SQLite3 as the default database, with provisions for PostgreSQL as an alternative.

Index

• Technology
• Requirements
• Environments
  • Develop
  • Production
• Flask Commands
  • Flask-cli
• Database commands
  • Flask-migrate
• Swagger
• Reference
• Contribution

Technology

• Operating System: Windows, Ubuntu
• Web Framework: Flask
• ORM: Flask-sqlalchemy
• Swagger: Swagger-UI
• Serialization: Marshmallow
• Deserialization: Marshmallow
• Validation: Marshmallow
• Migration Database: Flask-migrate
• Environment manager: Anaconda/Miniconda
• Containerization: Docker, docker-compose
• Database: PostgreSQL, SQLite3
• Python WSGI HTTP Server: Gunicorn (env specification)
• Proxy: Nginx
• Tests: Under Planning
• Deployment platform: Under planning for AWS
• CI/CD: Under planning for Github Actions

Requirements

• Python
• Anaconda/Miniconda
• Docker
• Docker-Compose
• Other requirements such as python libraries and so on.

Environments

Develop

Development environment uses SQLite3/Postgresql locally and runs the Flask server in debug mode. You can customize the environment variables in the corresponding .env file.

1. Create environment and install packages

In general, I am using conda to handle virtual env and packages installations, however you can use other alternatives to install the python dependencies as well.

conda create -n NAME_OF_VENV python=3.10

conda activate NAME_OF_VENV

pip install -r requirements.txt

2. Create PosgresSQL on Linux[Ubuntu] (optional)

# Install PosgresSQL
sudo apt-get install postgresql-12

# Access to PosgresSQL
sudo -u postgres psql

# Create user and password
CREATE USER db_user WITH PASSWORD 'db_password';

# Create Database dev
CREATE DATABASE db_dev;

# Add permission User to Database
GRANT ALL PRIVILEGES ON DATABASE db_dev TO db_user;

Note: remember to change the default env configuration to switch from sqllite to postgresql.

Note: if you are using Windows machine, you can simply download and install the postgresql from its website. However, upon installing the software try to remember what is the password for the superuser.

3. Create or update .env file

# APP configuration
APP_NAME=Flask API Rest Template
APP_ENV=develop

# Flask Configuration
FLASK_APP=app:app
FLASK_DEBUG=true
APP_SETTINGS_MODULE=config.DevelopConfig
APP_TEST_SETTINGS_MODULE=config.TestingConfig

FLASK_RUN_HOST=192.168.0.104
FLASK_RUN_PORT=5000

# Database service configuration
DATABASE_URL=postgresql://db_user:db_password@localhost/db_dev
DATABASE_TEST_URL=postgresql://db_user:db_password@localhost/db_test

4. Run application Once you are done with the above steps, you are ready to run the application.

# Create database
flask create-db

# Run a development server
flask run

Testing

Some of the planned commands:

1. Run all tests

flask tests

2. Run unit tests

flask tests_unit

3. Run integration tests

flask tests_integration

4. Run API tests

flask tests_api

5. Run coverage

flask coverage

6. Run coverage report

flask coverage_report

Local (Dockerize)

Containerized services separately with PostgreSQL databases (db), API (api) and Nginx reverse proxy (nginx) with Docker and docker-compose.

1. Create .env.api.local, .env.db.local files

   1. .env.api.local

      # APP configuration
      APP_NAME=[Name APP] # For example Flask API Rest Template
      APP_ENV=local
      
      # Flask configuration
      API_ENTRYPOINT=app:app
      APP_SETTINGS_MODULE=config.LocalConfig
      APP_TEST_SETTINGS_MODULE=config.TestingConfig
      
      # API service configuration
      API_HOST=<api_host> # For example 0.0.0.0
      API_PORT=<port_api> # For example 5000
      
      # Database service configuration
      DATABASE=postgres
      DB_HOST=<name_container_bbdd> # For example db_service (name service in docker-compose)
      DB_PORT=<port_container_bbdd> # For example 5432 (port service in docker-compose)
      POSTGRES_DB=<name_database> # For example db_dev
      POSTGRES_USER=<name_user> # For example db_user
      PGPASSWORD=<password_user> # For example db_password
      
      # Secret key
      SECRET_KEY=<your-secret-key>
      JWT_SECRET_KEY=<your-jwt-secret-key>
      
      DATABASE_TEST_URL=<url database test> # For example postgresql+psycopg2://db_user:db_password@db_service:5432/db_test
      DATABASE_URL=<url database> # For example postgresql+psycopg2://db_user:db_password@db_service:5432/db_dev

   2. .env.db.local:

      POSTGRES_USER=<name_user> # For example db_user
      POSTGRES_PASSWORD=<password> # For example db_password
      POSTGRES_DB=<name_DB> # For example db_dev

2. Build and run services shell docker-compose up --build 2. Stop services: shell docker-compose stop 3. Delete services: shell docker compose down 4. Remove services (removing volumes): shell docker-compose down -v 4. Remove services (removing volumes and images): shell docker-compose down -v --rmi all 5. View services: shell docker-compose ps NOTE: The Rest API defaults to host localhost and port 80.

Production

Apply CI/CD with Github Actions to automatically deployed to AWS platform use EC2, RDS PostgresSQL.

1. Create file .env.pro and enter the environment variables needed for production. For example:

   # APP configuration
   APP_NAME=Flask API Rest Template
   APP_ENV=production
   
   # Flask configuration
   API_ENTRYPOINT=app:app
   APP_SETTINGS_MODULE=config.ProductionConfig
   
   # API service configuration
   API_HOST=<api_host> # For example 0.0.0.0
   
   # Secret key
   SECRET_KEY=<your-secret-key>
   JWT_SECRET_KEY=<your-jwt-secret-key>
   
   # Database service configuration
   DATABASE_URL=<url_database> # For example sqlite:///production.db
   
   # Deploy platform
   PLATFORM_DEPLOY=AWS

Flask Commands

Flask-cli

• Create all tables in the database:

  flask create_db

• Delete all tables in the database:

  flask drop_db

• Database reset:

  flask reset-db

• Run tests with coverage without report in html:

  flask cov

• Run tests with coverage with report in html:

  flask cov-html

Database commands

Flask-migrate

• Create a migration repository:

  flask db init

• Generate a migration version:

  flask db migrate -m "Init"

• Apply migration to the Database:

  flask db upgrade

Swagger

http://localhost:<port>/swagger-ui

Reference

• Github - Uvicorn Gunicorn Fastapi Docker

Contribution

Feel free to make any suggestions or improvements to the project.