Lotus.Runner (Lotus v0.16.4)

Copy Markdown View Source

SQL execution with safety checks, param binding, and result shaping.

By default, all queries are read-only. Destructive operations (INSERT, UPDATE, DELETE, DDL) are blocked at both the application and database level. Pass read_only: false to allow write operations.

Summary

Types

opts()
params()
query_result()
repo()
sql()

Functions

run_sql(repo, sql, params \\ [], opts \\ [])

Types

opts()

@type opts() :: [
  timeout: non_neg_integer(),
  statement_timeout_ms: non_neg_integer(),
  read_only: boolean(),
  search_path: String.t() | nil
]

params()

@type params() :: list()

query_result()

@type query_result() :: Lotus.Result.t()

repo()

@type repo() :: module()

sql()

@type sql() :: String.t()

Functions

run_sql(repo, sql, params \\ [], opts \\ [])

@spec run_sql(repo(), sql(), params(), opts()) ::
  {:ok, query_result()} | {:error, term()}