-
Notifications
You must be signed in to change notification settings - Fork 0
/
func_create_post.go
83 lines (70 loc) · 1.89 KB
/
func_create_post.go
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
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
package main
import (
"context"
"database/sql"
"fmt"
"time"
"github.com/google/uuid"
_ "github.com/lib/pq"
"github.com/skovranek/rss_aggregator/internal/database"
)
func (cfg *apiConfig) createPost(ctx context.Context, feedID uuid.UUID, item Item) error {
id := uuid.New()
now := time.Now().UTC()
titleNullStr, err := strPtrToSQLNullStr(item.Title)
if err != nil {
return fmt.Errorf("strPtrToSQLNullStr(itme.Title): %v", err)
}
descriptionNullStr, err := strPtrToSQLNullStr(item.Description)
if err != nil {
return fmt.Errorf("strPtrToSQLNullStr(itme.Description): %v", err)
}
publishedAtNullTime, err := strPtrToSQLNullTime(item.PubDate)
if err != nil {
return fmt.Errorf("strPtrToSQLNullTime(item.PubDate): %v", err)
}
_, err = cfg.DB.CreatePost(ctx, database.CreatePostParams{
ID: id,
CreatedAt: now,
UpdatedAt: now,
Title: titleNullStr,
Url: item.Link,
Description: descriptionNullStr,
PublishedAt: publishedAtNullTime,
FeedID: feedID,
})
if err != nil {
err = fmt.Errorf("unable to add post to database: %v", err)
return err
}
return nil
}
func strPtrToSQLNullStr(strPtr *string) (sql.NullString, error) {
if strPtr == nil {
return sql.NullString{}, nil
}
nullStr := sql.NullString{}
err := nullStr.Scan(*strPtr)
if err != nil {
err = fmt.Errorf("sql.NullString{}.Scan(*strPtr): %v", err)
return sql.NullString{}, err
}
return nullStr, nil
}
func strPtrToSQLNullTime(strPtr *string) (sql.NullTime, error) {
if strPtr == nil {
return sql.NullTime{}, nil
}
parsedTime, err := time.Parse(time.RFC1123Z, *strPtr)
if err != nil {
err = fmt.Errorf("time.Parse(time.RFC1123Z, *strPtr): %v", err)
return sql.NullTime{}, err
}
nullTime := sql.NullTime{}
err = nullTime.Scan(parsedTime)
if err != nil {
err = fmt.Errorf("sql.NullTime{}.Scan(parsedTime): %v", err)
return sql.NullTime{}, err
}
return nullTime, nil
}