ref: 23690d53dd05b1a2051fcb8745a1c1a8d45165c1
server/db/position.go
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 |
/** * Yats - yats * * This file is licensed under the Affero General Public License version 3 or * later. See the COPYING file. * * @author Paolo Lulli <kevwe.com> * @copyright Paolo Lulli 2024 */ package db import ( "fmt" "time" ) func SavePosition(idClient string, lat float64, lon float64, positionName string) { q := fmt.Sprintf("insert into position ( id_client, ptime, lat, lon, name) values ('%s',toTimestamp(now()),'%f','%f','%s');", idClient, lat, lon, positionName) fmt.Printf("q=%s", q) Session.Query(q).Exec() } func SavePositionAt(idClient string, lat float64, lon float64, tstamp time.Time, positionName string) { timeAsBytes, _ := tstamp.UTC().MarshalText() q := fmt.Sprintf("insert into position ( id_client, ptime, lat, lon, name) values ('%s','%s','%f','%f','%s');", idClient, string(timeAsBytes), lat, lon, positionName) Session.Query(q).Exec() } |