unable to see the latest updated sqllite db in wwwroot folder

asked 2022-06-08T01:15:41.237+00:00
Kesavamurthi D 106 Reputation points

hi admin

I am using azure webservices for hosting my python flask app (os- linux), used SQLite DB which will do all crud operations from code. I have for the placed this .db file along wiht app.py for it to access it .all crud operations works fine in local env.
steps to reproduce:

  1. I deployed the project to azure using vs code. Deployment was successful
  2. Checked the instance in cloud .it has got all rows from the local which is fine.
  3. Using hosted API I performed many crud operations and verified it to via postman all rows are updated .
  4. Now i downloaded the wwwroot from app editor from azure page assuming all the recent rows inserted via hosted api can be seen in the download file ( wwwroot folder).
  5. verified the .db file but it contains only the initial rows which i upload during the initial deployment.

thought of using the downloaded db for trouble shooting but it got only the initial rows .pls help

expected solution: the downloaded .db file should have all recent rows updated using the hosted api link and thought of using it again for redeployment so that the continuity is maintained and i have to repeat this same methodology in client implementation too for trouble shooting and database correction..

.i am downloading the folder from azure-advanced tools->go->Site wwwroot->output.tar.gz . i am downloading this output.tar.qz and when verify by unzipping it the .db files is not updated wiht latest rows only the initial files during deployment was present ..any help where i can find the latest deployment packages ..

Azure Web Apps
Azure Web Apps
A feature of Azure App Service used to create and deploy scalable, mission-critical web apps.
4,295 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. answered 2022-06-08T22:24:36.597+00:00
    Ryan Hill 15,986 Reputation points Microsoft Employee

    I would start with this troubleshooting guide @Kesavamurthi D . I would expect that you would see database is locked messages in your logs due to CIFS. It's definitely not a supported scenario and is recommended that you use a cloud database such as Postgres.

    No comments