GraphQL 查詢字段 post 和 list 返回除 created_at 之外的所有數據。它始終為空。我檢查GetPostBySlug和GetPostList變量,它包含來自 Postgres 的數據。我的錯誤在哪里?模型.gopackage posttype Post struct { Slug string `db:"slug"` Title string `db:"title"` Content string `db:"content"` Author string `db:"author"` Category string `db:"category"` CreatedAt string `db:"created_at"` Published bool `db:"published"`}存儲庫.gopackage postimport ( "context" "errors" "fmt" "log" "os" "time" "github.com/jackc/pgx/v4" "github.com/joho/godotenv")var ( db *pgx.Conn Info *log.Logger Warning *log.Logger Error *log.Logger)func init() { err := godotenv.Load("environment/.env") if err != nil { Error.Fatalf("Can't read \".env\" file: %s\n", err.Error()) } Info = log.New(os.Stdout, "INFO: ", log.Ldate|log.Ltime|log.Lshortfile) Warning = log.New(os.Stdout, "WARNING: ", log.Ldate|log.Ltime|log.Lshortfile) Error = log.New(os.Stderr, "ERROR: ", log.Ldate|log.Ltime|log.Lshortfile) db, err = pgx.Connect( context.Background(), fmt.Sprintf( "postgres://%s:%s@%s:%s/%s", os.Getenv("POSTGRES_USER"), os.Getenv("POSTGRES_PASSWORD"), os.Getenv("POSTGRES_HOST"), os.Getenv("POSTGRES_PORT"), os.Getenv("POSTGRES_DB"), ), ) if err != nil { Error.Fatalf("Can't connect to database: %s\n", err.Error()) }}func GetPostBySlug(ctx context.Context, slug string) (result interface{}) { row, err := db.Query(ctx, "SELECT slug, title, content, author, category, created_at, published FROM posts WHERE slug=$1 LIMIT 1", slug) if err != nil { Warning.Printf("GetPostBySlug query: %v\n", err.Error()) return err }
- 1 回答
- 0 關注
- 79 瀏覽
添加回答
舉報
0/150
提交
取消