查询模板【mapper】

sql筛选条件

{s-if:currentMonthS} sql条件 {e-if:currentMonthS}

仅Sql语句（onlySqlList=true）模式

{
  "diffTableNo": 0,
  "isRESTful": true,
  "base": {
    "connName": "ConnBt",
    "isRearEnd": true,
    "isFrontEnd": true
  },
  "responseField": {
    "level": {
      "guidMethod": "None",
      "dataFromType": "Database",
      "isList": true,
      "onlySqlList": true,
      "selectSql": {
        "auth": false,
        "list": "select keyword from bt_keywords where LOCATE(@keyword,keyword)>0"
      }
    }
  }
}

仅Sql语句（onlySqlList=true）+nodejs模式

{
    "diffTableNo": 0,
    "isRESTful": true,
    "base": {
      "connName": "ConnIdc",
      "isRearEnd": true,
      "isFrontEnd": true
    },
    "responseField": {
      "level": {
        "guidMethod": "None",
        "dataFromType": "Database",
        "njcArgs": {
          "moduleName": "~/Config/AppNodeJs/idc-plugins/dcim-tj-warm/level-query",
          "functionName": ""
        },
        "njcResult": {
          "moduleName": "~/Config/AppNodeJs/idc-plugins/dcim-tj-warm/level",
          "functionName": ""
        },
        "isList": true,
        "onlySqlList": true,
        "selectSql": {
          "auth": false,
          "list": "select group_id,data_date,level_yb,level_cy,level_zy,level_yz from idc_resource_statistics_warm_level where group_id=@spaceId and data_date=@_currentMonthS",
          "listField": "*",
          "pageField": "*",
          "detailField": "*"
        },
        "mock": {
          "list": "~/App_Data/idc/mock/api/v3/dcim-tj-warm/list/res/level.json"
        }
      }
    }
  }