Skip to main content

Tool for running transformations on columns in a SQLite database.

Project description

sqlite-transform

PyPI CircleCI License

Tool for running transformations on columns in a SQLite database.

How to install

$ pip install sqlite-transform

How to use

$ sqlite-transform parsedatetime my.db mytable column1 column2

There are only one subcommand at the moment: parsedatetime.

These will run all values in the specified column through dateutils.parser.parse() and replace them with the result, formatted as an ISO timestamp.

Supported by

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