Overview

Project website www.tarantool.io/en/doc/latest
Translation process
  • Translations can be made directly.
  • Translation suggestions can be made.
  • Any authenticated user can contribute.
  • The translation uses bilingual files.
Source code repository git@github.com:tarantool/doc.git
Repository branch test-weblate
Weblate repository http://weblate.tarantool.io/git/testing_project/documentation-referencereference_luabox_spaceauto_increment/
File mask locale/*/LC_MESSAGES/reference/reference_lua/box_space/create_index.po
Translation file Not available
Last change None
Last author None

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 155 2,406 17,649
Translated 100% 155 100% 2,406 100% 17,649
Needs editing 0% 0 0% 0 0% 0
Read-only 100% 155 100% 2,406 100% 17,649
Failing checks 8% 13 16% 404 20% 3,670
Strings with suggestions 0% 0 0% 0 0% 0
Untranslated strings 0% 0 0% 0 0% 0
Last 12 months Previous

Activity in last 12 months

0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 155 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes
Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar

Quick numbers

2,406
Hosted words
155
Hosted strings
100%
Translated
0
Contributors
and previous 30 days

Trends of last 30 days

—
Hosted words
+100%
—
Hosted strings
+100%
—
Translated
+100%
—
Contributors
—
User avatar None

New source string

testing_project / Documentation: reference/reference_lua/box_space/create_index — English

tester = box.schema.space.create('withdata')
tester:format({ { name = 'name', type = 'string' },
{ name = 'address', type = 'string' } })
name_index = tester:create_index('name', { parts = { { field = 1, type = 'string' } } })
function_code = [[function(tuple)
local address = string.split(tuple[2])
local ret = {}
for _, v in pairs(address) do
table.insert(ret, {utf8.upper(v)})
end
return ret
end]]
box.schema.func.create('address',
{ body = function_code,
is_deterministic = true,
is_sandboxed = true,
is_multikey = true })
addr_index = tester:create_index('addr', { unique = false,
func = 'address',
parts = { { field = 1, type = 'string',
collation = 'unicode_ci' } } })
tester:insert({ "James", "SIS Building Lambeth London UK" })
tester:insert({ "Sherlock", "221B Baker St Marylebone London NW1 6XE UK" })
addr_index:select('Uk')
a year ago
User avatar None

New source string

testing_project / Documentation: reference/reference_lua/box_space/create_index — English

To create a multikey function, the options of ``box.schema.func.create()`` must include ``is_multikey = true``. The return value must be a table of tuples. If a multikey function returns N tuples, then N keys will be added to the index.
a year ago
User avatar None

New source string

testing_project / Documentation: reference/reference_lua/box_space/create_index — English

Functions for functional indexes can return **multiple keys**. Such functions are called "multikey" functions.
a year ago
User avatar None

New source string

testing_project / Documentation: reference/reference_lua/box_space/create_index — English

box.schema.space.create('tester')
box.space.tester:create_index('i', { parts = { { field = 1, type = 'string' } } })
function_code = [[function(tuple) return {string.sub(tuple[2],1,1)} end]]
box.schema.func.create('my_func',
{ body = function_code, is_deterministic = true, is_sandboxed = true })
box.space.tester:create_index('func_index', { parts = { { field = 1, type = 'string' } },
func = 'my_func' })
box.space.tester:insert({ 'a', 'wombat' })
box.space.tester:insert({ 'b', 'rabbit' })
box.space.tester.index.func_index:select('w')
box.space.tester.index.func_index:select(box.func.my_func:call({ { 'tester', 'wombat' } }))
a year ago
User avatar None

New source string

testing_project / Documentation: reference/reference_lua/box_space/create_index — English

Here is the full code of the example:
a year ago
User avatar None

New source string

testing_project / Documentation: reference/reference_lua/box_space/create_index — English

tarantool> box.space.tester.index.func_index:select('w')
---
- - ['a', 'wombat']
...
tarantool> box.space.tester.index.func_index:select(box.func.my_func:call({{'tester','wombat'}}));
---
- - ['a', 'wombat']
...
a year ago
User avatar None

New source string

testing_project / Documentation: reference/reference_lua/box_space/create_index — English

The results of the two ``select`` requests will look like this:
a year ago
User avatar None

New source string

testing_project / Documentation: reference/reference_lua/box_space/create_index — English

box.space.tester:insert({ 'a', 'wombat' })
box.space.tester:insert({ 'b', 'rabbit' })
box.space.tester.index.func_index:select('w')
box.space.tester.index.func_index:select(box.func.my_func:call({ { 'tester', 'wombat' } }))
a year ago
User avatar None

New source string

testing_project / Documentation: reference/reference_lua/box_space/create_index — English

Insert a few tuples. Select using only the first letter, it will work because that is the key. Or, select using the same function as was used for insertion:
a year ago
User avatar None

New source string

testing_project / Documentation: reference/reference_lua/box_space/create_index — English

box.space.tester:create_index('func_index', { parts = { { field = 1, type = 'string' } },
func = 'my_func' })
a year ago
Browse all translation changes