Method update

lib/models/expenses.ts:313–345

(expense: Expense)

  }

  static async update(expense: Expense) {
    const existingBudgetInMonth = await BudgetModel.getByName(
      expense.user_id,
      expense.date.substring(0, 7),
      expense.budget,
    );

    if (!existingBudgetInMonth) {
      await BudgetModel.create(expense.user_id, expense.budget, expense.date.substring(0, 7), 100);
    }

    await db.query(
      sql`UPDATE "bewcloud_expenses" SET
          "cost" = $2,
          "description" = $3,
          "budget" = $4,
          "date" = $5,
          "is_recurring" = $6,
          "extra" = $7
        WHERE "id" = $1`,
      [
        expense.id,
        expense.cost,
        expense.description,
        expense.budget,
        expense.date,
        expense.is_recurring,
        JSON.stringify(expense.extra),
      ],
    );

    await recalculateMonthBudgets(expense.user_id, expense.date.substring(0, 7));
  }

  static async delete(userId: string, id: string) {
    const expense = await this.getById(userId, id);