Plane vs Atlassian Jira harryngovu.click

Feature: Work Item Lifecycle Management

  Scenario: Creating a child issue under an existing parent
    Given a user is authenticated with "Member" privileges in workspace "eng-team"
    When the user sends a POST to "/api/v1/workspaces/eng-team/projects/{p_id}/issues/" with parent_id
    Then the database transaction commits successfully
    And a new row is inserted into "db_issue" with "parent_id" equal to parent UUID
    And the generated "sequence_id" increments the project max counter by 1
    And the API returns HTTP status 201 with issue key "INFRA-11"

  Scenario: Dragging an issue card between state columns
    Given an issue "INFRA-11" resides in state group "unstarted"
    When the user drags "INFRA-11" to the "Started" column
    Then the client sends an optimistic PATCH request with new "state_id"
    And "db_issue" is updated within 50ms
    And a Socket.io broadcast event "ISSUE_UPDATED" is published to room "project_{UUID}"

# Update and create dedicated deployer account
apt update && apt upgrade -y
adduser --gecos "" deploy && usermod -aG sudo deploy

# Copy authorized SSH keys
mkdir -p /home/deploy/.ssh && cp /root/.ssh/authorized_keys /home/deploy/.ssh/
chown -R deploy:deploy /home/deploy/.ssh && chmod 700 /home/deploy/.ssh && chmod 600 /home/deploy/.ssh/authorized_keys

# Enforce UFW firewall
ufw default deny incoming && ufw default allow outgoing
ufw allow 22/tcp && ufw allow 80/tcp && ufw allow 443/tcp
ufw --force enable

# Allocate 4GB swapfile for database stability
fallocate -l 4G /swapfile && chmod 600 /swapfile && mkswap /swapfile && swapon /swapfile
echo '/swapfile none swap sw 0 0' >> /etc/fstab
sysctl vm.swappiness=10 && echo 'vm.swappiness=10' >> /etc/sysctl.conf

# 1. Launch Analysis Portal Container
cd /var/www/analysis-portal
docker build -t strategic-analysis-portal:latest .
docker run -d --name analysis-portal --restart always -p 127.0.0.1:8080:80 strategic-analysis-portal:latest

# 2. Launch Plane Self-Hosted Stack
cd /opt/plane-selfhost
./setup.sh
# Ensure WEB_URL=https://plane.harryngovu.click and NGINX_PORT=8000 in variables.env
docker compose up -d

upstream plane_backend {
    server 127.0.0.1:8000;
    keepalive 32;
}

upstream analysis_portal {
    server 127.0.0.1:8080;
    keepalive 16;
}

server {
    listen 80;
    server_name plane.harryngovu.click;
    client_max_body_size 100M;
    location / {
        proxy_pass http://plane_backend;
        proxy_http_version 1.1;
        proxy_set_header Upgrade $http_upgrade;
        proxy_set_header Connection "upgrade";
        proxy_set_header Host $host;
        proxy_set_header X-Real-IP $remote_addr;
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_set_header X-Forwarded-Proto $scheme;
    }
}

server {
    listen 80;
    server_name harryngovu.click www.harryngovu.click analysis.harryngovu.click;
    location / {
        proxy_pass http://analysis_portal;
        proxy_http_version 1.1;
        proxy_set_header Host $host;
        proxy_set_header X-Real-IP $remote_addr;
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_set_header X-Forwarded-Proto $scheme;
    }
}

-- Open interactive shell
docker exec -it plane-db psql -U planeUser -d planeDB

-- 1. Verify schema tables
\dt

-- 2. Inspect active Workspaces and Projects
SELECT p.id, p.identifier, p.name AS project_name, w.name AS workspace_name 
FROM db_project p
JOIN db_workspace w ON p.workspace_id = w.id;

-- 3. Check Issue distribution across workflow state groups
SELECT s.group, s.name, COUNT(i.id) AS total_issues
FROM db_state s
LEFT JOIN db_issue i ON s.id = i.state_id
GROUP BY s.group, s.name
ORDER BY s.group;

-- 4. Inspect top issues with priority
SELECT sequence_id, name, priority, created_at 
FROM db_issue 
ORDER BY created_at DESC 
LIMIT 10;

# Inside WSL2 terminal (Ubuntu 24.04):
cd /mnt/c/Users/LOQ/Downloads/plane/analysis-portal

# Build & launch container on port 8090
docker build -t strategic-analysis-portal:latest .
docker run -d --name analysis-portal --restart always -p 8090:80 strategic-analysis-portal:latest

# Open in Windows browser:
# Navigate to: http://localhost:8090