Class PostgreSQLAdapter

constructor

• new PostgreSQLAdapter(
      registry: MetadataRegistry,
      connectionString: string,
  ): PostgreSQLAdapter

  Constructor for PostgreSQL adapter

  Parameters

  • registry: MetadataRegistry

    The metadata registry to use for schema information
  • connectionString: string

    The PostgreSQL connection string

  Returns PostgreSQLAdapter

Readonlytype

close

• close(): Promise<void>

  Close the connection pool when done

  Returns Promise<void>

delete

• delete<T>(entityType: Type<T>, id: string | number): Promise<void>

  Delete an entity from PostgreSQL

  Type Parameters

  • T

  Parameters

  • entityType: Type<T>
  • id: string | number

  Returns Promise<void>

query

• query<T>(entityType: Type<T>, criteria: object): Promise<T>

  Query for a single entity by criteria

  Type Parameters

  • T

  Parameters

  • entityType: Type<T>
  • criteria: object

  Returns Promise<T>

queryMany

• queryMany<T>(entityType: Type<T>, criteria: object): Promise<T[]>

  Query for multiple entities by criteria

  Type Parameters

  • T

  Parameters

  • entityType: Type<T>
  • criteria: object

  Returns Promise<T[]>

runNativeQuery

• runNativeQuery<T>(query: string, params?: any[]): Promise<T>

  Execute a raw SQL query

  Type Parameters

  • T

  Parameters

  • query: string
  • Optionalparams: any[]

  Returns Promise<T>

save

• save<T>(entity: T, savingEntities?: Set<any>): Promise<void>

  Save an entity to PostgreSQL

  Type Parameters

  • T

  Parameters

  • entity: T
  • OptionalsavingEntities: Set<any>

  Returns Promise<void>