From c4175e0b74f7c2d2ec5e0687e8a65e12afcd9067 Mon Sep 17 00:00:00 2001 From: Santo Cariotti Date: Sun, 20 Oct 2024 22:21:24 +0200 Subject: Fix new position creation time --- src/graphql/types/position.rs | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'src') diff --git a/src/graphql/types/position.rs b/src/graphql/types/position.rs index 3d0c38f..35d448d 100644 --- a/src/graphql/types/position.rs +++ b/src/graphql/types/position.rs @@ -237,7 +237,8 @@ pub mod mutations { client.query( "UPDATE positions SET location = ST_SetSRID(ST_MakePoint($1, $2), 4326), - activity = $3 + activity = $3, + created_at = now() WHERE user_id = $4 RETURNING id, user_id, extract(epoch from created_at)::double precision as created_at, ST_Y(location::geometry) AS latitude, ST_X(location::geometry) AS longitude, activity ", -- cgit v1.2.3-18-g5258