some1chan
some1chan
Explore posts from servers
SIASapphire - Imagine a frameworkDTDrizzle Team
PostsComments
DTDrizzle Team
Created by some1chan on 9/23/2023 in #help
Unwanted db.execute() behavior; trying to pass in an array instead of a record or its singular
https://github.com/drizzle-team/drizzle-orm/issues/1289 posted!
51 replies
DTDrizzle Team
Created by some1chan on 9/23/2023 in #help
Unwanted db.execute() behavior; trying to pass in an array instead of a record or its singular
Will do! i'll probably add mention of also the singular issue too, as I'd believe this would be related
51 replies
DTDrizzle Team
Created by some1chan on 9/23/2023 in #help
Unwanted db.execute() behavior; trying to pass in an array instead of a record or its singular
also just to clarify on Drizzle's stability; would I be able to expect this code to be stable, or should I really do some test cases (especially for the queryChunks[1]!)? or should I just not be using Drizzle in prod at all, and I'm doing something really risky
51 replies
DTDrizzle Team
Created by some1chan on 9/23/2023 in #help
Unwanted db.execute() behavior; trying to pass in an array instead of a record or its singular
oh wow, that's quite some code seems to work on my end, thank you! update: need to sanity check a few things update: forgot to remove a line, which broke the query. oops!
51 replies
DTDrizzle Team
Created by some1chan on 9/23/2023 in #help
Unwanted db.execute() behavior; trying to pass in an array instead of a record or its singular
let me know if you run into any issues with running the repro
51 replies
DTDrizzle Team
Created by some1chan on 9/23/2023 in #help
Unwanted db.execute() behavior; trying to pass in an array instead of a record or its singular
hope this helps!
51 replies
DTDrizzle Team
Created by some1chan on 9/23/2023 in #help
Unwanted db.execute() behavior; trying to pass in an array instead of a record or its singular
https://github.com/some1chan/drizzle-repro
51 replies
DTDrizzle Team
Created by some1chan on 9/23/2023 in #help
Unwanted db.execute() behavior; trying to pass in an array instead of a record or its singular
or so i believe
51 replies
DTDrizzle Team
Created by some1chan on 9/23/2023 in #help
Unwanted db.execute() behavior; trying to pass in an array instead of a record or its singular
ah, i should specify; im using postgres.js, not pg
51 replies
DTDrizzle Team
Created by some1chan on 9/23/2023 in #help
Unwanted db.execute() behavior; trying to pass in an array instead of a record or its singular
if it is required, any leads on how I'd figure that fnToMap out for Postgres.js? I'm looking at their GitHub right now, and nothing particularly stands out to me. Tried using choice.id from my schema
51 replies
DTDrizzle Team
Created by some1chan on 9/23/2023 in #help
Unwanted db.execute() behavior; trying to pass in an array instead of a record or its singular
is the .mapWith required? i'm currently hitting PostgresError: syntax error at or near "{" and im not sure if that's related, as I have to change your example to match what query I actually need to do (which is a direct sql one, to call a postgres function) Also to sanity check; is this the expected output (at least without .mapWidth)?
Query: SELECT public.insert_vote('018ac05623e3e0e91219a5827a481a27'::uuid, '018ac03e-243b-405e-da02-6c18c7c82b00'::uuid, 
{'018ac05623d3b7dec2b69bb78c8e0844', '018ac05623de2205e235e092b07c48d0'}::uuid[])
// Should have been...
'{018ac05623d3b7dec2b69bb78c8e0844, 018ac05623de2205e235e092b07c48d0}'::uuid[])
Query: SELECT public.insert_vote('018ac05623e3e0e91219a5827a481a27'::uuid, '018ac03e-243b-405e-da02-6c18c7c82b00'::uuid, 
{'018ac05623d3b7dec2b69bb78c8e0844', '018ac05623de2205e235e092b07c48d0'}::uuid[])
// Should have been...
'{018ac05623d3b7dec2b69bb78c8e0844, 018ac05623de2205e235e092b07c48d0}'::uuid[])
51 replies
DTDrizzle Team
Created by some1chan on 9/23/2023 in #help
Unwanted db.execute() behavior; trying to pass in an array instead of a record or its singular
for certain future plans, im worried about malicious user input inside that button somehow
51 replies
DTDrizzle Team
Created by some1chan on 9/23/2023 in #help
Unwanted db.execute() behavior; trying to pass in an array instead of a record or its singular
currently, i pull these values from the client from a Discord button + a client fetch of a user's UUID
51 replies
DTDrizzle Team
Created by some1chan on 9/23/2023 in #help
Unwanted db.execute() behavior; trying to pass in an array instead of a record or its singular
yeah, i'd like the values to be dynamic
51 replies
DTDrizzle Team
Created by some1chan on 9/23/2023 in #help
Unwanted db.execute() behavior; trying to pass in an array instead of a record or its singular
would be unsurprised if it suddenly broke
51 replies
DTDrizzle Team
Created by some1chan on 9/23/2023 in #help
Unwanted db.execute() behavior; trying to pass in an array instead of a record or its singular
just sanity-checked it; this function's been the bane of my existance for a few days 😝
51 replies
DTDrizzle Team
Created by some1chan on 9/23/2023 in #help
Unwanted db.execute() behavior; trying to pass in an array instead of a record or its singular
SELECT public.insert_vote(
    '018ac056-23e3-e0e9-1219-a5827a481a27',
    '018ac03e-243b-405e-da02-6c18c7c82b00',
    '{018ac056-26d3-4c2d-e99c-9f6acd25e802, 018ac056-26d3-4c2d-e99c-9f6acd25e803}'::uuid[]);
SELECT public.insert_vote(
    '018ac056-23e3-e0e9-1219-a5827a481a27',
    '018ac03e-243b-405e-da02-6c18c7c82b00',
    '{018ac056-26d3-4c2d-e99c-9f6acd25e802, 018ac056-26d3-4c2d-e99c-9f6acd25e803}'::uuid[]);
This query is whatever I have right now in pgAdmin, and it works
51 replies
DTDrizzle Team
Created by some1chan on 9/23/2023 in #help
Unwanted db.execute() behavior; trying to pass in an array instead of a record or its singular
i'd presume it'd be {} instead, unless im mistaken, at least judging by my raw SQL query that for sure works
51 replies
DTDrizzle Team
Created by some1chan on 9/23/2023 in #help
Unwanted db.execute() behavior; trying to pass in an array instead of a record or its singular
ah got it; 1. there's two issues, that feel connected. it'd either be one element, or it'd be a record, instead of an array 2. square brackets don't seem to be valid syntax?
51 replies
DTDrizzle Team
Created by some1chan on 9/23/2023 in #help
Unwanted db.execute() behavior; trying to pass in an array instead of a record or its singular
and i'd just repeat and join that per choice ID? not entirely sure how this'll work?
51 replies