AppCreator

AppCreator · GPT 작업

A cloud-native platform designed for rapid and automated web application development

A cloud-native platform designed for rapid and automated web application development.

  • POST /com/codetg/ai/dev/openai/plugin/api/app/app/create.jssCreate a new application.
  • POST /com/codetg/ai/dev/openai/plugin/api/app/app/delete.jssDelete a application, ask user to confirm before call this api, it's a dangerous operation, can not recover after deleted
  • POST /com/codetg/ai/dev/openai/plugin/api/app/app/my_list.jsslist user's applications
  • POST /com/codetg/ai/dev/openai/plugin/api/app/app/open_or_view.jssopen a application or view current opened application's information
  • POST /com/codetg/ai/dev/openai/plugin/api/app/db/execute_update.jssExecute sqls to create/modify/drop tables or insert/update/delete data, database is mysql
  • POST /com/codetg/ai/dev/openai/plugin/api/app/db/query.jssquery data from database , support any select SQL sentence
  • POST /com/codetg/ai/dev/openai/plugin/api/app/db/get_table_schema.jssGet all table and table schema information
  • POST /com/codetg/ai/dev/openai/plugin/api/app/file/get.jssRetrieve detailed information of a file.
  • POST /com/codetg/ai/dev/openai/plugin/api/app/file/list.jssRetrieve files starting with a specified path.
  • POST /com/codetg/ai/dev/openai/plugin/api/app/file/save.jssCreate or update a file. A version number is required when updating an existing file.
  • POST /com/codetg/ai/dev/openai/plugin/api/app/lib/lib.jssRetrieve library details and usage example based on type.
  • POST /com/codetg/ai/dev/openai/plugin/api/app/cicd/run_test.jssRun tests for domain service and ui
  • POST /com/codetg/base/dev/facade/api/template/run_ddl.jssRun DDL (domain description language) file to generate apis
  • POST /com/codetg/ai/dev/openai/plugin/api/app/config/openapi.jssGet openapi document of the given apis or get all openapi document, URLs can be partial paths.
