Skip to main content

Inery Query List

GET Queries​

Retrieving All Data from a Table​

Description: This query allows you to retrieve all data from a specific table.
Command: get all [account] [table]
Arguments:
[account] - User account name.
[table] - Table name from which you want to retrieve data.

Retrieving the First x Rows from a Table​

Description: This query enables you to retrieve the first x rows from a specific table.
Command: get first [account] [table] [count]
Arguments:
[account] - User account name.
[table] - Table name from which you want to retrieve data.
[count] - Number of rows to retrieve.

Retrieving the Last x Rows from a Table​

Description: This query allows you to retrieve the last x rows from a specific table.
Command: get last [account] [table] [count]
Arguments:
[account] - User account name.
[table] - Table name from which you want to retrieve data. [count] - Number of rows to retrieve.

Retrieving Rows within a Range from a Table​

Description: This query lets you retrieve rows from a table within a specified index range.
Command: get range [account] [table] [lower] [upper]
Arguments:
[account] - User account name.
[table] - Table name from which you want to retrieve data.
[lower] - Starting index.
[upper] - Ending index (optional).

Retrieving a Single Row by ID from a Table​

Description: This query allows you to retrieve a single row from a table based on its ID.
Command: get one [account] [table] [row_id]
Arguments:
[account] - User account name.
[table] - Table name from which you want to retrieve data.
[row_id] - ID of the row you want to retrieve.

Showing Database Structure​

Description: This query provides information about the database's structure.
Command: get structure [account]
Arguments:
[account] - User account name.

Showing Database Compositions​

Description: This query displays information about the compositions in the database.
Command: get compositions [account] [-a]
Arguments:
[account] - User account name.
[-a] - Optional parameter to show composition records.

Showing a Specific Database Composition​

Description: This query allows you to retrieve information about a specific database composition.
Command: get composition [account] [composition]
Arguments:
[account] - User account name.
[composition] - Composition name.

Showing Database Actions​

Description: This query provides information about the actions in the database.
Command: get actions [account] [-a]
Arguments:
[account] - User account name.
[-a] - Optional parameter to show composition records.

Showing a Specific Database Action​

Description: This query allows you to retrieve information about a specific database action.
Command: `get action [account] [action]`
Arguments:
[account] - _User account name._
[action] - _Action name._

Set Queries​

Creating an Account on the Blockchain​

Description: This query enables you to create a new account on the blockchain.
Command: create account [creator_name] [account_name] [owner_public_key] [active_public_key] [creator_permission]
Arguments:
[creator_name] - Creator account name.
[account_name] - New account name.
[owner_public_key] - Public key of the account owner.
[active_public_key] - Active public key.
[creator_permission] - Private key of the creator account.

Creating an Inery Keypair​

Description: This query allows you to create an Inery keypair.
Command: create keypair [type] Arguments:
[type] - Type of keypair (optional).