4 files changed, 196 insertions, 0 deletions
diff --git a/src/service/budget.ts b/src/service/budget.ts
new file mode 100644
index 0000000..2790b62
--- /dev/null
+++ b/src/service/budget.ts
@@ -0,0 +1,20 @@
+/* Financer - Pocket Money Tracker
+ * Copyright (C) 2025  Vidhu Kant Sharma <vidhukant@vidhukant.com>
+
+ * This program is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ * GNU General Public License for more details.
+
+ * You should have received a copy of the GNU General Public License
+ * along with this program.  If not, see <https://www.gnu.org/licenses/>.
+ */
+
+// import prisma from "../util/prisma";
+//import {  } from "@prisma/client";
+
diff --git a/src/service/friend.ts b/src/service/friend.ts
new file mode 100644
index 0000000..c7f4b6b
--- /dev/null
+++ b/src/service/friend.ts
@@ -0,0 +1,72 @@
+/* Financer - Pocket Money Tracker
+ * Copyright (C) 2025  Vidhu Kant Sharma <vidhukant@vidhukant.com>
+
+ * This program is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ * GNU General Public License for more details.
+
+ * You should have received a copy of the GNU General Public License
+ * along with this program.  If not, see <https://www.gnu.org/licenses/>.
+ */
+
+import prisma from "../util/prisma";
+
+const friend = async (userId: Number, friendId: Number) => {
+    // will return error P2002 if already friends
+    return prisma.friend.createMany({
+        data: [
+            // @ts-ignore
+            { userId: userId, friendId: friendId },
+
+            // @ts-ignore
+            { userId: friendId, friendId: userId }
+        ]
+    })
+}
+
+const unfriend = async (userId: Number, friendId: Number) => {
+    return prisma.friend.deleteMany({
+        where: {
+            OR: [
+                // @ts-ignore
+                { userId: userId },
+
+                // @ts-ignore
+                { userId: friendId },
+            ]
+        }
+    })
+}
+
+const list = async (userId: Number) => {
+    const friendsRaw = await prisma.friend.findMany({
+        // @ts-ignore
+        where: { userId: userId },
+        include: { friend: true }
+    })
+
+    // TODO: check if no friends
+
+    // @ts-ignore
+    return friendsRaw.map((x: any) => {
+        const friend = x.friend;
+        delete friend["password"];
+        delete friend["refreshTokenVersion"];
+        delete friend["createdAt"];
+        delete friend["updatedAt"];
+
+        return friend;
+    })
+}
+
+export {
+    friend,
+    unfriend,
+    list
+}
+\ No newline at end of file
diff --git a/src/service/transaction.ts b/src/service/transaction.ts
new file mode 100644
index 0000000..29a9faa
--- /dev/null
+++ b/src/service/transaction.ts
@@ -0,0 +1,48 @@
+/* Financer - Pocket Money Tracker
+ * Copyright (C) 2025  Vidhu Kant Sharma <vidhukant@vidhukant.com>
+
+ * This program is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ * GNU General Public License for more details.
+
+ * You should have received a copy of the GNU General Public License
+ * along with this program.  If not, see <https://www.gnu.org/licenses/>.
+ */
+
+import prisma from "../util/prisma";
+import { Transaction, TransactionType } from "@prisma/client";
+
+const create = async (transaction: Transaction) => {
+    // TODO: validate
+    return prisma.transaction.create({
+        data: {
+            ...transaction,
+        }
+    })
+}
+
+const read = async (userId: Number, type: String) => {
+    const hasFilter = [
+        TransactionType.LENT,
+        TransactionType.BORROWED,
+        TransactionType.SPENT,
+        TransactionType.RECEIVED
+    ].includes(type as TransactionType)
+    const filter = hasFilter ? { type: type } : {}
+
+    return prisma.transaction.findMany({
+        // @ts-ignore
+        where: { userId: userId, ...filter }
+    })
+}
+
+export {
+    create,
+    read
+}
diff --git a/src/service/user.ts b/src/service/user.ts
new file mode 100644
index 0000000..712e6f4
--- /dev/null
+++ b/src/service/user.ts
@@ -0,0 +1,56 @@
+/* Financer - Pocket Money Tracker
+ * Copyright (C) 2025  Vidhu Kant Sharma <vidhukant@vidhukant.com>
+
+ * This program is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ * GNU General Public License for more details.
+
+ * You should have received a copy of the GNU General Public License
+ * along with this program.  If not, see <https://www.gnu.org/licenses/>.
+ */
+
+import prisma from "../util/prisma";
+import {User} from "@prisma/client";
+
+const create = async (user: User) => {
+    // TODO: validate
+    return prisma.user.create({
+        data: {
+            ...user,
+        }
+    })
+}
+
+const readById = async (id: Number) => {
+    return prisma.user.findUnique({
+        // @ts-ignore
+        where: { id: id }
+    })
+}
+
+const readByEmail = async (email: String) => {
+    return prisma.user.findUniqueOrThrow({
+        // @ts-ignore
+        where: { email: email }
+    })
+}
+
+const readByUsername = async (username: String) => {
+    return prisma.user.findUnique({
+        // @ts-ignore
+        where: { userName: username }
+    })
+}
+
+export {
+    create,
+    readById,
+    readByEmail,
+    readByUsername,
+};
+\ No newline at end of file