多层关系的表查询问题，只能获取主表跟子表的数据，没有返回子表与子表关联的数据

{
  "tb_newbee_mall_order": {
    "@method": "GET",
    "order_id": "14"
  },
  "tb_newbee_mall_user": {
    "@method": "GET",
    "user_id@": "tb_newbee_mall_order/user_id"
  },
  "tb_newbee_mall_order_item[]": {
    "tb_newbee_mall_order_item": {
      "order_id@": "tb_newbee_mall_order/order_id"
    },
    "@method": "GET"
  },
  "tb_newbee_mall_goods_info[]": {
    "tb_newbee_mall_goods_info": {
      "goods_id@": "tb_newbee_mall_order_item/goods_id"
    },
    "@method": "GET"
  },
  "tb_newbee_mall_goods_category[]": {
    "tb_newbee_mall_goods_category": {
      "category_id@": "tb_newbee_mall_goods_info/goods_category_id"
    },
    "@method": "GET"
  }
}

**返回的数据
** {
  "tb_newbee_mall_order": {
    "order_id": 14,
    "order_no": "15692291639125640",
    "user_id": 6,
    "total_price": 9046,
    "pay_status": 1,
    "pay_type": 2,
    "pay_time": "2019-09-23 16:59:32",
    "order_status": -1,
    "extra_info": "",
    "user_name": "",
    "user_phone": "",
    "user_address": "杭州市西湖区xx小区x幢419 十三 137xxxx2709",
    "is_deleted": 0,
    "create_time": "2019-09-23 16:59:23",
    "update_time": "2019-09-23 16:59:40"
  },
  "tb_newbee_mall_user": {
    "user_id": 6,
    "nick_name": "测试用户1",
    "login_name": "13711113333",
    "password_md5": "dda01dc6d334badcd031102be6bee182",
    "introduce_sign": "测试用户1",
    "address": "上海浦东新区XX路XX号 999 137xxxx7797",
    "is_deleted": 1,
    "locked_flag": 0,
    "create_time": "2019-08-29 10:51:39"
  },
  "tb_newbee_mall_order_item[]": [
    {
      "order_item_id": 22,
      "order_id": 14,
      "goods_id": 10158,
      "goods_name": "无印良品 女式粗棉线条纹长袖T恤",
      "goods_cover_img": "/goods-img/5488564b-8335-4b0c-a5a4-52f3f03ee728.jpg",
      "selling_price": 70,
      "goods_count": 1,
      "create_time": "2019-09-23 16:59:24"
    },
    {
      "order_item_id": 23,
      "order_id": 14,
      "goods_id": 10704,
      "goods_name": "华为 HUAWEI P30 超感光徕卡三摄麒麟980AI...",
      "goods_cover_img": "/goods-img/b9e6d770-06dd-40f4-9ae5-31103cec6e5f.jpg",
      "selling_price": 3988,
      "goods_count": 1,
      "create_time": "2019-09-23 16:59:24"
    },
    {
      "order_item_id": 24,
      "order_id": 14,
      "goods_id": 10739,
      "goods_name": "华为 HUAWEI P30 Pro",
      "goods_cover_img": "/goods-img/65c8e729-aeca-4780-977b-4d0d39d4aa2e.jpg",
      "selling_price": 4988,
      "goods_count": 1,
      "create_time": "2019-09-23 16:59:24"
    }
  ],
  "ok": true,
  "code": 200,
  "msg": "success",
  "time": 1742543803092,
  "schemaMap": {}
}

**没有返回 tb_newbee_mall_goods_info ，tb_newbee_mall_goods_category 表信息
**

日志信息是这样的

onArrayParse parentPath = ; name = Tb_newbee_mall_goods_info[]; request = {"Tb_newbee_mall_goods_info":{"goods_id@":"Tb_newbee_mall_order_item/goods_id"},"@method":"GET"}

2025-03-21 03:56:43.091: AbstractParser.INFO: getPath  path = ; name = Tb_newbee_mall_goods_info[] <<<<<<<<<<<<<

2025-03-21 03:56:43.091: AbstractParser.INFO: getPath  return Tb_newbee_mall_goods_info[] >>>>>>>>>>>>>>>>

2025-03-21 03:56:43.091: AbstractParser.INFO:

getObject:  parentPath = Tb_newbee_mall_goods_info[];

name = 0; request = {"Tb_newbee_mall_goods_info":{"goods_id@":"Tb_newbee_mall_order_item/goods_id"},"@method":"GET"}

2025-03-21 03:56:43.091: AbstractParser.INFO: getPath  path = Tb_newbee_mall_goods_info[]; name = 0 <<<<<<<<<<<<<

2025-03-21 03:56:43.091: AbstractParser.INFO: getPath  return Tb_newbee_mall_goods_info[]/0 >>>>>>>>>>>>>>>>

2025-03-21 03:56:43.091: getRealMethod.INFO: GET——Tb_newbee_mall_goods_info——{"goods_id@":"Tb_newbee_mall_order_item/goods_id"}

2025-03-21 03:56:43.091: AbstractParser.INFO:

getObject:  parentPath = Tb_newbee_mall_goods_info[]/0;

name = Tb_newbee_mall_goods_info; request = {"goods_id@":"Tb_newbee_mall_order_item/goods_id"}

2025-03-21 03:56:43.091: AbstractParser.INFO: getPath  path = Tb_newbee_mall_goods_info[]/0; name = Tb_newbee_mall_goods_info <<<<<<<<<<<<<

2025-03-21 03:56:43.091: AbstractParser.INFO: getPath  return Tb_newbee_mall_goods_info[]/0/Tb_newbee_mall_goods_info >>>>>>>>>>>>>>>>

