Hi All, 1. There is a requirement in my KMM project to use the existing database file in common code...

# multiplatform

[Vinod Rai]

Hi All,
1. There is a requirement in my KMM project to use the existing database file in common code using SQLDelight like the .db file we use from assets in android. how I can do this?
2. I wish to access the JSON text from the file stored locally, parse it & return in the response in case of Network/API failure. Is there any way to do this?
Thanks in advance!

[Mustafa Ozhan]

Hello, I had same issue I couldn’t find an solution, but I found a work around, If your database is not so huge you can open your asset with sqllitebrowser and then you can export the neccessary tables as blabla.sqlite

then you will be able to add INSERT INTO commands like here
https://github.com/CurrencyConverterCalculator/CCC/blob/master/common/src/commonMain/database/com/github/mustafaozhan/ccc/common/sql/Currency.sq

[Vinod Rai]

Thanks, but I have 1000 or more records in table

[Mustafa Ozhan]

I see.. please let me know also if you find something, I would like to change my implementation too if possible 🙂