Class MySqlPersister

Hierarchy

MySqlPersister

Implements

Persister

Index

Constructors

constructor

new MySqlPersister(host: string, user: string, password: string, database: string, tablePrefix?: string, connectionLimit?: number, queueLimit?: number, acquireTimeout?: number, connectTimeout?: number, timeout?: number, queryTimeout?: number, waitForConnections?: boolean, charset?: string): MySqlPersister
Parameters
- host: string
- user: string
- password: string
- database: string
- tablePrefix: string = ''
- connectionLimit: number = 100
- queueLimit: number = 0
- acquireTimeout: number = ...
  
  Seconds -- or Milliseconds?
- connectTimeout: number = ...
  
  Milliseconds?
- timeout: number = ...
  
  Milliseconds
- queryTimeout: number = ...
  
  Milliseconds
- waitForConnections: boolean = true
- charset: string = MySqlCharset.UTF8_GENERAL_CI
  
  Connection charset. Defaults to UTF8_GENERAL_CI
Returns MySqlPersister
- Defined in fi/hg/repository/persisters/mysql/MySqlPersister.ts:54

Properties

`Private` `Readonly` _pool

_pool: Pool

`Private` `Readonly` _queryTimeout

_queryTimeout: number

`Private` `Readonly` _tablePrefix

_tablePrefix: string

Methods

`Private` _query

_query(query: string, values?: any[]): Promise<QueryResultPair>
Parameters
- query: string
- Optional values: any[]
Returns Promise<QueryResultPair>
- Defined in fi/hg/repository/persisters/mysql/MySqlPersister.ts:370

count

count<T, ID>(metadata: EntityMetadata): Promise<number>
Type Parameters
- T extends Entity<T>
- ID extends EntityIdTypes
Parameters
- metadata: EntityMetadata
Returns Promise<number>
Implementation of Persister.count
- Defined in fi/hg/repository/persisters/mysql/MySqlPersister.ts:305

countByProperty

countByProperty<T, ID>(property: string, value: any, metadata: EntityMetadata): Promise<number>
Type Parameters
- T extends Entity<T>
- ID extends EntityIdTypes
Parameters
- property: string
- value: any
- metadata: EntityMetadata
Returns Promise<number>
Implementation of Persister.countByProperty
- Defined in fi/hg/repository/persisters/mysql/MySqlPersister.ts:322

deleteAll

deleteAll<T, ID>(metadata: EntityMetadata): Promise<void>
Type Parameters
- T extends Entity<T>
- ID extends EntityIdTypes
Parameters
- metadata: EntityMetadata
Returns Promise<void>
Implementation of Persister.deleteAll
- Defined in fi/hg/repository/persisters/mysql/MySqlPersister.ts:164

deleteAllById

deleteAllById<T, ID>(ids: ID[], metadata: EntityMetadata): Promise<void>
Type Parameters
- T extends Entity<T>
- ID extends EntityIdTypes
Parameters
- ids: ID[]
- metadata: EntityMetadata
Returns Promise<void>
Implementation of Persister.deleteAllById
- Defined in fi/hg/repository/persisters/mysql/MySqlPersister.ts:185

deleteAllByProperty

deleteAllByProperty<T, ID>(property: string, value: any, metadata: EntityMetadata): Promise<void>
Type Parameters
- T extends Entity<T>
- ID extends EntityIdTypes
Parameters
- property: string
- value: any
- metadata: EntityMetadata
Returns Promise<void>
Implementation of Persister.deleteAllByProperty
- Defined in fi/hg/repository/persisters/mysql/MySqlPersister.ts:202

deleteById

deleteById<T, ID>(id: ID, metadata: EntityMetadata): Promise<void>
Type Parameters
- T extends Entity<T>
- ID extends EntityIdTypes
Parameters
- id: ID
- metadata: EntityMetadata
Returns Promise<void>
Implementation of Persister.deleteById
- Defined in fi/hg/repository/persisters/mysql/MySqlPersister.ts:172

existsByProperty

existsByProperty<T, ID>(property: string, value: any, metadata: EntityMetadata): Promise<boolean>
Type Parameters
- T extends Entity<T>
- ID extends EntityIdTypes
Parameters
- property: string
- value: any
- metadata: EntityMetadata
Returns Promise<boolean>
Implementation of Persister.existsByProperty
- Defined in fi/hg/repository/persisters/mysql/MySqlPersister.ts:344

findAll

