GPKGSQLiteMasterQuery

Objective-C

@interface GPKGSQLiteMasterQuery : NSObject

Swift

class GPKGSQLiteMasterQuery : NSObject

Query on the SQLiteMaster table

Show on GitHub

  • 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
    Show on GitHub

  • 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
    Show on GitHub

  • Add an is null query

    Declaration

    Objective-C

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

    Swift

    func addIsNullColumn(_ column: GPKGSQLiteMasterColumn)

    Parameters

    column

    column
    Show on GitHub

  • Add an is not null query

    Declaration

    Objective-C

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

    Swift

    func addIsNotNullColumn(_ column: GPKGSQLiteMasterColumn)

    Parameters

    column

    column
    Show on GitHub

  • Determine a query has been set

    Declaration

    Objective-C

    - (BOOL)has;

    Swift

    func has() -> Bool

    Return Value

    true if has a query

    Show on GitHub

  • Build the query SQL

    Declaration

    Objective-C

    - (NSString *)buildSQL;

    Swift

    func buildSQL() -> String!

    Return Value

    sql

    Show on GitHub

  • Get the query arguments

    Declaration

    Objective-C

    - (NSArray<NSString *> *)arguments;

    Swift

    func arguments() -> [String]!

    Return Value

    arguments

    Show on GitHub

  • Create an empty query that supports a single query

    Declaration

    Objective-C

    + (GPKGSQLiteMasterQuery *)create;

    Swift

    class func create() -> GPKGSQLiteMasterQuery!

    Return Value

    query

    Show on GitHub

  • Create a query with multiple queries combined by an OR

    Declaration

    Objective-C

    + (GPKGSQLiteMasterQuery *)createOr;

    Swift

    class func createOr() -> GPKGSQLiteMasterQuery!

    Return Value

    query

    Show on GitHub

  • Create a query with multiple queries combined by an AND

    Declaration

    Objective-C

    + (GPKGSQLiteMasterQuery *)createAnd;

    Swift

    class func createAnd() -> GPKGSQLiteMasterQuery!

    Return Value

    query

    Show on GitHub

  • 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

    Show on GitHub

  • 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

    Show on GitHub

  • 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

    Show on GitHub

  • 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

    Show on GitHub

  • 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

    Show on GitHub

  • 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

    Show on GitHub

  • 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

    Show on GitHub