원본 API 스키마
{
  "openapi": "3.0.0",
  "info": {
    "version": "1.0.0",
    "title": "A cloud-native platform designed for rapid and automated web application development",
    "description": "A cloud-native platform designed for rapid and automated web application development."
  },
  "servers": [
    {
      "url": "https://aier3.com/"
    }
  ],
  "paths": {
    "/com/codetg/ai/dev/openai/plugin/api/app/app/create.jss": {
      "post": {
        "summary": "Create a new application.",
        "operationId": "createApplication",
        "requestBody": {
          "required": true,
          "content": {
            "application/json": {
              "schema": {
                "type": "object",
                "properties": {
                  "appName": {
                    "type": "string",
                    "description": "english name of the application"
                  },
                  "orgId": {
                    "type": "string",
                    "description": "The organization identifier indicates which organization an application belongs to. English words in the identifier are separated by dots, Example: com.demo"
                  }
                },
                "required": [
                  "appName"
                ]
              }
            }
          }
        },
        "responses": {
          "200": {
            "description": "OK",
            "content": {
              "application/json": {
                "schema": {
                  "type": "object",
                  "properties": {
                    "base_path": {
                      "type": "string",
                      "description": "base path of  application files"
                    },
                    "id": {
                      "type": "number",
                      "description": "id of the application"
                    },
                    "code": {
                      "type": "string",
                      "description": "code is success  or errcode"
                    },
                    "msg": {
                      "type": "string",
                      "description": "success or error message"
                    }
                  }
                }
              }
            }
          }
        }
      }
    },
    "/com/codetg/ai/dev/openai/plugin/api/app/app/delete.jss": {
      "post": {
        "summary": "Delete a application, ask user to confirm before call this api, it's a dangerous operation, can not recover after deleted",
        "operationId": "deleteApplication",
        "requestBody": {
          "required": true,
          "content": {
            "application/json": {
              "schema": {
                "type": "object",
                "properties": {
                  "id": {
                    "type": "Integer",
                    "description": "id of the application"
                  }
                }
              }
            }
          }
        },
        "responses": {
          "200": {
            "description": "OK",
            "content": {
              "application/json": {
                "schema": {
                  "type": "object",
                  "properties": {
                    "code": {
                      "type": "string",
                      "description": "code is success  or errcode"
                    },
                    "msg": {
                      "type": "string",
                      "description": "success or error message"
                    }
                  }
                }
              }
            }
          }
        }
      }
    },
    "/com/codetg/ai/dev/openai/plugin/api/app/app/my_list.jss": {
      "post": {
        "summary": "list user's applications",
        "operationId": "listMyApplications",
        "tags": [
          "listMyApplication"
        ],
        "requestBody": {
          "required": true,
          "content": {
            "application/json": {
              "schema": {}
            }
          }
        },
        "responses": {
          "200": {
            "description": "OK",
            "content": {
              "application/json": {
                "schema": {
                  "type": "object",
                  "properties": {
                    "code": {
                      "type": "string",
                      "description": "code is success  or errcode"
                    },
                    "msg": {
                      "type": "string",
                      "description": "success or error message"
                    },
                    "list": {
                      "type": "array",
                      "items": {
                        "type": "object",
                        "properties": {
                          "id": {
                            "type": "integer",
                            "description": "id of application"
                          },
                          "name": {
                            "type": "string",
                            "description": "name of application"
                          }
                        }
                      }
                    }
                  }
                }
              }
            }
          }
        }
      }
    },
    "/com/codetg/ai/dev/openai/plugin/api/app/app/open_or_view.jss": {
      "post": {
        "summary": "open a application or view current opened application's information",
        "operationId": "openOrViewApplication",
        "requestBody": {
          "required": true,
          "content": {
            "application/json": {
              "schema": {
                "type": "object",
                "properties": {
                  "id": {
                    "type": "Integer",
                    "description": "id of the application, required when open a application "
                  }
                }
              }
            }
          }
        },
        "responses": {
          "200": {
            "description": "OK",
            "content": {
              "application/json": {
                "schema": {
                  "type": "object",
                  "properties": {
                    "base_path": {
                      "type": "string",
                      "description": "base path of  application files"
                    },
                    "app_source_url": {
                      "type": "string",
                      "description": "source code url of the application"
                    },
                    "plugin_config_url": {
                      "type": "string",
                      "description": "ChatGPT plugin configuration url for the application"
                    },
                    "id": {
                      "type": "Integer",
                      "description": "id of the application"
                    },
                    "code": {
                      "type": "string",
                      "description": "code is success  or errcode"
                    },
                    "msg": {
                      "type": "string",
                      "description": "success or error message"
                    }
                  }
                }
              }
            }
          }
        }
      }
    },
    "/com/codetg/ai/dev/openai/plugin/api/app/db/execute_update.jss": {
      "post": {
        "summary": "Execute sqls to create/modify/drop tables or insert/update/delete data, database is mysql",
        "operationId": "executeUpdate",
        "requestBody": {
          "required": true,
          "content": {
            "application/json": {
              "schema": {
                "type": "object",
                "properties": {
                  "sqls": {
                    "type": "string",
                    "description": "Multiple sqls should be seperated by semicolon;"
                  }
                }
              }
            }
          }
        },
        "responses": {
          "200": {
            "description": "OK",
            "content": {
              "application/json": {
                "schema": {
                  "type": "object",
                  "properties": {
                    "code": {
                      "type": "string",
                      "description": "code is success  or errcode"
                    },
                    "msg": {
                      "type": "string",
                      "description": "success or error message"
                    }
                  }
                }
              }
            }
          }
        }
      }
    },
    "/com/codetg/ai/dev/openai/plugin/api/app/db/query.jss": {
      "post": {
        "summary": "query data from database , support any select SQL sentence",
        "operationId": "query",
        "tags": [
          "query"
        ],
        "requestBody": {
          "required": true,
          "content": {
            "application/json": {
              "schema": {
                "type": "object",
                "properties": {
                  "sql": {
                    "type": "string",
                    "description": "a SQL query , Example : select * from table_name where  field_name = 'some value', database is  mysql"
                  },
                  "itemsPerPage": {
                    "type": "number",
                    "description": "Items per page"
                  },
                  "page": {
                    "type": "number",
                    "description": "current page no "
                  }
                }
              }
            }
          }
        },
        "responses": {
          "200": {
            "description": "OK",
            "content": {
              "application/json": {
                "schema": {
                  "type": "object",
                  "properties": {
                    "data": {
                      "type": "array",
                      "description": "get data result from SQL "
                    },
                    "code": {
                      "type": "string",
                      "description": "code is success  or errcode"
                    },
                    "msg": {
                      "type": "string",
                      "description": "success or error message"
                    }
                  }
                }
              }
            }
          }
        }
      }
    },
    "/com/codetg/ai/dev/openai/plugin/api/app/db/get_table_schema.jss": {
      "post": {
        "summary": "Get all table  and table schema information ",
        "operationId": "getAllTableAndSechema",
        "tags": [
          "getTableSechema"
        ],
        "requestBody": {
          "required": true,
          "content": {
            "application/json": {
              "schema": {
                "type": "object",
                "properties": {}
              }
            }
          }
        },
        "responses": {
          "200": {
            "description": "OK",
            "content": {
              "application/json": {
                "schema": {
                  "type": "object",
                  "properties": {
                    "tableSchema": {
                      "type": "array",
                      "description": "All table name and  table  schema , suggest presenting it using tables to user "
                    },
                    "code": {
                      "type": "string",
                      "description": "code is success  or errcode"
                    },
                    "msg": {
                      "type": "string",
                      "description": "success or error message"
                    }
                  }
                }
              }
            }
          }
        }
      }
    },
    "/com/codetg/ai/dev/openai/plugin/api/app/file/get.jss": {
      "post": {
        "summary": "Retrieve detailed information of a file.",
        "operationId": "getFileInfo",
        "requestBody": {
          "required": true,
          "content": {
            "application/json": {
              "schema": {
                "type": "object",
                "properties": {
                  "file_path": {
                    "type": "string",
                    "description": "Path of the file."
                  }
                }
              }
            }
          }
        },
        "responses": {
          "200": {
            "description": "OK",
            "content": {
              "application/json": {
                "schema": {
                  "type": "object",
                  "properties": {
                    "file_content": {
                      "type": "string",
                      "description": "Content of the file, typically source code or related data."
                    },
                    "remark": {
                      "type": "string",
                      "description": "Remarks about the file."
                    },
                    "version": {
                      "type": "integer",
                      "description": "File version number."
                    },
                    "code": {
                      "type": "string",
                      "description": "Status code (success or error)."
                    },
                    "msg": {
                      "type": "string",
                      "description": "Result message."
                    }
                  }
                }
              }
            }
          }
        }
      }
    },
    "/com/codetg/ai/dev/openai/plugin/api/app/file/list.jss": {
      "post": {
        "summary": "Retrieve files starting with a specified path.",
        "operationId": "getFileList",
        "requestBody": {
          "required": true,
          "content": {
            "application/json": {
              "schema": {
                "type": "object",
                "properties": {
                  "file_path": {
                    "type": "string",
                    "description": "Path prefix to filter files."
                  }
                }
              }
            }
          }
        },
        "responses": {
          "200": {
            "description": "Successful retrieval of files.",
            "content": {
              "application/json": {
                "schema": {
                  "type": "object",
                  "properties": {
                    "list": {
                      "type": "array",
                      "description": "List of files with specified path prefix.",
                      "items": {
                        "type": "object",
                        "properties": {
                          "file_name": {
                            "type": "string",
                            "description": "File name."
                          },
                          "file_path": {
                            "type": "string",
                            "description": "Full file path."
                          },
                          "remark": {
                            "type": "string",
                            "description": "File remarks."
                          }
                        }
                      }
                    },
                    "code": {
                      "type": "string",
                      "description": "Status code (success or error)."
                    },
                    "msg": {
                      "type": "string",
                      "description": "Result message."
                    }
                  }
                }
              }
            }
          }
        }
      }
    },
    "/com/codetg/ai/dev/openai/plugin/api/app/file/save.jss": {
      "post": {
        "summary": "Create or update a file. A version number is required when updating an existing file.",
        "operationId": "createUpdateFile",
        "requestBody": {
          "required": true,
          "content": {
            "application/json": {
              "schema": {
                "type": "object",
                "properties": {
                  "version": {
                    "type": "integer",
                    "description": "Version number of the file. Required when updating an existing file."
                  },
                  "file_path": {
                    "type": "string",
                    "description": "Path of the file."
                  },
                  "append": {
                    "type": "boolean",
                    "description": "Indicates if the content should be appended to the file."
                  },
                  "file_content": {
                    "type": "string",
                    "default": false,
                    "description": "Content of the file, typically the source code."
                  },
                  "remark": {
                    "type": "string",
                    "description": "Remarks or notes related to the file."
                  }
                }
              }
            }
          }
        },
        "responses": {
          "200": {
            "description": "OK",
            "content": {
              "application/json": {
                "schema": {
                  "type": "object",
                  "properties": {
                    "version": {
                      "type": "integer",
                      "description": "Latest version number of the file. Use this version number for subsequent updates to ensure data consistency."
                    },
                    "preview_url": {
                      "type": "string",
                      "description": "URL for previewing."
                    },
                    "code": {
                      "type": "string",
                      "description": "Response code indicating success or specific error codes. "
                    },
                    "msg": {
                      "type": "string",
                      "description": "Message providing additional details on the response. "
                    }
                  }
                }
              }
            }
          }
        }
      }
    },
    "/com/codetg/ai/dev/openai/plugin/api/app/lib/lib.jss": {
      "post": {
        "summary": "Retrieve library details and usage example based on type.",
        "operationId": "getLibraryAndExample",
        "requestBody": {
          "required": true,
          "content": {
            "application/json": {
              "schema": {
                "type": "object",
                "properties": {
                  "type": {
                    "type": "string",
                    "description": "Specifies the category of library and example.",
                    "enum": [
                      "domain",
                      "ddl",
                      "ui",
                      "ui_test"
                    ]
                  }
                },
                "required": [
                  "type"
                ]
              }
            }
          }
        },
        "responses": {
          "200": {
            "description": "OK",
            "content": {
              "application/json": {
                "schema": {
                  "type": "object",
                  "properties": {
                    "library": {
                      "type": "string",
                      "description": "Description of the library. All functions and variables are global and can be accessed directly."
                    },
                    "example": {
                      "type": "string",
                      "description": "Demonstrative usage of the library."
                    },
                    "code": {
                      "type": "string",
                      "description": "Indicates success or an error code."
                    },
                    "msg": {
                      "type": "string",
                      "description": "Detailed message indicating success or the nature of the error."
                    }
                  }
                }
              }
            }
          }
        }
      }
    },
    "/com/codetg/ai/dev/openai/plugin/api/app/cicd/run_test.jss": {
      "post": {
        "summary": "Run tests for  domain service  and ui ",
        "operationId": "runTests",
        "requestBody": {
          "required": true,
          "content": {
            "application/json": {
              "schema": {
                "type": "object",
                "properties": {
                  "file_path": {
                    "type": "string"
                  },
                  "function_name": {
                    "type": "string"
                  },
                  "function_param": {
                    "type": "array",
                    "items": {
                      "oneOf": [
                        {
                          "type": "string"
                        },
                        {
                          "type": "number"
                        },
                        {
                          "type": "boolean"
                        },
                        {
                          "type": "null"
                        },
                        {
                          "type": "object"
                        },
                        {
                          "type": "array",
                          "items": {}
                        }
                      ]
                    },
                    "description": "Parameters of the function for domain service, type is Array , example:[{'userid':'user123'},'jack',123]"
                  }
                }
              }
            }
          }
        },
        "responses": {
          "200": {
            "description": "OK",
            "content": {
              "application/json": {
                "schema": {
                  "type": "object",
                  "properties": {
                    "console": {
                      "type": "object",
                      "description": "console log messages"
                    },
                    "result": {
                      "type": "object",
                      "description": "The result of function call returned when code is success"
                    },
                    "error_trace": {
                      "type": "object",
                      "description": "error trace"
                    },
                    "code": {
                      "type": "string",
                      "description": "code is success  or errcode"
                    },
                    "msg": {
                      "type": "string",
                      "description": "success or error message"
                    }
                  }
                }
              }
            }
          }
        }
      }
    },
    "/com/codetg/base/dev/facade/api/template/run_ddl.jss": {
      "post": {
        "summary": "Run DDL (domain description language) file to generate apis",
        "operationId": "runDDL",
        "requestBody": {
          "required": true,
          "content": {
            "application/json": {
              "schema": {
                "type": "object",
                "properties": {
                  "file_path": {
                    "type": "string",
                    "description": "file path"
                  }
                }
              }
            }
          }
        },
        "responses": {
          "200": {
            "description": "OK",
            "content": {
              "application/json": {
                "schema": {
                  "type": "object",
                  "properties": {
                    "result": {
                      "type": "object",
                      "description": "The result of function call returned when code is success"
                    },
                    "apis": {
                      "type": "array",
                      "items": {
                        "type": "string"
                      },
                      "description": "api urls "
                    },
                    "domain_service_path": {
                      "type": "string",
                      "description": "domain service file  path"
                    },
                    "code": {
                      "type": "string",
                      "description": "Code is success or error code"
                    },
                    "msg": {
                      "type": "string",
                      "description": "Success or error message"
                    }
                  }
                }
              }
            }
          }
        }
      }
    },
    "/com/codetg/ai/dev/openai/plugin/api/app/config/openapi.jss": {
      "post": {
        "summary": "Get openapi document of the given apis or get all openapi document, URLs can be partial paths.  ",
        "operationId": "getOpenapiDoc",
        "requestBody": {
          "content": {
            "application/json": {
              "schema": {
                "type": "object",
                "properties": {
                  "apis": {
                    "type": "array",
                    "items": {
                      "type": "string"
                    },
                    "description": "Retrieve the OpenAPI document for the specified API URLs, URLs can be partial paths. "
                  }
                }
              }
            }
          }
        },
        "responses": {
          "200": {
            "description": "OK",
            "content": {
              "application/json": {
                "schema": {
                  "type": "object",
                  "properties": {
                    "openapi_doc": {
                      "type": "object",
                      "description": "openapi document  "
                    },
                    "code": {
                      "type": "string",
                      "description": "code is success  or errcode"
                    },
                    "msg": {
                      "type": "string",
                      "description": "success or error message"
                    }
                  }
                }
              }
            }
          }
        }
      }
    }
  }
}