Merge 4af6d34507 into b880670929

.github/workflows/build-image.yaml

@@ -1,105 +0,0 @@
-name: Build and Push Image
-
-on:
-  workflow_call:
-    inputs:
-      mode:
-        description: "Build mode: 'prod' or 'pr'"
-        required: true
-        type: string
-      image_repo:
-        description: "Docker image repository (e.g., user/app)"
-        required: false
-        default: "lukastrkan/cc-app-demo"
-        type: string
-      context:
-        description: "Docker build context path"
-        required: false
-        default: "7project/backend"
-        type: string
-      pr_number:
-        description: "PR number (required when mode=pr)"
-        required: false
-        type: string
-    secrets:
-      DOCKER_USER:
-        required: true
-      DOCKER_PASSWORD:
-        required: true
-    outputs:
-      digest:
-        description: "Built image digest"
-        value: ${{ jobs.build.outputs.digest }}
-      image_repo:
-        description: "Image repository used"
-        value: ${{ jobs.build.outputs.image_repo }}
-
-jobs:
-  build:
-    runs-on: ubuntu-latest
-    outputs:
-      digest: ${{ steps.set.outputs.digest }}
-      image_repo: ${{ steps.set.outputs.image_repo }}
-    steps:
-      - name: Checkout
-        uses: actions/checkout@v4
-
-      - name: Set up QEMU
-        uses: docker/setup-qemu-action@v3
-
-      - name: Set up Docker Buildx
-        id: buildx
-        uses: docker/setup-buildx-action@v3
-
-      - name: Log in to Docker Hub
-        uses: docker/login-action@v3
-        with:
-          username: ${{ secrets.DOCKER_USER }}
-          password: ${{ secrets.DOCKER_PASSWORD }}
-
-      - name: Compute image repo and tags
-        id: meta
-        env:
-          MODE: ${{ inputs.mode }}
-          IMAGE_REPO: ${{ inputs.image_repo }}
-          PR: ${{ inputs.pr_number }}
-        run: |
-          set -euo pipefail
-          if [ -z "${IMAGE_REPO:-}" ]; then IMAGE_REPO="lukastrkan/cc-app-demo"; fi
-          echo "IMAGE_REPO=$IMAGE_REPO" >> $GITHUB_ENV
-          SHA_SHORT="${GITHUB_SHA::12}"
-          case "$MODE" in
-            prod)
-              TAG1="prod-$SHA_SHORT"
-              TAG2="latest"
-              ;;
-            pr)
-              if [ -z "${PR:-}" ]; then echo "pr_number input is required for mode=pr"; exit 1; fi
-              TAG1="pr-$PR"
-              TAG2="pr-$PR-$SHA_SHORT"
-              ;;
-            *)
-              echo "Unknown mode '$MODE' (expected 'prod' or 'pr')"; exit 1;
-              ;;
-          esac
-          echo "TAG1=$TAG1" >> $GITHUB_ENV
-          echo "TAG2=$TAG2" >> $GITHUB_ENV
-
-      - name: Build and push image
-        id: build
-        uses: docker/build-push-action@v5
-        with:
-          context: ${{ inputs.context }}
-          push: true
-          tags: |
-            ${{ env.IMAGE_REPO }}:${{ env.TAG1 }}
-            ${{ env.IMAGE_REPO }}:${{ env.TAG2 }}
-          platforms: linux/amd64
-
-      - name: Set outputs
-        id: set
-        env:
-          IMAGE_REPO: ${{ env.IMAGE_REPO }}
-        run: |
-          echo "digest=${{ steps.build.outputs.digest }}" >> $GITHUB_OUTPUT
-          echo "image_repo=$IMAGE_REPO" >> $GITHUB_OUTPUT

.github/workflows/deploy-pr.yaml

@@ -1,151 +0,0 @@
-name: Deploy Preview (PR)
-
-on:
-  pull_request:
-    types: [opened, reopened, synchronize, closed]
-
-permissions:
-  contents: read
-  pull-requests: write
-
-jobs:
-  build:
-    if: github.event.action != 'closed'
-    name: Build and push image (reusable)
-    uses: ./.github/workflows/build-image.yaml
-    with:
-      mode: pr
-      image_repo: lukastrkan/cc-app-demo
-      context: 7project/backend
-      pr_number: ${{ github.event.pull_request.number }}
-    secrets: inherit
-
-  get_urls:
-    if: github.event.action != 'closed'
-    name: Generate Preview URLs
-    uses: ./.github/workflows/url_generator.yml
-    with:
-      runner: vhs
-      mode: pr
-      pr_number: ${{ github.event.pull_request.number }}
-      base_domain: ${{ vars.DEV_BASE_DOMAIN }}
-    secrets: inherit
-
-  frontend:
-    if: github.event.action != 'closed'
-    name: Frontend - Build and Deploy to Cloudflare Pages (PR)
-    needs: [get_urls]
-    uses: ./.github/workflows/frontend-pages.yml
-    with:
-      mode: pr
-      pr_number: ${{ github.event.pull_request.number }}
-      backend_url_scheme: ${{ needs.get_urls.outputs.backend_url_scheme }}
-    secrets: inherit
-
-  deploy:
-    if: github.event.action != 'closed'
-    name: Helm upgrade/install (PR preview)
-    runs-on: vhs
-    concurrency:
-      group: pr-${{ github.event.pull_request.number }}
-      cancel-in-progress: false
-    needs: [build, frontend, get_urls]
-    steps:
-      - name: Checkout
-        uses: actions/checkout@v4
-
-      - name: Setup Helm
-        uses: azure/setup-helm@v4
-
-      - name: Setup kubectl
-        uses: azure/setup-kubectl@v4
-
-      - name: Configure kubeconfig
-        env:
-          KUBE_CONFIG: ${{ secrets.KUBE_CONFIG }}
-        run: |
-          mkdir -p ~/.kube
-          if [ -z "$KUBE_CONFIG" ]; then
-            echo "Secret KUBE_CONFIG is required (kubeconfig content)"; exit 1; fi
-          echo "$KUBE_CONFIG" > ~/.kube/config
-          chmod 600 ~/.kube/config
-
-      - name: Helm upgrade/install PR preview
-        env:
-          DEV_BASE_DOMAIN: ${{ secrets.BASE_DOMAIN }}
-          RABBITMQ_PASSWORD: ${{ secrets.PROD_RABBITMQ_PASSWORD }}
-          DB_PASSWORD: ${{ secrets.PROD_DB_PASSWORD }}
-          DIGEST: ${{ needs.build.outputs.digest }}
-          DOMAIN: "${{ needs.get_urls.outputs.backend_url }}"
-          DOMAIN_SCHEME: "${{ needs.get_urls.outputs.backend_url_scheme }}"
-          FRONTEND_DOMAIN: "${{ needs.get_urls.outputs.frontend_url }}"
-          FRONTEND_DOMAIN_SCHEME: "${{ needs.get_urls.outputs.frontend_url_scheme }}"
-        run: |
-          PR=${{ github.event.pull_request.number }}
-          RELEASE=myapp-pr-$PR
-          NAMESPACE=pr-$PR
-          helm upgrade --install "$RELEASE" ./7project/charts/myapp-chart \
-            -n "$NAMESPACE" --create-namespace \
-            -f 7project/charts/myapp-chart/values-dev.yaml \
-            --set prNumber="$PR" \
-            --set deployment="pr-$PR" \
-            --set domain="$DOMAIN" \
-            --set domain_scheme="$DOMAIN_SCHEME" \
-            --set frontend_domain="$FRONTEND_DOMAIN" \
-            --set frontend_domain_scheme="$FRONTEND_DOMAIN_SCHEME" \
-            --set image.digest="$DIGEST" \
-            --set-string rabbitmq.password="$RABBITMQ_PASSWORD" \
-            --set-string database.password="$DB_PASSWORD"
-
-      - name: Post preview URLs as PR comment
-        uses: actions/github-script@v7
-        env:
-          BACKEND_URL: ${{ needs.get_urls.outputs.backend_url_scheme }}
-          FRONTEND_URL: ${{ needs.get_urls.outputs.frontend_url_scheme }}
-        with:
-          script: |
-            const pr = context.payload.pull_request;
-            if (!pr) { core.setFailed('No pull_request context'); return; }
-            const prNumber = pr.number;
-            const backendUrl = process.env.BACKEND_URL || '(not available)';
-            const frontendUrl = process.env.FRONTEND_URL || '(not available)';
-            const marker = '<!-- preview-comment-marker -->';
-            const body = `${marker}\nPreview environment is running\n- Frontend: ${frontendUrl}\n- Backend: ${backendUrl}\n`;
-            const { owner, repo } = context.repo;
-            const { data: comments } = await github.rest.issues.listComments({ owner, repo, issue_number: prNumber, per_page: 100 });
-            const existing = comments.find(c => c.body && c.body.includes(marker));
-            if (existing) {
-              await github.rest.issues.updateComment({ owner, repo, comment_id: existing.id, body });
-            } else {
-              await github.rest.issues.createComment({ owner, repo, issue_number: prNumber, body });
-            }
-
-  uninstall:
-    if: github.event.action == 'closed'
-    name: Helm uninstall (PR preview)
-    runs-on: vhs
-    steps:
-      - name: Setup Helm
-        uses: azure/setup-helm@v4
-
-      - name: Setup kubectl
-        uses: azure/setup-kubectl@v4
-
-      - name: Configure kubeconfig
-        env:
-          KUBE_CONFIG: ${{ secrets.KUBE_CONFIG }}
-        run: |
-          mkdir -p ~/.kube
-          if [ -z "$KUBE_CONFIG" ]; then
-            echo "Secret KUBE_CONFIG is required (kubeconfig content)"; exit 1; fi
-          echo "$KUBE_CONFIG" > ~/.kube/config
-          chmod 600 ~/.kube/config
-
-      - name: Helm uninstall release and cleanup namespace
-        run: |
-          PR=${{ github.event.pull_request.number }}
-          RELEASE=myapp-pr-$PR
-          NAMESPACE=pr-$PR
-          helm uninstall "$RELEASE" -n "$NAMESPACE" || true
-          # Optionally delete the namespace if empty
-          kubectl delete namespace "$NAMESPACE" --ignore-not-found=true || true

.github/workflows/deploy-prod.yaml

@@ -1,105 +0,0 @@
-name: Deploy Prod
-
-on:
-  push:
-    branches: [ "main" ]
-    paths:
-      - 7project/backend/**
-      - 7project/frontend/**
-      - 7project/charts/myapp-chart/**
-      - .github/workflows/deploy-prod.yaml
-      - .github/workflows/build-image.yaml
-      - .github/workflows/frontend-pages.yml
-  workflow_dispatch:
-
-
-permissions:
-  contents: read
-
-concurrency:
-  group: deploy-prod
-  cancel-in-progress: false
-
-jobs:
-  build:
-    name: Build and push image (reusable)
-    uses: ./.github/workflows/build-image.yaml
-    with:
-      mode: prod
-      image_repo: lukastrkan/cc-app-demo
-      context: 7project/backend
-    secrets: inherit
-
-  get_urls:
-    name: Generate Production URLs
-    uses: ./.github/workflows/url_generator.yml
-    with:
-      mode: prod
-      runner: vhs
-      base_domain: ${{ vars.PROD_DOMAIN }}
-    secrets: inherit
-
-  frontend:
-    name: Frontend - Build and Deploy to Cloudflare Pages (prod)
-    needs: [get_urls]
-    uses: ./.github/workflows/frontend-pages.yml
-    with:
-      mode: prod
-      backend_url_scheme: ${{ needs.get_urls.outputs.backend_url_scheme }}
-    secrets: inherit
-
-  deploy:
-    name: Helm upgrade/install (prod)
-    runs-on: vhs
-    needs: [build, frontend, get_urls]
-    steps:
-      - name: Checkout
-        uses: actions/checkout@v4
-
-      - name: Setup Helm
-        uses: azure/setup-helm@v4
-
-      - name: Setup kubectl
-        uses: azure/setup-kubectl@v4
-
-      - name: Configure kubeconfig
-        env:
-          KUBE_CONFIG: ${{ secrets.KUBE_CONFIG }}
-        run: |
-          mkdir -p ~/.kube
-          if [ -z "$KUBE_CONFIG" ]; then
-            echo "Secret KUBE_CONFIG is required (kubeconfig content)"; exit 1; fi
-          echo "$KUBE_CONFIG" > ~/.kube/config
-          chmod 600 ~/.kube/config
-
-      - name: Helm upgrade/install prod
-        env:
-          DOMAIN: ${{ needs.get_urls.outputs.backend_url }}
-          DOMAIN_SCHEME: ${{ needs.get_urls.outputs.backend_url_scheme }}
-          FRONTEND_DOMAIN: ${{ needs.get_urls.outputs.frontend_url }}
-          FRONTEND_DOMAIN_SCHEME: ${{ needs.get_urls.outputs.frontend_url_scheme }}
-          RABBITMQ_PASSWORD: ${{ secrets.PROD_RABBITMQ_PASSWORD }}
-          DB_PASSWORD: ${{ secrets.PROD_DB_PASSWORD }}
-          DIGEST: ${{ needs.build.outputs.digest }}
-          BANKID_CLIENT_ID: ${{ secrets.BANKID_CLIENT_ID }}
-          BANKID_CLIENT_SECRET: ${{ secrets.BANKID_CLIENT_SECRET }}
-          MOJEID_CLIENT_ID: ${{ secrets.MOJEID_CLIENT_ID }}
-          MOJEID_CLIENT_SECRET: ${{ secrets.MOJEID_CLIENT_SECRET }}
-          SENTRY_DSN: ${{ secrets.SENTRY_DSN }}
-        run: |
-          helm upgrade --install myapp ./7project/charts/myapp-chart \
-            -n prod --create-namespace \
-            -f 7project/charts/myapp-chart/values-prod.yaml \
-            --set deployment="prod" \
-            --set domain="$DOMAIN" \
-            --set domain_scheme="$DOMAIN_SCHEME" \
-            --set frontend_domain="$FRONTEND_DOMAIN" \
-            --set frontend_domain_scheme="$FRONTEND_DOMAIN_SCHEME" \
-            --set image.digest="$DIGEST" \
-            --set-string rabbitmq.password="$RABBITMQ_PASSWORD" \
-            --set-string database.password="$DB_PASSWORD" \
-            --set-string oauth.bankid.clientId="$BANKID_CLIENT_ID" \
-            --set-string oauth.bankid.clientSecret="$BANKID_CLIENT_SECRET" \
-            --set-string oauth.mojeid.clientId="$MOJEID_CLIENT_ID" \
-            --set-string oauth.mojeid.clientSecret="$MOJEID_CLIENT_SECRET" \
-            --set-string sentry_dsn="$SENTRY_DSN" \

.github/workflows/frontend-pages.yml

@@ -1,135 +0,0 @@
-name: Frontend - Build and Deploy to Cloudflare Pages
-
-on:
-  workflow_call:
-    inputs:
-      mode:
-        description: "Build mode: 'prod' or 'pr'"
-        required: true
-        type: string
-      pr_number:
-        description: 'PR number (required when mode=pr)'
-        required: false
-        type: string
-      project_name:
-        description: 'Cloudflare Pages project name (overrides default)'
-        required: false
-        type: string
-      backend_url_scheme:
-        description: 'The full scheme URL for the backend (e.g., https://api.example.com)'
-        required: true
-        type: string
-    secrets:
-      CLOUDFLARE_API_TOKEN:
-        required: true
-      CLOUDFLARE_ACCOUNT_ID:
-        required: true
-    outputs:
-      deployed_url:
-        description: 'URL of deployed frontend'
-        value: ${{ jobs.deploy.outputs.deployed_url }}
-
-jobs:
-  build:
-    name: Build frontend
-    runs-on: ubuntu-latest
-    defaults:
-      run:
-        working-directory: 7project/frontend
-    steps:
-      - name: Checkout
-        uses: actions/checkout@v4
-
-      - name: Use Node.js
-        uses: actions/setup-node@v4
-        with:
-          node-version: '20'
-          cache: 'npm'
-          cache-dependency-path: 7project/frontend/package-lock.json
-
-      - name: Install dependencies
-        run: npm ci
-
-      - name: Set backend URL from workflow input
-        run: |
-          echo "VITE_BACKEND_URL=${{ inputs.backend_url_scheme }}" >> $GITHUB_ENV
-
-      - name: Build
-        run: npm run build
-
-      - name: Upload build artifact
-        uses: actions/upload-artifact@v4
-        with:
-          name: frontend-dist
-          path: 7project/frontend/dist
-
-  deploy:
-    name: Deploy to Cloudflare Pages
-    needs: build
-    runs-on: ubuntu-latest
-    outputs:
-      deployed_url: ${{ steps.out.outputs.deployed_url }}
-    steps:
-      - name: Checkout
-        uses: actions/checkout@v4
-
-      - name: Download build artifact
-        uses: actions/download-artifact@v4
-        with:
-          name: frontend-dist
-          path: dist
-
-      - name: Determine project name and branch
-        id: pname
-        env:
-          INPUT_MODE: ${{ inputs.mode }}
-          INPUT_PR: ${{ inputs.pr_number }}
-        run: |
-          set -euo pipefail
-          # Prefer manual input, then repo variable, fallback to repo-name
-          INPUT_NAME='${{ inputs.project_name }}'
-          VAR_NAME='${{ vars.CF_PAGES_PROJECT_NAME }}'
-          if [ -n "$INPUT_NAME" ]; then PNAME_RAW="$INPUT_NAME"; 
-          elif [ -n "$VAR_NAME" ]; then PNAME_RAW="$VAR_NAME"; 
-          else PNAME_RAW="${GITHUB_REPOSITORY##*/}-frontend"; fi
-          # Normalize project name to lowercase to satisfy Cloudflare Pages naming
-          PNAME="${PNAME_RAW,,}"
-          # Determine branch for Pages
-          if [ "${INPUT_MODE}" = "pr" ]; then
-            if [ -z "${INPUT_PR}" ]; then echo "pr_number is required when mode=pr"; exit 1; fi
-            PBRANCH="pr-${INPUT_PR}"
-          else
-            PBRANCH="main"
-          fi
-          echo "project_name=$PNAME" >> $GITHUB_OUTPUT
-          echo "branch=$PBRANCH" >> $GITHUB_OUTPUT
-
-      - name: Ensure Cloudflare Pages project exists
-        env:
-          CLOUDFLARE_API_TOKEN: ${{ secrets.CLOUDFLARE_API_TOKEN }}
-          CLOUDFLARE_ACCOUNT_ID: ${{ secrets.CLOUDFLARE_ACCOUNT_ID }}
-          PNAME: ${{ steps.pname.outputs.project_name }}
-        run: |
-          set -euo pipefail
-          npx wrangler pages project create "$PNAME" --production-branch=main || true
-
-      - name: Deploy using Cloudflare Wrangler
-        uses: cloudflare/wrangler-action@v3
-        with:
-          apiToken: ${{ secrets.CLOUDFLARE_API_TOKEN }}
-          accountId: ${{ secrets.CLOUDFLARE_ACCOUNT_ID }}
-          command: pages deploy dist --project-name=${{ steps.pname.outputs.project_name }} --branch=${{ steps.pname.outputs.branch }}
-
-      - name: Compute deployed URL
-        id: out
-        env:
-          PNAME: ${{ steps.pname.outputs.project_name }}
-          PBRANCH: ${{ steps.pname.outputs.branch }}
-        run: |
-          set -euo pipefail
-          if [ "$PBRANCH" = "main" ]; then
-            URL="https://${PNAME}.pages.dev"
-          else
-            URL="https://${PBRANCH}.${PNAME}.pages.dev"
-          fi
-          echo "deployed_url=$URL" >> $GITHUB_OUTPUT

.github/workflows/url_generator.yml

