du1068 2018-04-26 18:16
浏览 37
已采纳

大猩猩Mux和GORM失败

I followed this tutorial on how to setup a basic API with PostgreSQL, Gorilla Mux and GORM.

This is my app:

package main

import (
    "encoding/json"
    "net/http"

    "github.com/gorilla/mux"
    "github.com/jinzhu/gorm"
    _ "github.com/jinzhu/gorm/dialects/postgres"
)

var db *gorm.DB


type Ticket struct {
    gorm.Model
    InfoHash string
    Status   *int `gorm:"default:'0'"`
}


func main() {
    router := mux.NewRouter()

    db, err := gorm.Open("postgres", "host=localhost user=user dbname=db_development password=password sslmode=disable")
    db.LogMode(true)

    if err != nil {
        panic(err)
    }
    defer db.Close()

    db.AutoMigrate(&Ticket{})

    router.HandleFunc("/", TicketsIndex).Methods("GET")

    http.ListenAndServe(":3000", router)
}

func TicketsIndex(w http.ResponseWriter, r *http.Request) {
    tickets := []Ticket{}
    db.Find(&tickets)
    json.NewEncoder(w).Encode(&tickets)
}

The problem is when I visit localhost:3000, the server just stops with no error logs, just stops and exit the app. It should return the tickets stored in the database as JSON.

I got it working if I open the database in my TicketsIndex function and close it, like this:

func TicketsIndex(w http.ResponseWriter, r *http.Request) {
  db, err := gorm.Open("postgres", "host=localhost user=user dbname=db_development password=password sslmode=disable")
  tickets := []Ticket{}
  db.Find(&tickets)
  json.NewEncoder(w).Encode(&tickets)
  defer db.Close()
}

But I think this is not the proper way. I also try to move this code into the main function and also works:

tickets := []Ticket{}
db.Find(&tickets)

So I am assuming it could be the global variable var db *gormDB that is not being assigned correctly. What am I doing wrong?

  • 写回答

1条回答 默认 最新

  • doutian4046 2018-04-26 21:48
    关注

    When you type db, err := ... you're actually shadowing the global var db with a function-local variable named db, not assigning to the global one. You need to use the equal sign (= vs :=) to assign to an already defined var. That also means you'll need to write var err error inside of main scope before the assignment, since you're no longer getting declaration automatically from :=.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 cpuid是如何转换的
  • ¥15 MddBootstrapInitialize2失败
  • ¥15 LCD Flicker
  • ¥15 Spring MVC项目,访问不到相应的控制器方法
  • ¥15 esp32在micropython环境下使用ssl/tls连接mqtt服务器出现以下报错Connected on 192.168.154.223发生意外错误: 5无法连接到 MQTT 代理,如何解决?
  • ¥15 关于#genesiscsheel#的问题,如何解决?
  • ¥15 Android aidl for hal
  • ¥15 STM32CubeIDE下载程序报错
  • ¥15 微信好友如何转变为会员系统?(相关搜索:小程序)
  • ¥15 c# 直接使用c++ 类库文件