dresende / node-orm2

Object Relational Mapping
http://github.com/dresende/node-orm2
MIT License
3.07k stars 379 forks source link

orm2 can support table alias? #651

Closed qiangzi109901 closed 8 years ago

qiangzi109901 commented 8 years ago

now, mysql has a table named 'qz_blog'


//normal defined
var Blog = db.define('qz_blog', {
    id          : Number,
    title       : String,
    content     : String,
    type        : Number, 
    create_time : Date,
    abstract    : String
  },

but I want define this model named 'blog',just like this


//define demo
var Blog = db.define('blog', {
    id          : Number,
    title       : String,
    content     : String,
    type        : Number, 
    create_time : Date,
    abstract    : String
  },

//use  demo
req.models.blog.get(425,function(err,blog){
    if(err) throw err;
    res.render('index',{
        title : '首页',
        blog : blog
    });
});

How can I do it?

dxg commented 8 years ago

Try:

var Blog = db.define('blog', {
    id          : Number,
    title       : String,
    content     : String,
    type        : Number, 
    create_time : Date,
    abstract    : String
  },
  {
    collection: "qz_blog"
  }

From lib/ORM.js#L230

qiangzi109901 commented 8 years ago

ok,thank you for your suggestion