tickets

3.9 KB

1. // tests/oldstore.hl — the gate's LEGACY FIXTURE for ticket #20: a store as it was BEFORE projects were own
2. // data — projects `{ name, created }`, tickets that name their project by NAME (path '<name>/<number>'),
3. // the old state names, events with free-text authors — written straight into the mpackdb tables, exactly the
4. // record shapes the pre-#20 store.hl wrote. The app's migrate.hl (run at every start) must turn it into
5. // projects with ids, members and the new states.
6. //
7. // TICKETS_STORAGE=/abs/dir bin/hybriel tests/oldstore.hl (writes <dir>/{projects,tickets,events}.db)
8. //
9. // old #1 alpha created T in progress, 3 events (the comment and the state change share one ms)
10. // old #3 alpha (alpha #2) created T+2min awaiting creator, 2 events (a Question ticket → pending)
11. // old #4 alpha (alpha #3) created T+2min open, 1 event
12. // old #2 beta.example.org created T+1min open, 1 event
13. // old #5 beta.example.org created T+4min awaiting creator, 1 event (→ review)
14. // → alpha #1 #2 #3 = old #1 #3 #4; beta.example.org #1 #2 = old #2 #5
15. import { MPackDB } from 'hl:mpackdb'
16. import { env } from 'hl:proc'
18. dir = env('TICKETS_STORAGE')
19. if (dir == null || !dir.startsWith('/')) { hlError('set TICKETS_STORAGE to an ABSOLUTE directory') }
20. projects = new MPackDB(file = dir + '/projects.db', primaryKey = '@id', indexes = ['!name'])
21. tickets = new MPackDB(file = dir + '/tickets.db', primaryKey = '@id', indexes = ['project', 'state', 'source', '!path', '*oldNumber'])
22. events = new MPackDB(file = dir + '/events.db', primaryKey = '@id', indexes = ['@ticket'])
23. if (tickets.count() > 0) { hlError('the fixture store is not empty: ' + dir) }
25. T = 1790000000000
26. M = 60000
27. projects.put({ name = 'alpha' created = T })
28. projects.put({ name = 'beta.example.org' created = T + M })
29. t1 = tickets.put({ project = 'alpha' number = 1 path = 'alpha/1' oldNumber = 1 subject = 'Legacy alpha one' summary = 'first legacy ticket' state = 'in progress' source = '' created = T updated = T + 5 * M events = 3 })
30. t2 = tickets.put({ project = 'beta.example.org' number = 1 path = 'beta.example.org/1' oldNumber = 2 subject = 'Legacy beta one' summary = '' state = 'open' source = '' created = T + M updated = T + M events = 1 })
31. t3 = tickets.put({ project = 'alpha' number = 2 path = 'alpha/2' oldNumber = 3 subject = 'Question: legacy alpha two' summary = 'two' state = 'awaiting creator' source = '' created = T + 2 * M updated = T + 3 * M events = 2 })
32. t4 = tickets.put({ project = 'alpha' number = 3 path = 'alpha/3' oldNumber = 4 subject = 'Legacy alpha three' summary = 'three' state = 'open' source = '' created = T + 2 * M updated = T + 2 * M events = 1 })
33. t5 = tickets.put({ project = 'beta.example.org' number = 2 path = 'beta.example.org/2' oldNumber = 5 subject = 'Legacy beta two' summary = 'b2' state = 'awaiting creator' source = '' created = T + 4 * M updated = T + 4 * M events = 1 })
34. events.put({ ticket = t1 seq = 1 kind = 'created' author = 'creator' text = '' created = T })
35. events.put({ ticket = t2 seq = 1 kind = 'created' author = 'architect' text = '' created = T + M })
36. events.put({ ticket = t3 seq = 1 kind = 'created' author = 'creator' text = '' created = T + 2 * M })
37. events.put({ ticket = t4 seq = 1 kind = 'created' author = 'creator' text = '' created = T + 2 * M })
38. events.put({ ticket = t5 seq = 1 kind = 'created' author = 'creator' text = '' created = T + 4 * M })
39. events.put({ ticket = t3 seq = 2 kind = 'comment' author = 'worker' text = 'legacy comment on two' created = T + 3 * M })
40. events.put({ ticket = t1 seq = 2 kind = 'comment' author = 'worker' text = 'legacy comment on one' created = T + 5 * M })
41. events.put({ ticket = t1 seq = 3 kind = 'state' author = 'worker' text = 'started' from = 'open' to = 'in progress' created = T + 5 * M })
42. console.log('oldstore: ' + projects.count() + ' projects, ' + tickets.count() + ' tickets, ' + events.count() + ' events (' + dir + ')')