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 )
RegexMatchWithCase(<column>, <regular expression>)
RegexMatchNoCase(<column>, <regular expression>):
tab1.select( tab1.id, where=RegexMatchNoCase(tab1.rgbcolor, '^#[0-9,a-f]{6}$') )
To make FuzzyEqual work, call CREATE EXTENSION pg_trgm; in PostgreSQL.
Requires
python-sql
Changes
0.1.11 - 04/30/2021
add: LPad
0.1.10 - 03/02/2021
fix: parameter order in StringAgg()
0.1.9 - 02/22/2021
add: parameter ‘order’ to StringAgg
0.1.8 - 02/13/2018
new: two operators - RegexMatchNoCase + RegexMatchWithCase
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 Distribution
Hashes for mds_sqlextension-0.1.11-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 354ee39e0c9cf062b012fb055256b59587c984da9d823e4bb5827e21954fe362 |
|
MD5 | 189cc2bebd82ef21cfb04fecc3f81725 |
|
BLAKE2b-256 | 06b6c48a115d6a96c37802e7d8b72d44051cf7f4d198f3b6d8cc3f1a65456e62 |