View Source Runbox.Scenario.OutputAction.ExecuteSQL (runbox v13.0.3)

Parameters for output action Execute SQL.

The resulting output action executes an SQL statement.

Summary

Types

t()

Execute SQL

Types

Link to this type

t()

View Source 
@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.