CamBlackwood Comments - Answer Overflow

CamBlackwood

Explore posts from servers

•Created by CamBlackwood on 9/18/2024 in #🙋questions

After running a database migration locally, all my database deleted - how to prevent in prod?

cool, deleted all the duplicates, deleted all migrations within past 2 hours and restarted the server - do I need to redeploy?

35 replies

WWasp-lang

•Created by CamBlackwood on 9/18/2024 in #🙋questions

After running a database migration locally, all my database deleted - how to prevent in prod?

just fixed the query, working on removing the duplicates atm

35 replies

WWasp-lang

•Created by CamBlackwood on 9/18/2024 in #🙋questions

After running a database migration locally, all my database deleted - how to prevent in prod?

35 replies

WWasp-lang

•Created by CamBlackwood on 9/18/2024 in #🙋questions

After running a database migration locally, all my database deleted - how to prevent in prod?

also, the client and server now are seem to be totally disconnected again which would maybe point to the db being corrupted

35 replies

WWasp-lang

•Created by CamBlackwood on 9/18/2024 in #🙋questions

After running a database migration locally, all my database deleted - how to prevent in prod?

oh interesting, it does run now but it says there is no UnverifiedCreator table. Maybe it wiped somehow, should I try and reset it from that snapshot?

35 replies

WWasp-lang

•Created by CamBlackwood on 9/18/2024 in #🙋questions

After running a database migration locally, all my database deleted - how to prevent in prod?

thanks

35 replies

WWasp-lang

•Created by CamBlackwood on 9/18/2024 in #🙋questions

After running a database migration locally, all my database deleted - how to prevent in prod?

is it obvious that I'm more of a frontend developer 😂

35 replies

WWasp-lang

•Created by CamBlackwood on 9/18/2024 in #🙋questions

After running a database migration locally, all my database deleted - how to prevent in prod?

@miho I don't seem to be getting anything back when I try and query the database via the CLI. I know I'm connected (I get a list of databases), but even when I run SELECT * FROM UnverifiedCreator nothing comes back

35 replies

WWasp-lang

•Created by CamBlackwood on 9/18/2024 in #🙋questions

After running a database migration locally, all my database deleted - how to prevent in prod?

Thanks mate I’ll get cracking on that now!

35 replies

WWasp-lang

•Created by CamBlackwood on 9/18/2024 in #🙋questions

After running a database migration locally, all my database deleted - how to prevent in prod?

Ah that makes a lot of sense thank you

35 replies

WWasp-lang

•Created by CamBlackwood on 9/18/2024 in #🙋questions

After running a database migration locally, all my database deleted - how to prevent in prod?

this was in the logs

35 replies

WWasp-lang

•Created by CamBlackwood on 9/18/2024 in #🙋questions

After running a database migration locally, all my database deleted - how to prevent in prod?

@miho just gave deploying it a try and seems to have caused some db issues (same thing I had the other day, it seems disconnected). I'll try and wind it back using the snapshot I took

35 replies

WWasp-lang

•Created by CamBlackwood on 9/18/2024 in #🙋questions

After running a database migration locally, all my database deleted - how to prevent in prod?

cool, thanks @miho 🙂 I'll grab a backup for the prod database as well using pg_dump as well just in case and will test it

35 replies

WWasp-lang

•Created by CamBlackwood on 9/18/2024 in #🙋questions

After running a database migration locally, all my database deleted - how to prevent in prod?

That's the migration file

35 replies

WWasp-lang

•Created by CamBlackwood on 9/18/2024 in #🙋questions

After running a database migration locally, all my database deleted - how to prevent in prod?

/*
  Warnings:

  - A unique constraint covering the columns `[tiktokUsername]` on the table `UnverifiedCreator` will be added. If there are existing duplicate values, this will fail.

*/
-- CreateIndex
CREATE UNIQUE INDEX "UnverifiedCreator_tiktokUsername_key" ON "UnverifiedCreator"("tiktokUsername");

/*
  Warnings:

  - A unique constraint covering the columns `[tiktokUsername]` on the table `UnverifiedCreator` will be added. If there are existing duplicate values, this will fail.

*/
-- CreateIndex
CREATE UNIQUE INDEX "UnverifiedCreator_tiktokUsername_key" ON "UnverifiedCreator"("tiktokUsername");

35 replies

WWasp-lang

•Created by CamBlackwood on 9/18/2024 in #🙋questions

After running a database migration locally, all my database deleted - how to prevent in prod?

@miho It's related to the database of influencers I have, I changed it so that the username for each platform must be unique across that database (so there's no duplicate accounts, basically). I'll dig out the migrations file now

35 replies

WWasp-lang

•Created by CamBlackwood on 9/16/2024 in #🙋questions

Deployed Server and Client appear "Disconnected"

@sodic hey 🙂 yeah it was me omitting the ssl parameter from the db url that was the issue in the end, all sorted now!

24 replies

WWasp-lang

•Created by CamBlackwood on 9/16/2024 in #🙋questions

Stripe Webhook not firing when relevant events fire

if you want I can make a version of it and raise a PR?

30 replies

WWasp-lang

•Created by CamBlackwood on 9/16/2024 in #🙋questions

Stripe Webhook not firing when relevant events fire

yeah anything high contrast from the background is v useful for people with my type of colourblindness. Although I should've read it - maybe it's worth putting the sentence "make sure to use the url that matches the webhook url in your main.wasp file payemnts API definition." in bold?

30 replies

WWasp-lang

•Created by CamBlackwood on 9/16/2024 in #🙋questions

Stripe Webhook not firing when relevant events fire

your solution instantly worked btw, thanks Vinny

30 replies

Gaming

Programming