[스프링부트] 18. 상점 v1 더미데이터

더미 데이터 세팅

insert into store_tb(name, stock, price) values ('바나나', 40, 3000);
insert into store_tb(name, stock, price) values ('딸기', 45, 2000);

insert into log_tb(store_id, qty, total_price, buyer) values (1, 5, 15000, 'ssar');
insert into log_tb(store_id, qty, total_price, buyer) values (1, 5, 15000, 'ssar');
insert into log_tb(store_id, qty, total_price, buyer) values (2, 5, 10000, 'cos');

README.md

# Table Setting

## store_tb

```sql
create table store_tb (
        id integer generated by default as identity,
        price integer,
        stock integer,
        name varchar(255),
        primary key (id)
    )
```

## log_tb

```sql
   create table log_tb (
        id integer generated by default as identity,
        qty integer,
        store_id integer,
        total_price integer,
        buyer varchar(255),
        primary key (id)
    )
    ```

application.properties

# vscode console highlight
spring.output.ansi.enabled=always
# utf-8
server.servlet.encoding.charset=utf-8
server.servlet.encoding.force=true
# DB
spring.datasource.driver-class-name=org.h2.Driver
spring.datasource.url=jdbc:h2:mem:test
spring.datasource.username=sa
spring.datasource.password=
spring.h2.console.enabled=true
# JPA table create or none (create : 실행할 때 테이블 생성o, none : 실행할 때 테이블 생성x)
spring.jpa.hibernate.ddl-auto=create
# query log
spring.jpa.show-sql=true
# dummy data
spring.sql.init.data-locations=classpath:db/data.sql
# create dummy data  after ddl-auto create
spring.jpa.defer-datasource-initialization=true
# mustache request expose
spring.mustache.servlet.expose-request-attributes=true
# sql formatter
spring.jpa.properties.hibernate.format_sql=true