server:
  port: 6041

# 配置数据源
dataSource:
  db1:
    # 与数据库名可用保持一致
    schema: stu
    jdbcUrl: jdbc:mysql://localhost:3306/stu?useUnicode=true&characterEncoding=utf8&autoReconnect=true&rewriteBatchedStatements=true
    driverClassName: com.mysql.cj.jdbc.Driver
    username: root
    password: root

mybatis:
  db1:
    mappers:
      - "com.myapp.demo.dao.*"
      # 指定mybatis xml文件存放目录
      - "classpath:mybatis/mapper/*.xml"
    configuration:
      cacheEnabled: false
      mapUnderscoreToCamelCase: true
    globalConfig:
      logicNotDeleteValue: "0"
      disableSqlAnnotation: false
    plugins:
      - sqlFormatterPlugin:
          # 开启
          enable: true
          class: "com.gitee.fastmybatis.core.support.plugin.SqlFormatterPlugin"
          appendDelimiter: true
          delimiter: ";"
          useDruid: false
          format: "====== SQL ======\n%s"


solon.logging.appender:
  console:
    level: INFO

# 记录器级别的配置示例
solon.logging.logger:
  "root": #默认记录器配置
    level: INFO
  "com.zaxxer.hikari":
    level: WARN

@Controller
public class DemoController {

    @Db("db1")
    TUserMapper mapper;

    /**
     * http://localhost:6041/index
     *
     * @return
     */
    @Mapping("index")
    public TUser index() {
        return mapper.getById(6);
    }

    /**
     * http://localhost:6041/index2
     *
     * @return
     */
    @Mapping("index2")
    public List<TUser> index2() {
        Query query = new Query()
                .in("id", Arrays.asList(4, 5, 6));
        return mapper.list(query);
    }
}