1. 1
2. 2
3. 3
4. 4
5. 5
6. 6
7. 7
8. 8
9. 9
10. 10
11. 11
12. 12
13. 13
14. 14
15. 15
16. 16
17. 17
18. 18
19. 19
20. 20
21. 21
22. 22
23. 23
24. 24
25. 25
26. 26
27. 27
28. 28
29. 29
30. 30
31. 31

// SPDX-FileCopyrightText: 2024 Shota FUJI <pockawoooh@gmail.com>
// SPDX-License-Identifier: AGPL-3.0-only

import { createRandomBytes } from "../helpers";

import type { Migration } from "./types";

export const v9: Migration = async (db, transaction) => {
	const store = transaction.objectStore("workers");

	for await (const cursor of store.iterate()) {
		await cursor.update({
			...cursor.value,
			providePaidLeaveKey: cursor.value.providePaidLeaveKey || createRandomBytes(16),
		});
	}

	const paidLeaveProvision = db.createObjectStore("paidLeaveProvision", {
		keyPath: "id",
	});

	paidLeaveProvision.createIndex("workspaceId,workerId", ["workspaceId", "workerId"], {
		unique: false,
	});

	paidLeaveProvision.createIndex(
		"workspaceId,workerId,providedAtPacked",
		["workspaceId", "workerId", "providedAtPacked"],
		{ unique: true },
	);
};