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}