DBCDatabase

DBCDatabase designed to:

control multi-threaded access to database handler (if it was passed to another thread) or sqlite database file
execute queries and update to database
cache prepared sqlite statements (this allows speeding up requests execution)
control SQL transactions
create new database with 'read-only' or 'read-write' access
create new database from SQL dump file (file like MySQL database dump file)
create mutable copy of database

In some methods I'll reference on this small example:

DBCError *error = nil;
DBCDatabase *db = [DBCDatabase databaseWithPath:@":memory:"];
if([db openError:&error]){
    [db executeUpdate:@"DROP TABLE IF EXISTS test;
                        CREATE TABLE IF NOT EXISTS test (pid INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,  \
                                                         pType TEXT NOT NULL, pTitle TEXT,                \
                                                         loc_lat FLOAT NOT NULL, loc_lon FLOAT NOT NULL); \
                        CREATE UNIQUE INDEX locationIndex ON test (loc_lat, loc_lon);                     \
                        INSERT INTO test (pType, pTitle, loc_lat, loc_lon) VALUES ( ?1, ?2, ?3, ?4 );     \
                        INSERT INTO test (pType, pTitle, loc_lat, loc_lon) VALUES ( ?1, ?5, ?6, ?7 );     \
                        INSERT INTO test (pType, pTitle, loc_lat, loc_lon) VALUES ( ?1, ?8, ?9, ?10 );    \
                        INSERT INTO test (pType, pTitle, loc_lat, loc_lon) VALUES ( ?1, ?11, ?12, ?13 );"
                 error:&error, 
                       @"City", @"Cupertino", [NSNumber numberWithFloat:37.3261f],
                       [NSNumber numberWithFloat:-122.0320f], @"New York", [NSNumber numberWithFloat:40.724f],
                       [NSNumber numberWithFloat:-74.06f], @"Dnepropetrovsk", [NSNumber numberWithFloat:48.47f],
                       [NSNumber numberWithFloat:35.050f], @"Kiev", [NSNumber numberWithFloat:50.457f],
                       [NSNumber numberWithFloat:30.525f],
                       nil];
    if(error != nil){
        // Hmm, something has gone wrong, try to log out an error to find out something useful. Or you can set a flag
           for DBCUseDebugLogger in DBCConfiguration.h, than DBConnect will log out all debug information.
        NSLog(@"Occurred an error: %@", error);
    }
} else {
    // In some rare cases an error may occur, just log it out to find out what has gone wrong. Or you can set a flag
       for DBCUseDebugLogger in DBCConfiguration.h, than DBConnect will log out all debug information.  
    NSLog(@"Occurred an error: %@", error);
}

##Tasks ###DBCDatabase instance initialization + databaseWithPath:
+ databaseWithPath:defaultEncoding:
+ databaseFromFile:atPath:continueOnExecutionErrors:error:
+ databaseFromFile:atPath:defaultEncoding:continueOnExecutionErrors:error:
- initWithPath:defaultEncoding:
- createDatabaseFromFile:atPath:defaultEncoding:continueOnExecutionErrors:error: ###DBCDatabase sqlite database connection open/close - openError:
- openReadonlyError:
- makeMutableAt:rewriteExisting:error:
- closeError:
###DBCDatabase DDL and DML
- executeUpdate:error:
- executeQuery:error:
- executeStatementsFromFile:continueOnExecutionErrors:error:
###DBCDatabase TCL
- beginTransactionError:
- beginDeferredTransactionError:
- beginImmediateTransactionError:
- beginExclusiveTransactionError:
- commitTransactionError:
- rollbackTransactionError:
###DBCDatabase misc - databaseVersionError:
- databaseVersionFor:error:
- changeDatabaseVersion:error:
- changeDatabaseVersion:forDatabase:error:
###DBCDatabase properties busyRetryCount
defaultSQLSequencesTransactionLock
statementsCachingEnabled
rollbackSQLSequenceTransactionOnError
createTransactionOnSQLSequences
database

##Properties

busyRetryCount

This property stores statements execution retry count.

@property (nonatomic)int busyRetryCount

Discussion
If you pass reference on DBCDatabase to another thread or maybe few instances of DBCDatabase access to the same [sqlite][SQLitews] database file at the same time, requests execution may not pass because database is busy or locked. This parameter tells DBCDatabase instance to retry for specified number of times to execute statement.
Default value is set to 5.

DBCDatabase

Clone this wiki locally