2025-03-21 03:56:43.091: getRealMethod.INFO: GET——goods_id@——Tb_newbee_mall_order_item/goods_id

2025-03-21 03:56:43.091: AbstractParser.INFO: <<<<<<<<<<<<<<<

getValueByPath  valuePath = Tb_newbee_mall_order_item/goods_id

<<<<<<<<<<<<<<<<<<

2025-03-21 03:56:43.091: AbstractParser.INFO: getValueByPath  return null;

2025-03-21 03:56:43.091: AbstractObjectParser.INFO: onParse targetPath = Tb_newbee_mall_order_item/goods_id; target = null

2025-03-21 03:56:43.091: AbstractParser.DEBUG:

onArrayParse <<<<<<<<<<<<<<<<<<<<<<<<<<<<

for (int i = 0; i < (isSubquery ? 1 : size); i++)  startTime = 1742543803091; endTime = 1742543803091; duration = 0

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

2025-03-21 03:56:43.091: AbstractParser.DEBUG: onArrayParse  query = null; count = null; page = null; join = null

2025-03-21 03:56:43.091: AbstractParser.DEBUG: onArrayParse  size = 20000; page = 0

2025-03-21 03:56:43.092: AbstractParser.INFO: onArrayParse  return response =

[]

>>>>>>>>>>>>>>>

2025-03-21 03:56:43.091: AbstractParser.ERROR: onJoinParse  set == null || set.isEmpty() >> return null;

2025-03-21 03:56:43.091: AbstractObjectParser.DEBUG: AbstractObjectParser  parentPath = Tb_newbee_mall_goods_info[]; name = 0; table = 0; alias = null

2025-03-21 03:56:43.091: AbstractObjectParser.DEBUG: AbstractObjectParser  type = 1; isTable = false; isArrayMainTable = false

2025-03-21 03:56:43.091: AbstractObjectParser.DEBUG: AbstractObjectParser  isEmpty = false; tri = false; drop = false

2025-03-21 03:56:43.091: AbstractObjectParser.DEBUG: AbstractObjectParser  parentPath = Tb_newbee_mall_goods_info[]/0; name = Tb_newbee_mall_goods_info; table = Tb_newbee_mall_goods_info; alias = null

2025-03-21 03:56:43.091: AbstractObjectParser.DEBUG: AbstractObjectParser  type = 2; isTable = true; isArrayMainTable = true

2025-03-21 03:56:43.091: AbstractObjectParser.DEBUG: AbstractObjectParser  isEmpty = false; tri = false; drop = false

2025-03-21 03:56:43.091: AbstractObjectParser.DEBUG: onParse  target == null  >>  return true;

2025-03-21 03:56:43.092: AbstractObjectParser.ERROR: onParse  isTable && (key.startsWith(@) == false || JSONRequest.TABLE_KEY_LIST.contains(key)) >>  return null;

2025-03-21 03:56:43.092: AbstractParser.DEBUG:

onArrayParse <<<<<<<<<<<<<<<<<<<<<<<<<<<<

isExtract >> putQueryResult  startTime = 1742543803092; endTime = 1742543803092; duration = 0

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

2025-03-21 03:56:43.092: AbstractParser.DEBUG: onArrayParse  query = null; count = null; page = null; join = null

2025-03-21 03:56:43.092: AbstractParser.DEBUG: onArrayParse  size = 20000; page = 0

2025-03-21 03:56:43.092: AbstractParser.ERROR: onJoinParse  set == null || set.isEmpty() >> return null;

2025-03-21 03:56:43.092: AbstractObjectParser.DEBUG: AbstractObjectParser  parentPath = Tb_newbee_mall_goods_category[]; name = 0; table = 0; alias = null

2025-03-21 03:56:43.092: AbstractObjectParser.DEBUG: AbstractObjectParser  type = 1; isTable = false; isArrayMainTable = false

2025-03-21 03:56:43.092: AbstractObjectParser.DEBUG: AbstractObjectParser  isEmpty = false; tri = false; drop = false

2025-03-21 03:56:43.092: AbstractObjectParser.DEBUG: AbstractObjectParser  parentPath = Tb_newbee_mall_goods_category[]/0; name = Tb_newbee_mall_goods_category; table = Tb_newbee_mall_goods_category; alias = null

2025-03-21 03:56:43.092: AbstractObjectParser.DEBUG: AbstractObjectParser  type = 2; isTable = true; isArrayMainTable = true

2025-03-21 03:56:43.092: getRealMethod.INFO: CRUD——Tb_newbee_mall_goods_category[]——{"Tb_newbee_mall_goods_category":{"category_id@":"Tb_newbee_mall_goods_info/goods_category_id"},"@method":"GET"}

2025-03-21 03:56:43.092: AbstractObjectParser.DEBUG: AbstractObjectParser  isEmpty = false; tri = false; drop = false

2025-03-21 03:56:43.092: AbstractObjectParser.DEBUG: onParse  target == null  >>  return true;

2025-03-21 03:56:43.092: getRealMethod CRUD.INFO: GET

2025-03-21 03:56:43.092: AbstractObjectParser.ERROR: onParse  isTable && (key.startsWith(@) == false || JSONRequest.TABLE_KEY_LIST.contains(key)) >>  return null;

2025-03-21 03:56:43.092: AbstractParser.INFO:

2025-03-21 03:56:43.092: AbstractParser.DEBUG:

GVP 腾讯开源/APIJSON

内容风险标识

评论 (1)

GVP腾讯开源/APIJSON

内容风险标识