| Name | datasette-create-view JSON |
| Version |
0.1
JSON |
| download |
| home_page | |
| Summary | Create a SQL view from a query |
| upload_time | 2024-03-07 04:27:36 |
| maintainer | |
| docs_url | None |
| author | Simon Willison |
| requires_python | >=3.8 |
| license | Apache-2.0 |
| keywords |
|
| VCS |
 |
| bugtrack_url |
|
| requirements |
No requirements were recorded.
|
| Travis-CI |
No Travis.
|
| coveralls test coverage |
No coveralls.
|
# datasette-create-view
[](https://pypi.org/project/datasette-create-view/)
[](https://github.com/datasette/datasette-create-view/releases)
[](https://github.com/datasette/datasette-create-view/actions/workflows/test.yml)
[](https://github.com/datasette/datasette-create-view/blob/main/LICENSE)
Create a SQL view from a query
## Installation
Install this plugin in the same environment as Datasette.
```bash
datasette install datasette-create-view
```
## Usage
Users with the `create-table` permission will get a new menu item on the query results page offering to save the query as a view.
This option will only show for SQL queries that do not use `:named` parameters.
## Development
To set up this plugin locally, first checkout the code. Then create a new virtual environment:
```bash
cd datasette-create-view
python3 -m venv venv
source venv/bin/activate
```
Now install the dependencies and test dependencies:
```bash
pip install -e '.[test]'
```
To run the tests:
```bash
pytest
```
Raw data
{
"_id": null,
"home_page": "",
"name": "datasette-create-view",
"maintainer": "",
"docs_url": null,
"requires_python": ">=3.8",
"maintainer_email": "",
"keywords": "",
"author": "Simon Willison",
"author_email": "",
"download_url": "https://files.pythonhosted.org/packages/58/55/a6a93b4da09a6eae40102746088f61dd6f74bdf81dd23012d825ab43eaa5/datasette-create-view-0.1.tar.gz",
"platform": null,
"description": "# datasette-create-view\n\n[](https://pypi.org/project/datasette-create-view/)\n[](https://github.com/datasette/datasette-create-view/releases)\n[](https://github.com/datasette/datasette-create-view/actions/workflows/test.yml)\n[](https://github.com/datasette/datasette-create-view/blob/main/LICENSE)\n\nCreate a SQL view from a query\n\n## Installation\n\nInstall this plugin in the same environment as Datasette.\n```bash\ndatasette install datasette-create-view\n```\n## Usage\n\nUsers with the `create-table` permission will get a new menu item on the query results page offering to save the query as a view.\n\nThis option will only show for SQL queries that do not use `:named` parameters.\n\n## Development\n\nTo set up this plugin locally, first checkout the code. Then create a new virtual environment:\n```bash\ncd datasette-create-view\npython3 -m venv venv\nsource venv/bin/activate\n```\nNow install the dependencies and test dependencies:\n```bash\npip install -e '.[test]'\n```\nTo run the tests:\n```bash\npytest\n```\n",
"bugtrack_url": null,
"license": "Apache-2.0",
"summary": "Create a SQL view from a query",
"version": "0.1",
"project_urls": {
"CI": "https://github.com/datasette/datasette-create-view/actions",
"Changelog": "https://github.com/datasette/datasette-create-view/releases",
"Homepage": "https://github.com/datasette/datasette-create-view",
"Issues": "https://github.com/datasette/datasette-create-view/issues"
},
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "b878f6f35ca4582b42debe8192d99f608656a777773cb20ddabbc72b3b4d5aa0",
"md5": "7eec52ed18335f81bb34aae88b58e443",
"sha256": "ef14d23504f96bc3a9798c99c5c49b251c9b1272325b3df4dae32843a4b39a88"
},
"downloads": -1,
"filename": "datasette_create_view-0.1-py3-none-any.whl",
"has_sig": false,
"md5_digest": "7eec52ed18335f81bb34aae88b58e443",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.8",
"size": 8043,
"upload_time": "2024-03-07T04:27:34",
"upload_time_iso_8601": "2024-03-07T04:27:34.885582Z",
"url": "https://files.pythonhosted.org/packages/b8/78/f6f35ca4582b42debe8192d99f608656a777773cb20ddabbc72b3b4d5aa0/datasette_create_view-0.1-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "5855a6a93b4da09a6eae40102746088f61dd6f74bdf81dd23012d825ab43eaa5",
"md5": "b99c52c7c0078c30018c1ca7329a40e8",
"sha256": "b8dd84c511c18f8de549674061f7c85d91711a429624ec108d4f1b95945423e1"
},
"downloads": -1,
"filename": "datasette-create-view-0.1.tar.gz",
"has_sig": false,
"md5_digest": "b99c52c7c0078c30018c1ca7329a40e8",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.8",
"size": 8031,
"upload_time": "2024-03-07T04:27:36",
"upload_time_iso_8601": "2024-03-07T04:27:36.302388Z",
"url": "https://files.pythonhosted.org/packages/58/55/a6a93b4da09a6eae40102746088f61dd6f74bdf81dd23012d825ab43eaa5/datasette-create-view-0.1.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-03-07 04:27:36",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "datasette",
"github_project": "datasette-create-view",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"lcname": "datasette-create-view"
}
