Skip to content

v0.2.50..v0.2.51 changeset changeset 3.osc.sql

Garret Voltz edited this page Jan 15, 2020 · 1 revision
diff --git a/test-files/cmd/slow/serial/ServiceChangesetDeriveCmdSqlTest/changeset-3.osc.sql b/test-files/cmd/slow/serial/ServiceChangesetDeriveCmdSqlTest/changeset-3.osc.sql
new file mode 100644
index 0000000..e65d5b1
--- /dev/null
+++ b/test-files/cmd/slow/serial/ServiceChangesetDeriveCmdSqlTest/changeset-3.osc.sql
@@ -0,0 +1,22 @@
+INSERT INTO changesets (id, user_id, created_at, closed_at) VALUES (3, 1, (now() at time zone 'utc'), (now() at time zone 'utc'));
+INSERT INTO changeset_tags (changeset_id, k, v) VALUES (3, 'written_by', 'Hootenanny');
+/* create node 1669791*/
+INSERT INTO nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669791, 388549524, 1048987389, 3, true, (now() at time zone 'utc'), 3852309038, 1);
+INSERT INTO current_nodes (id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669791, 388549524, 1048987389, 3, true, (now() at time zone 'utc'), 3852309038, 1);
+/* create node 1669793*/
+INSERT INTO nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669793, 388549321, 1048979050, 3, true, (now() at time zone 'utc'), 3852309038, 1);
+INSERT INTO current_nodes (id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669793, 388549321, 1048979050, 3, true, (now() at time zone 'utc'), 3852309038, 1);
+/* create way 1669801*/
+INSERT INTO ways (way_id, changeset_id, visible, "timestamp", version) VALUES (1669801, 3, true, (now() at time zone 'utc'), 1);
+INSERT INTO current_ways (id, changeset_id, visible, "timestamp", version) VALUES (1669801, 3, true, (now() at time zone 'utc'), 1);
+INSERT INTO current_way_tags (way_id, k, v) VALUES (1669801, 'highway', 'road');
+INSERT INTO way_tags (way_id, k, v, version) VALUES (1669801, 'highway', 'road', 1);
+INSERT INTO current_way_tags (way_id, k, v) VALUES (1669801, 'note', '1');
+INSERT INTO way_tags (way_id, k, v, version) VALUES (1669801, 'note', '1', 1);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669801, 1669731, 1, 1);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669801, 1669731, 1);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669801, 1669791, 1, 2);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669801, 1669791, 2);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669801, 1669793, 1, 3);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669801, 1669793, 3);
+UPDATE changesets SET min_lat=388549321, max_lat=388549524, min_lon=1048979050, max_lon=1048987389, num_changes=3 WHERE id=3;
Clone this wiki locally