-
Notifications
You must be signed in to change notification settings - Fork 0
/
query.page.pageBySql.test.js
42 lines (34 loc) · 1.29 KB
/
query.page.pageBySql.test.js
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
const expect = require('chai').expect;
const my = require('../../src');
const config = require('../__config/default');
const tools = require('../__tools');
const {prepareForTesting, _________________} = tools;
describe('MySQL - query/page/pageBySql', () => {
const table = 'users';
my.init(config);
prepareForTesting();
it(`.pageBySql({sql, order, pageNumber, pageSize})`, async () => {
const sql = 'select * from users';
const order = 'id';
const pageNumber = 2;
const pageSize = 3;
const result = await my.pageBySql({sql, order, pageNumber, pageSize});
expect(result.pageSize === 3 && result.count === 7).to.be.true;
});
it(`.pageBySql({sql, order, pageNumber, pageSize, data})`, async () => {
const sql = 'select * from users where isAvenger = :isAvenger';
const order = 'id';
const pageNumber = 2;
const pageSize = 3;
const data = {isAvenger: 1};
const result = await my.pageBySql({sql, order, pageNumber, pageSize, data});
expect(result.pageSize === 3 && result.count === 6).to.be.true;
});
it(`.pageBySql({sql, pageNumber, pageSize})`, async () => {
const sql = 'select * from users';
const pageNumber = 2;
const pageSize = 3;
const result = await my.pageBySql({sql, pageNumber, pageSize});
expect(result.pageSize === 3 && result.count === 7).to.be.true;
});
});