Skip to main content

Date utility functions for sqlite-utils

Project description

sqlite-utils-dateutil

PyPI Changelog Tests License

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

This version

0.1

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

sqlite-utils-dateutil-0.1.tar.gz (7.5 kB view details)

Uploaded Source

Built Distribution

sqlite_utils_dateutil-0.1-py3-none-any.whl (7.4 kB view details)

Uploaded Python 3

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

Hashes for sqlite-utils-dateutil-0.1.tar.gz
Algorithm Hash digest
SHA256 95993c63d1c02cfdff5772c51c724665a4b282ec956626f2b913ca58b8a6fff6
MD5 3f70e19be72c64ba832ec6d94e47428a
BLAKE2b-256 01e7f0e369e3435325c2d52e5b03c2a8b97c01ae8e197e9f16e3af9fb0bc9bc0

See more details on using hashes here.

File details

Details for the file sqlite_utils_dateutil-0.1-py3-none-any.whl.

File metadata

File hashes

Hashes for sqlite_utils_dateutil-0.1-py3-none-any.whl
Algorithm Hash digest
SHA256 5f679b61777115c06e22b8a24bbf89441de0e01c9e018328c33462f3124569f2
MD5 877867a9f97c3b6c9b47d0cad7478da0
BLAKE2b-256 f38cfe0e8ddad93e9f9bc244e2803f984afdf6245a7b077e7176b77656e857d0

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page