Add tests filemain

1 files changed, 19 insertions, 0 deletions

diff --git a/tests/insert-positions.sql b/tests/insert-positions.sql
new file mode 100644
index 0000000..c287f29
--- /dev/null
+++ b/tests/insert-positions.sql
@@ -0,0 +1,19 @@
+INSERT INTO positions (user_id, location, activity)
+VALUES
+    (1, ST_GeogFromText('SRID=4326;POINT(11.3339 44.5010)'), 'Still'),
+    (2, ST_GeogFromText('SRID=4326;POINT(11.3565 44.4967)'), 'Still'),
+    (3, ST_GeogFromText('SRID=4326;POINT(11.3490 44.4958)'), 'InVehicle'),
+    (4, ST_GeogFromText('SRID=4326;POINT(11.3411 44.4952)'), 'Still'),
+    (5, ST_GeogFromText('SRID=4326;POINT(11.3439 44.4971)'), 'Walking'),
+    (6, ST_GeogFromText('SRID=4326;POINT(11.3403 44.4936)'), 'Running'),
+    (7, ST_GeogFromText('SRID=4326;POINT(11.3485 44.4969)'), 'InVehicle'),
+    (8, ST_GeogFromText('SRID=4326;POINT(11.3442 44.4932)'), 'Still'),
+    (9, ST_GeogFromText('SRID=4326;POINT(11.3465 44.4978)'), 'Walking'),
+    (10, ST_GeogFromText('SRID=4326;POINT(11.3453 44.4941)'), 'Running'),
+    (11, ST_GeogFromText('SRID=4326;POINT(11.3155 44.5313)'), 'InVehicle'),
+    (12, ST_GeogFromText('SRID=4326;POINT(11.5789 44.5246)'), 'Still'),
+    (13, ST_GeogFromText('SRID=4326;POINT(11.7339 44.2956)'), 'Walking'),
+    (14, ST_GeogFromText('SRID=4326;POINT(11.2258 44.6452)'), 'Running'),
+    (15, ST_GeogFromText('SRID=4326;POINT(11.0708 44.5426)'), 'InVehicle');
+    (16, ST_GeogFromText('SRID=4326;POINT(11.3426 44.4949)'), 'Walking'),
+    (17, ST_GeogFromText('SRID=4326;POINT(11.3450 44.4965)'), 'Running'),