Library to use more sql-commands
Project description
sqlextension
This module makes some SQL commands available for use with python-sql.
Install
pip install mds-sqlextension
Available SQL functions
AnyInArray (any)
ArrayAgg (array_agg)
Ascii (ascii)
Concat2 (concat)
FuzzyEqal (%)
Lower (lower)
Replace (replace)
ReplaceRegexp (regexp_replace)
RPad (rpad)
SplitPart (split_part)
StringAgg (string_agg)
Available SQL expressions
Overlaps ( (start1, end1) overlaps (start2, end2) ):
tab1.select( tab1.id, where=Overlaps('2017-10-01', '2017-10-15', tab1.start, tab1.end) == True )
To make FuzzyEqual work, call CREATE EXTENSION pg_trgm; in PostgreSQL.
Requires
python-sql
Changes
0.1.7 - 03/09/2018
fix: generate valid params in ‘Overlaps’
0.1.6 - 03/08/2018
added expression: Overlaps
0.1.5 - 02/01/2018
added function: ReplaceRegexp
0.1.4 - 12/14/2017
bugfix: import-syntax in python3
added docstrings for help
0.1.3 - 07/14/2017
added ‘split_part’
0.1.2 - 06/09/2017
import optimized
0.1.1 - 06/09/2017
first public version
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 Distributions
Hashes for mds_sqlextension-0.1.7-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b4763f8263af00596a196cf1f820a428aaac40b41e272bb6952c9f52e471c924 |
|
MD5 | 993ed8e6ced8f63601270ebf40d3070c |
|
BLAKE2b-256 | c3c76c615299ebd5d8ed1682ca4da897d05262a82895e6b676c677c2bcaf362e |
Hashes for mds_sqlextension-0.1.7-py2-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 8cb0e065d589045db86db12ced39e8b15503a8872b1dc3e1da18533d74d6c575 |
|
MD5 | 9b01c972f9b3571b9d4e723db3ab8034 |
|
BLAKE2b-256 | 5cab994f711755e43f41390e3be101a440b7439f5ec453a7523c1cc1bec3ac99 |