Loading…
 None
New source string testing_project / Documentation: reference/reference_lua/box_index/pairs — English |
Loading…
|
None
New source string testing_project / Documentation: reference/reference_lua/box_index/pairs — English |
tarantool> bands:insert{1, 'Roxette', 1986}
bands:insert{2, 'Scorpions', 1965}
bands:insert{3, 'Ace of Base', 1987}
bands:insert{4, 'The Beatles', 1960}
bands:insert{5, 'Pink Floyd', 1965}
bands:insert{6, 'The Rolling Stones', 1962}
bands:insert{7, 'The Doors', 1965}
bands:insert{8, 'Nirvana', 1987}
bands:insert{9, 'Led Zeppelin', 1968}
bands:insert{10, 'Queen', 1970}
---
...
-- Select all tuples by the primary index --
tarantool> for _, tuple in bands.index.primary:pairs() do
print(tuple)
end
[1, 'Roxette', 1986]
[2, 'Scorpions', 1965]
[3, 'Ace of Base', 1987]
[4, 'The Beatles', 1960]
[5, 'Pink Floyd', 1965]
[6, 'The Rolling Stones', 1962]
[7, 'The Doors', 1965]
[8, 'Nirvana', 1987]
[9, 'Led Zeppelin', 1968]
[10, 'Queen', 1970]
---
...
-- Select all tuples whose secondary key values start with the specified string --
tarantool> for _, tuple in bands.index.band:pairs("The", {iterator = "GE"}) do
if (string.sub(tuple[2], 1, 3) ~= "The") then break end
print(tuple)
end
[4, 'The Beatles', 1960]
[7, 'The Doors', 1965]
[6, 'The Rolling Stones', 1962]
---
...
-- Select all tuples whose secondary key values are between 1965 and 1970 --
tarantool> for _, tuple in bands.index.year:pairs(1965, {iterator = "GE"}) do
if (tuple[3] > 1970) then break end
print(tuple)
end
[2, 'Scorpions', 1965]
[5, 'Pink Floyd', 1965]
[7, 'The Doors', 1965]
[9, 'Led Zeppelin', 1968]
[10, 'Queen', 1970]
---
...
-- Select all tuples after the specified tuple --
tarantool> for _, tuple in bands.index.primary:pairs({}, {after={7, 'The Doors', 1965}}) do
print(tuple)
end
[8, 'Nirvana', 1987]
[9, 'Led Zeppelin', 1968]
[10, 'Queen', 1970]
---
...