search

Edufalcao14 / Projet-Web-3-Hotel-APP

0 stars 0 forks source link

DB - Data #6

Open dawid-ciborowski-vinci opened 2 weeks ago

dawid-ciborowski-vinci commented 2 weeks ago

Basic data added with 'Inserts' in the init file

dawid-ciborowski-vinci commented 2 weeks ago

Created a web3_views.sql file to store views creation. Added rooms view.

dawid-ciborowski-vinci commented 1 week ago

Added a python project in api/db/ with the data initializer. Made the data init script (main.py). All scripts put in one sql scripts directory. Separated sql scripts for easier management. Upgraded and fixed queries to recover stats data. Added triggers to manage state changes.