File: rtree_array.test.lua

package info (click to toggle)
tarantool 2.6.0-1.4
  • links: PTS, VCS
  • area: main
  • in suites: sid, trixie
  • size: 85,412 kB
  • sloc: ansic: 513,775; cpp: 69,493; sh: 25,650; python: 19,190; perl: 14,973; makefile: 4,178; yacc: 1,329; sql: 1,074; pascal: 620; ruby: 190; awk: 18; lisp: 7
file content (69 lines) | stat: -rw-r--r-- 2,298 bytes parent folder | download | duplicates (5)
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
s = box.schema.space.create('spatial')
_ = s:create_index('primary')
spatial = s:create_index('spatial', { type = 'rtree', unique = false, parts = {2, 'array'}})

spatial.type

s:insert{1,{0.0,0.0}}
s:insert{2,{0.0,10.0}}
s:insert{3,{0.0,50.0}}
s:insert{4,{10.0,0.0}}
s:insert{5,{50.0,0.0}}
s:insert{6,{10.0,10.0}}
s:insert{7,{10.0,50.0}}
s:insert{8,{50.0,10.0}}
s:insert{9,{50.0,50.0}}

-- select all records
s.index.spatial:select({}, {iterator = 'ALL'})
-- select records belonging to rectangle (0,0,10,10)
s.index.spatial:select({0.0,0.0,10.0,10.0}, {iterator = 'LE'})
-- select records with coordinates (10,10)
s.index.spatial:select({10.0,10.0}, {iterator = 'EQ'})
-- select neighbors of point (5,5)
s.index.spatial:select({5.0,5.0}, {iterator = 'NEIGHBOR'})

s:drop()

s = box.schema.space.create('spatial')
_ = s:create_index('primary')
spatial = s:create_index('spatial', { type = 'rtree', unique = false, parts = {2, 'array'}, dimension = 8})

spatial.type

s:insert{ 1,{0, 0, 0, 0, 0, 0, 0, 0}}
s:insert{ 2,{10, 0, 0, 0, 0, 0, 0, 0}}
s:insert{ 3,{0, 10, 0, 0, 0, 0, 0, 0}}
s:insert{ 4,{0, 0, 10, 0, 0, 0, 0, 0}}
s:insert{ 5,{0, 0, 0, 10, 0, 0, 0, 0}}
s:insert{ 6,{0, 0, 0, 0, 10, 0, 0, 0}}
s:insert{ 7,{0, 0, 0, 0, 0, 10, 0, 0}}
s:insert{ 8,{0, 0, 0, 0, 0, 0, 10, 0}}
s:insert{ 9,{0, 0, 0, 0, 0, 0, 0, 10}}
s:insert{10,{50, 0, 0, 0, 0, 0, 0, 0}}
s:insert{11,{0, 50, 0, 0, 0, 0, 0, 0}}
s:insert{12,{0, 0, 50, 0, 0, 0, 0, 0}}
s:insert{13,{0, 0, 0, 50, 0, 0, 0, 0}}
s:insert{14,{0, 0, 0, 0, 50, 0, 0, 0}}
s:insert{15,{0, 0, 0, 0, 0, 50, 0, 0}}
s:insert{16,{0, 0, 0, 0, 0, 0, 50, 0}}
s:insert{17,{0, 0, 0, 0, 0, 0, 0, 50}}
s:insert{18,{10, 10, 10, 10, 10, 10, 10, 10}}
s:insert{19,{10, 50, 10, 50, 10, 50, 10, 50}}
s:insert{20,{0, 10, 50, 0, 10, 50, 0, 10}}

p0 = {0, 0, 0, 0, 0, 0, 0, 0}
p5 = {5, 5, 5, 5, 5, 5, 5, 5}
p10 = {10, 10, 10, 10, 10, 10, 10, 10 }
rt0_10 = {0, 0, 0, 0, 0, 0, 0, 0, 10, 10, 10, 10, 10, 10, 10, 10 }

-- select all records
s.index.spatial:select({}, {iterator = 'ALL'})
-- select records belonging to rectangle (0,0,..10,10,..)
s.index.spatial:select(rt0_10, {iterator = 'LE'})
-- select records with coordinates (10,10)
s.index.spatial:select(p10, {iterator = 'EQ'})
-- select neighbors of point (5,5)
s.index.spatial:select(p5, {iterator = 'NEIGHBOR'})

s:drop()