LucasB25 Comments - Answer Overflow

LucasB25

Explore posts from servers

DIAdiscord.js - Imagine an app PPrisma

Posts Comments

PPrisma

•Created by LucasB25 on 3/1/2025 in #help-and-questions

Prisma migrate

because there is no utility for database schema updates?

11 replies

PPrisma

•Created by LucasB25 on 3/1/2025 in #help-and-questions

Prisma migrate

And how should that work?

11 replies

PPrisma

•Created by LucasB25 on 3/1/2025 in #help-and-questions

Prisma migrate

ah nice

11 replies

PPrisma

•Created by LucasB25 on 3/1/2025 in #help-and-questions

Prisma migrate

hi, The request resets all database data, not just the playlist

11 replies

PPrisma

•Created by LucasB25 on 3/1/2025 in #help-and-questions

Prisma migrate

I just changed Playlist Old

model Playlist {
  userId String
  name   String
  tracks String?

  @@unique([userId, name])
}

model Playlist {
  userId String
  name   String
  tracks String?

  @@unique([userId, name])
}

New

model Playlist {
    userId     String
    name       String
    tracks     String?
    lastUpdate DateTime @updatedAt //ADD
    isPublic   Boolean  @default(false) //ADD

    @@id([userId, name]) //EDITE
}

model Playlist {
    userId     String
    name       String
    tracks     String?
    lastUpdate DateTime @updatedAt //ADD
    isPublic   Boolean  @default(false) //ADD

    @@id([userId, name]) //EDITE
}

11 replies

PPrisma

•Created by LucasB25 on 3/1/2025 in #help-and-questions

Prisma migrate

New Schema

generator client {
    provider      = "prisma-client-js"
    binaryTargets = ["native", "debian-openssl-3.0.x"]
}

datasource db {
    provider = "sqlite"
    url      = "file:./panais.db"
}

model Bot {
    botId         String     @unique @id
    totalPlaySong Int
}

model Guild {
    guildId       String      @id
    prefix        String
    language      String?     @default("EnglishUS")
    defaultVolume DefaultVolume?
    theme         Theme?
    stay          Stay?
    dj            Dj?
    premium       Premium?
    roles         Role[]
    setup         Setup?
}

model DefaultVolume {
    guildId  String  @id
    volume   Int     @default(100)
    Guild    Guild   @relation(fields: [guildId], references: [guildId])
}

model Theme {
    guildId String  @id
    theme   String  @default("classic")
    Guild   Guild   @relation(fields: [guildId], references: [guildId])
}

model Stay {
    guildId String @id
    textId  String
    voiceId String
    Guild   Guild  @relation(fields: [guildId], references: [guildId])
}

model Dj {
    guildId String  @id
    mode    Boolean
    Guild   Guild   @relation(fields: [guildId], references: [guildId])
}

model Role {
    guildId String
    roleId  String
    Guild   Guild  @relation(fields: [guildId], references: [guildId])

    @@unique([guildId, roleId])
}

model Playlist {
    userId     String
    name       String
    tracks     String?
    lastUpdate DateTime @updatedAt
    isPublic   Boolean  @default(false)

    @@id([userId, name])
}

model Setup {
    guildId   String @id
    textId    String
    messageId String
    Guild     Guild  @relation(fields: [guildId], references: [guildId])
}

model Premium {
    guildId  String  @id
    isActive Int
    Guild    Guild   @relation(fields: [guildId], references: [guildId])
}

generator client {
    provider      = "prisma-client-js"
    binaryTargets = ["native", "debian-openssl-3.0.x"]
}

datasource db {
    provider = "sqlite"
    url      = "file:./panais.db"
}

model Bot {
    botId         String     @unique @id
    totalPlaySong Int
}

model Guild {
    guildId       String      @id
    prefix        String
    language      String?     @default("EnglishUS")
    defaultVolume DefaultVolume?
    theme         Theme?
    stay          Stay?
    dj            Dj?
    premium       Premium?
    roles         Role[]
    setup         Setup?
}

model DefaultVolume {
    guildId  String  @id
    volume   Int     @default(100)
    Guild    Guild   @relation(fields: [guildId], references: [guildId])
}

model Theme {
    guildId String  @id
    theme   String  @default("classic")
    Guild   Guild   @relation(fields: [guildId], references: [guildId])
}

