วิธี Sync Workspace ใน Frappe ด้วย Delete+Reinsert Pattern

import frappe
 
def sync_workspaces():
    """ลบและสร้าง Workspace ใหม่เพื่อ Apply JSON Changes"""
    workspaces_to_sync = [
        "Your Workspace 1",
        "Your Workspace 2",
    ]
 
    for ws_name in workspaces_to_sync:
        if frappe.db.exists("Workspace", ws_name):
            frappe.delete_doc("Workspace", ws_name, force=True)
            frappe.db.commit()
            print(f"Deleted workspace: {ws_name}")
 
    # Workspace จะถูกสร้างใหม่เมื่อรัน migrate
    print("Run 'bench migrate' to recreate workspaces")

import frappe
import json
 
def sync_workspace(workspace_name: str):
    """Delete และ Reinsert Workspace พร้อม Child Tables"""
 
    # 1. ลบ Workspace และ Child Tables ที่เกี่ยวข้อง
    if frappe.db.exists("Workspace", workspace_name):
        frappe.db.delete("Workspace", {"name": workspace_name})
        frappe.db.delete("Workspace Link", {"parent": workspace_name})
        frappe.db.delete("Workspace Shortcut", {"parent": workspace_name})
        frappe.db.delete("Workspace Chart", {"parent": workspace_name})
        frappe.db.delete("Workspace Number Card", {"parent": workspace_name})
        frappe.db.commit()
        print(f"Deleted: {workspace_name}")
 
    # 2. โหลด JSON File
    workspace_json_path = frappe.get_app_path(
        "your_app",
        "your_module",
        "workspace",
        workspace_name.lower().replace(" ", "_"),
        f"{workspace_name.lower().replace(' ', '_')}.json"
    )
 
    with open(workspace_json_path, 'r', encoding='utf-8') as f:
        workspace_data = json.load(f)
 
    # 3. Insert ใหม่
    doc = frappe.get_doc(workspace_data)
    doc.flags.ignore_permissions = True
    doc.flags.ignore_links = True
    doc.insert(ignore_permissions=True)
 
    # 4. Commit และ Clear Cache
    frappe.db.commit()
    frappe.cache().flushall()
    print(f"Recreated: {workspace_name}")
 
 
def sync_all_workspaces():
    """Sync ทุก Workspaces ของ App"""
    workspaces = [
        "Dashboard",
        "Settings",
        "Reports",
    ]
 
    for ws in workspaces:
        sync_workspace(ws)

{
  "doctype": "Workspace",
  "name": "Your Workspace",
  "label": "Your Workspace",
  "module": "Your Module",
  "icon": "organization",
  "public": 1,
  "content": "[...]",
  "links": [...],
  "shortcuts": [...],
  "charts": [...],
  "number_cards": [...]
}