mysqlclient-collate


Namemysqlclient-collate JSON
Version 2.1.1.post2 PyPI version JSON
download
home_pagehttps://github.com/coderedcorp/mysqlclient-collate
SummaryPython interface to MySQL
upload_time2023-10-19 15:31:47
maintainer
docs_urlNone
authorCodeRed LLC
requires_python>=3.5
licenseGPL
keywords
VCS
bugtrack_url
requirements No requirements were recorded.
Travis-CI No Travis.
coveralls test coverage No coveralls.
            # mysqlclient-collate

**NOTE:** These features have been merged upstream into mysqlclient 2.2.0. This package is now archived. Please switch to `mysqlclient>=2.2` instead.

---

Fork of [mysqlclient](https://github.com/PyMySQL/mysqlclient) which adds support for setting collation via connection options.

Setting collation is necessary for servers that do not use the default, and for Django queries using `CAST` statements, which are prevalent in Wagtail 4. For more background, see the following discussions:

* [mysqlclient bug report](https://github.com/PyMySQL/mysqlclient/pull/564)
* [Wagtail bug report](https://github.com/wagtail/wagtail/issues/9477)

## Usage

Make sure you have MySQL or MariaDB C connector, and a C compiler installed.

**IMPORTANT**: If you already have `mysqlclient` installed, uninstall it before installing this fork. Both projects use the same module name and cannot be installed at the same time.

```
pip uninstall mysqlclient
pip install mysqlclient-collate
```

For use in a Django project, set your database connection as so:

```python
DATABASES = {
    "default": {
        "ENGINE": "django.db.backends.mysql",
        "HOST": "",
        "NAME": "",
        "USER": "",
        "PASSWORD": "",
        "OPTIONS": {
            "charset": "utf8mb4",
            "collation": "utf8mb4_unicode_ci",
        },
    }
}
```

            

Raw data

            {
    "_id": null,
    "home_page": "https://github.com/coderedcorp/mysqlclient-collate",
    "name": "mysqlclient-collate",
    "maintainer": "",
    "docs_url": null,
    "requires_python": ">=3.5",
    "maintainer_email": "",
    "keywords": "",
    "author": "CodeRed LLC",
    "author_email": "info@coderedcorp.com",
    "download_url": "https://files.pythonhosted.org/packages/8c/6f/ae76ffe0dc52ec56697bbdec0879befc57e7d8c69a8201c7ac276c755c11/mysqlclient-collate-2.1.1.post2.tar.gz",
    "platform": "ALL",
    "description": "# mysqlclient-collate\r\n\r\n**NOTE:** These features have been merged upstream into mysqlclient 2.2.0. This package is now archived. Please switch to `mysqlclient>=2.2` instead.\r\n\r\n---\r\n\r\nFork of [mysqlclient](https://github.com/PyMySQL/mysqlclient) which adds support for setting collation via connection options.\r\n\r\nSetting collation is necessary for servers that do not use the default, and for Django queries using `CAST` statements, which are prevalent in Wagtail 4. For more background, see the following discussions:\r\n\r\n* [mysqlclient bug report](https://github.com/PyMySQL/mysqlclient/pull/564)\r\n* [Wagtail bug report](https://github.com/wagtail/wagtail/issues/9477)\r\n\r\n## Usage\r\n\r\nMake sure you have MySQL or MariaDB C connector, and a C compiler installed.\r\n\r\n**IMPORTANT**: If you already have `mysqlclient` installed, uninstall it before installing this fork. Both projects use the same module name and cannot be installed at the same time.\r\n\r\n```\r\npip uninstall mysqlclient\r\npip install mysqlclient-collate\r\n```\r\n\r\nFor use in a Django project, set your database connection as so:\r\n\r\n```python\r\nDATABASES = {\r\n    \"default\": {\r\n        \"ENGINE\": \"django.db.backends.mysql\",\r\n        \"HOST\": \"\",\r\n        \"NAME\": \"\",\r\n        \"USER\": \"\",\r\n        \"PASSWORD\": \"\",\r\n        \"OPTIONS\": {\r\n            \"charset\": \"utf8mb4\",\r\n            \"collation\": \"utf8mb4_unicode_ci\",\r\n        },\r\n    }\r\n}\r\n```\r\n",
    "bugtrack_url": null,
    "license": "GPL",
    "summary": "Python interface to MySQL",
    "version": "2.1.1.post2",
    "project_urls": {
        "Homepage": "https://github.com/coderedcorp/mysqlclient-collate"
    },
    "split_keywords": [],
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "d09a147bce3c8ffa72da6b1ec067c478bf191b0cc6c3c79af4adaa4fa77919f4",
                "md5": "b825ac4d2f01833153ec0150ac1598fa",
                "sha256": "7884c06f23d731676916d2a36d021a5669d374f99f8888c91ef47c4a949d6bfc"
            },
            "downloads": -1,
            "filename": "mysqlclient_collate-2.1.1.post2-cp310-cp310-win_amd64.whl",
            "has_sig": false,
            "md5_digest": "b825ac4d2f01833153ec0150ac1598fa",
            "packagetype": "bdist_wheel",
            "python_version": "cp310",
            "requires_python": ">=3.5",
            "size": 173548,
            "upload_time": "2023-10-19T15:31:38",
            "upload_time_iso_8601": "2023-10-19T15:31:38.793383Z",
            "url": "https://files.pythonhosted.org/packages/d0/9a/147bce3c8ffa72da6b1ec067c478bf191b0cc6c3c79af4adaa4fa77919f4/mysqlclient_collate-2.1.1.post2-cp310-cp310-win_amd64.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "c7fa954f2bd46dc9ab3526bdaf59ae4c9dfb5bb89524dfe75cdc23283bb3ed76",
                "md5": "13bada219bef3aabc842013834966f33",
                "sha256": "d67d1eed148a5ae7e955f2fc1b6167f6dc385d8b812078b9cebc5863adc9a9ff"
            },
            "downloads": -1,
            "filename": "mysqlclient_collate-2.1.1.post2-cp311-cp311-win_amd64.whl",
            "has_sig": false,
            "md5_digest": "13bada219bef3aabc842013834966f33",
            "packagetype": "bdist_wheel",
            "python_version": "cp311",
            "requires_python": ">=3.5",
            "size": 173551,
            "upload_time": "2023-10-19T15:31:40",
            "upload_time_iso_8601": "2023-10-19T15:31:40.628613Z",
            "url": "https://files.pythonhosted.org/packages/c7/fa/954f2bd46dc9ab3526bdaf59ae4c9dfb5bb89524dfe75cdc23283bb3ed76/mysqlclient_collate-2.1.1.post2-cp311-cp311-win_amd64.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "b50e0bbbf04ca2340e8d49d74868fa68bde58d5cf09540f8f27970d230724763",
                "md5": "987a3b5dc9917ae121fcba67aac6e674",
                "sha256": "e071c70aff80181989fe4d0f6c09c57530b4f42bdb13be43387b42bb2d730bc3"
            },
            "downloads": -1,
            "filename": "mysqlclient_collate-2.1.1.post2-cp37-cp37m-win_amd64.whl",
            "has_sig": false,
            "md5_digest": "987a3b5dc9917ae121fcba67aac6e674",
            "packagetype": "bdist_wheel",
            "python_version": "cp37",
            "requires_python": ">=3.5",
            "size": 174145,
            "upload_time": "2023-10-19T15:31:42",
            "upload_time_iso_8601": "2023-10-19T15:31:42.389870Z",
            "url": "https://files.pythonhosted.org/packages/b5/0e/0bbbf04ca2340e8d49d74868fa68bde58d5cf09540f8f27970d230724763/mysqlclient_collate-2.1.1.post2-cp37-cp37m-win_amd64.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "0aacb2cfbefbb08835d019a3c187e976f6ae834afb4bb1d09db27183aa708a36",
                "md5": "080a59c9689f823bc48ad2c86a0613b9",
                "sha256": "2429c9915ae10e5fb16a9d8c7f9de9d542c70c4c35861f403121d4beb5a83c01"
            },
            "downloads": -1,
            "filename": "mysqlclient_collate-2.1.1.post2-cp38-cp38-win_amd64.whl",
            "has_sig": false,
            "md5_digest": "080a59c9689f823bc48ad2c86a0613b9",
            "packagetype": "bdist_wheel",
            "python_version": "cp38",
            "requires_python": ">=3.5",
            "size": 174488,
            "upload_time": "2023-10-19T15:31:43",
            "upload_time_iso_8601": "2023-10-19T15:31:43.896086Z",
            "url": "https://files.pythonhosted.org/packages/0a/ac/b2cfbefbb08835d019a3c187e976f6ae834afb4bb1d09db27183aa708a36/mysqlclient_collate-2.1.1.post2-cp38-cp38-win_amd64.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "ed5a24a051d68fb23b4a02a21301e3845772239a038d9357a159d311993ade2a",
                "md5": "67dbb43fee7c31e2087a2b8457e4ac8a",
                "sha256": "faa37c715858d0b486448a1236b1ad5ff008b5f8a2a0b383e0b72d4f353f6718"
            },
            "downloads": -1,
            "filename": "mysqlclient_collate-2.1.1.post2-cp39-cp39-win_amd64.whl",
            "has_sig": false,
            "md5_digest": "67dbb43fee7c31e2087a2b8457e4ac8a",
            "packagetype": "bdist_wheel",
            "python_version": "cp39",
            "requires_python": ">=3.5",
            "size": 174477,
            "upload_time": "2023-10-19T15:31:45",
            "upload_time_iso_8601": "2023-10-19T15:31:45.716981Z",
            "url": "https://files.pythonhosted.org/packages/ed/5a/24a051d68fb23b4a02a21301e3845772239a038d9357a159d311993ade2a/mysqlclient_collate-2.1.1.post2-cp39-cp39-win_amd64.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "8c6fae76ffe0dc52ec56697bbdec0879befc57e7d8c69a8201c7ac276c755c11",
                "md5": "75cfbf8efc38e2c6cace547539209d9d",
                "sha256": "6c98e4e2cb8863898ce4c2b590d8ed44e8b33165f12d77556c34f8bb6a14aab4"
            },
            "downloads": -1,
            "filename": "mysqlclient-collate-2.1.1.post2.tar.gz",
            "has_sig": false,
            "md5_digest": "75cfbf8efc38e2c6cace547539209d9d",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": ">=3.5",
            "size": 87152,
            "upload_time": "2023-10-19T15:31:47",
            "upload_time_iso_8601": "2023-10-19T15:31:47.615750Z",
            "url": "https://files.pythonhosted.org/packages/8c/6f/ae76ffe0dc52ec56697bbdec0879befc57e7d8c69a8201c7ac276c755c11/mysqlclient-collate-2.1.1.post2.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2023-10-19 15:31:47",
    "github": true,
    "gitlab": false,
    "bitbucket": false,
    "codeberg": false,
    "github_user": "coderedcorp",
    "github_project": "mysqlclient-collate",
    "travis_ci": false,
    "coveralls": false,
    "github_actions": true,
    "lcname": "mysqlclient-collate"
}
        
Elapsed time: 0.15093s