@@ -1,74 +0,0 @@
-name: Generate Preview or Production URLs
-
-on:
-  workflow_call:
-    inputs:
-      mode:
-        description: "Build mode: 'prod' or 'pr'"
-        required: true
-        type: string
-      pr_number:
-        description: 'PR number (required when mode=pr)'
-        required: false
-        type: string
-      runner:
-        description: 'The runner to use for this job'
-        required: false
-        type: string
-        default: 'ubuntu-latest'
-      base_domain:
-        description: 'The base domain for production URLs (e.g., example.com)'
-        required: true
-        type: string
-
-    outputs:
-      backend_url:
-        description: "The backend URL without scheme (e.g., api.example.com)"
-        value: ${{ jobs.generate-urls.outputs.backend_url }}
-      frontend_url:
-        description: "The frontend URL without scheme (e.g., app.example.com)"
-        value: ${{ jobs.generate-urls.outputs.frontend_url }}
-      backend_url_scheme:
-        description: "The backend URL with scheme (e.g., https://api.example.com)"
-        value: ${{ jobs.generate-urls.outputs.backend_url_scheme }}
-      frontend_url_scheme:
-        description: "The frontend URL with scheme (e.g., https://app.example.com)"
-        value: ${{ jobs.generate-urls.outputs.frontend_url_scheme }}
-
-jobs:
-  generate-urls:
-    permissions:
-      contents: none
-    runs-on: ${{ inputs.runner }}
-
-    outputs:
-      backend_url: ${{ steps.set_urls.outputs.backend_url }}
-      frontend_url: ${{ steps.set_urls.outputs.frontend_url }}
-      backend_url_scheme: ${{ steps.set_urls.outputs.backend_url_scheme }}
-      frontend_url_scheme: ${{ steps.set_urls.outputs.frontend_url_scheme }}
-
-    steps:
-      - name: Generate URLs
-        id: set_urls
-        env:
-          BASE_DOMAIN: ${{ inputs.base_domain }}
-        run: |
-          set -euo pipefail
-          
-          if [ "${{ inputs.mode }}" = "prod" ]; then
-            BACKEND_URL="api.${BASE_DOMAIN}"
-            FRONTEND_URL="finance.${BASE_DOMAIN}"
-          else
-            # This is your current logic
-            FRONTEND_URL="pr-${{ inputs.pr_number }}.group-8-frontend.pages.dev"
-            BACKEND_URL="api-pr-${{ inputs.pr_number }}.${BASE_DOMAIN}"
-          fi
-
-          FRONTEND_URL_SCHEME="https://$FRONTEND_URL"
-          BACKEND_URL_SCHEME="https://$BACKEND_URL"
-          
-          # This part correctly writes to GITHUB_OUTPUT for the step
-          echo "backend_url_scheme=$BACKEND_URL_SCHEME" >> $GITHUB_OUTPUT
-          echo "frontend_url_scheme=$FRONTEND_URL_SCHEME" >> $GITHUB_OUTPUT
-          echo "backend_url=$BACKEND_URL" >> $GITHUB_OUTPUT
-          echo "frontend_url=$FRONTEND_URL" >> $GITHUB_OUTPUT

.github/workflows/workflow.yml

@@ -0,0 +1,54 @@
+name: Build, Push and Update Image in Manifest
+
+on:
+  push:
+    branches: [ "main" ]
+    paths:
+      - 'backend/**'
+  workflow_dispatch:
+
+jobs:
+  build-and-update:
+    runs-on: ubuntu-latest
+    permissions:
+      contents: write
+      packages: write
+
+    steps:
+      - name: Checkout repo
+        uses: actions/checkout@v4
+
+      - name: Login to Docker Hub
+        uses: docker/login-action@v3
+        with:
+          username: ${{ secrets.DOCKER_USER }}
+          password: ${{ secrets.DOCKER_PASSWORD }}
+
+      - name: Build and push Docker image
+        id: build
+        uses: docker/build-push-action@v5
+        with:
+          context: ./backend
+          push: true
+          tags: ${{ secrets.DOCKER_USER }}/cc-app-demo:latest
+
+      - name: Get image digest
+        run: echo "IMAGE_DIGEST=${{ steps.build.outputs.digest }}" >> $GITHUB_ENV
+
+      - name: Update manifests with new image digest
+        uses: OpsVerseIO/image-updater-action@0.1.0
+        with:
+          branch: main
+          targetBranch: main
+          createPR: 'false'
+          message: "${{ github.event.head_commit.message }}"
+          token: ${{ secrets.GITHUB_TOKEN }}
+          changes: |
+            {
+              "deployment/app-demo-deployment.yaml": {
+                "spec.template.spec.containers[0].image": "${{ secrets.DOCKER_USER }}/cc-app-demo@${{ env.IMAGE_DIGEST }}"
+              },
+              "deployment/app-demo-worker-deployment.yaml": {
+                "spec.template.spec.containers[0].image": "${{ secrets.DOCKER_USER }}/cc-app-demo@${{ env.IMAGE_DIGEST }}"
+              }
+            }

7project/backend/alembic/versions/2025_10_09_1514-390041bd839e_update_categories_unique.py

@@ -1,34 +0,0 @@
-"""update categories unique
-
-Revision ID: 390041bd839e
-Revises: 63e072f09836
-Create Date: 2025-10-09 15:14:31.557686
-
-"""
-from typing import Sequence, Union
-
-from alembic import op
-import sqlalchemy as sa
-
-
-# revision identifiers, used by Alembic.
-revision: str = '390041bd839e'
-down_revision: Union[str, Sequence[str], None] = '63e072f09836'
-branch_labels: Union[str, Sequence[str], None] = None
-depends_on: Union[str, Sequence[str], None] = None
-
-
-def upgrade() -> None:
-    """Upgrade schema."""
-    # ### commands auto generated by Alembic - please adjust! ###
-    op.drop_index(op.f('name'), table_name='categories')
-    op.create_unique_constraint('uix_name_user_id', 'categories', ['name', 'user_id'])
-    # ### end Alembic commands ###
-
-
-def downgrade() -> None:
-    """Downgrade schema."""
-    # ### commands auto generated by Alembic - please adjust! ###
-    op.drop_constraint('uix_name_user_id', 'categories', type_='unique')
-    op.create_index(op.f('name'), 'categories', ['name'], unique=True)
-    # ### end Alembic commands ###

7project/backend/alembic/versions/2025_10_10_1405-7af8f296d089_add_user_oauth.py

@@ -1,48 +0,0 @@
-"""add user oauth
-
-Revision ID: 7af8f296d089
-Revises: 390041bd839e
-Create Date: 2025-10-10 14:05:00.153376
-
-"""
-from typing import Sequence, Union
-
-import fastapi_users_db_sqlalchemy
-from alembic import op
-import sqlalchemy as sa
-
-
-# revision identifiers, used by Alembic.
-revision: str = '7af8f296d089'
-down_revision: Union[str, Sequence[str], None] = '390041bd839e'
-branch_labels: Union[str, Sequence[str], None] = None
-depends_on: Union[str, Sequence[str], None] = None
-
-
-def upgrade() -> None:
-    """Upgrade schema."""
-    # ### commands auto generated by Alembic - please adjust! ###
-    op.create_table('oauth_account',
-    sa.Column('id', fastapi_users_db_sqlalchemy.generics.GUID(), nullable=False),
-    sa.Column('user_id', fastapi_users_db_sqlalchemy.generics.GUID(), nullable=False),
-    sa.Column('oauth_name', sa.String(length=100), nullable=False),
-    sa.Column('access_token', sa.String(length=1024), nullable=False),
-    sa.Column('expires_at', sa.Integer(), nullable=True),
-    sa.Column('refresh_token', sa.String(length=1024), nullable=True),
-    sa.Column('account_id', sa.String(length=320), nullable=False),
-    sa.Column('account_email', sa.String(length=320), nullable=False),
-    sa.ForeignKeyConstraint(['user_id'], ['user.id'], ondelete='cascade'),
-    sa.PrimaryKeyConstraint('id')
-    )
-    op.create_index(op.f('ix_oauth_account_account_id'), 'oauth_account', ['account_id'], unique=False)
-    op.create_index(op.f('ix_oauth_account_oauth_name'), 'oauth_account', ['oauth_name'], unique=False)
-    # ### end Alembic commands ###
-
-
-def downgrade() -> None:
-    """Downgrade schema."""
-    # ### commands auto generated by Alembic - please adjust! ###
-    op.drop_index(op.f('ix_oauth_account_oauth_name'), table_name='oauth_account')
-    op.drop_index(op.f('ix_oauth_account_account_id'), table_name='oauth_account')
-    op.drop_table('oauth_account')
-    # ### end Alembic commands ###

7project/backend/alembic/versions/2025_10_11_2107-5ab2e654c96e_change_token_lenght.py

@@ -1,38 +0,0 @@
-"""change token length
-
-Revision ID: 5ab2e654c96e
-Revises: 7af8f296d089
-Create Date: 2025-10-11 21:07:41.930470
-
-"""
-from typing import Sequence, Union
-
-from alembic import op
-import sqlalchemy as sa
-from sqlalchemy.dialects import mysql
-
-# revision identifiers, used by Alembic.
-revision: str = '5ab2e654c96e'
-down_revision: Union[str, Sequence[str], None] = '7af8f296d089'
-branch_labels: Union[str, Sequence[str], None] = None
-depends_on: Union[str, Sequence[str], None] = None
-
-
-def upgrade() -> None:
-    """Upgrade schema."""
-    # ### commands auto generated by Alembic - please adjust! ###
-    op.alter_column('oauth_account', 'access_token',
-               existing_type=mysql.VARCHAR(length=1024),
-               type_=sa.String(length=4096),
-               existing_nullable=False)
-    # ### end Alembic commands ###
-
-
-def downgrade() -> None:
-    """Downgrade schema."""
-    # ### commands auto generated by Alembic - please adjust! ###
-    op.alter_column('oauth_account', 'access_token',
-               existing_type=sa.String(length=4096),
-               type_=mysql.VARCHAR(length=1024),
-               existing_nullable=False)
-    # ### end Alembic commands ###

7project/backend/app/api/auth.py

@@ -1,49 +0,0 @@
-from fastapi import APIRouter, Depends, status
-from fastapi_users import models
-from fastapi_users.manager import BaseUserManager
-
-from app.schemas.user import UserCreate, UserRead, UserUpdate
-from app.services.user_service import auth_backend, fastapi_users
-
-router = APIRouter()
-
-@router.delete(
-    "/users/me",
-    status_code=status.HTTP_204_NO_CONTENT,
-    tags=["users"],
-    summary="Delete current user",
-    response_description="The user has been successfully deleted.",
-)
-async def delete_me(
-    user: models.UserProtocol = Depends(fastapi_users.current_user(active=True)),
-    user_manager: BaseUserManager = Depends(fastapi_users.get_user_manager),
-):
-    """
-    Delete the currently authenticated user.
-    """
-    await user_manager.delete(user)
-
-# Keep existing paths as-is under /auth/* and /users/*
-router.include_router(
-    fastapi_users.get_auth_router(auth_backend), prefix="/auth/jwt", tags=["auth"]
-)
-router.include_router(
-    fastapi_users.get_register_router(UserRead, UserCreate),
-    prefix="/auth",
-    tags=["auth"],
-)
-router.include_router(
-    fastapi_users.get_reset_password_router(),
-    prefix="/auth",
-    tags=["auth"],
-)
-router.include_router(
-    fastapi_users.get_verify_router(UserRead),
-    prefix="/auth",
-    tags=["auth"],
-)
-router.include_router(
-    fastapi_users.get_users_router(UserRead, UserUpdate),
-    prefix="/users",
-    tags=["users"],
-)

7project/backend/app/api/categories.py

@@ -1,77 +0,0 @@
-from typing import List
-
-from fastapi import APIRouter, Depends, HTTPException, status
-from sqlalchemy import select, delete
-from sqlalchemy.ext.asyncio import AsyncSession
-
-from app.models.categories import Category
-from app.schemas.category import CategoryCreate, CategoryRead
-from app.services.db import get_async_session
-from app.services.user_service import current_active_user
-from app.models.user import User
-
-router = APIRouter(prefix="/categories", tags=["categories"])
-
-
-@router.post("/create", response_model=CategoryRead, status_code=status.HTTP_201_CREATED)
-async def create_category(
-    payload: CategoryCreate,
-    session: AsyncSession = Depends(get_async_session),
-    user: User = Depends(current_active_user),
-):
-    # Enforce per-user unique name via query to provide 409 feedback
-    res = await session.execute(
-        select(Category).where(Category.user_id == user.id, Category.name == payload.name)
-    )
-    existing = res.scalar_one_or_none()
-    if existing:
-        raise HTTPException(status_code=409, detail="Category with this name already exists")
-
-    category = Category(name=payload.name, description=payload.description, user_id=user.id)
-    session.add(category)
-    await session.commit()
-    await session.refresh(category)
-    return category
-
-
-@router.get("/", response_model=List[CategoryRead])
-async def list_categories(
-    session: AsyncSession = Depends(get_async_session),
-    user: User = Depends(current_active_user),
-):
-    res = await session.execute(select(Category).where(Category.user_id == user.id))
-    return list(res.scalars())
-
-
-@router.get("/{category_id}", response_model=CategoryRead)
-async def get_category(
-    category_id: int,
-    session: AsyncSession = Depends(get_async_session),
-    user: User = Depends(current_active_user),
-):
-    res = await session.execute(
-        select(Category).where(Category.id == category_id, Category.user_id == user.id)
-    )
-    category = res.scalar_one_or_none()
-    if not category:
-        raise HTTPException(status_code=404, detail="Category not found")
-    return category
-
-
-@router.delete("/{category_id}", status_code=status.HTTP_204_NO_CONTENT)
-async def delete_category(
-    category_id: int,
-    session: AsyncSession = Depends(get_async_session),
-    user: User = Depends(current_active_user),
-):
-    res = await session.execute(
-        select(Category.id).where(Category.id == category_id, Category.user_id == user.id)
-    )
-    if res.scalar_one_or_none() is None:
-        raise HTTPException(status_code=404, detail="Category not found")
-
-    await session.execute(
-        delete(Category).where(Category.id == category_id, Category.user_id == user.id)
-    )
-    await session.commit()
-    return None

7project/backend/app/api/transactions.py

@@ -1,219 +0,0 @@
-from typing import List, Optional
-
-from fastapi import APIRouter, Depends, HTTPException, status
-from sqlalchemy import select
-from sqlalchemy.ext.asyncio import AsyncSession
-
-from app.models.transaction import Transaction
-from app.models.categories import Category
-from app.schemas.transaction import (
-    TransactionCreate,
-    TransactionRead,
-    TransactionUpdate,
-)
-from app.services.db import get_async_session
-from app.services.user_service import current_active_user
-from app.models.user import User
-
-router = APIRouter(prefix="/transactions", tags=["transactions"])
-
-
-def _to_read_model(tx: Transaction) -> TransactionRead:
-    return TransactionRead(
-        id=tx.id,
-        amount=tx.amount,
-        description=tx.description,
-        category_ids=[c.id for c in (tx.categories or [])],
-    )
-
-
-@router.post("/create", response_model=TransactionRead, status_code=status.HTTP_201_CREATED)
-async def create_transaction(
-    payload: TransactionCreate,
-    session: AsyncSession = Depends(get_async_session),
-    user: User = Depends(current_active_user),
-):
-    tx = Transaction(amount=payload.amount, description=payload.description, user_id=user.id)
-
-    # Attach categories if provided (and owned by user)
-    if payload.category_ids:
-        res = await session.execute(
-            select(Category).where(
-                Category.user_id == user.id, Category.id.in_(payload.category_ids)
-            )
-        )
-        categories = list(res.scalars())
-        if len(categories) != len(set(payload.category_ids)):
-            raise HTTPException(
-                status_code=400,
-                detail="Duplicate category IDs provided or one or more categories not found"
-            )
-        tx.categories = categories
-
-    session.add(tx)
-    await session.commit()
-    await session.refresh(tx)
-    # Ensure categories are loaded
-    await session.refresh(tx, attribute_names=["categories"])
-    return _to_read_model(tx)
-
-
-@router.get("/", response_model=List[TransactionRead])
-async def list_transactions(
-    session: AsyncSession = Depends(get_async_session),
-    user: User = Depends(current_active_user),
-):
-    res = await session.execute(
-        select(Transaction).where(Transaction.user_id == user.id).order_by(Transaction.id)
-    )
-    txs = list(res.scalars())
-    # Eagerly load categories for each transaction
-    for tx in txs:
-        await session.refresh(tx, attribute_names=["categories"])
-    return [_to_read_model(tx) for tx in txs]
-
-
-@router.get("/{transaction_id}", response_model=TransactionRead)
-async def get_transaction(
-    transaction_id: int,
-    session: AsyncSession = Depends(get_async_session),
-    user: User = Depends(current_active_user),
-):
-    res = await session.execute(
-        select(Transaction).where(
-            Transaction.id == transaction_id, Transaction.user_id == user.id
-        )
-    )
-    tx: Optional[Transaction] = res.scalar_one_or_none()
-    if not tx:
-        raise HTTPException(status_code=404, detail="Transaction not found")
-    await session.refresh(tx, attribute_names=["categories"])
-    return _to_read_model(tx)
-
-
-@router.patch("/{transaction_id}/edit", response_model=TransactionRead)
-async def update_transaction(
-    transaction_id: int,
-    payload: TransactionUpdate,
-    session: AsyncSession = Depends(get_async_session),
-    user: User = Depends(current_active_user),
-):
-    res = await session.execute(
-        select(Transaction).where(
-            Transaction.id == transaction_id, Transaction.user_id == user.id
-        )
-    )
-    tx: Optional[Transaction] = res.scalar_one_or_none()
-    if not tx:
-        raise HTTPException(status_code=404, detail="Transaction not found")
-
-    if payload.amount is not None:
-        tx.amount = payload.amount
-    if payload.description is not None:
-        tx.description = payload.description
-
-    if payload.category_ids is not None:
-        # Preload categories to avoid async lazy-load during assignment
-        await session.refresh(tx, attribute_names=["categories"])
-        if payload.category_ids:
-            # Check for duplicate category IDs in the payload
-            if len(payload.category_ids) != len(set(payload.category_ids)):
-                raise HTTPException(status_code=400, detail="Duplicate category IDs in payload")
-            res = await session.execute(
-                select(Category).where(
-                    Category.user_id == user.id, Category.id.in_(payload.category_ids)
-                )
-            )
-            categories = list(res.scalars())
-            if len(categories) != len(payload.category_ids):
-                raise HTTPException(status_code=400, detail="One or more categories not found")
-            tx.categories = categories
-        else:
-            tx.categories = []
-
-    await session.commit()
-    await session.refresh(tx, attribute_names=["categories"])
-    return _to_read_model(tx)
-
-
-@router.delete("/{transaction_id}/delete", status_code=status.HTTP_204_NO_CONTENT)
-async def delete_transaction(
-    transaction_id: int,
-    session: AsyncSession = Depends(get_async_session),
-    user: User = Depends(current_active_user),
-):
-    res = await session.execute(
-        select(Transaction).where(
-            Transaction.id == transaction_id, Transaction.user_id == user.id
-        )
-    )
-    tx = res.scalar_one_or_none()
-    if not tx:
-        raise HTTPException(status_code=404, detail="Transaction not found")
-
-    await session.delete(tx)
-    await session.commit()
-    return None
-
-
-@router.post("/{transaction_id}/categories/{category_id}", response_model=TransactionRead)
-async def assign_category(
-    transaction_id: int,
-    category_id: int,
-    session: AsyncSession = Depends(get_async_session),
-    user: User = Depends(current_active_user),
-):
-    # Load transaction and category ensuring ownership
-    res_tx = await session.execute(
-        select(Transaction).where(
-            Transaction.id == transaction_id, Transaction.user_id == user.id
-        )
-    )
-    tx: Optional[Transaction] = res_tx.scalar_one_or_none()
-    if not tx:
-        raise HTTPException(status_code=404, detail="Transaction not found")
-
-    res_cat = await session.execute(
-        select(Category).where(Category.id == category_id, Category.user_id == user.id)
-    )
-    cat: Optional[Category] = res_cat.scalar_one_or_none()
-    if not cat:
-        raise HTTPException(status_code=404, detail="Category not found")
-
-    await session.refresh(tx, attribute_names=["categories"])
-    if cat not in tx.categories:
-        tx.categories.append(cat)
-        await session.commit()
-        await session.refresh(tx, attribute_names=["categories"])
-    return _to_read_model(tx)
-
-
-@router.delete("/{transaction_id}/categories/{category_id}", response_model=TransactionRead)
-async def unassign_category(
-    transaction_id: int,
-    category_id: int,
-    session: AsyncSession = Depends(get_async_session),
-    user: User = Depends(current_active_user),
-):
-    res_tx = await session.execute(
-        select(Transaction).where(
-            Transaction.id == transaction_id, Transaction.user_id == user.id
-        )
-    )
-    tx: Optional[Transaction] = res_tx.scalar_one_or_none()
-    if not tx:
-        raise HTTPException(status_code=404, detail="Transaction not found")
-
-    res_cat = await session.execute(
-        select(Category).where(Category.id == category_id, Category.user_id == user.id)
-    )
-    cat: Optional[Category] = res_cat.scalar_one_or_none()
-    if not cat:
-        raise HTTPException(status_code=404, detail="Category not found")
-
-    await session.refresh(tx, attribute_names=["categories"])
-    if cat in tx.categories:
-        tx.categories.remove(cat)
-        await session.commit()
-        await session.refresh(tx, attribute_names=["categories"])
-    return _to_read_model(tx)

