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)
}
