code_generators_02.ts

import { PreparedQuery } from '@pgtyped/query';

export type file_retention_status = 'DELETED' | 'EXPIRED' | 'NOTIFIED' | 'PROCESSED';

export type file_upload_status = 'CANCELLED' | 'DONE' | 'FAILED' | 'UPLOADING';

export interface IGetFileByIdParams {
  id: string;
}

export interface IGetFileByIdResult {
  created_at: Date;
  id: string;
  size: number | null
  type: string | null;
  updated_at: Date;
  upload_status: file_upload_status;
}

export interface IGetFileByIdQuery {
  params: IGetFileByIdParams;
  result: IGetFileByIdResult;
}

const getFileByIdIR: any = {"usedParamSet":{"id":true},"params":[{"name":"id","required":true,"transform":{"type":"scalar"},"locs":[{"a":39,"b":42}]}],"statement":"SELECT *\nFROM dovetail.file\nWHERE id = :id!"};

/**
 * Query generated from SQL:
 * ```
 * SELECT *
 * FROM dovetail.file
 * WHERE id = :id!
 * ```
 */
export const getFileById = new PreparedQuery<IGetFileByIdParams,IGetFileByIdResult>(getFileByIdIR);