-
Notifications
You must be signed in to change notification settings - Fork 12
/
state_read_repository.go
57 lines (49 loc) · 1.63 KB
/
state_read_repository.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
package repository
import (
"context"
"github.com/neo4j/neo4j-go-driver/v5/neo4j"
"github.com/neo4j/neo4j-go-driver/v5/neo4j/dbtype"
"github.com/openline-ai/openline-customer-os/packages/server/customer-os-common-module/utils"
"github.com/opentracing/opentracing-go"
"github.com/opentracing/opentracing-go/log"
)
type StateReadRepository interface {
GetStatesByCountryId(ctx context.Context, countryId string) ([]*dbtype.Node, error)
}
type stateReadRepository struct {
driver *neo4j.DriverWithContext
database string
}
func NewStateReadRepository(driver *neo4j.DriverWithContext, database string) StateReadRepository {
return &stateReadRepository{
driver: driver,
database: database,
}
}
func (r *stateReadRepository) GetStatesByCountryId(ctx context.Context, countryId string) ([]*dbtype.Node, error) {
span, ctx := opentracing.StartSpanFromContext(ctx, "UserRepository.FindUserByEmail")
defer span.Finish()
span.LogFields(log.String("countryId", countryId))
session := utils.NewNeo4jWriteSession(ctx, *r.driver)
defer session.Close(ctx)
dbRecords, err := session.ExecuteRead(ctx, func(tx neo4j.ManagedTransaction) (any, error) {
params := map[string]any{
"countryId": countryId,
}
queryResult, err := tx.Run(ctx, "MATCH (s:State)-[:BELONGS_TO_COUNTRY]->(c:Country { id: $countryId }) RETURN s", params)
if err != nil {
return nil, err
}
return queryResult.Collect(ctx)
})
if err != nil {
return nil, err
}
dbNodes := []*dbtype.Node{}
for _, v := range dbRecords.([]*neo4j.Record) {
if v.Values[0] != nil {
dbNodes = append(dbNodes, utils.NodePtr(v.Values[0].(dbtype.Node)))
}
}
return dbNodes, err
}