REST API that allows money transfer between accounts by using Vert.x .

$ mvn clean install -U -X vertx:run

moneytransfer\target$ java -jar .\moneytransfer-0.0.1-SNAPSHOT.jar 

[vert.x-eventloop-thread-1] INFO  c.company.moneytransfer.util.DBUtil - Start setup initial database.
[vert.x-eventloop-thread-1] INFO  c.company.moneytransfer.util.DBUtil - Altered money_transfer table!
[vert.x-eventloop-thread-1] INFO  c.company.moneytransfer.util.DBUtil - Altered money_transfer table!
[vert.x-eventloop-thread-1] INFO  c.company.moneytransfer.util.DBUtil - Inserted sample row into the user table!
[vert.x-eventloop-thread-1] INFO  c.company.moneytransfer.util.DBUtil - Inserted sample row into the user table!
[vert.x-eventloop-thread-1] INFO  c.company.moneytransfer.util.DBUtil - Inserted sample row into the account table!
[vert.x-eventloop-thread-1] INFO  c.company.moneytransfer.util.DBUtil - Inserted sample row into the account table!
[vert.x-eventloop-thread-1] INFO  c.company.moneytransfer.util.DBUtil - Created sample database schema!
[vert.x-eventloop-thread-1] INFO  c.company.moneytransfer.util.DBUtil - Sample DB rows populated for user and account tables!

NOT : If you receive "java.net.BindException" then find and kill the running process on port 9090 of WIN10 OS.
$ Failed to deploy : java.net.BindException: Address already in use: bind

$ netstat -nao | find "9090"
TCP    0.0.0.0:9090           0.0.0.0:0              LISTENING       9292
TCP    [::]:9090              [::]:0                 LISTENING       9292

$ taskkill /PID 9292 /F
SUCCESS: The process with PID 9292 has been terminated.

Java 11
vertx-core
vertx-web
vertx-jdbc-client
vertx-unit
vertx-junit5
hsqldb
logback-classic
maven
vertx-maven-plugin

CREATE TABLE user(id INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 1, INCREMENT BY 1) PRIMARY KEY, name varchar(255));
CREATE TABLE account(id INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 1, INCREMENT BY 1) PRIMARY KEY, userId integer NOT NULL, balance DECIMAL(10,2) NOT NULL );
CREATE TABLE money_transfer(id INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 1, INCREMENT BY 1) PRIMARY KEY, fromAccountId integer NOT NULL, toAccountId integer NOT NULL, amount DECIMAL(10,2) NOT NULL, currency varchar(50) NOT NULL, transaction_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP);
ALTER TABLE account ADD FOREIGN KEY(userId) REFERENCES user(id);
ALTER TABLE money_transfer ADD FOREIGN KEY(fromAccountId) REFERENCES account(id);
ALTER TABLE money_transfer ADD FOREIGN KEY(toAccountId) REFERENCES account(id);

user = Stores user details information
account = Stores accounts of users and balance information for each account
money_transfer = Join table for sender, receiver accounts and transfer amount with currency

• When the Vert.x application starts in memory hsqldb is initialized and loaded with test data
  

• Application can be started directly with the execution of main method inside the com.company.moneytransfer.AppMain class.
  

Method : HTTP.GET
URL : http://localhost:9090/api/users

Input Test Data : No input just fire the request.

Request Body :

{
}

Curl Request :

curl --location --request GET 'http://localhost:9090/api/users' \
--header 'Content-Type: application/json' \
--data-raw '{
}'

Response :

HTTP response code 200

[
    {
        "ID": 1,
        "NAME": "user1"
    },
    {
        "ID": 2,
        "NAME": "user2"
    }
]

Method : HTTP.GET
URL : http://localhost:9090/api/users/:id
URL : http://localhost:9090/api/users/1

Input Test Data : No input just fire the request. "id" field contains user information for the specific user.

Request Body :

{
}

Curl Request :

curl --location --request GET 'http://localhost:9090/api/users/1' \
--header 'Content-Type: application/json' \
--data-raw '{
}'

Response :

HTTP response code 200

{
    "ID": 1,
    "name": "user1"
}

Method : HTTP.GET
URL : http://localhost:9090/api/accounts/:userid
URL : http://localhost:9090/api/accounts/1

Input Test Data : No input just fire the request. "userid" field contains user information for the specific user.

Request Body :

{
}

Curl Request :

curl --location --request GET 'http://localhost:9090/api/accounts/1' \
--header 'Content-Type: application/json' \
--data-raw '{
}'

Response :

HTTP response code 200

[
    {
        "ID": 1,
        "USERID": 1,
        "BALANCE": 100
    }
]

Method : HTTP.POST
URL : http://localhost:9090/api/transfer

Input Test Data : Provide required fields for transfer operation.

Request Body :

{
	"fromAccountId": 1,
	"toAccountId": 2,
	"amount": 100,
	"currency": "GBP"
}

Curl Request :

curl --location --request POST 'http://localhost:9090/api/transfer' \
--header 'Content-Type: application/json' \
--data-raw '{
	"fromAccountId": 1,
	"toAccountId": 2,
	"amount": 100,
	"currency": "GBP"
}'

Response :

HTTP response code 200

{
    "transferResult": "Money transfer completed successfully!",
    "SenderAccountDetails": {
        "status": "ok",
        "id": 1,
        "userId": 1,
        "balance": 0.00
    },
    "ReceiverAccountDetails": {
        "status": "ok",
        "id": 2,
        "userId": 2,
        "balance": 300.00
    }
}

Method : HTTP.GET
URL : http://localhost:9090/api/transfer/:accountid
URL : http://localhost:9090/api/transfer/1

Input Test Data : No input just fire the request. "accountid" field contains account information for the specific account.

Request Body :

{
}

Curl Request :

curl --location --request GET 'http://localhost:9090/api/transfer/1' \
--header 'Content-Type: application/json' \
--data-raw '{
}'

Response :

HTTP response code 200

[
    {
        "ID": 1,
        "FROMACCOUNTID": 1,
        "TOACCOUNTID": 2,
        "AMOUNT": 100.00,
        "CURRENCY": "GBP",
        "TRANSACTION_DATE": "2022-03-20T14:24:22.749"
    }
]