Lab realized as a student at ECN. This app is a python CLI (command line interface) to query a PostgreSQL database. https://github.com/DricomDragon/PythonPostgresLab

2 Branches

Jovian (Netbook) e6dee9186d SQL script to populate database with sample data		6 年之前
SQL	e6dee9186d SQL script to populate database with sample data	6 年之前
.gitignore	bad4ff78b1 Initial commit	6 年之前
README.md	e6dee9186d SQL script to populate database with sample data	6 年之前
app_dispatcher.py	9bb09f593b Fix DataConsumer importation	6 年之前
connect.py	55589e50fa Fix the connection access in methods	6 年之前

PythonPostgresLab

A CLI (Command Line Interface) written in python to query a PostgreSQL database. Lab realized as a student at Ecole Centrale de Nantes (ECN).

Postgres

Install postgreSQL : sudo apt install postgresql

Connect with postgres profile : sudo su postgres

Create the database : psql -f SQL/create_db.sql postgres

Populate database with tables : psql -d logistics -f SQL/create_tables.sql postgres

Populate tables with sample data : psql -d logistics -f SQL/populate_tables.sql postgres