The translation is temporarily closed for contributions due to maintenance, please come back later.
The translation was automatically locked due to following alerts: Could not merge the repository.
Zen

Source string Source string

163/10000 · 163
English Actions
**SQL_TEXT** is a single non-empty SQL statement. For SQL syntax, see https://sqlite.org/lang.html
**SQL_BIND** is an optional array of bindings (parameters). Each parameter value is a scalar: number, string, binary, null.
A parameter can be *ordinal* or *named*. An ordinal parameter is encoded as a message pack scalar value (MP_UINT, INT, DOUBLE, FLOAT, STR, BIN, EXT, NIL). A named parameter is encoded as a map with one string key -- its name. For bindings syntax, see https://sqlite.org/lang_expr.html#varparam
**Examples:**
:code:`[100, 'abc', NULL, -345.6] = MP_ARRAY[ MP_UINT, MP_STR, MP_NIL, MP_DOUBLE ]`
:code:`[1, 2, {'name': 300}] = MP_ARRAY[ MP_UINT, MP_UINT, MP_MAP{ MP_STR : MP_UINT } ]`
Response packet body
Body structure depends on the type of the SQL request.
If the SQL request is SELECT, the response contains:
metadata for columns (metadata for a single column contains only the column's name and type) and
result rows.
EXECUTE SELECT RESPONSE BODY:
MAP
+======================================+===========================+
| | |
| 0x32: METADATA | |
| MP_ARRAY: array of maps: | |
| +~~~~~~~~~~~~~~~~~~~~~~~~+ | |
| | +~~~~~~~~~~~~~~~~~~~~+ | | 0x30: DATA |
| | | 0x00: FIELD_NAME | | | MP_ARRAY: array of tuples |
| | | MP_STR: field name | | | |
| | | 0x01: FIELD_TYPE | | | |
| | | MP_STR: field type | | | |
| | +~~~~~~~~~~~~~~~~~~~~+ | | |
| | MP_MAP | | |
| +~~~~~~~~~~~~~~~~~~~~~~~~+ | |
| MP_ARRAY | |
| | |
+======================================+===========================+
**Example:**
Request: :code:`SELECT x, y FROM test_space;`
Response:
BODY = {
METADATA = [
{ FIELD_NAME: 'X', FIELD_TYPE: 'TEXT'}, { FIELD_NAME: 'Y', FIELD_TYPE: 'INTEGER'},
DATA = [ ['a', 1], ['c', 2], ['e', 5], ... ]
}
If the SQL request is not SELECT, the response body contains only SQL_INFO. Usually SQL_INFO is a map with only one key -- SQL_INFO_ROW_COUNT (0) -- which is the number of changed rows. For example, if the request is :code:`INSERT INTO test VALUES (1), (2), (3)`, the response body contains an SQL_INFO map with SQL_INFO_ROW_COUNT = 3. SQL_INFO_ROW_COUNT can be 0 for statements that do not change rows, such as CREATE TABLE.
The SQL_INFO map may contain a second key -- SQL_INFO_AUTO_INCREMENT_IDS (1) -- which is the new primary-key value for an INSERT in a table defined with PRIMARY KEY AUTOINCREMENT. In this case the MP_MAP will have two keys, and one of the two keys will be 0x01: SQL_INFO_AUTO_INCREMENT_IDS, which is an array of unsigned integers.
EXECUTE NOT-SELECT RESPONSE BODY:

+=========================================================+
| |
| 0x42: SQL_INFO |
| MP_MAP: usually 1 key +~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+ |
| | | |
| | 0x00: SQL_INFO_ROW_COUNT | |
| | MP_UINT: changed row count | |
| | | |
| +~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+ |
| |
+=========================================================+

Loading…

User avatar None

New source string

testing_project / Documentation: dev_guide/internals/sql_protocol — English

BODY = {
METADATA = [
{ FIELD_NAME: 'X', FIELD_TYPE: 'TEXT'}, { FIELD_NAME: 'Y', FIELD_TYPE: 'INTEGER'},
DATA = [ ['a', 1], ['c', 2], ['e', 5], ... ]
}
a year ago
Browse all string changes

Things to check

Ellipsis

The string uses three dots (...) instead of an ellipsis character (…)

Reset

Glossary

English English
No related strings found in the glossary.

String information

Flags
read-only
String age
a year ago
Last updated
a year ago
Source string age
a year ago
Translation file
string 25