MyBatis Playground

Configuration

1. create test scope application.yml file

test scope application.yml

spring:
  h2:
    console:
      enabled: true
  datasource:
    driver-class-name: org.h2.Driver
    url:  jdbc:h2:mem:toast_bread;MODE=PostgreSQL;DATABASE_TO_LOWER=TRUE;DEFAULT_NULL_ORDERING=HIGH
    username: sa
    password: 1111
    ### do you want to use your own local h2 db? use the following configuration ###
    #url:  jdbc:h2:tcp://localhost/~/toast_bread;MODE=PostgreSQL;DATABASE_TO_LOWER=TRUE
  sql:
    init:
      mode: always
      platform: h2

mybatis:
  # mapper.xml location
  mapper-locations: classpath:mappers/**/*.xml
  # @Alias Class package location
  type-aliases-package: coding.toast.playground
  configuration:
    # db: snake_case => java: camelCase
    map-underscore-to-camel-case: true
    default-fetch-size: 10
    default-statement-timeout: 5
    jdbc-type-for-null: null

logging:
  level:
    root: info
    coding:
      toast:
        playground: debug
    org.springframework.jdbc.core.JdbcTemplate: debug
    org.springframework.jdbc.core.StatementCreatorUtils: trace
  pattern:
    console: "%d{HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n"

some test won't work because of postgresql specific methods.
change 'platform' to 'postgres' and change database connection config to postgres!

2. create sql script for startup initialize

schema-h2.sql

create schema IF NOT EXISTS coding_toast;

drop table if exists coding_toast.address;
create table if not exists coding_toast.address
(
    city_name varchar(50) not null,
    zipcode   varchar(50) not null
);

drop table if exists coding_toast."user";
create table if not exists  coding_toast."user"
(
    id           serial
        constraint user_pk
            primary key,
    name         varchar(50) not null,
    phone_number varchar(50)
);

data-h2.sql

insert into coding_toast.address (city_name, zipcode)
values  ('New York', '00000'),
        ('California', '11111'),
        ('Texas', '22222'),
        ('Arizona', '33333'),
        ('Indiana', '44444'),
        ('Washington', '55555'),
        ('Oklahoma', '66666');

insert into coding_toast."user" (id, name, phone_number)
values  (default, 'Charlie Puth', '010-0000-0001'),
        (default, 'Brad Pitt', '010-0002-0003'),
        (default, 'Daniel Radcliffe', '010-0004-0005'),
        (default, 'Freddie Highmore', '010-0006-0007'),
        (default, 'Gary Oldman', '010-0000-0001');

codingtoastbread / mybatis-playground Goto Github PK

mybatis-playground's Introduction

MyBatis Playground

Configuration

1. create test scope application.yml file

2. create sql script for startup initialize

see also

Recommend Projects

React

Vue.js

Typescript

TensorFlow

Django

Laravel

D3

Recommend Topics

javascript

web

server

Machine learning

Visualization

Game

Recommend Org

Facebook

Microsoft

Google

Alibaba

D3

Tencent