{
    "info": {
        "author": "Mahmoud Abdelkader, Davide Setti",
        "author_email": "UNKNOWN",
        "bugtrack_url": null,
        "classifiers": [
            "Intended Audience :: Developers",
            "License :: OSI Approved :: BSD License",
            "Programming Language :: Python",
            "Topic :: Software Development :: Libraries :: Python Modules"
        ],
        "description": "# sqlalchemy-citext\n\nCreates a SQLAlchemy user defined type to understand\n[PostgreSQL's CIText](http://www.postgresql.org/docs/9.1/static/citext.html)\nextension.\n\n## Installation\n\nThis requires some kind of PostgreSQL compatible db-api driver already\ninstalled in order to work.\n\nMake sure you have something like `psycopg2` already installed.\n\n```bash\npip install sqlalchemy-citext\n```\n\n## Usage\n\n\n```python\nfrom sqlalchemy import create_engine, MetaData, Integer\nfrom sqlalchemy.schema import Column, Table\nimport sqlalchemy.orm as orm\n\nengine = create_engine('postgresql://localhost/test_db')\nmeta = MetaData()\n\ntest_table = Table('test', meta,\n    Column('id', Integer(), primary_key=True),\n    Column('txt', CIText()))\n\nconn = engine.connect()\n\nmeta.bind = conn\nmeta.drop_all()\nmeta.create_all()\n\nclass TestObj(object):\n    def __init__(self, id_, txt):\n        self.id = id_\n        self.txt = txt\n\n    def __repr__(self):\n        return \"TestObj(%r, %r)\" % (self.id, self.txt)\n\norm.mapper(TestObj, test_table)\nSession = orm.sessionmaker(bind=engine)\nses = Session()\n\nto = TestObj(1, txt='FooFighter')\nses.add(to)\nses.commit()\nrow = ses.query(TestObj).filter(TestObj.txt == 'foofighter').all()\nassert len(row) == 1\nprint row\nses.close()\n```\n\n## License\n\n`sqlalchemy-citext` is an MIT/BSD dual-Licensed library.\n\n\n## Contribute\n\n- Check for open issues or open a fresh issue to start a discussion around a\n  feature idea or a bug.\n- Fork the repository on GitHub to start making your changes to the master\n  branch (or branch off of it).\n- Write a test which shows that the bug was fixed or that the feature\n  works as expected.\n- Send a pull request and bug the maintainer until it gets merged and\n  published.\n- Make sure to add yourself to the author's file in `setup.py` and the\n  `Contributors` section below :)\n\n## Contributors\n\n- [@mahmoudimus](https://github.com/mahmoudimus)\n- [@vad](https://github.com/vad)\n- [@dstufft](https://github.com/dstufft)\n- [@brmzkw](https://github.com/brmzkw)",
        "description_content_type": null,
        "docs_url": null,
        "download_url": "UNKNOWN",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://github.com/mahmoudimus/sqlalchemy-citext",
        "keywords": null,
        "license": "UNKNOWN",
        "maintainer": null,
        "maintainer_email": null,
        "name": "sqlalchemy-citext",
        "package_url": "https://pypi.org/project/sqlalchemy-citext/",
        "platform": "UNKNOWN",
        "project_url": "https://pypi.org/project/sqlalchemy-citext/",
        "project_urls": {
            "Download": "UNKNOWN",
            "Homepage": "https://github.com/mahmoudimus/sqlalchemy-citext"
        },
        "release_url": "https://pypi.org/project/sqlalchemy-citext/1.3-0/",
        "requires_dist": null,
        "requires_python": null,
        "summary": "A sqlalchemy plugin that allows postgres use of CITEXT.",
        "version": "1.3-0"
    },
    "last_serial": 1375619,
    "releases": {
        "1.0-0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "96f640581cf77a09b39ca35a5e363aa2",
                    "sha256": "be23d92b3dba8f807c9576f6c8431654ab6fa005667959900cfd25457007bd54"
                },
                "downloads": -1,
                "filename": "sqlalchemy-citext-1.0-0.tar.gz",
                "has_sig": false,
                "md5_digest": "96f640581cf77a09b39ca35a5e363aa2",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 2040,
                "upload_time": "2012-03-30T03:23:08",
                "url": "https://files.pythonhosted.org/packages/51/5a/2d718f9ac28d85ec8c8bb59087f2e451b24159763ddb977c918e2ccb2c0f/sqlalchemy-citext-1.0-0.tar.gz"
            }
        ],
        "1.0-1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "c30b1fa37397441392de9ba64dec3965",
                    "sha256": "3a86179b95e32085f5a5b09f37a512f0238320724cbfd9b277e0e8054279bd86"
                },
                "downloads": -1,
                "filename": "sqlalchemy-citext-1.0-1.tar.gz",
                "has_sig": false,
                "md5_digest": "c30b1fa37397441392de9ba64dec3965",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 2222,
                "upload_time": "2012-03-30T04:22:25",
                "url": "https://files.pythonhosted.org/packages/8b/08/e4b8d48c86f461ec1d416f8898bb9a2949aced8dfdd1c48a7cdfb4fd63c0/sqlalchemy-citext-1.0-1.tar.gz"
            }
        ],
        "1.0-2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "c076a1543c5e96677b0742a5ef30c82e",
                    "sha256": "9cf8026eebf60b1ac8cb78f4abff3b0df60d3370a8d991c2ac0af3e05f254608"
                },
                "downloads": -1,
                "filename": "sqlalchemy-citext-1.0-2.tar.gz",
                "has_sig": false,
                "md5_digest": "c076a1543c5e96677b0742a5ef30c82e",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 2228,
                "upload_time": "2012-03-30T18:25:52",
                "url": "https://files.pythonhosted.org/packages/74/31/8bf9d745cd1fb48a66befb901f81ce5aa47101977c40be056851d9fb3cb7/sqlalchemy-citext-1.0-2.tar.gz"
            }
        ],
        "1.1-0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "6205a2480d06d40f8810dee08710513f",
                    "sha256": "c3e3f59b017db01d9acf5043aadd8453d616a2005ce2cf3e3c6289919683e2da"
                },
                "downloads": -1,
                "filename": "sqlalchemy-citext-1.1-0.tar.gz",
                "has_sig": false,
                "md5_digest": "6205a2480d06d40f8810dee08710513f",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 2982,
                "upload_time": "2013-09-24T17:29:37",
                "url": "https://files.pythonhosted.org/packages/cd/7e/7682518d98a1d4a9cd9bd673a9a97ac1ffca393162605410f613931a079b/sqlalchemy-citext-1.1-0.tar.gz"
            }
        ],
        "1.2-0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "bd8bcf90a76c547de6a3fd7d0690b12f",
                    "sha256": "ec7d8c5a05f0876334bd7cc581775a0da4f93067ea7c736e00bd59fd04e55d8e"
                },
                "downloads": -1,
                "filename": "sqlalchemy-citext-1.2-0.tar.gz",
                "has_sig": false,
                "md5_digest": "bd8bcf90a76c547de6a3fd7d0690b12f",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 2993,
                "upload_time": "2013-09-30T00:01:32",
                "url": "https://files.pythonhosted.org/packages/b5/f4/18f78ddfe2384f7425c6c0da95ef6aa95dd9c9ead0ffc1dc9e1503ea69a2/sqlalchemy-citext-1.2-0.tar.gz"
            }
        ],
        "1.3-0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "5fbd2ab0318a271d10d8818cd9794c50",
                    "sha256": "7d7343037a35153d6f94c3c2f6baf391f88a57651c3bde5d6749d216859ae4c5"
                },
                "downloads": -1,
                "filename": "sqlalchemy-citext-1.3-0.tar.gz",
                "has_sig": false,
                "md5_digest": "5fbd2ab0318a271d10d8818cd9794c50",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 3208,
                "upload_time": "2015-01-08T16:37:51",
                "url": "https://files.pythonhosted.org/packages/49/4e/26a78dc12d4e280d6a3608367b73ad32dff298cc93a8d72ef4d281b374e8/sqlalchemy-citext-1.3-0.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "5fbd2ab0318a271d10d8818cd9794c50",
                "sha256": "7d7343037a35153d6f94c3c2f6baf391f88a57651c3bde5d6749d216859ae4c5"
            },
            "downloads": -1,
            "filename": "sqlalchemy-citext-1.3-0.tar.gz",
            "has_sig": false,
            "md5_digest": "5fbd2ab0318a271d10d8818cd9794c50",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 3208,
            "upload_time": "2015-01-08T16:37:51",
            "url": "https://files.pythonhosted.org/packages/49/4e/26a78dc12d4e280d6a3608367b73ad32dff298cc93a8d72ef4d281b374e8/sqlalchemy-citext-1.3-0.tar.gz"
        }
    ]
}