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
|
net_box = require('net.box')
msgpack = require('msgpack')
urilib = require('uri')
IPROTO_REQUEST_TYPE = 0x00
IPROTO_PREPARE = 13
IPROTO_SQL_TEXT = 0x40
IPROTO_STMT_ID = 0x43
box.schema.user.grant('guest', 'read, write, execute', 'universe')
uri = urilib.parse(box.cfg.listen)
socket = net_box.establish_connection(uri.host, uri.service)
header = { [IPROTO_REQUEST_TYPE] = IPROTO_PREPARE }
body = { [IPROTO_SQL_TEXT] = 'SELECT 1' }
response = iproto_request(socket, header, body)
body = { [IPROTO_STMT_ID] = response['body'][IPROTO_STMT_ID] }
-- Decoding of the response will fail if there's no body.
response = iproto_request(socket, header, body)
response.body
box.schema.user.revoke('guest', 'read, write, execute', 'universe')
socket:close()
|
