Accueil Explorer Aide
Connexion
DricomDragon
/
PythonPostgresLab
miroir de https://github.com/DricomDragon/PythonPostgresLab.git
1
0
Fork 0
Fichiers Tickets 0 Wiki

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

Aborescence: 983c648b55
Branches Tags
PythonPostgr...
ZIP TAR.GZ
Jovian (Netbook) 983c648b55 New script without sql to test pyinquirer il y a 6 ans
SQL e6dee9186d SQL script to populate database with sample data il y a 6 ans
.gitignore bad4ff78b1 Initial commit il y a 6 ans
README.md 2499e2a626 Connection to a local postgres sql database il y a 6 ans
app_dispatcher.py 2499e2a626 Connection to a local postgres sql database il y a 6 ans
connect.py 55589e50fa Fix the connection access in methods il y a 6 ans
test_pyinquirer.py 983c648b55 New script without sql to test pyinquirer il y a 6 ans

README.md

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

If needed you can adapt the password of postgres user (or any user you want) : psql -c "alter user postgres password 'postgres_password'"