数据库配置

\RG3.Web.Host.PaaS\Config\App{ownerId}\db.provider.Production.json

  "ConnZentao": {
    "remark": "备注",
    "name": "ConnZentao",
    "databaseType": "MySql",
    "providerName": "MySql.Data.MySqlClient",
    "read": [
      "Data Source=localhost;Initial Catalog=tosoft_bs_zentao;User Id=tosoft;Password=123456;charset=utf8"
    ],
    "write": [
      "Data Source=localhost;Initial Catalog=tosoft_bs_zentao;User Id=tosoft;Password=123456;charset=utf8"
    ]
  },

connbasis.json

\RG3.Web.Host.PaaS\App_Data\ApiDocument\devbuild\connbasis.json

1、数据库DevBuild MapperBridge(ConnXcxt对应数据库连接串)

   {
          "name": "ConnXcxt",
          "request": {
            "method": "POST",
            "header": [
              {
                "description": "项目识别编号(小写)",
                "key": "XownerId",
                "type": "text",
                "value": "bt"
              }
            ],
            "body": {
              "mode": "raw",
              "raw": "[]",
              "options": {
                "raw": {
                  "language": "json"
                }
              }
            },
            "url": {
              "raw": "http://localhost:5900/bo/api/v3/bi/db/devcode?ignore=true&ownerId=bt&sysId&connName=ConnXcxt&templates=devextand",
              "protocol": "http",
              "host": [
                "localhost"
              ],
              "port": "5900",
              "path": [
                "bo",
                "api",
                "v3",
                "bi",
                "db",
                "devcode"
              ],
              "query": [
                {
                  "key": "ignore",
                  "value": "true"
                },
                {
                  "key": "ownerId",
                  "value": "bt"
                },
                {
                  "key": "sysId",
                  "value": null
                },
                {
                  "key": "connName",
                  "value": "ConnXcxt"
                },
                {
                  "key": "templates",
                  "value": "devbuild"
                }
              ]
            },
            "description": "1、用于后台管理映射配置"
          },
          "response": []
        },

2、数据库MapperBridge辅助代码


        {
          "name": "ConnXcxt",
          "request": {
            "method": "POST",
            "header": [
              {
                "description": "项目识别编号(小写)",
                "key": "XownerId",
                "type": "text",
                "value": "bt"
              }
            ],
            "body": {
              "mode": "raw",
              "raw": "[]",
              "options": {
                "raw": {
                  "language": "json"
                }
              }
            },
            "url": {
              "raw": "http://localhost:5900/bo/api/v3/bi/db/devcode?ignore=true&ownerId=bt&sysId&connName=ConnXcxt&templates=devextand",
              "protocol": "http",
              "host": [
                "localhost"
              ],
              "port": "5900",
              "path": [
                "bo",
                "api",
                "v3",
                "bi",
                "db",
                "devcode"
              ],
              "query": [
                {
                  "key": "ignore",
                  "value": "true"
                },
                {
                  "key": "ownerId",
                  "value": "bt"
                },
                {
                  "key": "sysId",
                  "value": null
                },
                {
                  "key": "connName",
                  "value": "ConnXcxt"
                },
                {
                  "key": "templates",
                  "value": "devextand"
                }
              ]
            },
            "description": "1、用于后台管理映射配置"
          },
          "response": []
        },

3、数据库字典(文档)

     {
          "name": "ConnXcxt",
          "request": {
            "method": "POST",
            "header": [
              {
                "description": "项目识别编号(小写)",
                "key": "XownerId",
                "type": "text",
                "value": "bt"
              }
            ],
            "body": {
              "mode": "raw",
              "raw": "[]",
              "options": {
                "raw": {
                  "language": "json"
                }
              }
            },
            "url": {
              "raw": "http://localhost:5900/bo/api/v3/bi/db/document?ignore=true&ownerId=bt&sysId&connName=ConnXcxt&templates=Basis",
              "protocol": "http",
              "host": [
                "localhost"
              ],
              "port": "5900",
              "path": [
                "bo",
                "api",
                "v3",
                "bi",
                "db",
                "document"
              ],
              "query": [
                {
                  "key": "ignore",
                  "value": "true"
                },
                {
                  "key": "ownerId",
                  "value": "bt"
                },
                {
                  "key": "sysId",
                  "value": null
                },
                {
                  "key": "connName",
                  "value": "ConnXcxt"
                },
                {
                  "key": "templates",
                  "value": "Basis"
                }
              ]
            },
            "description": "1、用于后台管理映射配置"
          },
          "response": []
        },

4、数据库Postman-Build-API


        {
          "name": "ConnXcxt",
          "request": {
            "method": "POST",
            "header": [
              {
                "description": "项目识别编号(小写)",
                "key": "XownerId",
                "type": "text",
                "value": "bt"
              }
            ],
            "body": {
              "mode": "raw",
              "raw": "[]",
              "options": {
                "raw": {
                  "language": "json"
                }
              }
            },
            "url": {
              "raw": "http://localhost:5900/bo/api/v3/bi/db/devcode?ignore=true&ownerId=bt&sysId&connName=ConnXcxt&templates=api",
              "protocol": "http",
              "host": [
                "localhost"
              ],
              "port": "5900",
              "path": [
                "bo",
                "api",
                "v3",
                "bi",
                "db",
                "devcode"
              ],
              "query": [
                {
                  "key": "ignore",
                  "value": "true"
                },
                {
                  "key": "ownerId",
                  "value": "bt"
                },
                {
                  "key": "sysId",
                  "value": null
                },
                {
                  "key": "connName",
                  "value": "ConnXcxt"
                },
                {
                  "key": "templates",
                  "value": "api"
                }
              ]
            },
            "description": "1、用于后台管理映射配置"
          },
          "response": []
        },

4、数据库Postman-Build-API

进入后台管理,点击接口工具

http://localhost:5775/auth/main-content

选择一个链接名,参数改成新的生成

找到生成的文件名目录,把里面文件剪切到新目录(并重命名)

旧:
\RG3.Web.Host.PaaS\App_Temp\tosoft\DevCode\devbuild\tosoft_connzentao_devbuild_db.json
新:
\RG3.Web.Host.PaaS\App_Data\ApiDocument\devbuild\connzentao.json

重新刷新devbuild,选择新链接connzentao

文档更新时间: 2023-07-22 09:42   作者:admin