group.test.js
1.88 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
'use strict';
/* jshint -W030 */
var chai = require('chai')
, expect = chai.expect
, Support = require(__dirname + '/../../support')
, Sequelize = Support.Sequelize
, DataTypes = require(__dirname + '/../../../../lib/data-types')
, current = Support.sequelize;
describe(Support.getTestDialectTeaser('Model'), function() {
describe('findAll', function () {
describe('group', function () {
it('should correctly group with attributes, #3009', function() {
var Post = current.define('Post', {
id: { type: DataTypes.INTEGER, autoIncrement: true, primaryKey: true },
name: { type: DataTypes.STRING, allowNull: false }
});
var Comment = current.define('Comment', {
id: { type: DataTypes.INTEGER, autoIncrement: true, primaryKey: true },
text: { type: DataTypes.STRING, allowNull: false }
});
Post.hasMany(Comment);
return current.sync({ force: true }).then(function() {
// Create an enviroment
return Post.bulkCreate([
{ name: 'post-1' },
{ name: 'post-2' }
]);
}).then(function(u) {
return Comment.bulkCreate([
{ text: 'Market', PostId: 1},
{ text: 'Text', PostId: 2},
{ text: 'Abc', PostId: 2},
{ text: 'Semaphor', PostId: 1},
{ text: 'Text', PostId: 1},
]);
}).then(function(p) {
return Post.findAll({
attributes: [ [ Sequelize.fn('COUNT', Sequelize.col('Comments.id')), 'comment_count' ] ],
include: [
{ model: Comment, attributes: [] }
],
group: [ 'Post.id' ]
});
}).then(function(posts) {
expect(parseInt(posts[0].get('comment_count'))).to.be.equal(3);
expect(parseInt(posts[1].get('comment_count'))).to.be.equal(2);
});
});
});
});
});