ledger.test.js 6.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155
  1. /**
  2. * 标段--台账 模型 单元测试
  3. *
  4. * @author Mai
  5. * @date 2017/12/1
  6. * @version
  7. */
  8. 'use strict';
  9. /* const testNodeData = [
  10. { ledger_id: 1, ledger_pid: -1, order: 1, level: 1, full_path: '1', code: '1' },
  11. { ledger_id: 2, ledger_pid: 1, order: 1, level: 2, full_path: '1.2', code: '1-1' },
  12. { ledger_id: 6, ledger_pid: 2, order: 1, level: 3, full_path: '1.2.6', code: '1-1-1' },
  13. { ledger_id: 7, ledger_pid: 6, order: 1, level: 4, full_path: '1.2.6.7', code: '202-1' },
  14. { ledger_id: 10, ledger_pid: 7, order: 2, level: 5, full_path: '1.2.6.7.10', code: '202-1-a' },
  15. { ledger_id: 9, ledger_pid: 7, order: 1, level: 5, full_path: '1.2.6.7.9', code: '202-1-b' },
  16. { ledger_id: 8, ledger_pid: 6, order: 2, level: 4, full_path: '1.2.6.8', code: '202-2' },
  17. { ledger_id: 11, ledger_pid: 8, order: 1, level: 5, full_path: '1.2.6.8.11', code: '202-2-c' },
  18. { ledger_id: 12, ledger_pid: 8, order: 2, level: 5, full_path: '1.2.6.8.12', code: '202-2-e' },
  19. { ledger_id: 13, ledger_pid: 2, order: 2, level: 3, full_path: '1.2.13', code: '1-1-2' },
  20. { ledger_id: 14, ledger_pid: 2, order: 3, level: 3, full_path: '1.2.14', code: '1-1-3' },
  21. { ledger_id: 3, ledger_pid: 1, order: 2, level: 2, full_path: '1.3', code: '1-2' },
  22. { ledger_id: 4, ledger_pid: 1, order: 3, level: 2, full_path: '1.4', code: '1-3' },
  23. { ledger_id: 5, ledger_pid: 1, order: 4, level: 2, full_path: '1.5', code: '1-4' },
  24. ];*/
  25. const testNodeData = [
  26. { ledger_id: 1, ledger_pid: -1, order: 1, level: 1, full_path: '1', code: '1', is_leaf: false },
  27. { ledger_id: 2, ledger_pid: 1, order: 1, level: 2, full_path: '1.2', code: '1-1', is_leaf: false },
  28. { ledger_id: 6, ledger_pid: 2, order: 1, level: 3, full_path: '1.2.6', code: '1-1-1', is_leaf: false },
  29. { ledger_id: 7, ledger_pid: 6, order: 1, level: 4, full_path: '1.2.6.7', code: '202-1', is_leaf: false },
  30. { ledger_id: 10, ledger_pid: 7, order: 2, level: 5, full_path: '1.2.6.7.10', code: '202-1-a', is_leaf: true },
  31. { ledger_id: 9, ledger_pid: 7, order: 1, level: 5, full_path: '1.2.6.7.9', code: '202-1-b', is_leaf: true },
  32. { ledger_id: 8, ledger_pid: 6, order: 2, level: 4, full_path: '1.2.6.8', code: '202-2', is_leaf: false },
  33. { ledger_id: 11, ledger_pid: 8, order: 1, level: 5, full_path: '1.2.6.8.11', code: '202-2-c', is_leaf: true },
  34. { ledger_id: 12, ledger_pid: 8, order: 2, level: 5, full_path: '1.2.6.8.12', code: '202-2-e', is_leaf: true },
  35. { ledger_id: 13, ledger_pid: 2, order: 2, level: 3, full_path: '1.2.13', code: '1-1-2', is_leaf: true },
  36. { ledger_id: 14, ledger_pid: 2, order: 3, level: 3, full_path: '1.2.14', code: '1-1-3', is_leaf: true },
  37. { ledger_id: 3, ledger_pid: 1, order: 2, level: 2, full_path: '1.3', code: '1-2', is_leaf: false },
  38. { ledger_id: 15, ledger_pid: 3, order: 1, level: 3, full_path: '1.3.15', code: '1-2-1', is_leaf: true },
  39. { ledger_id: 4, ledger_pid: 1, order: 3, level: 2, full_path: '1.4', code: '1-3', is_leaf: false },
  40. { ledger_id: 16, ledger_pid: 4, order: 1, level: 3, full_path: '1.4.16', code: '1-3-1', is_leaf: true },
  41. { ledger_id: 5, ledger_pid: 1, order: 4, level: 2, full_path: '1.5', code: '1-4', is_leaf: true },
  42. ];
  43. const testTenderId = 3;
  44. const { app, assert } = require('egg-mock/bootstrap');
  45. const findById = function (nodes, Id) {
  46. const filters = nodes.filter(function (x) {
  47. return x.ledger_id === Id;
  48. });
  49. return filters.length > 0 ? filters[0] : undefined;
  50. }
  51. describe('test/app/service/ledger.test.js', () => {
  52. it('clear history test data', function* () {
  53. const ctx = app.mockContext();
  54. const result = yield ctx.service.ledger.db.delete(ctx.service.ledger.tableName, { tender_id: testTenderId });
  55. assert(result.affectedRows >= 0);
  56. });
  57. it('add test data', function* () {
  58. const ctx = app.mockContext();
  59. for (const data of testNodeData) {
  60. data.tender_id = testTenderId;
  61. }
  62. const result = yield ctx.service.ledger.db.insert(ctx.service.ledger.tableName, testNodeData);
  63. assert(result.affectedRows === testNodeData.length);
  64. });
  65. it('test addNode', function* () {
  66. const ctx = app.mockContext();
  67. // 选中1-1-1,插入节点
  68. const resultData = yield ctx.service.ledger.addNode(testTenderId, 6);
  69. assert(resultData.create.length === 1);
  70. assert(resultData.update.length === 2);
  71. assert(resultData.create[0].is_leaf === 1);
  72. });
  73. it('test deleteNode', function* () {
  74. const ctx = app.mockContext();
  75. // 选中202-1,删除节点
  76. const resultData = yield ctx.service.ledger.deleteNode(testTenderId, 7);
  77. assert(resultData.delete.length === 3);
  78. assert(resultData.update.length === 1);
  79. });
  80. it('test upMoveNode', function* () {
  81. const ctx = app.mockContext();
  82. // 选中202-2-e上移
  83. let resultData = yield ctx.service.ledger.upMoveNode(testTenderId, 12);
  84. resultData.update.sort(function (x, y) {
  85. return x.order - y.order;
  86. });
  87. assert(resultData.update.length === 2);
  88. assert(resultData.update[0].code === '202-2-e');
  89. });
  90. it('test downMoveNode', function* () {
  91. const ctx = app.mockContext();
  92. // 选中202-2-e下移
  93. let resultData = yield ctx.service.ledger.downMoveNode(testTenderId, 12);
  94. resultData.update.sort(function (x, y) {
  95. return x.order - y.order;
  96. });
  97. assert(resultData.update.length === 2);
  98. assert(resultData.update[0].code === '202-2-c');
  99. });
  100. it('test upLevelNode', function* () {
  101. const ctx = app.mockContext();
  102. // 选中 1-1-2 升级
  103. let resultData = yield ctx.service.ledger.upLevelNode(testTenderId, 13);
  104. assert(resultData);
  105. assert(resultData.update.length === 5);
  106. let node = findById(resultData.update, 13);
  107. assert(node.full_path === '1.13');
  108. assert(node.ledger_pid === 1);
  109. assert(!node.is_leaf);
  110. node = findById(resultData.update, 14);
  111. assert(node.ledger_pid === 13);
  112. assert(node.full_path === '1.13.14');
  113. node = findById(resultData.update, 3);
  114. assert(node.order === 3);
  115. node = findById(resultData.update, 4);
  116. assert(node.order === 4);
  117. node = findById(resultData.update, 5);
  118. assert(node.order === 5);
  119. });
  120. it('test downLevelNode', function* () {
  121. const ctx = app.mockContext();
  122. // 选中1-3 降级
  123. let resultData = yield ctx.service.ledger.downLevelNode(testTenderId, 4);
  124. assert(resultData.update.length === 3);
  125. let node = findById(resultData.update, 4);
  126. assert(node.full_path === '1.3.4');
  127. assert(node.ledger_pid === 3);
  128. assert(node.level === 3);
  129. assert(node.order === 2);
  130. node = findById(resultData.update, 16);
  131. assert(node.level === 4);
  132. assert(node.full_path === '1.3.4.16');
  133. node = findById(resultData.update, 5);
  134. assert(node.order === 4);
  135. })
  136. });