如何将预先存在的sqlite文件导入Core Data？

I need to import a .sqlite file into Core Data, I searched on the internet and found:

我需要将.sqlite文件导入Core Data，我在互联网上搜索并发现：

Core Data Tutorial: How To Preload/Import Existing Data

核心数据教程：如何预加载/导入现有数据

It is creating a Python script to populate this database by reading in the contents of our old database, and creating the appropriate rows in the new database. But my sqlite database is too large in term of number of tables and columns, this may cost me a considerable amount of time.

它正在创建一个Python脚本来填充此数据库，方法是读入旧数据库的内容，并在新数据库中创建相应的行。但是我的sqlite数据库在表和列的数量方面太大，这可能花费我相当长的时间。

I also found this:

我也发现了这个：

Using a Pre-Populated SQLite Database with Core Data on iPhone OS 3.0

在iPhone OS 3.0上使用预先填充的SQLite数据库和核心数据

But I don't quite understand it, it looks like it's copying old database to a new one, then how does it add Z_ suffix to all the table and column names? Also, it asks me to create entities and attributes, is there anyway this can be done automatically(from sqlite dabase file)?

但我不太明白它，看起来它正在将旧数据库复制到新数据库，那么它如何将Z_后缀添加到所有表和列名称？另外，它要求我创建实体和属性，无论如何这可以自动完成（来自sqlite dabase文件）？

Thanks!

谢谢！

2 个解决方案

#1

This answers here might be useful (mine is one of them)

这里的答案可能有用（我的就是其中之一）

Pre-populate Core Data

预填充核心数据

 /**
 Returns the path to the application's Documents directory.
*/
      - (NSString *)applicationDocumentsDirectory {
          return [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory,  NSUserDomainMask, YES) lastObject];
      }

sample code

示例代码

#2

// Returns the persistent store coordinator for the application.
// If the coordinator doesn't already exist, it is created and the application's store added to it.
- (NSPersistentStoreCoordinator *)persistentStoreCoordinator
{
    if (_persistentStoreCoordinator != nil)
    {
        return _persistentStoreCoordinator;
    }

    NSURL *storeURL = [[self applicationDocumentsDirectory] URLByAppendingPathComponent:@"yourSqlite.sqlite"];

    NSString *sourcePath = [[NSBundle mainBundle] pathForResource:@"yourSqlite.sqlite" ofType:nil];

    NSString *documentsDirectory = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) objectAtIndex:0];
    NSError *error = nil;

    if  (![[NSFileManager defaultManager] fileExistsAtPath:[documentsDirectory stringByAppendingPathComponent:@"yourSqlite.sqlite"] ]) {

        if([[NSFileManager defaultManager] copyItemAtPath:sourcePath toPath:[documentsDirectory stringByAppendingPathComponent:@"yourSqlite.sqlite"] error:&error]){
            NSLog(@"Default file successfully copied over.");
        } else {
            NSLog(@"Error description-%@ \n", [error localizedDescription]);
            NSLog(@"Error reason-%@", [error localizedFailureReason]);
        }
    }

    _persistentStoreCoordinator = [[NSPersistentStoreCoordinator alloc] initWithManagedObjectModel:[self managedObjectModel]];
    if (![_persistentStoreCoordinator addPersistentStoreWithType:NSSQLiteStoreType configuration:nil URL:storeURL options:nil error:&error])
    {
        NSLog(@"Unresolved error %@, %@", error, [error userInfo]);
        abort();
    }

    return _persistentStoreCoordinator;
}

#1