[PR #6] [MERGED] Add WordPress site management with environments, database sync, and Git integration #13

New issue

Closed

opened 2026-03-02 11:44:07 +03:00 by kerem · 0 comments

kerem commented

2026-03-02 11:44:07 +03:00

Owner

📋 Pull Request Information

Original PR: https://github.com/jhd3197/ServerKit/pull/6
Author: @jhd3197
Created: 1/25/2026
Status: ✅ Merged
Merged: 1/26/2026
Merged by: @jhd3197

Base: main ← Head: dev

📝 Commits (10+)

f4ed11c Add WordPress site management API and models
e3d6077 Redirect WordPress apps to dedicated page and refactor
f2216a9 chore: bump version to 1.2.66 [skip ci]
965428d Add border-hover variable and update style aliases
42bcbed chore: bump version to 1.2.67 [skip ci]
6bcbcab Add unified dev scripts and improve login UX
a0f75ab chore: bump version to 1.2.68 [skip ci]
c7444a8 Add resource tier enforcement and UI for WordPress creation
30abb2f Revamp dashboard UI and metrics graph, add animated star
06d63cb Add standalone WordPress and SSL management UI

📊 Changes

77 files changed (+9710 additions, -3753 deletions)

View changed files

📝 CONTRIBUTING.md (+51 -66)
➖ EXPLORATIONS_AND_FUTURE.md (+0 -672)
➖ GITEA_INTEGRATION_PLAN.md (+0 -488)
📝 README.md (+1 -1)
➖ SERVERS_INTEGRATION_PLAN.md (+0 -1535)
➖ SERVER_SECURITY_PLAN.md (+0 -330)
📝 VERSION (+1 -1)
📝 backend/app/__init__.py (+2 -0)
📝 backend/app/api/auth.py (+8 -5)
📝 backend/app/api/ssl.py (+12 -0)
📝 backend/app/api/system.py (+23 -1)
📝 backend/app/api/wordpress.py (+83 -0)
➕ backend/app/api/wordpress_sites.py (+817 -0)
📝 backend/app/models/__init__.py (+3 -1)
➕ backend/app/models/wordpress_site.py (+247 -0)
➕ backend/app/services/db_sync_service.py (+609 -0)
➕ backend/app/services/git_wordpress_service.py (+536 -0)
📝 backend/app/services/nginx_service.py (+119 -0)
➕ backend/app/services/resource_tier_service.py (+184 -0)
➕ backend/app/services/wordpress_env_service.py (+486 -0)

...and 57 more files

📄 Description

Summary

WordPress Management Dashboard: Complete management interface
for WordPress sites with dedicated listing page and detail view
Multi-Environment Support: Create and manage dev/staging
environments linked to production sites
Database Operations: Snapshot, sync, and clone databases between
environments with full backup history
Git Integration: Connect WordPress sites to Git repositories for
version-controlled deployments
Developer Experience: Unified dev scripts moved to
scripts/dev/ with cross-platform support (Windows, Linux, WSL)

Changes

Backend

New WordPress Sites API (/api/wordpress/sites) with full CRUD
operations
WordPressSite model with environment relationships and
DatabaseSnapshot/SyncJob tracking
Services: WordPressEnvService, DatabaseSyncService,
GitWordPressService

Frontend

WordPress listing page (/wordpress) and detail page
(/wordpress/:id)
Reusable components: EnvironmentCard, SnapshotTable,
GitConnectForm, CommitList
WordPress-specific styles and theming
Login UX: Now accepts username or email

Housekeeping

Consolidated dev scripts under scripts/dev/
Removed stale planning documents
Added border-hover CSS variable

_{🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.}

## 📋 Pull Request Information **Original PR:** https://github.com/jhd3197/ServerKit/pull/6 **Author:** [@jhd3197](https://github.com/jhd3197) **Created:** 1/25/2026 **Status:** ✅ Merged **Merged:** 1/26/2026 **Merged by:** [@jhd3197](https://github.com/jhd3197) **Base:** `main` ← **Head:** `dev` --- ### 📝 Commits (10+) - [`f4ed11c`](https://github.com/jhd3197/ServerKit/commit/f4ed11ceafa45735962eef13054131da211abeab) Add WordPress site management API and models - [`e3d6077`](https://github.com/jhd3197/ServerKit/commit/e3d60775faf8dd2b46c3b2a6e5385872e236ccae) Redirect WordPress apps to dedicated page and refactor - [`f2216a9`](https://github.com/jhd3197/ServerKit/commit/f2216a99814a883cd8b649ec82c8e1ffc1abd1f5) chore: bump version to 1.2.66 [skip ci] - [`965428d`](https://github.com/jhd3197/ServerKit/commit/965428d48b416d7d92beeb363cab17df9f7efd4d) Add border-hover variable and update style aliases - [`42bcbed`](https://github.com/jhd3197/ServerKit/commit/42bcbed19dbb682cb0ec295b57806c65dcbb8e01) chore: bump version to 1.2.67 [skip ci] - [`6bcbcab`](https://github.com/jhd3197/ServerKit/commit/6bcbcab56a2f9d5e42c6d582b1f10ee0a97a5c80) Add unified dev scripts and improve login UX - [`a0f75ab`](https://github.com/jhd3197/ServerKit/commit/a0f75ab2d4e2e848bbe0e65639fc156727b32939) chore: bump version to 1.2.68 [skip ci] - [`c7444a8`](https://github.com/jhd3197/ServerKit/commit/c7444a88f5f7292701ce1794df2b9d3af89e7eea) Add resource tier enforcement and UI for WordPress creation - [`30abb2f`](https://github.com/jhd3197/ServerKit/commit/30abb2fdfa9f60d0ff2cd8841309cf412646711c) Revamp dashboard UI and metrics graph, add animated star - [`06d63cb`](https://github.com/jhd3197/ServerKit/commit/06d63cbc52d811a4aa1238c206fe8bbdd2fdd534) Add standalone WordPress and SSL management UI ### 📊 Changes **77 files changed** (+9710 additions, -3753 deletions) <details> <summary>View changed files</summary> 📝 `CONTRIBUTING.md` (+51 -66) ➖ `EXPLORATIONS_AND_FUTURE.md` (+0 -672) ➖ `GITEA_INTEGRATION_PLAN.md` (+0 -488) 📝 `README.md` (+1 -1) ➖ `SERVERS_INTEGRATION_PLAN.md` (+0 -1535) ➖ `SERVER_SECURITY_PLAN.md` (+0 -330) 📝 `VERSION` (+1 -1) 📝 `backend/app/__init__.py` (+2 -0) 📝 `backend/app/api/auth.py` (+8 -5) 📝 `backend/app/api/ssl.py` (+12 -0) 📝 `backend/app/api/system.py` (+23 -1) 📝 `backend/app/api/wordpress.py` (+83 -0) ➕ `backend/app/api/wordpress_sites.py` (+817 -0) 📝 `backend/app/models/__init__.py` (+3 -1) ➕ `backend/app/models/wordpress_site.py` (+247 -0) ➕ `backend/app/services/db_sync_service.py` (+609 -0) ➕ `backend/app/services/git_wordpress_service.py` (+536 -0) 📝 `backend/app/services/nginx_service.py` (+119 -0) ➕ `backend/app/services/resource_tier_service.py` (+184 -0) ➕ `backend/app/services/wordpress_env_service.py` (+486 -0) _...and 57 more files_ </details> ### 📄 Description ## Summary - **WordPress Management Dashboard**: Complete management interface for WordPress sites with dedicated listing page and detail view - **Multi-Environment Support**: Create and manage dev/staging environments linked to production sites - **Database Operations**: Snapshot, sync, and clone databases between environments with full backup history - **Git Integration**: Connect WordPress sites to Git repositories for version-controlled deployments - **Developer Experience**: Unified dev scripts moved to `scripts/dev/` with cross-platform support (Windows, Linux, WSL) ## Changes ### Backend - New WordPress Sites API (`/api/wordpress/sites`) with full CRUD operations - `WordPressSite` model with environment relationships and `DatabaseSnapshot`/`SyncJob` tracking - Services: `WordPressEnvService`, `DatabaseSyncService`, `GitWordPressService` ### Frontend - WordPress listing page (`/wordpress`) and detail page (`/wordpress/:id`) - Reusable components: `EnvironmentCard`, `SnapshotTable`, `GitConnectForm`, `CommitList` - WordPress-specific styles and theming - Login UX: Now accepts username or email ### Housekeeping - Consolidated dev scripts under `scripts/dev/` - Removed stale planning documents - Added `border-hover` CSS variable --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>