Method create

lib/models/expenses.ts:244–311

(
    userId: string,
    cost: number,
    description: string,
    budget: string,
    date: string,
    is_recurring: boolean,
    { skipRecalculation = false, skipBudgetMatching = false, skipBudgetCreation = false }: {
      skipRecalculation?: boolean;
      skipBudgetMatching?: boolean;
      skipBudgetCreation?: boolean;
    } = {},
  )

  }

  static async create(
    userId: string,
    cost: number,
    description: string,
    budget: string,
    date: string,
    is_recurring: boolean,
    { skipRecalculation = false, skipBudgetMatching = false, skipBudgetCreation = false }: {
      skipRecalculation?: boolean;
      skipBudgetMatching?: boolean;
      skipBudgetCreation?: boolean;
    } = {},
  ) {
    const extra: Expense['extra'] = {};

    if (!budget.trim()) {
      budget = 'Misc';
    }

    // Match budget to an existing expense "by default"
    if (!skipBudgetMatching && budget === 'Misc') {
      const existingExpense = await this.getByName(userId, description);

      if (existingExpense) {
        budget = existingExpense.budget;
      }
    }

    if (!skipBudgetCreation) {
      const existingBudgetInMonth = await BudgetModel.getByName(userId, date.substring(0, 7), budget);

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

    const newExpense = (await db.query<Expense>(
      sql`INSERT INTO "bewcloud_expenses" (
        "user_id",
        "cost",
        "description",
        "budget",
        "date",
        "is_recurring",
        "extra"
      ) VALUES ($1, $2, $3, $4, $5, $6, $7)
      RETURNING *`,
      [
        userId,
        cost,
        description,
        budget,
        date,
        is_recurring,
        JSON.stringify(extra),
      ],
    ))[0];