func writedata(ProtoMessage *msgproto.Msg) { db, err := sql.Open("postgres", "user=postgres password='******' dbname=test sslmode=disable ") if err != nil { fmt.Println(err) } rows, err := db.Exec("INSERT INTO public.data values($1,$2,$3,to_timestamp($4))", ProtoMessage.GetId(), ProtoMessage.GetLat(), ProtoMessage.GetLong(), ProtoMessage.GetUtime()) if err != nil { fmt.Println(err) } fmt.Println(rows) }
func writedata(ProtoMessage *msgproto.Msg) { db, err := sql.Open("postgres", "user=postgres password='******' dbname=test sslmode=disable ") if err != nil { fmt.Println(err) } //var query string //string = "INSERT INTO bus_" + string(ProtoMessage.GetId()) + " values(" + strconv.FormatInt(ProtoMessage.GetLat(), 10) + "," + strconv.FormatInt(ProtoMessage.GetLong(), 10) + "," + strconv.FormatInt(ProtoMessage.GetUtime(), 10) rows, err := db.Exec("INSERT INTO $1 values($2,$3,to_timestamp($4))", ProtoMessage.GetId(), ProtoMessage.GetLat(), ProtoMessage.GetLong(), ProtoMessage.GetUtime()) if err != nil { fmt.Println(err) } fmt.Println(rows) }