Runbox.Scenario.OutputAction.ExecuteSQL (runbox v7.0.1)

Parameters for output action Execute SQL.

The resulting output action executes an SQL statement.

Link to this section Summary

Types

t()

Execute SQL

Link to this section Types

t()

@type t() :: %Runbox.Scenario.OutputAction.ExecuteSQL{
  data: list(),
  db_connection: map(),
  sql_query: String.t(),
  type: :postgresql | String.t()
}

Execute SQL

:db_connection - map with database connection info (hostname, username, password, database)
:sql_query - SQL query.
:data - list of parameterized data.
:type - database type, right now only PostgreSQL is supported. It's checked in OutputProcessor and the value must be :postgresql.

If :run_id is present in data, it's replaced with actual run_id in AssetMap.Api.SqlExecutor.