Method create

lib/models/expenses.ts:89–118

(userId: string, name: string, month: string, value: number)

  }

  static async create(userId: string, name: string, month: string, value: number) {
    const extra: Budget['extra'] = {
      usedValue: 0,
      availableValue: value,
    };

    const newBudget = (await db.query<Budget>(
      sql`INSERT INTO "bewcloud_budgets" (
        "user_id",
        "name",
        "month",
        "value",
        "extra"
      ) VALUES ($1, $2, $3, $4, $5)
      RETURNING *`,
      [
        userId,
        name,
        month,
        value,
        JSON.stringify(extra),
      ],
    ))[0];

    // Numeric values come as strings, so we need to convert them to numbers
    return {
      ...newBudget,
      value: Number(newBudget.value),
    };
  }

  static async update(
    budget: Budget,