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
Close
Hashes for sqlite-utils-dateutil-0.1.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 95993c63d1c02cfdff5772c51c724665a4b282ec956626f2b913ca58b8a6fff6 |
|
MD5 | 3f70e19be72c64ba832ec6d94e47428a |
|
BLAKE2b-256 | 01e7f0e369e3435325c2d52e5b03c2a8b97c01ae8e197e9f16e3af9fb0bc9bc0 |
Close
Hashes for sqlite_utils_dateutil-0.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 5f679b61777115c06e22b8a24bbf89441de0e01c9e018328c33462f3124569f2 |
|
MD5 | 877867a9f97c3b6c9b47d0cad7478da0 |
|
BLAKE2b-256 | f38cfe0e8ddad93e9f9bc244e2803f984afdf6245a7b077e7176b77656e857d0 |