水线-定向数据库 - 双向边缘

Question

我在 Sails 中声明了两个模型，我使用的是 Waterline-Orientdb 适配器，不知道如何通过双向边缘连接它们

问题模型

var Waterline = require('waterline');
module.exports = Waterline.Collection.extend({
  tableName: 'questionsTable',
  identity: 'questions',
  connection: 'associations',
  attributes: {
    id: { type: 'string', primaryKey: true, columnName: '@rid'},
    question  : { type: 'string'},
    user: { model: "User", required: true },
    answerOptions: {type: 'json'},
    imagefile: {type:'string'},
    answers: {
      collection: 'answer',
      via: 'questions',
      dominant:true
    }
  }
});

应答模型

var Waterline = require('waterline');
module.exports = Waterline.Collection.extend({
    tableName: 'answerTable',
    identity: 'answer',
    connection: 'associations',
    attributes: {
        id: {
            type: 'string',
            primaryKey: true,
            columnName: '@rid'
        },
        Answer: {
            type: 'string'
        },
        questions: {
            collection: 'questions',
            via: 'answer'
        }
    }
});

我希望能够在两个模型之间创建边缘。用户创建一个问题，然后用户可以发布响应。

Answer 1

您的答案模型上有拼写错误：

questions: {
  collection: 'questions',
  via: 'answer'
}

应该是

questions: {
  collection: 'questions',
  via: 'answers'  // answers as that is the attribute name in questions model
}

创建问题、答案然后链接它们的示例：

var question1;
ontology.collections.questions.create({ question: 'question1' })
  .then(function(question){
    question1 = question;
    return ontology.collections.answer.create([{ answer: 'answer1' }, { answer: 'answer2' }]);
  })
  .then(function(answers){
    question1.answers.add(answers[0]);
    question1.answers.add(answers[1]);
    return question1.save();
  })

我在 github.com/appscot/waterline-orientdb 创建了一个运行示例。

问候

更新：waterline-orientdb现在被命名为sails-orientdb。