douyan3478
2018-11-13 14:47
浏览 599

如何在PostgreSQL中跟踪SQL查询

sql.Register("sqlWithHooks", sqlhooks.Wrap(r.Driver(), &Hooks{}))

// Connect to the registered wrapped driver
db, err := sql.Open("sqlWithHooks", ":memory:")
if err != nil {
    fmt.Println("error",err)

}

rows, err := db.Query("SELECT id,name,zone_z_id,dimension,price FROM   gift_box_z ")

if err != nil {
    fmt.Println("inside the error .........................",err)

}

After running this code I am getting an error missing "=" after ":memory:" in connection info string. Can anyone tell me what's wrong with what I've done here?

  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

2条回答 默认 最新

  • dongyi2425 2018-11-13 19:34
    已采纳

    sql.Open() expects 2 things 'driverName' and 'dataSourceName'. In case of sqlhooks example, they used sqlite as database. Apart from that, they have used go-sqlite3 and if you look closely to file sqlite3.go at line number 886. You would see datasourcename ':memory:' that means we are opting for in-memory utilization of sqlite db.

    'dataSourceName' will vary as per the database opted. Its basically means connection string in Data Source Name format.

    Reason why this worked fmt.Sprintf("host=%s port=%d user=%s password=%s dbname=%s sslmode=disable", host, port, user, password, dbname)

    打赏 评论
  • douxin8749 2018-11-13 14:55

    The second argument of sql.Open() expects a connection string. It has the following form:

    fmt.Sprintf("host=%s port=%d user=%s password=%s dbname=%s sslmode=disable",
                host, port, user, password, dbname)
    

    It contains the needed information to open a connection to Postgres.

    打赏 评论

相关推荐 更多相似问题