group.test.js
3.29 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
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
'use strict';
const chai = require('chai'),
expect = chai.expect,
Support = require('../../support'),
Sequelize = Support.Sequelize,
DataTypes = require('../../../../lib/data-types'),
current = Support.sequelize;
describe(Support.getTestDialectTeaser('Model'), () => {
describe('findAll', () => {
describe('group', () => {
it('should correctly group with attributes, #3009', async () => {
const Post = current.define('Post', {
id: { type: DataTypes.INTEGER, autoIncrement: true, primaryKey: true },
name: { type: DataTypes.STRING, allowNull: false }
});
const Comment = current.define('Comment', {
id: { type: DataTypes.INTEGER, autoIncrement: true, primaryKey: true },
text: { type: DataTypes.STRING, allowNull: false }
});
Post.hasMany(Comment);
await current.sync({ force: true });
// Create an enviroment
await Post.bulkCreate([
{ name: 'post-1' },
{ name: 'post-2' }
]);
await Comment.bulkCreate([
{ text: 'Market', PostId: 1 },
{ text: 'Text', PostId: 2 },
{ text: 'Abc', PostId: 2 },
{ text: 'Semaphor', PostId: 1 },
{ text: 'Text', PostId: 1 }
]);
const posts = await Post.findAll({
attributes: [[Sequelize.fn('COUNT', Sequelize.col('Comments.id')), 'comment_count']],
include: [
{ model: Comment, attributes: [] }
],
group: ['Post.id'],
order: [
['id']
]
});
expect(parseInt(posts[0].get('comment_count'), 10)).to.be.equal(3);
expect(parseInt(posts[1].get('comment_count'), 10)).to.be.equal(2);
});
it('should not add primary key when grouping using a belongsTo association', async () => {
const Post = current.define('Post', {
id: { type: DataTypes.INTEGER, autoIncrement: true, primaryKey: true },
name: { type: DataTypes.STRING, allowNull: false }
});
const Comment = current.define('Comment', {
id: { type: DataTypes.INTEGER, autoIncrement: true, primaryKey: true },
text: { type: DataTypes.STRING, allowNull: false }
});
Post.hasMany(Comment);
Comment.belongsTo(Post);
await current.sync({ force: true });
await Post.bulkCreate([
{ name: 'post-1' },
{ name: 'post-2' }
]);
await Comment.bulkCreate([
{ text: 'Market', PostId: 1 },
{ text: 'Text', PostId: 2 },
{ text: 'Abc', PostId: 2 },
{ text: 'Semaphor', PostId: 1 },
{ text: 'Text', PostId: 1 }
]);
const posts = await Comment.findAll({
attributes: ['PostId', [Sequelize.fn('COUNT', Sequelize.col('Comment.id')), 'comment_count']],
include: [
{ model: Post, attributes: [] }
],
group: ['PostId'],
order: [
['PostId']
]
});
expect(posts[0].get().hasOwnProperty('id')).to.equal(false);
expect(posts[1].get().hasOwnProperty('id')).to.equal(false);
expect(parseInt(posts[0].get('comment_count'), 10)).to.be.equal(3);
expect(parseInt(posts[1].get('comment_count'), 10)).to.be.equal(2);
});
});
});
});