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:



3459
3460
3461
 
# File 'lib/infrawrench/client.rb', line 3459

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:



3479
3480
3481
3482
3483
3484
3485
3486
3487
 
# File 'lib/infrawrench/client.rb', line 3479

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:



3506
3507
3508
3509
3510
3511
3512
3513
3514
 
# File 'lib/infrawrench/client.rb', line 3506

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:



3537
3538
3539
3540
3541
3542
3543
3544
3545
 
# File 'lib/infrawrench/client.rb', line 3537

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