A modern programming language that makes developers happier.

kotlinlang

If you are using <https://cashapp.github.io/sqldelight/|SQLDelight>, see <https://cashapp.github.io/sqldelight/jvm_sqlite/migrations/>

If you use Room, take a look at the documentation for testing - <https://developer.android.com/training/data-storage/room/migrating-db-versions#test>

I am not using any of these, i am working on an old codebase using `SQLiteOpenHelper`

Unit test wise, not so easily. You possibly could, but given the resource needs it may be difficult to stub, but maybe roblectric could facilitate.
Integration test wise you’ll want to create the database and then call your override for `onUpgrade` to synthesize the upgrade process.
From there, you’d want to asssert on your results.