IllegalArgumentException: File contains a path separator - Cannot create sqldelight file on ios application group directory

[mikezliu]

I'm trying to create the sqlite file on iOS in the application group directory so it can be shared between the main app and the today notification center widget. I've created sqlite files and shared it successfully this way in the past, just not using sqldelight.

let url = FileManager.default.containerURL(forSecurityApplicationGroupIdentifier: "group.identifier")!
let file = url.path + "/" + Schema.FILE_NAME

val dbConfig = DatabaseConfiguration(
                name = file,
                version = Schema.version,
                foreignKeyConstraints = true,
                create = { connection ->
                    wrapConnection(connection) { Schema.create(it) }
                },
                upgrade = { connection, oldVersion, newVersion ->
                    wrapConnection(connection) { Schema.migrate(it, oldVersion, newVersion) }
                }
        )

        return NativeSqliteDriver(
                dbConfig)

Runtime Environment
SQLDelight version: 1.3.0
Application OS: iOS

Describe the bug

Exception:

Uncaught Kotlin exception: kotlin.IllegalArgumentException: File
/Users/username/Library/Developer/CoreSimulator/Devices/63D82DB4-4A53-4931-906C-BB63480D651C/data/Containers/Shared/AppGroup/23F1DE03-88A2-4840-BB83-037915A442B9/db contains a path separator

It seems in DatabaseConfiguration there is a hard requirement that the sqlite file doesn't contain path separators:

if (name.contains("/")) {
        throw IllegalArgumentException(
            "File $name contains a path separator"
        )
    }

Putting the sqlite file in the application group directory is a pretty common scenario to share data with extensions - is there any way to do this? Can this path check be removed? Thanks

[mikezliu]

Oh I noticed a path property for the config, will give that a try!

[ghost]

@mikezliu I don't see it. How did you do it?

[mikezliu]

val dbConfig = DatabaseConfiguration(
                name = Schema.FILE_NAME,
                version = Schema.version,
                extendedConfig = DatabaseConfiguration.Extended(
                        foreignKeyConstraints = true,
                        basePath = path
                ),

[mikezliu]

Path should be

let path = PKPersistentContainer.defaultDirectoryURL()

[ghost]

Thank you!

[silverhammermba]

For my app I had to use

[[[[NSFileManager alloc] init] containerURLForSecurityApplicationGroupIdentifier:@"myIdentifier"] absoluteString]

for basePath. I injected this into my Kotlin code in the same way that I injected the Context for my Android driver.