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:



4755
4756
4757
 
# File 'lib/infrawrench/client.rb', line 4755

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:



4775
4776
4777
4778
4779
4780
4781
4782
4783
 
# File 'lib/infrawrench/client.rb', line 4775

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:



4802
4803
4804
4805
4806
4807
4808
4809
4810
 
# File 'lib/infrawrench/client.rb', line 4802

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:



4833
4834
4835
4836
4837
4838
4839
4840
4841
 
# File 'lib/infrawrench/client.rb', line 4833

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