watelineJS: One Way Association

Asked May 07 '15 at 16:07

Active May 08 '15 at 06:20

Viewed 125 times

I'm using the Waterline ORM (PostgresQL adapter) with SailsJS and I have two models:

buildings:

{
  tableName: 'buildings',
  attributes: {
  id: {
    type: 'integer',
    primaryKey: true
  },
  BuildingName: {type: 'string'},
  BuildingBodyId:{model:'buildingbodies'}
}

bodybuildings:

{
  tableName: 'buildingbodies',
  id: {
    type: 'integer',
    primaryKey: true,
    required: true
  },
  RequiedBeInField: {type: 'integer'},
  BuildingViewState: {type: 'string'}
};

I trying to return all buildings and use next query:

buildings.find({
  select:['id','BuildingName','BuildingBodyId']})
  .populate('BuildingBodyId')

It's return to result:

 {
     "BuildingBodyId":{
       "id":2,
       "createdAt":"2015-05-07T12:46:55.501Z", 
       "updatedAt":"2015-05-07T12:46:55.501Z"},
     "id":1,
     "BuildingName":"YellowTeaField"
 }

i.e. BuildingBodyId return without RequiedBeInField and BuildingViewState. Can anyone give me a tip on how to get these two tables with all parameters? Thanks.

edited May 08 '15 at 06:20

asked May 07 '15 at 16:07

shoom

i have had that problem before but I end up finding that my model did not have these values. check your database to see if they exist.also try adding requred:true in the …odel field – Evilsanta May 07 '15 at 18:03
Thanks for answer Evilsanta. But database has all values. – shoom May 08 '15 at 06:27
1

select() is unstable method. – zieglar May 08 '15 at 06:31
@shoom try using required:true with these attributes in the requiredbeinfield – Evilsanta May 08 '15 at 08:01
Evilsanta, it didn't help. – shoom May 08 '15 at 08:47

watelineJS: One Way Association

0 Answers0