Readmysql

Write to stdout or <f_out> MariaDB/MySQL <table>.

Password is taken from file ‘$EVL_PASSFILE’, which is by default ‘$HOME/.evlpass’. When such file has not permissions 600 (or 400), it is ignored! For details see ‘evl-password’.

Readmysql

is to be used in EVS job structure definition file. <f_out> is either output file or flow name.

evl readmysql

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

Readmysql
  [<schema>.]<table> <f_out> (<evd>|-d <inline_evd>)
  [-b|--dbname=<database>] [-h|--host=<hostname>] [-p|--port=<port>]
  [-q|--query=<query>] [-u|--username=<mysqluser>]
  [--mysql=<mysql-options>] [-y|--text-output]

evl readmysql
  [<schema>.]<table> (<evd>|-d <inline_evd>)
  [-b|--dbname=<database>] [-h|--host=<hostname>] [-p|--port=<port>]
  [-q|--query=<query>] [-u|--username=<mysqluser>]
  [--mysql=<mysql-options>] [-y|--text-output]
  [-v|--verbose]

evl readmysql
  ( --help | --usage | --version )

Options

-d, --data-definition=<inline_evd>

either this option or the file <evd> must be presented. Example: -d ’id int, user_id string(6) enc=iso-8859-1’

-q, --query=<query>

Use SQL <query> instead of reading whole table. With this option <table> might be an empty string.

-y, --text-output

write the output as text, not binary

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:

-b, --dbname=<database>

this option is provided to ‘mysql’ command as ‘--database=<database>’

-h, --host=<hostname>

this option is provided to ‘mysql’ command

-p, --port=<port>

using other than standard port 3306. This option is provided to ‘mysql’ command.

-u, --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>

other mysql options can be specified here