xonecas.io
60255
Zn

Zoea-Nova / files

Zoea-Nova / internal / store / accounts.go

5.0 KB
1package store
2
3import (
4	"database/sql"
5	"fmt"
6	"time"
7)
8
9type Account struct {
10	Username   string
11	Password   string
12	AssignedTo string
13	LastUsedAt time.Time
14	CreatedAt  time.Time
15}
16
17func (s *Store) CreateAccount(username, password string, mysisID ...string) (*Account, error) {
18	now := time.Now().UTC()
19	assignedTo := ""
20	var assignedToParam interface{}
21	if len(mysisID) > 0 && mysisID[0] != "" {
22		assignedTo = mysisID[0]
23		assignedToParam = mysisID[0]
24	} else {
25		assignedToParam = nil
26	}
27
28	_, err := s.db.Exec(`
29		INSERT INTO accounts (username, password, assigned_to, created_at, last_used_at)
30		VALUES (?, ?, ?, ?, ?)
31	`, username, password, assignedToParam, now, now)
32	if err != nil {
33		return nil, fmt.Errorf("insert account: %w", err)
34	}
35
36	return &Account{
37		Username:   username,
38		Password:   password,
39		AssignedTo: assignedTo,
40		CreatedAt:  now,
41		LastUsedAt: now,
42	}, nil
43}
44
45func (s *Store) GetAccount(username string) (*Account, error) {
46	var acc Account
47	var lastUsedAt sql.NullTime
48	var assignedTo sql.NullString
49
50	err := s.db.QueryRow(`
51		SELECT username, password, assigned_to, last_used_at, created_at
52		FROM accounts WHERE username = ?
53	`, username).Scan(&acc.Username, &acc.Password, &assignedTo, &lastUsedAt, &acc.CreatedAt)
54	if err != nil {
55		return nil, err
56	}
57
58	if assignedTo.Valid {
59		acc.AssignedTo = assignedTo.String
60	}
61	if lastUsedAt.Valid {
62		acc.LastUsedAt = lastUsedAt.Time
63	}
64
65	return &acc, nil
66}
67
68func (s *Store) GetAccountByMysisID(mysisID string) (*Account, error) {
69	var acc Account
70	var lastUsedAt sql.NullTime
71	var assignedTo sql.NullString
72
73	err := s.db.QueryRow(`
74		SELECT username, password, assigned_to, last_used_at, created_at
75		FROM accounts WHERE assigned_to = ?
76	`, mysisID).Scan(&acc.Username, &acc.Password, &assignedTo, &lastUsedAt, &acc.CreatedAt)
77	if err != nil {
78		return nil, err
79	}
80
81	if assignedTo.Valid {
82		acc.AssignedTo = assignedTo.String
83	}
84	if lastUsedAt.Valid {
85		acc.LastUsedAt = lastUsedAt.Time
86	}
87
88	return &acc, nil
89}
90
91func (s *Store) ListAvailableAccounts() ([]*Account, error) {
92	rows, err := s.db.Query(`
93		SELECT username, password, assigned_to, last_used_at, created_at
94		FROM accounts
95		WHERE assigned_to IS NULL
96		ORDER BY created_at ASC
97	`)
98	if err != nil {
99		return nil, fmt.Errorf("query available accounts: %w", err)
100	}
101	defer rows.Close()
102
103	var accounts []*Account
104	for rows.Next() {
105		var acc Account
106		var lastUsedAt sql.NullTime
107		var assignedTo sql.NullString
108
109		if err := rows.Scan(&acc.Username, &acc.Password, &assignedTo, &lastUsedAt, &acc.CreatedAt); err != nil {
110			return nil, fmt.Errorf("scan account: %w", err)
111		}
112
113		if assignedTo.Valid {
114			acc.AssignedTo = assignedTo.String
115		}
116		if lastUsedAt.Valid {
117			acc.LastUsedAt = lastUsedAt.Time
118		}
119
120		accounts = append(accounts, &acc)
121	}
122
123	return accounts, rows.Err()
124}
125
126func (s *Store) ClaimAccount(mysisID string) (*Account, error) {
127	if mysisID == "" {
128		return nil, fmt.Errorf("mysisID required to claim account")
129	}
130
131	now := time.Now().UTC()
132	var username, password string
133	var createdAt time.Time
134	var lastUsedAt sql.NullTime
135
136	// Atomically assign an account permanently to this mysis
137	// This prevents race conditions where multiple myses claim the same account
138	err := s.db.QueryRow(`
139		UPDATE accounts
140		SET assigned_to = ?, last_used_at = ?
141		WHERE username = (
142			SELECT username
143			FROM accounts
144			WHERE assigned_to IS NULL
145			ORDER BY created_at ASC
146			LIMIT 1
147		)
148		RETURNING username, password, created_at, last_used_at
149	`, mysisID, now).Scan(&username, &password, &createdAt, &lastUsedAt)
150	if err == sql.ErrNoRows {
151		return nil, fmt.Errorf("no accounts available")
152	}
153	if err != nil {
154		return nil, fmt.Errorf("claim account: %w", err)
155	}
156
157	acc := &Account{
158		Username:   username,
159		Password:   password,
160		AssignedTo: mysisID,
161		CreatedAt:  createdAt,
162	}
163
164	if lastUsedAt.Valid {
165		acc.LastUsedAt = lastUsedAt.Time
166	}
167
168	return acc, nil
169}
170
171// AssignAccount permanently assigns an account to a mysis
172func (s *Store) AssignAccount(username, mysisID string) error {
173	now := time.Now().UTC()
174
175	_, err := s.db.Exec(`
176		UPDATE accounts
177		SET assigned_to = ?, last_used_at = ?
178		WHERE username = ?
179	`, mysisID, now, username)
180	if err != nil {
181		return fmt.Errorf("assign account: %w", err)
182	}
183
184	return nil
185}
186
187// ReleaseAccount clears the permanent assignment of an account (returns it to pool)
188func (s *Store) ReleaseAccount(username string) error {
189	_, err := s.db.Exec(`
190		UPDATE accounts
191		SET assigned_to = NULL
192		WHERE username = ?
193	`, username)
194	if err != nil {
195		return fmt.Errorf("release account: %w", err)
196	}
197
198	return nil
199}
200
201// ReleaseAccountByMysisID clears the permanent assignment for a mysis's account
202func (s *Store) ReleaseAccountByMysisID(mysisID string) error {
203	_, err := s.db.Exec(`
204		UPDATE accounts
205		SET assigned_to = NULL
206		WHERE assigned_to = ?
207	`, mysisID)
208	if err != nil {
209		return fmt.Errorf("release account by mysis: %w", err)
210	}
211
212	return nil
213}
214
215func (s *Store) ReleaseAllAccounts() error {
216	_, err := s.db.Exec(`UPDATE accounts SET assigned_to = NULL`)
217	if err != nil {
218		return fmt.Errorf("release all accounts: %w", err)
219	}
220
221	return nil
222}