[SqlDelight] can i use pragme user_version to store the current migration version for sqldelight? <h...

# squarelibraries

[Nikky]

[SqlDelight] can i use pragme user_version to store the current migration version for sqldelight?
https://www.sqlite.org/pragma.html#pragma_user_version

when i tried to add it..

setUserVersion:
    PRAGMA schema.user_version = :version;

<pragma value real> expected, got ':'

i could probably call it with ‘unsafe’ raw SQL.. might look into this later

[mbonnin]

Example here: https://github.com/JakeWharton/dodo/blob/0ba2fe7bb2d6c4964b94af6eadd9a6eb7477f667/src/main/kotlin/com/jakewharton/dodo/db.kt#L17

[Nikky]

thanks, this got me started.. needed to change things around a bit to work with async queries using WebWorkerDriver (wrap in AsyncResult, call await(), etc)

but it works 😛