Skip to content

Commit 539d56d

Browse files
TaskPilot-AITaskPilot-AI
authored
Merge pull request #1 from TaskPilot-AI/mohit
Frontend, Backend, SearxNG migrations
2 parents ee53e54 + 9a95fb3 commit 539d56d

File tree

308 files changed

+74906
-0
lines changed

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

308 files changed

+74906
-0
lines changed

‎.DS_Store‎

10 KB
Binary file not shown.

‎backend/.dockerignore‎

Lines changed: 6 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,6 @@
1+
node_modules
2+
npm-debug.log
3+
dist
4+
.git
5+
.gitignore
6+
.env

‎backend/.gitignore‎

Lines changed: 36 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,36 @@
1+
# dependencies (bun install)
2+
node_modules
3+
4+
# output
5+
out
6+
dist
7+
*.tgz
8+
9+
# code coverage
10+
coverage
11+
*.lcov
12+
13+
# logs
14+
logs
15+
_.log
16+
report.[0-9]_.[0-9]_.[0-9]_.[0-9]_.json
17+
18+
# dotenv environment variable files
19+
.env
20+
.env.development.local
21+
.env.test.local
22+
.env.production.local
23+
.env.local
24+
25+
# caches
26+
.eslintcache
27+
.cache
28+
*.tsbuildinfo
29+
30+
# IntelliJ based IDEs
31+
.idea
32+
33+
# Finder (MacOS) folder config
34+
.DS_Store
35+
36+
/src/generated/prisma

‎backend/Dockerfile‎

Lines changed: 26 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,26 @@
1+
# Alternative Dockerfile for projects without bun.lockb
2+
FROM oven/bun:1 AS base
3+
WORKDIR /usr/src/app
4+
5+
RUN apt-get update -y && apt-get install -y openssl
6+
7+
# Install dependencies
8+
FROM base AS deps
9+
COPY package.json ./
10+
RUN bun install
11+
12+
# Generate Prisma client
13+
FROM deps AS builder
14+
COPY . .
15+
RUN bunx prisma generate
16+
17+
# Production image
18+
FROM base AS runner
19+
COPY --from=deps /usr/src/app/node_modules ./node_modules
20+
COPY . .
21+
22+
# Generate Prisma client in production
23+
RUN bunx prisma generate
24+
25+
# Expose port
26+
EXPOSE 3000

‎backend/README.md‎

