我正在尝试将strfmt.DateTime类型(https://godoc.org/github.com/go- openapi/strfmt#DateTime)的时间戳写入mongodb
strfmt.DateTime
我可以成功地将这种日期格式写入数据库,如下所示:
{“ _id”:ObjectId(“ 5bcb58f7540ac6d0bc946e22”),“状态”:“测试”,“时间标记”:{“数据”:“ 2018-10-21T00:33:59.699 + 08:00”}}
但是我只是无法从mongodb中检索它,time_stamp的值始终显示0001-01-01T00:00:00.000Z,我只是不明白为什么。
0001-01-01T00:00:00.000Z
这是我的代码,欢迎任何建议或意见!谢谢
package main import ( "fmt" "time" "github.com/go-openapi/strfmt" "github.com/op/go-logging" "gopkg.in/mgo.v2" "gopkg.in/mgo.v2/bson" ) type TxStatus struct { Status string `json:"status" bson:"status"` TimeStamp *strfmt.DateTime `json:"time_stamp" bson:"time_stamp"` } type MongoDBOperations struct { mongoSession *mgo.Session database string collection string } var log = logging.MustGetLogger("example") func main() { mo := MongoDBOperations{} mo.database = Database mo.collection = Collection // We need this object to establish a session to our MongoDB. mongoDBDialInfo := &mgo.DialInfo{ Addrs: []string{MongoDBHosts}, Timeout: 60 * time.Second, Database: AuthDatabase, Username: AuthUserName, Password: AuthPassword, } // Create a session which maintains a pool of socket connections // to our MongoDB. var err error mo.mongoSession, err = mgo.DialWithInfo(mongoDBDialInfo) if err != nil { log.Fatalf("CreateSession: %s\n", err) } mo.mongoSession.SetMode(mgo.Eventual, true) write(mo) read(mo) } func write(mo MongoDBOperations) { log.Info("write operation") session := mo.mongoSession.Copy() defer session.Close() c := session.DB(Database).C(Collection) timestamp := strfmt.DateTime(time.Now()) txStatus := TxStatus{ Status: "test", TimeStamp: ×tamp, } if err2 := c.Insert(txStatus); err2 != nil { panic(err2) } } func read(mo MongoDBOperations) { log.Info("write operation") session := mo.mongoSession.Copy() defer session.Close() c := session.DB(Database).C(Collection) // Find and Count var status []TxStatus err2 := c.Find(bson.M{"status": "test"}).All(&status) if err2 != nil { panic(err2) } for _, elem := range status { fmt.Printf("%+v\n", elem) } }
我仔细研究了的代码,github.com/go- openapi/strfmt发现它们正在使用github.com/globalsign/mgo而不是gopkg.in/mgo.v2。更改进口使用方式github.com/globalsign/mgo并github.com/globalsign/mgo/bson解决了该问题。Globalsign包是其中的一个分支,mgo.v2因此方法保持不变,除了导入外,无需更改任何代码。
github.com/go- openapi/strfmt
github.com/globalsign/mgo
gopkg.in/mgo.v2
github.com/globalsign/mgo/bson
mgo.v2