{
    "info": {
        "author": "m-ds GmbH",
        "author_email": "service@m-ds.de",
        "bugtrack_url": null,
        "classifiers": [
            "Development Status :: 5 - Production/Stable",
            "Intended Audience :: Developers",
            "License :: OSI Approved :: BSD License",
            "Operating System :: OS Independent",
            "Programming Language :: Python :: 2.6",
            "Programming Language :: Python :: 2.7",
            "Programming Language :: Python :: 3.4",
            "Programming Language :: Python :: 3.5",
            "Programming Language :: Python :: 3.6",
            "Topic :: Database",
            "Topic :: Software Development :: Libraries :: Python Modules"
        ],
        "description": "sqlextension\n============\nThis module makes some SQL commands available for use with python-sql.\n\nInstall\n=======\npip install mds-sqlextension\n\nAvailable SQL functions\n=======================\n\n- AnyInArray (any)\n- ArrayAgg (array_agg)\n- Ascii (ascii)\n- Concat2 (concat)\n- FuzzyEqal (%)\n- Lower (lower)\n- Replace (replace)\n- ReplaceRegexp (regexp_replace)\n- RPad (rpad)\n- SplitPart (split_part)\n- StringAgg (string_agg)\n\nAvailable SQL expressions\n=========================\n\n- Overlaps ( (start1, end1) overlaps (start2, end2) )::\n\n    tab1.select(\n       tab1.id, \n       where=Overlaps('2017-10-01', '2017-10-15', tab1.start, tab1.end) == True\n       )\n- RegexMatchWithCase(<column>, <regular expression>)\n- RegexMatchNoCase(<column>, <regular expression>)::\n\n     tab1.select(\n       tab1.id,\n       where=RegexMatchNoCase(tab1.rgbcolor, '^#[0-9,a-f]{6}$')\n       )\n\n\nTo make FuzzyEqual work, call *CREATE EXTENSION pg_trgm;* in PostgreSQL.\n\nRequires\n========\n- python-sql\n\nChanges\n=======\n\n*0.1.8 - 02/13/2018*\n\n- new: two operators - RegexMatchNoCase + RegexMatchWithCase\n\n*0.1.7 - 03/09/2018*\n\n- fix: generate valid params in 'Overlaps'\n\n*0.1.6 - 03/08/2018*\n\n- added expression: Overlaps\n\n*0.1.5 - 02/01/2018*\n\n- added function: ReplaceRegexp\n\n*0.1.4 - 12/14/2017*\n\n- bugfix: import-syntax in python3\n- added docstrings for help\n\n*0.1.3 - 07/14/2017*\n\n- added 'split_part'\n\n*0.1.2 - 06/09/2017*\n\n- import optimized\n\n*0.1.1 - 06/09/2017*\n\n- first public version",
        "description_content_type": "",
        "docs_url": null,
        "download_url": "",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://www.m-ds.de/",
        "keywords": "sql library",
        "license": "GPL-3",
        "maintainer": "",
        "maintainer_email": "",
        "name": "mds-sqlextension",
        "package_url": "https://pypi.org/project/mds-sqlextension/",
        "platform": "",
        "project_url": "https://pypi.org/project/mds-sqlextension/",
        "project_urls": {
            "Homepage": "https://www.m-ds.de/"
        },
        "release_url": "https://pypi.org/project/mds-sqlextension/0.1.8/",
        "requires_dist": null,
        "requires_python": "",
        "summary": "Library to use more sql-commands",
        "version": "0.1.8"
    },
    "last_serial": 4815484,
    "releases": {
        "0.1": [],
        "0.1.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "a33981edb0049f0bfb6dbab28533ed6b",
                    "sha256": "9ccdafe7d7a8b7ab0233426869b5955f188e300915bb2c78882e0e46f3070a99"
                },
                "downloads": -1,
                "filename": "mds_sqlextension-0.1.1-py2-none-any.whl",
                "has_sig": false,
                "md5_digest": "a33981edb0049f0bfb6dbab28533ed6b",
                "packagetype": "bdist_wheel",
                "python_version": "py2",
                "requires_python": null,
                "size": 4547,
                "upload_time": "2017-06-09T11:22:49",
                "url": "https://files.pythonhosted.org/packages/dc/57/2a481188b1bd45640d5134e39815760f3af7a85843de0a4b97236de3e587/mds_sqlextension-0.1.1-py2-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "969585c4ea501fd20efb7b82a47c7ecd",
                    "sha256": "808d0219109e83e50a99b47d37271d7a77f79ec3c94a37e52ca99e9b2073fbb3"
                },
                "downloads": -1,
                "filename": "mds-sqlextension-0.1.1.tar.gz",
                "has_sig": false,
                "md5_digest": "969585c4ea501fd20efb7b82a47c7ecd",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 2817,
                "upload_time": "2017-06-09T11:22:50",
                "url": "https://files.pythonhosted.org/packages/6c/d2/14480e57fda110c9d4428ec78b261fd7d1c0acc2246cff0aa75c74595d86/mds-sqlextension-0.1.1.tar.gz"
            }
        ],
        "0.1.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "a8fa2f286081622ac89c032d32ef684d",
                    "sha256": "456508c43b55cb9ab5ad7539edbdf1f59f7ad628d2c9e9728583a09326a7b01e"
                },
                "downloads": -1,
                "filename": "mds_sqlextension-0.1.2-py2-none-any.whl",
                "has_sig": false,
                "md5_digest": "a8fa2f286081622ac89c032d32ef684d",
                "packagetype": "bdist_wheel",
                "python_version": "py2",
                "requires_python": null,
                "size": 4674,
                "upload_time": "2017-06-09T13:02:01",
                "url": "https://files.pythonhosted.org/packages/f4/47/d1b03b37c5b20b05be18976f382aba1629396fbf0a332af0761dd57a11d9/mds_sqlextension-0.1.2-py2-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "af1da2f1b4a8ef731174a7d0ea19a603",
                    "sha256": "ec16c334d03db14cdae0725546f1f862892a71fa6f8293ce0f8b6d2a349e91ae"
                },
                "downloads": -1,
                "filename": "mds-sqlextension-0.1.2.tar.gz",
                "has_sig": false,
                "md5_digest": "af1da2f1b4a8ef731174a7d0ea19a603",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 2890,
                "upload_time": "2017-06-09T13:02:03",
                "url": "https://files.pythonhosted.org/packages/75/36/a2216ab696b45e7882afa8212c51fdf88b33735a13c9d25ed7ed529fa2e3/mds-sqlextension-0.1.2.tar.gz"
            }
        ],
        "0.1.3": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "a14f9aa3710be8c6eb8ca9eab084299a",
                    "sha256": "544c4b3d74609c3f77b77609e43baafc63c22faaa024671a9d5a3015fa5703fc"
                },
                "downloads": -1,
                "filename": "mds_sqlextension-0.1.3-py2-none-any.whl",
                "has_sig": false,
                "md5_digest": "a14f9aa3710be8c6eb8ca9eab084299a",
                "packagetype": "bdist_wheel",
                "python_version": "py2",
                "requires_python": null,
                "size": 4766,
                "upload_time": "2017-07-14T11:43:00",
                "url": "https://files.pythonhosted.org/packages/2b/fe/117d76bacad992162cfea8337be05f820706ed05287094cf451dcd3ccaf8/mds_sqlextension-0.1.3-py2-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "185c464597a3fa48a5f2ef14c01a3a9c",
                    "sha256": "291c766bd07228430c66d42c8421a09edf509c318a1ca9b258fdf1340588b2af"
                },
                "downloads": -1,
                "filename": "mds-sqlextension-0.1.3.tar.gz",
                "has_sig": false,
                "md5_digest": "185c464597a3fa48a5f2ef14c01a3a9c",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 2957,
                "upload_time": "2017-07-14T11:43:01",
                "url": "https://files.pythonhosted.org/packages/2c/eb/4c1d7d77c6b779497f51dcddcfa93fc64459ffcd24a3dd58b46a75e05a7c/mds-sqlextension-0.1.3.tar.gz"
            }
        ],
        "0.1.4": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "e36c8537f99e3628bab388bcfd999265",
                    "sha256": "da181cbf2b39d9c7de4088c8bb88406a6f37f4ce92bb9fa054520a7b98e180e0"
                },
                "downloads": -1,
                "filename": "mds_sqlextension-0.1.4-py2-none-any.whl",
                "has_sig": false,
                "md5_digest": "e36c8537f99e3628bab388bcfd999265",
                "packagetype": "bdist_wheel",
                "python_version": "py2",
                "requires_python": null,
                "size": 5443,
                "upload_time": "2017-12-14T10:29:46",
                "url": "https://files.pythonhosted.org/packages/39/51/64010d7a338d84a4fd2cdbf0fe291f3075c35d820c269de5485b22280ecf/mds_sqlextension-0.1.4-py2-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "730857a080f0fa6e5faf8b22cafc1f49",
                    "sha256": "6257aca032fbc17cb70808826625cd29ce5f09aaab122247cfd084d601fedf3c"
                },
                "downloads": -1,
                "filename": "mds_sqlextension-0.1.4-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "730857a080f0fa6e5faf8b22cafc1f49",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 5479,
                "upload_time": "2017-12-14T10:29:47",
                "url": "https://files.pythonhosted.org/packages/2f/d7/216b997a9e62a57c6282503b261aaf83b3a01ebf6301c94b0d6e22a1ef76/mds_sqlextension-0.1.4-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "bdae55af268e151710380ab8a5dfc92e",
                    "sha256": "767b59eeb547675cce04e38095f76c036581d125b0a2a5b94dc6057e0b713f94"
                },
                "downloads": -1,
                "filename": "mds-sqlextension-0.1.4.tar.gz",
                "has_sig": false,
                "md5_digest": "bdae55af268e151710380ab8a5dfc92e",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 3597,
                "upload_time": "2017-12-14T10:29:33",
                "url": "https://files.pythonhosted.org/packages/38/ba/22272c67dbcd663b8f0da22beae12b1448c7582fd47b42fb614a6533f82f/mds-sqlextension-0.1.4.tar.gz"
            }
        ],
        "0.1.6": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "b1bee8682858c7e25b059f29642abc41",
                    "sha256": "5fc87f15eb976f9777e6e83a4039b0a7786bbf32aae04ccdbe12f03b38362578"
                },
                "downloads": -1,
                "filename": "mds_sqlextension-0.1.6-py2-none-any.whl",
                "has_sig": false,
                "md5_digest": "b1bee8682858c7e25b059f29642abc41",
                "packagetype": "bdist_wheel",
                "python_version": "py2",
                "requires_python": null,
                "size": 6471,
                "upload_time": "2018-03-08T16:03:02",
                "url": "https://files.pythonhosted.org/packages/b1/82/42db1ecc342fa7c9801c6dc2bc8a76fcd80a35be7a0092a5583d1542c1db/mds_sqlextension-0.1.6-py2-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "1ab185280ea9190df8e4ac2048535574",
                    "sha256": "447e5eeb43b43cc3c02e805f54257126511444fdee58b824a4a750fa15b8394b"
                },
                "downloads": -1,
                "filename": "mds_sqlextension-0.1.6-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "1ab185280ea9190df8e4ac2048535574",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 6507,
                "upload_time": "2018-03-08T16:03:03",
                "url": "https://files.pythonhosted.org/packages/a5/41/8d82f4ccf9ec7c44e56f314130dabc543502bef65123169927dbfffd14bc/mds_sqlextension-0.1.6-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "d1f80c1405119e51bffcf514234fc30a",
                    "sha256": "8c6aa578e1872a7dcff37ddf5157ea5782c90bfbdd314f59ba1988dd7534fb16"
                },
                "downloads": -1,
                "filename": "mds-sqlextension-0.1.6.tar.gz",
                "has_sig": false,
                "md5_digest": "d1f80c1405119e51bffcf514234fc30a",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 4206,
                "upload_time": "2018-03-08T16:03:12",
                "url": "https://files.pythonhosted.org/packages/ca/4f/770a0ee2e797da67c26c98fedbc3daa2079e56a459bb76d5f1724a5c4973/mds-sqlextension-0.1.6.tar.gz"
            }
        ],
        "0.1.7": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "9b01c972f9b3571b9d4e723db3ab8034",
                    "sha256": "8cb0e065d589045db86db12ced39e8b15503a8872b1dc3e1da18533d74d6c575"
                },
                "downloads": -1,
                "filename": "mds_sqlextension-0.1.7-py2-none-any.whl",
                "has_sig": false,
                "md5_digest": "9b01c972f9b3571b9d4e723db3ab8034",
                "packagetype": "bdist_wheel",
                "python_version": "py2",
                "requires_python": null,
                "size": 6548,
                "upload_time": "2018-03-09T21:33:07",
                "url": "https://files.pythonhosted.org/packages/5c/ab/994f711755e43f41390e3be101a440b7439f5ec453a7523c1cc1bec3ac99/mds_sqlextension-0.1.7-py2-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "993ed8e6ced8f63601270ebf40d3070c",
                    "sha256": "b4763f8263af00596a196cf1f820a428aaac40b41e272bb6952c9f52e471c924"
                },
                "downloads": -1,
                "filename": "mds_sqlextension-0.1.7-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "993ed8e6ced8f63601270ebf40d3070c",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 6590,
                "upload_time": "2018-03-09T21:33:09",
                "url": "https://files.pythonhosted.org/packages/c3/c7/6c615299ebd5d8ed1682ca4da897d05262a82895e6b676c677c2bcaf362e/mds_sqlextension-0.1.7-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "ae2f78d71554a697042d1df9ddda68e7",
                    "sha256": "7395862110fb1efc64e9baa423326bc588e36f6230be70f5a70550644f2c1fc8"
                },
                "downloads": -1,
                "filename": "mds-sqlextension-0.1.7.tar.gz",
                "has_sig": false,
                "md5_digest": "ae2f78d71554a697042d1df9ddda68e7",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 4243,
                "upload_time": "2018-03-09T21:32:55",
                "url": "https://files.pythonhosted.org/packages/93/62/538f203177f4dfe6e15d6ed6d8abe8ef508f180f2f18e0255920c70080be/mds-sqlextension-0.1.7.tar.gz"
            }
        ],
        "0.1.8": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "bb860944afe3659c4e2d5e6aafc201da",
                    "sha256": "784d2f439c89deb544bdf24d450ae98b97fcc9aa0fd714b9a1444ac85248c2e3"
                },
                "downloads": -1,
                "filename": "mds_sqlextension-0.1.8-py2-none-any.whl",
                "has_sig": false,
                "md5_digest": "bb860944afe3659c4e2d5e6aafc201da",
                "packagetype": "bdist_wheel",
                "python_version": "py2",
                "requires_python": null,
                "size": 7264,
                "upload_time": "2019-02-13T12:25:03",
                "url": "https://files.pythonhosted.org/packages/2a/3b/c570b69b4beac9b5065f0ce0c2d507e456a9e30942a4cbfba48369e193d5/mds_sqlextension-0.1.8-py2-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "4eecff0c3107e85b80d59a9e7747f93d",
                    "sha256": "fbea67d163437ba37f9a16fc9d15c3c9c038519c88e6b6b215fd57f9c6fbeee1"
                },
                "downloads": -1,
                "filename": "mds_sqlextension-0.1.8-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "4eecff0c3107e85b80d59a9e7747f93d",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 5620,
                "upload_time": "2019-02-13T12:25:05",
                "url": "https://files.pythonhosted.org/packages/22/e9/68df7f8d7dc7d9bf201fe36657dc3f873c7c1c5d51f5df580e706fe43af6/mds_sqlextension-0.1.8-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "74cb6d1d266596509a1f2467cf5abb81",
                    "sha256": "a29d739f05e8304549099487b0ceaad89addc5ac39cf999358de18f108e037cf"
                },
                "downloads": -1,
                "filename": "mds-sqlextension-0.1.8.tar.gz",
                "has_sig": false,
                "md5_digest": "74cb6d1d266596509a1f2467cf5abb81",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 4570,
                "upload_time": "2019-02-13T12:24:54",
                "url": "https://files.pythonhosted.org/packages/c1/76/d2e846e7917fdc8c1747ce067afff34349bb0dce787205873dc20fde11fe/mds-sqlextension-0.1.8.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "bb860944afe3659c4e2d5e6aafc201da",
                "sha256": "784d2f439c89deb544bdf24d450ae98b97fcc9aa0fd714b9a1444ac85248c2e3"
            },
            "downloads": -1,
            "filename": "mds_sqlextension-0.1.8-py2-none-any.whl",
            "has_sig": false,
            "md5_digest": "bb860944afe3659c4e2d5e6aafc201da",
            "packagetype": "bdist_wheel",
            "python_version": "py2",
            "requires_python": null,
            "size": 7264,
            "upload_time": "2019-02-13T12:25:03",
            "url": "https://files.pythonhosted.org/packages/2a/3b/c570b69b4beac9b5065f0ce0c2d507e456a9e30942a4cbfba48369e193d5/mds_sqlextension-0.1.8-py2-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "4eecff0c3107e85b80d59a9e7747f93d",
                "sha256": "fbea67d163437ba37f9a16fc9d15c3c9c038519c88e6b6b215fd57f9c6fbeee1"
            },
            "downloads": -1,
            "filename": "mds_sqlextension-0.1.8-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "4eecff0c3107e85b80d59a9e7747f93d",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": null,
            "size": 5620,
            "upload_time": "2019-02-13T12:25:05",
            "url": "https://files.pythonhosted.org/packages/22/e9/68df7f8d7dc7d9bf201fe36657dc3f873c7c1c5d51f5df580e706fe43af6/mds_sqlextension-0.1.8-py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "74cb6d1d266596509a1f2467cf5abb81",
                "sha256": "a29d739f05e8304549099487b0ceaad89addc5ac39cf999358de18f108e037cf"
            },
            "downloads": -1,
            "filename": "mds-sqlextension-0.1.8.tar.gz",
            "has_sig": false,
            "md5_digest": "74cb6d1d266596509a1f2467cf5abb81",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 4570,
            "upload_time": "2019-02-13T12:24:54",
            "url": "https://files.pythonhosted.org/packages/c1/76/d2e846e7917fdc8c1747ce067afff34349bb0dce787205873dc20fde11fe/mds-sqlextension-0.1.8.tar.gz"
        }
    ]
}