| Name | db-copilot-tool JSON |
| Version |
0.0.8
JSON |
| download |
| home_page | None |
| Summary | nl2sql tool for prompt flow |
| upload_time | 2024-07-24 08:41:37 |
| maintainer | None |
| docs_url | None |
| author | Microsoft Corporation |
| requires_python | >=3.8 |
| license | None |
| keywords |
|
| VCS |
|
| bugtrack_url |
|
| requirements |
No requirements were recorded.
|
| Travis-CI |
No Travis.
|
| coveralls test coverage |
No coveralls.
|
nl2sql tool for prompt flow
# How to create promptflow endpoint your workspace
## 1. Prepare your workspace
Open your workspace in Azure ML studio portal <br>
Example Studio Portal URL: <br>
https://main.ml.azure.com/?wsid=/subscriptions/1b75927d-563b-49d2-bf8a-772f7d6a170e/resourceGroups/ragdev/providers/Microsoft.MachineLearningServices/workspaces/RAGDev&flight=promptDesigner&tid=72f988bf-86f1-41af-91ab-2d7cd011db47
## 2. Create a ci (compute instance)
Create a ci with name with prefix "ci-lin-cpu-0-" , for example ci-lin-cpu-0-alan
## 3. Config Customer Application on your ci
### 3.1 Application Name
Application Name has to be: promptflow-runtime
### 3.2 Port
Target Port and Published Port have to be: 8080
### 3.3 Docker Image
docker image can be modulesdkpreview/prt:tag. <br>
For example:
modulesdkpreview/prt:v20230420-140738
### 3.4 Restart ci
## 4. Install dbcopilot on your ci
### 4.1 Open Terminal of your ci
### 4.2 upload whl files to your ci
dbcopilot-0.2.0-py3-none-any.whl (get it from https://dev.azure.com/TScience/NL2Code/_artifacts/feed/AIMS.TScience.NL2Code/PyPI/dbcopilot/overview/0.3.0)<br>
db_copilot_tool-0.1.0-py3-none-any.whl <br>
embeddingstore-0.0.1-py3-none-any.whl (optional) <br>
promptflow_sdk-0.0.1-py3-none-any.whl (optional) <br>
### 4.3 Install whl files in promptflow container
Find your promptflow container id with command: docker ps -a <br>
Copy whl files to promptflow container with command: docker cp xxx.whl <container_id>:/xxx.whl <br>
Login promptflow container with command: docker exec -it <container_id> /bin/bash <br>
install whl files with command: pip install xxx.whl
### 4.4 Install Microsoft ODBC in promptflow container
Reference Doc: https://learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver16&tabs=ubuntu18-install%2Calpine17-install%2Cdebian8-install%2Credhat7-13-install%2Crhel7-offline#18 <br>
Commands: <br>
apt-get update <br>
apt-get install -y curl lsb-core <br>
curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add - <br>
curl https://packages.microsoft.com/config/ubuntu/$(lsb_release -rs)/prod.list > /etc/apt/sources.list.d/mssql-release.list <br>
apt-get update <br>
ACCEPT_EULA=Y apt-get install -y msodbcsql18 <br>
apt-get install -y unixodbc-dev <br>
### 4.5 Restart promptflow container
exit
docker stop container_id <br>
docker start container_id <br>
## 5. Copy Local DB file to promptflow container (optional)
## 6. Get promptflow endpoint url
promptflow endpoint url can be found in the ci overview page, click "promptflow-runtime" link <br>
Raw data
{
"_id": null,
"home_page": null,
"name": "db-copilot-tool",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3.8",
"maintainer_email": null,
"keywords": null,
"author": "Microsoft Corporation",
"author_email": "xiangrao@microsoft.com",
"download_url": "https://files.pythonhosted.org/packages/84/f3/cb926a43cbbb958fa601d4bbe0ee35274111fbeff25574408160ae690dd6/db_copilot_tool-0.0.8.tar.gz",
"platform": null,
"description": "nl2sql tool for prompt flow\r\n\r\n# How to create promptflow endpoint your workspace\r\n## 1. Prepare your workspace\r\nOpen your workspace in Azure ML studio portal <br>\r\nExample Studio Portal URL: <br>\r\nhttps://main.ml.azure.com/?wsid=/subscriptions/1b75927d-563b-49d2-bf8a-772f7d6a170e/resourceGroups/ragdev/providers/Microsoft.MachineLearningServices/workspaces/RAGDev&flight=promptDesigner&tid=72f988bf-86f1-41af-91ab-2d7cd011db47\r\n## 2. Create a ci (compute instance)\r\nCreate a ci with name with prefix \"ci-lin-cpu-0-\" , for example ci-lin-cpu-0-alan\r\n## 3. Config Customer Application on your ci\r\n### 3.1 Application Name\r\nApplication Name has to be: promptflow-runtime\r\n### 3.2 Port\r\nTarget Port and Published Port have to be: 8080\r\n### 3.3 Docker Image\r\ndocker image can be modulesdkpreview/prt:tag. <br>\r\nFor example: \r\nmodulesdkpreview/prt:v20230420-140738\r\n### 3.4 Restart ci\r\n## 4. Install dbcopilot on your ci\r\n### 4.1 Open Terminal of your ci\r\n### 4.2 upload whl files to your ci\r\ndbcopilot-0.2.0-py3-none-any.whl (get it from https://dev.azure.com/TScience/NL2Code/_artifacts/feed/AIMS.TScience.NL2Code/PyPI/dbcopilot/overview/0.3.0)<br>\r\ndb_copilot_tool-0.1.0-py3-none-any.whl <br>\r\nembeddingstore-0.0.1-py3-none-any.whl (optional) <br>\r\npromptflow_sdk-0.0.1-py3-none-any.whl (optional) <br>\r\n### 4.3 Install whl files in promptflow container\r\nFind your promptflow container id with command: docker ps -a <br>\r\nCopy whl files to promptflow container with command: docker cp xxx.whl <container_id>:/xxx.whl <br>\r\nLogin promptflow container with command: docker exec -it <container_id> /bin/bash <br>\r\ninstall whl files with command: pip install xxx.whl\r\n### 4.4 Install Microsoft ODBC in promptflow container\r\nReference Doc: https://learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver16&tabs=ubuntu18-install%2Calpine17-install%2Cdebian8-install%2Credhat7-13-install%2Crhel7-offline#18 <br>\r\nCommands: <br>\r\napt-get update <br>\r\napt-get install -y curl lsb-core <br>\r\ncurl https://packages.microsoft.com/keys/microsoft.asc | apt-key add - <br>\r\ncurl https://packages.microsoft.com/config/ubuntu/$(lsb_release -rs)/prod.list > /etc/apt/sources.list.d/mssql-release.list <br>\r\napt-get update <br>\r\nACCEPT_EULA=Y apt-get install -y msodbcsql18 <br>\r\napt-get install -y unixodbc-dev <br>\r\n### 4.5 Restart promptflow container\r\nexit\r\ndocker stop container_id <br>\r\ndocker start container_id <br>\r\n\r\n## 5. Copy Local DB file to promptflow container (optional)\r\n\r\n## 6. Get promptflow endpoint url\r\npromptflow endpoint url can be found in the ci overview page, click \"promptflow-runtime\" link <br>\r\n",
"bugtrack_url": null,
"license": null,
"summary": "nl2sql tool for prompt flow",
"version": "0.0.8",
"project_urls": null,
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "a5bbfa034361e512e8244e402bb1155c56a0f9a5d6aa174696e2a0d0ded726fd",
"md5": "a2cfea703e279c294fd9988eeee411f2",
"sha256": "42085f71a3f52cb30added0014a31302477c96082404bf8886e0b2dace66dc65"
},
"downloads": -1,
"filename": "db_copilot_tool-0.0.8-py3-none-any.whl",
"has_sig": false,
"md5_digest": "a2cfea703e279c294fd9988eeee411f2",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.8",
"size": 1393906,
"upload_time": "2024-07-24T08:41:35",
"upload_time_iso_8601": "2024-07-24T08:41:35.497893Z",
"url": "https://files.pythonhosted.org/packages/a5/bb/fa034361e512e8244e402bb1155c56a0f9a5d6aa174696e2a0d0ded726fd/db_copilot_tool-0.0.8-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "84f3cb926a43cbbb958fa601d4bbe0ee35274111fbeff25574408160ae690dd6",
"md5": "c4741332084d15360147172532a78ee1",
"sha256": "ecd0d5fe6bdd100bf9ab83fcb8fe53a8afd4a08344c3a43d77be75eb9e3182b0"
},
"downloads": -1,
"filename": "db_copilot_tool-0.0.8.tar.gz",
"has_sig": false,
"md5_digest": "c4741332084d15360147172532a78ee1",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.8",
"size": 1344064,
"upload_time": "2024-07-24T08:41:37",
"upload_time_iso_8601": "2024-07-24T08:41:37.898942Z",
"url": "https://files.pythonhosted.org/packages/84/f3/cb926a43cbbb958fa601d4bbe0ee35274111fbeff25574408160ae690dd6/db_copilot_tool-0.0.8.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-07-24 08:41:37",
"github": false,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"lcname": "db-copilot-tool"
}
