Class SQLiteMasterQuery

Hierarchy

SQLiteMasterQuery

Constructors

constructor

new SQLiteMasterQuery(combineOperation: string): SQLiteMasterQuery
Create a query with the combine operation
Parameters
- combineOperation: string
  
  combine operation
Returns SQLiteMasterQuery
- Defined in lib/db/master/sqliteMasterQuery.ts:28

Properties

arguments

arguments: string[] = []

List of arguments

combineOperation

combineOperation: string

Combine operation for multiple queries

queries

queries: string[] = []

List of queries

Methods

add

add(column: SQLiteMasterColumn, operation: string, value: string): void
Add a query
Parameters
- column: SQLiteMasterColumn
  
  column
- operation: string
  
  operation
- value: string
  
  value
Returns void
- Defined in lib/db/master/sqliteMasterQuery.ts:38

addIsNotNull

addIsNotNull(column: SQLiteMasterColumn): void
Add an is not null query
Parameters
- column: SQLiteMasterColumn
  
  column
Returns void
- Defined in lib/db/master/sqliteMasterQuery.ts:63

addIsNull

addIsNull(column: SQLiteMasterColumn): void
Add an is null query
Parameters
- column: SQLiteMasterColumn
  
  column
Returns void
- Defined in lib/db/master/sqliteMasterQuery.ts:54

buildSQL

buildSQL(): string
Build the query SQL

Returns
sql

Returns string
- Defined in lib/db/master/sqliteMasterQuery.ts:89

getArguments

getArguments(): string[]
Get the query arguments

Returns
arguments

Returns string[]
- Defined in lib/db/master/sqliteMasterQuery.ts:112

has

has(): boolean
Determine a query has been set

Returns
true if has a query

Returns boolean
- Defined in lib/db/master/sqliteMasterQuery.ts:81

validateAdd

validateAdd(): void
Validate the state of the query when adding to the query

Returns void
- Defined in lib/db/master/sqliteMasterQuery.ts:71

`Static` create

create(): SQLiteMasterQuery
Create an empty query that supports a single query

Returns
query

Returns SQLiteMasterQuery
- Defined in lib/db/master/sqliteMasterQuery.ts:120

`Static` createAnd

createAnd(): SQLiteMasterQuery
Create a query with multiple queries combined by an AND

Returns
query

Returns SQLiteMasterQuery
- Defined in lib/db/master/sqliteMasterQuery.ts:136

`Static` createAndForColumnValue

createAndForColumnValue(column: SQLiteMasterColumn, values: string[]): SQLiteMasterQuery
Create an equality query with multiple values for a single column combined with an AND

Returns
query
Parameters
- column: SQLiteMasterColumn
  
  column
- values: string[]
  
  value
Returns SQLiteMasterQuery
- Defined in lib/db/master/sqliteMasterQuery.ts:213

`Static` createAndForOperationAndColumnValue

createAndForOperationAndColumnValue(column: SQLiteMasterColumn, operation: string, values: string[]): SQLiteMasterQuery
Create a query with multiple values for a single column combined with an AND

Returns
query
Parameters
- column: SQLiteMasterColumn
  
  column
- operation: string
  
  operation
- values: string[]
  
  value
Returns SQLiteMasterQuery
- Defined in lib/db/master/sqliteMasterQuery.ts:229

`Static` createForColumnValue

createForColumnValue(column: SQLiteMasterColumn, value: string): SQLiteMasterQuery
Create a single equality query

Returns
query
Parameters
- column: SQLiteMasterColumn
  
  column
- value: string
  
  value
Returns SQLiteMasterQuery
- Defined in lib/db/master/sqliteMasterQuery.ts:147

`Static` createForOperationAndColumnValue

createForOperationAndColumnValue(column: SQLiteMasterColumn, operation: string, value: string): SQLiteMasterQuery
Create a single query

Returns
query
Parameters
- column: SQLiteMasterColumn
  
  column
- operation: string
  
  operation
- value: string
  
  value
Returns SQLiteMasterQuery
- Defined in lib/db/master/sqliteMasterQuery.ts:160

`Static` createOr

createOr(): SQLiteMasterQuery
Create a query with multiple queries combined by an OR

Returns
query

Returns SQLiteMasterQuery
- Defined in lib/db/master/sqliteMasterQuery.ts:128

`Static` createOrForColumnValue

createOrForColumnValue(column: SQLiteMasterColumn, values: string[]): SQLiteMasterQuery
Create an equality query with multiple values for a single column combined with an OR

Returns
query
Parameters
- column: SQLiteMasterColumn
  
  column
- values: string[]
  
  value
Returns SQLiteMasterQuery
- Defined in lib/db/master/sqliteMasterQuery.ts:177

`Static` createOrForOperationAndColumnValue

createOrForOperationAndColumnValue(column: SQLiteMasterColumn, operation: string, values: string[]): SQLiteMasterQuery
Create a query with multiple values for a single column combined with an OR

Returns
query
Parameters
- column: SQLiteMasterColumn
  
  column
- operation: string
  
  operation
- values: string[]
  
  value
Returns SQLiteMasterQuery
- Defined in lib/db/master/sqliteMasterQuery.ts:194

`Static` createTableViewQuery

createTableViewQuery(tableName: string): SQLiteMasterQuery
Create a query to find views in the sql column referring to the table

Returns
query
Parameters
- tableName: string
  
  table name
Returns SQLiteMasterQuery
- Defined in lib/db/master/sqliteMasterQuery.ts:246

Generated using TypeDoc