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’.
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.