@sourceloop/reporting-service / Exports / QueryUtilityInterface

Interface: QueryUtilityInterface

Table of contents

Methods

• jsonToQueryConverter
• listAllDataSourcesFromJson
• prepareFinalSqlQuery
• validateQueryObject

Methods

jsonToQueryConverter

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

Parameters

Name	Type
query	StructuredQueryInterface

Returns

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

Defined in

services/reporting-service/src/interfaces/query-utility.interface.ts:11

---

listAllDataSourcesFromJson

▸ listAllDataSourcesFromJson(query, removeSchema): string[]

Parameters

Name	Type
query	StructuredQueryInterface
removeSchema	boolean

Returns

string[]

Defined in

services/reporting-service/src/interfaces/query-utility.interface.ts:7

---

prepareFinalSqlQuery

▸ prepareFinalSqlQuery(sqlQuery, filter): string

Parameters

Name	Type
sqlQuery	string
filter	CustomFilter<AnyObject>

Returns

string

Defined in

services/reporting-service/src/interfaces/query-utility.interface.ts:15

---

validateQueryObject

▸ validateQueryObject(query): boolean

Parameters

Name	Type
query	StructuredQueryInterface

Returns

boolean

Defined in

services/reporting-service/src/interfaces/query-utility.interface.ts:6