mapper_{mkey}_sql__responsefield.json

mapper_mall-commodity-user_sql__responsefield.json

{
  "responseField": {
    "global": {
      "dataFromType": "Database",
      "show": "cu_id",
      "auth": true
    },
    // #region 提供给前端 使用，不需要auth
    "op_detail": {
      "guidMethod": "None",
      "guidMethodSn": "none",
      "dataFromType": "Database",
      "dataFromTypeSn": "database",
      "extend": "basis_detail",
      "auth": false,
      "bridgeColumn": "comm_id,user_id,show_name,cu_id,is_like",
      "viewCountClosed": true,
      //// #region 自定义保存SQL语句
      "saveSql": {
        "insert": "insert into mall_commodity_user (cu_id,comm_id,show_name,is_like,user_id,modify_date) values  (@_primaryIdV,@commId,@_userPushName,@isLike,@_userId,@_currentDate)",
        "modify": "update mall_commodity_user set is_like=@isLike,modify_date=@_currentDate,show_name=@_userPushName where comm_id=@commId and user_id=@_userId",
        "update": "",
        "updateA": "",
        "insertA": "",
        "modifyB": "",
        "modifyA": "",
        "delete": "",
        "deleteA": ""
      },
      // #endregion 自定义保存SQL语句,
      // 获取唯一ID
      "where": "select cu_id from mall_commodity_user where user_id=@_userId and comm_id=@commId",
      //"saveSqlPrimary": {
      //  //"primaryWhere": " monitor_id = @monitorId and data_date = @dataDate  ",
      //  "primaryWhere": " comm_id = @commId and user_id = @_userId ",
      //  "primaryColumn": [
      //    {
      //      "colName": "comm_id",
      //      "field": "commId", //存储子表里面关联主表对应的字段列
      //      "isIdentity": false,
      //      "primaryColumn": "comm_id",
      //      "primaryField": "commId", //来源主表的字段列
      //      "tableId": 1
      //    }
      //  ],
      //  "childPrimaryColumn": [
      //    {
      //      //多对多情况关联表主键
      //      "colName": "comm_id",
      //      "field": "commId",
      //      "tableId": 1
      //    },
      //    {
      //      //多对多情况关联表主键
      //      "colName": "user_id",
      //      "field": "userId",
      //      "tableId": 1
      //    }
      //  ]
      //},
      "columns": {
        "cuId": {
          //每次保存时候都重置主键，用于多列更新
          "guidMethod": "NEW_ID"
        }
      }
    }
    // #endregion 提供给前端
  }
}