javascript - 环回 - EmbedsOne 关系产生错误

Question

我有以下两个模型

Nurse

Room

房间与护士模型有 belongsTo 关系，定义如下:

"relations": {
        "nurse": {
            "model": "Nurse",
            "type": "belongsTo",
            "foreignKey": "nid"
        }
    }

它工作正常并在以下 url 上生成数据

http://localhost:3000/api/Rooms/1

http://localhost:3000/api/Rooms/1/nurse

但是当我尝试如下定义的 embedsOne 关系时:

"relations": {
        "nurse": {
            "model": "Nurse",
            "type": "embedsOne",
            "foreignKey": "nid"
        }
    }

并尝试访问 url

http://localhost:3000/api/Rooms/1

我收到以下错误:

message: "ER_BAD_FIELD_ERROR: Unknown column '_nurse' in 'field list'",

想法？

Answer 1

embedsOne 关系没有外键。您应该使用文档中所示的“属性”:( https://docs.strongloop.com/display/public/LB/Embedded+models+and+relations#Embeddedmodelsandrelations-EmbedsOne )

"relations": {
  "address": {
    "type": "embedsOne",
    "model": "Address",
    "property": "billingAddress"
  }
}

那么你的对象看起来像

 {
  id: 1,
  name: 'John Smith',
  billingAddress: {
    street: '123 Main St',
    city: 'San Jose',
    state: 'CA',
    zipCode: '95124'
  }
}