7project/backend/app/app.py

@@ -1,102 +0,0 @@
-import logging
-import os
-from datetime import datetime
-
-from fastapi import Depends, FastAPI
-from fastapi.middleware.cors import CORSMiddleware
-from starlette.requests import Request
-
-from app.models.user import User
-
-from app.services.user_service import current_active_verified_user
-from app.api.auth import router as auth_router
-from app.api.categories import router as categories_router
-from app.api.transactions import router as transactions_router
-from app.services.user_service import auth_backend, current_active_verified_user, fastapi_users, get_oauth_provider
-
-
-from fastapi import FastAPI
-import sentry_sdk
-
-sentry_sdk.init(
-    dsn=os.getenv("SENTRY_DSN"),
-    send_default_pii=True,
-)
-
-app = FastAPI()
-fastApi = FastAPI()
-
-# CORS for frontend dev server
-fastApi.add_middleware(
-    CORSMiddleware,
-    allow_origins=[
-        "http://localhost:5173",
-        "http://127.0.0.1:5173",
-        os.getenv("FRONTEND_DOMAIN_SCHEME", "")
-    ],
-    allow_credentials=True,
-    allow_methods=["*"],
-    allow_headers=["*"],
-)
-
-fastApi.include_router(auth_router)
-fastApi.include_router(categories_router)
-fastApi.include_router(transactions_router)
-
-logging.basicConfig(filename='app.log', level=logging.INFO, format='%(asctime)s %(message)s')
-@fastApi.middleware("http")
-async def log_traffic(request: Request, call_next):
-    start_time = datetime.now()
-    response = await call_next(request)
-    process_time = (datetime.now() - start_time).total_seconds()
-    client_host = request.client.host
-    log_params = {
-        "request_method": request.method,
-        "request_url": str(request.url),
-        "request_size": request.headers.get("content-length"),
-        "request_headers": dict(request.headers),
-        "response_status": response.status_code,
-        "response_size": response.headers.get("content-length"),
-        "response_headers": dict(response.headers),
-        "process_time": process_time,
-        "client_host": client_host
-    }
-    logging.info(str(log_params))
-    return response
-
-fastApi.include_router(
-    fastapi_users.get_oauth_router(
-        get_oauth_provider("MojeID"),
-        auth_backend,
-        "SECRET",
-        associate_by_email=True,
-    ),
-    prefix="/auth/mojeid",
-    tags=["auth"],
-)
-
-fastApi.include_router(
-    fastapi_users.get_oauth_router(
-        get_oauth_provider("BankID"),
-        auth_backend,
-        "SECRET",
-        associate_by_email=True,
-    ),
-    prefix="/auth/bankid",
-    tags=["auth"],
-)
-
-
-# Liveness/root endpoint
-@fastApi.get("/", include_in_schema=False)
-async def root():
-    return {"status": "ok"}
-
-
-@fastApi.get("/authenticated-route")
-async def authenticated_route(user: User = Depends(current_active_verified_user)):
-    return {"message": f"Hello {user.email}!"}
-
-@fastApi.get("/sentry-debug")
-async def trigger_error():
-    division_by_zero = 1 / 0

7project/backend/app/celery_app.py

@@ -1,50 +0,0 @@
-import os
-from celery import Celery
-
-if os.getenv("RABBITMQ_URL"):
-    RABBITMQ_URL = os.getenv("RABBITMQ_URL")  # type: ignore
-else:
-    from urllib.parse import quote
-
-    username = os.getenv("RABBITMQ_USERNAME", "user")
-    password = os.getenv("RABBITMQ_PASSWORD", "bitnami123")
-    host = os.getenv("RABBITMQ_HOST", "localhost")
-    port = os.getenv("RABBITMQ_PORT", "5672")
-    vhost = os.getenv("RABBITMQ_VHOST", "/")
-    use_ssl = os.getenv("RABBITMQ_USE_SSL", "0").lower() in {"1", "true", "yes"}
-    scheme = "amqps" if use_ssl else "amqp"
-
-    # Kombu uses '//' to denote the default '/' vhost. For custom vhosts, URL-encode them.
-    if vhost in ("/", ""):
-        vhost_path = "/"  # will become '//' after concatenation below
-    else:
-        vhost_path = f"/{quote(vhost, safe='')}"
-
-    # Ensure we end up with e.g. amqp://user:pass@host:5672// (for '/')
-    RABBITMQ_URL = f"{scheme}://{username}:{password}@{host}:{port}{vhost_path}"
-    if vhost in ("/", "") and not RABBITMQ_URL.endswith("//"):
-        RABBITMQ_URL += "/"
-
-DEFAULT_QUEUE = os.getenv("MAIL_QUEUE", "mail_queue")
-
-CELERY_BACKEND = os.getenv("CELERY_BACKEND", "rpc://")
-
-celery_app = Celery(
-    "app",
-    broker=RABBITMQ_URL,
-    # backend=CELERY_BACKEND,
-)
-celery_app.autodiscover_tasks(["app.workers"], related_name="celery_tasks")  # discover app.workers.celery_tasks
-
-celery_app.set_default()
-
-celery_app.conf.update(
-    task_default_queue=DEFAULT_QUEUE,
-    task_acks_late=True,
-    worker_prefetch_multiplier=int(os.getenv("CELERY_PREFETCH", "1")),
-    task_serializer="json",
-    result_serializer="json",
-    accept_content=["json"],
-)
-
-__all__ = ["celery_app"]

7project/backend/app/core/queue.py

@@ -1,6 +0,0 @@
-import app.celery_app  # noqa: F401
-from app.workers.celery_tasks import send_email
-
-
-def enqueue_email(to: str, subject: str, body: str) -> None:
-    send_email.delay(to, subject, body)

7project/backend/app/models/categories.py

@@ -1,25 +0,0 @@
-from fastapi_users_db_sqlalchemy import GUID
-from sqlalchemy import Column, Integer, String, ForeignKey, Table, UniqueConstraint
-from sqlalchemy.orm import relationship
-
-from app.core.base import Base
-
-association_table = Table(
-    "category_transaction",
-    Base.metadata,
-    Column("id_category", Integer, ForeignKey("categories.id")),
-    Column("id_transaction", Integer, ForeignKey("transaction.id"))
-)
-
-
-class Category(Base):
-    __tablename__ = "categories"
-    __table_args__ = (
-        UniqueConstraint("name", "user_id", name="uix_name_user_id"),
-    )
-    id = Column(Integer, primary_key=True, autoincrement=True)
-    name = Column(String(length=100), nullable=False)
-    description = Column(String(length=255), nullable=True)
-    user_id = Column(GUID, ForeignKey("user.id"), nullable=False)
-    user = relationship("User", back_populates="categories")
-    transactions = relationship("Transaction", secondary=association_table, back_populates="categories")

7project/backend/app/models/transaction.py

@@ -1,17 +0,0 @@
-from fastapi_users_db_sqlalchemy import GUID
-from sqlalchemy import Column, Integer, String, Float, ForeignKey
-from sqlalchemy.orm import relationship
-from app.core.base import Base
-from app.models.categories import association_table
-
-
-class Transaction(Base):
-    __tablename__ = "transaction"
-    id = Column(Integer, primary_key=True, autoincrement=True)
-    amount = Column(Float, nullable=False)
-    description = Column(String(length=255), nullable=True)
-    user_id = Column(GUID, ForeignKey("user.id"), nullable=False)
-
-    # Relationship
-    user = relationship("User", back_populates="transactions")
-    categories = relationship("Category", secondary=association_table, back_populates="transactions")

7project/backend/app/models/user.py

@@ -1,19 +0,0 @@
-from sqlalchemy import Column, String
-from sqlalchemy.orm import relationship, mapped_column, Mapped
-from fastapi_users.db import SQLAlchemyBaseUserTableUUID, SQLAlchemyBaseOAuthAccountTableUUID
-from app.core.base import Base
-
-
-class OAuthAccount(SQLAlchemyBaseOAuthAccountTableUUID, Base):
-    # BankID token is longer than default
-    access_token: Mapped[str] = mapped_column(String(length=4096), nullable=False)
-
-
-class User(SQLAlchemyBaseUserTableUUID, Base):
-    first_name = Column(String(length=100), nullable=True)
-    last_name = Column(String(length=100), nullable=True)
-    oauth_accounts = relationship("OAuthAccount", lazy="joined")
-
-    # Relationship
-    transactions = relationship("Transaction", back_populates="user")
-    categories = relationship("Category", back_populates="user")

7project/backend/app/oauth/bank_id.py

@@ -1,50 +0,0 @@
-import secrets
-from typing import Optional, Literal
-
-from httpx_oauth.oauth2 import T
-
-from app.oauth.custom_openid import CustomOpenID
-
-
-class BankID(CustomOpenID):
-    def __init__(self, client_id: str, client_secret: str):
-        super().__init__(
-            client_id,
-            client_secret,
-            "https://oidc.sandbox.bankid.cz/.well-known/openid-configuration",
-            "BankID",
-            base_scopes=["openid", "profile.email", "profile.name"],
-        )
-
-    async def get_user_info(self, token: str) -> dict:
-        info = await self.get_profile(token)
-
-        return {
-            "first_name": info.get("given_name"),
-            "last_name": info.get("family_name"),
-        }
-
-    async def get_authorization_url(
-            self,
-            redirect_uri: str,
-            state: Optional[str] = None,
-            scope: Optional[list[str]] = None,
-            code_challenge: Optional[str] = None,
-            code_challenge_method: Optional[Literal["plain", "S256"]] = None,
-            extras_params: Optional[T] = None,
-    ) -> str:
-        if extras_params is None:
-            extras_params = {}
-
-        # BankID requires random nonce parameter for security
-        # https://developer.bankid.cz/docs/security_sep
-        extras_params["nonce"] = secrets.token_urlsafe()
-
-        return await super().get_authorization_url(
-            redirect_uri,
-            state,
-            scope,
-            code_challenge,
-            code_challenge_method,
-            extras_params,
-        )

7project/backend/app/oauth/custom_openid.py

@@ -1,6 +0,0 @@
-from httpx_oauth.clients.openid import OpenID
-
-
-class CustomOpenID(OpenID):
-    async def get_user_info(self, token: str) -> dict:
-        raise NotImplementedError()

7project/backend/app/oauth/moje_id.py

@@ -1,56 +0,0 @@
-import json
-from typing import Optional, Literal, Any
-
-from httpx_oauth.oauth2 import T
-
-from app.oauth.custom_openid import CustomOpenID
-
-
-class MojeIDOAuth(CustomOpenID):
-    def __init__(self, client_id: str, client_secret: str):
-        super().__init__(
-            client_id,
-            client_secret,
-            "https://mojeid.regtest.nic.cz/.well-known/openid-configuration/",
-            "MojeID",
-            base_scopes=["openid", "email", "profile"],
-        )
-
-    async def get_user_info(self, token: str) -> Optional[Any]:
-        info = await self.get_profile(token)
-
-        return {
-            "first_name": info.get("given_name"),
-            "last_name": info.get("family_name"),
-        }
-
-    async def get_authorization_url(
-            self,
-            redirect_uri: str,
-            state: Optional[str] = None,
-            scope: Optional[list[str]] = None,
-            code_challenge: Optional[str] = None,
-            code_challenge_method: Optional[Literal["plain", "S256"]] = None,
-            extras_params: Optional[T] = None,
-    ) -> str:
-        required_fields = {
-            'id_token': {
-                'name': {'essential': True},
-                'given_name': {'essential': True},
-                'family_name': {'essential': True},
-                'email': {'essential': True},
-                'mojeid_valid': {'essential': True},
-            }}
-
-        if extras_params is None:
-            extras_params = {}
-        extras_params["claims"] = json.dumps(required_fields)
-
-        return await super().get_authorization_url(
-            redirect_uri,
-            state,
-            scope,
-            code_challenge,
-            code_challenge_method,
-            extras_params,
-        )

7project/backend/app/schemas/category.py

@@ -1,16 +0,0 @@
-from typing import Optional
-from pydantic import BaseModel, ConfigDict
-
-
-class CategoryBase(BaseModel):
-    name: str
-    description: Optional[str] = None
-
-
-class CategoryCreate(CategoryBase):
-    pass
-
-
-class CategoryRead(CategoryBase):
-    id: int
-    model_config = ConfigDict(from_attributes=True)

7project/backend/app/schemas/transaction.py

@@ -1,21 +0,0 @@
-from typing import List, Optional
-from pydantic import BaseModel, Field, ConfigDict
-
-
-class TransactionBase(BaseModel):
-    amount: float = Field(..., gt=-1e18, lt=1e18)
-    description: Optional[str] = None
-
-class TransactionCreate(TransactionBase):
-    category_ids: Optional[List[int]] = None
-
-class TransactionUpdate(BaseModel):
-    amount: Optional[float] = Field(None, gt=-1e18, lt=1e18)
-    description: Optional[str] = None
-    category_ids: Optional[List[int]] = None
-
-class TransactionRead(TransactionBase):
-    id: int
-    category_ids: List[int] = []
-
-    model_config = ConfigDict(from_attributes=True)

7project/backend/app/workers/celery_tasks.py

@@ -1,19 +0,0 @@
-import logging
-
-from celery import shared_task
-
-logger = logging.getLogger("celery_tasks")
-if not logger.handlers:
-    _h = logging.StreamHandler()
-    logger.addHandler(_h)
-logger.setLevel(logging.INFO)
-
-
-@shared_task(name="workers.send_email")
-def send_email(to: str, subject: str, body: str) -> None:
-    if not (to and subject and body):
-        logger.error("Email task missing fields. to=%r subject=%r body_len=%r", to, subject, len(body) if body else 0)
-        return
-
-    # Placeholder for real email sending logic
-    logger.info("[Celery] Email sent | to=%s | subject=%s | body_len=%d", to, subject, len(body))

7project/charts/myapp-chart/Chart.yaml

@@ -1,6 +0,0 @@
-apiVersion: v2
-name: myapp-chart
-version: 0.1.0
-description: Helm chart for my app with MariaDB Database CR
-appVersion: "1.0.0"
-type: application

7project/charts/myapp-chart/templates/app-deployment.yaml

@@ -1,107 +0,0 @@
-apiVersion: apps/v1
-kind: Deployment
-metadata:
-  name: {{ .Values.app.name }}
-spec:
-  replicas: {{ .Values.app.replicas }}
-  revisionHistoryLimit: 3
-  selector:
-    matchLabels:
-      app: {{ .Values.app.name }}
-  template:
-    metadata:
-      labels:
-        app: {{ .Values.app.name }}
-    spec:
-      containers:
-        - name: {{ .Values.app.name }}
-          image: "{{- if .Values.image.digest -}}{{ .Values.image.repository }}@{{ .Values.image.digest }}{{- else -}}{{ .Values.image.repository }}:{{ default "latest" .Values.image.tag }}{{- end -}}"
-          imagePullPolicy: {{ .Values.image.pullPolicy }}
-          securityContext:
-            allowPrivilegeEscalation: false
-            capabilities:
-              drop: [ "ALL" ]
-          ports:
-            - containerPort: {{ .Values.app.port }}
-          env:
-            - name: MARIADB_HOST
-              value: "mariadb-repl-maxscale-internal.mariadb-operator.svc.cluster.local"
-            - name: MARIADB_PORT
-              value: '3306'
-            - name: MARIADB_DB
-              valueFrom:
-                secretKeyRef:
-                  name: prod
-                  key: MARIADB_DB
-            - name: MARIADB_USER
-              valueFrom:
-                secretKeyRef:
-                  name: prod
-                  key: MARIADB_USER
-            - name: MARIADB_PASSWORD
-              valueFrom:
-                secretKeyRef:
-                  name: prod
-                  key: MARIADB_PASSWORD
-            - name: RABBITMQ_USERNAME
-              value: {{ .Values.rabbitmq.username | quote }}
-            - name: RABBITMQ_PASSWORD
-              valueFrom:
-                secretKeyRef:
-                  name: prod
-                  key: RABBITMQ_PASSWORD
-            - name: RABBITMQ_HOST
-              value: {{ printf "%s.%s.svc.cluster.local" "rabbitmq-cluster" .Release.Namespace | quote }}
-            - name: RABBITMQ_PORT
-              value: {{ .Values.rabbitmq.port | quote }}
-            - name: RABBITMQ_VHOST
-              value: {{ .Values.rabbitmq.vhost | default "/" | quote }}
-            - name: MAIL_QUEUE
-              value: {{ .Values.worker.mailQueueName | default "mail_queue" | quote }}
-            - name: MOJEID_CLIENT_ID
-              valueFrom:
-                secretKeyRef:
-                  name: prod
-                  key: MOJEID_CLIENT_ID
-            - name: MOJEID_CLIENT_SECRET
-              valueFrom:
-                secretKeyRef:
-                  name: prod
-                  key: MOJEID_CLIENT_SECRET
-            - name: BANKID_CLIENT_ID
-              valueFrom:
-                secretKeyRef:
-                  name: prod
-                  key: BANKID_CLIENT_ID
-            - name: BANKID_CLIENT_SECRET
-              valueFrom:
-                secretKeyRef:
-                  name: prod
-                  key: BANKID_CLIENT_SECRET
-            - name: DOMAIN
-              value: {{ required "Set .Values.domain" .Values.domain | quote }}
-            - name: DOMAIN_SCHEME
-              value: {{ required "Set .Values.domain_scheme" .Values.domain_scheme | quote }}
-            - name: FRONTEND_DOMAIN
-              value: {{ required "Set .Values.frontend_domain" .Values.frontend_domain | quote }}
-            - name: FRONTEND_DOMAIN_SCHEME
-              value: {{ required "Set .Values.frontend_domain_scheme" .Values.frontend_domain_scheme | quote }}
-            - name: SENTRY_DSN
-              valueFrom:
-                secretKeyRef:
-                  name: prod
-                  key: SENTRY_DSN
-          livenessProbe:
-            httpGet:
-              path: /
-              port: {{ .Values.app.port }}
-            initialDelaySeconds: 10
-            periodSeconds: 10
-            failureThreshold: 3
-          readinessProbe:
-            httpGet:
-              path: /
-              port: {{ .Values.app.port }}
-            initialDelaySeconds: 10
-            periodSeconds: 10
-            failureThreshold: 3

7project/charts/myapp-chart/templates/database-grant.yaml

@@ -1,18 +0,0 @@
-apiVersion: k8s.mariadb.com/v1alpha1
-kind: Grant
-metadata:
-  name: grant
-spec:
-  mariaDbRef:
-    name: {{ .Values.mariadb.mariaDbRef.name }}
-    namespace: {{ .Values.mariadb.mariaDbRef.namespace }}
-  privileges:
-    - "ALL PRIVILEGES"
-  database: {{ required "Set .Values.deployment" .Values.deployment | quote }}
-  table: "*"
-  username: {{ required "Set .Values.deployment" .Values.deployment | quote }}
-  grantOption: true
-  host: "%"
-  cleanupPolicy: {{ .Values.mariadb.cleanupPolicy }}
-  requeueInterval: {{ .Values.mariadb.requeueInterval | quote }}
-  retryInterval: {{ .Values.mariadb.retryInterval | quote }}

7project/charts/myapp-chart/templates/database-secret.yaml

@@ -1,7 +0,0 @@
-apiVersion: v1
-kind: Secret
-metadata:
-  name: {{ required "Set .Values.database.secretName" .Values.database.secretName }}
-type: kubernetes.io/basic-auth
-stringData:
-  password: {{ required "Set .Values.database.password" .Values.database.password | quote }}

