From 13bf1d14499e9cbb9d99c8bbc350e3cb5a7a4fd2 Mon Sep 17 00:00:00 2001 From: Vidhu Kant Sharma Date: Sun, 13 Apr 2025 18:26:41 +0530 Subject: first commit --- src/service/budget.ts | 20 +++++++++++++ src/service/friend.ts | 72 ++++++++++++++++++++++++++++++++++++++++++++++ src/service/transaction.ts | 48 +++++++++++++++++++++++++++++++ src/service/user.ts | 56 ++++++++++++++++++++++++++++++++++++ 4 files changed, 196 insertions(+) create mode 100644 src/service/budget.ts create mode 100644 src/service/friend.ts create mode 100644 src/service/transaction.ts create mode 100644 src/service/user.ts (limited to 'src/service') 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 + + * 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 . + */ + +// 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 + + * 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 . + */ + +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 + + * 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 . + */ + +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 + + * 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 . + */ + +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 -- cgit v1.2.3