Skip to main content

Class: Registry

Registry provides direct access to remote Registry smart contract APIs.

Constructors

constructor

new Registry(config?)

Create a Registry instance with the specified connection configuration.

Parameters

NameTypeDescription
configPartial<SignerConfig>The connection configuration. This must include an ethersjs Signer. If passing the config from a pre-existing Database instance, it must have a non-null signer key defined.

Defined in

@tableland/sdk/src/registry/index.ts:62

Properties

config

Readonly config: SignerConfig

Defined in

@tableland/sdk/src/registry/index.ts:55

Methods

create

create(params): Promise<ContractTransaction>

Creates a new table owned by owner using statement and returns its tableId.

owner - the to-be owner of the new table statement - the SQL statement used to create the table

Requirements:

  • contract must be unpaused

Parameters

NameType
paramsCreateParams

Returns

Promise<ContractTransaction>

Defined in

@tableland/sdk/src/registry/index.ts:163


getController

getController(table): Promise<string>

Returns the controller for a table.

tableId - the id of the target table

Parameters

NameType
tablestring | TableIdentifier

Returns

Promise<string>

Defined in

@tableland/sdk/src/registry/index.ts:149


listTables

listTables(owner?): Promise<TableIdentifier[]>

Gets the list of table IDs of the requested owner.

Parameters

NameTypeDescription
owner?stringThe address owning the table.

Returns

Promise<TableIdentifier[]>

Defined in

@tableland/sdk/src/registry/index.ts:82


lockController

lockController(table): Promise<ContractTransaction>

Locks the controller for a table forever. Controller can be an EOA or contract address.

Although not very useful, it is possible to lock a table controller that is set to the zero address.

caller - the address that is locking the controller tableId - the id of the target table

Requirements:

  • contract must be unpaused
  • msg.sender must be caller or contract owner and owner of tableId
  • tableId must exist
  • tableId controller must not be locked

Parameters

NameType
tablestring | TableIdentifier

Returns

Promise<ContractTransaction>

Defined in

@tableland/sdk/src/registry/index.ts:138


mutate

mutate(params): Promise<ContractTransaction>

Runs a SQL statement for caller using statement.

caller - the address that is running the SQL statement tableId - the id of the target table statement - the SQL statement to run

Requirements:

  • contract must be unpaused
  • msg.sender must be caller
  • tableId must exist
  • caller must be authorized by the table controller
  • statement must be less than 35000 bytes after normalizing

Parameters

NameType
paramsMutateParams

Returns

Promise<ContractTransaction>

Defined in

@tableland/sdk/src/registry/index.ts:182


runSQL

runSQL(params): Promise<ContractTransaction>

Runs a set of SQL statements for caller using runnables. @custom:deprecated Using this with a single statement is deprecated. Use mutate instead.

Parameters

NameType
paramsMutateParams

Returns

Promise<ContractTransaction>

Defined in

@tableland/sdk/src/registry/index.ts:190


safeTransferFrom

safeTransferFrom(params): Promise<ContractTransaction>

Safely transfers the ownership of a given table ID to another address.

Requires the msg sender to be the owner, approved, or operator

Parameters

NameType
paramsTransferParams

Returns

Promise<ContractTransaction>

Defined in

@tableland/sdk/src/registry/index.ts:91


setController

setController(params): Promise<ContractTransaction>

Sets the controller for a table. Controller can be an EOA or contract address.

When a table is created, it's controller is set to the zero address, which means that the contract will not enforce write access control. In this situation, validators will not accept transactions from non-owners unless explicitly granted access with "GRANT" SQL statements.

When a controller address is set for a table, validators assume write access control is handled at the contract level, and will accept all transactions.

You can unset a controller address for a table by setting it back to the zero address. This will cause validators to revert back to honoring owner and GRANT bases write access control.

caller - the address that is setting the controller tableId - the id of the target table controller - the address of the controller (EOA or contract)

Requirements:

  • contract must be unpaused
  • msg.sender must be caller or contract owner and owner of tableId
  • tableId must exist
  • tableId controller must not be locked

Parameters

NameType
paramsSetParams

Returns

Promise<ContractTransaction>

Defined in

@tableland/sdk/src/registry/index.ts:119


forSigner

Static forSigner(signer): Promise<Registry>

Create a Registry that is connected to the given Signer.

Parameters

NameTypeDescription
signerSignerAn ethersjs Signer to use for mutating queries.

Returns

Promise<Registry>

Defined in

@tableland/sdk/src/registry/index.ts:74