| Name | sqlite-utils-dateutil JSON |
| Version |
0.1
JSON |
| download |
| home_page | |
| Summary | Date utility functions for sqlite-utils |
| upload_time | 2023-07-24 02:54:29 |
| maintainer | |
| docs_url | None |
| author | Simon Willison |
| requires_python | |
| license | Apache-2.0 |
| keywords |
|
| VCS |
 |
| bugtrack_url |
|
| requirements |
No requirements were recorded.
|
| Travis-CI |
No Travis.
|
| coveralls test coverage |
No coveralls.
|
# sqlite-utils-dateutil
[](https://pypi.org/project/sqlite-utils-dateutil/)
[](https://github.com/simonw/sqlite-utils-dateutil/releases)
[](https://github.com/simonw/sqlite-utils-dateutil/actions?query=workflow%3ATest)
[](https://github.com/simonw/sqlite-utils-dateutil/blob/main/LICENSE)
Date utility functions for [sqlite-utils](https://sqlite-utils.datasette.io/).
## Installation
Install this plugin in the same environment as sqlite-utils.
```bash
sqlite-utils install sqlite-utils-dateutil
```
## Usage
This plugin adds a variety of SQL functions for parsing dates. For example:
```bash
sqlite-utils memory "select dateutil_parse('10 october 2020 3pm')" --table
```
Output:
```
dateutil_parse('10 october 2020 3pm')
---------------------------------------
2020-10-10T15:00:00
```
Consult [the datasette-dateutil documentation](https://github.com/simonw/datasette-dateutil/blob/main/README.md#usage) for a full list of functions.
## Development
To set up this plugin locally, first checkout the code. Then create a new virtual environment:
cd sqlite-utils-dateutil
python3 -m venv venv
source venv/bin/activate
Now install the dependencies and test dependencies:
pip install -e '.[test]'
To run the tests:
pytest
Raw data
{
"_id": null,
"home_page": "",
"name": "sqlite-utils-dateutil",
"maintainer": "",
"docs_url": null,
"requires_python": "",
"maintainer_email": "",
"keywords": "",
"author": "Simon Willison",
"author_email": "",
"download_url": "https://files.pythonhosted.org/packages/01/e7/f0e369e3435325c2d52e5b03c2a8b97c01ae8e197e9f16e3af9fb0bc9bc0/sqlite-utils-dateutil-0.1.tar.gz",
"platform": null,
"description": "# sqlite-utils-dateutil\n\n[](https://pypi.org/project/sqlite-utils-dateutil/)\n[](https://github.com/simonw/sqlite-utils-dateutil/releases)\n[](https://github.com/simonw/sqlite-utils-dateutil/actions?query=workflow%3ATest)\n[](https://github.com/simonw/sqlite-utils-dateutil/blob/main/LICENSE)\n\nDate utility functions for [sqlite-utils](https://sqlite-utils.datasette.io/).\n\n## Installation\n\nInstall this plugin in the same environment as sqlite-utils.\n```bash\nsqlite-utils install sqlite-utils-dateutil\n```\n\n## Usage\n\nThis plugin adds a variety of SQL functions for parsing dates. For example:\n\n```bash\nsqlite-utils memory \"select dateutil_parse('10 october 2020 3pm')\" --table\n```\nOutput:\n```\ndateutil_parse('10 october 2020 3pm')\n---------------------------------------\n2020-10-10T15:00:00\n```\nConsult [the datasette-dateutil documentation](https://github.com/simonw/datasette-dateutil/blob/main/README.md#usage) for a full list of functions.\n\n## Development\n\nTo set up this plugin locally, first checkout the code. Then create a new virtual environment:\n\n cd sqlite-utils-dateutil\n python3 -m venv venv\n source venv/bin/activate\n\nNow install the dependencies and test dependencies:\n\n pip install -e '.[test]'\n\nTo run the tests:\n\n pytest\n",
"bugtrack_url": null,
"license": "Apache-2.0",
"summary": "Date utility functions for sqlite-utils",
"version": "0.1",
"project_urls": {
"CI": "https://github.com/simonw/sqlite-utils-dateutil/actions",
"Changelog": "https://github.com/simonw/sqlite-utils-dateutil/releases",
"Homepage": "https://github.com/simonw/sqlite-utils-dateutil",
"Issues": "https://github.com/simonw/sqlite-utils-dateutil/issues"
},
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "f38cfe0e8ddad93e9f9bc244e2803f984afdf6245a7b077e7176b77656e857d0",
"md5": "877867a9f97c3b6c9b47d0cad7478da0",
"sha256": "5f679b61777115c06e22b8a24bbf89441de0e01c9e018328c33462f3124569f2"
},
"downloads": -1,
"filename": "sqlite_utils_dateutil-0.1-py3-none-any.whl",
"has_sig": false,
"md5_digest": "877867a9f97c3b6c9b47d0cad7478da0",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": null,
"size": 7434,
"upload_time": "2023-07-24T02:54:28",
"upload_time_iso_8601": "2023-07-24T02:54:28.075097Z",
"url": "https://files.pythonhosted.org/packages/f3/8c/fe0e8ddad93e9f9bc244e2803f984afdf6245a7b077e7176b77656e857d0/sqlite_utils_dateutil-0.1-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "01e7f0e369e3435325c2d52e5b03c2a8b97c01ae8e197e9f16e3af9fb0bc9bc0",
"md5": "3f70e19be72c64ba832ec6d94e47428a",
"sha256": "95993c63d1c02cfdff5772c51c724665a4b282ec956626f2b913ca58b8a6fff6"
},
"downloads": -1,
"filename": "sqlite-utils-dateutil-0.1.tar.gz",
"has_sig": false,
"md5_digest": "3f70e19be72c64ba832ec6d94e47428a",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 7511,
"upload_time": "2023-07-24T02:54:29",
"upload_time_iso_8601": "2023-07-24T02:54:29.552593Z",
"url": "https://files.pythonhosted.org/packages/01/e7/f0e369e3435325c2d52e5b03c2a8b97c01ae8e197e9f16e3af9fb0bc9bc0/sqlite-utils-dateutil-0.1.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2023-07-24 02:54:29",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "simonw",
"github_project": "sqlite-utils-dateutil",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"lcname": "sqlite-utils-dateutil"
}
