agamvrinos / wdm-spring-microservices Goto Github PK

we haven't specified yet what the responses to the requests look like

for example for the endpoint /users/credit/{id}
should I just return the integer as raw text or a json struct {"credit": x}?

should we just all agree to always return json with the information requested as keys?

Create a schema.sql file under the /resources directory of the corresponding project/microservice and define the following tables:

Users Module

1. users -> Fields: id, name, credit

Payments Module

1. payments -> Fields: id, user_id, order_id, status

Stocks Module

1. items -> Fields: id, stock, price

Orders Module

1. order_items -> Fields: order_id, item_id, number
2. order -> Fields: id, total, user_id

Also create a data.sql file under /resources with insert statements for the related mock data of each table (for each microservice).

1. The names of the tables should be in lowercase since spring data seems to automatically do this regardless of what we pass. Thus, if a table contains capital letters it cannot match the table with the corresponding entity.

2. The id field of each table should automatically be incremented (check serial in postgresql)

This should be in new branches

The configuration server should also be added to the CouchDB subproject.

NOTE! The Spring Cloud dependencies are NOT the same as the Postgres project, due to downgraded Spring Boot version.

Create a transaction like behaviour in CouchDB.

idea:
after population user/stock data record total user credit and total stock value
run stresstest
compute again total user credit and total stock value and check the deltas

This will be done once all microservices have been merged @master.

Need to find more info on how to setup a local couchDB and look for possible related spring-boot libraries.

Resources should be posted here.

Investigate and replace with @OneToMany + automatic deletion