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

10 Achegas

2 Branches

Jovian (Netbook) 5c91993bdd Script to create database		%!s(int64=6) %!d(string=hai) anos
SQL	5c91993bdd Script to create database	%!s(int64=6) %!d(string=hai) anos
.gitignore	bad4ff78b1 Initial commit	%!s(int64=6) %!d(string=hai) anos
README.md	5c91993bdd Script to create database	%!s(int64=6) %!d(string=hai) anos
app_dispatcher.py	9bb09f593b Fix DataConsumer importation	%!s(int64=6) %!d(string=hai) anos
connect.py	55589e50fa Fix the connection access in methods	%!s(int64=6) %!d(string=hai) anos

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