081

NSString *databaseName = @"my.db";

    NSArray *documentPaths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);

    NSString *documentsDir = [documentPaths objectAtIndex:0];

    NSString *databasePath = [documentsDir stringByAppendingPathComponent:databaseName];

    // Check if the SQL database has already been saved to the users phone, if not then copy it over

    BOOL success;

    // Create a FileManager object, we will use this to check the status

    // of the database and to copy it over if required

    NSFileManager *fileManager = [NSFileManager defaultManager];

    // Check if the database has already been created in the users filesystem

    success = [fileManager fileExistsAtPath:databasePath];

    // If the database already exists then return without doing anything

    if(success) return;

    // If not then proceed to copy the database from the application to the users filesystem

    // Get the path to the database in the application package

    NSString *databasePathFromApp = [[[NSBundle mainBundle] resourcePath] stringByAppendingPathComponent:databaseName];

    NSLog(@"databasePathFromApp %@", databasePathFromApp);

    // Copy the database from the package to the users filesystem

    [fileManager copyItemAtPath:databasePathFromApp toPath:databasePath error:nil];