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).