Class SolanaAccountTransactionQueryService

new SolanaAccountTransactionQueryService(
    __namedParameters: { sqlClient: Sql },
): SolanaAccountTransactionQueryService

get(
    args: { account: PublicKey; signature: string },
): Promise<
    {
        ok: true;
        value: | {
            account: PublicKey;
            blockTime: Date;
            createdAt: Date;
            indexWithinBlock: number;
            postBalances: SolanaAccountTransactionTokenBalance[];
            preBalances: SolanaAccountTransactionTokenBalance[];
            signature: string;
            slot: number;
            tokenInstructions: {
                amount: BigNumber;
                instructionType: "mint"
                | "transfer";
                owner: PublicKey;
                sourceTokenAccount?: PublicKey;
                targetTokenAccount: PublicKey;
            }[];
            transactionData: {
                blockTime: number;
                indexWithinBlock: number;
                meta: {
                    err: null;
                    fee: number;
                    innerInstructions: {
                        index: number;
                        instructions: {
                            accounts: (...)[];
                            data: string;
                            programIdIndex: number;
                        }[];
                    }[];
                    loadedAddresses: { readonly: string[]; writable: string[] };
                    logMessages: string[];
                    postBalances: number[];
                    postTokenBalances: TokenBalance[];
                    preBalances: number[];
                    preTokenBalances: TokenBalance[];
                };
                slot: number;
                transaction: {
                    message: {
                        accountKeys: string[];
                        addressTableLookups: null;
                        header: {
                            numReadonlySignedAccounts: number;
                            numReadonlyUnsignedAccounts: number;
                            numRequiredSignatures: number;
                        };
                        instructions: {
                            accounts: number[];
                            data: string;
                            programIdIndex: number;
                        }[];
                        recentBlockhash: string;
                    };
                    signatures: string[];
                };
            };
            transactionId: string
            | null;
            updatedAt: Date;
        }
        | null;
    },
>

search(
    __namedParameters: {
        address?: PublicKey;
        addresses?: PublicKey[];
        blockTime?: DbTimestampCriteria;
        createdAt?: DbTimestampCriteria;
        mint?: PublicKey;
        orderBy?: DbOrderByCriterion<
            Omit<
                PgTableWithColumns<
                    {
                        columns: {
                            blockTime: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgTimestamp";
                                    data: Date;
                                    dataType: "date";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "blockTime";
                                    notNull: true;
                                    tableName: "solana_transaction";
                                },
                                {},
                                {},
                            >;
                            createdAt: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgTimestamp";
                                    data: Date;
                                    dataType: "date";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "createdAt";
                                    notNull: true;
                                    tableName: "solana_transaction";
                                },
                                {},
                                {},
                            >;
                            data: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgJsonb";
                                    data: {
                                        blockTime: ...;
                                        indexWithinBlock: ...;
                                        meta: ...;
                                        slot: ...;
                                        transaction: ...;
                                    };
                                    dataType: "json";
                                    driverParam: unknown;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "data";
                                    notNull: true;
                                    tableName: "solana_transaction";
                                },
                                {},
                                {
                                    $type: {
                                        blockTime: ...;
                                        indexWithinBlock: ...;
                                        meta: ...;
                                        slot: ...;
                                        transaction: ...;
                                    };
                                },
                            >;
                            id: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgInteger";
                                    data: number;
                                    dataType: "number";
                                    driverParam: (...)
                                    | (...);
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: "byDefault";
                                    isAutoincrement: false;
                                    isPrimaryKey: true;
                                    name: "id";
                                    notNull: true;
                                    tableName: "solana_transaction";
                                },
                                {},
                                {},
                            >;
                            indexWithinBlock: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgInteger";
                                    data: number;
                                    dataType: "number";
                                    driverParam: (...)
                                    | (...);
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "indexWithinBlock";
                                    notNull: true;
                                    tableName: "solana_transaction";
                                },
                                {},
                                {},
                            >;
                            signature: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgText";
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: [(...), ...(...)[]];
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "signature";
                                    notNull: true;
                                    tableName: "solana_transaction";
                                },
                                {},
                                {},
                            >;
                            slot: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgInteger";
                                    data: number;
                                    dataType: "number";
                                    driverParam: (...)
                                    | (...);
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "slot";
                                    notNull: true;
                                    tableName: "solana_transaction";
                                },
                                {},
                                {},
                            >;
                            updatedAt: PgColumn<
                                {
                                    baseColumn: never;
                                    columnType: "PgTimestamp";
                                    data: Date;
                                    dataType: "date";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: "updatedAt";
                                    notNull: true;
                                    tableName: "solana_transaction";
                                },
                                {},
                                {},
                            >;
                        };
                        dialect: "pg";
                        name: "solana_transaction";
                        schema: "b2b";
                    },
                >,
                "enableRLS",
            >,
            "createdAt"
            | "indexWithinBlock"
            | "slot"
            | "blockTime",
        >[];
        page?: number;
        pageSize?: number;
        signature?: string;
        signatures?: string[];
    },
): Promise<
    {
        ok: true;
        value: {
            hasNext: boolean;
            items: {
                account: PublicKey;
                blockTime: Date;
                createdAt: Date;
                indexWithinBlock: number;
                postBalances: SolanaAccountTransactionTokenBalance[];
                preBalances: SolanaAccountTransactionTokenBalance[];
                signature: string;
                slot: number;
                tokenInstructions: {
                    amount: BigNumber;
                    instructionType: "mint"
                    | "transfer";
                    owner: PublicKey;
                    sourceTokenAccount?: PublicKey;
                    targetTokenAccount: PublicKey;
                }[];
                transactionData: {
                    blockTime: number;
                    indexWithinBlock: number;
                    meta: {
                        err: null;
                        fee: number;
                        innerInstructions: {
                            index: number;
                            instructions: { accounts: ...; data: ...; programIdIndex: ... }[];
                        }[];
                        loadedAddresses: { readonly: string[]; writable: string[] };
                        logMessages: string[];
                        postBalances: number[];
                        postTokenBalances: TokenBalance[];
                        preBalances: number[];
                        preTokenBalances: TokenBalance[];
                    };
                    slot: number;
                    transaction: {
                        message: {
                            accountKeys: string[];
                            addressTableLookups: null;
                            header: {
                                numReadonlySignedAccounts: number;
                                numReadonlyUnsignedAccounts: number;
                                numRequiredSignatures: number;
                            };
                            instructions: {
                                accounts: (...)[];
                                data: string;
                                programIdIndex: number;
                            }[];
                            recentBlockhash: string;
                        };
                        signatures: string[];
                    };
                };
                transactionId: string
                | null;
                updatedAt: Date;
            }[];
        };
    },
>