sasikanth
12/06/2023, 7:02 AMRETURNING
with a DELETE
query. SQLite supports RETURNING
from 3.35.0 onwards, and I have checked that SQLite version is available from iOS 15 onwards, I have tested it on iOS 17. (posting the log in the thread)
I have create a query that deletes posts before certain period and then returns deleted ids
DELETE FROM post
WHERE post.read == 1 AND post.date < :before
RETURNING post.id;
This works great on Android when tested and on iOS it crashes. But when I wrap the query in a transaction it passes on iOS as well
postQueries.transactionWithResult {
postQueries.deleteReadPosts(before = before).executeAsList()
}
Not sure if I am doing something wrong here or if this is an issue with the platform. so, just checking to see if anyone else had a similar issue.sasikanth
12/06/2023, 7:03 AM