4
The commands that are endorsed in Drizzletest are delineated in the following documentation. Examples are given for the commands. Browse **tests/t** for more examples.
6
.. note:: The commands are not case sensitive
14
* :ref:`character_set`
24
* :ref:`disable/enable_abort_on_error`
25
* :ref:`disable/enable_connect_log`
26
* :ref:`disable/enable_info`
27
* :ref:`disable/enable_metadata`
28
* :ref:`disable/enable_parsing`
29
* :ref:`disable/enable_ps_protocol`
30
* :ref:`disable/enable_query_log`
31
* :ref:`disable/enable_reconnect`
32
* :ref:`disable/enable_result_log`
33
* :ref:`disable/enable_rpl_parse`
34
* :ref:`disable/enable_warnings`
44
* :ref:`horizontal_results`
50
* :ref:`list_files_append_file`
51
* :ref:`list_files_write_file`
52
* :ref:`lowercase_result`
57
* :ref:`query_get_value`
58
* :ref:`query_horizontal`
59
* :ref:`query_vertical`
63
* :ref:`remove_files_wildcard`
64
* :ref:`replace_column`
65
* :ref:`replace_regex`
66
* :ref:`replace_result`
70
* :ref:`save_master_pos`
74
* :ref:`shutdown_server`
77
* :ref:`sorted_result`
80
* :ref:`sync_slave_with_master`
81
* :ref:`sync_with_master`
83
* :ref:`vertical_results`
84
* :ref:`wait_for_slave_to_stop`
94
:program:`append_file file_name [terminator]`
98
.. code-block:: python
107
:program:`cat_file file_name`
111
.. code-block:: python
120
:program:`change_user [user_name], [password], [db_name]`
124
.. code-block:: python
133
:program:`character_set charset_name`
137
.. code-block:: python
146
:program:`chmod octal_mode file_name`
150
.. code-block:: python
159
:program:`connect (name, host_name, user_name, password, db_name [,port_num [,socket [,options [,default_auth]]]])`
163
.. code-block:: python
172
:program:`connection connection_name`
176
.. code-block:: python
185
:program:`copy_file from_file to_file`
189
.. code-block:: python
198
:program:`dec $variable_name`
202
.. code-block:: python
211
:program:`delimiter string`
215
.. code-block:: python
224
:program:`die [message]`
228
.. code-block:: python
237
:program:`diff_files file_name1 file_name2`
241
.. code-block:: python
250
:program:`dirty_close connection_name`
252
.. _disable/enable_abort_on_error:
254
disable/enable_abort_on_error
255
-----------------------------
259
:program:`disable_abort_on_error,enable_abort_on_error`
263
.. code-block:: python
265
.. _disable/enable_connect_log:
267
disable/enable_connect_log
268
--------------------------
272
:program:`disable_connect_log, enable_connect_log`
276
.. code-block:: python
278
.. _disable/enable_info:
285
:program:`disable_info, enable_info`
289
.. code-block:: python
291
.. _disable/enable_metadata:
293
disable/enable_metadata
294
-----------------------
298
:program:`disable_metadata, enable_metadata`
302
.. code-block:: python
304
.. _disable/enable_parsing:
306
disable/enable_parsing
307
----------------------
311
:program:`disable_parsing, enable_parsing`
315
.. code-block:: python
317
.. _disable/enable_ps_protocol:
319
disable/enable_ps_protocol
320
--------------------------
324
:program:`disable_ps_protocol, enable_ps_protocol`
328
.. code-block:: python
330
.. _disable/enable_query_log:
332
disable/enable_query_log
333
------------------------
337
:program:`disable_query_log, enable_query_log`
341
.. code-block:: python
343
.. _disable/enable_reconnect:
345
disable/enable_reconnect
346
------------------------
350
:program:`disable_reconnect, enable_reconnect`
354
.. code-block:: python
356
.. _disable/enable_result_log:
358
disable/enable_result_log
359
-------------------------
363
:program:`disable_result_log, enable_result_log`
367
.. code-block:: python
369
.. _disable/enable_rpl_parse:
371
disable/enable_rpl_parse
372
------------------------
376
:program:`disable_rpl_parse, enable_rpl_parse`
380
.. code-block:: python
382
.. _disable/enable_warnings:
384
disable/enable_warnings
385
-----------------------
389
:program:`disable_warnings, enable_warnings`
393
.. code-block:: python
402
:program:`disconnect connection_name`
406
.. code-block:: python
419
.. code-block:: python
446
:program:`error error_code [,error_code[,...]]`
450
.. code-block:: python
459
:program:`eval statement`
463
.. code-block:: python
472
:program:`exec command [arg1[,arg2[,...]]]`
476
.. code-block:: python
494
:program:`file_exists file_name`
498
.. code-block:: python
500
.. _horizontal_results:
507
:program:`horizontal_results`
511
.. code-block:: python
524
.. code-block:: python
533
:program:`inc $var_name`
537
.. code-block:: python
546
:program:`let $var_name = value`
548
:program:`let $var_name = query_get_value(query, col_name, row_num)`
552
.. code-block:: python
561
:program:`mkdir dir_name`
565
.. code-block:: python
574
:program:`list_files dir_name [pattern]`
578
.. code-block:: python
580
.. _list_files_append_file:
582
list_files_append_file
583
----------------------
587
:program:`list_files_append_file file_name dir_name [pattern]`
591
.. code-block:: python
593
.. _list_files_write_file:
595
list_files_write_file
596
---------------------
600
:program:`list_files_write_file file_name dir_name [pattern]`
604
.. code-block:: python
606
.. _lowercase_result:
613
:program:`lowercase_result`
617
.. code-block:: python
626
:program:`move_file from_file to_file`
630
.. code-block:: python
639
:program:`perl [terminator]`
643
.. code-block:: python
661
:program:`query [statement]`
670
:program:`query_get_value(query,col_name,row_num)`
674
.. code-block:: python
676
.. _query_horizontal:
683
:program:`query_horizontal statement`
687
.. code-block:: python
696
:program:`query_vertical statement`
700
.. code-block:: python
709
:program:`real_sleep num`
713
.. code-block:: python
731
:program:`remove_file file_name`
735
.. code-block:: python
737
.. _remove_files_wildcard:
739
remove_files_wildcard
740
---------------------
744
:program:`remove_files_wildcard dir_name [pattern]`
748
.. code-block:: python
757
:program:`replace_column col_num value [col_num value [,...] ]`
761
.. code-block:: python
770
:program:`replace_regex /pattern/replacement/[i] ...`
774
.. code-block:: python
783
:program:`replace_result from_val to_val [from_val to_val [...]]`
787
.. code-block:: python
796
:program:`require file_name`
800
.. code-block:: python
809
:program:`result file_name`
818
:program:`rmdir dir_name`
822
.. code-block:: python
831
:program:`save_master_pos`
840
:program:`send [statement]`
844
.. code-block:: python
853
:program:`send_eval [statement]`
857
.. code-block:: python
866
:program:`send_quit [timeout]`
870
.. code-block:: python
879
:program:`shutdown_server [timeout]`
883
.. code-block:: python
892
:program:`skip [message]`
896
.. code-block:: python
909
.. code-block:: python
918
:program:`sorted_result`
922
.. code-block:: python
931
:program:`source file_name`
935
.. code-block:: python
944
:program:`start_timer`
946
.. _sync_slave_with_master:
948
sync_slave_with_master
949
----------------------
953
:program:`sync_slave_with_master [connection_name]`
955
.. _sync_with_master:
962
:program:`sync_with_master offset`
971
:program:`system command [arg1[,arg2[,...]]]`
975
.. code-block:: python
977
.. _vertical_results:
984
:program:`vertical_results`
988
.. code-block:: python
990
.. _wait_for_slave_to_stop:
992
wait_for_slave_to_stop
993
----------------------
997
:program:`wait_for_slave_to_stop`
1006
:program:`while(expr)`
1010
.. code-block:: python
1019
:program:`write_file file_name [terminator]`
1023
.. code-block:: python