/
grocery_trip.go
61 lines (59 loc) · 1.75 KB
/
grocery_trip.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
package gql
import (
"github.com/bradpurchase/grocerytime-backend/internal/pkg/db"
"github.com/bradpurchase/grocerytime-backend/internal/pkg/db/models"
"github.com/graphql-go/graphql"
)
var GroceryTripType = graphql.NewObject(
graphql.ObjectConfig{
Name: "GroceryTrip",
Fields: graphql.Fields{
"id": &graphql.Field{
Type: graphql.NewNonNull(graphql.ID),
},
"storeID": &graphql.Field{
Type: graphql.NewNonNull(graphql.ID),
},
"storeName": &graphql.Field{
Type: graphql.String,
Resolve: func(p graphql.ResolveParams) (interface{}, error) {
storeID := p.Source.(models.GroceryTrip).StoreID
store := models.Store{}
if err := db.Manager.Select("name").Where("id = ?", storeID).First(&store).Error; err != nil {
return nil, err
}
return store.Name, nil
},
},
"name": &graphql.Field{
Type: graphql.NewNonNull(graphql.String),
},
"completed": &graphql.Field{
Type: graphql.NewNonNull(graphql.Boolean),
},
"createdAt": &graphql.Field{
Type: graphql.DateTime,
},
"updatedAt": &graphql.Field{
Type: graphql.DateTime,
},
"categories": &graphql.Field{
Type: graphql.NewList(GroceryTripCategoryType),
Resolve: func(p graphql.ResolveParams) (interface{}, error) {
tripID := p.Source.(models.GroceryTrip).ID
categories := []models.GroceryTripCategory{}
query := db.Manager.
Joins("INNER JOIN store_categories ON store_categories.id = grocery_trip_categories.store_category_id").
Where("grocery_trip_categories.grocery_trip_id = ?", tripID).
Order("grocery_trip_categories.created_at DESC").
Find(&categories).
Error
if err := query; err != nil {
return nil, err
}
return categories, nil
},
},
},
},
)