skillspark/backend/internal/storage/postgres/schema/saved/create.go at 82b47a4b19004ae2077ef04adb3b657312496a83 · GenerateNU/skillspark · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
package saved

import (
	"context"
	"skillspark/internal/errs"
	"skillspark/internal/models"
	"skillspark/internal/storage/postgres/schema"
)

var language string

func (r *SavedRepository) CreateSaved(ctx context.Context, saved *models.CreateSavedInput) (*models.Saved, error) {
	language = saved.AcceptLanguage

	query, err := schema.ReadSQLBaseScript("create.sql", SqlSavedFiles)
	if err != nil {
		err := errs.InternalServerError("Failed to read base query: ", err.Error())
		return nil, &err
	}

	row := r.db.QueryRow(ctx, query, saved.Body.GuardianID, saved.Body.EventID)

	var createdSaved models.Saved
	var titleEN, descriptionEN string
	var titleTH, descriptionTH *string

	err = row.Scan(
		&createdSaved.ID,
		&createdSaved.GuardianID,
		&createdSaved.CreatedAt,
		&createdSaved.UpdatedAt,
		&createdSaved.Event.ID,
		&titleEN,
		&titleTH,
		&descriptionEN,
		&descriptionTH,
		&createdSaved.Event.OrganizationID,
		&createdSaved.Event.AgeRangeMin,
		&createdSaved.Event.AgeRangeMax,
		&createdSaved.Event.Category,
		&createdSaved.Event.HeaderImageS3Key,
		&createdSaved.Event.CreatedAt,
		&createdSaved.Event.UpdatedAt,
	)

	if err != nil {
		err := errs.InternalServerError("Failed to create saved event: ", err.Error())
		return nil, &err
	}

	switch language {
	case "th-TH":
		if titleTH != nil {
			createdSaved.Event.Title = *titleTH
		}
		if descriptionTH != nil {
			createdSaved.Event.Description = *descriptionTH
		}
	case "en-US":
		createdSaved.Event.Title = titleEN
		createdSaved.Event.Description = descriptionEN
	}

	return &createdSaved, nil

}