This shows you the differences between two versions of the page.
|
ii:labs:s2:05:tasks:04 [2022/05/31 13:08] radu.ciobanu created |
ii:labs:s2:05:tasks:04 [2024/04/29 19:32] (current) radu.ciobanu [04. [10p] Administrating a database] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ==== 04. [10p] Stopping a multi-node Docker Swarm cluster ==== | + | ==== 04. [10p] Administrating a database ==== |
| == Subtasks == | == Subtasks == | ||
| - | - X | + | - go to the Adminer interface on [[http://localhost:8080]] (or see [[ii:labs:s2:04|lab 4]] if you are working on Play with Docker) |
| - | + | - log into the database using the following details: | |
| - | == What to upload == | + | - System: PostgreSQL |
| - | + | - Server: lab5-db | |
| - | * X | + | - Username: admin |
| + | - Password: admin | ||
| + | - Database: books | ||
| + | - check that you can observe a table called //**books**// and click on it | ||
| + | - click the //**Select data**// button to see the books already in the database (you should see the book you previously added) | ||
| + | - click the //**New item**// button and add a new book (you should only fill in the //**title**// and //**author**// text boxes and then press //**Save**//) | ||
| + | - using Postman, send a //**GET**// request and check that the backend also returns the book you added in Adminer | ||