startersaas.pro-node-api-main/api/workspaces/workspace.router.js

// api/workspaces/workspace.router.js
import * as express from "express";
import { wrap } from "../../common/exceptions.js";
import workspaceController from "./workspace.controller.js";

export default express
  .Router()
  // Existing routes
  .post("/", wrap(workspaceController.create))
  .get("/", wrap(workspaceController.index))
  .get("/get-this-workspace/:name", wrap(workspaceController.getWorkspaceFile))
  .get("/:id", wrap(workspaceController.byId))
  .put("/:id", wrap(workspaceController.update))
  .delete("/:id", wrap(workspaceController.delete))
  
  // New MySQL database routes
  .get("/:id/db/tables", wrap(workspaceController.listTables))
  .get("/:id/db/data", wrap(workspaceController.getTableData))
  .get("/:id/db/test", wrap(workspaceController.testConnection));