Hey all, was wondering if anybody could help.
We have a prod app using SQLDelight.
I need to create a new Table that will hold a date. The dates going to be sent as a param for a server call. So we need to check if the date exists in this new Table, if not, use the current date, and store it.
I was wondering how best to do this? As I believe we will need a database migration. I'm also not sure of the best way to create the Table. I have added it to my .sq file, but when I try to check if there is any date in it, I get 'no such table' error, which makes sense as it hasn't been created. I'm not sure of where the best place to create it would be.