paaradiso Comments - Answer Overflow

Topics

paaradiso

Explore posts from servers

KKysely DTDrizzle Team

•Created by paaradiso on 6/12/2024 in #help

NeonDbError: Error connecting to database: fetch failed

dunno what other information to provide

3 replies

•Created by paaradiso on 11/11/2023 in #help

how can i delete if row exists (where eq(xxx)), otherwise insert, in one query?

easier to implement as well

24 replies

•Created by paaradiso on 11/11/2023 in #help

how can i delete if row exists (where eq(xxx)), otherwise insert, in one query?

that's much smarter, thanks :)

24 replies

•Created by paaradiso on 11/11/2023 in #help

how can i delete if row exists (where eq(xxx)), otherwise insert, in one query?

yeah true

24 replies

•Created by paaradiso on 11/11/2023 in #help

how can i delete if row exists (where eq(xxx)), otherwise insert, in one query?

hmm

24 replies

•Created by paaradiso on 11/11/2023 in #help

how can i delete if row exists (where eq(xxx)), otherwise insert, in one query?

i see

24 replies

•Created by paaradiso on 11/11/2023 in #help

how can i delete if row exists (where eq(xxx)), otherwise insert, in one query?

how should i do it?

24 replies

•Created by paaradiso on 11/11/2023 in #help

how can i delete if row exists (where eq(xxx)), otherwise insert, in one query?

ooh okay

24 replies

•Created by paaradiso on 11/11/2023 in #help

how can i delete if row exists (where eq(xxx)), otherwise insert, in one query?

i think this should work? https://www.commandprompt.com/education/postgresql-if-else-statement-with-examples/

24 replies

•Created by paaradiso on 11/11/2023 in #help

how can i delete if row exists (where eq(xxx)), otherwise insert, in one query?

i have a table of collections (music singles, eps, albums) that you can like. i also have a liked_collections table that just has user_id and collection_id columns. when a collection is liked/unliked, i want to either remove a row if it's already liked, or insert a row if it's not already liked

24 replies

•Created by paaradiso on 11/9/2023 in #help

how to do the opposite of inArray()?

that works, thanks 🙂

7 replies

•Created by paaradiso on 11/9/2023 in #help

how to do the opposite of inArray()?

export const collectionsTable = pgTable('collections', {
    id: integer('id').primaryKey(),
    name: text('name'),
    type: collectionTypeEnum('type'),
    cover: text('cover'),
    artist: text('artist'),
    tags: text('tags')
        .references(() => tagsTable.name)
        .array(),
    releaseDate: date('release_date'),
    addedBy: text('added_by')
});

export const collectionsTable = pgTable('collections', {
    id: integer('id').primaryKey(),
    name: text('name'),
    type: collectionTypeEnum('type'),
    cover: text('cover'),
    artist: text('artist'),
    tags: text('tags')
        .references(() => tagsTable.name)
        .array(),
    releaseDate: date('release_date'),
    addedBy: text('added_by')
});

7 replies

•Created by paaradiso on 11/9/2023 in #help

how to do the opposite of inArray()?

just an array

7 replies