Class: Infrawrench::SqlNamespace

Inherits:
Object
  • Object
show all
Defined in:
lib/infrawrench/client.rb,
sig/infrawrench/sdk.rbs

Overview

client.sql

Instance Method Summary collapse

Constructor Details

#initialize(transport) ⇒ SqlNamespace

This method is part of a private API. You should avoid using this method if possible, as it may be removed or be changed in the future.

Returns a new instance of SqlNamespace.

Parameters:



6728
6729
6730
 
# File 'lib/infrawrench/client.rb', line 6728

def initialize(transport)
  @transport = transport
end

Instance Method Details

#estimate(body:, org_id: nil, request_options: nil) ⇒ Hash

Dry-run cost estimate (e.g. BigQuery byte scan)

Requires permission: resources:read.

POST /api/org/orgId/sql/estimate

Raises on 400: Bad request

Raises on 404: Not found

Parameters:

  • org_id (String, nil) (defaults to: nil) —

    Organization id. Defaults to the org_id the client was constructed with.

  • body (Hash) —

    Request body, shaped as SqlEstimateRequest.

  • request_options (Hash, nil) (defaults to: nil) —

    Per-call :headers, :timeout and :open_timeout.

  • body: (sql_estimate_request)
  • org_id: (String, nil) (defaults to: nil)
  • request_options: (Hash[Symbol, untyped], nil) (defaults to: nil)

Returns:

  • (Hash) —

    Parsed JSON, shaped as JsonObject — see sig/infrawrench/sdk.rbs.

Raises:



6748
6749
6750
6751
6752
6753
6754
6755
6756
 
# File 'lib/infrawrench/client.rb', line 6748

def estimate(body:, org_id: nil, request_options: nil)
  @transport.request(
    http_method: "POST",
    path: "/api/org/{orgId}/sql/estimate",
    path_params: { "orgId" => org_id },
    body: body,
    request_options: request_options
  )
end

#execute(body:, org_id: nil, request_options: nil) ⇒ Hash

Run an INSERT/UPDATE/DELETE/DDL statement

Requires permission: resources:execute.

POST /api/org/orgId/sql/execute

Raises on 400: Bad request

Raises on 404: Not found

Parameters:

  • org_id (String, nil) (defaults to: nil) —

    Organization id. Defaults to the org_id the client was constructed with.

  • body (Hash) —

    Request body, shaped as SqlExecuteRequest.

  • request_options (Hash, nil) (defaults to: nil) —

    Per-call :headers, :timeout and :open_timeout.

  • body: (sql_execute_request)
  • org_id: (String, nil) (defaults to: nil)
  • request_options: (Hash[Symbol, untyped], nil) (defaults to: nil)

Returns:

  • (Hash) —

    Parsed JSON, shaped as SqlExecuteResponse — see sig/infrawrench/sdk.rbs.

Raises:



6775
6776
6777
6778
6779
6780
6781
6782
6783
 
# File 'lib/infrawrench/client.rb', line 6775

def execute(body:, org_id: nil, request_options: nil)
  @transport.request(
    http_method: "POST",
    path: "/api/org/{orgId}/sql/execute",
    path_params: { "orgId" => org_id },
    body: body,
    request_options: request_options
  )
end

#query(body:, org_id: nil, request_options: nil) ⇒ Hash

Run a read-only SQL query

Routes to the right driver: REST executeQuery (BigQuery, Databricks), per-resource SQL driver (Neon, Turso) or account-level SQL driver (Postgres, MySQL).

Requires permission: resources:execute.

POST /api/org/orgId/sql/query

Raises on 400: Bad request

Raises on 404: Not found

Parameters:

  • org_id (String, nil) (defaults to: nil) —

    Organization id. Defaults to the org_id the client was constructed with.

  • body (Hash) —

    Request body, shaped as SqlQueryRequest.

  • request_options (Hash, nil) (defaults to: nil) —

    Per-call :headers, :timeout and :open_timeout.

  • body: (sql_query_request)
  • org_id: (String, nil) (defaults to: nil)
  • request_options: (Hash[Symbol, untyped], nil) (defaults to: nil)

Returns:

  • (Hash) —

    Parsed JSON, shaped as SqlQueryResponse | JsonObject — see sig/infrawrench/sdk.rbs.

Raises:



6806
6807
6808
6809
6810
6811
6812
6813
6814
 
# File 'lib/infrawrench/client.rb', line 6806

def query(body:, org_id: nil, request_options: nil)
  @transport.request(
    http_method: "POST",
    path: "/api/org/{orgId}/sql/query",
    path_params: { "orgId" => org_id },
    body: body,
    request_options: request_options
  )
end