findAll<T, ID>(metadata: EntityMetadata): Promise<T[]>
Type Parameters
- T extends Entity<T>
- ID extends EntityIdTypes
Parameters
- metadata: EntityMetadata
Returns Promise<T[]>
Implementation of Persister.findAll
- Defined in fi/hg/repository/persisters/mysql/MySqlPersister.ts:255

findAllById

findAllById<T, ID>(ids: ID[], metadata: EntityMetadata): Promise<T[]>
Type Parameters
- T extends Entity<T>
- ID extends EntityIdTypes
Parameters
- ids: ID[]
- metadata: EntityMetadata
Returns Promise<T[]>
Implementation of Persister.findAllById
- Defined in fi/hg/repository/persisters/mysql/MySqlPersister.ts:268

findAllByProperty

findAllByProperty<T, ID>(property: string, value: any, metadata: EntityMetadata): Promise<T[]>
Type Parameters
- T extends Entity<T>
- ID extends EntityIdTypes
Parameters
- property: string
- value: any
- metadata: EntityMetadata
Returns Promise<T[]>
Implementation of Persister.findAllByProperty
- Defined in fi/hg/repository/persisters/mysql/MySqlPersister.ts:286

findById

findById<T, ID>(id: ID, metadata: EntityMetadata): Promise<T>
Type Parameters
- T extends Entity<T>
- ID extends EntityIdTypes
Parameters
- id: ID
- metadata: EntityMetadata
Returns Promise<T>
Implementation of Persister.findById
- Defined in fi/hg/repository/persisters/mysql/MySqlPersister.ts:222

findByProperty

findByProperty<T, ID>(property: string, value: any, metadata: EntityMetadata): Promise<T>
Type Parameters
- T extends Entity<T>
- ID extends EntityIdTypes
Parameters
- property: string
- value: any
- metadata: EntityMetadata
Returns Promise<T>
Implementation of Persister.findByProperty
- Defined in fi/hg/repository/persisters/mysql/MySqlPersister.ts:240

insert

insert<T, ID>(entities: T | T[], metadata: EntityMetadata): Promise<T>
Type Parameters
- T extends Entity<T>
- ID extends EntityIdTypes
Parameters
- entities: T | T[]
- metadata: EntityMetadata
Returns Promise<T>
Implementation of Persister.insert
- Defined in fi/hg/repository/persisters/mysql/MySqlPersister.ts:87

update

update<T, ID>(entity: T, metadata: EntityMetadata): Promise<T>
Type Parameters
- T extends Entity<T>
- ID extends EntityIdTypes
Parameters
- entity: T
- metadata: EntityMetadata
Returns Promise<T>
Implementation of Persister.update
- Defined in fi/hg/repository/persisters/mysql/MySqlPersister.ts:125

Class MySqlPersister

Hierarchy

Implements

Index

Constructors

Properties

Methods

Constructors

constructor

Parameters

host: string

user: string

password: string

database: string

tablePrefix: string = ''

connectionLimit: number = 100

queueLimit: number = 0

acquireTimeout: number = ...

connectTimeout: number = ...

timeout: number = ...

queryTimeout: number = ...

waitForConnections: boolean = true

charset: string = MySqlCharset.UTF8_GENERAL_CI

Returns MySqlPersister

Properties

Private Readonly _pool

Private Readonly _queryTimeout

Private Readonly _tablePrefix

Methods

Private _query

Parameters

query: string

Optional values: any[]

Returns Promise<QueryResultPair>

count

Type Parameters

T extends Entity<T>

ID extends EntityIdTypes

Parameters

metadata: EntityMetadata

Returns Promise<number>

countByProperty

Type Parameters

T extends Entity<T>

ID extends EntityIdTypes

Parameters

property: string

value: any

metadata: EntityMetadata

Returns Promise<number>

deleteAll

Type Parameters

T extends Entity<T>

ID extends EntityIdTypes

Parameters

metadata: EntityMetadata

Returns Promise<void>

deleteAllById

Type Parameters

T extends Entity<T>

ID extends EntityIdTypes

Parameters

ids: ID[]

metadata: EntityMetadata

Returns Promise<void>

deleteAllByProperty

Type Parameters

T extends Entity<T>

ID extends EntityIdTypes

Parameters

property: string

value: any

metadata: EntityMetadata

Returns Promise<void>

deleteById

Type Parameters

T extends Entity<T>

ID extends EntityIdTypes

Parameters

id: ID

`Private` `Readonly` _pool

`Private` `Readonly` _queryTimeout

`Private` `Readonly` _tablePrefix

`Private` _query

`Optional` values: any[]