dvdrental is a Laravel app, that I used to learn and practice PostgreSQL. The postgres webpage (awesome tutorial, awesome explanation) uses an example of a dvd renting company database for explanation. This database is about movies, customers...
The DB is in postgres. Check if the postgres service is running. Open Run Window by Winkey + R. Type services.msc Search Postgres service based on version installed. Click stop, start or restart the service option.
Use DBeaver once the postgres is running.
run 'php artisan serve' in CLI, then go to http://127.0.0.1:8000/dvd-rental.
See /routes/web.php. Here you will find all the description.
app/Http/Controllers/SqlTestController.php
app\Http\Controllers\JobController.php This topic is done in MySQL database. So, in order for this to work change from postgres db to mysql in the .env.
app/Http/Controllers/EmailController.php
When the user clicks the 'EventCreator' button (that is on the http://127.0.0.1:8000/create-event page), that will send a GET request. The router will trigger the EventController.
... is installed. You can use either Debugbar, or Telescope.
... is here: http://127.0.0.1:8000/telescope
The app uses https://github.com/spatie/laravel-slack-alerts#quickly-send-a-message-to-slack package for sending a simple, hardcoded message to Slack. Now, for this to work, the Job/Queueu system must be set up also, this is mandatory, because the Spatie package uses Jobs. So in order to use this feature locally, you need terminals open:
- php artisan serve (starts the Laravel server)
- php artisan queue:work (starts the queue watcher LOCALLY)
app\Http\Controllers\SlackController.php