model Stay {
    guildId String @id
    textId  String
    voiceId String
    Guild   Guild  @relation(fields: [guildId], references: [guildId])
}

model Dj {
    guildId String  @id
    mode    Boolean
    Guild   Guild   @relation(fields: [guildId], references: [guildId])
}

model Role {
    guildId String
    roleId  String
    Guild   Guild  @relation(fields: [guildId], references: [guildId])

    @@unique([guildId, roleId])
}

model Playlist {
    userId     String
    name       String
    tracks     String?
    lastUpdate DateTime @updatedAt
    isPublic   Boolean  @default(false)

    @@id([userId, name])
}

model Setup {
    guildId   String @id
    textId    String
    messageId String
    Guild     Guild  @relation(fields: [guildId], references: [guildId])
}

model Premium {
    guildId  String  @id
    isActive Int
    Guild    Guild   @relation(fields: [guildId], references: [guildId])
}

11 replies

PPrisma

•Created by LucasB25 on 3/1/2025 in #help-and-questions

Prisma migrate

Old schema

generator client {
    provider      = "prisma-client-js"
    binaryTargets = ["native", "debian-openssl-3.0.x"]
}

datasource db {
    provider = "sqlite"
    url      = "file:./panais.db"
}

model Bot {
    botId         String     @unique @id
    totalPlaySong Int
}

model Guild {
    guildId       String      @id
    prefix        String
    language      String?     @default("EnglishUS")
    defaultVolume DefaultVolume?
    theme         Theme?
    stay          Stay?
    dj            Dj?
    premium       Premium?
    roles         Role[]
    setup         Setup?
}

model DefaultVolume {
    guildId  String  @id
    volume   Int     @default(100)
    Guild    Guild   @relation(fields: [guildId], references: [guildId])
}

model Theme {
    guildId String  @id
    theme   String  @default("classic")
    Guild   Guild   @relation(fields: [guildId], references: [guildId])
}

model Stay {
    guildId String @id
    textId  String
    voiceId String
    Guild   Guild  @relation(fields: [guildId], references: [guildId])
}

model Dj {
    guildId String  @id
    mode    Boolean
    Guild   Guild   @relation(fields: [guildId], references: [guildId])
}

model Role {
    guildId String
    roleId  String
    Guild   Guild  @relation(fields: [guildId], references: [guildId])

    @@unique([guildId, roleId])
}

model Playlist {
  userId String
  name   String
  tracks String?

  @@unique([userId, name])
}

model Setup {
    guildId   String @id
    textId    String
    messageId String
    Guild     Guild  @relation(fields: [guildId], references: [guildId])
}

model Premium {
    guildId  String  @id
    isActive Int
    Guild    Guild   @relation(fields: [guildId], references: [guildId])
}

generator client {
    provider      = "prisma-client-js"
    binaryTargets = ["native", "debian-openssl-3.0.x"]
}

datasource db {
    provider = "sqlite"
    url      = "file:./panais.db"
}

model Bot {
    botId         String     @unique @id
    totalPlaySong Int
}

model Guild {
    guildId       String      @id
    prefix        String
    language      String?     @default("EnglishUS")
    defaultVolume DefaultVolume?
    theme         Theme?
    stay          Stay?
    dj            Dj?
    premium       Premium?
    roles         Role[]
    setup         Setup?
}

model DefaultVolume {
    guildId  String  @id
    volume   Int     @default(100)
    Guild    Guild   @relation(fields: [guildId], references: [guildId])
}

model Theme {
    guildId String  @id
    theme   String  @default("classic")
    Guild   Guild   @relation(fields: [guildId], references: [guildId])
}

model Stay {
    guildId String @id
    textId  String
    voiceId String
    Guild   Guild  @relation(fields: [guildId], references: [guildId])
}

model Dj {
    guildId String  @id
    mode    Boolean
    Guild   Guild   @relation(fields: [guildId], references: [guildId])
}

model Role {
    guildId String
    roleId  String
    Guild   Guild  @relation(fields: [guildId], references: [guildId])

    @@unique([guildId, roleId])
}

model Playlist {
  userId String
  name   String
  tracks String?

  @@unique([userId, name])
}

model Setup {
    guildId   String @id
    textId    String
    messageId String
    Guild     Guild  @relation(fields: [guildId], references: [guildId])
}

model Premium {
    guildId  String  @id
    isActive Int
    Guild    Guild   @relation(fields: [guildId], references: [guildId])
}