/ShopOfHan

Primary LanguageJava

Shop of Han

Build Status

codecov

BCH compliance

https://bettercodehub.com/

A hanfak.shopofhan.domain driven example of a shop to help learn the technologies used at work.

http://localhost:8081/productscheck?productName=Joy%20Of%20Java

Running mySql via docker

docker network create --driver=bridge --subnet=192.168.127.0/24 --gateway=192.168.127.1 --ip-range=192.168.127.128/25 mybridge1

From scratch docker run --name some-mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password -d mysql

docker run --name --net=mybridge mysql -e MYSQL_ROOT_PASSWORD=password -d mysql:tag

// docker run -it --link some-mysql:mysql --rm mysql sh -c 'exec mysql -h"172.17.0.3" -P"3306" -uroot -p'

If already pulled image docker start <container name>

Check containers that are not running docker ps -a

Check if working docker ps

start bash in container docker exec -it <container name> /bin/bash

Start mysql mysql -u root -p

Connect to mysql mysql -h"172.17.0.3" -P"3306" -uroot -p mysql -h"127.0.0.1" -P"3306" -uroot -p

copy and paste sql file (/home/dev/Documents/HAN/ShopOfHan/ShopOfHanSQL/priming.sql)

// TODO: script to run via docker bash

mysql -h localhost -P 3306 --protocol=tcp -uroot -p

address in use

lsof -i tcp:8081

kill -9

Hikari db pooling

not working with docker at the momentc

TODOs

  • add stock, has stock id stored as stock desc.

  • Delete a product given a product id and rest of the stock

  • Not found page

  • No servlet found

  • -db sql, foreign key constraints-

  • rethink db design, do i need a join table

  • Use a test db instead of stubs or prod db

    • Fix stub to make all tests past without filling stub first
    • Have a testStock and testPRoduct repository,
      • which acccess database and only has db methods used in test
    • Extract test stub and test db into two separate wirings,
      • just need to change properties file to decide what to use (no commenting out)

  • Test http client

  • Update a product given a json

    • use parse json to return jsonObject when unmarshalling json

  • Update stock given productid and xml

  • Logger interfaece

  • Test wiring, factory for using stubs or database by using specific property file

  • delete specific stock given stock id and product id

  • -Show all products-

  • show one stock given id

  • use wriemock and 3rd party service

  • refactor arg passed to use case to only needed not request

  • Validation for unmarshalling and /or domain objects