View on GitHub
GPKGSQLiteMaster Class Reference
GPKGSQLiteMaster
Objective-C
@interface GPKGSQLiteMaster : NSObjectSwift
class GPKGSQLiteMaster : NSObjectSQLite Master table queries (sqlite_master)
-
Result count
Declaration
Objective-C
- (int)count;Swift
func count() -> Int32Return Value
count
-
Get the columns in the result
Declaration
Objective-C
- (NSArray<NSNumber *> *)columns;Swift
func columns() -> [NSNumber]!Return Value
columns
-
Get the type
Declaration
Objective-C
- (enum GPKGSQLiteMasterType)typeAtRow:(int)row;Swift
func type(atRow row: Int32) -> GPKGSQLiteMasterTypeParameters
rowrow index
Return Value
type
-
Get the type string
Declaration
Objective-C
- (NSString *)typeStringAtRow:(int)row;Swift
func typeString(atRow row: Int32) -> String!Parameters
rowrow index
Return Value
type string
-
Get the name
Declaration
Objective-C
- (NSString *)nameAtRow:(int)row;Swift
func name(atRow row: Int32) -> String!Parameters
rowrow index
Return Value
name
-
Get the table name
Declaration
Objective-C
- (NSString *)tableNameAtRow:(int)row;Swift
func tableName(atRow row: Int32) -> String!Parameters
rowrow index
Return Value
name
-
Get the rootpage
Declaration
Objective-C
- (NSNumber *)rootpageAtRow:(int)row;Swift
func rootpage(atRow row: Int32) -> NSNumber!Parameters
rowrow index
Return Value
name
-
Get the sql
Declaration
Objective-C
- (NSString *)sqlAtRow:(int)row;Swift
func sql(atRow row: Int32) -> String!Parameters
rowrow index
Return Value
name
-
Get the value of the column at the row index
Declaration
Objective-C
- (NSObject *)valueAtRow:(int)row forColumn:(enum GPKGSQLiteMasterColumn)column;Swift
func value(atRow row: Int32, for column: GPKGSQLiteMasterColumn) -> NSObject!Parameters
rowrow index
columncolumn type
Return Value
value
-
Get the row at the row index
Parameters
rowrow index
Return Value
row column values
-
Get the value in the row at the column index
Declaration
Objective-C
- (NSObject *)valueInRow:(GPKGRow *)row forColumn:(enum GPKGSQLiteMasterColumn)column;Swift
func value(in row: GPKGRow!, for column: GPKGSQLiteMasterColumn) -> NSObject!Parameters
rowrow
columncolumn type
Return Value
value
-
Get the column index of the column type
Declaration
Objective-C
- (int)columnIndex:(enum GPKGSQLiteMasterColumn)column;Swift
func columnIndex(_ column: GPKGSQLiteMasterColumn) -> Int32Parameters
columncolumn type
Return Value
column index
-
Get the constraints from table SQL
Declaration
Objective-C
- (GPKGTableConstraints *)constraintsAtRow:(int)row;Swift
func constraints(atRow row: Int32) -> GPKGTableConstraints!Parameters
rowrow index
Return Value
constraints
-
Shortcut to build a column into an array
Declaration
Objective-C
+ (NSArray *)columnsFromColumn:(enum GPKGSQLiteMasterColumn)column;Swift
class func columns(from column: GPKGSQLiteMasterColumn) -> [Any]!Parameters
columncolumn
Return Value
columns
-
Shortcut to build a type into an array
Declaration
Objective-C
+ (NSArray *)typesFromType:(enum GPKGSQLiteMasterType)type;Swift
class func types(from type: GPKGSQLiteMasterType) -> [Any]!Parameters
typetype
Return Value
types
-
Count the sqlite_master table
Declaration
Objective-C
+ (int)countWithConnection:(GPKGConnection *)db;Swift
class func count(with db: GPKGConnection!) -> Int32Parameters
dbconnection
Return Value
count
-
Query the sqlite_master table
Declaration
Objective-C
+ (GPKGSQLiteMaster *)queryWithConnection:(GPKGConnection *)db;Swift
class func query(with db: GPKGConnection!) -> GPKGSQLiteMaster!Parameters
dbconnection
Return Value
SQLiteMaster result
-
Count the sqlite_master table
Declaration
Objective-C
+ (int)countWithConnection:(GPKGConnection *)db andTable:(NSString *)tableName;Swift
class func count(with db: GPKGConnection!, andTable tableName: String!) -> Int32Parameters
dbconnection
tableNametable name
Return Value
count
-
Query the sqlite_master table
Declaration
Objective-C
+ (GPKGSQLiteMaster *)queryWithConnection:(GPKGConnection *)db andTable:(NSString *)tableName;Swift
class func query(with db: GPKGConnection!, andTable tableName: String!) -> GPKGSQLiteMaster!Parameters
dbconnection
tableNametable name
Return Value
SQLiteMaster result
-
Query the sqlite_master table
Declaration
Objective-C
+ (GPKGSQLiteMaster *)queryWithConnection:(GPKGConnection *)db andColumns:(NSArray<NSNumber *> *)columns;Swift
class func query(with db: GPKGConnection!, andColumns columns: [NSNumber]!) -> GPKGSQLiteMaster!Parameters
dbconnection
columnsresult columns
Return Value
SQLiteMaster result
-
Query the sqlite_master table
Declaration
Objective-C
+ (GPKGSQLiteMaster *)queryWithConnection:(GPKGConnection *)db andColumns:(NSArray<NSNumber *> *)columns andTable:(NSString *)tableName;Swift
class func query(with db: GPKGConnection!, andColumns columns: [NSNumber]!, andTable tableName: String!) -> GPKGSQLiteMaster!Parameters
dbconnection
columnsresult columns
tableNametable name
Return Value
SQLiteMaster result
-
Query the sqlite_master table
Declaration
Objective-C
+ (GPKGSQLiteMaster *)queryWithConnection:(GPKGConnection *)db andType:(enum GPKGSQLiteMasterType)type;Swift
class func query(with db: GPKGConnection!, andType type: GPKGSQLiteMasterType) -> GPKGSQLiteMaster!Parameters
dbconnection
typeresult type
Return Value
SQLiteMaster result
-
Query the sqlite_master table
Declaration
Objective-C
+ (GPKGSQLiteMaster *)queryWithConnection:(GPKGConnection *)db andTypes:(NSArray<NSNumber *> *)types;Swift
class func query(with db: GPKGConnection!, andTypes types: [NSNumber]!) -> GPKGSQLiteMaster!Parameters
dbconnection
typesresult types
Return Value
SQLiteMaster result
-
Query the sqlite_master table
Declaration
Objective-C
+ (GPKGSQLiteMaster *)queryWithConnection:(GPKGConnection *)db andType:(enum GPKGSQLiteMasterType)type andTable:(NSString *)tableName;Swift
class func query(with db: GPKGConnection!, andType type: GPKGSQLiteMasterType, andTable tableName: String!) -> GPKGSQLiteMaster!Parameters
dbconnection
typeresult type
tableNametable name
Return Value
SQLiteMaster result
-
Query the sqlite_master table
Declaration
Objective-C
+ (GPKGSQLiteMaster *)queryWithConnection:(GPKGConnection *)db andTypes:(NSArray<NSNumber *> *)types andTable:(NSString *)tableName;Swift
class func query(with db: GPKGConnection!, andTypes types: [NSNumber]!, andTable tableName: String!) -> GPKGSQLiteMaster!Parameters
dbconnection
typesresult types
tableNametable name
Return Value
SQLiteMaster result
-
Count the sqlite_master table
Declaration
Objective-C
+ (int)countWithConnection:(GPKGConnection *)db andType:(enum GPKGSQLiteMasterType)type;Swift
class func count(with db: GPKGConnection!, andType type: GPKGSQLiteMasterType) -> Int32Parameters
dbconnection
typeresult type
Return Value
count
-
Query the sqlite_master table
Declaration
Objective-C
+ (GPKGSQLiteMaster *)queryWithConnection:(GPKGConnection *)db andColumns:(NSArray<NSNumber *> *)columns andType:(enum GPKGSQLiteMasterType)type;Swift
class func query(with db: GPKGConnection!, andColumns columns: [NSNumber]!, andType type: GPKGSQLiteMasterType) -> GPKGSQLiteMaster!Parameters
dbconnection
columnsresult columns
typeresult type
Return Value
SQLiteMaster result
-
Count the sqlite_master table
Declaration
Objective-C
+ (int)countWithConnection:(GPKGConnection *)db andType:(enum GPKGSQLiteMasterType)type andTable:(NSString *)tableName;Swift
class func count(with db: GPKGConnection!, andType type: GPKGSQLiteMasterType, andTable tableName: String!) -> Int32Parameters
dbconnection
typeresult type
tableNametable name
Return Value
count
-
Query the sqlite_master table
Declaration
Objective-C
+ (GPKGSQLiteMaster *)queryWithConnection:(GPKGConnection *)db andColumns:(NSArray<NSNumber *> *)columns andType:(enum GPKGSQLiteMasterType)type andTable:(NSString *)tableName;Swift
class func query(with db: GPKGConnection!, andColumns columns: [NSNumber]!, andType type: GPKGSQLiteMasterType, andTable tableName: String!) -> GPKGSQLiteMaster!Parameters
dbconnection
columnsresult columns
typeresult type
tableNametable name
Return Value
SQLiteMaster result
-
Count the sqlite_master table
Declaration
Objective-C
+ (int)countWithConnection:(GPKGConnection *)db andTypes:(NSArray<NSNumber *> *)types;Swift
class func count(with db: GPKGConnection!, andTypes types: [NSNumber]!) -> Int32Parameters
dbconnection
typesresult types
Return Value
count
-
Query the sqlite_master table
Declaration
Objective-C
+ (GPKGSQLiteMaster *)queryWithConnection:(GPKGConnection *)db andColumns:(NSArray<NSNumber *> *)columns andTypes:(NSArray<NSNumber *> *)types;Swift
class func query(with db: GPKGConnection!, andColumns columns: [NSNumber]!, andTypes types: [NSNumber]!) -> GPKGSQLiteMaster!Parameters
dbconnection
columnsresult columns
typesresult types
Return Value
SQLiteMaster result
-
Count the sqlite_master table
Declaration
Objective-C
+ (int)countWithConnection:(GPKGConnection *)db andTypes:(NSArray<NSNumber *> *)types andTable:(NSString *)tableName;Swift
class func count(with db: GPKGConnection!, andTypes types: [NSNumber]!, andTable tableName: String!) -> Int32Parameters
dbconnection
typesresult types
tableNametable name
Return Value
count
-
Query the sqlite_master table
Declaration
Objective-C
+ (GPKGSQLiteMaster *)queryWithConnection:(GPKGConnection *)db andColumns:(NSArray<NSNumber *> *)columns andTypes:(NSArray<NSNumber *> *)types andTable:(NSString *)tableName;Swift
class func query(with db: GPKGConnection!, andColumns columns: [NSNumber]!, andTypes types: [NSNumber]!, andTable tableName: String!) -> GPKGSQLiteMaster!Parameters
dbconnection
columnsresult columns
typesresult types
tableNametable name
Return Value
SQLiteMaster result
-
Query the sqlite_master table
Declaration
Objective-C
+ (GPKGSQLiteMaster *)queryWithConnection:(GPKGConnection *)db andQuery:(GPKGSQLiteMasterQuery *)query;Swift
class func query(with db: GPKGConnection!, andQuery query: GPKGSQLiteMasterQuery!) -> GPKGSQLiteMaster!Parameters
dbconnection
queryquery
Return Value
SQLiteMaster result
-
Count the sqlite_master table
Declaration
Objective-C
+ (int)countWithConnection:(GPKGConnection *)db andQuery:(GPKGSQLiteMasterQuery *)query;Swift
class func count(with db: GPKGConnection!, andQuery query: GPKGSQLiteMasterQuery!) -> Int32Parameters
dbconnection
queryquery
Return Value
count
-
Query the sqlite_master table
Declaration
Objective-C
+ (GPKGSQLiteMaster *)queryWithConnection:(GPKGConnection *)db andColumns:(NSArray<NSNumber *> *)columns andQuery:(GPKGSQLiteMasterQuery *)query;Swift
class func query(with db: GPKGConnection!, andColumns columns: [NSNumber]!, andQuery query: GPKGSQLiteMasterQuery!) -> GPKGSQLiteMaster!Parameters
dbconnection
columnsresult columns
queryquery
Return Value
SQLiteMaster result
-
Query the sqlite_master table
Declaration
Objective-C
+ (GPKGSQLiteMaster *)queryWithConnection:(GPKGConnection *)db andType:(enum GPKGSQLiteMasterType)type andQuery:(GPKGSQLiteMasterQuery *)query;Swift
class func query(with db: GPKGConnection!, andType type: GPKGSQLiteMasterType, andQuery query: GPKGSQLiteMasterQuery!) -> GPKGSQLiteMaster!Parameters
dbconnection
typeresult type
queryquery
Return Value
SQLiteMaster result
-
Count the sqlite_master table
Declaration
Objective-C
+ (int)countWithConnection:(GPKGConnection *)db andType:(enum GPKGSQLiteMasterType)type andQuery:(GPKGSQLiteMasterQuery *)query;Swift
class func count(with db: GPKGConnection!, andType type: GPKGSQLiteMasterType, andQuery query: GPKGSQLiteMasterQuery!) -> Int32Parameters
dbconnection
typeresult type
queryquery
Return Value
count
-
Query the sqlite_master table
Declaration
Objective-C
+ (GPKGSQLiteMaster *)queryWithConnection:(GPKGConnection *)db andColumns:(NSArray<NSNumber *> *)columns andType:(enum GPKGSQLiteMasterType)type andQuery:(GPKGSQLiteMasterQuery *)query;Swift
class func query(with db: GPKGConnection!, andColumns columns: [NSNumber]!, andType type: GPKGSQLiteMasterType, andQuery query: GPKGSQLiteMasterQuery!) -> GPKGSQLiteMaster!Parameters
dbconnection
columnsresult columns
typeresult type
queryquery
Return Value
SQLiteMaster result
-
Count the sqlite_master table
Declaration
Objective-C
+ (int)countWithConnection:(GPKGConnection *)db andTypes:(NSArray<NSNumber *> *)types andQuery:(GPKGSQLiteMasterQuery *)query;Swift
class func count(with db: GPKGConnection!, andTypes types: [NSNumber]!, andQuery query: GPKGSQLiteMasterQuery!) -> Int32Parameters
dbconnection
typesresult types
queryquery
Return Value
count
-
Query the sqlite_master table
Declaration
Objective-C
+ (GPKGSQLiteMaster *)queryWithConnection:(GPKGConnection *)db andColumns:(NSArray<NSNumber *> *)columns andTypes:(NSArray<NSNumber *> *)types andQuery:(GPKGSQLiteMasterQuery *)query;Swift
class func query(with db: GPKGConnection!, andColumns columns: [NSNumber]!, andTypes types: [NSNumber]!, andQuery query: GPKGSQLiteMasterQuery!) -> GPKGSQLiteMaster!Parameters
dbconnection
columnsresult columns
typesresult types
queryquery
Return Value
SQLiteMaster result
-
Query the sqlite_master views on the table
Declaration
Objective-C
+ (GPKGSQLiteMaster *)queryViewsWithConnection:(GPKGConnection *)db andTable:(NSString *)tableName;Swift
class func queryViews(with db: GPKGConnection!, andTable tableName: String!) -> GPKGSQLiteMaster!Parameters
dbconnection
tableNametable name
Return Value
SQLiteMaster result
-
Query the sqlite_master views on the table
Declaration
Objective-C
+ (GPKGSQLiteMaster *)queryViewsWithConnection:(GPKGConnection *)db andColumns:(NSArray<NSNumber *> *)columns andTable:(NSString *)tableName;Swift
class func queryViews(with db: GPKGConnection!, andColumns columns: [NSNumber]!, andTable tableName: String!) -> GPKGSQLiteMaster!Parameters
dbconnection
columnsresult columns
tableNametable name
Return Value
SQLiteMaster result
-
Count the sqlite_master views on the table
Declaration
Objective-C
+ (int)countViewsWithConnection:(GPKGConnection *)db andTable:(NSString *)tableName;Swift
class func countViews(with db: GPKGConnection!, andTable tableName: String!) -> Int32Parameters
dbconnection
tableNametable name
Return Value
count
-
Query for the table constraints
Declaration
Objective-C
+ (GPKGTableConstraints *)queryForConstraintsWithConnection:(GPKGConnection *)db andTable: (NSString *)tableName;Swift
class func queryForConstraints(with db: GPKGConnection!, andTable tableName: String!) -> GPKGTableConstraints!Parameters
dbconnection
tableNametable name
Return Value
SQL constraints