Fright XO Posts - Answer Overflow

Fright XO

Explore posts from servers

•Created by Fright XO on 10/17/2024 in #help-and-questions

PRISMA_SKIP_POSTINSTALL_GENERATE is Not Skipping Generate on yarn install

I am running into errors during dockerfile builds, in which I cannot reach the database. My soluition was to try using the environment variables. During yarn install it seems the generate command is still running.

6 replies

PPrisma

•Created by Fright XO on 6/24/2024 in #help-and-questions

Best Practices for Updating Nested Relations in Prisma with NestJS and SQL Server

Hello! I'm working on a project using NestJS, Prisma, and SQL Server, and I need help with updating a complex model with many relations. Here’s the context: I have the following models with relationships:

UserConfig
|- Preferences? // 1:1
|  |- NotificationSettings[] // 1:N
|  |  `- EmailSettings? // 1:1
|  `- ThemeSettings? // 1:1
`- AccountSettings? // 1:1
   `- PrivacySettings[] // 1:N

UserConfig
|- Preferences? // 1:1
|  |- NotificationSettings[] // 1:N
|  |  `- EmailSettings? // 1:1
|  `- ThemeSettings? // 1:1
`- AccountSettings? // 1:1
   `- PrivacySettings[] // 1:N

Models in Prisma Schema:

model UserConfig {
  id               Int    @id @default(autoincrement())
  userId           Int    @unique
  preferences      Preferences?
  accountSettings  AccountSettings?
}

model Preferences {
  id                    Int    @id @default(autoincrement())
  userConfigId          Int    @unique
  notificationSettings  NotificationSettings[]
  themeSettings         ThemeSettings?
  userConfig            UserConfig @relation(fields: [userConfigId], references: [id], onDelete: Cascade)
}

model NotificationSettings {
  id              Int    @id @default(autoincrement())
  type            String // "EMAIL" | "SMS"
  preferencesId   Int
  emailSettings   EmailSettings?
  preferences     Preferences @relation(fields: [preferencesId], references: [id], onDelete: Cascade)
}

model EmailSettings {
  id                   Int    @id @default(autoincrement())
  email                String
  notificationSettingsId Int    @unique
  notificationSettings NotificationSettings @relation(fields: [notificationSettingsId], references: [id], onDelete: Cascade)
}

model ThemeSettings {
  id            Int    @id @default(autoincrement())
  theme         String
  preferencesId Int    @unique
  preferences   Preferences @relation(fields: [preferencesId], references: [id], onDelete: Cascade)
}

model AccountSettings {
  id               Int    @id @default(autoincrement())
  userConfigId     Int    @unique
  privacySettings  PrivacySettings[]
  userConfig       UserConfig @relation(fields: [userConfigId], references: [id], onDelete: Cascade)
}

model PrivacySettings {
  id                Int    @id @default(autoincrement())
  setting           String
  accountSettingsId Int
  accountSettings   AccountSettings @relation(fields: [accountSettingsId], references: [id], onDelete: Cascade)
}

model UserConfig {
  id               Int    @id @default(autoincrement())
  userId           Int    @unique
  preferences      Preferences?
  accountSettings  AccountSettings?
}

model Preferences {
  id                    Int    @id @default(autoincrement())
  userConfigId          Int    @unique
  notificationSettings  NotificationSettings[]
  themeSettings         ThemeSettings?
  userConfig            UserConfig @relation(fields: [userConfigId], references: [id], onDelete: Cascade)
}

model NotificationSettings {
  id              Int    @id @default(autoincrement())
  type            String // "EMAIL" | "SMS"
  preferencesId   Int
  emailSettings   EmailSettings?
  preferences     Preferences @relation(fields: [preferencesId], references: [id], onDelete: Cascade)
}

model EmailSettings {
  id                   Int    @id @default(autoincrement())
  email                String
  notificationSettingsId Int    @unique
  notificationSettings NotificationSettings @relation(fields: [notificationSettingsId], references: [id], onDelete: Cascade)
}

model ThemeSettings {
  id            Int    @id @default(autoincrement())
  theme         String
  preferencesId Int    @unique
  preferences   Preferences @relation(fields: [preferencesId], references: [id], onDelete: Cascade)
}

model AccountSettings {
  id               Int    @id @default(autoincrement())
  userConfigId     Int    @unique
  privacySettings  PrivacySettings[]
  userConfig       UserConfig @relation(fields: [userConfigId], references: [id], onDelete: Cascade)
}

model PrivacySettings {
  id                Int    @id @default(autoincrement())
  setting           String
  accountSettingsId Int
  accountSettings   AccountSettings @relation(fields: [accountSettingsId], references: [id], onDelete: Cascade)
}

Question: How can I efficiently update these models in a single query or within a transaction? The update should handle creating, deleting, and updating nested related objects. I currently do not have services or controllers for the related models, but I can create them if necessary. Thank you for any guidance!

4 replies

CC#

•Created by Fright XO on 1/18/2023 in #help

✅ How to flush NLog on application exit with MEL

Hi, I am using Microsoft.Extension.Logger (MEL) ILogger abstraction, and NLog as my provided implementation. When I use an AsyncWrapper, the final log messages aren't written. I've read that it's important to flush async targets before ending the application. How can I flush nlog via the MEL abstraction?

3 replies

CC#

•Created by Fright XO on 1/12/2023 in #help

❔ ✅ DotNet Templating Bind Project Name

With dotnet, there is a templating tool. It supports symbol replacement. With that you can bind to various properties. https://github.com/dotnet/templating/wiki/Binding-and-project-context-evaluation#bind-symbols I would like to get the project name. This would be whatever the developer submitted for their project name. There is a feature which replaces the project name, using the sourceName property, but this is a "safe" project name which uses _. I have tried many bindings I would expect to work but none do. msbuild:projectname context:projectname projectname targetname project name I also tried creating a derived symbol from the source name but I am unable to find the binding for the source name. Rider doesn't support custom parameter symbols so I want to avoid that for now since Rider is quite popular among my developer audience.

20 replies

Gaming

Programming