大家好,这是我第一次使用loopback进行开发 .
我在loopback中遇到关系概念的问题,直到现在让我感到困惑,我有这样的关系 .
One City Has Many Merchant
One Merchant Belongs To City
然后我像这样在loopback上实现:
City Model
{
"name": "city",
"base": "PersistedModel",
"idInjection": true,
"options": {
"validateUpsert": true,
"mysql": {
"table": "city"
}
},
"properties": {
"id": {
"type": "number",
"id": true,
"required": true,
"mysql": {
"columnName": "id",
"dataType": "INT",
"dataLength": 11
}
},
"name": {
"type": "string",
"required": true
},
"isDelete": {
"type": "number",
"required": true,
"default": 1
}
},
"validations": [],
"relations": {
"merchants": {
"type": "hasMany",
"model": "merchant",
"foreignKey": "",
"options": {
"nestRemoting": true,
"forceId": false
},
"scope": {
"include": "city"
}
}
},
"acls": [
{
"accessType": "*",
"principalType": "ROLE",
"principalId": "$everyone",
"permission": "ALLOW"
}
],
"methods": {}
}
Merchant Model
{
"name": "merchant",
"base": "PersistedModel",
"idInjection": true,
"options": {
"mysql": {
"table": "merchant"
},
"validateUpsert": true
},
"properties": {
"id": {
"type": "number",
"id": true,
"required": true,
"mysql": {
"columnName": "id",
"dataType": "INT",
"dataLength": 1
}
},
"merchantName": {
"type": "string",
"required": true,
"mysql": {
"columnName": "merchantName",
"dataType": "VARCHAR",
"dataLength": 100
}
},
"longitude": {
"type": "string",
"required": true,
"mysql": {
"columnName": "longitude",
"dataType": "VARCHAR",
"dataLength": 45
}
},
"latitude": {
"type": "string",
"required": true,
"mysql": {
"columnName": "latitude",
"dataType": "VARCHAR",
"dataLength": 45
}
},
"telephone": {
"type": "string",
"required": true,
"mysql": {
"columnName": "telephone",
"dataType": "VARCHAR",
"dataLength": 45
}
},
"isDelete": {
"type": "number",
"required": true,
"default": 1,
"mysql": {
"columnName": "isDelete",
"dataType": "INT",
"dataLength": 1
}
}
},
"validations": [],
"relations": {
"city": {
"type": "belongsTo",
"model": "city",
"foreignKey": ""
}
},
"acls": [
{
"accessType": "*",
"principalType": "ROLE",
"principalId": "$everyone",
"permission": "ALLOW"
}
],
"methods": {}
}
然后我可以使用包含在这样的查询网址获取城市中的商家列表 .
list merchant in city
但我不能像这样在商人那里得到细节之城 .
那么如何在商家中获得细节城市?