Utility Dictionary

The utility_dictionary plugin provides several DATA_DICTIONARY tables:

  • COUNTER
  • ENVIRONMENTAL
  • RANDOM_NUMBER
  • RANDOM_STRING

Loading

To load this plugin, start drizzled with:

--plugin-add=utility_dictionary

See also

Plugin Options for more information about adding and removing plugins.

Examples

drizzle> SELECT * FROM DATA_DICTIONARY.COUNTER;
+-------+
| VALUE |
+-------+
|     1 |
+-------+

drizzle> SELECT * FROM DATA_DICTIONARY.COUNTER;
+-------+
| VALUE |
+-------+
|     2 |
+-------+

drizzle> SELECT * FROM DATA_DICTIONARY.COUNTER;
+-------+
| VALUE |
+-------+
|     3 |
+-------+

drizzle> SELECT * FROM DATA_DICTIONARY.ENVIRONMENTAL;
+---------------+----------------------------+
| VARIABLE_NAME | VARIABLE_VALUE             |
+---------------+----------------------------+
| SHELL         | /bin/bash                  |
| TERM          | xterm-color                |
| USER          | daniel                     |
| EDITOR        | vi                         |
| HOME          | /Users/daniel              |
| LOGNAME       | daniel                     |
| DISPLAY       | /tmp/launch-ccfH4l/org.x:0 |
| _             | ./sbin/drizzled            |
+---------------+----------------------------+

drizzle> SELECT * FROM DATA_DICTIONARY.RANDOM_NUMBER;
+------------+
| VALUE      |
+------------+
| 1804289383 |
+------------+

drizzle> SELECT * FROM DATA_DICTIONARY.RANDOM_STRING;
+----------------------+
| VALUE                |
+----------------------+
| 8FJid3GaHpRC2L6jX3i9 |
+----------------------+

Authors

Brian Aker

Version

This documentation applies to utility_dictionary 1.0.

To see which version of the plugin a Drizzle server is running, execute:

SELECT MODULE_VERSION FROM DATA_DICTIONARY.MODULES WHERE MODULE_NAME='utility_dictionary'

Changelog

v1.0

  • First release.

Table Of Contents

Previous topic

User Locks

Next topic

Utility Functions

This Page