7project/charts/myapp-chart/templates/database-user.yaml

@@ -1,16 +0,0 @@
-apiVersion: k8s.mariadb.com/v1alpha1
-kind: User
-metadata:
-  name: {{ required "Set .Values.deployment" .Values.deployment }}
-spec:
-  mariaDbRef:
-    name: {{ .Values.mariadb.mariaDbRef.name }}
-    namespace: {{ .Values.mariadb.mariaDbRef.namespace }}
-  passwordSecretKeyRef:
-    name: {{ required "Set .Values.database.secretName" .Values.database.secretName }}
-    key: password
-  maxUserConnections: 20
-  host: "%"
-  cleanupPolicy: {{ .Values.mariadb.cleanupPolicy }}
-  requeueInterval: {{ .Values.mariadb.requeueInterval | quote }}
-  retryInterval: {{ .Values.mariadb.retryInterval | quote }}

7project/charts/myapp-chart/templates/database.yaml

@@ -1,14 +0,0 @@
-apiVersion: k8s.mariadb.com/v1alpha1
-kind: Database
-metadata:
-  name: {{ required "Set .Values.deployment" .Values.deployment }}
-spec:
-  mariaDbRef:
-    name: {{ .Values.mariadb.mariaDbRef.name | required "Values mariadb.mariaDbRef.name is required" }}
-    namespace: {{ .Values.mariadb.mariaDbRef.namespace | default .Release.Namespace }}
-  characterSet: utf8
-  collate: utf8_general_ci
-  cleanupPolicy: {{ .Values.mariadb.cleanupPolicy }}
-  requeueInterval: {{ .Values.mariadb.requeueInterval | quote }}
-  retryInterval: {{ .Values.mariadb.retryInterval | quote }}
-

7project/charts/myapp-chart/templates/prod.yaml

@@ -1,18 +0,0 @@
-apiVersion: v1
-kind: Secret
-metadata:
-  name: prod
-type: Opaque
-stringData:
-  MOJEID_CLIENT_ID: {{ .Values.oauth.mojeid.clientId | quote }}
-  MOJEID_CLIENT_SECRET: {{ .Values.oauth.mojeid.clientSecret | quote }}
-  BANKID_CLIENT_ID: {{ .Values.oauth.bankid.clientId | quote }}
-  BANKID_CLIENT_SECRET: {{ .Values.oauth.bankid.clientSecret | quote }}
-  # Database credentials
-  MARIADB_DB: {{ required "Set .Values.deployment" .Values.deployment | quote }}
-  MARIADB_USER: {{ required "Set .Values.deployment" .Values.deployment | quote }}
-  MARIADB_PASSWORD: {{ .Values.database.password | default "" | quote }}
-  # RabbitMQ credentials
-  RABBITMQ_PASSWORD: {{ .Values.rabbitmq.password | default "" | quote }}
-  RABBITMQ_USERNAME: {{ .Values.rabbitmq.username | quote }}
-  SENTRY_DSN: {{ .Values.sentry_dsn | quote }}

7project/charts/myapp-chart/templates/rabbitmq-cluster.yaml

@@ -1,10 +0,0 @@
-apiVersion: rabbitmq.com/v1beta1
-kind: RabbitmqCluster
-metadata:
-  name: "rabbitmq-cluster"
-  namespace: {{ .Release.Namespace }}
-spec:
-  replicas: {{ .Values.rabbitmq.replicas | default 1 }}
-  persistence:
-    storage: {{ .Values.rabbitmq.storage | default "1Gi" }}
-  resources: {}

7project/charts/myapp-chart/templates/rabbitmq-permission.yaml

@@ -1,15 +0,0 @@
-apiVersion: rabbitmq.com/v1beta1
-kind: Permission
-metadata:
-  name: {{ printf "%s-permission" (.Values.rabbitmq.username | default "demo-app") }}
-  namespace: {{ .Release.Namespace }}
-spec:
-  rabbitmqClusterReference:
-    name: rabbitmq-cluster
-    namespace: {{ .Release.Namespace }}
-  vhost: {{ .Values.rabbitmq.vhost | default "/" | quote }}
-  user: {{ .Values.rabbitmq.username | default "demo-app" }}
-  permissions:
-    configure: ".*"
-    read: ".*"
-    write: ".*"

7project/charts/myapp-chart/templates/rabbitmq-queue.yaml

@@ -1,12 +0,0 @@
-apiVersion: rabbitmq.com/v1beta1
-kind: Queue
-metadata:
-  name: {{ .Values.worker.mailQueueName | replace "_" "-" | lower }}
-  namespace: {{ .Release.Namespace }}
-spec:
-  rabbitmqClusterReference:
-    name: rabbitmq-cluster
-    namespace: {{ .Release.Namespace }}
-  name: {{ .Values.worker.mailQueueName }}
-  vhost: {{ .Values.rabbitmq.vhost | default "/" | quote }}
-  durable: true

7project/charts/myapp-chart/templates/rabbitmq-user-secret.yaml

@@ -1,10 +0,0 @@
-{{- if .Values.rabbitmq.password }}
-apiVersion: v1
-kind: Secret
-metadata:
-  name: {{ printf "%s-user-credentials" (.Values.rabbitmq.username | default "app-user") }}
-  namespace: {{ .Release.Namespace }}
-stringData:
-  password: {{ .Values.rabbitmq.password | quote }}
-  username: {{ .Values.rabbitmq.username | quote }}
-{{- end }}

7project/charts/myapp-chart/templates/rabbitmq-user.yaml

@@ -1,13 +0,0 @@
-apiVersion: rabbitmq.com/v1beta1
-kind: User
-metadata:
-  name: {{ .Values.rabbitmq.username | default "demo-app" }}
-  namespace: {{ .Release.Namespace }}
-spec:
-  rabbitmqClusterReference:
-    name: rabbitmq-cluster
-    namespace: {{ .Release.Namespace }}
-  tags:
-    - management
-  importCredentialsSecret:
-    name: {{ printf "%s-user-credentials" (.Values.rabbitmq.username | default "app-user") }}

7project/charts/myapp-chart/templates/service.yaml

@@ -1,10 +0,0 @@
-apiVersion: v1
-kind: Service
-metadata:
-  name: {{ .Values.app.name }}
-spec:
-  ports:
-    - port: {{ .Values.service.port }}
-      targetPort: {{ .Values.app.port }}
-  selector:
-    app: {{ .Values.app.name }}

7project/charts/myapp-chart/templates/tunnel.yaml

@@ -1,14 +0,0 @@
-apiVersion: networking.cfargotunnel.com/v1alpha1
-kind: TunnelBinding
-metadata:
-  name: guestbook-tunnel-binding
-  namespace: {{ .Release.Namespace }}
-subjects:
-  - name: app-server
-    spec:
-      target: {{ printf "http://%s.%s.svc.cluster.local" .Values.app.name .Release.Namespace | quote }}
-      fqdn: {{ required "Set .Values.domain via --set domain=example.com" .Values.domain | quote }}
-      noTlsVerify: true
-tunnelRef:
-  kind: ClusterTunnel
-  name: cluster-tunnel

7project/charts/myapp-chart/templates/worker-deployment.yaml

@@ -1,72 +0,0 @@
-apiVersion: apps/v1
-kind: Deployment
-metadata:
-  name: {{ printf "%s-worker" .Values.app.name }}
-spec:
-  replicas: {{ .Values.worker.replicas }}
-  revisionHistoryLimit: 3
-  selector:
-    matchLabels:
-      app: {{ printf "%s-worker" .Values.app.name }}
-  template:
-    metadata:
-      labels:
-        app: {{ printf "%s-worker" .Values.app.name }}
-    spec:
-      containers:
-        - name: {{ printf "%s-worker" .Values.app.name }}
-          image: "{{- if .Values.image.digest -}}{{ .Values.image.repository }}@{{ .Values.image.digest }}{{- else -}}{{ .Values.image.repository }}:{{ default "latest" .Values.image.tag }}{{- end -}}"
-          imagePullPolicy: {{ .Values.image.pullPolicy }}
-          securityContext:
-            allowPrivilegeEscalation: false
-            capabilities:
-              drop: ["ALL"]
-          command:
-            - celery
-            - -A
-            - app.celery_app
-            - worker
-            - -Q
-            - $(MAIL_QUEUE)
-            - --loglevel
-            - INFO
-          env:
-            - name: MARIADB_HOST
-              value: "mariadb-repl-maxscale-internal.mariadb-operator.svc.cluster.local"
-            - name: MARIADB_PORT
-              value: '3306'
-            - name: MARIADB_DB
-              valueFrom:
-                secretKeyRef:
-                  name: prod
-                  key: MARIADB_DB
-            - name: MARIADB_USER
-              valueFrom:
-                secretKeyRef:
-                  name: prod
-                  key: MARIADB_USER
-            - name: MARIADB_PASSWORD
-              valueFrom:
-                secretKeyRef:
-                  name: prod
-                  key: MARIADB_PASSWORD
-            - name: RABBITMQ_USERNAME
-              value: {{ .Values.rabbitmq.username | quote }}
-            - name: RABBITMQ_PASSWORD
-              valueFrom:
-                secretKeyRef:
-                  name: prod
-                  key: RABBITMQ_PASSWORD
-            - name: RABBITMQ_HOST
-              value: {{ printf "%s.%s.svc.cluster.local" "rabbitmq-cluster" .Release.Namespace | quote }}
-            - name: RABBITMQ_PORT
-              value: {{ .Values.rabbitmq.port | quote }}
-            - name: RABBITMQ_VHOST
-              value: {{ .Values.rabbitmq.vhost | default "/" | quote }}
-            - name: MAIL_QUEUE
-              value: {{ .Values.worker.mailQueueName | default "mail_queue" | quote }}
-            - name: SENTRY_DSN
-              valueFrom:
-                secretKeyRef:
-                  name: prod
-                  key: SENTRY_DSN

7project/charts/myapp-chart/values-dev.yaml

@@ -1,5 +0,0 @@
-env: dev
-
-mariadb:
-  cleanupPolicy: Delete
-

7project/charts/myapp-chart/values-prod.yaml

@@ -1,7 +0,0 @@
-env: prod
-
-app:
-  replicas: 3
-
-worker:
-  replicas: 3

7project/charts/myapp-chart/values.yaml

@@ -1,74 +0,0 @@
-# Base values shared across environments
-env: dev
-
-# Optional PR number used to suffix DB name, set via --set prNumber=123 in CI
-prNumber: ""
-
-# Optional deployment identifier used to suffix resource names (db, user, secret)
-# Example: --set deployment=alice or --set deployment=feature123
-deployment: ""
-
-# Public domain to expose the app under (used by TunnelBinding fqdn)
-# Set at install time: --set domain=example.com
-domain: ""
-domain_scheme: ""
-
-frontend_domain: ""
-frontend_domain_scheme: ""
-
-sentry_dsn: ""
-
-image:
-  repository: lukastrkan/cc-app-demo
-  # You can use a tag or digest. If digest is provided, it takes precedence.
-  digest: ""
-  pullPolicy: IfNotPresent
-
-app:
-  name: "finance-tracker"
-  replicas: 1
-  port: 8000
-
-worker:
-  name: app-demo-worker
-  replicas: 1
-  # Queue name for Celery worker and for CRD Queue
-  mailQueueName: "mail_queue"
-
-
-service:
-  port: 80
-
-oauth:
-  bankid:
-    clientId: ""
-    clientSecret: ""
-  mojeid:
-    clientId: ""
-    clientSecret: ""
-
-rabbitmq:
-  create: true
-  replicas: 1
-  storage: 5Gi
-  # Optional: override the generated cluster name; default is "<app.name>-rabbit[-<deployment>]"
-  clusterName: ""
-  port: "5672"
-  username: demo-app
-  password: ""
-  vhost: "/"
-
-mariadb:
-  name: app-demo-database
-  cleanupPolicy: Skip
-  requeueInterval: 10h
-  retryInterval: 30s
-  mariaDbRef:
-    name: mariadb-repl
-    namespace: mariadb-operator
-
-# Database access resources
-database:
-  userName: app-demo-user
-  secretName: app-demo-database-secret
-  password: ""

7project/checklist.md

@@ -1,81 +0,0 @@
-# Project Evaluation Checklist
-
-The group earn points by completing items from the categories below.
-You are not expected to complete all items.
-Focus on areas that align with your project goals and interests.
-
-The core deliverables are required.
-This means that you must get at least 2 points for each item in this category.
-
-| **Category**                     | **Item**                                | **Max Points** | **Points**       |
-| -------------------------------- | --------------------------------------- | -------------- | ---------------- |
-| **Core Deliverables (Required)** |                                         |                |                  |
-| Codebase & Organization          | Well-organized project structure        | 5              |                  |
-|                                  | Clean, readable code                    | 5              |                  |
-|                                  | Use planning tool (e.g., GitHub issues) | 5              |                  |
-|                                  | Proper version control usage            | 5              |                  |
-|                                  | Complete source code                    | 5              |                  |
-| Documentation                    | Comprehensive reproducibility report    | 10             |                  |
-|                                  | Updated design document                 | 5              |                  |
-|                                  | Clear build/deployment instructions     | 5              |                  |
-|                                  | Troubleshooting guide                   | 5              |                  |
-|                                  | Completed self-assessment table         | 5              |                  |
-|                                  | Hour sheets for all members             | 5              |                  |
-| Presentation Video               | Project demonstration                   | 5              |                  |
-|                                  | Code walk-through                       | 5              |                  |
-|                                  | Deployment showcase                     | 5              |                  |
-| **Technical Implementation**     |                                         |                |                  |
-| Application Functionality        | Basic functionality works               | 10             |                  |
-|                                  | Advanced features implemented           | 10             |                  |
-|                                  | Error handling & robustness             | 10             |                  |
-|                                  | User-friendly interface                 | 5              |                  |
-| Backend & Architecture           | Stateless web server                    | 5              |                  |
-|                                  | Stateful application                    | 10             |                  |
-|                                  | Database integration                    | 10             |                  |
-|                                  | API design                              | 5              |                  |
-|                                  | Microservices architecture              | 10             |                  |
-| Cloud Integration                | Basic cloud deployment                  | 10             |                  |
-|                                  | Cloud APIs usage                        | 10             |                  |
-|                                  | Serverless components                   | 10             |                  |
-|                                  | Advanced cloud services                 | 5              |                  |
-| **DevOps & Deployment**          |                                         |                |                  |
-| Containerization                 | Basic Dockerfile                        | 5              |                  |
-|                                  | Optimized Dockerfile                    | 5              |                  |
-|                                  | Docker Compose                          | 5              |                  |
-|                                  | Persistent storage                      | 5              |                  |
-| Deployment & Scaling             | Manual deployment                       | 5              |                  |
-|                                  | Automated deployment                    | 5              |                  |
-|                                  | Multiple replicas                       | 5              |                  |
-|                                  | Kubernetes deployment                   | 10             |                  |
-| **Quality Assurance**            |                                         |                |                  |
-| Testing                          | Unit tests                              | 5              |                  |
-|                                  | Integration tests                       | 5              |                  |
-|                                  | End-to-end tests                        | 5              |                  |
-|                                  | Performance testing                     | 5              |                  |
-| Monitoring & Operations          | Health checks                           | 5              |                  |
-|                                  | Logging                                 | 5              |                  |
-|                                  | Metrics/Monitoring                      | 5              |                  |
-| Security                         | HTTPS/TLS                               | 5              |                  |
-|                                  | Authentication                          | 5              |                  |
-|                                  | Authorization                           | 5              |                  |
-| **Innovation & Excellence**      |                                         |                |                  |
-| Advanced Features and            | AI/ML Integration                       | 10             |                  |
-| Technical Excellence             | Real-time features                      | 10             |                  |
-|                                  | Creative problem solving                | 10             |                  |
-|                                  | Performance optimization                | 5              |                  |
-|                                  | Exceptional user experience             | 5              |                  |
-| **Total**                        |                                         | **255**        | **[Your Total]** |
-
-## Grading Scale
-
-- **Minimum Required: 100 points**
-- **Maximum: 200+ points**
-
-| Grade | Points   |
-| ----- | -------- |
-| A     | 180-200+ |
-| B     | 160-179  |
-| C     | 140-159  |
-| D     | 120-139  |
-| E     | 100-119  |
-| F     | 0-99     |

7project/frontend/src/App.css

@@ -1 +0,0 @@
-/* App-level styles moved to ui.css for a cleaner layout. */

7project/frontend/src/App.tsx

@@ -1,39 +0,0 @@
-import { useEffect, useState } from 'react';
-import './App.css';
-import LoginRegisterPage from './pages/LoginRegisterPage';
-import Dashboard from './pages/Dashboard';
-import { logout } from './api';
-
-function App() {
-  const [hasToken, setHasToken] = useState<boolean>(!!localStorage.getItem('token'));
-
-  useEffect(() => {
-    // Handle OAuth callback: /oauth-callback?access_token=...&token_type=...
-    if (window.location.pathname === '/oauth-callback') {
-      const params = new URLSearchParams(window.location.search);
-      const token = params.get('access_token');
-      if (token) {
-        localStorage.setItem('token', token);
-        setHasToken(true);
-      }
-      // Clean URL and redirect to home
-      window.history.replaceState({}, '', '/');
-    }
-
-    const onStorage = (e: StorageEvent) => {
-      if (e.key === 'token') setHasToken(!!e.newValue);
-    };
-    window.addEventListener('storage', onStorage);
-    return () => window.removeEventListener('storage', onStorage);
-  }, []);
-
-  if (!hasToken) {
-    return <LoginRegisterPage onLoggedIn={() => setHasToken(true)} />;
-  }
-
-  return (
-    <Dashboard onLogout={() => { logout(); setHasToken(false); }} />
-  );
-}
-
-export default App;

7project/frontend/src/api.ts

@@ -1,155 +0,0 @@
-import { BACKEND_URL } from './config';
-
-export type LoginResponse = {
-  access_token: string;
-  token_type: string;
-};
-
-export type Category = {
-  id: number;
-  name: string;
-  description?: string | null;
-};
-
-export type Transaction = {
-  id: number;
-  amount: number;
-  description?: string | null;
-  category_ids: number[];
-};
-
-function getBaseUrl() {
-  const base = BACKEND_URL?.replace(/\/$/, '') || '';
-  return base || '';
-}
-
-function getHeaders(contentType: 'json' | 'form' | 'none' = 'json'): Record<string, string> {
-  const token = localStorage.getItem('token');
-  const headers: Record<string, string> = {};
-
-  if (contentType === 'json') {
-    headers['Content-Type'] = 'application/json';
-  } else if (contentType === 'form') {
-    headers['Content-Type'] = 'application/x-www-form-urlencoded';
-  }
-
-  if (token) {
-    headers['Authorization'] = `Bearer ${token}`;
-  }
-
-  return headers;
-}
-
-export async function login(email: string, password: string): Promise<void> {
-  const body = new URLSearchParams();
-  body.set('username', email);
-  body.set('password', password);
-
-  const res = await fetch(`${getBaseUrl()}/auth/jwt/login`, {
-    method: 'POST',
-    headers: {
-      'Content-Type': 'application/x-www-form-urlencoded',
-    },
-    body: body.toString(),
-  });
-  if (!res.ok) {
-    const text = await res.text();
-    throw new Error(text || 'Login failed');
-  }
-  const data: LoginResponse = await res.json();
-  localStorage.setItem('token', data.access_token);
-}
-
-export async function register(email: string, password: string, first_name?: string, last_name?: string): Promise<void> {
-  const res = await fetch(`${getBaseUrl()}/auth/register`, {
-    method: 'POST',
-    headers: { 'Content-Type': 'application/json' },
-    body: JSON.stringify({ email, password, first_name, last_name }),
-  });
-  if (!res.ok) {
-    const text = await res.text();
-    throw new Error(text || 'Registration failed');
-  }
-}
-
-export async function getCategories(): Promise<Category[]> {
-  const res = await fetch(`${getBaseUrl()}/categories/`, {
-    headers: getHeaders(),
-  });
-  if (!res.ok) throw new Error('Failed to load categories');
-  return res.json();
-}
-
-export type CreateTransactionInput = {
-  amount: number;
-  description?: string;
-  category_ids?: number[];
-};
-
-export async function createTransaction(input: CreateTransactionInput): Promise<Transaction> {
-  const res = await fetch(`${getBaseUrl()}/transactions/create`, {
-    method: 'POST',
-    headers: getHeaders(),
-    body: JSON.stringify(input),
-  });
-  if (!res.ok) {
-    const text = await res.text();
-    throw new Error(text || 'Failed to create transaction');
-  }
-  return res.json();
-}
-
-export async function getTransactions(): Promise<Transaction[]> {
-    const res = await fetch(`${getBaseUrl()}/transactions/`, {
-    headers: getHeaders(),
-  });
-  if (!res.ok) throw new Error('Failed to load transactions');
-  return res.json();
-}
-
-export type User = {
-  id: string;
-  email: string;
-  first_name?: string | null;
-  last_name?: string | null;
-  is_active: boolean;
-  is_superuser: boolean;
-  is_verified: boolean;
-};
-
-export async function getMe(): Promise<User> {
-  const res = await fetch(`${getBaseUrl()}/users/me`, {
-    headers: getHeaders(),
-  });
-  if (!res.ok) throw new Error('Failed to load user');
-  return res.json();
-}
-
-export type UpdateMeInput = Partial<Pick<User, 'first_name' | 'last_name'>> & { password?: string };
-export async function updateMe(input: UpdateMeInput): Promise<User> {
-  const res = await fetch(`${getBaseUrl()}/users/me`, {
-    method: 'PATCH',
-    headers: getHeaders(),
-    body: JSON.stringify(input),
-  });
-  if (!res.ok) {
-    const text = await res.text();
-    throw new Error(text || 'Failed to update user');
-  }
-  return res.json();
-}
-
-export async function deleteMe(): Promise<void> {
-  const res = await fetch(`${getBaseUrl()}/users/me`, {
-    method: 'DELETE',
-    headers: getHeaders(),
-  });
-  if (!res.ok) {
-    const text = await res.text();
-    throw new Error(text || 'Failed to delete account');
-  }
-}
-
-export function logout() {
-  localStorage.removeItem('token');
-}

