问如何在节点orm中创建的其他文件中使用模型对象
EN

Stack Overflow用户

提问于 2014-06-25 01:43:26

回答 1查看 671关注 0票数 0

user.js中为用户创建的模型

var orm = require("orm");

orm.connect("mysql://root:@localhost/axi_timescape", function (err, db)  {
  if (err) throw err;

    var user = db.define("axi_users", {
        name           : String,
        id             : Number,
        enterprise_id  : Number,
        location_id    :  Number, 
        email          : String,
        pin            : Number,
        job_description: String,
        password        :String,
        role            :Number,
        designation     :String,
        department_id   :Number,
        created         :String,    
        updated         :String,
 });
 module.exports.user=user;   
 });

现在，我想在patu.js中使用这个用户模型对象，但是它不允许在用户对象上使用方法。因此，如何在节点orm中创建的其他文件中使用模型对象。下面的文件是patu.js。

var orm = require('orm');
var user= require('./user.js');

exports.list = function(req, res){
  res.send('respond with a resource');
};


 user.find({ id: 2 }, function (err, people) {     //VIEW BY ID
         if(err)
           {
             console.log(err);
              return;
              }

                 console.log("asad");


          console.log(JSON.stringify(people));            

    });

node-orm2

javascript

node.js

回答 1

Stack Overflow用户

回答已采纳

发布于 2014-06-25 01:57:09

按照文档，您需要这样的东西。

user.js

module.exports = function(db, callback) {
    db.define("axi_users", {
        name: String,
        id: Number,
        enterprise_id: Number,
        location_id: Number,
        email: String,
        pin: Number,
        job_description: String,
        password: String,
        role: Number,
        designation: String,
        department_id: Number,
        created: String,
        updated: String,
    });

    return callback();
}

patu.js

var orm = require("orm");
orm.connect("mysql://root:@localhost/axi_timescape", function(err, db) {
    if (err) throw err;

    db.load('./user.js', function(err) {
        if (err) throw err;

        var user = db.models.axi_users;

        user.find({
            id: 2
        }, function(err, people) { //VIEW BY ID
            if (err) {
                console.log(err);
                return;
            }

            console.log("asad");


            console.log(JSON.stringify(people));

        });
    });

});

或者如果你在用快车。

var express = require('express');
var orm = require('orm');
var app = express();

app.use(orm.express("mysql://root:@localhost/axi_timescape", {
    define: function(db, models) {
        models.user = db.define("axi_users", {
            name: String,
            id: Number,
            enterprise_id: Number,
            location_id: Number,
            email: String,
            pin: Number,
            job_description: String,
            password: String,
            role: Number,
            designation: String,
            department_id: Number,
            created: String,
            updated: String,
        });
    }
}));
app.listen(80);

app.get("/", function(req, res) {
    req.models.user.find({
        id: 2
    }, function(err, people) { //VIEW BY ID
        if (err) {
            console.log(err);
            return;
        }
        res.send(people);
    });
});