Automotive-Maintenance-Management

Shanghai University Database principles (2) Project:

A B/S-based automobile maintenance management system developed based on the domestic database OpenGauss.

Project Configuration/Use OpenGauss like PostgreSQL

Environment:

• OS : Ubuntu 23.10
• Python : 3.8.10
• Django : 3.2
• Wechat-devtools : Stable 1.06

For the python library version, please refer to requirements.txt.

Install Docker In Your Linux

Since OpenGauss does not support Ubuntu, we chose to run it in Docker. For the installation of Docker, please refer to Install Docker.

Or you can enter the following command to install Docker directly.

Old version:

sudo spt install docker.io

New version (Recommended):

curl -sSL https://get.docker.com/ | sh

Pull Image Of OpenGauss

Pull the image through the following command:

sudo docker pull enmotech/opengauss

You can use docker images to check whether the download is successful.

Create Docker

Create a container to store data persistently and map ports to provide external access.

docker run --name opengauss -p 5432:5432 -e GS_PASSWORD=Enmo@123 --privileged=true -d enmotech/opengauss

Check docker status:

docker ps

At this point, the image in the container is configured.

Use the database via the following mystical command:

docker exec -it opengauss bash
su - omm
gsql

Connect To Database In Django project

This step can be referred to Connect OpenGauss.

Run Project

Configure setting.py as shown below:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql_psycopg2',
        'NAME': 'amm',
        'USER': 'gaussdb',
        'PASSWORD': 'Enmo@123',
        'HOST': 'localhost',
        'PORT': '5432',
    }
}

The amm database needs to be created manually after entering opengauss through the mysterious command above.

CREATE DATABASE amm;

Enter the following command in the terminal:

python manage.py makemigrations
python manage.py migrate
python manage.py runserver

Deploy Project On Cloud Server

If you rent a cloud server (Teacher Jerry will issue coupons), then you can choose to install Opengauss on the cloud server.

The installation method is the same as the local installation method, and is installed through docker.

Then you need to modify the DATABASES in setting.py,and <ip> is the public IP of your cloud server.

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql_psycopg2',
        'NAME': 'amm',
        'USER': 'gaussdb',
        'PASSWORD': 'Enmo@123',
        'HOST': '<ip>',
        'PORT': '5432',
    }
}

In addition, you may also encounter such problems. When you run

python manage.py runserver

the terminal will prompt that the connection has timed out.

This is because Django connects to the cloud server through TCP, and the set port 5432 is not open to the outside world. At this time you can ping \<ip>, but telnet \<ip> \<port> will time out.

A possible solution is to first install the telnet service on your cloud server, and then modify the security group on the cloud server provider's website to open TCP 5432 port.

When your local host can telnet to the remote host, you can access the cloud database.