ObjectiveC - 平面文件到 CoreData

Question

我有一个包含 100 万行的大文件。文件设置如下：

A1 B1 C1 D1 E1
A2 B2 C2 D2 E2
A3 B3 C3 D3 E3

我想将此数据读入由 CoreData 管理的 SQLite 数据库中。

做到这一点最有效和最有效的方法是什么？

这可以通过使用 CoreData & 来实现。 Objective-C 或创建一个 SQLite 数据库，然后将其导入到使用 CoreData 的项目中。

Answer 1

如果这不是您需要即时执行的操作，那么我可能会编写某种脚本：（1）创建数据库/架构，然后（2）从文件中读取并插入到适当的表中。然后我将数据库导入到项目中。

Answer 2

下面是我在 iOS 应用程序中使用的方法示例，用于加载分隔文本文件（使用竖线“|”作为字段分隔符），其中包含有关多种植物和动物物种的数据。该文件存储在应用程序的文档目录中，以便用户可以通过 iTunes 通过文档共享来添加/更改它。该文件名为“X.specieslist”，其中 X 与 Core Data 管理的 sqlite 数据库同名。该代码检查数据库中是否已存在给定物种（基于“代码”键），并且仅导入那些不存在的物种。

- (void)loadSpecies {

    //get path to species file stored in Documents directory
    NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
    NSString *basePath = ([paths count] > 0) ? [paths objectAtIndex:0] : nil;
    NSPersistentStoreCoordinator *psc = [managedObjectContext persistentStoreCoordinator];
    NSArray *psa = [psc persistentStores];
    NSURL *psurl = [[psa objectAtIndex: 0] URL];
    NSString *filestr = [[psurl lastPathComponent] stringByReplacingOccurrencesOfString: @"sqlite" withString: @"specieslist"] ;
    NSString *filePath = [basePath stringByAppendingPathComponent: filestr];

    //create array with each element containing a single line from the input file
    NSArray *speciesRecords = [[NSString stringWithContentsOfFile: filePath encoding: NSUTF8StringEncoding error: nil] componentsSeparatedByString: @"\n"];

    if (speciesRecords) {
        int speciesAdded = 0;
        int speciesSkipped = 0;
        NSEntityDescription *entity = [NSEntityDescription entityForName: @"Species" inManagedObjectContext: managedObjectContext];
        NSManagedObject *newSpecies;
        NSDictionary *speciesDictionary;
        NSArray *fieldKeys = [[NSArray alloc] initWithObjects: @"code", @"scientificName", @"commonName", @"family", @"lifeform", @"growthForm", @"lifecycle", @"nativity", @"notes", nil];
        NSArray *fieldValues;
        NSArray *existingRecords = [fetchedResultsController fetchedObjects];
        NSPredicate *speciesCodePred;
        NSArray *speciesMatch;

        for (NSString *species in speciesRecords) {
            fieldValues = [species componentsSeparatedByString: @"|"];

            //check if species code already exists
            speciesCodePred = [NSPredicate predicateWithFormat: @"code MATCHES %@", [fieldValues objectAtIndex: 0] ];
            speciesMatch = [existingRecords filteredArrayUsingPredicate: speciesCodePred];

            //only add species not already present
            if ([speciesMatch count] == 0) {
                newSpecies = [[NSManagedObject alloc] initWithEntity: entity insertIntoManagedObjectContext: managedObjectContext];
                speciesDictionary = [NSDictionary dictionaryWithObjects: fieldValues forKeys: fieldKeys];
                [newSpecies setValuesForKeysWithDictionary: speciesDictionary];
                [newSpecies release];
                speciesAdded++;
            }
            else
                speciesSkipped++;
        }
        [fieldKeys release];
        NSString *speciesSkippedString = (speciesSkipped > 0) ? [NSString stringWithFormat: @" and %d species were skipped because they were already present.", speciesSkipped] : @".";

        UIAlertView *av = [[UIAlertView alloc] initWithTitle: @"Species List Import" message: [NSString stringWithFormat: @"%d species were added to the database%@", speciesAdded, speciesSkippedString] delegate: nil cancelButtonTitle: @"OK" otherButtonTitles: nil];
        [av show];
        [av release];
    }

    else {
        UIAlertView *av = [[UIAlertView alloc] initWithTitle: @"Species List Import" message: @"A species list file was not present, no species were imported." delegate: nil cancelButtonTitle:@"OK" otherButtonTitles: nil];
        [av show];
        [av release];
    }
}