@sourceloop/reporting-service / Exports / BaseSequelize

Class: BaseSequelize

Hierarchy

• BaseSequelize

  ↳ MysqlSequelizeStrategy

  ↳ PsqlSequelizeStrategy

Implements

• SequelizeStrategy

Table of contents

Constructors

• constructor

Properties

• logger
• sequilizeQuertUtility

Methods

• applyRowLevelFilter
• checkIfColumnsExists
• checkIfDataSourceExists
• listDataSourceColumns
• listdataSources
• manageRecord
• query
• sanitizeValue
• translateQuery

Constructors

constructor

• new BaseSequelize(logger, sequilizeQuertUtility)

Parameters

Name	Type
logger	ILogger
sequilizeQuertUtility	QueryUtilityInterface

Defined in

services/reporting-service/src/strategies/sequelize/base-sequelize.ts:18

Properties

logger

• logger: ILogger

Defined in

services/reporting-service/src/strategies/sequelize/base-sequelize.ts:16

---

sequilizeQuertUtility

• sequilizeQuertUtility: QueryUtilityInterface

Defined in

services/reporting-service/src/strategies/sequelize/base-sequelize.ts:17

Methods

applyRowLevelFilter

▸ Abstract applyRowLevelFilter(initialQuery): Promise<StructuredQueryInterface>

Parameters

Name	Type
initialQuery	StructuredQueryInterface

Returns

Promise<StructuredQueryInterface>

Implementation of

SequelizeStrategy.applyRowLevelFilter

Defined in

services/reporting-service/src/strategies/sequelize/base-sequelize.ts:51

---

checkIfColumnsExists

▸ Abstract checkIfColumnsExists(columnEntityPairs): Promise<boolean>

Parameters

Name	Type
columnEntityPairs	ColumnEntityPair[]

Returns

Promise<boolean>

Implementation of

SequelizeStrategy.checkIfColumnsExists

Defined in

services/reporting-service/src/strategies/sequelize/base-sequelize.ts:47

---

checkIfDataSourceExists

▸ Abstract checkIfDataSourceExists(dataSourceNames): Promise<boolean>

Parameters

Name	Type
dataSourceNames	string[]

Returns

Promise<boolean>

Implementation of

SequelizeStrategy.checkIfDataSourceExists

Defined in

services/reporting-service/src/strategies/sequelize/base-sequelize.ts:45

---

listDataSourceColumns

▸ Abstract listDataSourceColumns(dataSource): Promise<ColumnForDataSourceModel[]>

Parameters

Name	Type
dataSource	string

Returns

Promise<ColumnForDataSourceModel[]>

Implementation of

SequelizeStrategy.listDataSourceColumns

Defined in

services/reporting-service/src/strategies/sequelize/base-sequelize.ts:41

---

listdataSources

▸ Abstract listdataSources(): Promise<DataSourceList[]>

Returns

Promise<DataSourceList[]>

Implementation of

SequelizeStrategy.listdataSources

Defined in

services/reporting-service/src/strategies/sequelize/base-sequelize.ts:35

---

manageRecord

▸ Abstract manageRecord(dataSource, data, identifier?): Promise<AnyObject>

Parameters

Name	Type
dataSource	string
data	IngestReportRecord
identifier?	string

Returns

Promise<AnyObject>

Implementation of

SequelizeStrategy.manageRecord

Defined in

services/reporting-service/src/strategies/sequelize/base-sequelize.ts:29

---

query

▸ Abstract query(queryObject): Promise<AnyObject[]>

Parameters

Name	Type
queryObject	string | StructuredQueryInterface

Returns

Promise<AnyObject[]>

Implementation of

SequelizeStrategy.query

Defined in

services/reporting-service/src/strategies/sequelize/base-sequelize.ts:37

---

sanitizeValue

▸ sanitizeValue(value): JSONValueType

Parameters

Name	Type
value	JSONValueType

Returns

JSONValueType

Defined in

services/reporting-service/src/strategies/sequelize/base-sequelize.ts:23

---

translateQuery

▸ translateQuery(queryObject): Promise<{ bind: AnyObject ; query: string }>

Parameters

Name	Type
queryObject	StructuredQueryInterface

Returns

Promise<{ bind: AnyObject ; query: string }>

Implementation of

SequelizeStrategy.translateQuery

Defined in

services/reporting-service/src/strategies/sequelize/base-sequelize.ts:55