Runmysql
(since EVL 2.4)
Run SQL or mysql commands from stdin or <f_in> and write result into stdout or
<f_out>. It returns output from ‘mysql’ as is, so for quering the table to get
formatted EVL output use ‘Readmysql’ or ‘evl readmysql’. All unrecognized options are
provided to ‘mysql’ utility.
Password is taken from $HOME/.mysqlpass file, unless other file is specified by ‘--defaults-extra-file=<file>’.
- Runmysql
-
is to be used in EVS job structure definition file.
<f_out>is either output file or flow name. - evl runmysql
-
is intended for standalone usage, i.e. to be invoked from command line and writing records to standard output.
EVD and EVS are EVL definition files, for details see evl-evd(5) and evl-evs(5).
Synopsis
Runmysql <f_in> <f_out> [--dbname=<database>] [--host=<hostname>] [--port=<port>] [--username=<mysqluser>] [--mysql=<mysql_options>] evl runmysql [--dbname=<database>] [--host=<hostname>] [--port=<port>] [--username=<mysqluser>] [--mysql=<mysql_options>] [-v|--verbose] evl runmysql ( --help | --usage | --version )
Options
Standard options:
- --help
-
print this help and exit
- --usage
-
print short usage information and exit
- -v, --verbose
-
print to stderr info/debug messages of the component
- --version
-
print version and exit
’mysql’ options:
- --dbname=<database>
-
this option is provided to ‘mysql’ command as ‘--database=<database>’
- --host=<hostname>
-
this option is provided to ‘mysql’ command
- --port=<port>
-
using other than standard port 3306. This option is provided to ‘mysql’ command.
- --username=<mysqluser>
-
if not mentioned, then current system username is used as mysql user. This option is provided to ‘mysql’ command as ‘--user=<mysqluser>’.
- --mysql=<mysql_options>
-
all
<mysql_options>is provided to ‘mysql’ utility.