7project/frontend/src/appearance.ts

@@ -1,38 +0,0 @@
-export type Theme = 'system' | 'light' | 'dark';
-export type FontSize = 'small' | 'medium' | 'large';
-
-const THEME_KEY = 'app_theme';
-const FONT_KEY = 'app_font_size';
-
-export function applyTheme(theme: Theme) {
-  const body = document.body;
-  const effective = theme === 'system' ? (window.matchMedia && window.matchMedia('(prefers-color-scheme: dark)').matches ? 'dark' : 'light') : theme;
-  body.setAttribute('data-theme', effective);
-}
-
-export function applyFontSize(size: FontSize) {
-  const root = document.documentElement;
-  const map: Record<FontSize, string> = {
-    small: '14px',
-    medium: '16px',
-    large: '18px',
-  };
-  root.style.fontSize = map[size];
-}
-
-export function saveAppearance(theme: Theme, size: FontSize) {
-  localStorage.setItem(THEME_KEY, theme);
-  localStorage.setItem(FONT_KEY, size);
-}
-
-export function loadAppearance(): { theme: Theme; size: FontSize } {
-  const theme = (localStorage.getItem(THEME_KEY) as Theme) || 'light';
-  const size = (localStorage.getItem(FONT_KEY) as FontSize) || 'medium';
-  return { theme, size };
-}
-
-export function applyAppearanceFromStorage() {
-  const { theme, size } = loadAppearance();
-  applyTheme(theme);
-  applyFontSize(size);
-}

7project/frontend/src/config.ts

@@ -1,2 +0,0 @@
-export const BACKEND_URL: string =
-  import.meta.env.VITE_BACKEND_URL ?? '';

7project/frontend/src/pages/AccountPage.tsx

@@ -1,87 +0,0 @@
-import { useEffect, useState } from 'react';
-import { deleteMe, getMe, type UpdateMeInput, type User, updateMe } from '../api';
-
-export default function AccountPage({ onDeleted }: { onDeleted: () => void }) {
-  const [user, setUser] = useState<User | null>(null);
-  const [firstName, setFirstName] = useState('');
-  const [lastName, setLastName] = useState('');
-  const [loading, setLoading] = useState(true);
-  const [saving, setSaving] = useState(false);
-  const [error, setError] = useState<string | null>(null);
-
-  useEffect(() => {
-    (async () => {
-      try {
-        const u = await getMe();
-        setUser(u);
-        setFirstName(u.first_name || '');
-        setLastName(u.last_name || '');
-      } catch (e: any) {
-        setError(e?.message || 'Failed to load account');
-      } finally {
-        setLoading(false);
-      }
-    })();
-  }, []);
-
-  async function handleSave(e: React.FormEvent) {
-    e.preventDefault();
-    setSaving(true);
-    setError(null);
-    try {
-      const payload: UpdateMeInput = { first_name: firstName || null as any, last_name: lastName || null as any };
-      const updated = await updateMe(payload);
-      setUser(updated);
-    } catch (e: any) {
-      setError(e?.message || 'Failed to update');
-    } finally {
-      setSaving(false);
-    }
-  }
-
-  async function handleDelete() {
-    if (!confirm('Are you sure you want to delete your account? This cannot be undone.')) return;
-    try {
-      await deleteMe();
-      onDeleted();
-    } catch (e: any) {
-      alert(e?.message || 'Failed to delete account');
-    }
-  }
-
-  return (
-    <section className="card">
-      <h3>Account</h3>
-      {loading ? (
-        <div>Loading…</div>
-      ) : error ? (
-        <div style={{ color: 'crimson' }}>{error}</div>
-      ) : !user ? (
-        <div>Not signed in</div>
-      ) : (
-        <div className="space-y">
-          <div className="muted">Email: <strong>{user.email}</strong></div>
-          <form onSubmit={handleSave} className="space-y">
-            <div className="form-row">
-              <div>
-                <label className="muted">First name</label>
-                <input className="input" value={firstName} onChange={(e) => setFirstName(e.target.value)} />
-              </div>
-              <div>
-                <label className="muted">Last name</label>
-                <input className="input" value={lastName} onChange={(e) => setLastName(e.target.value)} />
-              </div>
-            </div>
-            <div className="actions" style={{ justifyContent: 'flex-end' }}>
-              <button className="btn primary" type="submit" disabled={saving}>{saving ? 'Saving…' : 'Save changes'}</button>
-            </div>
-          </form>
-          <div className="actions" style={{ justifyContent: 'space-between' }}>
-            <div className="muted"></div>
-            <button className="btn" style={{ borderColor: 'crimson', color: 'crimson' }} onClick={handleDelete}>Delete account</button>
-          </div>
-        </div>
-      )}
-    </section>
-  );
-}

7project/frontend/src/pages/AppearancePage.tsx

@@ -1,49 +0,0 @@
-import { useEffect, useState } from 'react';
-import { applyFontSize, applyTheme, loadAppearance, saveAppearance, type FontSize, type Theme } from '../appearance';
-
-export default function AppearancePage() {
-  const [theme, setTheme] = useState<Theme>('light');
-  const [size, setSize] = useState<FontSize>('medium');
-
-  useEffect(() => {
-    const { theme, size } = loadAppearance();
-    setTheme(theme);
-    setSize(size);
-  }, []);
-
-  function onThemeChange(next: Theme) {
-    setTheme(next);
-    applyTheme(next);
-    saveAppearance(next, size);
-  }
-
-  function onSizeChange(next: FontSize) {
-    setSize(next);
-    applyFontSize(next);
-    saveAppearance(theme, next);
-  }
-
-  return (
-    <section className="card">
-      <h3>Appearance</h3>
-      <div className="space-y">
-        <div>
-          <div className="muted" style={{ marginBottom: 6 }}>Theme</div>
-          <div className="segmented">
-            <button className={theme === 'light' ? 'active' : ''} onClick={() => onThemeChange('light')}>Light</button>
-            <button className={theme === 'dark' ? 'active' : ''} onClick={() => onThemeChange('dark')}>Dark</button>
-            <button className={theme === 'system' ? 'active' : ''} onClick={() => onThemeChange('system')}>System</button>
-          </div>
-        </div>
-        <div>
-          <div className="muted" style={{ marginBottom: 6 }}>Font size</div>
-          <div className="segmented">
-            <button className={size === 'small' ? 'active' : ''} onClick={() => onSizeChange('small')}>Small</button>
-            <button className={size === 'medium' ? 'active' : ''} onClick={() => onSizeChange('medium')}>Medium</button>
-            <button className={size === 'large' ? 'active' : ''} onClick={() => onSizeChange('large')}>Large</button>
-          </div>
-        </div>
-      </div>
-    </section>
-  );
-}

7project/frontend/src/pages/Dashboard.tsx

@@ -1,172 +0,0 @@
-import { useEffect, useMemo, useState } from 'react';
-import { type Category, type Transaction, createTransaction, getCategories, getTransactions } from '../api';
-import AccountPage from './AccountPage';
-import AppearancePage from './AppearancePage';
-
-function formatAmount(n: number) {
-  return new Intl.NumberFormat(undefined, { minimumFractionDigits: 2, maximumFractionDigits: 2 }).format(n);
-}
-
-export default function Dashboard({ onLogout }: { onLogout: () => void }) {
-  const [current, setCurrent] = useState<'home' | 'account' | 'appearance'>('home');
-  const [transactions, setTransactions] = useState<Transaction[]>([]);
-  const [categories, setCategories] = useState<Category[]>([]);
-  const [loading, setLoading] = useState(true);
-  const [error, setError] = useState<string | null>(null);
-
-  // New transaction form state
-  const [amount, setAmount] = useState<string>('');
-  const [description, setDescription] = useState('');
-  const [selectedCategoryId, setSelectedCategoryId] = useState<number | ''>('');
-
-  // Filters
-  const [minAmount, setMinAmount] = useState<string>('');
-  const [maxAmount, setMaxAmount] = useState<string>('');
-  const [filterCategoryId, setFilterCategoryId] = useState<number | ''>('');
-  const [searchText, setSearchText] = useState('');
-
-  async function loadAll() {
-    setLoading(true);
-    setError(null);
-    try {
-      const [txs, cats] = await Promise.all([getTransactions(), getCategories()]);
-      setTransactions(txs);
-      setCategories(cats);
-    } catch (err: any) {
-      setError(err?.message || 'Failed to load data');
-    } finally {
-      setLoading(false);
-    }
-  }
-
-  useEffect(() => { loadAll(); }, []);
-
-  const last10 = useMemo(() => {
-    const sorted = [...transactions].sort((a, b) => b.id - a.id);
-    return sorted.slice(0, 10);
-  }, [transactions]);
-
-  const filtered = useMemo(() => {
-    let arr = last10;
-    const min = minAmount !== '' ? Number(minAmount) : undefined;
-    const max = maxAmount !== '' ? Number(maxAmount) : undefined;
-    if (min !== undefined) arr = arr.filter(t => t.amount >= min);
-    if (max !== undefined) arr = arr.filter(t => t.amount <= max);
-    if (filterCategoryId !== '') arr = arr.filter(t => t.category_ids.includes(filterCategoryId as number));
-    if (searchText.trim()) arr = arr.filter(t => (t.description || '').toLowerCase().includes(searchText.toLowerCase()));
-    return arr;
-  }, [last10, minAmount, maxAmount, filterCategoryId, searchText]);
-
-  function categoryNameById(id: number) { return categories.find(c => c.id === id)?.name || `#${id}`; }
-
-  async function handleCreate(e: React.FormEvent) {
-    e.preventDefault();
-    if (!amount) return;
-    const payload = {
-      amount: Number(amount),
-      description: description || undefined,
-      category_ids: selectedCategoryId !== '' ? [Number(selectedCategoryId)] : undefined,
-    };
-    try {
-      const created = await createTransaction(payload);
-      setTransactions(prev => [created, ...prev]);
-      setAmount(''); setDescription(''); setSelectedCategoryId('');
-    } catch (err: any) {
-      alert(err?.message || 'Failed to create transaction');
-    }
-  }
-
-  return (
-    <div className="app-layout">
-      <aside className="sidebar">
-        <div className="logo">7Project</div>
-        <nav className="nav">
-          <button className={current === 'home' ? 'active' : ''} onClick={() => setCurrent('home')}>Home</button>
-          <button className={current === 'account' ? 'active' : ''} onClick={() => setCurrent('account')}>Account</button>
-          <button className={current === 'appearance' ? 'active' : ''} onClick={() => setCurrent('appearance')}>Appearance</button>
-        </nav>
-      </aside>
-      <div className="content">
-        <div className="topbar">
-          <h2 style={{ margin: 0 }}>{current === 'home' ? 'Dashboard' : current === 'account' ? 'Account' : 'Appearance'}</h2>
-          <div className="actions">
-            <span className="user muted">Signed in</span>
-            <button className="btn" onClick={onLogout}>Logout</button>
-          </div>
-        </div>
-        <main className="page space-y">
-          {current === 'home' && (
-            <>
-              <section className="card">
-                <h3>Add Transaction</h3>
-                <form onSubmit={handleCreate} className="form-row">
-                  <input className="input" type="number" step="0.01" placeholder="Amount" value={amount} onChange={(e) => setAmount(e.target.value)} required />
-                  <input className="input" type="text" placeholder="Description (optional)" value={description} onChange={(e) => setDescription(e.target.value)} />
-                  <select className="input" value={selectedCategoryId} onChange={(e) => setSelectedCategoryId(e.target.value ? Number(e.target.value) : '')}>
-                    <option value="">No category</option>
-                    {categories.map(c => (<option key={c.id} value={c.id}>{c.name}</option>))}
-                  </select>
-                  <button className="btn primary" type="submit">Add</button>
-                </form>
-              </section>
-
-              <section className="card">
-                <h3>Filters</h3>
-                <div className="form-row">
-                  <input className="input" type="number" step="0.01" placeholder="Min amount" value={minAmount} onChange={(e) => setMinAmount(e.target.value)} />
-                  <input className="input" type="number" step="0.01" placeholder="Max amount" value={maxAmount} onChange={(e) => setMaxAmount(e.target.value)} />
-                  <select className="input" value={filterCategoryId} onChange={(e) => setFilterCategoryId(e.target.value ? Number(e.target.value) : '')}>
-                    <option value="">All categories</option>
-                    {categories.map(c => (<option key={c.id} value={c.id}>{c.name}</option>))}
-                  </select>
-                  <input className="input" type="text" placeholder="Search in description" value={searchText} onChange={(e) => setSearchText(e.target.value)} />
-                </div>
-              </section>
-
-              <section className="card">
-                <h3>Latest Transactions (last 10)</h3>
-                {loading ? (
-                  <div>Loading…</div>
-                ) : error ? (
-                  <div style={{ color: 'crimson' }}>{error}</div>
-                ) : filtered.length === 0 ? (
-                  <div>No transactions</div>
-                ) : (
-                  <table className="table">
-                    <thead>
-                      <tr>
-                        <th>ID</th>
-                        <th style={{ textAlign: 'right' }}>Amount</th>
-                        <th>Description</th>
-                        <th>Categories</th>
-                      </tr>
-                    </thead>
-                    <tbody>
-                      {filtered.map(t => (
-                        <tr key={t.id}>
-                          <td>{t.id}</td>
-                          <td className="amount">{formatAmount(t.amount)}</td>
-                          <td>{t.description || ''}</td>
-                          <td>{t.category_ids.map(id => categoryNameById(id)).join(', ')}</td>
-                        </tr>
-                      ))}
-                    </tbody>
-                  </table>
-                )}
-              </section>
-            </>
-          )}
-
-          {current === 'account' && (
-            // lazy import avoided for simplicity
-            <AccountPage onDeleted={onLogout} />
-          )}
-
-          {current === 'appearance' && (
-            <AppearancePage />
-          )}
-        </main>
-      </div>
-    </div>
-  );
-}

7project/frontend/src/pages/LoginRegisterPage.tsx

@@ -1,96 +0,0 @@
-import { useState, useEffect } from 'react';
-import { login, register } from '../api';
-import { BACKEND_URL } from '../config';
-
-function oauthUrl(provider: 'mojeid' | 'bankid') {
-  const base = BACKEND_URL.replace(/\/$/, '');
-  const redirect = encodeURIComponent(window.location.origin + '/oauth-callback');
-  return `${base}/auth/${provider}/authorize?redirect_url=${redirect}`;
-}
-
-export default function LoginRegisterPage({ onLoggedIn }: { onLoggedIn: () => void }) {
-  const [mode, setMode] = useState<'login' | 'register'>('login');
-  const [email, setEmail] = useState('');
-  const [password, setPassword] = useState('');
-  const [firstName, setFirstName] = useState('');
-  const [lastName, setLastName] = useState('');
-  const [loading, setLoading] = useState(false);
-  const [error, setError] = useState<string | null>(null);
-
-  async function handleSubmit(e: React.FormEvent) {
-    e.preventDefault();
-    setLoading(true);
-    setError(null);
-    try {
-      if (mode === 'login') {
-        await login(email, password);
-        onLoggedIn();
-      } else {
-        await register(email, password, firstName || undefined, lastName || undefined);
-        // After register, prompt login automatically
-        await login(email, password);
-        onLoggedIn();
-      }
-    } catch (err: any) {
-      setError(err?.message || 'Operation failed');
-    } finally {
-      setLoading(false);
-    }
-  }
-
-  // Add this useEffect hook
-  useEffect(() => {
-    // When the component mounts, add a class to the body
-    document.body.classList.add('auth-page');
-
-    // When the component unmounts, remove the class
-    return () => {
-      document.body.classList.remove('auth-page');
-    };
-  }, []); // The empty array ensures this runs only once
-
-  // The JSX no longer needs the wrapper div
-  return (
-    <div className="card" style={{ width: 420 }}>
-      <div style={{ display: 'flex', alignItems: 'center', justifyContent: 'space-between', marginBottom: 12 }}>
-        <h2 style={{ margin: 0 }}>{mode === 'login' ? 'Welcome back' : 'Create your account'}</h2>
-        <div className="segmented">
-          <button className={mode === 'login' ? 'active' : ''} type="button" onClick={() => setMode('login')}>Login</button>
-          <button className={mode === 'register' ? 'active' : ''} type="button" onClick={() => setMode('register')}>Register</button>
-        </div>
-      </div>
-      <form onSubmit={handleSubmit} className="space-y">
-        <div>
-            <label className="muted">Email</label>
-            <input className="input" type="email" required value={email} onChange={(e) => setEmail(e.target.value)} />
-          </div>
-          <div>
-            <label className="muted">Password</label>
-            <input className="input" type="password" required value={password} onChange={(e) => setPassword(e.target.value)} />
-          </div>
-          {mode === 'register' && (
-            <div className="form-row">
-              <div>
-                <label className="muted">First name (optional)</label>
-                <input className="input" type="text" value={firstName} onChange={(e) => setFirstName(e.target.value)} />
-              </div>
-              <div>
-                <label className="muted">Last name (optional)</label>
-                <input className="input" type="text" value={lastName} onChange={(e) => setLastName(e.target.value)} />
-              </div>
-            </div>
-          )}
-          {error && <div style={{ color: 'crimson' }}>{error}</div>}
-          <div className="actions" style={{ justifyContent: 'space-between' }}>
-            <div className="muted">Or continue with</div>
-            <div className="actions">
-              <a className="btn" href={oauthUrl('mojeid')}>MojeID</a>
-              <a className="btn" href={oauthUrl('bankid')}>BankID</a>
-              <button className="btn primary" type="submit" disabled={loading}>{loading ? 'Please wait…' : (mode === 'login' ? 'Login' : 'Register')}</button>
-            </div>
-          </div>
-      </form>
-    </div>
-  );
-}
-

7project/frontend/src/ui.css

