mirror of
https://github.com/wasp-lang/open-saas.git
synced 2025-11-21 08:27:28 +01:00
7d36c8f0b1
* Refactor file upload and toast notifications Replaces react-hot-toast with a custom toast system using @radix-ui/react-toast, updating all usages and adding new UI components for toast and dialog. Refactors file upload to use a two-step process: first generating an S3 upload URL, then adding the file to the database, and adds file deletion support with confirmation dialog and S3 cleanup. Updates Prisma schema, removes unused fields, and cleans up navigation and admin settings page. * Enforce file upload limit and update dependencies on opensaas-sh Added a check to restrict users to 2 file uploads in the demo, with a new helper function and error handling. Updated navigation items, improved landing page content, and removed unused dependencies (react-hot-toast). Added @radix-ui/react-toast, updated testimonials, and made minor content and code improvements. * update tests * Improve file deletion error handling and cleanup Refactors file deletion to delete the database record before attempting S3 deletion, ensuring the file is removed from the app even if S3 deletion fails. Adds error logging for failed S3 deletions to aid in manual cleanup. Also simplifies error handling in the file upload page and removes unused imports in the demo app page. * Add credit check and S3 file existence validation Added logic to decrement user credits or throw an error if out of credits in the AI demo app. Updated file upload operations to validate file existence in S3 before adding to the database, and implemented S3 file existence check utility. Minor UI and code improvements included. * Update s3Utils.ts * update app_diff * fix diff * Update deletions * Improve toast UI, error handling, and credit messaging Updated toast action hover style and icon spacing for better UI consistency. Enhanced error handling in file deletion to display specific error messages. Refined credit/subscription error message in GPT response operation for clarity and removed redundant credit decrement logic. * Refactor file upload validation and error handling Replaces error state management with toast notifications for file upload errors and success. Refactors file type validation to use a new ALLOWED_FILE_TYPES_CONST and type AllowedFileTypes. Updates validation logic to throw errors instead of returning error objects, and simplifies type handling across file upload modules. * Refactor file upload to use s3Key and add cleanup job Replaces the 'key' field with 's3Key' for file storage references throughout the codebase and database schema. Updates all related logic, types, and API contracts to use 's3Key'. Adds a scheduled job to delete old files from S3 and the database. Cleans up file type validation constants and improves consistency in file upload and download operations. * add orphaned file clean up * remove s3 cleanup job from template removed but added suggestion to docs. * Update SettingsPage.tsx * prettier format * Update UI, remove unused files Updated README with deployment and demo details. Removed unused App.tsx and package-lock.json files. Modified Main.css, NavBar constants, file uploading logic, file upload operations, and landing page content sections for improved UI and functionality. * remove pricing page from isMarketingPage
112 lines
3.8 KiB
Plaintext
112 lines
3.8 KiB
Plaintext
datasource db {
|
|
provider = "postgresql"
|
|
url = env("DATABASE_URL")
|
|
}
|
|
|
|
generator client {
|
|
provider = "prisma-client-js"
|
|
}
|
|
|
|
model User {
|
|
id String @id @default(uuid())
|
|
createdAt DateTime @default(now())
|
|
|
|
email String? @unique
|
|
username String? @unique
|
|
isAdmin Boolean @default(false)
|
|
|
|
paymentProcessorUserId String? @unique
|
|
lemonSqueezyCustomerPortalUrl String? // You can delete this if you're not using Lemon Squeezy as your payments processor.
|
|
subscriptionStatus String? // 'active', 'cancel_at_period_end', 'past_due', 'deleted'
|
|
subscriptionPlan String? // 'hobby', 'pro'
|
|
datePaid DateTime?
|
|
credits Int @default(3)
|
|
|
|
gptResponses GptResponse[]
|
|
contactFormMessages ContactFormMessage[]
|
|
tasks Task[]
|
|
files File[]
|
|
}
|
|
|
|
model GptResponse {
|
|
id String @id @default(uuid())
|
|
createdAt DateTime @default(now())
|
|
updatedAt DateTime @updatedAt
|
|
|
|
user User @relation(fields: [userId], references: [id])
|
|
userId String
|
|
|
|
content String
|
|
}
|
|
|
|
model Task {
|
|
id String @id @default(uuid())
|
|
createdAt DateTime @default(now())
|
|
|
|
user User @relation(fields: [userId], references: [id])
|
|
userId String
|
|
|
|
description String
|
|
time String @default("1")
|
|
isDone Boolean @default(false)
|
|
}
|
|
|
|
model File {
|
|
id String @id @default(uuid())
|
|
createdAt DateTime @default(now())
|
|
|
|
user User @relation(fields: [userId], references: [id])
|
|
userId String
|
|
|
|
name String
|
|
type String
|
|
s3Key String
|
|
}
|
|
|
|
model DailyStats {
|
|
id Int @id @default(autoincrement())
|
|
date DateTime @default(now()) @unique
|
|
|
|
totalViews Int @default(0)
|
|
prevDayViewsChangePercent String @default("0")
|
|
userCount Int @default(0)
|
|
paidUserCount Int @default(0)
|
|
userDelta Int @default(0)
|
|
paidUserDelta Int @default(0)
|
|
totalRevenue Float @default(0)
|
|
totalProfit Float @default(0)
|
|
|
|
sources PageViewSource[]
|
|
}
|
|
|
|
model PageViewSource {
|
|
@@id([date, name])
|
|
name String
|
|
date DateTime @default(now())
|
|
|
|
dailyStats DailyStats? @relation(fields: [dailyStatsId], references: [id])
|
|
dailyStatsId Int?
|
|
|
|
visitors Int
|
|
}
|
|
|
|
model Logs {
|
|
id Int @id @default(autoincrement())
|
|
createdAt DateTime @default(now())
|
|
|
|
message String
|
|
level String
|
|
}
|
|
|
|
model ContactFormMessage {
|
|
id String @id @default(uuid())
|
|
createdAt DateTime @default(now())
|
|
|
|
user User @relation(fields: [userId], references: [id])
|
|
userId String
|
|
|
|
content String
|
|
isRead Boolean @default(false)
|
|
repliedAt DateTime?
|
|
}
|