Compare commits
2 Commits
v1/develop
...
cfdf39e6b9
| Author | SHA1 | Date | |
|---|---|---|---|
| cfdf39e6b9 | |||
30984b0784
|
170
.gitignore
vendored
170
.gitignore
vendored
@@ -1,38 +1,140 @@
|
|||||||
# Dependencies
|
# Logs
|
||||||
node_modules
|
logs
|
||||||
.pnp
|
*.log
|
||||||
.pnp.js
|
|
||||||
|
|
||||||
# Local env files
|
|
||||||
.env
|
|
||||||
.env.local
|
|
||||||
.env.development.local
|
|
||||||
.env.test.local
|
|
||||||
.env.production.local
|
|
||||||
|
|
||||||
# Testing
|
|
||||||
coverage
|
|
||||||
|
|
||||||
# Turbo
|
|
||||||
.turbo
|
|
||||||
|
|
||||||
# Vercel
|
|
||||||
.vercel
|
|
||||||
|
|
||||||
# Build Outputs
|
|
||||||
.next/
|
|
||||||
out/
|
|
||||||
build
|
|
||||||
dist
|
|
||||||
|
|
||||||
# Prisma
|
|
||||||
generated
|
|
||||||
|
|
||||||
# Debug
|
|
||||||
npm-debug.log*
|
npm-debug.log*
|
||||||
yarn-debug.log*
|
yarn-debug.log*
|
||||||
yarn-error.log*
|
yarn-error.log*
|
||||||
|
lerna-debug.log*
|
||||||
|
|
||||||
# Misc
|
# Diagnostic reports (https://nodejs.org/api/report.html)
|
||||||
.DS_Store
|
report.[0-9]*.[0-9]*.[0-9]*.[0-9]*.json
|
||||||
*.pem
|
|
||||||
|
# Runtime data
|
||||||
|
pids
|
||||||
|
*.pid
|
||||||
|
*.seed
|
||||||
|
*.pid.lock
|
||||||
|
|
||||||
|
# Directory for instrumented libs generated by jscoverage/JSCover
|
||||||
|
lib-cov
|
||||||
|
|
||||||
|
# Coverage directory used by tools like istanbul
|
||||||
|
coverage
|
||||||
|
*.lcov
|
||||||
|
|
||||||
|
# nyc test coverage
|
||||||
|
.nyc_output
|
||||||
|
|
||||||
|
# Grunt intermediate storage (https://gruntjs.com/creating-plugins#storing-task-files)
|
||||||
|
.grunt
|
||||||
|
|
||||||
|
# Bower dependency directory (https://bower.io/)
|
||||||
|
bower_components
|
||||||
|
|
||||||
|
# node-waf configuration
|
||||||
|
.lock-wscript
|
||||||
|
|
||||||
|
# Compiled binary addons (https://nodejs.org/api/addons.html)
|
||||||
|
build/Release
|
||||||
|
|
||||||
|
# Dependency directories
|
||||||
|
node_modules/
|
||||||
|
jspm_packages/
|
||||||
|
|
||||||
|
# Snowpack dependency directory (https://snowpack.dev/)
|
||||||
|
web_modules/
|
||||||
|
|
||||||
|
# TypeScript cache
|
||||||
|
*.tsbuildinfo
|
||||||
|
|
||||||
|
# Optional npm cache directory
|
||||||
|
.npm
|
||||||
|
|
||||||
|
# Optional eslint cache
|
||||||
|
.eslintcache
|
||||||
|
|
||||||
|
# Optional stylelint cache
|
||||||
|
.stylelintcache
|
||||||
|
|
||||||
|
# Optional REPL history
|
||||||
|
.node_repl_history
|
||||||
|
|
||||||
|
# Output of 'npm pack'
|
||||||
|
*.tgz
|
||||||
|
|
||||||
|
# Yarn Integrity file
|
||||||
|
.yarn-integrity
|
||||||
|
|
||||||
|
# dotenv environment variable files
|
||||||
|
.env
|
||||||
|
.env.*
|
||||||
|
!.env.example
|
||||||
|
|
||||||
|
# parcel-bundler cache (https://parceljs.org/)
|
||||||
|
.cache
|
||||||
|
.parcel-cache
|
||||||
|
|
||||||
|
# Next.js build output
|
||||||
|
.next
|
||||||
|
out
|
||||||
|
|
||||||
|
# Nuxt.js build / generate output
|
||||||
|
.nuxt
|
||||||
|
dist
|
||||||
|
|
||||||
|
# Gatsby files
|
||||||
|
.cache/
|
||||||
|
# Comment in the public line in if your project uses Gatsby and not Next.js
|
||||||
|
# https://nextjs.org/blog/next-9-1#public-directory-support
|
||||||
|
# public
|
||||||
|
|
||||||
|
# vuepress build output
|
||||||
|
.vuepress/dist
|
||||||
|
|
||||||
|
# vuepress v2.x temp and cache directory
|
||||||
|
.temp
|
||||||
|
.cache
|
||||||
|
|
||||||
|
# Sveltekit cache directory
|
||||||
|
.svelte-kit/
|
||||||
|
|
||||||
|
# vitepress build output
|
||||||
|
**/.vitepress/dist
|
||||||
|
|
||||||
|
# vitepress cache directory
|
||||||
|
**/.vitepress/cache
|
||||||
|
|
||||||
|
# Docusaurus cache and generated files
|
||||||
|
.docusaurus
|
||||||
|
|
||||||
|
# Serverless directories
|
||||||
|
.serverless/
|
||||||
|
|
||||||
|
# FuseBox cache
|
||||||
|
.fusebox/
|
||||||
|
|
||||||
|
# DynamoDB Local files
|
||||||
|
.dynamodb/
|
||||||
|
|
||||||
|
# Firebase cache directory
|
||||||
|
.firebase/
|
||||||
|
|
||||||
|
# TernJS port file
|
||||||
|
.tern-port
|
||||||
|
|
||||||
|
# Stores VSCode versions used for testing VSCode extensions
|
||||||
|
.vscode-test
|
||||||
|
|
||||||
|
# yarn v3
|
||||||
|
.pnp.*
|
||||||
|
.yarn/*
|
||||||
|
!.yarn/patches
|
||||||
|
!.yarn/plugins
|
||||||
|
!.yarn/releases
|
||||||
|
!.yarn/sdks
|
||||||
|
!.yarn/versions
|
||||||
|
|
||||||
|
# Vite logs files
|
||||||
|
vite.config.js.timestamp-*
|
||||||
|
vite.config.ts.timestamp-*
|
||||||
|
**/.helix
|
||||||
|
|||||||
43
README.md
43
README.md
@@ -1,43 +0,0 @@
|
|||||||
# Dependencies to run
|
|
||||||
|
|
||||||
- postgres
|
|
||||||
- bun
|
|
||||||
- setup biome in ide / editor
|
|
||||||
|
|
||||||
## env
|
|
||||||
|
|
||||||
```env
|
|
||||||
DATABASE_URL = "postgresql://concord_user:concord_test@localhost:5432/concord_db"
|
|
||||||
```
|
|
||||||
|
|
||||||
# Running
|
|
||||||
|
|
||||||
## API
|
|
||||||
|
|
||||||
```bash
|
|
||||||
cd apps/api
|
|
||||||
bun run dev
|
|
||||||
```
|
|
||||||
## DB
|
|
||||||
|
|
||||||
```bash
|
|
||||||
cd packages/database
|
|
||||||
bun run db:generate
|
|
||||||
bun run db:migrate
|
|
||||||
bun run db:push
|
|
||||||
bun run db:seed
|
|
||||||
bun run db:studio # optional
|
|
||||||
```
|
|
||||||
|
|
||||||
## Linting and Fixing
|
|
||||||
|
|
||||||
```bash
|
|
||||||
bunx turbo format-and-lint # view linting and formatting suggestions, without writing
|
|
||||||
bunx turbo format-and-lint:fix # write fixes
|
|
||||||
```
|
|
||||||
## Alternatively
|
|
||||||
|
|
||||||
All commands for DB and API can be run from repo root with:
|
|
||||||
```bash
|
|
||||||
bunx turbo <script> # db:generate, etc...
|
|
||||||
```
|
|
||||||
2
apps/api/.gitignore
vendored
2
apps/api/.gitignore
vendored
@@ -1,2 +0,0 @@
|
|||||||
# deps
|
|
||||||
node_modules/
|
|
||||||
@@ -1,22 +0,0 @@
|
|||||||
{
|
|
||||||
"name": "@concord/api",
|
|
||||||
"scripts": {
|
|
||||||
"dev": "bun run --hot src/index.ts",
|
|
||||||
"build": "bun build src/index.ts",
|
|
||||||
"start": "bun src/index.ts",
|
|
||||||
"lint": "biome lint .",
|
|
||||||
"format": "biome format --write .",
|
|
||||||
"typecheck": "tsc --noEmit"
|
|
||||||
},
|
|
||||||
"dependencies": {
|
|
||||||
"@concord/database": "workspace:*",
|
|
||||||
"@hono/zod-validator": "^0.7.3",
|
|
||||||
"hono": "^4.9.10",
|
|
||||||
"zod": "^4.1.12"
|
|
||||||
},
|
|
||||||
"devDependencies": {
|
|
||||||
"@types/bun": "latest",
|
|
||||||
"@concord/biome-config": "workspace:*",
|
|
||||||
"@concord/tsconfig": "workspace:*"
|
|
||||||
}
|
|
||||||
}
|
|
||||||
@@ -1,37 +0,0 @@
|
|||||||
import { prisma } from '@concord/database'; // types from prisma
|
|
||||||
import { Hono } from 'hono';
|
|
||||||
import { logger } from 'hono/logger';
|
|
||||||
|
|
||||||
const app = new Hono();
|
|
||||||
|
|
||||||
app.use('*', logger());
|
|
||||||
|
|
||||||
// Health check
|
|
||||||
app.get('/', (c) => {
|
|
||||||
return c.json({ ok: true, message: 'Hello from the Concord API' });
|
|
||||||
});
|
|
||||||
|
|
||||||
// route to get all users
|
|
||||||
const usersRoute = app.get('/users', async (c) => {
|
|
||||||
const users = await prisma.user.findMany({
|
|
||||||
select: {
|
|
||||||
id: true,
|
|
||||||
username: true,
|
|
||||||
nickname: true,
|
|
||||||
createdAt: true,
|
|
||||||
},
|
|
||||||
});
|
|
||||||
return c.json(users);
|
|
||||||
});
|
|
||||||
|
|
||||||
const port = Number.parseInt(process.env.PORT || '3000', 10);
|
|
||||||
console.log(`API server listening on port ${port}`);
|
|
||||||
|
|
||||||
// This exports the type of our app's routes,
|
|
||||||
// which the client can use for end-to-end type safety.
|
|
||||||
export type AppType = typeof usersRoute;
|
|
||||||
|
|
||||||
export default {
|
|
||||||
port: 3000,
|
|
||||||
fetch: app.fetch,
|
|
||||||
};
|
|
||||||
@@ -1,10 +0,0 @@
|
|||||||
{
|
|
||||||
"extends": "@concord/tsconfig/base.json",
|
|
||||||
"compilerOptions": {
|
|
||||||
"baseUrl": ".",
|
|
||||||
"paths": {
|
|
||||||
"@/*": ["./src/*"]
|
|
||||||
}
|
|
||||||
},
|
|
||||||
"include": ["src"]
|
|
||||||
}
|
|
||||||
@@ -1,3 +0,0 @@
|
|||||||
{
|
|
||||||
"extends": ["./packages/biome-config/biome.json"]
|
|
||||||
}
|
|
||||||
182
bun.lock
182
bun.lock
@@ -1,182 +0,0 @@
|
|||||||
{
|
|
||||||
"lockfileVersion": 1,
|
|
||||||
"workspaces": {
|
|
||||||
"": {
|
|
||||||
"name": "concord",
|
|
||||||
"devDependencies": {
|
|
||||||
"@biomejs/biome": "^2.2.5",
|
|
||||||
"turbo": "^2.5.8",
|
|
||||||
"typescript": "5.9.2",
|
|
||||||
},
|
|
||||||
},
|
|
||||||
"apps/api": {
|
|
||||||
"name": "@concord/api",
|
|
||||||
"dependencies": {
|
|
||||||
"@concord/database": "workspace:*",
|
|
||||||
"@hono/zod-validator": "^0.7.3",
|
|
||||||
"hono": "^4.9.10",
|
|
||||||
"zod": "^4.1.12",
|
|
||||||
},
|
|
||||||
"devDependencies": {
|
|
||||||
"@concord/biome-config": "workspace:*",
|
|
||||||
"@concord/tsconfig": "workspace:*",
|
|
||||||
"@types/bun": "latest",
|
|
||||||
},
|
|
||||||
},
|
|
||||||
"packages/biome-config": {
|
|
||||||
"name": "@concord/biome-config",
|
|
||||||
"version": "0.1.0",
|
|
||||||
},
|
|
||||||
"packages/database": {
|
|
||||||
"name": "@concord/database",
|
|
||||||
"dependencies": {
|
|
||||||
"@prisma/client": "^6.17.0",
|
|
||||||
},
|
|
||||||
"devDependencies": {
|
|
||||||
"@concord/biome-config": "workspace:*",
|
|
||||||
"@concord/tsconfig": "workspace:*",
|
|
||||||
"@types/bun": "latest",
|
|
||||||
"bcryptjs": "^3.0.2",
|
|
||||||
"prisma": "^6.17.0",
|
|
||||||
},
|
|
||||||
"peerDependencies": {
|
|
||||||
"typescript": "^5",
|
|
||||||
},
|
|
||||||
},
|
|
||||||
"packages/tsconfig": {
|
|
||||||
"name": "@concord/tsconfig",
|
|
||||||
"version": "0.1.0",
|
|
||||||
},
|
|
||||||
},
|
|
||||||
"packages": {
|
|
||||||
"@biomejs/biome": ["@biomejs/biome@2.2.5", "", { "optionalDependencies": { "@biomejs/cli-darwin-arm64": "2.2.5", "@biomejs/cli-darwin-x64": "2.2.5", "@biomejs/cli-linux-arm64": "2.2.5", "@biomejs/cli-linux-arm64-musl": "2.2.5", "@biomejs/cli-linux-x64": "2.2.5", "@biomejs/cli-linux-x64-musl": "2.2.5", "@biomejs/cli-win32-arm64": "2.2.5", "@biomejs/cli-win32-x64": "2.2.5" }, "bin": { "biome": "bin/biome" } }, "sha512-zcIi+163Rc3HtyHbEO7CjeHq8DjQRs40HsGbW6vx2WI0tg8mYQOPouhvHSyEnCBAorfYNnKdR64/IxO7xQ5faw=="],
|
|
||||||
|
|
||||||
"@biomejs/cli-darwin-arm64": ["@biomejs/cli-darwin-arm64@2.2.5", "", { "os": "darwin", "cpu": "arm64" }, "sha512-MYT+nZ38wEIWVcL5xLyOhYQQ7nlWD0b/4mgATW2c8dvq7R4OQjt/XGXFkXrmtWmQofaIM14L7V8qIz/M+bx5QQ=="],
|
|
||||||
|
|
||||||
"@biomejs/cli-darwin-x64": ["@biomejs/cli-darwin-x64@2.2.5", "", { "os": "darwin", "cpu": "x64" }, "sha512-FLIEl73fv0R7dI10EnEiZLw+IMz3mWLnF95ASDI0kbx6DDLJjWxE5JxxBfmG+udz1hIDd3fr5wsuP7nwuTRdAg=="],
|
|
||||||
|
|
||||||
"@biomejs/cli-linux-arm64": ["@biomejs/cli-linux-arm64@2.2.5", "", { "os": "linux", "cpu": "arm64" }, "sha512-5DjiiDfHqGgR2MS9D+AZ8kOfrzTGqLKywn8hoXpXXlJXIECGQ32t+gt/uiS2XyGBM2XQhR6ztUvbjZWeccFMoQ=="],
|
|
||||||
|
|
||||||
"@biomejs/cli-linux-arm64-musl": ["@biomejs/cli-linux-arm64-musl@2.2.5", "", { "os": "linux", "cpu": "arm64" }, "sha512-5Ov2wgAFwqDvQiESnu7b9ufD1faRa+40uwrohgBopeY84El2TnBDoMNXx6iuQdreoFGjwW8vH6k68G21EpNERw=="],
|
|
||||||
|
|
||||||
"@biomejs/cli-linux-x64": ["@biomejs/cli-linux-x64@2.2.5", "", { "os": "linux", "cpu": "x64" }, "sha512-fq9meKm1AEXeAWan3uCg6XSP5ObA6F/Ovm89TwaMiy1DNIwdgxPkNwxlXJX8iM6oRbFysYeGnT0OG8diCWb9ew=="],
|
|
||||||
|
|
||||||
"@biomejs/cli-linux-x64-musl": ["@biomejs/cli-linux-x64-musl@2.2.5", "", { "os": "linux", "cpu": "x64" }, "sha512-AVqLCDb/6K7aPNIcxHaTQj01sl1m989CJIQFQEaiQkGr2EQwyOpaATJ473h+nXDUuAcREhccfRpe/tu+0wu0eQ=="],
|
|
||||||
|
|
||||||
"@biomejs/cli-win32-arm64": ["@biomejs/cli-win32-arm64@2.2.5", "", { "os": "win32", "cpu": "arm64" }, "sha512-xaOIad4wBambwJa6mdp1FigYSIF9i7PCqRbvBqtIi9y29QtPVQ13sDGtUnsRoe6SjL10auMzQ6YAe+B3RpZXVg=="],
|
|
||||||
|
|
||||||
"@biomejs/cli-win32-x64": ["@biomejs/cli-win32-x64@2.2.5", "", { "os": "win32", "cpu": "x64" }, "sha512-F/jhuXCssPFAuciMhHKk00xnCAxJRS/pUzVfXYmOMUp//XW7mO6QeCjsjvnm8L4AO/dG2VOB0O+fJPiJ2uXtIw=="],
|
|
||||||
|
|
||||||
"@concord/api": ["@concord/api@workspace:apps/api"],
|
|
||||||
|
|
||||||
"@concord/biome-config": ["@concord/biome-config@workspace:packages/biome-config"],
|
|
||||||
|
|
||||||
"@concord/database": ["@concord/database@workspace:packages/database"],
|
|
||||||
|
|
||||||
"@concord/tsconfig": ["@concord/tsconfig@workspace:packages/tsconfig"],
|
|
||||||
|
|
||||||
"@hono/zod-validator": ["@hono/zod-validator@0.7.3", "", { "peerDependencies": { "hono": ">=3.9.0", "zod": "^3.25.0 || ^4.0.0" } }, "sha512-uYGdgVib3RlGD698WR5dVM0zB3UuPY5vHKXffGUbUh7r4xY+mFIhF3/v4AcQVLrU5CQdBso8BJr4wuVoCrjTuQ=="],
|
|
||||||
|
|
||||||
"@prisma/client": ["@prisma/client@6.17.0", "", { "peerDependencies": { "prisma": "*", "typescript": ">=5.1.0" }, "optionalPeers": ["prisma", "typescript"] }, "sha512-b42mTLOdLEZ6e/igu8CLdccAUX9AwHknQQ1+pHOftnzDP2QoyZyFvcANqSLs5ockimFKJnV7Ljf+qrhNYf6oAg=="],
|
|
||||||
|
|
||||||
"@prisma/config": ["@prisma/config@6.17.0", "", { "dependencies": { "c12": "3.1.0", "deepmerge-ts": "7.1.5", "effect": "3.16.12", "empathic": "2.0.0" } }, "sha512-k8tuChKpkO/Vj7ZEzaQMNflNGbaW4X0r8+PC+W2JaqVRdiS2+ORSv1SrDwNxsb8YyzIQJucXqLGZbgxD97ZhsQ=="],
|
|
||||||
|
|
||||||
"@prisma/debug": ["@prisma/debug@6.17.0", "", {}, "sha512-eE2CB32nr1hRqyLVnOAVY6c//iSJ/PN+Yfoa/2sEzLGpORaCg61d+nvdAkYSh+6Y2B8L4BVyzkRMANLD6nnC2g=="],
|
|
||||||
|
|
||||||
"@prisma/engines": ["@prisma/engines@6.17.0", "", { "dependencies": { "@prisma/debug": "6.17.0", "@prisma/engines-version": "6.17.0-16.c0aafc03b8ef6cdced8654b9a817999e02457d6a", "@prisma/fetch-engine": "6.17.0", "@prisma/get-platform": "6.17.0" } }, "sha512-XhE9v3hDQTNgCYMjogcCYKi7HCEkZf9WwTGuXy8cmY8JUijvU0ap4M7pGLx4pBblkp5EwUsYzw1YLtH7yi0GZw=="],
|
|
||||||
|
|
||||||
"@prisma/engines-version": ["@prisma/engines-version@6.17.0-16.c0aafc03b8ef6cdced8654b9a817999e02457d6a", "", {}, "sha512-G0VU4uFDreATgTz4sh3dTtU2C+jn+J6c060ixavWZaUaSRZsNQhSPW26lbfez7GHzR02RGCdqs5UcSuGBC3yLw=="],
|
|
||||||
|
|
||||||
"@prisma/fetch-engine": ["@prisma/fetch-engine@6.17.0", "", { "dependencies": { "@prisma/debug": "6.17.0", "@prisma/engines-version": "6.17.0-16.c0aafc03b8ef6cdced8654b9a817999e02457d6a", "@prisma/get-platform": "6.17.0" } }, "sha512-YSl5R3WIAPrmshYPkaaszOsBIWRAovOCHn3y7gkTNGG51LjYW4pi6PFNkGouW6CA06qeTjTbGrDRCgFjnmVWDg=="],
|
|
||||||
|
|
||||||
"@prisma/get-platform": ["@prisma/get-platform@6.17.0", "", { "dependencies": { "@prisma/debug": "6.17.0" } }, "sha512-3tEKChrnlmLXPd870oiVfRvj7vVKuxqP349hYaMDsbV4TZd3+lFqw8KTI2Tbq5DopamfNuNqhVCj+R6ZxKKYGQ=="],
|
|
||||||
|
|
||||||
"@standard-schema/spec": ["@standard-schema/spec@1.0.0", "", {}, "sha512-m2bOd0f2RT9k8QJx1JN85cZYyH1RqFBdlwtkSlf4tBDYLCiiZnv1fIIwacK6cqwXavOydf0NPToMQgpKq+dVlA=="],
|
|
||||||
|
|
||||||
"@types/bun": ["@types/bun@1.2.23", "", { "dependencies": { "bun-types": "1.2.23" } }, "sha512-le8ueOY5b6VKYf19xT3McVbXqLqmxzPXHsQT/q9JHgikJ2X22wyTW3g3ohz2ZMnp7dod6aduIiq8A14Xyimm0A=="],
|
|
||||||
|
|
||||||
"@types/node": ["@types/node@24.7.1", "", { "dependencies": { "undici-types": "~7.14.0" } }, "sha512-CmyhGZanP88uuC5GpWU9q+fI61j2SkhO3UGMUdfYRE6Bcy0ccyzn1Rqj9YAB/ZY4kOXmNf0ocah5GtphmLMP6Q=="],
|
|
||||||
|
|
||||||
"@types/react": ["@types/react@19.2.2", "", { "dependencies": { "csstype": "^3.0.2" } }, "sha512-6mDvHUFSjyT2B2yeNx2nUgMxh9LtOWvkhIU3uePn2I2oyNymUAX1NIsdgviM4CH+JSrp2D2hsMvJOkxY+0wNRA=="],
|
|
||||||
|
|
||||||
"bcryptjs": ["bcryptjs@3.0.2", "", { "bin": { "bcrypt": "bin/bcrypt" } }, "sha512-k38b3XOZKv60C4E2hVsXTolJWfkGRMbILBIe2IBITXciy5bOsTKot5kDrf3ZfufQtQOUN5mXceUEpU1rTl9Uog=="],
|
|
||||||
|
|
||||||
"bun-types": ["bun-types@1.2.23", "", { "dependencies": { "@types/node": "*" }, "peerDependencies": { "@types/react": "^19" } }, "sha512-R9f0hKAZXgFU3mlrA0YpE/fiDvwV0FT9rORApt2aQVWSuJDzZOyB5QLc0N/4HF57CS8IXJ6+L5E4W1bW6NS2Aw=="],
|
|
||||||
|
|
||||||
"c12": ["c12@3.1.0", "", { "dependencies": { "chokidar": "^4.0.3", "confbox": "^0.2.2", "defu": "^6.1.4", "dotenv": "^16.6.1", "exsolve": "^1.0.7", "giget": "^2.0.0", "jiti": "^2.4.2", "ohash": "^2.0.11", "pathe": "^2.0.3", "perfect-debounce": "^1.0.0", "pkg-types": "^2.2.0", "rc9": "^2.1.2" }, "peerDependencies": { "magicast": "^0.3.5" }, "optionalPeers": ["magicast"] }, "sha512-uWoS8OU1MEIsOv8p/5a82c3H31LsWVR5qiyXVfBNOzfffjUWtPnhAb4BYI2uG2HfGmZmFjCtui5XNWaps+iFuw=="],
|
|
||||||
|
|
||||||
"chokidar": ["chokidar@4.0.3", "", { "dependencies": { "readdirp": "^4.0.1" } }, "sha512-Qgzu8kfBvo+cA4962jnP1KkS6Dop5NS6g7R5LFYJr4b8Ub94PPQXUksCw9PvXoeXPRRddRNC5C1JQUR2SMGtnA=="],
|
|
||||||
|
|
||||||
"citty": ["citty@0.1.6", "", { "dependencies": { "consola": "^3.2.3" } }, "sha512-tskPPKEs8D2KPafUypv2gxwJP8h/OaJmC82QQGGDQcHvXX43xF2VDACcJVmZ0EuSxkpO9Kc4MlrA3q0+FG58AQ=="],
|
|
||||||
|
|
||||||
"confbox": ["confbox@0.2.2", "", {}, "sha512-1NB+BKqhtNipMsov4xI/NnhCKp9XG9NamYp5PVm9klAT0fsrNPjaFICsCFhNhwZJKNh7zB/3q8qXz0E9oaMNtQ=="],
|
|
||||||
|
|
||||||
"consola": ["consola@3.4.2", "", {}, "sha512-5IKcdX0nnYavi6G7TtOhwkYzyjfJlatbjMjuLSfE2kYT5pMDOilZ4OvMhi637CcDICTmz3wARPoyhqyX1Y+XvA=="],
|
|
||||||
|
|
||||||
"csstype": ["csstype@3.1.3", "", {}, "sha512-M1uQkMl8rQK/szD0LNhtqxIPLpimGm8sOBwU7lLnCpSbTyY3yeU1Vc7l4KT5zT4s/yOxHH5O7tIuuLOCnLADRw=="],
|
|
||||||
|
|
||||||
"deepmerge-ts": ["deepmerge-ts@7.1.5", "", {}, "sha512-HOJkrhaYsweh+W+e74Yn7YStZOilkoPb6fycpwNLKzSPtruFs48nYis0zy5yJz1+ktUhHxoRDJ27RQAWLIJVJw=="],
|
|
||||||
|
|
||||||
"defu": ["defu@6.1.4", "", {}, "sha512-mEQCMmwJu317oSz8CwdIOdwf3xMif1ttiM8LTufzc3g6kR+9Pe236twL8j3IYT1F7GfRgGcW6MWxzZjLIkuHIg=="],
|
|
||||||
|
|
||||||
"destr": ["destr@2.0.5", "", {}, "sha512-ugFTXCtDZunbzasqBxrK93Ik/DRYsO6S/fedkWEMKqt04xZ4csmnmwGDBAb07QWNaGMAmnTIemsYZCksjATwsA=="],
|
|
||||||
|
|
||||||
"dotenv": ["dotenv@16.6.1", "", {}, "sha512-uBq4egWHTcTt33a72vpSG0z3HnPuIl6NqYcTrKEg2azoEyl2hpW0zqlxysq2pK9HlDIHyHyakeYaYnSAwd8bow=="],
|
|
||||||
|
|
||||||
"effect": ["effect@3.16.12", "", { "dependencies": { "@standard-schema/spec": "^1.0.0", "fast-check": "^3.23.1" } }, "sha512-N39iBk0K71F9nb442TLbTkjl24FLUzuvx2i1I2RsEAQsdAdUTuUoW0vlfUXgkMTUOnYqKnWcFfqw4hK4Pw27hg=="],
|
|
||||||
|
|
||||||
"empathic": ["empathic@2.0.0", "", {}, "sha512-i6UzDscO/XfAcNYD75CfICkmfLedpyPDdozrLMmQc5ORaQcdMoc21OnlEylMIqI7U8eniKrPMxxtj8k0vhmJhA=="],
|
|
||||||
|
|
||||||
"exsolve": ["exsolve@1.0.7", "", {}, "sha512-VO5fQUzZtI6C+vx4w/4BWJpg3s/5l+6pRQEHzFRM8WFi4XffSP1Z+4qi7GbjWbvRQEbdIco5mIMq+zX4rPuLrw=="],
|
|
||||||
|
|
||||||
"fast-check": ["fast-check@3.23.2", "", { "dependencies": { "pure-rand": "^6.1.0" } }, "sha512-h5+1OzzfCC3Ef7VbtKdcv7zsstUQwUDlYpUTvjeUsJAssPgLn7QzbboPtL5ro04Mq0rPOsMzl7q5hIbRs2wD1A=="],
|
|
||||||
|
|
||||||
"giget": ["giget@2.0.0", "", { "dependencies": { "citty": "^0.1.6", "consola": "^3.4.0", "defu": "^6.1.4", "node-fetch-native": "^1.6.6", "nypm": "^0.6.0", "pathe": "^2.0.3" }, "bin": { "giget": "dist/cli.mjs" } }, "sha512-L5bGsVkxJbJgdnwyuheIunkGatUF/zssUoxxjACCseZYAVbaqdh9Tsmmlkl8vYan09H7sbvKt4pS8GqKLBrEzA=="],
|
|
||||||
|
|
||||||
"hono": ["hono@4.9.10", "", {}, "sha512-AlI15ijFyKTXR7eHo7QK7OR4RoKIedZvBuRjO8iy4zrxvlY5oFCdiRG/V/lFJHCNXJ0k72ATgnyzx8Yqa5arug=="],
|
|
||||||
|
|
||||||
"jiti": ["jiti@2.6.1", "", { "bin": { "jiti": "lib/jiti-cli.mjs" } }, "sha512-ekilCSN1jwRvIbgeg/57YFh8qQDNbwDb9xT/qu2DAHbFFZUicIl4ygVaAvzveMhMVr3LnpSKTNnwt8PoOfmKhQ=="],
|
|
||||||
|
|
||||||
"node-fetch-native": ["node-fetch-native@1.6.7", "", {}, "sha512-g9yhqoedzIUm0nTnTqAQvueMPVOuIY16bqgAJJC8XOOubYFNwz6IER9qs0Gq2Xd0+CecCKFjtdDTMA4u4xG06Q=="],
|
|
||||||
|
|
||||||
"nypm": ["nypm@0.6.2", "", { "dependencies": { "citty": "^0.1.6", "consola": "^3.4.2", "pathe": "^2.0.3", "pkg-types": "^2.3.0", "tinyexec": "^1.0.1" }, "bin": { "nypm": "dist/cli.mjs" } }, "sha512-7eM+hpOtrKrBDCh7Ypu2lJ9Z7PNZBdi/8AT3AX8xoCj43BBVHD0hPSTEvMtkMpfs8FCqBGhxB+uToIQimA111g=="],
|
|
||||||
|
|
||||||
"ohash": ["ohash@2.0.11", "", {}, "sha512-RdR9FQrFwNBNXAr4GixM8YaRZRJ5PUWbKYbE5eOsrwAjJW0q2REGcf79oYPsLyskQCZG1PLN+S/K1V00joZAoQ=="],
|
|
||||||
|
|
||||||
"pathe": ["pathe@2.0.3", "", {}, "sha512-WUjGcAqP1gQacoQe+OBJsFA7Ld4DyXuUIjZ5cc75cLHvJ7dtNsTugphxIADwspS+AraAUePCKrSVtPLFj/F88w=="],
|
|
||||||
|
|
||||||
"perfect-debounce": ["perfect-debounce@1.0.0", "", {}, "sha512-xCy9V055GLEqoFaHoC1SoLIaLmWctgCUaBaWxDZ7/Zx4CTyX7cJQLJOok/orfjZAh9kEYpjJa4d0KcJmCbctZA=="],
|
|
||||||
|
|
||||||
"pkg-types": ["pkg-types@2.3.0", "", { "dependencies": { "confbox": "^0.2.2", "exsolve": "^1.0.7", "pathe": "^2.0.3" } }, "sha512-SIqCzDRg0s9npO5XQ3tNZioRY1uK06lA41ynBC1YmFTmnY6FjUjVt6s4LoADmwoig1qqD0oK8h1p/8mlMx8Oig=="],
|
|
||||||
|
|
||||||
"prisma": ["prisma@6.17.0", "", { "dependencies": { "@prisma/config": "6.17.0", "@prisma/engines": "6.17.0" }, "peerDependencies": { "typescript": ">=5.1.0" }, "optionalPeers": ["typescript"], "bin": { "prisma": "build/index.js" } }, "sha512-rcvldz98r+2bVCs0MldQCBaaVJRCj9Ew4IqphLATF89OJcSzwRQpwnKXR+W2+2VjK7/o2x3ffu5+2N3Muu6Dbw=="],
|
|
||||||
|
|
||||||
"pure-rand": ["pure-rand@6.1.0", "", {}, "sha512-bVWawvoZoBYpp6yIoQtQXHZjmz35RSVHnUOTefl8Vcjr8snTPY1wnpSPMWekcFwbxI6gtmT7rSYPFvz71ldiOA=="],
|
|
||||||
|
|
||||||
"rc9": ["rc9@2.1.2", "", { "dependencies": { "defu": "^6.1.4", "destr": "^2.0.3" } }, "sha512-btXCnMmRIBINM2LDZoEmOogIZU7Qe7zn4BpomSKZ/ykbLObuBdvG+mFq11DL6fjH1DRwHhrlgtYWG96bJiC7Cg=="],
|
|
||||||
|
|
||||||
"readdirp": ["readdirp@4.1.2", "", {}, "sha512-GDhwkLfywWL2s6vEjyhri+eXmfH6j1L7JE27WhqLeYzoh/A3DBaYGEj2H/HFZCn/kMfim73FXxEJTw06WtxQwg=="],
|
|
||||||
|
|
||||||
"tinyexec": ["tinyexec@1.0.1", "", {}, "sha512-5uC6DDlmeqiOwCPmK9jMSdOuZTh8bU39Ys6yidB+UTt5hfZUPGAypSgFRiEp+jbi9qH40BLDvy85jIU88wKSqw=="],
|
|
||||||
|
|
||||||
"turbo": ["turbo@2.5.8", "", { "optionalDependencies": { "turbo-darwin-64": "2.5.8", "turbo-darwin-arm64": "2.5.8", "turbo-linux-64": "2.5.8", "turbo-linux-arm64": "2.5.8", "turbo-windows-64": "2.5.8", "turbo-windows-arm64": "2.5.8" }, "bin": { "turbo": "bin/turbo" } }, "sha512-5c9Fdsr9qfpT3hA0EyYSFRZj1dVVsb6KIWubA9JBYZ/9ZEAijgUEae0BBR/Xl/wekt4w65/lYLTFaP3JmwSO8w=="],
|
|
||||||
|
|
||||||
"turbo-darwin-64": ["turbo-darwin-64@2.5.8", "", { "os": "darwin", "cpu": "x64" }, "sha512-Dh5bCACiHO8rUXZLpKw+m3FiHtAp2CkanSyJre+SInEvEr5kIxjGvCK/8MFX8SFRjQuhjtvpIvYYZJB4AGCxNQ=="],
|
|
||||||
|
|
||||||
"turbo-darwin-arm64": ["turbo-darwin-arm64@2.5.8", "", { "os": "darwin", "cpu": "arm64" }, "sha512-f1H/tQC9px7+hmXn6Kx/w8Jd/FneIUnvLlcI/7RGHunxfOkKJKvsoiNzySkoHQ8uq1pJnhJ0xNGTlYM48ZaJOQ=="],
|
|
||||||
|
|
||||||
"turbo-linux-64": ["turbo-linux-64@2.5.8", "", { "os": "linux", "cpu": "x64" }, "sha512-hMyvc7w7yadBlZBGl/bnR6O+dJTx3XkTeyTTH4zEjERO6ChEs0SrN8jTFj1lueNXKIHh1SnALmy6VctKMGnWfw=="],
|
|
||||||
|
|
||||||
"turbo-linux-arm64": ["turbo-linux-arm64@2.5.8", "", { "os": "linux", "cpu": "arm64" }, "sha512-LQELGa7bAqV2f+3rTMRPnj5G/OHAe2U+0N9BwsZvfMvHSUbsQ3bBMWdSQaYNicok7wOZcHjz2TkESn1hYK6xIQ=="],
|
|
||||||
|
|
||||||
"turbo-windows-64": ["turbo-windows-64@2.5.8", "", { "os": "win32", "cpu": "x64" }, "sha512-3YdcaW34TrN1AWwqgYL9gUqmZsMT4T7g8Y5Azz+uwwEJW+4sgcJkIi9pYFyU4ZBSjBvkfuPZkGgfStir5BBDJQ=="],
|
|
||||||
|
|
||||||
"turbo-windows-arm64": ["turbo-windows-arm64@2.5.8", "", { "os": "win32", "cpu": "arm64" }, "sha512-eFC5XzLmgXJfnAK3UMTmVECCwuBcORrWdewoiXBnUm934DY6QN8YowC/srhNnROMpaKaqNeRpoB5FxCww3eteQ=="],
|
|
||||||
|
|
||||||
"typescript": ["typescript@5.9.2", "", { "bin": { "tsc": "bin/tsc", "tsserver": "bin/tsserver" } }, "sha512-CWBzXQrc/qOkhidw1OzBTQuYRbfyxDXJMVJ1XNwUHGROVmuaeiEm3OslpZ1RV96d7SKKjZKrSJu3+t/xlw3R9A=="],
|
|
||||||
|
|
||||||
"undici-types": ["undici-types@7.14.0", "", {}, "sha512-QQiYxHuyZ9gQUIrmPo3IA+hUl4KYk8uSA7cHrcKd/l3p1OTpZcM0Tbp9x7FAtXdAYhlasd60ncPpgu6ihG6TOA=="],
|
|
||||||
|
|
||||||
"zod": ["zod@4.1.12", "", {}, "sha512-JInaHOamG8pt5+Ey8kGmdcAcg3OL9reK8ltczgHTAwNhMys/6ThXHityHxVV2p3fkw/c+MAvBHFVYHFZDmjMCQ=="],
|
|
||||||
}
|
|
||||||
}
|
|
||||||
30
package.json
30
package.json
@@ -1,30 +0,0 @@
|
|||||||
{
|
|
||||||
"name": "concord",
|
|
||||||
"devDependencies": {
|
|
||||||
"@biomejs/biome": "^2.2.5",
|
|
||||||
"turbo": "^2.5.8",
|
|
||||||
"typescript": "5.9.2"
|
|
||||||
},
|
|
||||||
"engines": {
|
|
||||||
"node": ">=18"
|
|
||||||
},
|
|
||||||
"packageManager": "bun@1.2.23",
|
|
||||||
"private": true,
|
|
||||||
"scripts": {
|
|
||||||
"build": "turbo run build",
|
|
||||||
"dev": "turbo run dev",
|
|
||||||
"check-types": "turbo run check-types",
|
|
||||||
"format-and-lint": "biome check .",
|
|
||||||
"format-and-lint:fix": "biome check . --write",
|
|
||||||
"db:generate": "prisma generate",
|
|
||||||
"db:migrate": "prisma migrate dev --skip-generate",
|
|
||||||
"db:deploy": "prisma migrate deploy",
|
|
||||||
"db:seed": "bun src/seed.ts",
|
|
||||||
"db:push": "prisma db push",
|
|
||||||
"db:studio": "prisma studio"
|
|
||||||
},
|
|
||||||
"workspaces": [
|
|
||||||
"apps/*",
|
|
||||||
"packages/*"
|
|
||||||
]
|
|
||||||
}
|
|
||||||
@@ -1,57 +0,0 @@
|
|||||||
{
|
|
||||||
"$schema": "https://biomejs.dev/schemas/2.2.5/schema.json",
|
|
||||||
"root": false,
|
|
||||||
"vcs": {
|
|
||||||
"enabled": false,
|
|
||||||
"clientKind": "git",
|
|
||||||
"useIgnoreFile": false
|
|
||||||
},
|
|
||||||
"files": {
|
|
||||||
"ignoreUnknown": false,
|
|
||||||
"includes": ["**", "!dist", "!**/generated"]
|
|
||||||
},
|
|
||||||
"formatter": {
|
|
||||||
"enabled": true,
|
|
||||||
"indentStyle": "space",
|
|
||||||
"lineWidth": 100
|
|
||||||
},
|
|
||||||
"linter": {
|
|
||||||
"enabled": true,
|
|
||||||
"rules": {
|
|
||||||
"recommended": true
|
|
||||||
}
|
|
||||||
},
|
|
||||||
"json": {
|
|
||||||
"parser": {
|
|
||||||
"allowTrailingCommas": true,
|
|
||||||
"allowComments": true
|
|
||||||
},
|
|
||||||
"formatter": {
|
|
||||||
"trailingCommas": "none"
|
|
||||||
}
|
|
||||||
},
|
|
||||||
"javascript": {
|
|
||||||
"formatter": {
|
|
||||||
"quoteStyle": "single",
|
|
||||||
"jsxQuoteStyle": "single",
|
|
||||||
"indentStyle": "space",
|
|
||||||
"lineWidth": 100,
|
|
||||||
"operatorLinebreak": "before",
|
|
||||||
"trailingCommas": "es5"
|
|
||||||
},
|
|
||||||
"linter": {
|
|
||||||
"enabled": true
|
|
||||||
}
|
|
||||||
},
|
|
||||||
"css": {
|
|
||||||
"formatter": { "enabled": true, "indentStyle": "space" }
|
|
||||||
},
|
|
||||||
"assist": {
|
|
||||||
"enabled": true,
|
|
||||||
"actions": {
|
|
||||||
"source": {
|
|
||||||
"organizeImports": "on"
|
|
||||||
}
|
|
||||||
}
|
|
||||||
}
|
|
||||||
}
|
|
||||||
@@ -1,5 +0,0 @@
|
|||||||
{
|
|
||||||
"name": "@concord/biome-config",
|
|
||||||
"version": "0.1.0",
|
|
||||||
"private": true
|
|
||||||
}
|
|
||||||
38
packages/database/.gitignore
vendored
38
packages/database/.gitignore
vendored
@@ -1,38 +0,0 @@
|
|||||||
# dependencies (bun install)
|
|
||||||
node_modules
|
|
||||||
|
|
||||||
# output
|
|
||||||
out
|
|
||||||
dist
|
|
||||||
*.tgz
|
|
||||||
|
|
||||||
# code coverage
|
|
||||||
coverage
|
|
||||||
*.lcov
|
|
||||||
|
|
||||||
# logs
|
|
||||||
logs
|
|
||||||
_.log
|
|
||||||
report.[0-9]_.[0-9]_.[0-9]_.[0-9]_.json
|
|
||||||
|
|
||||||
# dotenv environment variable files
|
|
||||||
.env
|
|
||||||
.env.development.local
|
|
||||||
.env.test.local
|
|
||||||
.env.production.local
|
|
||||||
.env.local
|
|
||||||
|
|
||||||
# caches
|
|
||||||
.eslintcache
|
|
||||||
.cache
|
|
||||||
*.tsbuildinfo
|
|
||||||
|
|
||||||
# IntelliJ based IDEs
|
|
||||||
.idea
|
|
||||||
|
|
||||||
# Finder (MacOS) folder config
|
|
||||||
.DS_Store
|
|
||||||
|
|
||||||
# prisma recommended
|
|
||||||
generated
|
|
||||||
|
|
||||||
@@ -1,29 +0,0 @@
|
|||||||
{
|
|
||||||
"name": "@concord/database",
|
|
||||||
"scripts": {
|
|
||||||
"db:migrate": "prisma migrate dev --skip-generate",
|
|
||||||
"db:generate": "prisma generate",
|
|
||||||
"db:push": "prisma db push",
|
|
||||||
"db:seed": "bun src/seed.ts",
|
|
||||||
"db:studio": "prisma studio",
|
|
||||||
"lint": "biome lint .",
|
|
||||||
"format": "biome format --write .",
|
|
||||||
"typecheck": "tsc --noEmit"
|
|
||||||
},
|
|
||||||
"devDependencies": {
|
|
||||||
"@concord/biome-config": "workspace:*",
|
|
||||||
"@concord/tsconfig": "workspace:*",
|
|
||||||
"@types/bun": "latest",
|
|
||||||
"bcryptjs": "^3.0.2",
|
|
||||||
"prisma": "^6.17.0"
|
|
||||||
},
|
|
||||||
"peerDependencies": {
|
|
||||||
"typescript": "^5"
|
|
||||||
},
|
|
||||||
"dependencies": {
|
|
||||||
"@prisma/client": "^6.17.0"
|
|
||||||
},
|
|
||||||
"exports": {
|
|
||||||
".": "./src/client.ts"
|
|
||||||
}
|
|
||||||
}
|
|
||||||
@@ -1,234 +0,0 @@
|
|||||||
datasource db {
|
|
||||||
provider = "postgresql"
|
|
||||||
url = env("DATABASE_URL")
|
|
||||||
}
|
|
||||||
|
|
||||||
generator client {
|
|
||||||
provider = "prisma-client"
|
|
||||||
output = "../generated"
|
|
||||||
}
|
|
||||||
|
|
||||||
// Enums
|
|
||||||
enum UserStatus {
|
|
||||||
online
|
|
||||||
offline
|
|
||||||
invisible
|
|
||||||
dnd
|
|
||||||
idle
|
|
||||||
}
|
|
||||||
|
|
||||||
enum ChannelType {
|
|
||||||
voice
|
|
||||||
text
|
|
||||||
forum
|
|
||||||
}
|
|
||||||
|
|
||||||
// Core
|
|
||||||
model User {
|
|
||||||
id String @id @default(cuid())
|
|
||||||
username String @unique @db.VarChar(32)
|
|
||||||
nickname String? @db.VarChar(64)
|
|
||||||
bio String? @db.VarChar(1024)
|
|
||||||
picture String? @db.VarChar(2048)
|
|
||||||
banner String? @db.VarChar(2048)
|
|
||||||
status UserStatus @default(offline)
|
|
||||||
createdAt DateTime @default(now()) @map("created_at")
|
|
||||||
updatedAt DateTime @default(now()) @map("updated_at")
|
|
||||||
passwordHash String @db.VarChar(255)
|
|
||||||
isOwner Boolean @default(false)
|
|
||||||
isAdmin Boolean @default(false)
|
|
||||||
|
|
||||||
// Relations
|
|
||||||
RoleAssign RoleAssign[]
|
|
||||||
Message Message[]
|
|
||||||
Reaction Reaction[]
|
|
||||||
UserPing UserPing[]
|
|
||||||
Timeout Timeout[]
|
|
||||||
RefreshToken RefreshToken[]
|
|
||||||
}
|
|
||||||
|
|
||||||
model Server {
|
|
||||||
id String @id @default(cuid())
|
|
||||||
name String @unique @db.VarChar(32)
|
|
||||||
description String? @db.VarChar(1024)
|
|
||||||
icon String? @db.VarChar(2048)
|
|
||||||
|
|
||||||
// FKs
|
|
||||||
headCategoryId String? @unique @map("head_category_id")
|
|
||||||
headCategory Category? @relation("ServerHeadCategory", fields: [headCategoryId], references: [id], onUpdate: NoAction, onDelete: SetNull)
|
|
||||||
|
|
||||||
// Relations
|
|
||||||
Category Category[]
|
|
||||||
Channel Channel[]
|
|
||||||
Role Role[]
|
|
||||||
Timeout Timeout[]
|
|
||||||
}
|
|
||||||
|
|
||||||
model Category {
|
|
||||||
id String @id @default(cuid())
|
|
||||||
name String @unique @db.VarChar(64)
|
|
||||||
|
|
||||||
// FKs (Linked-List)
|
|
||||||
nextCategoryId String? @unique @map("next_category_id")
|
|
||||||
nextCategory Category? @relation("CategoryOrder", fields: [nextCategoryId], references: [id], onUpdate: NoAction, onDelete: SetNull)
|
|
||||||
prevCategory Category? @relation("CategoryOrder")
|
|
||||||
|
|
||||||
serverId String @map("server_id")
|
|
||||||
server Server @relation(fields: [serverId], references: [id], onDelete: Cascade)
|
|
||||||
|
|
||||||
headChannelId String? @unique @map("head_channel_id")
|
|
||||||
headChannel Channel? @relation("CategoryHeadChannel", fields: [headChannelId], references: [id], onUpdate: NoAction, onDelete: SetNull)
|
|
||||||
// Relations
|
|
||||||
serverLink Server? @relation("ServerHeadCategory")
|
|
||||||
}
|
|
||||||
|
|
||||||
model Channel {
|
|
||||||
id String @id @default(cuid())
|
|
||||||
name String @unique @db.VarChar(64)
|
|
||||||
description String? @db.VarChar(1024)
|
|
||||||
type ChannelType @default(text)
|
|
||||||
|
|
||||||
// FKs (Linked-List)
|
|
||||||
nextChannelId String? @unique @map("next_channel_id")
|
|
||||||
nextChannel Channel? @relation("ChannelOrder", fields: [nextChannelId], references: [id], onUpdate: NoAction, onDelete: SetNull)
|
|
||||||
prevChannel Channel? @relation("ChannelOrder")
|
|
||||||
|
|
||||||
serverId String @map("server_id")
|
|
||||||
server Server @relation(fields: [serverId], references: [id], onDelete: Cascade)
|
|
||||||
|
|
||||||
// Relations
|
|
||||||
categoryLink Category? @relation("CategoryHeadChannel")
|
|
||||||
Message Message[]
|
|
||||||
ChannelPermissions ChannelPermissions[]
|
|
||||||
}
|
|
||||||
|
|
||||||
model Message {
|
|
||||||
id String @id @default(cuid())
|
|
||||||
text String @db.VarChar(8096)
|
|
||||||
createdAt DateTime @default(now())
|
|
||||||
updatedAt DateTime @default(now())
|
|
||||||
deletedAt DateTime?
|
|
||||||
|
|
||||||
// FKs
|
|
||||||
channelId String @map("channel_id")
|
|
||||||
channel Channel @relation(fields: [channelId], references: [id], onDelete: Cascade)
|
|
||||||
|
|
||||||
userId String @map("user_id")
|
|
||||||
user User @relation(fields: [userId], references: [id], onDelete: Cascade)
|
|
||||||
|
|
||||||
// Replies
|
|
||||||
repliesToId String? @map("replies_to_id")
|
|
||||||
repliesTo Message? @relation("Replies", fields: [repliesToId], references: [id], onUpdate: NoAction, onDelete: SetNull)
|
|
||||||
replies Message[] @relation("Replies")
|
|
||||||
|
|
||||||
// Relations
|
|
||||||
Reaction Reaction[]
|
|
||||||
UserPing UserPing[]
|
|
||||||
RolePing RolePing[]
|
|
||||||
Attachment Attachment[]
|
|
||||||
}
|
|
||||||
|
|
||||||
model Role {
|
|
||||||
id String @id @default(cuid())
|
|
||||||
name String @unique @db.VarChar(64)
|
|
||||||
canModifyRoles Boolean @default(false)
|
|
||||||
canCreateChannels Boolean @default(false)
|
|
||||||
canKickUsers Boolean @default(false)
|
|
||||||
canTimeout Boolean @default(false)
|
|
||||||
|
|
||||||
// FKs
|
|
||||||
serverId String @map("server_id")
|
|
||||||
server Server @relation(fields: [serverId], references: [id], onDelete: Cascade)
|
|
||||||
|
|
||||||
// Relations
|
|
||||||
RoleAssign RoleAssign[]
|
|
||||||
ChannelPermissions ChannelPermissions[]
|
|
||||||
RolePing RolePing[]
|
|
||||||
}
|
|
||||||
|
|
||||||
// Supporting
|
|
||||||
model RoleAssign {
|
|
||||||
// Foreign Keys as composite primary key
|
|
||||||
userId String @map("user_id")
|
|
||||||
roleId String @map("role_id")
|
|
||||||
user User @relation(fields: [userId], references: [id], onDelete: Cascade)
|
|
||||||
role Role @relation(fields: [roleId], references: [id], onDelete: Cascade)
|
|
||||||
|
|
||||||
@@id([userId, roleId])
|
|
||||||
}
|
|
||||||
|
|
||||||
model ChannelPermissions {
|
|
||||||
id String @id @default(cuid())
|
|
||||||
channelId String @map("channel_id")
|
|
||||||
roleId String @map("role_id")
|
|
||||||
channel Channel @relation(fields: [channelId], references: [id], onDelete: Cascade)
|
|
||||||
role Role @relation(fields: [roleId], references: [id], onDelete: Cascade)
|
|
||||||
}
|
|
||||||
|
|
||||||
model Reaction {
|
|
||||||
id String @id @default(cuid())
|
|
||||||
emoji String
|
|
||||||
messageId String @map("message_id")
|
|
||||||
userId String @map("user_id")
|
|
||||||
message Message @relation(fields: [messageId], references: [id], onDelete: Cascade)
|
|
||||||
user User @relation(fields: [userId], references: [id], onDelete: Cascade)
|
|
||||||
|
|
||||||
@@unique([messageId, userId, emoji])
|
|
||||||
}
|
|
||||||
|
|
||||||
model UserPing {
|
|
||||||
// Foreign Keys as composite primary key
|
|
||||||
userId String @map("user_id")
|
|
||||||
messageId String @map("message_id")
|
|
||||||
user User @relation(fields: [userId], references: [id], onDelete: Cascade)
|
|
||||||
message Message @relation(fields: [messageId], references: [id], onDelete: Cascade)
|
|
||||||
|
|
||||||
@@id([userId, messageId])
|
|
||||||
}
|
|
||||||
|
|
||||||
model RolePing {
|
|
||||||
// FKs as composite primary key
|
|
||||||
roleId String @map("role_id")
|
|
||||||
messageId String @map("message_id")
|
|
||||||
role Role @relation(fields: [roleId], references: [id], onDelete: Cascade)
|
|
||||||
message Message @relation(fields: [messageId], references: [id], onDelete: Cascade)
|
|
||||||
|
|
||||||
@@id([roleId, messageId])
|
|
||||||
}
|
|
||||||
|
|
||||||
model Attachment {
|
|
||||||
id String @id @default(cuid())
|
|
||||||
url String @db.VarChar(2000)
|
|
||||||
fileName String @map("file_name") @db.VarChar(255)
|
|
||||||
mimeType String @map("mime_type") @db.VarChar(64)
|
|
||||||
size Int
|
|
||||||
|
|
||||||
// FKs
|
|
||||||
messageId String @map("message_id")
|
|
||||||
message Message @relation(fields: [messageId], references: [id], onDelete: Cascade)
|
|
||||||
}
|
|
||||||
|
|
||||||
model Timeout {
|
|
||||||
timeoutUntil DateTime @map("timeout_until")
|
|
||||||
description String? @db.VarChar(1000)
|
|
||||||
|
|
||||||
// FKs
|
|
||||||
userId String @map("user_id")
|
|
||||||
serverId String @map("server_id")
|
|
||||||
user User @relation(fields: [userId], references: [id], onDelete: Cascade)
|
|
||||||
server Server @relation(fields: [serverId], references: [id], onDelete: Cascade)
|
|
||||||
|
|
||||||
@@id([userId, serverId])
|
|
||||||
}
|
|
||||||
|
|
||||||
model RefreshToken {
|
|
||||||
id String @id @default(cuid())
|
|
||||||
tokenHash String @unique @db.VarChar(255)
|
|
||||||
createdAt DateTime @default(now())
|
|
||||||
expiresAt DateTime
|
|
||||||
device String? @db.VarChar(255)
|
|
||||||
|
|
||||||
// FKs
|
|
||||||
userId String @map("user_id")
|
|
||||||
user User @relation(fields: [userId], references: [id], onDelete: Cascade)
|
|
||||||
}
|
|
||||||
@@ -1,15 +0,0 @@
|
|||||||
import { PrismaClient } from '../generated/client';
|
|
||||||
|
|
||||||
const globalForPrisma = globalThis as unknown as {
|
|
||||||
prisma: PrismaClient | undefined;
|
|
||||||
};
|
|
||||||
|
|
||||||
export const prisma =
|
|
||||||
globalForPrisma.prisma
|
|
||||||
|| new PrismaClient({
|
|
||||||
log: process.env.NODE_ENV === 'development' ? ['query', 'error', 'warn'] : ['error'],
|
|
||||||
});
|
|
||||||
|
|
||||||
if (process.env.NODE_ENV !== 'production') globalForPrisma.prisma = prisma;
|
|
||||||
|
|
||||||
export * from '../generated/client';
|
|
||||||
@@ -1,163 +0,0 @@
|
|||||||
import * as bcrypt from 'bcryptjs';
|
|
||||||
import { PrismaClient } from './client';
|
|
||||||
|
|
||||||
const prisma = new PrismaClient();
|
|
||||||
|
|
||||||
async function main() {
|
|
||||||
console.log('Start seeding...');
|
|
||||||
|
|
||||||
const hashedPassword = await bcrypt.hash('test', 10);
|
|
||||||
console.log('Generated password hash.');
|
|
||||||
|
|
||||||
// Clean up existing data to ensure a fresh start
|
|
||||||
await prisma.roleAssign.deleteMany();
|
|
||||||
await prisma.message.deleteMany();
|
|
||||||
await prisma.channel.deleteMany();
|
|
||||||
await prisma.category.deleteMany();
|
|
||||||
await prisma.role.deleteMany();
|
|
||||||
await prisma.server.deleteMany();
|
|
||||||
await prisma.user.deleteMany();
|
|
||||||
console.log('Cleaned up old data.');
|
|
||||||
|
|
||||||
// Create Users
|
|
||||||
const alice = await prisma.user.create({
|
|
||||||
data: {
|
|
||||||
username: 'Alice',
|
|
||||||
nickname: 'Alice',
|
|
||||||
passwordHash: hashedPassword,
|
|
||||||
isOwner: true,
|
|
||||||
},
|
|
||||||
});
|
|
||||||
const bob = await prisma.user.create({
|
|
||||||
data: {
|
|
||||||
username: 'Bob',
|
|
||||||
nickname: 'Bobby',
|
|
||||||
passwordHash: hashedPassword,
|
|
||||||
isAdmin: true,
|
|
||||||
},
|
|
||||||
});
|
|
||||||
const charlie = await prisma.user.create({
|
|
||||||
data: {
|
|
||||||
username: 'Charlie',
|
|
||||||
passwordHash: hashedPassword,
|
|
||||||
},
|
|
||||||
});
|
|
||||||
console.log(`Created users: ${alice.username}, ${bob.username}, ${charlie.username}`);
|
|
||||||
|
|
||||||
// Create a Server
|
|
||||||
const server = await prisma.server.create({
|
|
||||||
data: {
|
|
||||||
name: 'TS Lovers',
|
|
||||||
description: 'Static Types Win',
|
|
||||||
},
|
|
||||||
});
|
|
||||||
console.log(`Created server: ${server.name}`);
|
|
||||||
|
|
||||||
// Create Roles for the server
|
|
||||||
const adminRole = await prisma.role.create({
|
|
||||||
data: {
|
|
||||||
name: 'Admin',
|
|
||||||
serverId: server.id,
|
|
||||||
canCreateChannels: true,
|
|
||||||
canKickUsers: true,
|
|
||||||
canModifyRoles: true,
|
|
||||||
canTimeout: true,
|
|
||||||
},
|
|
||||||
});
|
|
||||||
const memberRole = await prisma.role.create({
|
|
||||||
data: { name: 'Member', serverId: server.id },
|
|
||||||
});
|
|
||||||
console.log(`Created roles: ${adminRole.name}, ${memberRole.name}`);
|
|
||||||
|
|
||||||
// Assign roles to users
|
|
||||||
await prisma.roleAssign.createMany({
|
|
||||||
data: [
|
|
||||||
{ userId: alice.id, roleId: adminRole.id },
|
|
||||||
{ userId: bob.id, roleId: adminRole.id },
|
|
||||||
{ userId: charlie.id, roleId: memberRole.id },
|
|
||||||
],
|
|
||||||
});
|
|
||||||
console.log('Assigned roles to users.');
|
|
||||||
|
|
||||||
// Create Categories
|
|
||||||
const generalCategory = await prisma.category.create({
|
|
||||||
data: {
|
|
||||||
name: 'General',
|
|
||||||
serverId: server.id,
|
|
||||||
},
|
|
||||||
});
|
|
||||||
const devCategory = await prisma.category.create({
|
|
||||||
data: {
|
|
||||||
name: 'Development',
|
|
||||||
serverId: server.id,
|
|
||||||
},
|
|
||||||
});
|
|
||||||
|
|
||||||
// Set the category order (linked-list) and head category for the server
|
|
||||||
await prisma.server.update({
|
|
||||||
where: { id: server.id },
|
|
||||||
data: { headCategoryId: generalCategory.id },
|
|
||||||
});
|
|
||||||
await prisma.category.update({
|
|
||||||
where: { id: generalCategory.id },
|
|
||||||
data: { nextCategoryId: devCategory.id },
|
|
||||||
});
|
|
||||||
console.log(`Created categories: ${generalCategory.name}, ${devCategory.name}`);
|
|
||||||
|
|
||||||
// Create Channels
|
|
||||||
const welcomeChannel = await prisma.channel.create({
|
|
||||||
data: {
|
|
||||||
name: 'welcome',
|
|
||||||
serverId: server.id,
|
|
||||||
},
|
|
||||||
});
|
|
||||||
const announcementsChannel = await prisma.channel.create({
|
|
||||||
data: {
|
|
||||||
name: 'announcements',
|
|
||||||
serverId: server.id,
|
|
||||||
},
|
|
||||||
});
|
|
||||||
|
|
||||||
// Set channel order for the "General" category
|
|
||||||
await prisma.category.update({
|
|
||||||
where: { id: generalCategory.id },
|
|
||||||
data: { headChannelId: welcomeChannel.id },
|
|
||||||
});
|
|
||||||
await prisma.channel.update({
|
|
||||||
where: { id: welcomeChannel.id },
|
|
||||||
data: { nextChannelId: announcementsChannel.id },
|
|
||||||
});
|
|
||||||
console.log(`Created channels: ${welcomeChannel.name}, ${announcementsChannel.name}`);
|
|
||||||
|
|
||||||
// Create a Message
|
|
||||||
const firstMessage = await prisma.message.create({
|
|
||||||
data: {
|
|
||||||
text: `Welcome to the ${server.name} server, ${bob.username}!`,
|
|
||||||
channelId: welcomeChannel.id,
|
|
||||||
userId: alice.id,
|
|
||||||
},
|
|
||||||
});
|
|
||||||
console.log(`Created a welcome message.`);
|
|
||||||
|
|
||||||
// Create a Reply
|
|
||||||
await prisma.message.create({
|
|
||||||
data: {
|
|
||||||
text: 'Glad to be here!',
|
|
||||||
channelId: welcomeChannel.id,
|
|
||||||
userId: bob.id,
|
|
||||||
repliesToId: firstMessage.id,
|
|
||||||
},
|
|
||||||
});
|
|
||||||
console.log(`Created a reply.`);
|
|
||||||
|
|
||||||
console.log('Seeding finished.');
|
|
||||||
}
|
|
||||||
|
|
||||||
main()
|
|
||||||
.catch((e) => {
|
|
||||||
console.error(e);
|
|
||||||
process.exit(1);
|
|
||||||
})
|
|
||||||
.finally(async () => {
|
|
||||||
await prisma.$disconnect();
|
|
||||||
});
|
|
||||||
@@ -1,5 +0,0 @@
|
|||||||
{
|
|
||||||
"extends": "@concord/tsconfig/base.json",
|
|
||||||
"include": ["."],
|
|
||||||
"exclude": ["generated"]
|
|
||||||
}
|
|
||||||
@@ -1,39 +0,0 @@
|
|||||||
{
|
|
||||||
"$schema": "https://json.schemastore.org/tsconfig",
|
|
||||||
"display": "Default",
|
|
||||||
"compilerOptions": {
|
|
||||||
"target": "ESNext",
|
|
||||||
"module": "ESNext",
|
|
||||||
"moduleDetection": "force",
|
|
||||||
"jsx": "react-jsx",
|
|
||||||
"allowJs": true,
|
|
||||||
|
|
||||||
"moduleResolution": "bundler",
|
|
||||||
"allowImportingTsExtensions": true,
|
|
||||||
"verbatimModuleSyntax": true,
|
|
||||||
"noEmit": true,
|
|
||||||
|
|
||||||
"esModuleInterop": true,
|
|
||||||
"isolatedModules": true,
|
|
||||||
"resolveJsonModule": true,
|
|
||||||
|
|
||||||
"baseUrl": ".",
|
|
||||||
"paths": {
|
|
||||||
"@/*": ["./src/*"]
|
|
||||||
},
|
|
||||||
|
|
||||||
"strict": true,
|
|
||||||
"skipLibCheck": true,
|
|
||||||
"noFallthroughCasesInSwitch": true,
|
|
||||||
"noUncheckedIndexedAccess": true,
|
|
||||||
"noImplicitOverride": true,
|
|
||||||
"noImplicitReturns": true,
|
|
||||||
"inlineSources": false,
|
|
||||||
|
|
||||||
"noUnusedLocals": false,
|
|
||||||
"noUnusedParameters": false,
|
|
||||||
"forceConsistentCasingInFileNames": true,
|
|
||||||
"noPropertyAccessFromIndexSignature": false
|
|
||||||
},
|
|
||||||
"exclude": ["node_modules", "dist"]
|
|
||||||
}
|
|
||||||
@@ -1,5 +0,0 @@
|
|||||||
{
|
|
||||||
"name": "@concord/tsconfig",
|
|
||||||
"version": "0.1.0",
|
|
||||||
"private": true
|
|
||||||
}
|
|
||||||
43
turbo.json
43
turbo.json
@@ -1,43 +0,0 @@
|
|||||||
{
|
|
||||||
"$schema": "https://turborepo.com/schema.json",
|
|
||||||
"ui": "tui",
|
|
||||||
"tasks": {
|
|
||||||
"build": {
|
|
||||||
"dependsOn": ["^build"],
|
|
||||||
"inputs": ["$TURBO_DEFAULT$", ".env*"],
|
|
||||||
"outputs": [".next/**", "!.next/cache/**"],
|
|
||||||
"env": ["DATABASE_URL"]
|
|
||||||
},
|
|
||||||
"//#format-and-lint": {},
|
|
||||||
"//#format-and-lint:fix": {
|
|
||||||
"cache": false
|
|
||||||
},
|
|
||||||
"check-types": {
|
|
||||||
"dependsOn": ["^check-types"]
|
|
||||||
},
|
|
||||||
"dev": {
|
|
||||||
"cache": false,
|
|
||||||
"persistent": true
|
|
||||||
},
|
|
||||||
"db:generate": {
|
|
||||||
"cache": false
|
|
||||||
},
|
|
||||||
"db:migrate": {
|
|
||||||
"cache": false,
|
|
||||||
"persistent": true
|
|
||||||
},
|
|
||||||
"db:deploy": {
|
|
||||||
"cache": false
|
|
||||||
},
|
|
||||||
"db:seed": {
|
|
||||||
"cache": false
|
|
||||||
},
|
|
||||||
"db:push": {
|
|
||||||
"cache": false
|
|
||||||
},
|
|
||||||
"db:studio": {
|
|
||||||
"cache": false,
|
|
||||||
"persistent": true
|
|
||||||
}
|
|
||||||
}
|
|
||||||
}
|
|
||||||
Reference in New Issue
Block a user