@@ -1,85 +0,0 @@
-:root {
-  --bg: #f7f7fb;
-  --panel: #ffffff;
-  --text: #9aa3b2;
-  --muted: #6b7280;
-  --primary: #6f49fe;
-  --primary-600: #5a37fb;
-  --border: #e5e7eb;
-  --radius: 12px;
-  --shadow: 0 1px 2px rgba(0,0,0,0.04), 0 8px 24px rgba(0,0,0,0.08);
-
-  font-family: Inter, ui-sans-serif, system-ui, -apple-system, Segoe UI, Roboto, Helvetica, Arial, "Apple Color Emoji", "Segoe UI Emoji";
-  color: var(--text);
-}
-
-* { box-sizing: border-box; }
-
-html, body, #root { height: 100%; }
-
-body { background: var(--bg); margin: 0; display: block; }
-
-/* Dark theme variables */
-body[data-theme="dark"] {
-  --bg: #161a2b;
-  --panel: #283046;
-  --text: #283046;
-  --muted: #cbd5e1;
-  --primary: #8b7bff;
-  --primary-600: #7b69ff;
-  --border: #283046;
-}
-
-/* Layout */
-.app-layout { display: grid; grid-template-columns: 260px 1fr; height: 100%; }
-.sidebar { background: #15172a; color: #e5e7eb; display: flex; flex-direction: column; padding: 20px 12px; }
-.sidebar .logo { color: #fff; font-weight: 700; font-size: 18px; padding: 12px 14px; display: flex; align-items: center; gap: 10px; }
-.nav { margin-top: 12px; display: grid; gap: 4px; }
-.nav a, .nav button { color: #cbd5e1; text-align: left; background: transparent; border: 0; padding: 10px 12px; border-radius: 8px; cursor: pointer; }
-.nav a.active, .nav a:hover, .nav button:hover { background: rgba(255,255,255,0.08); color: #fff; }
-
-.content { display: flex; flex-direction: column; height: 100%; }
-.topbar { height: 64px; display: flex; align-items: center; justify-content: space-between; padding: 0 24px; background: var(--panel); border-bottom: 1px solid var(--border); }
-.topbar .user { color: var(--muted); }
-.page { padding: 24px; max-width: 1100px; margin: auto; }
-
-/* Cards */
-.card { background: var(--panel); border: 1px solid var(--border); border-radius: var(--radius); box-shadow: var(--shadow); padding: 16px; }
-.card h3 { margin: 0 0 12px; }
-
-/* Forms */
-.input, select, textarea { width: 100%; padding: 10px 12px; border-radius: 10px; border: 1px solid var(--border); background: #fff; color: var(--text); }
-.input:focus, select:focus, textarea:focus { outline: 2px solid var(--primary); border-color: var(--primary); }
-.form-row { display: grid; gap: 8px; grid-template-columns: repeat(4, minmax(0,1fr)); }
-.form-row > * { min-width: 140px; }
-.actions { display: flex; align-items: center; gap: 8px; }
-
-/* Buttons */
-.btn { border: 1px solid var(--border); background: #fff; color: var(--text); padding: 10px 14px; border-radius: 10px; cursor: pointer; }
-.btn.primary { background: var(--primary); border-color: var(--primary); color: #fff; }
-.btn.primary:hover { background: var(--primary-600); }
-.btn.ghost { background: transparent; color: var(--muted); }
-
-/* Tables */
-.table { width: 100%; border-collapse: collapse; }
-.table th, .table td { padding: 10px; border-bottom: 1px solid var(--border); }
-.table th { text-align: left; color: var(--muted); font-weight: 600; }
-.table td.amount { text-align: right; font-variant-numeric: tabular-nums; }
-
-/* Segmented control */
-.segmented { display: inline-flex; background: #f1f5f9; border-radius: 10px; padding: 4px; border: 1px solid var(--border); }
-.segmented button { border: 0; background: transparent; padding: 8px 12px; border-radius: 8px; color: var(--muted); cursor: pointer; }
-.segmented button.active { background: #fff; color: var(--text); box-shadow: var(--shadow); }
-
-/* Auth layout */
-body.auth-page #root {
-  display: flex;
-  align-items: center;
-  justify-content: center;
-  min-height: 100vh;
-  width: 100%;
-}
-
-/* Utility */
-.muted { color: var(--muted); }
-.space-y > * + * { margin-top: 12px; }

7project/meetings/2025-10-16-meeting.md

@@ -1,53 +0,0 @@
-# Weekly Meeting Notes
-
-- Group 8 - Personal finance tracker
-- Mentor: Jaychander
-
-Keep all meeting notes in the `meetings.md` file in your project folder.
-Just copy the template below for each weekly meeting and fill in the details.
-
-## Administrative Info
-
-- Date: 2025-10-08
-- Attendees: Dejan Ribarovski, Lukas Trkan
-- Notetaker: Dejan Ribarovski
-
-## Progress Update (Before Meeting)
-
-Summary of what has been accomplished since the last meeting in the following categories.
-
-## Action Items from Last Week (During Meeting)
-
-- [x] start coding the app logic
-- [x] start writing the report so it matches the actual progress
-- [x] redo the system diagram so it includes a response flow
-
-### Coding
-Implemented initial functioning version of the app, added OAuth with BankId and MojeID,
-added database snapshots.
-
-### Documentation
-report.md is up to date
-
-## Questions and Topics for Discussion (Before Meeting)
-
-Prepare 3-5 questions and topics you want to discuss with your mentor.
-
-1. What other functionality should be added to the app
-2. Priority for the next week (Testing maybe?)
-3. Question 3
-
-## Discussion Notes (During Meeting)
-
-## Action Items for Next Week (During Meeting)
-
-Last 3 minutes of the meeting, summarize action items.
-
-- [ ] OAuth
-- [ ] CI/CD fix
-- [ ] Database local (multiple bank accounts)
-- [ ] Add tests and set up github pipeline
-- [ ] Frontend imporvment - user experience
-- [ ] make the report more clear
-
----

7project/meetings/2025-10-9-meeting.md

@@ -1,54 +0,0 @@
-# Weekly Meeting Notes
-
-- Group 8 - Personal finance tracker
-- Mentor: Jaychander
-
-Keep all meeting notes in the `meetings.md` file in your project folder.
-Just copy the template below for each weekly meeting and fill in the details.
-
-## Administrative Info
-
-- Date: 2025-10-08
-- Attendees: Dejan Ribarovski, Lukas Trkan
-- Notetaker: Dejan Ribarovski
-
-## Progress Update (Before Meeting)
-
-Summary of what has been accomplished since the last meeting in the following categories.
-
-### Coding
-
-Lukas has implemented the template source directories, source files and config files necessary for deployment 
-- docker compose for database, redis cache and rabbit MQ
-- tofu
-- backend template
-- frontend template
-- charts templates
-
-### Documentation
-- Created GitHub issues for the next steps 
-- Added this document + checklist and report
-
-## Questions and Topics for Discussion (Before Meeting)
-
-Prepare 3-5 questions and topics you want to discuss with your mentor.
-
-1. Anything we should add structure-wise?
-2. Anything you would like us to prioritize until next week?
-
-## Discussion Notes (During Meeting)
-
-- start working on the report
-- start coding the actual code
-- write problems solved
-- redo the system diagram - see the response as well
-- create a meetings folder wih seperate meetings files
-## Action Items for Next Week (During Meeting)
-
-Last 3 minutes of the meeting, summarize action items.
-
-- [ ] start coding the app logic
-- [ ] start writing the report so it matches the actual progress
-- [ ] redo the system diagram so it includes a response flow
-
----

7project/meetings/meeting-template.md

@@ -1,41 +0,0 @@
-# Weekly Meeting Notes
-
-- Group X - Project Title
-- Mentor: Mentor Name
-
-Keep all meeting notes in the `meetings.md` file in your project folder.
-Just copy the template below for each weekly meeting and fill in the details.
-
-## Administrative Info
-
-- Date: 2025-09-19
-- Attendees: Name1, Name2, Name3
-- Notetaker: Name1
-
-## Progress Update (Before Meeting)
-
-Summary of what has been accomplished since the last meeting in the following categories.
-
-### Coding
-
-### Documentation
-
-## Questions and Topics for Discussion (Before Meeting)
-
-Prepare 3-5 questions and topics you want to discuss with your mentor.
-
-1. Question 1
-2. Question 2
-3. Question 3
-
-## Discussion Notes (During Meeting)
-
-## Action Items for Next Week (During Meeting)
-
-Last 3 minutes of the meeting, summarize action items.
-
-- [ ] Action Item 1
-- [ ] Action Item 2
-- [ ] Action Item 3
-
----

7project/report.md

@@ -1,394 +0,0 @@
-# Personal finance tracker
-
-> **Instructions**:
-> This template provides the structure for your project report.
-> Replace the placeholder text with your actual content.
-> Remove instructions that are not relevant for your project, but leave the headings along with a (NA) label.
-
-## Project Overview
-
-**Project Name**: Personal Finance Tracker
-
-**Group Members**:
-
-- 289229, Lukáš Trkan, lukastrkan
-- 289258, Dejan Ribarovski, derib2613, ribardej
-
-**Brief Description**:
-Our application is a finance tracker, so a person can easily track his cash flow
-through multiple bank accounts. Person can label transactions with custom categories
-and later filter by them.
-
-## Architecture Overview
-Our system is a full‑stack web application composed of a React frontend, a FastAPI backend, a PostgreSQL database, and asynchronous background workers powered by Celery with RabbitMQ. Redis is available for caching/kv and may be used by Celery as a result backend. The backend exposes REST endpoints for authentication (email/password and OAuth), users, categories, and transactions. A thin controller layer (FastAPI routers) lives under app/api. Infrastructure for Kubernetes is provided via OpenTofu (Terraform‑compatible) modules and the application is packaged via a Helm chart.
-
-### High-Level Architecture
-
-```mermaid
-flowchart LR
-    proc_queue[Message Queue] --> proc_queue_worker[Worker Service]
-    proc_queue_worker --> ext_mail[(Email Service)]
-    proc_cron[Task planner] --> proc_queue
-    proc_queue_worker --> ext_bank[(Bank API)]
-    proc_queue_worker --> db
-    client[Client/Frontend] <--> svc[Backend API]
-    svc --> proc_queue
-    svc <--> db[(Database)]
-    svc <--> cache[(Cache)]
-```
-
-### Components
-
-- Frontend (frontend/): React + TypeScript app built with Vite. Talks to the backend via REST, handles login/registration, shows latest transactions, filtering, and allows adding transactions.
-- Backend API (backend/app): FastAPI app with routers under app/api for auth, categories, and transactions. Uses FastAPI Users for auth (JWT + OAuth), SQLAlchemy ORM, and Pydantic v2 schemas.
-- Worker service (backend/app/workers): Celery worker handling asynchronous tasks (e.g., sending verification emails, future background processing).
-- Database (PostgreSQL): Persists users, categories, transactions; schema managed by Alembic migrations.
-- Message Queue (RabbitMQ): Transports background jobs from the API to the worker.
-- Cache/Result Store (Redis): Available for caching or Celery result backend.
-- Infrastructure as Code (tofu/): OpenTofu modules provisioning cluster services (RabbitMQ, Redis, Argo CD, cert-manager, Cloudflare tunnel, etc.).
-- Deployment Chart (charts/myapp-chart/): Helm chart to deploy the application to Kubernetes.
-
-### Technologies Used
-
-- Backend: Python, FastAPI, FastAPI Users, SQLAlchemy, Pydantic, Alembic, Celery
-- Frontend: React, TypeScript, Vite
-- Database: PostgreSQL
-- Messaging: RabbitMQ 
-- Cache: Redis
-- Containerization/Orchestration: Docker, Docker Compose (dev), Kubernetes, Helm
-- IaC/Platform: OpenTofu (Terraform), Argo CD, cert-manager, MetalLB, Cloudflare Tunnel, Prometheus
-
-## Prerequisites
-
-### System Requirements
-
-- Operating System: Linux, macOS, or Windows
-- Minimum RAM: 4 GB (8 GB recommended for running backend, frontend, and database together)
-- Storage: 2 GB free (Docker images may require additional space)
-
-### Required Software
-
-- Docker Desktop or Docker Engine 24+
-- Docker Compose v2+
-- Node.js 20+ and npm 10+ (for local frontend dev/build)
-- Python 3.12+ (for local backend dev outside Docker)
-- PostgreSQL 15+ (optional if running DB outside Docker)
-- Helm 3.12+ and kubectl 1.29+ (for Kubernetes deployment)
-- OpenTofu 1.7+ (for infrastructure provisioning)
-
-### Environment Variables (common)
-
-- Backend: SECRET, FRONTEND_URL, BACKEND_URL, DATABASE_URL, RABBITMQ_URL, REDIS_URL 
-- OAuth vars (Backend): MOJEID_CLIENT_ID/SECRET, BANKID_CLIENT_ID/SECRET (optional)
-- Frontend: VITE_BACKEND_URL
-
-### Dependencies (key libraries)
-I am not sure what is meant by "key libraries"
-
-Backend: FastAPI, fastapi-users, SQLAlchemy, pydantic v2, Alembic, Celery  
-Frontend: React, TypeScript, Vite  
-Services: PostgreSQL, RabbitMQ, Redis
-
-## Build Instructions
-
-You can run the project with Docker Compose (recommended for local development) or run services manually.
-
-### 1) Clone the Repository
-
-```bash
-git clone https://github.com/dat515-2025/Group-8.git
-cd 7project
-```
-
-### 2) Install dependencies
-Backend
-```bash
-# In 7project/backend
-python3.12 -m venv .venv
-source .venv/bin/activate  # Windows: .venv\Scripts\activate
-pip install -r requirements.txt
-```
-Frontend
-```bash
-# In 7project/frontend
-npm install
-```
-
-### 3) Manual Local Run
-
-Backend
-```bash
-# From the 7project/ directory
-docker compose up --build
-# This starts: PostgreSQL, RabbitMQ/Redis (if defined)
-
-# Set environment variables (or create .env file)
-export SECRET=CHANGE_ME_SECRET
-export BACKEND_URL=http://127.0.0.1:8000
-export FRONTEND_URL=http://localhost:5173
-export DATABASE_URL=postgresql+asyncpg://user:password@127.0.0.1:5432/app
-export RABBITMQ_URL=amqp://guest:guest@127.0.0.1:5672/
-export REDIS_URL=redis://127.0.0.1:6379/0
-
-# Apply DB migrations (Alembic)
-# From 7project/backend
-alembic upgrade head
-
-# Run API
-uvicorn app.app:fastApi --reload --host 0.0.0.0 --port 8000
-
-# Run Celery worker (optional, for emails/background tasks)
-celery -A app.celery_app.celery_app worker -l info
-```
-
-Frontend
-```bash
-# Configure backend URL for dev
-echo 'VITE_BACKEND_URL=http://127.0.0.1:8000' > .env
-npm run dev
-# Open http://localhost:5173
-```
-
-- Backend default: http://127.0.0.1:8000 (OpenAPI at /docs)
-- Frontend default: http://localhost:5173
-
-If needed, adjust compose services/ports in compose.yml.
-
-
-## Deployment Instructions
-
-### Local (Docker Compose)
-
-Described in the previous section (Manual Local Run)
-
-### Kubernetes (via OpenTofu + Helm)
-
-1) Provision platform services (RabbitMQ/Redis/ingress/tunnel/etc.) with OpenTofu
-```bash
-cd tofu
-# copy and edit variables
-cp terraform.tfvars.example terraform.tfvars
-# authenticate to your cluster/cloud as needed, then:
-tofu init
-tofu plan
-tofu apply
-```
-
-2) Deploy the app using Helm
-```bash
-# Set the namespace
-kubectl create namespace myapp || true
-
-# Install/upgrade the chart with required values
-helm upgrade --install myapp charts/myapp-chart \
-  -n myapp \
-  -f charts/myapp-chart/values.yaml \
-  --set image.backend.repository=myorg/myapp-backend \
-  --set image.backend.tag=latest \
-  --set env.BACKEND_URL="https://myapp.example.com" \
-  --set env.FRONTEND_URL="https://myapp.example.com" \
-  --set env.SECRET="CHANGE_ME_SECRET"
-```
-Adjust values to your registry and domain. The chart’s NOTES.txt includes additional examples.
-
-3) Expose and access
-- If using Cloudflare Tunnel or an ingress, configure DNS accordingly (see tofu/modules/cloudflare and deployment/tunnel.yaml).
-- For quick testing without ingress:
-```bash
-kubectl -n myapp port-forward deploy/myapp-backend 8000:8000
-kubectl -n myapp port-forward deploy/myapp-frontend 5173:80
-```
-
-### Verification
-
-```bash
-# Check pods
-kubectl -n myapp get pods
-
-# Backend health
-curl -i http://127.0.0.1:8000/
-# OpenAPI
-open http://127.0.0.1:8000/docs
-
-# Frontend (if port-forwarded)
-open http://localhost:5173
-```
-
-## Testing Instructions
-
-### Unit Tests
-
-```bash
-# Commands to run unit tests
-# For example:
-# go test ./...
-# npm test
-```
-
-### Integration Tests
-
-```bash
-# Commands to run integration tests
-# Any setup required for integration tests
-```
-
-### End-to-End Tests
-
-```bash
-# Commands to run e2e tests
-# How to set up test environment
-```
-
-## Usage Examples
-
-All endpoints are documented at OpenAPI: http://127.0.0.1:8000/docs
-
-### Auth: Register and Login (JWT)
-
-```bash
-# Register
-curl -X POST http://127.0.0.1:8000/auth/register \
-  -H 'Content-Type: application/json' \
-  -d '{
-    "email": "user@example.com",
-    "password": "StrongPassw0rd",
-    "first_name": "Jane",
-    "last_name": "Doe"
-  }'
-
-# Login (JWT)
-TOKEN=$(curl -s -X POST http://127.0.0.1:8000/auth/jwt/login \
-  -H 'Content-Type: application/x-www-form-urlencoded' \
-  -d 'username=user@example.com&password=StrongPassw0rd' | jq -r .access_token)
-
-echo $TOKEN
-
-# Call a protected route
-curl -H "Authorization: Bearer $TOKEN" http://127.0.0.1:8000/authenticated-route
-```
-
-### Frontend
-
-- Start with: npm run dev in 7project/frontend
-- Ensure VITE_BACKEND_URL is set to the backend URL (e.g., http://127.0.0.1:8000)
-- Open http://localhost:5173
-- Login, view latest transactions, filter, and add new transactions from the UI.
-
----
-
-## Presentation Video
-
-**YouTube Link**: [Insert your YouTube link here]
-
-**Duration**: [X minutes Y seconds]
-
-**Video Includes**:
-
-- [ ] Project overview and architecture
-- [ ] Live demonstration of key features
-- [ ] Code walkthrough
-- [ ] Build and deployment showcase
-
-## Troubleshooting
-
-### Common Issues
-
-#### Issue 1: [Common problem]
-
-**Symptoms**: [What the user sees]
-**Solution**: [Step-by-step fix]
-
-#### Issue 2: [Another common problem]
-
-**Symptoms**: [What the user sees]
-**Solution**: [Step-by-step fix]
-
-### Debug Commands
-
-```bash
-# Useful commands for debugging
-# Log viewing commands
-# Service status checks
-```
-
----
-
-## Self-Assessment Table
-
-> Be honest and detailed in your assessments.
-> This information is used for individual grading.
-> Link to the specific commit on GitHub for each contribution.
-
-| Task/Component                                                        | Assigned To | Status        | Time Spent     | Difficulty | Notes       |
-|-----------------------------------------------------------------------|-------------| ------------- |----------------|------------| ----------- |
-| [Project Setup & Repository](https://github.com/dat515-2025/Group-8#) | Lukas       | ✅ Complete    | [X hours]      | Medium     | [Any notes] |
-| [Design Document](https://github.com/dat515-2025/Group-8/blob/main/6design/design.md)          | Both        | ✅ Complete    | 2 Hours        | Easy       | [Any notes] |
-| [Backend API Development](https://github.com/dat515-2025/Group-8/tree/main/7project/backend/app/api)  | Dejan       | ✅ Complete    | 10 hours       | Medium     | [Any notes] |
-| [Database Setup & Models](https://github.com/dat515-2025/Group-8/tree/main/7project/backend/app/models)  | Lukas       | ✅ Complete    | [X hours]      | Medium     | [Any notes] |
-| [Frontend Development](https://github.com/dat515-2025/Group-8/tree/main/7project/frontend)     | Dejan       | 🔄 In Progress | 7 hours so far | Medium     | [Any notes] |
-| [Docker Configuration](https://github.com/dat515-2025/Group-8/blob/main/7project/compose.yml)     | Lukas       | ✅ Complete    | [X hours]      | Easy       | [Any notes] |
-| [Cloud Deployment](https://github.com/dat515-2025/Group-8/blob/main/7project/deployment/app-demo-deployment.yaml)         | Lukas       | ✅ Complete    | [X hours]      | Hard       | [Any notes] |
-| [Testing Implementation](https://github.com/dat515-2025/group-name)   | Dejan       | ❌ Not Started     | [X hours]      | Medium     | [Any notes] |
-| [Documentation](https://github.com/dat515-2025/group-name)            | Both        | ❌ Not Started   | [X hours]      | Easy       | [Any notes] |
-| [Presentation Video](https://github.com/dat515-2025/group-name)       | Both        | ❌ Not Started     | [X hours]      | Medium     | [Any notes] |
-
-**Legend**: ✅ Complete | 🔄 In Progress | ⏳ Pending | ❌ Not Started
-
-## Hour Sheet
-
-> Link to the specific commit on GitHub for each contribution.
-
-### [Team Member 1 Name]
-
-| Date      | Activity            | Hours      | Description                         |
-| --------- | ------------------- | ---------- | ----------------------------------- |
-| [Date]    | Initial Setup       | [X.X]      | Repository setup, project structure |
-| [Date]    | Backend Development | [X.X]      | Implemented user authentication     |
-| [Date]    | Testing             | [X.X]      | Unit tests for API endpoints        |
-| [Date]    | Documentation       | [X.X]      | Updated README and design doc       |
-| **Total** |                     | **[XX.X]** |                                     |
-
-### Dejan
-
-| Date        | Activity             | Hours  | Description                    |
-|-------------|----------------------|--------|--------------------------------|
-| 25.9.       | Design               | 1.5    | 6design                        |
-| 9-11.10.    | Backend APIs         | 10     | Implemented Backend APIs       |
-| 13-15.10.   | Frontend Development | 6.5    | Created user interface mockups |
-| Continually | Documantation        | 3      | Documenting the dev process    |
-| **Total**   |                      | **21** |                                |
-
-
-### Group Total: [XXX.X] hours
-
----
-
-## Final Reflection
-
-### What We Learned
-
-[Reflect on the key technical and collaboration skills learned during this project]
-
-### Challenges Faced
-
-[Describe the main challenges and how you overcame them]
-
-### If We Did This Again
-
-[What would you do differently? What worked well that you'd keep?]
-
-### Individual Growth
-
-#### [Team Member 1 Name]
-
-[Personal reflection on growth, challenges, and learning]
-
-#### [Team Member 2 Name]
-
-[Personal reflection on growth, challenges, and learning]
-
-
----
-
-**Report Completion Date**: [Date]
-**Last Updated**: 15.10.2025

7project/tofu/modules/maxscale/charts/maxscale-helm/templates/backup.yaml

@@ -1,42 +0,0 @@
-{{- if .Values.s3.enabled }}
-apiVersion: k8s.mariadb.com/v1alpha1
-kind: Backup
-metadata:
-  name: backup
-  namespace: mariadb-operator
-spec:
-  mariaDbRef:
-    name: mariadb-repl
-    namespace: mariadb-operator
-  schedule:
-    cron: "0 */3 * * *"
-    suspend: false
-  timeZone: "Europe/Prague"
-  maxRetention: 720h # 30 days
-  compression: bzip2
-  storage:
-    s3:
-      bucket: {{ .Values.s3.bucket | quote }}
-      endpoint: {{ .Values.s3.endpoint | quote }}
-      accessKeyIdSecretKeyRef:
-        name: s3-credentials
-        key: key_id
-      secretAccessKeySecretKeyRef:
-        name: s3-credentials
-        key: secret_key
-      region: {{ .Values.s3.region | quote }}
-      tls:
-        enabled: true
-  # Define a PVC to use as staging area for keeping the backups while they are being processed.
-  stagingStorage:
-    persistentVolumeClaim:
-      resources:
-        requests:
-          storage: 10Gi
-      accessModes:
-        - ReadWriteOnce
-  args:
-    - --single-transaction
-    - --all-databases
-  logLevel: info
-{{- end }}

7project/tofu/modules/maxscale/charts/maxscale-helm/templates/garage.yaml

@@ -1,11 +0,0 @@
-{{- if .Values.s3.enabled }}
-apiVersion: v1
-kind: Secret
-metadata:
-  name: s3-credentials
-  namespace: mariadb-operator
-type: Opaque
-stringData:
-  key_id: "{{ .Values.s3.key_id }}"
-  secret_key: "{{ .Values.s3.key_secret }}"
-{{- end }}

7project/tofu/modules/maxscale/main.tf

@@ -1,82 +0,0 @@
-terraform {
-  required_providers {
-    kubectl = {
-      source  = "gavinbunney/kubectl"
-      version = "1.19.0"
-    }
-    helm = {
-      source  = "hashicorp/helm"
-      version = "3.0.2"
-    }
-    kubernetes = {
-      source  = "hashicorp/kubernetes"
-      version = "2.38.0"
-    }
-  }
-}
-
-resource "kubernetes_namespace" "mariadb-operator" {
-  metadata {
-    name = "mariadb-operator"
-  }
-}
-
-locals {
-  mariadb_secret_yaml = templatefile("${path.module}/mariadb-secret.yaml", {
-    password      = var.mariadb_password
-    user_password = var.mariadb_user_password
-    root_password = var.mariadb_root_password
-  })
-}
-
-resource "kubectl_manifest" "secrets" {
-  yaml_body  = local.mariadb_secret_yaml
-  depends_on = [kubernetes_namespace.mariadb-operator]
-}
-
-
-resource "helm_release" "mariadb-operator-crds" {
-  name       = "mariadb-operator-crds"
-  repository = "https://helm.mariadb.com/mariadb-operator"
-  chart      = "mariadb-operator-crds"
-  namespace  = "mariadb-operator"
-  version    = "25.8.4"
-  depends_on = [kubectl_manifest.secrets]
-  timeout    = 3600
-}
-
-
-resource "helm_release" "mariadb-operator" {
-  name       = "mariadb-operator"
-  repository = "https://helm.mariadb.com/mariadb-operator"
-  chart      = "mariadb-operator"
-  depends_on = [helm_release.mariadb-operator-crds, kubectl_manifest.secrets]
-  namespace  = "mariadb-operator"
-  version    = "25.8.3"
-  timeout    = 3600
-}
-
-resource "helm_release" "maxscale_helm" {
-  name       = "maxscale-helm"
-  chart      = "${path.module}/charts/maxscale-helm"
-  version    = "1.0.14"
-  depends_on = [helm_release.mariadb-operator-crds, kubectl_manifest.secrets]
-  timeout    = 3600
-
-  set = [
-    { name = "user.name", value = var.mariadb_user_name },
-    { name = "user.host", value = var.mariadb_user_host },
-    { name = "metallb.maxscale_ip", value = var.maxscale_ip },
-    { name = "metallb.service_ip", value = var.service_ip },
-    { name = "metallb.primary_ip", value = var.primary_ip },
-    { name = "metallb.secondary_ip", value = var.secondary_ip },
-    { name = "phpmyadmin.enabled", value = tostring(var.phpmyadmin_enabled) },
-    { name = "base_domain", value = var.cloudflare_domain },
-    { name = "s3.key_id", value = var.s3_key_id },
-    { name = "s3.key_secret", value = var.s3_key_secret },
-    { name = "s3.enabled", value = var.s3_enabled },
-    { name = "s3.endpoint", value = var.s3_endpoint },
-    { name = "s3.region", value = var.s3_region },
-    { name = "s3.bucket", value = var.s3_bucket },
-  ]
-}

7project/tofu/modules/metrics-server/main.tf

@@ -1,33 +0,0 @@
-terraform {
-  required_providers {
-    kubectl = {
-      source  = "gavinbunney/kubectl"
-      version = "1.19.0"
-    }
-    helm = {
-      source  = "hashicorp/helm"
-      version = "3.0.2"
-    }
-    kubernetes = {
-      source  = "hashicorp/kubernetes"
-      version = "2.38.0"
-    }
-  }
-}
-
-# Deploy metrics-server via Helm into kube-system namespace
-resource "helm_release" "metrics_server" {
-  name       = "metrics-server"
-  repository = "https://kubernetes-sigs.github.io/metrics-server/"
-  chart      = "metrics-server"
-  namespace  = "kube-system"
-
-  wait          = true
-  timeout       = 600
-  recreate_pods = false
-  force_update  = false
-
-  values = [
-    file("${path.module}/values.yaml")
-  ]
-}

7project/tofu/modules/metrics-server/values.yaml

@@ -1,15 +0,0 @@
-# Values overriding defaults for metrics-server Helm chart
-# Fix TLS and address selection issues when scraping kubelets (common on Talos)
-args:
-  - --kubelet-insecure-tls
-  - --kubelet-preferred-address-types=InternalIP,Hostname,InternalDNS,ExternalDNS,ExternalIP
-  - --kubelet-use-node-status-port=true
-
-# Using hostNetwork often helps in restricted CNI/DNS environments
-#hostNetwork: true
-# Required when hostNetwork is true so DNS works as expected
-#dnsPolicy: ClusterFirstWithHostNet
-
-# Enable metrics API service monitor if Prometheus Operator is present (optional)
-# serviceMonitor:
-#   enabled: true

7project/tofu/modules/prometheus/grafana-ui.yaml

@@ -1,14 +0,0 @@
-apiVersion: networking.cfargotunnel.com/v1alpha1
-kind: TunnelBinding
-metadata:
-  name: grafana-tunnel-binding
-  namespace: monitoring
-subjects:
-  - name: grafana
-    spec:
-      target: http://kube-prometheus-stack-grafana.monitoring.svc.cluster.local
-      fqdn: grafana.${base_domain}
-      noTlsVerify: true
-tunnelRef:
-  kind: ClusterTunnel
-  name: cluster-tunnel

7project/tofu/modules/prometheus/main.tf

@@ -1,66 +0,0 @@
-terraform {
-  required_providers {
-    kubectl = {
-      source  = "gavinbunney/kubectl"
-      version = "1.19.0"
-    }
-    helm = {
-      source  = "hashicorp/helm"
-      version = "3.0.2"
-    }
-    kubernetes = {
-      source  = "hashicorp/kubernetes"
-      version = "2.38.0"
-    }
-    kustomization = {
-      source  = "kbst/kustomization"
-      version = "0.9.6"
-    }
-    time = {
-      source  = "hashicorp/time"
-      version = "0.13.1"
-    }
-  }
-}
-
-# Create namespace for monitoring
-resource "kubernetes_namespace" "monitoring" {
-  metadata {
-    name = "monitoring"
-    labels = {
-      "pod-security.kubernetes.io/enforce" = "privileged"
-    }
-  }
-}
-
-# Deploy kube-prometheus-stack
-resource "helm_release" "kube_prometheus_stack" {
-  name       = "kube-prometheus-stack"
-  repository = "https://prometheus-community.github.io/helm-charts"
-  chart      = "kube-prometheus-stack"
-  namespace  = kubernetes_namespace.monitoring.metadata[0].name
-  version    = "67.2.1" # Check for latest version
-
-  # Wait for CRDs to be created
-  wait          = true
-  timeout       = 600
-  force_update  = false
-  recreate_pods = false
-
-  # Reference the values file
-  values = [
-    file("${path.module}/values.yaml")
-  ]
-
-  depends_on = [
-    kubernetes_namespace.monitoring
-  ]
-}
-
-resource "kubectl_manifest" "argocd-tunnel-bind" {
-  depends_on = [helm_release.kube_prometheus_stack]
-
-  yaml_body = templatefile("${path.module}/grafana-ui.yaml", {
-    base_domain = var.cloudflare_domain
-  })
-}

7project/tofu/modules/prometheus/values.yaml

@@ -1,189 +0,0 @@
-# Prometheus configuration
-prometheus:
-  prometheusSpec:
-    retention: 30d
-    retentionSize: "45GB"
-
-    # Storage configuration
-    storageSpec:
-      volumeClaimTemplate:
-        spec:
-          accessModes:
-            - ReadWriteOnce
-          resources:
-            requests:
-              storage: 50Gi
-          # storageClassName: "your-storage-class" # Uncomment and specify if needed
-
-    # Resource limits
-    resources:
-      requests:
-        cpu: 500m
-        memory: 2Gi
-      limits:
-        cpu: 2000m
-        memory: 4Gi
-
-    # Scrape interval
-    scrapeInterval: 30s
-    evaluationInterval: 30s
-
-  # Service configuration
-  service:
-    type: ClusterIP
-    port: 9090
-
-  # Ingress (disabled by default)
-  ingress:
-    enabled: false
-    # ingressClassName: nginx
-    # hosts:
-    #   - prometheus.example.com
-    # tls:
-    #   - secretName: prometheus-tls
-    #     hosts:
-    #       - prometheus.example.com
-
-# Grafana configuration
-grafana:
-  enabled: true
-
-  # Admin credentials
-  adminPassword: "admin" # CHANGE THIS IN PRODUCTION!
-
-  # Persistence
-  persistence:
-    enabled: true
-    size: 10Gi
-    # storageClassName: "your-storage-class" # Uncomment and specify if needed
-
-  # Resource limits
-  resources:
-    requests:
-      cpu: 100m
-      memory: 256Mi
-    limits:
-      cpu: 500m
-      memory: 512Mi
-
-  # Service configuration
-  service:
-    type: ClusterIP
-    port: 80
-
-  # Ingress (disabled by default)
-  ingress:
-    enabled: false
-    # ingressClassName: nginx
-    # hosts:
-    #   - grafana.example.com
-    # tls:
-    #   - secretName: grafana-tls
-    #     hosts:
-    #       - grafana.example.com
-
-  # Default dashboards
-  defaultDashboardsEnabled: true
-  defaultDashboardsTimezone: Europe/Prague
-
-# Alertmanager configuration
-alertmanager:
-  enabled: true
-
-  alertmanagerSpec:
-    # Storage configuration
-    storage:
-      volumeClaimTemplate:
-        spec:
-          accessModes:
-            - ReadWriteOnce
-          resources:
-            requests:
-              storage: 10Gi
-          # storageClassName: "your-storage-class" # Uncomment and specify if needed
-
-    # Resource limits
-    resources:
-      requests:
-        cpu: 100m
-        memory: 128Mi
-      limits:
-        cpu: 500m
-        memory: 256Mi
-
-  # Service configuration
-  service:
-    type: ClusterIP
-    port: 9093
-
-  # Ingress (disabled by default)
-  ingress:
-    enabled: false
-    # ingressClassName: nginx
-    # hosts:
-    #   - alertmanager.example.com
-    # tls:
-    #   - secretName: alertmanager-tls
-    #     hosts:
-    #       - alertmanager.example.com
-
-  # Alertmanager configuration
-  config:
-    global:
-      resolve_timeout: 5m
-
-    route:
-      group_by: [ 'alertname', 'cluster', 'service' ]
-      group_wait: 10s
-      group_interval: 10s
-      repeat_interval: 12h
-      receiver: 'null'
-      routes:
-        - match:
-            alertname: Watchdog
-          receiver: 'null'
-
-    receivers:
-      - name: 'null'
-      # Add your receivers here (email, slack, pagerduty, etc.)
-      # - name: 'slack'
-      #   slack_configs:
-      #     - api_url: 'YOUR_SLACK_WEBHOOK_URL'
-      #       channel: '#alerts'
-      #       title: '{{ range .Alerts }}{{ .Annotations.summary }}\n{{ end }}'
-      #       text: '{{ range .Alerts }}{{ .Annotations.description }}\n{{ end }}'
-
-# Node Exporter
-nodeExporter:
-  enabled: true
-
-# Kube State Metrics
-kubeStateMetrics:
-  enabled: true
-
-# Prometheus Operator
-prometheusOperator:
-  enabled: true
-
-  resources:
-    requests:
-      cpu: 100m
-      memory: 128Mi
-    limits:
-      cpu: 500m
-      memory: 256Mi
-
-# Service Monitors
-# Automatically discover and monitor services with appropriate labels
-prometheus-node-exporter:
-  prometheus:
-    monitor:
-      enabled: true
-
-# Additional ServiceMonitors can be defined here
-# additionalServiceMonitors: []
-
-# Global settings
-global:
-  rbac:
-    create: true

7project/tofu/modules/prometheus/variables.tf

@@ -1,5 +0,0 @@
-variable "cloudflare_domain" {
-  type     = string
-  default  = "Base cloudflare domain, e.g. example.com"
-  nullable = false
-}

7project/tofu/modules/rabbitmq/main.tf

@@ -1,91 +0,0 @@
-terraform {
-  required_providers {
-    kubectl = {
-      source  = "gavinbunney/kubectl"
-      version = "1.19.0"
-    }
-    helm = {
-      source  = "hashicorp/helm"
-      version = "3.0.2" # Doporučuji použít novější verzi providera
-    }
-    kubernetes = {
-      source  = "hashicorp/kubernetes"
-      version = "2.38.0" # Doporučuji použít novější verzi providera
-    }
-    # Ostatní provideři mohou zůstat
-  }
-}
-
-resource "kubernetes_namespace" "rabbitmq_namespace" {
-  metadata {
-    name = "rabbitmq-system"
-  }
-}
-
-
-resource "helm_release" "rabbitmq_operator" {
-  name       = "rabbitmq-cluster-operator"
-  repository = "oci://registry-1.docker.io/bitnamicharts"
-  chart      = "rabbitmq-cluster-operator"
-
-  version = "4.4.34"
-
-  namespace = "rabbitmq-system"
-
-  # Zde můžete přepsat výchozí hodnoty chartu, pokud by bylo potřeba
-  # Například sledovat jen určité namespace, nastavit tolerations atd.
-  # Pro základní instalaci není potřeba nic měnit.
-  # values = [
-  #   templatefile("${path.module}/values/operator-values.yaml", {})
-  # ]
-  set = [
-    {
-      name  = "rabbitmqImage.repository"
-      value = "bitnamilegacy/rabbitmq"
-    },
-    {
-      name  = "clusterOperator.image.repository"
-      value = "bitnamilegacy/rabbitmq-cluster-operator"
-    },
-    {
-      name  = "msgTopologyOperator.image.repository"
-      value = "bitnamilegacy/rmq-messaging-topology-operator"
-    },
-    {
-      name  = "credentialUpdaterImage.repository"
-      value = "bitnamilegacy/rmq-default-credential-updater"
-    },
-    {
-      name  = "clusterOperator.metrics.service.enabled"
-      value = "true"
-    },
-    {
-      name  = "clusterOperator.metrics.service.enabled"
-      value = "true"
-    }
-  ]
-  depends_on = [kubernetes_namespace.rabbitmq_namespace]
-}
-
-
-
-resource "kubectl_manifest" "rabbitmq_cluster" {
-  yaml_body = templatefile("${path.module}/rabbit-cluster.yaml", {
-    replicas = var.rabbitmq_replicas
-    password = var.rabbitmq-password
-  })
-
-  depends_on = [
-    helm_release.rabbitmq_operator
-  ]
-}
-
-resource "kubectl_manifest" "rabbit_ui" {
-  yaml_body = templatefile("${path.module}/rabbit-ui.yaml", {
-    base_domain = var.base_domain
-  })
-
-  depends_on = [
-    kubectl_manifest.rabbitmq_cluster
-  ]
-}

7project/tofu/modules/rabbitmq/rabbit-cluster.yaml

@@ -1,5 +0,0 @@
-apiVersion: rabbitmq.com/v1beta1
-kind: RabbitmqCluster
-metadata:
-  name: 'rabbitmq-cluster'
-  namespace: "rabbitmq-system"

backend/Dockerfile

@@ -1,8 +1,7 @@
 FROM python:3.11-slim
-
 WORKDIR /app
 COPY requirements.txt .
 RUN pip install --no-cache-dir -r requirements.txt
 COPY . .
 EXPOSE 8000
-CMD alembic upgrade head && uvicorn app.app:fastApi --host 0.0.0.0 --port 8000
+CMD alembic upgrade head && uvicorn app.app:app --host 0.0.0.0 --port 8000

backend/alembic.ini

@@ -11,7 +11,7 @@ script_location = %(here)s/alembic
 # Uncomment the line below if you want the files to be prepended with date and time
 # see https://alembic.sqlalchemy.org/en/latest/tutorial.html#editing-the-ini-file
 # for all available tokens
-file_template = %%(year)d_%%(month).2d_%%(day).2d_%%(hour).2d%%(minute).2d-%%(rev)s_%%(slug)s
+# file_template = %%(year)d_%%(month).2d_%%(day).2d_%%(hour).2d%%(minute).2d-%%(rev)s_%%(slug)s
 
 # sys.path path, will be prepended to sys.path if present.
 # defaults to the current working directory.  for multiple paths, the path separator

backend/alembic/env.py

@@ -23,10 +23,9 @@ if not DATABASE_URL:
     mariadb_password = os.getenv("MARIADB_PASSWORD", "strongpassword")
     DATABASE_URL = f"mysql+pymysql://{mariadb_user}:{mariadb_password}@{mariadb_host}:{mariadb_port}/{mariadb_db}"
 
+# Use synchronous driver for Alembic migrations
 SYNC_DATABASE_URL = DATABASE_URL.replace("+asyncmy", "+pymysql")
 
-ssl_enabled = os.getenv("MARIADB_HOST", "localhost") != "localhost"
-connect_args = {"ssl": {"ssl": True}} if ssl_enabled else {}
 
 def run_migrations_offline() -> None:
     context.configure(
@@ -40,7 +39,7 @@ def run_migrations_offline() -> None:
 
 
 def run_migrations_online() -> None:
-    connectable = create_engine(SYNC_DATABASE_URL, poolclass=pool.NullPool, connect_args=connect_args)
+    connectable = create_engine(SYNC_DATABASE_URL, poolclass=pool.NullPool)
     with connectable.connect() as connection:
         context.configure(
             connection=connection,

backend/alembic/versions/81f275275556_init_migration.py

@@ -1,8 +1,8 @@
-"""add categories
+"""Init migration
 
-Revision ID: 63e072f09836
+Revision ID: 81f275275556
 Revises: 
-Create Date: 2025-10-09 14:56:14.653249
+Create Date: 2025-09-24 17:39:25.346690
 
 """
 from typing import Sequence, Union
@@ -13,7 +13,7 @@ import sqlalchemy as sa
 
 
 # revision identifiers, used by Alembic.
-revision: str = '63e072f09836'
+revision: str = '81f275275556'
 down_revision: Union[str, Sequence[str], None] = None
 branch_labels: Union[str, Sequence[str], None] = None
 depends_on: Union[str, Sequence[str], None] = None
@@ -22,6 +22,12 @@ depends_on: Union[str, Sequence[str], None] = None
 def upgrade() -> None:
     """Upgrade schema."""
     # ### commands auto generated by Alembic - please adjust! ###
+    op.create_table('transaction',
+    sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
+    sa.Column('amount', sa.Float(), nullable=False),
+    sa.Column('description', sa.String(length=255), nullable=True),
+    sa.PrimaryKeyConstraint('id')
+    )
     op.create_table('user',
     sa.Column('first_name', sa.String(length=100), nullable=True),
     sa.Column('last_name', sa.String(length=100), nullable=True),
@@ -34,38 +40,13 @@ def upgrade() -> None:
     sa.PrimaryKeyConstraint('id')
     )
     op.create_index(op.f('ix_user_email'), 'user', ['email'], unique=True)
-    op.create_table('categories',
-    sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
-    sa.Column('name', sa.String(length=100), nullable=False),
-    sa.Column('description', sa.String(length=255), nullable=True),
-    sa.Column('user_id', fastapi_users_db_sqlalchemy.generics.GUID(), nullable=False),
-    sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
-    sa.PrimaryKeyConstraint('id'),
-    sa.UniqueConstraint('name')
-    )
-    op.create_table('transaction',
-    sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
-    sa.Column('amount', sa.Float(), nullable=False),
-    sa.Column('description', sa.String(length=255), nullable=True),
-    sa.Column('user_id', fastapi_users_db_sqlalchemy.generics.GUID(), nullable=False),
-    sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
-    sa.PrimaryKeyConstraint('id')
-    )
-    op.create_table('category_transaction',
-    sa.Column('id_category', sa.Integer(), nullable=True),
-    sa.Column('id_transaction', sa.Integer(), nullable=True),
-    sa.ForeignKeyConstraint(['id_category'], ['categories.id'], ),
-    sa.ForeignKeyConstraint(['id_transaction'], ['transaction.id'], )
-    )
     # ### end Alembic commands ###
 
 
 def downgrade() -> None:
     """Downgrade schema."""
     # ### commands auto generated by Alembic - please adjust! ###
-    op.drop_table('category_transaction')
-    op.drop_table('transaction')
-    op.drop_table('categories')
     op.drop_index(op.f('ix_user_email'), table_name='user')
     op.drop_table('user')
+    op.drop_table('transaction')
     # ### end Alembic commands ###

backend/app/app.py

@@ -0,0 +1,56 @@
+from fastapi import Depends, FastAPI
+from fastapi.middleware.cors import CORSMiddleware
+
+from app.models.user import User
+
+from app.schemas.user import UserCreate, UserRead, UserUpdate
+from app.services.user_service import auth_backend, current_active_verified_user, fastapi_users
+
+app = FastAPI()
+
+# CORS for frontend dev server
+app.add_middleware(
+    CORSMiddleware,
+    allow_origins=[
+        "http://localhost:5173",
+        "http://127.0.0.1:5173",
+    ],
+    allow_credentials=True,
+    allow_methods=["*"],
+    allow_headers=["*"],
+)
+
+app.include_router(
+    fastapi_users.get_auth_router(auth_backend), prefix="/auth/jwt", tags=["auth"]
+)
+app.include_router(
+    fastapi_users.get_register_router(UserRead, UserCreate),
+    prefix="/auth",
+    tags=["auth"],
+)
+app.include_router(
+    fastapi_users.get_reset_password_router(),
+    prefix="/auth",
+    tags=["auth"],
+)
+app.include_router(
+    fastapi_users.get_verify_router(UserRead),
+    prefix="/auth",
+    tags=["auth"],
+)
+app.include_router(
+    fastapi_users.get_users_router(UserRead, UserUpdate),
+    prefix="/users",
+    tags=["users"],
+)
+
+
+# Liveness/root endpoint
+@app.get("/", include_in_schema=False)
+async def root():
+    return {"status": "ok"}
+
+
+@app.get("/authenticated-route")
+async def authenticated_route(user: User = Depends(current_active_verified_user)):
+    return {"message": f"Hello {user.email}!"}

backend/app/core/db.py

@@ -17,7 +17,6 @@ if not DATABASE_URL:
 # Load all models to register them
 from app.models.user import User
 from app.models.transaction import Transaction
-from app.models.categories import Category
 
 ssl_enabled = os.getenv("MARIADB_HOST", "localhost") != "localhost"
 connect_args = {"ssl": {"ssl": True}} if ssl_enabled else {}

backend/app/core/queue.py

@@ -0,0 +1,35 @@
+import json
+import os
+from typing import Any, Dict
+import asyncio
+
+RABBITMQ_URL = os.getenv("RABBITMQ_URL") or (
+    f"amqp://{os.getenv('RABBITMQ_USERNAME', 'user')}:"
+    f"{os.getenv('RABBITMQ_PASSWORD', 'bitnami123')}@"
+    f"{os.getenv('RABBITMQ_HOST', 'localhost')}:"
+    f"{os.getenv('RABBITMQ_PORT', '5672')}"
+)
+QUEUE_NAME = os.getenv("MAIL_QUEUE", "mail_queue")
+
+async def _publish_async(message: Dict[str, Any]) -> None:
+    import aio_pika
+    connection = await aio_pika.connect_robust(RABBITMQ_URL)
+    try:
+        channel = await connection.channel()
+        await channel.declare_queue(QUEUE_NAME, durable=True)
+        body = json.dumps(message).encode("utf-8")
+        await channel.default_exchange.publish(
+            aio_pika.Message(body=body, delivery_mode=aio_pika.DeliveryMode.PERSISTENT),
+            routing_key=QUEUE_NAME,
+        )
+    finally:
+        await connection.close()
+
+def enqueue_email(to: str, subject: str, body: str) -> None:
+    message = {"type": "email", "to": to, "subject": subject, "body": body}
+    try:
+        loop = asyncio.get_running_loop()
+        loop.create_task(_publish_async(message))
+    except RuntimeError:
+        asyncio.run(_publish_async(message))
+

backend/app/models/transaction.py

@@ -0,0 +1,9 @@
+from sqlalchemy import Column, Integer, String, Float
+from app.core.base import Base
+
+class Transaction(Base):
+    __tablename__ = "transaction"
+    id = Column(Integer, primary_key=True, autoincrement=True)
+    amount = Column(Float, nullable=False)
+    description = Column(String(length=255), nullable=True)
+

backend/app/models/user.py

@@ -0,0 +1,7 @@
+from sqlalchemy import Column, String
+from fastapi_users.db import SQLAlchemyBaseUserTableUUID
+from app.core.base import Base
+
+class User(SQLAlchemyBaseUserTableUUID, Base):
+    first_name = Column(String(length=100), nullable=True)
+    last_name = Column(String(length=100), nullable=True)

backend/app/schemas/user.py

@@ -4,13 +4,13 @@ from fastapi_users import schemas
 
 class UserRead(schemas.BaseUser[uuid.UUID]):
     first_name: Optional[str] = None
-    last_name: Optional[str] = None
+    surname: Optional[str] = None
 
 class UserCreate(schemas.BaseUserCreate):
     first_name: Optional[str] = None
-    last_name: Optional[str] = None
+    surname: Optional[str] = None
 
 class UserUpdate(schemas.BaseUserUpdate):
     first_name: Optional[str] = None
-    last_name: Optional[str] = None
+    surname: Optional[str] = None
 

backend/app/services/db.py

@@ -4,13 +4,11 @@ from sqlalchemy.ext.asyncio import AsyncSession
 from fastapi_users.db import SQLAlchemyUserDatabase
 
 from ..core.db import async_session_maker
-from ..models.user import User, OAuthAccount
+from ..models.user import User
-
 
 async def get_async_session() -> AsyncGenerator[AsyncSession, None]:
     async with async_session_maker() as session:
         yield session
 
-
 async def get_user_db(session: AsyncSession = Depends(get_async_session)):
-    yield SQLAlchemyUserDatabase(session, User, OAuthAccount)
+    yield SQLAlchemyUserDatabase(session, User)

backend/app/services/user_service.py

@@ -3,66 +3,26 @@ import uuid
 from typing import Optional
 
 from fastapi import Depends, Request
-from fastapi_users import BaseUserManager, FastAPIUsers, UUIDIDMixin, models
+from fastapi_users import BaseUserManager, FastAPIUsers, UUIDIDMixin
 from fastapi_users.authentication import (
     AuthenticationBackend,
     BearerTransport,
+    JWTStrategy,
 )
-from fastapi_users.authentication.strategy.jwt import JWTStrategy
 from fastapi_users.db import SQLAlchemyUserDatabase
-from httpx_oauth.oauth2 import BaseOAuth2
 
 from app.models.user import User
-from app.oauth.bank_id import BankID
-from app.oauth.custom_openid import CustomOpenID
-from app.oauth.moje_id import MojeIDOAuth
 from app.services.db import get_user_db
 from app.core.queue import enqueue_email
 
 SECRET = os.getenv("SECRET", "CHANGE_ME_SECRET")
-
 FRONTEND_URL = os.getenv("FRONTEND_URL", "http://localhost:5173")
 BACKEND_URL = os.getenv("BACKEND_URL", "http://localhost:8000")
 
-providers = {
-    "MojeID": MojeIDOAuth(
-        os.getenv("MOJEID_CLIENT_ID", "CHANGE_ME_CLIENT_ID"),
-        os.getenv("MOJEID_CLIENT_SECRET", "CHANGE_ME_CLIENT_SECRET"),
-    ),
-    "BankID": BankID(
-        os.getenv("BANKID_CLIENT_ID", "CHANGE_ME_CLIENT_ID"),
-        os.getenv("BANKID_CLIENT_SECRET", "CHANGE_ME_CLIENT_SECRET"),
-    )
-}
-
-
-def get_oauth_provider(name: str) -> Optional[BaseOAuth2]:
-    if name not in providers:
-        return None
-    return providers[name]
-
-
 class UserManager(UUIDIDMixin, BaseUserManager[User, uuid.UUID]):
     reset_password_token_secret = SECRET
     verification_token_secret = SECRET
 
-    async def oauth_callback(self: "BaseUserManager[models.UOAP, models.ID]", oauth_name: str, access_token: str,
-                             account_id: str, account_email: str, expires_at: Optional[int] = None,
-                             refresh_token: Optional[str] = None, request: Optional[Request] = None, *,
-                             associate_by_email: bool = False, is_verified_by_default: bool = False) -> models.UOAP:
-
-        user = await super().oauth_callback(oauth_name, access_token, account_id, account_email, expires_at,
-                                            refresh_token, request, associate_by_email=associate_by_email,
-                                            is_verified_by_default=is_verified_by_default)
-
-        # set additional user info from the OAuth provider
-        provider = get_oauth_provider(oauth_name)
-        if provider is not None and isinstance(provider, CustomOpenID):
-            update_dict = await provider.get_user_info(access_token)
-            await self.user_db.update(user, update_dict)
-
-        return user
-
     async def on_after_register(self, user: User, request: Optional[Request] = None):
         await self.request_verify(user, request)
 
@@ -87,23 +47,19 @@ class UserManager(UUIDIDMixin, BaseUserManager[User, uuid.UUID]):
         )
         try:
             enqueue_email(to=user.email, subject=subject, body=body)
-        except Exception as e:
+        except Exception:
             print("[Email Fallback] To:", user.email)
             print("[Email Fallback] Subject:", subject)
             print("[Email Fallback] Body:\n", body)
 
-
 async def get_user_manager(user_db: SQLAlchemyUserDatabase = Depends(get_user_db)):
     yield UserManager(user_db)
 
-
 bearer_transport = BearerTransport(tokenUrl="auth/jwt/login")
 
-
 def get_jwt_strategy() -> JWTStrategy:
     return JWTStrategy(secret=SECRET, lifetime_seconds=3600)
 
-
 auth_backend = AuthenticationBackend(
     name="jwt",
     transport=bearer_transport,
@@ -114,3 +70,4 @@ fastapi_users = FastAPIUsers[User, uuid.UUID](get_user_manager, [auth_backend])
 
 current_active_user = fastapi_users.current_user(active=True)
 current_active_verified_user = fastapi_users.current_user(active=True, verified=True)
+

backend/requirements.txt

@@ -2,21 +2,14 @@ aio-pika==9.5.6
 aiormq==6.8.1
 aiosqlite==0.21.0
 alembic==1.16.5
-amqp==5.3.1
 annotated-types==0.7.0
 anyio==4.11.0
 argon2-cffi==23.1.0
 argon2-cffi-bindings==25.1.0
 asyncmy==0.2.9
 bcrypt==4.3.0
-billiard==4.2.2
-celery==5.5.3
-certifi==2025.10.5
 cffi==2.0.0
 click==8.1.8
-click-didyoumean==0.3.1
-click-plugins==1.1.1.2
-click-repl==0.3.0
 cryptography==46.0.1
 dnspython==2.7.0
 email_validator==2.2.0
@@ -26,19 +19,13 @@ fastapi-users==14.0.1
 fastapi-users-db-sqlalchemy==7.0.0
 greenlet==3.2.4
 h11==0.16.0
-httpcore==1.0.9
 httptools==0.6.4
-httpx==0.28.1
-httpx-oauth==0.16.1
 idna==3.10
-kombu==5.5.4
 makefun==1.16.0
 Mako==1.3.10
 MarkupSafe==3.0.2
 multidict==6.6.4
-packaging==25.0
 pamqp==3.3.0
-prompt_toolkit==3.0.52
 propcache==0.3.2
 pwdlib==0.2.1
 pycparser==2.23
@@ -46,24 +33,17 @@ pydantic==2.11.9
 pydantic_core==2.33.2
 PyJWT==2.10.1
 PyMySQL==1.1.2
-python-dateutil==2.9.0.post0
 python-dotenv==1.1.1
 python-multipart==0.0.20
 PyYAML==6.0.2
-sentry-sdk==2.42.0
-six==1.17.0
 sniffio==1.3.1
 SQLAlchemy==2.0.43
 starlette==0.48.0
 tomli==2.2.1
 typing-inspection==0.4.1
 typing_extensions==4.15.0
-tzdata==2025.2
-urllib3==2.5.0
 uvicorn==0.37.0
 uvloop==0.21.0
-vine==5.1.0
 watchfiles==1.1.0
-wcwidth==0.2.14
 websockets==15.0.1
 yarl==1.20.1

backend/worker/email_worker.py

@@ -0,0 +1,56 @@
+import asyncio
+import json
+import os
+from typing import Any, Dict
+
+RABBITMQ_URL = os.getenv("RABBITMQ_URL") or (
+    f"amqp://{os.getenv('RABBITMQ_USERNAME', 'user')}:"
+    f"{os.getenv('RABBITMQ_PASSWORD', 'bitnami123')}@"
+    f"{os.getenv('RABBITMQ_HOST', 'localhost')}:"
+    f"{os.getenv('RABBITMQ_PORT', '5672')}"
+)
+QUEUE_NAME = os.getenv("MAIL_QUEUE", "mail_queue")
+
+
+async def handle_message(message_body: bytes) -> None:
+    try:
+        data: Dict[str, Any] = json.loads(message_body.decode("utf-8"))
+    except Exception as e:
+        print(f"[email_worker] Failed to decode message: {e}")
+        return
+
+    if data.get("type") != "email":
+        print(f"[email_worker] Unknown message type: {data}")
+        return
+
+    to = data.get("to")
+    subject = data.get("subject")
+    body = data.get("body")
+    if not (to and subject and body):
+        print(f"[email_worker] Incomplete email message: {data}")
+        return
+
+    try:
+        await send_email(to=to, subject=subject, body=body)
+        print(f"[email_worker] Sent email to {to}")
+    except Exception as e:
+        print(f"[email_worker] Error sending email to {to}: {e}")
+
+
+async def main() -> None:
+    import aio_pika
+
+    print(f"[email_worker] Connecting to RabbitMQ at {RABBITMQ_URL}")
+    connection = await aio_pika.connect_robust(RABBITMQ_URL)
+    channel = await connection.channel()
+    queue = await channel.declare_queue(QUEUE_NAME, durable=True)
+    print(f"[email_worker] Waiting for messages in queue '{QUEUE_NAME}' ...")
+
+    async with queue.iterator() as queue_iter:
+        async for message in queue_iter:
+            async with message.process(requeue=False):
+                await handle_message(message.body)
+
+
+if __name__ == "__main__":
+    asyncio.run(main())

compose.yml

@@ -15,7 +15,7 @@ services:
     volumes:
       - redis_data:/data
   rabbitmq:
-    image: bitnamilegacy/rabbitmq:3.13.3-debian-12-r0
+    image: bitnami/rabbitmq:3.13.3-debian-12-r0
     network_mode: host
     ports:
       - "5672:5672"

create_migration.sh

@@ -8,8 +8,4 @@ fi
 cd backend || { echo "Directory 'backend' does not exist"; exit 1; }
 alembic revision --autogenerate -m "$1"
 git add alembic/versions/*
-YELLOW='\033[1;33m'
-NC='\033[0m' # No Color
-
-echo -e "${YELLOW}Don't forget to check imports in the new migration file!${NC}"
 cd - || exit

deployment/app-demo-database-grant.yaml

@@ -0,0 +1,20 @@
+apiVersion: k8s.mariadb.com/v1alpha1
+kind: Grant
+metadata:
+  name: grant
+spec:
+  mariaDbRef:
+    name: mariadb-repl
+    namespace: mariadb-operator
+  privileges:
+    - "ALL PRIVILEGES"
+  database: "app-demo-database"
+  table: "*"
+  username: "app-demo-user"
+  grantOption: true
+  host: "%"
+  # Delete the resource in the database whenever the CR gets deleted.
+  # Alternatively, you can specify Skip in order to omit deletion.
+  cleanupPolicy: Skip
+  requeueInterval: 10h
+  retryInterval: 30s

deployment/app-demo-database-secret.yaml

@@ -0,0 +1,7 @@
+apiVersion: v1
+kind: Secret
+metadata:
+  name: app-demo-database-secret
+type: kubernetes.io/basic-auth
+stringData:
+  password: "strongpassword"