FM / balavpn.abdallabala.com

/home/techb158/balavpn.abdallabala.com/

/home/techb158/balavpn.abdallabala.com

Name	Size	Mode	Actions
.git/	-	0755	rm
.github/	-	0755	rm
.next/	-	0777	rm
.well-known/	-	0755	rm
blxsenk/	-	0755	rm
bsahcio/	-	0755	rm
cgi-bin/	-	0755	rm
deploy/	-	0777	rm
docs/	-	0777	rm
emnbsuk/	-	0755	rm
gqefxrw/	-	0755	rm
jmvybrk/	-	0755	rm
ne1uwzb/	-	0755	rm
node_modules/	-	0777	rm
ojyauew/	-	0755	rm
oyqfklp/	-	0755	rm
prisma/	-	0777	rm
public/	-	0777	rm
rxfwzbq/	-	0755	rm
saas-app/	-	0755	rm
scripts/	-	0777	rm
src/	-	0755	rm
tests/	-	0777	rm
trwaeuc/	-	0755	rm
xqcyzpj/	-	0755	rm
yirxnfc/	-	0755	rm
.dockerignore	164	0644	edit dl rm
.env	1808	0666	edit dl rm
.env-backup	249	0666	edit dl rm
.env.example	1962	0644	edit dl rm
.env.production	1473	0644	edit dl rm
.gitignore	74	0644	edit dl rm
.htaccess	281	0644	edit dl rm
deploy.log	7656	0644	edit dl rm
docker-compose.monitoring.yml	254	0644	edit dl rm
docker-compose.prod.yml	3400	0644	edit dl rm
docker-compose.supabase.yml	1043	0644	edit dl rm
docker-compose.yml	2295	0644	edit dl rm
Dockerfile	1310	0644	edit dl rm
jsconfig.json	95	0644	edit dl rm
local-server.err.log	0	0666	edit dl rm
local-server.js	49177	0644	edit dl rm
local-server.out.log	0	0666	edit dl rm
mock-oidc-provider.js	7016	0644	edit dl rm
next.config.mjs	219	0644	edit dl rm
package-lock.json	237656	0644	edit dl rm
package.json	2296	0644	edit dl rm
README.md	2150	0644	edit dl rm
saas-app.zip	223122322	0644	edit dl rm
truncate_demo.sql	1676	0644	edit dl rm
wp-cron-owhg.php	1659	0644	edit dl rm

Edit: /home/techb158/balavpn.abdallabala.com/truncate_demo.sql (1676B)

DO $$
DECLARE
    demo_org_id TEXT;
    demo_workspace_id TEXT;
    demo_project_id TEXT;
BEGIN
    -- Find the COSMIC Demo Organization
    SELECT id INTO demo_org_id FROM "Organization" WHERE name = 'COSMIC Demo Org';
    
    -- Find the workspace for this organization
    SELECT id INTO demo_workspace_id FROM "Workspace" WHERE "organizationId" = demo_org_id AND name = 'AI Risk Governance';
    
    -- Find the DEMO project in that workspace
    SELECT id INTO demo_project_id FROM "Project" WHERE "workspaceId" = demo_workspace_id AND name = 'AI Risk Governance';
    
    -- Truncate all demo project tables in reverse order (foreign key dependencies)
    EXECUTE 'TRUNCATE TABLE "ReportExport" CASCADE';
    EXECUTE 'TRUNCATE TABLE "ScheduledReport" CASCADE';
    EXECUTE 'TRUNCATE TABLE "GateEvaluation" CASCADE';
    EXECUTE 'TRUNCATE TABLE "GateDecision" CASCADE';
    EXECUTE 'TRUNCATE TABLE "GateCriterion" CASCADE';
    EXECUTE 'TRUNCATE TABLE "Experiment" CASCADE';
    EXECUTE 'TRUNCATE TABLE "ModelMetric" CASCADE';
    EXECUTE 'TRUNCATE TABLE "Indicator" CASCADE';
    EXECUTE 'TRUNCATE TABLE "Evidence" CASCADE';
    EXECUTE 'TRUNCATE TABLE "Mitigation" CASCADE';
    EXECUTE 'TRUNCATE TABLE "Risk" CASCADE';
    EXECUTE 'TRUNCATE TABLE "LifecyclePhase" CASCADE';
    EXECUTE 'TRUNCATE TABLE "ExternalWorkItemMapping" CASCADE';
    EXECUTE 'TRUNCATE TABLE "IntegrationSyncRun" CASCADE';
    EXECUTE 'TRUNCATE TABLE "Integration" CASCADE';
    EXECUTE 'TRUNCATE TABLE "Workspace" CASCADE';
    EXECUTE 'TRUNCATE TABLE "Membership" CASCADE';
    EXECUTE 'TRUNCATE TABLE "OrganizationAccess" CASCADE';
    EXECUTE 'TRUNCATE TABLE "Project" CASCADE';
END $$;

DO $$ DECLARE demo_org_id TEXT; demo_workspace_id TEXT; demo_project_id TEXT; BEGIN -- Find the COSMIC Demo Organization SELECT id INTO demo_org_id FROM "Organization" WHERE name = 'COSMIC Demo Org'; -- Find the workspace for this organization SELECT id INTO demo_workspace_id FROM "Workspace" WHERE "organizationId" = demo_org_id AND name = 'AI Risk Governance'; -- Find the DEMO project in that workspace SELECT id INTO demo_project_id FROM "Project" WHERE "workspaceId" = demo_workspace_id AND name = 'AI Risk Governance'; -- Truncate all demo project tables in reverse order (foreign key dependencies) EXECUTE 'TRUNCATE TABLE "ReportExport" CASCADE'; EXECUTE 'TRUNCATE TABLE "ScheduledReport" CASCADE'; EXECUTE 'TRUNCATE TABLE "GateEvaluation" CASCADE'; EXECUTE 'TRUNCATE TABLE "GateDecision" CASCADE'; EXECUTE 'TRUNCATE TABLE "GateCriterion" CASCADE'; EXECUTE 'TRUNCATE TABLE "Experiment" CASCADE'; EXECUTE 'TRUNCATE TABLE "ModelMetric" CASCADE'; EXECUTE 'TRUNCATE TABLE "Indicator" CASCADE'; EXECUTE 'TRUNCATE TABLE "Evidence" CASCADE'; EXECUTE 'TRUNCATE TABLE "Mitigation" CASCADE'; EXECUTE 'TRUNCATE TABLE "Risk" CASCADE'; EXECUTE 'TRUNCATE TABLE "LifecyclePhase" CASCADE'; EXECUTE 'TRUNCATE TABLE "ExternalWorkItemMapping" CASCADE'; EXECUTE 'TRUNCATE TABLE "IntegrationSyncRun" CASCADE'; EXECUTE 'TRUNCATE TABLE "Integration" CASCADE'; EXECUTE 'TRUNCATE TABLE "Workspace" CASCADE'; EXECUTE 'TRUNCATE TABLE "Membership" CASCADE'; EXECUTE 'TRUNCATE TABLE "OrganizationAccess" CASCADE'; EXECUTE 'TRUNCATE TABLE "Project" CASCADE'; END $$;