queries

Documentation

Index

• Constants
• func TotalCountQuery(inner string) string

Constants

const (
	Status = `` /* 151-byte string literal not displayed */

	NodeHeight = `
		SELECT height 
			FROM chain.latest_node_heights
			WHERE layer=$1`

	Blocks = `` /* 360-byte string literal not displayed */

	Block = `
		SELECT height, block_hash, time, num_txs
			FROM chain.blocks
			WHERE height = $1::bigint`

	Transactions = `` /* 1821-byte string literal not displayed */

	Transaction = `` /* 243-byte string literal not displayed */

	Events = `` /* 423-byte string literal not displayed */

	Entities = `
		SELECT id, address
			FROM chain.entities
		ORDER BY id
		LIMIT $1::bigint
		OFFSET $2::bigint`

	Entity = `
		SELECT id, address
			FROM chain.entities
			WHERE id = $1::text`

	EntityNodeIds = `
		SELECT id
			FROM chain.nodes
			WHERE entity_id = $1::text
			ORDER BY id`

	EntityNodes = `` /* 204-byte string literal not displayed */

	EntityNode = `` /* 169-byte string literal not displayed */

	Accounts = `` /* 889-byte string literal not displayed */

	Account = `` /* 937-byte string literal not displayed */

	AccountAllowances = `
		SELECT beneficiary, allowance
			FROM chain.allowances
			WHERE owner = $1::text`

	Delegations = `` /* 286-byte string literal not displayed */

	DelegationsTo = `` /* 486-byte string literal not displayed */

	DebondingDelegations = `` /* 336-byte string literal not displayed */

	DebondingDelegationsTo = `` /* 542-byte string literal not displayed */

	Epochs = `` /* 203-byte string literal not displayed */

	Epoch = `
		SELECT id, start_height, end_height
			FROM chain.epochs
			WHERE id = $1::bigint`

	Proposals = `` /* 356-byte string literal not displayed */

	Proposal = `` /* 222-byte string literal not displayed */

	ProposalVotes = `` /* 136-byte string literal not displayed */

	Validators = `
		SELECT id, start_height
			FROM chain.epochs
			ORDER BY id DESC`

	ValidatorsData = `` /* 1175-byte string literal not displayed */

	RuntimeBlocks = `` /* 429-byte string literal not displayed */

	RuntimeBlock = `` /* 150-byte string literal not displayed */

	RuntimeTransactions = `` /* 3040-byte string literal not displayed */

	RuntimeEvents = `` /* 1545-byte string literal not displayed */

	RuntimeEvmContract = `` /* 636-byte string literal not displayed */

	AddressPreimage = `
		SELECT context_identifier, context_version, address_data
			FROM chain.address_preimages
			WHERE address = $1::text`

	RuntimeAccountStats = `` /* 406-byte string literal not displayed */

	//nolint:gosec // Linter suspects a hardcoded access token.
	EvmTokens = `` /* 1512-byte string literal not displayed */

	//nolint:gosec // Linter suspects a hardcoded credentials token.
	EvmTokenHolders = `` /* 579-byte string literal not displayed */

	EvmNfts = `` /* 1832-byte string literal not displayed */

	AccountRuntimeSdkBalances = `` /* 327-byte string literal not displayed */

	AccountRuntimeEvmBalances = `` /* 1107-byte string literal not displayed */

	RuntimeActiveNodes = `
		SELECT COUNT(*) AS active_nodes
		FROM chain.runtime_nodes
		WHERE runtime_id = $1::text
	`

	// FineTxVolumes returns the fine-grained query for 5-minute sampled tx volume windows.
	FineTxVolumes = `` /* 155-byte string literal not displayed */

	// FineDailyTxVolumes returns the query for daily tx volume windows.
	FineDailyTxVolumes = `` /* 156-byte string literal not displayed */

	// DailyTxVolumes returns the query for daily sampled daily tx volume windows.
	DailyTxVolumes = `` /* 213-byte string literal not displayed */

	// FineDailyActiveAccounts returns the fine-grained query for daily active account windows.
	FineDailyActiveAccounts = `` /* 168-byte string literal not displayed */

	// DailyActiveAccounts returns the query for daily sampled daily active account windows.
	DailyActiveAccounts = `` /* 225-byte string literal not displayed */

)

Functions

func TotalCountQuery

func TotalCountQuery(inner string) string