sdk install springboot
spring --version
should show:
Spring CLI v2.6.6
vi app.groovy
@RestController
class ThisWillActuallyRun {
@RequestMapping("/")
String home() {
"Hello World!"
}
}
Now run
spring run app.groovy and on browser goto http://localhost:8080
sudo apt install maven
mvn -v
Should show something like
Apache Maven 3.6.3
Maven home: /usr/share/maven
Java version: 14.0.2, vendor: Private Build, runtime: /usr/lib/jvm/java-14-openjdk-amd64
Default locale: en_GB, platform encoding: UTF-8
OS name: "linux", version: "5.4.0-105-generic", arch: "amd64", family: "unix"
Navigate to https://start.spring.io/
####2. Command line app creation using spring-cli
spring init -dependencies=web,thymeleaf MavenWebThymeLeaf.zip
Using service at https://start.spring.io
Content saved to 'MavenWebThymeLeaf.zip'
spring init --build=gradle --java-version=1.8 --dependencies=web,thymeleaf --packaging=war GradleApplication.zip
Using service at https://start.spring.io
Content saved to 'GradleApplication.zip'
spring init --build=gradle --java-version=1.8 --dependencies=web,thymeleaf,postgresql,mariadb --packaging=war GradleApplicationPostgres.zip --force
Using service at https://start.spring.io
Content saved to 'GradleApplicationPostgres.zip'
##Will use maven with Postgres
spring init --dependencies=web,thymeleaf,postgresql,mariadb SpringBootPostgres.zip
To run the application, run the following command in a terminal window (in the complete) directory:
./gradlew bootRun
If you use Maven, run the following command in a terminal window (in the complete) directory:
./mvnw spring-boot:run
#mvn
mvn spring-boot:run
-Dspring-boot.run.arguments=--logging.level.org.springframework=TRACE,--logging.level.com.example.SpringBootPostgres=TRACE
When working with Gradle, we can pass log settings through the command line. This will require setting the bootRun task.
#Gradle
./gradlew bootRun -Pargs=--logging.level.org.springframework=TRACE,--logging.level.com.example.SpringBootPostgres=TRACE
sudo docker run --name=postgres-docker -e POSTGRES_PASSWORD=password -d -p 5432:5432 postgres:alpine
sudo docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
1d03444ba05d postgres:alpine "docker-entrypoint.s…" 4 seconds ago Up 3 seconds 0.0.0.0:5432->5432/tcp, :::5432->5432/tcp postgres-docker
sudo docker port postgres-docker
5432/tcp -> 0.0.0.0:5432
5432/tcp -> :::5432
sudo docker exec -it 1d03444ba05d bin/bash
bash-5.1# psql -U postgres
psql (14.2)
Type "help" for help.
##-----------------------------
sudo apt install postgresql postgresql-contrib
sudo systemctl start postgresql.service
sudo -i -u postgres
createdb mytest
createuser --interactive
Enter name of role to add: mytest
Shall the new role be a superuser? (y/n) y
psql
ALTER USER mytest WITH PASSWORD 'mytest';
exit
Now ctrl d back to original account and sudo vi /etc/postgresql/12/main/pg_hba.conf
# local all postgres peer
local all postgres md5
local all mytest md5
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all peer
Add the line for mytest as above and postgres also changed to md5 save and quit
sudo service postgresql restart
sudo -u postgres
psql -U mytest -d mytest
This should now prompt for a password
let's stop postgres and use docker image instead
sudo service postgresql stop
psql -U postgres
postgres=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+----------+----------+------------+------------+-----------------------
postgres | postgres | UTF8 | en_US.utf8 | en_US.utf8 |
template0 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c/postgres +
| | | | | postgres=CTc/postgres
(3 rows)
postgres=# create database mytest;
CREATE DATABASE
postgres=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+----------+----------+------------+------------+-----------------------
mytest | postgres | UTF8 | en_US.utf8 | en_US.utf8 |
postgres | postgres | UTF8 | en_US.utf8 | en_US.utf8 |
template0 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c/postgres +
| | | | | postgres=CTc/postgres
(4 rows)
postgres=# \c mytest;
You are now connected to database "mytest" as user "postgres".
mytest=# \dt;
Did not find any relations.
mytest=# \d
mytest=# create table testing(id UUID not null, name varchar(250) not null);
CREATE TABLE
mytest=# \d
List of relations
Schema | Name | Type | Owner
--------+---------+-------+----------
public | testing | table | postgres
(1 row)
mytest=# create extension "uuid-ossp";
CREATE EXTENSION
mytest=# insert into testing (id, name) values (uuid_generate_v4(), 'testing');
INSERT 0 1
mytest=# select * from testing;
id | name
--------------------------------------+---------
a68c6dd6-acda-4f71-b537-d31dc03338e3 | testing
(1 row)
mytest=#
mytest=# \q
bash-5.1# ctrl D
exit
mvn flyway:migrate -Dflyway.url=jdbc:postgresql://localhost:5432/mytest -Dflyway.user=postgres -Dflyway.password=password
WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflective access by com.google.inject.internal.cglib.core.$ReflectUtils$1 (file:/usr/share/maven/lib/guice.jar) to method java.lang.ClassLoader.defineClass(java.lang.String,byte[],int,int,java.security.ProtectionDomain)
WARNING: Please consider reporting this to the maintainers of com.google.inject.internal.cglib.core.$ReflectUtils$1
WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
WARNING: All illegal access operations will be denied in a future release
[INFO] Scanning for projects...
[INFO]
[INFO] -------------------< com.example:SpringBootPostgres >-------------------
[INFO] Building demo 0.0.1-SNAPSHOT
[INFO] --------------------------------[ jar ]---------------------------------
[INFO]
[INFO] --- flyway-maven-plugin:8.0.5:migrate (default-cli) @ SpringBootPostgres ---
[INFO] Flyway Community Edition 8.0.5 by Redgate
[INFO] Database: jdbc:postgresql://localhost:5432/mytest (PostgreSQL 14.2)
[INFO] Successfully validated 1 migration (execution time 00:00.026s)
[INFO] Current version of schema "public": 1
[INFO] Schema "public" is up to date. No migration necessary.
[INFO] Flyway Community Edition 8.0.5 by Redgate
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 1.318 s
[INFO] Finished at: 2022-04-08T15:02:47+01:00
[INFO] ------------------------------------------------------------------------
I was able to set Headers as Content-Type application/json
Post to http://localhost:8080/api/v1/personpostgres with body of { "name": "first lastName" } Then using GET to query http://localhost:8080/api/v1/personpostgres and found listed:
[
{
"id": "230d207a-ba7c-4fe8-b189-7a3e6e5a9fd1",
"name": "name surname"
},
{
"id": "d7ec7caf-dd28-4bb6-a0ec-87a496542c9f",
"name": "John Smith"
},
{
"id": "cc21e9c0-266e-4dd9-8eb9-66674c7e10cd",
"name": "Tim Barr"
},
{
"id": "10590204-97d7-4879-aebd-66705cd9c718",
"name": "first lastName"
}
]
Sent http://localhost:8080/api/v1/personpostgres/10590204-97d7-4879-aebd-66705cd9c718 as a DELETE request which removed the ID from DB
You can now goto http://localhost:8080/h2/ and using Generic PostgreSQL
configure jdbc:postgresql://localhost:5432/mytest
userName: postgres password: password
as per above configuration and interact with postgres via web interface
Navigate to: http://localhost:8080/api/v1/people this will load in listUsers html and display a
list of existing users from postgres db
Using Tabbed postman chrome extension with headers set as Content-Type: Application/json &
Posting following request to http://localhost:8080/api/v1/student
{ "id": "2",
"name": "second user",
"age": "24"
}
Another request
{ "id": "4",
"name": "fourth user",
"age": "25",
"address": { "id": "2", "line1": "2 abc street", "line2": "long lane", "city":"London", "postcode": "SW1 1TL"}
}
{ "id": "5",
"name": "fifth user",
"age": "25",
"address": { "id": "1", "line1": "1 abc street", "line2": "long lane", "city":"London", "postcode": "SW1 1TL"},
"courses": [{ "id": "1", "name": "science"}, { "id": "2", "name": "Engineering"}, { "id": "3", "name": "Health"}]
}
Repeated above once or twice then change method to GET
[
{
"id": 1,
"name": "first lastName",
"status": null,
"age": 24,
"address": null,
"courses": []
},
{
"id": 2,
"name": "second user",
"status": null,
"age": 24,
"address": null,
"courses": []
},
{
"id": 3,
"name": "third user",
"status": null,
"age": 24,
"address": null,
"courses": []
},
{
"id": 5,
"name": "fifth user",
"status": null,
"age": 25,
"address": {
"id": 6,
"line1": "1 abc street",
"line2": "long lane",
"city": "London",
"postcode": "SW1 1TL"
},
"courses": [
{
"id": 9,
"name": "Engineering"
},
{
"id": 8,
"name": "science"
},
{
"id": 7,
"name": "Health"
}
]
},
{
"id": 11,
"name": "fourth user",
"status": null,
"age": 25,
"address": {
"id": 10,
"line1": "2 abc street",
"line2": "long lane",
"city": "London",
"postcode": "SW1 1TL"
},
"courses": []
}
]
this is now using Transaction and spring-boot-starter-jpa & using @Entity @Table(name = "student") But because Student extends User and there is no definition to separate tables postgres has following data for above:
mytest=# \dt student
Did not find any relation named "student".
mytest=# \dt users
List of relations
Schema | Name | Type | Owner
--------+-------+-------+----------
public | users | table | postgres
(1 row)
mytest=# select * from users;
id | name | status | dtype | age
----+----------------+--------+---------+-----
1 | first lastName | | Student | 24
2 | second user | | Student | 24
(2 rows)
Swagger also gives the configuration in JSON Format. By visiting http://localhost:8080/v3/api-docs & downloading the page. api-docs.json
Visit: https://swagger.io/tools/swagger-editor/ click on live demo and choose file import where you can import the above json file.
This gives you the capability to remotely carry out the tests written for project perhaps at a clients location where
there is no access to the underlying code. You can use generate server within menu to actually produce the code for the given tests