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.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 Distributions
Hashes for mds_sqlextension-0.1.8-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | fbea67d163437ba37f9a16fc9d15c3c9c038519c88e6b6b215fd57f9c6fbeee1 |
|
MD5 | 4eecff0c3107e85b80d59a9e7747f93d |
|
BLAKE2b-256 | 22e968df7f8d7dc7d9bf201fe36657dc3f873c7c1c5d51f5df580e706fe43af6 |
Hashes for mds_sqlextension-0.1.8-py2-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 784d2f439c89deb544bdf24d450ae98b97fcc9aa0fd714b9a1444ac85248c2e3 |
|
MD5 | bb860944afe3659c4e2d5e6aafc201da |
|
BLAKE2b-256 | 2a3bc570b69b4beac9b5065f0ce0c2d507e456a9e30942a4cbfba48369e193d5 |