RoundSparrow @ BT@bulletintree.comM to Lemmy Project Priorities Observations@bulletintree.com · 1 year ago2023-08-06message-squaremessage-square7fedilinkarrow-up12arrow-down10file-text
arrow-up12arrow-down1message-square2023-08-06RoundSparrow @ BT@bulletintree.comM to Lemmy Project Priorities Observations@bulletintree.com · 1 year agomessage-square7fedilinkfile-text
minus-squareRoundSparrowlinkfedilinkarrow-up1·1 year agoUPDATE “comment” SET “path” = $1 WHERE (“comment”.“id” = $2) RETURNING “comment”.“id”, “comment”.“creator_id”, “comment”.“post_id”, “comment”.“content”, “comment”.“removed”, “comment”.“published”, “comment”.“updated”, “comment”.“deleted”, “comment”.“ap_id”, “comment”.“local”, “comment”.“path”, “comment”.“distinguished”, “comment”.“language_id”
minus-squareRoundSparrow @ BT@bulletintree.comOPMlinkfedilinkarrow-up1·1 year agoWait…, so after an INSERT you have two of these UPDATES to set the id of the comment? UPDATE “comment” SET “ap_id” = $1 WHERE (“comment”.“id” = $2) RETURNING “comment”.“id”, “comment”.“creator_id”, “comment”.“post_id”, “comment”.“content”, “comment”.“removed”, “comment”.“published”, “comment”.“updated”, “comment”.“deleted”, “comment”.“ap_id”, “comment”.“local”, “comment”.“path”, “comment”.“distinguished”, “comment”.“language_id”
UPDATE “comment” SET “path” = $1 WHERE (“comment”.“id” = $2) RETURNING “comment”.“id”, “comment”.“creator_id”, “comment”.“post_id”, “comment”.“content”, “comment”.“removed”, “comment”.“published”, “comment”.“updated”, “comment”.“deleted”, “comment”.“ap_id”, “comment”.“local”, “comment”.“path”, “comment”.“distinguished”, “comment”.“language_id”
Wait…, so after an INSERT you have two of these UPDATES to set the id of the comment?
UPDATE “comment” SET “ap_id” = $1 WHERE (“comment”.“id” = $2) RETURNING “comment”.“id”, “comment”.“creator_id”, “comment”.“post_id”, “comment”.“content”, “comment”.“removed”, “comment”.“published”, “comment”.“updated”, “comment”.“deleted”, “comment”.“ap_id”, “comment”.“local”, “comment”.“path”, “comment”.“distinguished”, “comment”.“language_id”