GPKGSQLiteMasterQuery

Objective-C

@interface GPKGSQLiteMasterQuery : NSObject

Swift

class GPKGSQLiteMasterQuery : NSObject

Query on the SQLiteMaster table

  • Add an equality query

    Declaration

    Objective-C

    - (void)addColumn:(enum GPKGSQLiteMasterColumn)column
            withValue:(NSString *)value;

    Swift

    func add(_ column: GPKGSQLiteMasterColumn, withValue value: String!)

    Parameters

    column

    column

    value

    value

  • Add a query

    Declaration

    Objective-C

    - (void)addColumn:(enum GPKGSQLiteMasterColumn)column
        withOperation:(NSString *)operation
             andValue:(NSString *)value;

    Swift

    func add(_ column: GPKGSQLiteMasterColumn, withOperation operation: String!, andValue value: String!)

    Parameters

    column

    column

    operation

    operation

    value

    value

  • Add an is null query

    Declaration

    Objective-C

    - (void)addIsNullColumn:(enum GPKGSQLiteMasterColumn)column;

    Swift

    func addIsNullColumn(_ column: GPKGSQLiteMasterColumn)

    Parameters

    column

    column

  • Add an is not null query

    Declaration

    Objective-C

    - (void)addIsNotNullColumn:(enum GPKGSQLiteMasterColumn)column;

    Swift

    func addIsNotNullColumn(_ column: GPKGSQLiteMasterColumn)

    Parameters

    column

    column

  • Determine a query has been set

    Declaration

    Objective-C

    - (BOOL)has;

    Swift

    func has() -> Bool

    Return Value

    true if has a query

  • Build the query SQL

    Declaration

    Objective-C

    - (NSString *)buildSQL;

    Swift

    func buildSQL() -> String!

    Return Value

    sql

  • Get the query arguments

    Declaration

    Objective-C

    - (NSArray<NSString *> *)arguments;

    Swift

    func arguments() -> [String]!

    Return Value

    arguments

  • Create an empty query that supports a single query

    Declaration

    Objective-C

    + (GPKGSQLiteMasterQuery *)create;

    Swift

    class func create() -> GPKGSQLiteMasterQuery!

    Return Value

    query

  • Create a query with multiple queries combined by an OR

    Declaration

    Objective-C

    + (GPKGSQLiteMasterQuery *)createOr;

    Swift

    class func createOr() -> GPKGSQLiteMasterQuery!

    Return Value

    query

  • Create a query with multiple queries combined by an AND

    Declaration

    Objective-C

    + (GPKGSQLiteMasterQuery *)createAnd;

    Swift

    class func createAnd() -> GPKGSQLiteMasterQuery!

    Return Value

    query

  • Create a single equality query

    Declaration

    Objective-C

    + (GPKGSQLiteMasterQuery *)createWithColumn:(enum GPKGSQLiteMasterColumn)column
                                       andValue:(NSString *)value;

    Swift

    class func create(with column: GPKGSQLiteMasterColumn, andValue value: String!) -> GPKGSQLiteMasterQuery!

    Parameters

    column

    column

    value

    value

    Return Value

    query

  • Create a single query

    Declaration

    Objective-C

    + (GPKGSQLiteMasterQuery *)createWithColumn:(enum GPKGSQLiteMasterColumn)column
                                   andOperation:(NSString *)operation
                                       andValue:(NSString *)value;

    Swift

    class func create(with column: GPKGSQLiteMasterColumn, andOperation operation: String!, andValue value: String!) -> GPKGSQLiteMasterQuery!

    Parameters

    column

    column

    operation

    operation

    value

    value

    Return Value

    query

  • Create an equality query with multiple values for a single column combined with an OR

    Declaration

    Objective-C

    + (GPKGSQLiteMasterQuery *)createOrWithColumn:
                                   (enum GPKGSQLiteMasterColumn)column
                                        andValues:(NSArray<NSString *> *)values;

    Swift

    class func createOr(with column: GPKGSQLiteMasterColumn, andValues values: [String]!) -> GPKGSQLiteMasterQuery!

    Parameters

    column

    column

    values

    value

    Return Value

    query

  • Create a query with multiple values for a single column combined with an OR

    Declaration

    Objective-C

    + (GPKGSQLiteMasterQuery *)createOrWithColumn:
                                   (enum GPKGSQLiteMasterColumn)column
                                     andOperation:(NSString *)operation
                                        andValues:(NSArray<NSString *> *)values;

    Swift

    class func createOr(with column: GPKGSQLiteMasterColumn, andOperation operation: String!, andValues values: [String]!) -> GPKGSQLiteMasterQuery!

    Parameters

    column

    column

    operation

    operation

    values

    value

    Return Value

    query

  • Create an equality query with multiple values for a single column combined with an AND

    Declaration

    Objective-C

    + (GPKGSQLiteMasterQuery *)createAndWithColumn:
                                   (enum GPKGSQLiteMasterColumn)column
                                         andValues:(NSArray<NSString *> *)values;

    Swift

    class func createAnd(with column: GPKGSQLiteMasterColumn, andValues values: [String]!) -> GPKGSQLiteMasterQuery!

    Parameters

    column

    column

    values

    value

    Return Value

    query

  • Create a query with multiple values for a single column combined with an AND

    Declaration

    Objective-C

    + (GPKGSQLiteMasterQuery *)createAndWithColumn:
                                   (enum GPKGSQLiteMasterColumn)column
                                      andOperation:(NSString *)operation
                                         andValues:(NSArray<NSString *> *)values;

    Swift

    class func createAnd(with column: GPKGSQLiteMasterColumn, andOperation operation: String!, andValues values: [String]!) -> GPKGSQLiteMasterQuery!

    Parameters

    column

    column

    operation

    operation

    values

    value

    Return Value

    query

  • Create a query to find views in the sql column referring to the table

    Declaration

    Objective-C

    + (GPKGSQLiteMasterQuery *)createViewQueryWithTable:(NSString *)tableName;

    Swift

    class func createViewQuery(withTable tableName: String!) -> GPKGSQLiteMasterQuery!

    Parameters

    tableName

    table name

    Return Value

    query