Lines changed: 15 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,15 @@
1+
# be1
2+
3+
To install dependencies:
4+
5+
```bash
6+
bun install
7+
```
8+
9+
To run:
10+
11+
```bash
12+
bun run index.ts
13+
```
14+
15+
This project was created using `bun init` in bun v1.2.20. [Bun](https://bun.com) is a fast all-in-one JavaScript runtime.

‎backend/bun.lock‎

Lines changed: 816 additions & 0 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎backend/package.json‎

Lines changed: 48 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,48 @@
1+
{
2+
"name": "backend",
3+
"module": "src/index.ts",
4+
"type": "module",
5+
"private": true,
6+
"scripts": {
7+
"dev": "bun src/index.ts",
8+
"start": "bun src/index.ts",
9+
"build": "bun install --production"
10+
},
11+
"devDependencies": {
12+
"@octokit/tsconfig": "^4.0.0",
13+
"@types/cors": "^2.8.17",
14+
"@types/jsonwebtoken": "^9.0.9",
15+
"@types/morgan": "^1.9.9"
16+
},
17+
"peerDependencies": {
18+
"typescript": "^5"
19+
},
20+
"dependencies": {
21+
"@google/genai": "^0.8.0",
22+
"@langchain/community": "^0.3.40",
23+
"@langchain/core": "^0.3.44",
24+
"@langchain/google-genai": "^0.2.3",
25+
"@prisma/client": "^6.4.1",
26+
"@tavily/core": "^0.3.7",
27+
"@types/cookie-parser": "^1.4.8",
28+
"@types/express": "^5.0.0",
29+
"@types/stripe": "^8.0.416",
30+
"body-parser": "^2.2.0",
31+
"cookie-parser": "^1.4.7",
32+
"cors": "^2.8.5",
33+
"dotenv": "^16.5.0",
34+
"express": "^4.21.2",
35+
"helmet": "^8.0.0",
36+
"jsonwebtoken": "^9.0.2",
37+
"langchain": "^0.3.21",
38+
"morgan": "^1.10.0",
39+
"octokit": "^4.1.2",
40+
"prisma": "^6.4.1",
41+
"raw-body": "^3.0.0",
42+
"razorpay": "^2.9.6",
43+
"resend": "^4.1.2",
44+
"stripe": "^18.0.0",
45+
"typescript": "^5.8.2",
46+
"zod": "^3.24.2"
47+
}
48+
}

‎backend/prisma/migrations/20251003031553_init/migration.sql‎

Lines changed: 202 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,202 @@
1+
-- CreateTable
2+
CREATE TABLE "Admin" (
3+
"id" TEXT NOT NULL,
4+
"name" TEXT NOT NULL,
5+
"email" TEXT NOT NULL,
6+
"password" TEXT NOT NULL DEFAULT '',
7+
"role" TEXT NOT NULL DEFAULT 'admin',
8+
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
9+
"accessToken" TEXT NOT NULL DEFAULT '',
10+
"subscriptionId" TEXT,
11+
"remainingProjectLimit" INTEGER NOT NULL DEFAULT 0,
12+
"remainginEmployeeLimit" INTEGER NOT NULL DEFAULT 0,
13+
"remainingDocumentLimit" INTEGER NOT NULL DEFAULT 0,
14+
"remainingResearchLimit" INTEGER NOT NULL DEFAULT 0,
15+
"dailyResearchLimit" INTEGER NOT NULL DEFAULT 0,
16+
"lastLimitResetDate" TIMESTAMP(3) DEFAULT CURRENT_TIMESTAMP,
17+
18+
CONSTRAINT "Admin_pkey" PRIMARY KEY ("id")
19+
);
20+
21+
-- CreateTable
22+
CREATE TABLE "Project" (
23+
"id" TEXT NOT NULL,
24+
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
25+
"name" TEXT NOT NULL,
26+
"description" TEXT,
27+
"projectType" TEXT NOT NULL,
28+
"complexity" TEXT NOT NULL,
29+
"updatedAt" TIMESTAMP(3) NOT NULL,
30+
"completionStatus" TEXT NOT NULL,
31+
"timeEstimate" INTEGER NOT NULL DEFAULT 0,
32+
"ownerId" TEXT NOT NULL,
33+
34+
CONSTRAINT "Project_pkey" PRIMARY KEY ("id")
35+
);
36+
37+
-- CreateTable
38+
CREATE TABLE "Employee" (
39+
"id" TEXT NOT NULL,
40+
"name" TEXT NOT NULL,
41+
"email" TEXT NOT NULL,
42+
"contact" TEXT,
43+
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
44+
"updatedAt" TIMESTAMP(3) NOT NULL,
45+
"password" TEXT NOT NULL DEFAULT '',
46+
"role" TEXT NOT NULL,
47+
"skills" TEXT[],
48+
"githubUsername" TEXT NOT NULL DEFAULT '',
49+
"status" TEXT NOT NULL,
50+
"department" TEXT NOT NULL DEFAULT '',
51+
"employerId" TEXT NOT NULL,
52+
"location" TEXT,
53+
54+
CONSTRAINT "Employee_pkey" PRIMARY KEY ("id")
55+
);
56+
57+
-- CreateTable
58+
CREATE TABLE "Task" (
59+
"id" TEXT NOT NULL,
60+
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
61+
"updatedAt" TIMESTAMP(3) NOT NULL,
62+
"due" TIMESTAMP(3),
63+
"name" TEXT NOT NULL,
64+
"description" TEXT,
65+
"tag" TEXT,
66+
"status" TEXT NOT NULL,
67+
"priority" TEXT NOT NULL,
68+
"projectId" TEXT NOT NULL,
69+
"ownerId" TEXT NOT NULL DEFAULT '',
70+
71+
CONSTRAINT "Task_pkey" PRIMARY KEY ("id")
72+
);
73+
74+
-- CreateTable
75+
CREATE TABLE "Document" (
76+
"id" TEXT NOT NULL,
77+
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
78+
"updatedAt" TIMESTAMP(3) NOT NULL,
79+
"createdBy" TEXT NOT NULL,
80+
"ownerId" TEXT NOT NULL DEFAULT '',
81+
"name" TEXT NOT NULL DEFAULT '',
82+
"views" INTEGER NOT NULL DEFAULT 0,
83+
"description" TEXT,
84+
"status" TEXT NOT NULL,
85+
"body" TEXT,
86+
"docBody" JSONB,
87+
"docDesc" TEXT,
88+
"docName" TEXT,
89+
"erDiagram" TEXT,
90+
"useCaseDiagram" TEXT,
91+
"projectId" TEXT NOT NULL,
92+
93+
CONSTRAINT "Document_pkey" PRIMARY KEY ("id")
94+
);
95+
96+
-- CreateTable
97+
CREATE TABLE "Comment" (
98+
"id" TEXT NOT NULL,
99+
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
100+
"updatedAt" TIMESTAMP(3) NOT NULL,
101+
"text" TEXT NOT NULL,
102+
"commentorId" TEXT NOT NULL,
103+
"taskId" TEXT NOT NULL,
104+
"projectId" TEXT NOT NULL,
105+
106+
CONSTRAINT "Comment_pkey" PRIMARY KEY ("id")
107+
);
108+
109+
-- CreateTable
110+
CREATE TABLE "Subscription" (
111+
"id" TEXT NOT NULL,
112+
"adminId" TEXT NOT NULL,
113+
"planId" TEXT NOT NULL,
114+
"status" TEXT NOT NULL,
115+
"startDate" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
116+
"endDate" TIMESTAMP(3) NOT NULL,
117+
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
118+
"updatedAt" TIMESTAMP(3) NOT NULL,
119+
"razorpayOrderId" TEXT,
120+
"razorpayPaymentId" TEXT,
121+
122+
CONSTRAINT "Subscription_pkey" PRIMARY KEY ("id")
123+
);
124+
125+
-- CreateTable
126+
CREATE TABLE "Recordings" (
127+
"id" TEXT NOT NULL,
128+
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
129+
"updatedAt" TIMESTAMP(3) NOT NULL,
130+
"startTime" TIMESTAMP(3) NOT NULL,
131+
"endTime" TIMESTAMP(3) NOT NULL,
132+
"url" TEXT NOT NULL,
133+
"callId" TEXT NOT NULL,
134+
"sessionId" TEXT NOT NULL,
135+
"fileName" TEXT NOT NULL,
136+
137+
CONSTRAINT "Recordings_pkey" PRIMARY KEY ("id")
138+
);
139+
140+
-- CreateTable
141+
CREATE TABLE "_EmployeesProjects" (
142+
"A" TEXT NOT NULL,
143+
"B" TEXT NOT NULL,
144+
145+
CONSTRAINT "_EmployeesProjects_AB_pkey" PRIMARY KEY ("A","B")
146+
);
147+
148+
-- CreateTable
149+
CREATE TABLE "_TaskAssignees" (
150+
"A" TEXT NOT NULL,
151+
"B" TEXT NOT NULL,
152+
153+
CONSTRAINT "_TaskAssignees_AB_pkey" PRIMARY KEY ("A","B")
154+
);
155+
156+
-- CreateIndex
157+
CREATE UNIQUE INDEX "Admin_email_key" ON "Admin"("email");
158+
159+
-- CreateIndex
160+
CREATE UNIQUE INDEX "Admin_subscriptionId_key" ON "Admin"("subscriptionId");
161+
162+
-- CreateIndex
163+
CREATE UNIQUE INDEX "Subscription_adminId_key" ON "Subscription"("adminId");
164+
165+
-- CreateIndex
166+
CREATE INDEX "_EmployeesProjects_B_index" ON "_EmployeesProjects"("B");
167+
168+
-- CreateIndex
169+
CREATE INDEX "_TaskAssignees_B_index" ON "_TaskAssignees"("B");
170+
171+
-- AddForeignKey
172+
ALTER TABLE "Project" ADD CONSTRAINT "Project_ownerId_fkey" FOREIGN KEY ("ownerId") REFERENCES "Admin"("id") ON DELETE RESTRICT ON UPDATE CASCADE;
173+
174+
-- AddForeignKey
175+
ALTER TABLE "Task" ADD CONSTRAINT "Task_projectId_fkey" FOREIGN KEY ("projectId") REFERENCES "Project"("id") ON DELETE RESTRICT ON UPDATE CASCADE;
176+
177+
-- AddForeignKey
178+
ALTER TABLE "Document" ADD CONSTRAINT "Document_projectId_fkey" FOREIGN KEY ("projectId") REFERENCES "Project"("id") ON DELETE RESTRICT ON UPDATE CASCADE;
179+
180+
-- AddForeignKey
181+
ALTER TABLE "Comment" ADD CONSTRAINT "Comment_commentorId_fkey" FOREIGN KEY ("commentorId") REFERENCES "Employee"("id") ON DELETE RESTRICT ON UPDATE CASCADE;
182+
183+
-- AddForeignKey
184+
ALTER TABLE "Comment" ADD CONSTRAINT "Comment_taskId_fkey" FOREIGN KEY ("taskId") REFERENCES "Task"("id") ON DELETE RESTRICT ON UPDATE CASCADE;
185+
186+
-- AddForeignKey
187+
ALTER TABLE "Comment" ADD CONSTRAINT "Comment_projectId_fkey" FOREIGN KEY ("projectId") REFERENCES "Project"("id") ON DELETE RESTRICT ON UPDATE CASCADE;
188+
189+
-- AddForeignKey
190+
ALTER TABLE "Subscription" ADD CONSTRAINT "Subscription_adminId_fkey" FOREIGN KEY ("adminId") REFERENCES "Admin"("id") ON DELETE RESTRICT ON UPDATE CASCADE;
191+
192+
-- AddForeignKey
193+
ALTER TABLE "_EmployeesProjects" ADD CONSTRAINT "_EmployeesProjects_A_fkey" FOREIGN KEY ("A") REFERENCES "Employee"("id") ON DELETE CASCADE ON UPDATE CASCADE;
194+
195+
-- AddForeignKey
196+
ALTER TABLE "_EmployeesProjects" ADD CONSTRAINT "_EmployeesProjects_B_fkey" FOREIGN KEY ("B") REFERENCES "Project"("id") ON DELETE CASCADE ON UPDATE CASCADE;
197+
198+
-- AddForeignKey
199+
ALTER TABLE "_TaskAssignees" ADD CONSTRAINT "_TaskAssignees_A_fkey" FOREIGN KEY ("A") REFERENCES "Employee"("id") ON DELETE CASCADE ON UPDATE CASCADE;
200+
201+
-- AddForeignKey
202+
ALTER TABLE "_TaskAssignees" ADD CONSTRAINT "_TaskAssignees_B_fkey" FOREIGN KEY ("B") REFERENCES "Task"("id") ON DELETE CASCADE ON UPDATE CASCADE;

‎backend/prisma/migrations/migration_lock.toml‎

Lines changed: 3 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,3 @@
1+
# Please do not edit this file manually
2+
# It should be added in your version-control system (e.g., Git)
3+
provider = "postgresql"

0 commit comments

Comments
 (0)