job_test.rb 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650
  1. # encoding: utf-8
  2. require 'test_helper'
  3. class JobTest < ActiveSupport::TestCase
  4. test 'case 1' do
  5. # create ticket
  6. group1 = Group.lookup(name: 'Users')
  7. group2 = Group.create_or_update(
  8. name: 'JobTest2',
  9. updated_by_id: 1,
  10. created_by_id: 1,
  11. )
  12. ticket1 = Ticket.create(
  13. title: 'job test 1',
  14. group: group1,
  15. customer_id: 2,
  16. state: Ticket::State.lookup(name: 'new'),
  17. priority: Ticket::Priority.lookup(name: '2 normal'),
  18. created_at: Time.zone.now - 3.days,
  19. updated_at: Time.zone.now - 3.days,
  20. created_by_id: 1,
  21. updated_by_id: 1,
  22. )
  23. ticket2 = Ticket.create(
  24. title: 'job test 2',
  25. group: group1,
  26. customer_id: 2,
  27. state: Ticket::State.lookup(name: 'new'),
  28. priority: Ticket::Priority.lookup(name: '2 normal'),
  29. created_at: Time.zone.now - 1.day,
  30. created_by_id: 1,
  31. updated_at: Time.zone.now - 1.day,
  32. updated_by_id: 1,
  33. )
  34. ticket3 = Ticket.create(
  35. title: 'job test 3',
  36. group: group2,
  37. customer_id: 2,
  38. state: Ticket::State.lookup(name: 'open'),
  39. priority: Ticket::Priority.lookup(name: '3 high'),
  40. created_at: Time.zone.now - 1.day,
  41. created_by_id: 1,
  42. updated_at: Time.zone.now - 1.day,
  43. updated_by_id: 1,
  44. )
  45. ticket4 = Ticket.create(
  46. title: 'job test 4',
  47. group: group2,
  48. customer_id: 2,
  49. state: Ticket::State.lookup(name: 'closed'),
  50. priority: Ticket::Priority.lookup(name: '2 normal'),
  51. created_at: Time.zone.now - 3.days,
  52. created_by_id: 1,
  53. updated_at: Time.zone.now - 3.days,
  54. updated_by_id: 1,
  55. )
  56. ticket5 = Ticket.create(
  57. title: 'job test 5',
  58. group: group2,
  59. customer_id: 2,
  60. state: Ticket::State.lookup(name: 'open'),
  61. priority: Ticket::Priority.lookup(name: '2 normal'),
  62. created_at: Time.zone.now - 3.days,
  63. created_by_id: 1,
  64. updated_by_id: 1,
  65. updated_at: Time.zone.now - 3.days,
  66. )
  67. # create jobs
  68. job1 = Job.create_or_update(
  69. name: 'Test Job1',
  70. timeplan: {
  71. days: {
  72. Mon: false,
  73. Tue: false,
  74. Wed: false,
  75. Thu: false,
  76. Fri: false,
  77. Sat: false,
  78. Sun: false,
  79. },
  80. hours: {
  81. 0 => false,
  82. 1 => false,
  83. 2 => false,
  84. 3 => false,
  85. 4 => false,
  86. 5 => false,
  87. 6 => false,
  88. 7 => false,
  89. 8 => false,
  90. 9 => false,
  91. 10 => false,
  92. 11 => false,
  93. 12 => false,
  94. 13 => false,
  95. 14 => false,
  96. 15 => false,
  97. 16 => false,
  98. 17 => false,
  99. 18 => false,
  100. 19 => false,
  101. 20 => false,
  102. 21 => false,
  103. 22 => false,
  104. 23 => false,
  105. },
  106. minutes: {
  107. 0 => false,
  108. 10 => false,
  109. 20 => false,
  110. 30 => false,
  111. 40 => false,
  112. 50 => false,
  113. },
  114. },
  115. condition: {
  116. 'ticket.state_id' => { 'operator' => 'is', 'value' => [Ticket::State.lookup(name: 'new').id.to_s, Ticket::State.lookup(name: 'open').id.to_s] },
  117. 'ticket.created_at' => { 'operator' => 'before (relative)', 'value' => '2', 'range' => 'day' },
  118. },
  119. perform: {
  120. 'ticket.state_id' => { 'value' => Ticket::State.lookup(name: 'closed').id.to_s }
  121. },
  122. disable_notification: true,
  123. last_run_at: nil,
  124. active: true,
  125. created_by_id: 1,
  126. created_at: Time.zone.now,
  127. updated_by_id: 1,
  128. updated_at: Time.zone.now,
  129. )
  130. assert_not(job1.next_run_at)
  131. assert_not(job1.executable?)
  132. job1.last_run_at = Time.zone.now - 15.minutes
  133. job1.save!
  134. assert_not(job1.executable?)
  135. job1.updated_at = Time.zone.now - 15.minutes
  136. job1.save!
  137. assert(job1.executable?)
  138. job1.active = false
  139. job1.save!
  140. assert_not(job1.executable?)
  141. job1.active = true
  142. job1.save!
  143. assert_not(job1.executable?)
  144. assert_not(job1.in_timeplan?)
  145. time = Time.zone.now
  146. day_map = {
  147. 0 => 'Sun',
  148. 1 => 'Mon',
  149. 2 => 'Tue',
  150. 3 => 'Wed',
  151. 4 => 'Thu',
  152. 5 => 'Fri',
  153. 6 => 'Sat',
  154. }
  155. job1.timeplan['days'][day_map[time.wday]] = true
  156. job1.save!
  157. assert_not(job1.in_timeplan?(time))
  158. job1.timeplan['hours'][time.hour.to_s] = true
  159. job1.save!
  160. assert_not(job1.in_timeplan?(time))
  161. min = time.min
  162. if min < 9
  163. min = 0
  164. elsif min < 20
  165. min = 10
  166. elsif min < 30
  167. min = 20
  168. elsif min < 40
  169. min = 30
  170. elsif min < 50
  171. min = 40
  172. elsif min < 60
  173. min = 50
  174. end
  175. job1.timeplan['minutes'][min.to_s] = true
  176. job1.save!
  177. assert(job1.in_timeplan?(time))
  178. job1.timeplan['hours'][time.hour] = true
  179. job1.save!
  180. job1.timeplan['minutes'][min] = true
  181. job1.save!
  182. assert(job1.in_timeplan?(time))
  183. # execute jobs
  184. job1.updated_at = Time.zone.now - 15.minutes
  185. job1.save!
  186. Job.run
  187. assert(job1.next_run_at)
  188. assert(job1.executable?)
  189. assert(job1.in_timeplan?)
  190. # verify changes on tickets
  191. ticket1_later = Ticket.find(ticket1.id)
  192. assert_equal('closed', ticket1_later.state.name)
  193. assert_not_equal(ticket1.updated_at.to_s, ticket1_later.updated_at.to_s)
  194. ticket2_later = Ticket.find(ticket2.id)
  195. assert_equal('new', ticket2_later.state.name)
  196. assert_equal(ticket2.updated_at.to_s, ticket2_later.updated_at.to_s)
  197. ticket3_later = Ticket.find(ticket3.id)
  198. assert_equal('open', ticket3_later.state.name)
  199. assert_equal(ticket3.updated_at.to_s, ticket3_later.updated_at.to_s)
  200. ticket4_later = Ticket.find(ticket4.id)
  201. assert_equal('closed', ticket4_later.state.name)
  202. assert_equal(ticket4.updated_at.to_s, ticket4_later.updated_at.to_s)
  203. ticket5_later = Ticket.find(ticket5.id)
  204. assert_equal('closed', ticket5_later.state.name)
  205. assert_not_equal(ticket5.updated_at.to_s, ticket5_later.updated_at.to_s)
  206. # execute jobs again
  207. job1.updated_at = Time.zone.now - 15.minutes
  208. job1.save!
  209. Job.run
  210. # verify changes on tickets
  211. ticket1_later_next = Ticket.find(ticket1.id)
  212. assert_equal('closed', ticket1_later_next.state.name)
  213. assert_equal(ticket1_later.updated_at.to_s, ticket1_later_next.updated_at.to_s)
  214. ticket2_later_next = Ticket.find(ticket2.id)
  215. assert_equal('new', ticket2_later_next.state.name)
  216. assert_equal(ticket2_later.updated_at.to_s, ticket2_later_next.updated_at.to_s)
  217. ticket3_later_next = Ticket.find(ticket3.id)
  218. assert_equal('open', ticket3_later_next.state.name)
  219. assert_equal(ticket3_later.updated_at.to_s, ticket3_later_next.updated_at.to_s)
  220. ticket4_later_next = Ticket.find(ticket4.id)
  221. assert_equal('closed', ticket4_later_next.state.name)
  222. assert_equal(ticket4_later.updated_at.to_s, ticket4_later_next.updated_at.to_s)
  223. ticket5_later_next = Ticket.find(ticket5.id)
  224. assert_equal('closed', ticket5_later_next.state.name)
  225. assert_equal(ticket5_later.updated_at.to_s, ticket5_later_next.updated_at.to_s)
  226. end
  227. test 'case 2' do
  228. # create ticket
  229. group1 = Group.lookup(name: 'Users')
  230. group2 = Group.create_or_update(
  231. name: 'JobTest2',
  232. updated_by_id: 1,
  233. created_by_id: 1,
  234. )
  235. ticket1 = Ticket.create(
  236. title: 'job test 1',
  237. group: group1,
  238. customer_id: 2,
  239. state: Ticket::State.lookup(name: 'new'),
  240. priority: Ticket::Priority.lookup(name: '2 normal'),
  241. created_at: Time.zone.now - 3.days,
  242. updated_at: Time.zone.now - 3.days,
  243. created_by_id: 1,
  244. updated_by_id: 1,
  245. )
  246. ticket2 = Ticket.create(
  247. title: 'job test 2',
  248. group: group1,
  249. customer_id: 2,
  250. state: Ticket::State.lookup(name: 'new'),
  251. priority: Ticket::Priority.lookup(name: '2 normal'),
  252. created_at: Time.zone.now - 1.day,
  253. created_by_id: 1,
  254. updated_at: Time.zone.now - 1.day,
  255. updated_by_id: 1,
  256. )
  257. # create jobs
  258. job1 = Job.create_or_update(
  259. name: 'Test Job1',
  260. timeplan: {
  261. days: {
  262. Mon: true,
  263. Tue: true,
  264. Wed: true,
  265. Thu: true,
  266. Fri: true,
  267. Sat: true,
  268. Sun: true,
  269. },
  270. hours: {
  271. 0 => true,
  272. 1 => true,
  273. 2 => true,
  274. 3 => true,
  275. 4 => true,
  276. 5 => true,
  277. 6 => true,
  278. 7 => true,
  279. 8 => true,
  280. 9 => true,
  281. 10 => true,
  282. 11 => true,
  283. 12 => true,
  284. 13 => true,
  285. 14 => true,
  286. 15 => true,
  287. 16 => true,
  288. 17 => true,
  289. 18 => true,
  290. 19 => true,
  291. 20 => true,
  292. 21 => true,
  293. 22 => true,
  294. 23 => true,
  295. },
  296. minutes: {
  297. 0 => true,
  298. 10 => true,
  299. 20 => true,
  300. 30 => true,
  301. 40 => true,
  302. 50 => true,
  303. },
  304. },
  305. condition: {
  306. 'ticket.state_id' => { 'operator' => 'is', 'value' => '9999' },
  307. 'ticket.created_at' => { 'operator' => 'before (relative)', 'value' => '2', 'range' => 'day' },
  308. },
  309. perform: {
  310. 'ticket.state_id' => { 'value' => Ticket::State.lookup(name: 'closed').id.to_s }
  311. },
  312. disable_notification: true,
  313. last_run_at: nil,
  314. updated_at: Time.zone.now - 15.minutes,
  315. active: true,
  316. updated_by_id: 1,
  317. created_by_id: 1,
  318. )
  319. assert(job1.executable?)
  320. assert(job1.in_timeplan?)
  321. Job.run
  322. # verify changes on tickets
  323. ticket1_later = Ticket.find(ticket1.id)
  324. assert_equal('new', ticket1_later.state.name)
  325. assert_equal(ticket1.updated_at.to_s, ticket1_later.updated_at.to_s)
  326. ticket2_later = Ticket.find(ticket2.id)
  327. assert_equal('new', ticket2_later.state.name)
  328. assert_equal(ticket2.updated_at.to_s, ticket2_later.updated_at.to_s)
  329. end
  330. test 'case 3' do
  331. # create jobs
  332. job1 = Job.create_or_update(
  333. name: 'Test Job1',
  334. timeplan: {
  335. days: {
  336. Mon: true,
  337. Tue: false,
  338. Wed: false,
  339. Thu: false,
  340. Fri: true,
  341. Sat: false,
  342. Sun: false,
  343. },
  344. hours: {
  345. 0 => false,
  346. 1 => true,
  347. 2 => false,
  348. 3 => false,
  349. 4 => false,
  350. 5 => false,
  351. 6 => false,
  352. 7 => false,
  353. 8 => false,
  354. 9 => false,
  355. 10 => true,
  356. 11 => false,
  357. 12 => false,
  358. 13 => false,
  359. 14 => false,
  360. 15 => false,
  361. 16 => false,
  362. 17 => false,
  363. 18 => false,
  364. 19 => false,
  365. 20 => false,
  366. 21 => false,
  367. 22 => false,
  368. 23 => false,
  369. },
  370. minutes: {
  371. 0 => true,
  372. 10 => false,
  373. 20 => false,
  374. 30 => false,
  375. 40 => true,
  376. 50 => false,
  377. },
  378. },
  379. condition: {
  380. 'ticket.state_id' => { 'operator' => 'is', 'value' => [Ticket::State.lookup(name: 'new').id.to_s, Ticket::State.lookup(name: 'open').id.to_s] },
  381. 'ticket.created_at' => { 'operator' => 'before (relative)', 'value' => '2', 'range' => 'day' },
  382. },
  383. perform: {
  384. 'ticket.state_id' => { 'value' => Ticket::State.lookup(name: 'closed').id.to_s }
  385. },
  386. disable_notification: true,
  387. last_run_at: nil,
  388. active: true,
  389. created_by_id: 1,
  390. created_at: Time.zone.now,
  391. updated_by_id: 1,
  392. updated_at: Time.zone.now,
  393. )
  394. time_now = Time.zone.parse('2016-03-18 09:17:13 UTC')
  395. next_run_at = job1.next_run_at_calculate(time_now)
  396. assert_equal('2016-03-18 10:00:00 UTC', next_run_at.to_s)
  397. time_now = Time.zone.parse('2016-03-18 10:37:13 UTC')
  398. next_run_at = job1.next_run_at_calculate(time_now)
  399. assert_equal('2016-03-18 10:40:00 UTC', next_run_at.to_s)
  400. time_now = Time.zone.parse('2016-03-17 09:17:13 UTC')
  401. next_run_at = job1.next_run_at_calculate(time_now)
  402. assert_equal('2016-03-18 01:00:00 UTC', next_run_at.to_s)
  403. time_now = Time.zone.parse('2016-03-17 11:17:13 UTC')
  404. next_run_at = job1.next_run_at_calculate(time_now)
  405. assert_equal('2016-03-18 01:00:00 UTC', next_run_at.to_s)
  406. time_now = Time.zone.parse('2016-03-19 11:17:13 UTC')
  407. next_run_at = job1.next_run_at_calculate(time_now)
  408. assert_equal('2016-03-21 01:00:00 UTC', next_run_at.to_s)
  409. time_now = Time.zone.parse('2016-03-22 00:59:59 UTC')
  410. next_run_at = job1.next_run_at_calculate(time_now)
  411. assert_equal('2016-03-25 01:00:00 UTC', next_run_at.to_s)
  412. time_now = Time.zone.parse('2016-03-25 00:59:59 UTC')
  413. next_run_at = job1.next_run_at_calculate(time_now)
  414. assert_equal('2016-03-25 01:00:00 UTC', next_run_at.to_s)
  415. time_now = Time.zone.parse('2016-03-24 00:59:59 UTC')
  416. next_run_at = job1.next_run_at_calculate(time_now)
  417. assert_equal('2016-03-25 01:00:00 UTC', next_run_at.to_s)
  418. time_now = Time.zone.parse('2016-03-24 23:59:59 UTC')
  419. next_run_at = job1.next_run_at_calculate(time_now)
  420. assert_equal('2016-03-25 01:00:00 UTC', next_run_at.to_s)
  421. time_now = Time.zone.parse('2016-03-25 01:00:01 UTC')
  422. next_run_at = job1.next_run_at_calculate(time_now)
  423. assert_equal('2016-03-25 01:00:00 UTC', next_run_at.to_s)
  424. time_now = Time.zone.parse('2016-03-25 01:09:01 UTC')
  425. next_run_at = job1.next_run_at_calculate(time_now)
  426. assert_equal('2016-03-25 01:40:00 UTC', next_run_at.to_s)
  427. time_now = Time.zone.parse('2016-03-25 01:09:59 UTC')
  428. next_run_at = job1.next_run_at_calculate(time_now)
  429. assert_equal('2016-03-25 01:40:00 UTC', next_run_at.to_s)
  430. job1.last_run_at = Time.zone.parse('2016-03-18 10:00:01 UTC')
  431. job1.save!
  432. time_now = Time.zone.parse('2016-03-18 10:00:02 UTC')
  433. next_run_at = job1.next_run_at_calculate(time_now)
  434. assert_equal('2016-03-18 10:40:00 UTC', next_run_at.to_s)
  435. job1.last_run_at = Time.zone.parse('2016-03-18 10:40:01 UTC')
  436. job1.save!
  437. time_now = Time.zone.parse('2016-03-18 10:40:02 UTC')
  438. next_run_at = job1.next_run_at_calculate(time_now)
  439. assert_equal('2016-03-21 01:00:00 UTC', next_run_at.to_s)
  440. end
  441. test 'case 4' do
  442. # create jobs
  443. job1 = Job.create_or_update(
  444. name: 'Test Job1',
  445. timeplan: {
  446. days: {
  447. Mon: true,
  448. Tue: false,
  449. Wed: false,
  450. Thu: false,
  451. Fri: true,
  452. Sat: false,
  453. Sun: false,
  454. },
  455. hours: {
  456. 0 => true,
  457. 1 => false,
  458. 2 => false,
  459. 3 => false,
  460. 4 => false,
  461. 5 => false,
  462. 6 => false,
  463. 7 => false,
  464. 8 => false,
  465. 9 => false,
  466. 10 => true,
  467. 11 => false,
  468. 12 => false,
  469. 13 => false,
  470. 14 => false,
  471. 15 => false,
  472. 16 => false,
  473. 17 => false,
  474. 18 => false,
  475. 19 => false,
  476. 20 => false,
  477. 21 => false,
  478. 22 => false,
  479. 23 => false,
  480. },
  481. minutes: {
  482. 0 => true,
  483. 10 => false,
  484. 20 => false,
  485. 30 => false,
  486. 40 => true,
  487. 50 => false,
  488. },
  489. },
  490. condition: {
  491. 'ticket.state_id' => { 'operator' => 'is', 'value' => [Ticket::State.lookup(name: 'new').id.to_s, Ticket::State.lookup(name: 'open').id.to_s] },
  492. 'ticket.created_at' => { 'operator' => 'before (relative)', 'value' => '2', 'range' => 'day' },
  493. },
  494. perform: {
  495. 'ticket.state_id' => { 'value' => Ticket::State.lookup(name: 'closed').id.to_s }
  496. },
  497. disable_notification: true,
  498. last_run_at: nil,
  499. active: true,
  500. created_by_id: 1,
  501. created_at: Time.zone.now,
  502. updated_by_id: 1,
  503. updated_at: Time.zone.now,
  504. )
  505. time_now = Time.zone.parse('2016-03-17 23:51:23 UTC')
  506. next_run_at = job1.next_run_at_calculate(time_now)
  507. assert_equal('2016-03-18 00:00:00 UTC', next_run_at.to_s)
  508. job1.last_run_at = Time.zone.parse('2016-03-17 23:45:01 UTC')
  509. job1.save!
  510. time_now = Time.zone.parse('2016-03-17 23:51:23 UTC')
  511. next_run_at = job1.next_run_at_calculate(time_now)
  512. assert_equal('2016-03-18 00:00:00 UTC', next_run_at.to_s)
  513. job1.last_run_at = Time.zone.parse('2016-03-17 23:59:01 UTC')
  514. job1.save!
  515. time_now = Time.zone.parse('2016-03-17 23:59:23 UTC')
  516. next_run_at = job1.next_run_at_calculate(time_now)
  517. assert_equal('2016-03-18 00:40:00 UTC', next_run_at.to_s)
  518. time_now = Time.zone.parse('2016-03-17 23:59:23 UTC')
  519. assert_not(job1.in_timeplan?(time_now))
  520. time_now = Time.zone.parse('2016-03-18 00:01:23 UTC')
  521. assert(job1.in_timeplan?(time_now))
  522. end
  523. test 'case 5' do
  524. # create jobs
  525. job1 = Job.create_or_update(
  526. name: 'Test Job1',
  527. timeplan: {
  528. days: {
  529. Mon: true,
  530. Tue: false,
  531. Wed: false,
  532. Thu: false,
  533. Fri: false,
  534. Sat: false,
  535. Sun: false,
  536. },
  537. hours: {
  538. '0' => true,
  539. '1' => false,
  540. '2' => false,
  541. '3' => false,
  542. '4' => false,
  543. '5' => false,
  544. '6' => false,
  545. '7' => false,
  546. '8' => false,
  547. '9' => false,
  548. '10' => false,
  549. '11' => false,
  550. '12' => false,
  551. '13' => false,
  552. '14' => false,
  553. '15' => false,
  554. '16' => false,
  555. '17' => false,
  556. '18' => false,
  557. '19' => false,
  558. '20' => false,
  559. '21' => false,
  560. '22' => false,
  561. '23' => false,
  562. },
  563. minutes: {
  564. '0' => true,
  565. '10' => false,
  566. '20' => false,
  567. '30' => false,
  568. '40' => false,
  569. '50' => false,
  570. },
  571. },
  572. condition: {
  573. 'ticket.state_id' => { 'operator' => 'is', 'value' => [Ticket::State.lookup(name: 'new').id.to_s, Ticket::State.lookup(name: 'open').id.to_s] },
  574. 'ticket.created_at' => { 'operator' => 'before (relative)', 'value' => '2', 'range' => 'day' },
  575. },
  576. perform: {
  577. 'ticket.state_id' => { 'value' => Ticket::State.lookup(name: 'closed').id.to_s }
  578. },
  579. disable_notification: true,
  580. last_run_at: nil,
  581. active: true,
  582. created_by_id: 1,
  583. created_at: Time.zone.now,
  584. updated_by_id: 1,
  585. updated_at: Time.zone.now,
  586. )
  587. time_now = Time.zone.parse('2016-03-17 23:51:23 UTC')
  588. next_run_at = job1.next_run_at_calculate(time_now)
  589. assert_equal('2016-03-21 00:00:00 UTC', next_run_at.to_s)
  590. end
  591. end