paaradiso Comments - Answer Overflow

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

DTDrizzle Team

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

how to do the opposite of inArray()?

that works, thanks 🙂

7 replies

DTDrizzle Team

•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

DTDrizzle Team

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

how to do the opposite of inArray()?

just an array

7 replies

Gaming

Programming