I'm trying to setup my first D1 db. I've successfully applied migrations using the command: npx wra
I'm trying to setup my first D1 db. I've successfully applied migrations using the command:
npx wrangler d1 migrations apply job-hunt-db --local --persist-to /tmp/job-hunt-tmp-data
but then I try to execute a command against the job-hunt-db with this command:
npx wrangler d1 execute job-hunt-db --local --command="SELECT * FROM TargetRoleAnalysis"
✘ [ERROR] no such table: TargetRoleAnalysis
I can see that there is a sqlite file in the /tmp/ directory, I've tried connecting to this db using the sqlite client, when I try to list tables the db returns empty, no tables exist. Yet the migrations to create these tables successfully executed, any ideas why this might be happening?
npx wrangler d1 migrations apply job-hunt-db --local --persist-to /tmp/job-hunt-tmp-data
but then I try to execute a command against the job-hunt-db with this command:
npx wrangler d1 execute job-hunt-db --local --command="SELECT * FROM TargetRoleAnalysis"
✘ [ERROR] no such table: TargetRoleAnalysis
I can see that there is a sqlite file in the /tmp/ directory, I've tried connecting to this db using the sqlite client, when I try to list tables the db returns empty, no tables exist. Yet the migrations to create these tables successfully executed, any ideas why this might be happening?
