Tibo Posts - Answer Overflow

Tibo

Explore posts from servers

RReactiflux CDCloudflare Developers RRailway DTDrizzle Team

•Created by Tibo on 4/18/2024 in #help

Cascade delete not working

I have this schema:

export const albums = pgTable('albums', {
    id: uuid('id').notNull().primaryKey().defaultRandom(),
    name: text('name').notNull().unique(),

    gameId: uuid('game_id').notNull(),
});

export const albumsRelations = relations(albums, ({ one, many }) => ({
    music: many(musics),
}));

export const musics = pgTable('musics', {
    id: uuid('id').notNull().primaryKey().defaultRandom(),
    name: text('name').notNull(),
    url: text('url').notNull().unique(),

    albumId: uuid('album_id')
        .notNull()
        .references(() => albums.id, { onDelete: 'cascade' }),
});

export const musicsRelations = relations(musics, ({ one, many }) => ({
    album: one(albums, { fields: [musics.albumId], references: [albums.id] }),
    musicsToAuthors: many(musicsToAuthors),
}));

export const authors = pgTable('authors', {
    id: uuid('id').notNull().primaryKey().defaultRandom(),
    name: text('name').notNull().unique(),
});

export const authorsRelations = relations(authors, ({ many }) => ({
    musicsToAuthors: many(musicsToAuthors),
}));

// more in first comment

export const albums = pgTable('albums', {
    id: uuid('id').notNull().primaryKey().defaultRandom(),
    name: text('name').notNull().unique(),

    gameId: uuid('game_id').notNull(),
});

export const albumsRelations = relations(albums, ({ one, many }) => ({
    music: many(musics),
}));

export const musics = pgTable('musics', {
    id: uuid('id').notNull().primaryKey().defaultRandom(),
    name: text('name').notNull(),
    url: text('url').notNull().unique(),

    albumId: uuid('album_id')
        .notNull()
        .references(() => albums.id, { onDelete: 'cascade' }),
});

export const musicsRelations = relations(musics, ({ one, many }) => ({
    album: one(albums, { fields: [musics.albumId], references: [albums.id] }),
    musicsToAuthors: many(musicsToAuthors),
}));

export const authors = pgTable('authors', {
    id: uuid('id').notNull().primaryKey().defaultRandom(),
    name: text('name').notNull().unique(),
});

export const authorsRelations = relations(authors, ({ many }) => ({
    musicsToAuthors: many(musicsToAuthors),
}));

// more in first comment

When I try to delete all the musics from an album I get this error:

update or delete on table "musics" violates foreign key constraint "musics_to_authors_music_id_musics_id_fk" on table "musics_to_authors"

Here's my delete: await db.delete(musics).where(eq(musics.albumId, albumId)) I don't understand what I'm doing wrong

6 replies

DTDrizzle Team

•Created by Tibo on 3/29/2024 in #help

TypeError: Cannot read properties of undefined (reading 'compositePrimaryKeys')

I'm getting this error when I want to rename a table (there are no other changes). Old table:

export const userFavoritesMusics = pgTable(
    'user_favorites',
    {
        userId: text('user_id')
            .notNull()
            .references(() => users.id, { onDelete: 'cascade' }),
        musicId: integer('music_id')
            .notNull()
            .references(() => musics.id, { onDelete: 'cascade' }),
        createdAt: timestamp('created_at').notNull().defaultNow(),
    },
    (t) => ({
        pk: primaryKey(t.userId, t.musicId),
    }),
);

export const userFavoritesMusics = pgTable(
    'user_favorites',
    {
        userId: text('user_id')
            .notNull()
            .references(() => users.id, { onDelete: 'cascade' }),
        musicId: integer('music_id')
            .notNull()
            .references(() => musics.id, { onDelete: 'cascade' }),
        createdAt: timestamp('created_at').notNull().defaultNow(),
    },
    (t) => ({
        pk: primaryKey(t.userId, t.musicId),
    }),
);

New table:

export const userFavoritesMusics = pgTable(
    'user_favorites_musics',
    {
        userId: text('user_id')
            .notNull()
            .references(() => users.id, { onDelete: 'cascade' }),
        musicId: integer('music_id')
            .notNull()
            .references(() => musics.id, { onDelete: 'cascade' }),
        createdAt: timestamp('created_at').notNull().defaultNow(),
    },
    (t) => ({
        pk: primaryKey(t.userId, t.musicId),
    }),
);

export const userFavoritesMusics = pgTable(
    'user_favorites_musics',
    {
        userId: text('user_id')
            .notNull()
            .references(() => users.id, { onDelete: 'cascade' }),
        musicId: integer('music_id')
            .notNull()
            .references(() => musics.id, { onDelete: 'cascade' }),
        createdAt: timestamp('created_at').notNull().defaultNow(),
    },
    (t) => ({
        pk: primaryKey(t.userId, t.musicId),
    }),
);

Only the name changed so I don't understand why I'm getting this error. What should I do ?

3 replies

DTDrizzle Team

•Created by Tibo on 3/17/2024 in #help

How to do inserts in many-to-many relations ?

I'm new to Drizzle and I don't really know if my tables relation is correct or not. Here's the schema:

export const musics = pgTable('musics', {
    id: serial('id').primaryKey(),
    url: text('url').notNull().unique(),
    number: integer('number').notNull(),
    title: text('title').notNull(),
    duration: integer('duration').notNull(),
    albumId: serial('album_id')
        .notNull()
        .references(() => albums.id, { onDelete: 'cascade' }),
});

export const musicsRelations = relations(musics, ({ one, many }) => ({
    album: one(albums, { fields: [musics.albumId], references: [albums.id] }),
    musicsToAuthors: many(musicsToAuthors),
}));

export const authors = pgTable('authors', {
    id: serial('id').primaryKey(),
    name: text('name').notNull().unique(),
});

export const authorsRelations = relations(authors, ({ many }) => ({
    musicsToAuthors: many(musicsToAuthors),
}));

export const musicsToAuthors = pgTable(
    'musics_to_authors',
    {
        musicId: integer('music_id')
            .notNull()
            .references(() => musics.id),
        authorId: integer('author_id')
            .notNull()
            .references(() => authors.id),
    },
    (t) => ({
        pk: primaryKey(t.musicId, t.authorId),
    }),
);

export const musicToAuthorRelations = relations(musicsToAuthors, ({ one }) => ({
    music: one(musics, {
        fields: [musicsToAuthors.musicId],
        references: [musics.id],
    }),
    author: one(authors, {
        fields: [musicsToAuthors.authorId],
        references: [authors.id],
    }),
}));

export const musics = pgTable('musics', {
    id: serial('id').primaryKey(),
    url: text('url').notNull().unique(),
    number: integer('number').notNull(),
    title: text('title').notNull(),
    duration: integer('duration').notNull(),
    albumId: serial('album_id')
        .notNull()
        .references(() => albums.id, { onDelete: 'cascade' }),
});

export const musicsRelations = relations(musics, ({ one, many }) => ({
    album: one(albums, { fields: [musics.albumId], references: [albums.id] }),
    musicsToAuthors: many(musicsToAuthors),
}));

export const authors = pgTable('authors', {
    id: serial('id').primaryKey(),
    name: text('name').notNull().unique(),
});

export const authorsRelations = relations(authors, ({ many }) => ({
    musicsToAuthors: many(musicsToAuthors),
}));

export const musicsToAuthors = pgTable(
    'musics_to_authors',
    {
        musicId: integer('music_id')
            .notNull()
            .references(() => musics.id),
        authorId: integer('author_id')
            .notNull()
            .references(() => authors.id),
    },
    (t) => ({
        pk: primaryKey(t.musicId, t.authorId),
    }),
);

export const musicToAuthorRelations = relations(musicsToAuthors, ({ one }) => ({
    music: one(musics, {
        fields: [musicsToAuthors.musicId],
        references: [musics.id],
    }),
    author: one(authors, {
        fields: [musicsToAuthors.authorId],
        references: [authors.id],
    }),
}));

I chose to use a many-to-many relation because a music can have multiple authors and an author can have multiple music. Is my schema correct ? Insert in comment

2 replies

Gaming

Programming