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
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
|
Feature: Locators
Scenario: Define a locator without parameter
Given the OSM data
"""
"""
And the lua style
"""
local regions = osm2pgsql.define_locator()
print(regions:name())
"""
Then running osm2pgsql flex fails
And the error output contains
"""
Argument #1 to 'define_locator' must be a Lua table.
"""
Scenario: Define a locator with a name
Given the OSM data
"""
"""
And the lua style
"""
local regions = osm2pgsql.define_locator({ name = 'aname' })
print('NAME[' .. regions:name() .. ']')
"""
When running osm2pgsql flex
Then the standard output contains
"""
NAME[aname]
"""
Scenario: Define a locator without name is okay
Given the OSM data
"""
"""
And the lua style
"""
local regions = osm2pgsql.define_locator({})
print('NAME[' .. regions:name() .. ']')
"""
When running osm2pgsql flex
Then the standard output contains
"""
NAME[]
"""
Scenario: Calling name() on locator with . instead of : does not work
Given the OSM data
"""
"""
And the lua style
"""
local regions = osm2pgsql.define_locator({ name = 'test' })
print(regions.name())
"""
Then running osm2pgsql flex fails
And the error output contains
"""
Argument #1 has to be of type osm2pgsql.Locator.
"""
Scenario: Use a first_intersecting() without geometry fails
Given the OSM data
"""
n10 v1 dV Tamenity=post_box x0.5 y0.5
"""
And the lua style
"""
local regions = osm2pgsql.define_locator({ name = 'regions' })
regions:add_bbox('B1', 0.0, 0.0, 1.0, 1.0)
function osm2pgsql.process_node(object)
local r = regions:first_intersecting()
end
"""
Then running osm2pgsql flex fails
And the error output contains
"""
Error in 'first_intersecting': Need locator and geometry arguments
"""
Scenario: Use of all_intersecting() without geometry fails
Given the OSM data
"""
n10 v1 dV Tamenity=post_box x0.5 y0.5
"""
And the lua style
"""
local regions = osm2pgsql.define_locator({ name = 'regions' })
regions:add_bbox('B1', 0.0, 0.0, 1.0, 1.0)
function osm2pgsql.process_node(object)
local r = regions:all_intersecting()
end
"""
Then running osm2pgsql flex fails
And the error output contains
"""
Error in 'all_intersecting': Need locator and geometry arguments
"""
Scenario: Define and use a locator with first_intersecting
Given the OSM data
"""
n10 v1 dV Tamenity=post_box x0.5 y0.5
n11 v1 dV Tamenity=post_box x2.5 y2.5
n12 v1 dV Tamenity=post_box x1.5 y1.5
"""
And the lua style
"""
local regions = osm2pgsql.define_locator({ name = 'regions' })
regions:add_bbox('B1', 0.0, 0.0, 1.0, 1.0)
regions:add_bbox('B2', 1.0, 1.0, 2.0, 2.0)
local points = osm2pgsql.define_node_table('osm2pgsql_test_points', {
{ column = 'region', type = 'text' },
{ column = 'geom', type = 'point', projection = 4326 },
})
function osm2pgsql.process_node(object)
local g = object:as_point()
local r = regions:first_intersecting(g)
if r then
points:insert({
region = r,
geom = g,
})
end
end
"""
When running osm2pgsql flex
Then table osm2pgsql_test_points contains exactly
| node_id | region | ST_AsText(geom) |
| 10 | B1 | 0.5 0.5 |
| 12 | B2 | 1.5 1.5 |
Scenario: Define and use a locator with all_intersecting
Given the OSM data
"""
n10 v1 dV Tamenity=post_box x0.5 y0.5
n11 v1 dV Tamenity=post_box x2.5 y2.5
n12 v1 dV Tamenity=post_box x1.5 y1.5
n13 v1 dV Tamenity=post_box x1.0 y1.0
"""
And the lua style
"""
local regions = osm2pgsql.define_locator({ name = 'regions' })
regions:add_bbox('B1', 0.0, 0.0, 1.0, 1.0)
regions:add_bbox('B2', 1.0, 1.0, 2.0, 2.0)
local points = osm2pgsql.define_node_table('osm2pgsql_test_points', {
{ column = 'num_regions', type = 'int' },
{ column = 'geom', type = 'point', projection = 4326 },
})
function osm2pgsql.process_node(object)
local g = object:as_point()
local r = regions:all_intersecting(g)
if #r > 0 then
points:insert({
num_regions = #r,
geom = g,
})
end
end
"""
When running osm2pgsql flex
Then table osm2pgsql_test_points contains exactly
| node_id | num_regions | ST_AsText(geom) |
| 10 | 1 | 0.5 0.5 |
| 12 | 1 | 1.5 1.5 |
| 13 | 2 | 1 1 |
Scenario: Define and use a locator with polygon from db
Given the 10.0 grid with origin 10.0 10.0
| 10 | 11 |
| 12 | |
And the OSM data
"""
w20 v1 dV Tsome=boundary Nn10,n11,n12,n10
"""
And the lua style
"""
local regions = osm2pgsql.define_way_table('osm2pgsql_test_regions', {
{ column = 'region', type = 'text' },
{ column = 'geom', type = 'polygon', projection = 4326 },
})
function osm2pgsql.process_way(object)
regions:insert({
region = 'P1',
geom = object:as_polygon(),
})
end
"""
When running osm2pgsql flex
Then table osm2pgsql_test_regions contains exactly
| way_id | region | ST_AsText(geom) |
| 20 | P1 | (10 0,20 10,10 10,10 0) |
Given an empty grid
And the OSM data
"""
n10 v1 dV Tamenity=post_box x15.0 y8.0
n11 v1 dV Tamenity=post_box x15.0 y2.0
"""
And the lua style
"""
local regions = osm2pgsql.define_locator({ name = 'regions' })
regions:add_from_db('SELECT region, geom FROM osm2pgsql_test_regions')
local points = osm2pgsql.define_node_table('osm2pgsql_test_points', {
{ column = 'region', type = 'text' },
{ column = 'geom', type = 'point', projection = 4326 },
})
function osm2pgsql.process_node(object)
local g = object:as_point()
local r = regions:first_intersecting(g)
if r then
points:insert({
region = r,
geom = g,
})
end
end
"""
When running osm2pgsql flex
Then table osm2pgsql_test_points contains exactly
| node_id | region | ST_AsText(geom) |
| 10 | P1 | 15 8 |
Scenario: Define and use a locator with relation from db
Given the 10.0 grid with origin 10.0 10.0
| 10 | 11 | 12 |
| 13 | 14 | 15 |
And the OSM data
"""
w29 v1 dV Tregion=P1 Nn10,n11,n14,n13,n10
"""
And the lua style
"""
local regions = osm2pgsql.define_way_table('osm2pgsql_test_regions', {
{ column = 'region', type = 'text' },
{ column = 'geom', type = 'polygon', projection = 4326 },
})
function osm2pgsql.process_way(object)
regions:insert({
region = object.tags.region,
geom = object:as_polygon(),
})
end
"""
When running osm2pgsql flex
Then table osm2pgsql_test_regions contains exactly
| way_id | region | ST_AsText(geom) |
| 29 | P1 | (10 0,20 0,20 10,10 10, 10 0) |
Given the 10.0 grid with origin 10.0 10.0
| 10 | 11 | 12 |
| 13 | 14 | 15 |
And the OSM data
"""
w20 v1 dV Nn10,n11,n13
w21 v1 dV Nn13,n10
w22 v1 dV Nn14,n15
w23 v1 dV Nn12,n15
r30 v1 dV Tfoo=bar Mw20@,w21@,w22@,n12@
r31 v1 dV Tfoo=bar Mn12@,n15@
r32 v1 dV Tfoo=bar Mw23@
"""
And the lua style
"""
local regions = osm2pgsql.define_locator({ name = 'regions' })
regions:add_from_db('SELECT region, geom FROM osm2pgsql_test_regions')
local points = osm2pgsql.define_relation_table('osm2pgsql_test_rels', {
{ column = 'region', type = 'text' },
{ column = 'geom', type = 'geometry', projection = 4326 },
})
function osm2pgsql.process_relation(object)
local g = object:as_geometrycollection()
local r = regions:first_intersecting(g)
if r then
points:insert({
region = r,
geom = g,
})
end
end
"""
When running osm2pgsql flex
Then table osm2pgsql_test_rels contains exactly
| relation_id | region | ST_GeometryType(geom) |
| 30 | P1 | ST_GeometryCollection |
|
