Share your code. npm Orgs help your team discover, share, and reuse code. Create a free org »

    @runnerty/executor-mysqlpublic

    MySql executor for Runnerty:

    Configuration sample:

    {
      "id": "mysql_default",
      "type": "@runnerty-executor-mysql",
      "user": "mysqlusr",
      "password": "mysqlpass",
      "database": "MYDB",
      "host": "myhost.com",
      "port": "3306"
    }

    Plan sample:

    {
      "id":"mysql_default",
      "command_file": "/etc/runnerty/sql/test.sql"
    }
    {
      "id":"mysql_default",
      "command": "SELECT NOW()"
    }

    Output (Process values):

    Standard

    • PROCESS_EXEC_MSG_OUTPUT: MySQL output message.
    • PROCESS_EXEC_ERR_OUTPUT: Error output message.

    Query output

    • PROCESS_EXEC_DATA_OUTPUT: MySQL query output data.
    • PROCESS_EXEC_DB_COUNTROWS: MySQL query count rows.
    • PROCESS_EXEC_DB_FIRSTROW: MySQL query first row data.
    • PROCESS_EXEC_DB_FIRSTROW_[FILED_NAME]: MySQL first row field data.

    Operation output

    • PROCESS_EXEC_DB_FIELDCOUNT: MySQL field count.
    • PROCESS_EXEC_DB_AFFECTEDROWS: MySQL affected rows count.
    • PROCESS_EXEC_DB_CHANGEDROWS: MySQL changed rows count.
    • PROCESS_EXEC_DB_INSERTID: MySQL insert ID.
    • PROCESS_EXEC_DB_WARNINGCOUNT: MySQL warning count.
    • PROCESS_EXEC_DB_MESSAGE: MySQL message.

    install

    npm i @runnerty/executor-mysql

    Downloadslast 7 days

    1

    version

    1.0.2

    license

    MIT

    homepage

    github.com

    repository

    github.com

    last publish

    collaborators

    • avatar