account.go RawHistoryFolder

1package queries
2
3import (
4	"github.com/bnema/gordon/internal/db"
5	"github.com/bnema/gordon/internal/server"
6)
7
8func createDBAccount(a *server.App) (*db.Account, error) {
9	account := &db.Account{
10		ID: generateUUID(),
11	}
12
13	_, err := a.DB.Exec(
14		"INSERT INTO account (id, user_id) VALUES (?, ?)",
15		account.ID, a.DBTables.User.ID,
16	)
17	return account, err
18}
19
20func CheckDBAccountExists(a *server.App, accountID string) (bool, error) {
21	var exists bool
22	err := a.DB.QueryRow("SELECT EXISTS(SELECT 1 FROM account WHERE id = ?)", accountID).Scan(&exists)
23	if err != nil {
24		return false, err
25	}
26	return exists, nil
27}
28
29func PopulateAccountFromDB(a *server.App) error {
30	rows, err := a.DB.Query("SELECT id, user_id FROM account")
31	if err != nil {
32		return err
33	}
34	defer rows.Close()
35
36	for rows.Next() {
37		account := db.Account{}
38		err := rows.Scan(&account.ID, &account.UserID)
39		if err != nil {
40			return err
41		}
42
43		a.DBTables.Account = account
44	}
45
46	return rows.Err()
47}