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
32. 32
33. 33
34. 34
35. 35
36. 36
37. 37
38. 38
39. 39
40. 40
41. 41
42. 42
43. 43
44. 44
45. 45
46. 46
47. 47
48. 48
49. 49
50. 50
51. 51
52. 52
53. 53
54. 54
55. 55
56. 56
57. 57
58. 58
59. 59
60. 60
61. 61
62. 62
63. 63
64. 64
65. 65
66. 66
67. 67
68. 68
69. 69
70. 70
71. 71
72. 72
73. 73
74. 74
75. 75
76. 76
77. 77
78. 78
79. 79
80. 80
81. 81
82. 82
83. 83
84. 84
85. 85
86. 86
87. 87
88. 88
89. 89
90. 90
91. 91
92. 92
93. 93
94. 94
95. 95
96. 96
97. 97
98. 98
99. 99
100. 100
101. 101
102. 102

// Copyright 2025 Shota FUJI
//
// This source code is licensed under Zero-Clause BSD License.
// You can find a copy of the Zero-Clause BSD License at LICENSES/0BSD.txt
// You may also obtain a copy of the Zero-Clause BSD License at
// <https://opensource.org/license/0bsd>
//
// SPDX-License-Identifier: 0BSD

package events

import (
	"context"
	"database/sql"
	"fmt"

	"google.golang.org/protobuf/proto"

	"pocka.jp/x/event_sourcing_user_management_poc/gen/event"
)

func List(db *sql.DB) ([]proto.Message, error) {
	ctx := context.Background()

	tx, err := db.BeginTx(ctx, nil)
	if err != nil {
		return nil, fmt.Errorf("Failed to begin transaction for listing user_events: %s", err)
	}
	defer tx.Rollback()

	var rowCount int
	if err := tx.QueryRow("SELECT count(*) FROM user_events").Scan(&rowCount); err != nil {
		return nil, fmt.Errorf("Failed to count user_events: %s", err)
	}

	if rowCount == 0 {
		return []proto.Message{}, nil
	}

	rows, err := tx.Query("SELECT seq, event_name, payload FROM user_events ORDER BY seq ASC")
	if err != nil {
		return nil, fmt.Errorf("Failed to SELECT user_events: %s", err)
	}

	events := make([]proto.Message, rowCount)
	for i := range events {
		if !rows.Next() {
			return nil, fmt.Errorf("Number of events is less than rowCount")
		}

		event, _, err := ScanEvent(rows)
		if err != nil {
			return nil, err
		}

		events[i] = event
	}

	return events, nil
}

type Scanner interface {
	Scan(dst ...any) error
}

func ScanEvent(scanner Scanner) (proto.Message, int, error) {
	var seq int
	var eventName string
	var payload []byte
	if err := scanner.Scan(&seq, &eventName, &payload); err != nil {
		return nil, 0, fmt.Errorf("Failed to scan user event: %s", err)
	}

	switch eventName {
	case "InitialAdminCreationPasswordCreated":
		var event event.InitialAdminCreationPasswordCreated
		if err := proto.Unmarshal(payload, &event); err != nil {
			return nil, 0, fmt.Errorf("Illegal InitialAdminCreationPasswordCreated event: %s", err)
		}
		return &event, seq, nil
	case "UserCreated":
		var event event.UserCreated
		if err := proto.Unmarshal(payload, &event); err != nil {
			return nil, 0, fmt.Errorf("Illegal UserCreated event: %s", err)
		}
		return &event, seq, nil
	case "PasswordLoginConfigured":
		var event event.PasswordLoginConfigured
		if err := proto.Unmarshal(payload, &event); err != nil {
			return nil, 0, fmt.Errorf("Illegal PasswordLoginConfigured event: %s", err)
		}
		return &event, seq, nil
	case "RoleAssigned":
		var event event.RoleAssigned
		if err := proto.Unmarshal(payload, &event); err != nil {
			return nil, 0, fmt.Errorf("Illegal RoleAssigned event: %s", err)
		}
		return &event, seq, nil
	default:
		return nil, 0, fmt.Errorf("Unknown event in user_events: name=%s", eventName)
	}
}