TEST command

Syntax

TEST test_name [COMPRESSED]

Privileges

NONE

Description

The TEST command is used for debugging purposes and can be used by developers while developing the SCSP for a new language. By specifying a different test_name, the server will reply with different responses so you can test the parsing capabilities of your new binding. Supported test_name are: STRING, STRING0, ZERO_STRING, ERROR, EXTERROR, INTEGER, FLOAT, BLOB, BLOB0, ROWSET, ROWSET_CHUNK, JSON, NULL, COMMAND, ARRAY, ARRAY0

Return

Different output that depends on the test_name value.

Example

> TEST STRING
Hello World, this is a test string.

> TEST ERROR
ERROR: This is a test error message with a devil error code. (66666 - -1)

> TEST INTEGER
123456

> TEST FLOAT
3.1415926

> TEST ROWSET
--------------------------|----------------------------------------------------|
 key                      | value                                              |
--------------------------|----------------------------------------------------|
 sqlitecloud_version      | 0.9.8                                              |
 sqlite_version           | 3.39.3                                             |
 sqlitecloud_build_date   | Feb  7 2023                                        |
 sqlitecloud_git_hash     | 24e2ec6b121f09313afa9dfa4c02e9c9cc372034           |
 os                       | Linux on x86_64 (Kernel version 5.15.0-58-generic) |
 arch_bits                | 64bit                                              |
 multiplexing_api         | epool                                              |
 listening_port           | 9960                                               |
 process_id               | 182275                                             |
 num_processors           | 1                                                  |
 startup_datetime         | 2023-02-07 19:25:13                                |
 current_datetime         | 2023-02-08 09:31:23                                |
 nocluster                | 0                                                  |
 nodeid                   | 1                                                  |
 tls                      | LibreSSL 3.6.1                                     |
 tls_conn_version         | TLSv1.3                                            |
 tls_conn_cipher          | TLS_AES_256_GCM_SHA384                             |
 tls_conn_cipher_strength | 256                                                |
 tls_conn_alpn_selected   | NULL                                               |
 tls_conn_servername      | dev1.sqlitecloud.io                                |
 tls_peer_cert_provided   | 0                                                  |
 tls_peer_cert_subject    | NULL                                               |
 tls_peer_cert_issuer     | NULL                                               |
 tls_peer_cert_hash       | NULL                                               |
 tls_peer_cert_notbefore  | NULL                                               |
 tls_peer_cert_notafter   | NULL                                               |
--------------------------|----------------------------------------------------|

> TEST ARRAY
[0] Hello World
[1] 123456
[2] 3.1415
[3] NULL
[4] BLOB size 10