How to get a struct in graphql resolvers with xorm?

Asked May 02 '20 at 13:58

Active May 02 '20 at 13:58

Viewed 54 times

Here is the struct in models_gen.go

type Students struct {
    StudentID       string          `json:"student_id"`
    Class           string          `json:"class"`
    TestsHistory    []*TestsHistory `json:"test_history" 
}

type TestsHistory struct {
    English    string      `json:"eng"`
    Math       string      `json:"math"`
    Music      string      `json:"music"`
    PE         string      `json:"pe"`
}

The query function in resolvers.go:

func (r *queryResolver) GetStudents(ctx context.Context, id *int) (*model.Students, error) {
   var students []*model.students       
   engine.Sync2(new(model.students))
   fmt.Printf("%v\n", engine.Find(students))
   return nil, nil
}

When I check MySQL, the students table only contains "StudentID" and "Class" Field, no "TestsHistory". How do I get "TestsHistory" in resolvers?

asked May 02 '20 at 13:58

Emily

enable `engine.ShowSQL(true)` and see weather xorm tries to create table and if so, what does the log says ? – Mohammadreza Mirhajianmoghadam May 02 '20 at 14:37
xorm did create the table, but only created two fields, there's no TestsHistory. How do I do that? – Emily May 02 '20 at 15:00
Why do you sync in a resolver ? Instead of syncing when graph server starts ? – Mohammadreza Mirhajianmoghadam May 02 '20 at 16:04

How to get a struct in graphql resolvers with xorm?

0 Answers0