Date utility functions for sqlite-utils
Project description
sqlite-utils-dateutil
Date utility functions for sqlite-utils.
Installation
Install this plugin in the same environment as sqlite-utils.
sqlite-utils install sqlite-utils-dateutil
Usage
This plugin adds a variety of SQL functions for parsing dates. For example:
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 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
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
File details
Details for the file sqlite-utils-dateutil-0.1.tar.gz
.
File metadata
- Download URL: sqlite-utils-dateutil-0.1.tar.gz
- Upload date:
- Size: 7.5 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/4.0.2 CPython/3.11.4
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 95993c63d1c02cfdff5772c51c724665a4b282ec956626f2b913ca58b8a6fff6 |
|
MD5 | 3f70e19be72c64ba832ec6d94e47428a |
|
BLAKE2b-256 | 01e7f0e369e3435325c2d52e5b03c2a8b97c01ae8e197e9f16e3af9fb0bc9bc0 |
File details
Details for the file sqlite_utils_dateutil-0.1-py3-none-any.whl
.
File metadata
- Download URL: sqlite_utils_dateutil-0.1-py3-none-any.whl
- Upload date:
- Size: 7.4 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/4.0.2 CPython/3.11.4
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 5f679b61777115c06e22b8a24bbf89441de0e01c9e018328c33462f3124569f2 |
|
MD5 | 877867a9f97c3b6c9b47d0cad7478da0 |
|
BLAKE2b-256 | f38cfe0e8ddad93e9f9bc244e2803f984afdf6245a7b077e7176b77656e857d0 |