Skip to content

Instantly share code, notes, and snippets.

@p-baleine
Created November 29, 2013 08:59
  • Star 18 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
Star You must be signed in to star a gist
Embed
What would you like to do?
Bookshelf polymorphic association example.

Migrate

$ ./node_modules/.bin/knex:migrate:latest -c db/config.js
module.exports = {
directory: './db/migrations',
database: {
client: 'sqlite3',
connection: {
filename: './db/bookshelf-polymorphic-association.db'
}
}
};
exports.up = function(knex, Promise) {
return Promise.all([
knex.schema.createTable('employees', function(t) {
t.increments('id').primary();
t.string('name');
}),
knex.schema.createTable('products', function(t) {
t.increments('id').primary();
t.string('name');
}),
knex.schema.createTable('pictures', function(t) {
t.increments('id').primary();
t.string('name');
t.integer('imageable_id').notNull();
t.string('imageable_type').notNull();
})
]);
};
exports.down = function(knex, Promise) {
return Promise.all([
knex.schema.dropTable('employees'),
knex.schema.dropTable('products'),
knex.schema.dropTable('pictures')
]);
};
var config = require('./db/config').database,
Bookshelf = require('bookshelf').initialize(config);
var Employee = Bookshelf.Model.extend({
tableName: 'employees',
pictures: function() {
return this.morphMany(Picture, 'imageable');
}
});
var Product = Bookshelf.Model.extend({
tableName: 'products',
pictures: function() {
return this.morphMany(Picture, 'imageable');
}
});
var Picture = Bookshelf.Model.extend({
tableName: 'pictures',
imageable: function() {
return this.morphTo('imageable', Employee, Product);
}
});
// Employeeを作成
new Employee({ name: 'hoge' }).save()
// employeeのPictureを作成
.then(function(employee) {
var picture = new Picture({
name: 'employee\'s picture',
imageable_id: employee.id,
imageable_type: 'employees'
});
return [picture.save(), employee];
})
// employeeをPicture毎フェッチしてみる
.spread(function(picture, employee) {
return employee.fetch({ withRelated: ['pictures'] });
})
.tap(function(employee) {
console.log(employee.toJSON());
})
// 今度はProductを作成
.then(function() {
return new Product({ name: 'piyo' }).save();
})
// productのPictureを作成
.then(function(product) {
var picture = new Picture({
name: 'product\'s picture',
imageable_id: product.id,
imageable_type: 'products'
});
return [picture.save(), product];
})
// productをPicture毎フェッチしてみる
.spread(function(picture, product) {
return product.fetch({ withRelated: ['pictures'] });
})
.tap(function(employee) {
console.log(employee.toJSON());
})
.then(function() {
process.exit();
});
{
"name": "bookshelf-polymorphic-association",
"version": "0.0.0",
"description": "",
"main": "index.js",
"scripts": {
"test": "echo \"Error: no test specified\" && exit 1"
},
"author": "",
"license": "MIT",
"dependencies": {
"bookshelf": "~0.6.1",
"knex": "git+https://github.com/tgriesser/knex.git",
"sqlite3": "~2.1.19"
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment