/** Types generated for queries found in "src/sql/nonces.sql" */
import { PreparedQuery } from '@pgtyped/runtime';

/** 'FindNonce' parameters type */
export interface IFindNonceParams {
  nonce?: string | null | void;
}

/** 'FindNonce' return type */
export interface IFindNonceResult {
  block_height: number;
  nonce: string;
}

/** 'FindNonce' query type */
export interface IFindNonceQuery {
  params: IFindNonceParams;
  result: IFindNonceResult;
}

const findNonceIR: any = {"usedParamSet":{"nonce":true},"params":[{"name":"nonce","required":false,"transform":{"type":"scalar"},"locs":[{"a":48,"b":53}]}],"statement":"SELECT * FROM effectstream.nonces\nWHERE nonce = :nonce"};

/**
 * Query generated from SQL:
 * ```
 * SELECT * FROM effectstream.nonces
 * WHERE nonce = :nonce
 * ```
 */
export const findNonce = new PreparedQuery<IFindNonceParams,IFindNonceResult>(findNonceIR);


/** 'DeleteNonces' parameters type */
export interface IDeleteNoncesParams {
  limit_block_height: number;
}

/** 'DeleteNonces' return type */
export type IDeleteNoncesResult = void;

/** 'DeleteNonces' query type */
export interface IDeleteNoncesQuery {
  params: IDeleteNoncesParams;
  result: IDeleteNoncesResult;
}

const deleteNoncesIR: any = {"usedParamSet":{"limit_block_height":true},"params":[{"name":"limit_block_height","required":true,"transform":{"type":"scalar"},"locs":[{"a":54,"b":73}]}],"statement":"DELETE FROM effectstream.nonces\nWHERE block_height <= :limit_block_height!"};

/**
 * Query generated from SQL:
 * ```
 * DELETE FROM effectstream.nonces
 * WHERE block_height <= :limit_block_height!
 * ```
 */
export const deleteNonces = new PreparedQuery<IDeleteNoncesParams,IDeleteNoncesResult>(deleteNoncesIR);


/** 'InsertNonce' parameters type */
export interface IInsertNonceParams {
  block_height: number;
  nonce: string;
}

/** 'InsertNonce' return type */
export type IInsertNonceResult = void;

/** 'InsertNonce' query type */
export interface IInsertNonceQuery {
  params: IInsertNonceParams;
  result: IInsertNonceResult;
}

const insertNonceIR: any = {"usedParamSet":{"nonce":true,"block_height":true},"params":[{"name":"nonce","required":true,"transform":{"type":"scalar"},"locs":[{"a":61,"b":67}]},{"name":"block_height","required":true,"transform":{"type":"scalar"},"locs":[{"a":70,"b":83}]}],"statement":"INSERT INTO effectstream.nonces(nonce, block_height)\nVALUES (:nonce!, :block_height!)"};

/**
 * Query generated from SQL:
 * ```
 * INSERT INTO effectstream.nonces(nonce, block_height)
 * VALUES (:nonce!, :block_height!)
 * ```
 */
export const insertNonce = new PreparedQuery<IInsertNonceParams,IInsertNonceResult>(insertNonceIR);