database-wrapper-mysql


Namedatabase-wrapper-mysql JSON
Version 0.1.85 PyPI version JSON
download
home_pageNone
Summarydatabase_wrapper for MySQL database
upload_time2025-04-25 21:34:55
maintainerNone
docs_urlNone
authorNone
requires_python>=3.8
licenseGNU General Public License v3.0 (GPL-3.0)
keywords database wrapper python mysql mariadb
VCS
bugtrack_url
requirements No requirements were recorded.
Travis-CI No Travis.
coveralls test coverage No coveralls.
            # database_wrapper_mysql

_Part of the `database_wrapper` package._

This python package is a database wrapper for [MySQL](https://www.mysql.com/) and [MariaDB](https://mariadb.org/) database.

## Installation

```bash
pip install database_wrapper[mysql]
```

## Usage

```python
from database_wrapper_mysql import MySQL, DBWrapperMySQL

db = MySQL({
    "hostname": "localhost",
    "port": 3306,
    "username": "root",
    "password": "your_password",
    "database": "my_database"
})
db.open()
dbWrapper = DBWrapperMySQL(dbCursor=db.cursor)

# Simple query
aModel = MyModel()
res = await dbWrapper.getByKey(
    aModel,
    "id",
    3005,
)
if res:
    print(f"getByKey: {res.toDict()}")
else:
    print("No results")

# Raw query
res = await dbWrapper.getAll(
    aModel,
    customQuery="""
        SELECT t1.*, t2.name AS other_name
        FROM my_table AS t1
        LEFT JOIN other_table AS t2 ON t1.other_id = t2.id
    """
)
async for record in res:
    print(f"getAll: {record.toDict()}")
else:
    print("No results")

db.close()
```

            

Raw data

            {
    "_id": null,
    "home_page": null,
    "name": "database-wrapper-mysql",
    "maintainer": null,
    "docs_url": null,
    "requires_python": ">=3.8",
    "maintainer_email": null,
    "keywords": "database, wrapper, python, mysql, mariadb",
    "author": null,
    "author_email": "Gints Murans <gm@gm.lv>",
    "download_url": "https://files.pythonhosted.org/packages/78/e0/d25091cf993df215aaae92ee5ab2d9c83dc663c6f9b639a63f4f6da4f1b9/database_wrapper_mysql-0.1.85.tar.gz",
    "platform": null,
    "description": "# database_wrapper_mysql\n\n_Part of the `database_wrapper` package._\n\nThis python package is a database wrapper for [MySQL](https://www.mysql.com/) and [MariaDB](https://mariadb.org/) database.\n\n## Installation\n\n```bash\npip install database_wrapper[mysql]\n```\n\n## Usage\n\n```python\nfrom database_wrapper_mysql import MySQL, DBWrapperMySQL\n\ndb = MySQL({\n    \"hostname\": \"localhost\",\n    \"port\": 3306,\n    \"username\": \"root\",\n    \"password\": \"your_password\",\n    \"database\": \"my_database\"\n})\ndb.open()\ndbWrapper = DBWrapperMySQL(dbCursor=db.cursor)\n\n# Simple query\naModel = MyModel()\nres = await dbWrapper.getByKey(\n    aModel,\n    \"id\",\n    3005,\n)\nif res:\n    print(f\"getByKey: {res.toDict()}\")\nelse:\n    print(\"No results\")\n\n# Raw query\nres = await dbWrapper.getAll(\n    aModel,\n    customQuery=\"\"\"\n        SELECT t1.*, t2.name AS other_name\n        FROM my_table AS t1\n        LEFT JOIN other_table AS t2 ON t1.other_id = t2.id\n    \"\"\"\n)\nasync for record in res:\n    print(f\"getAll: {record.toDict()}\")\nelse:\n    print(\"No results\")\n\ndb.close()\n```\n",
    "bugtrack_url": null,
    "license": "GNU General Public License v3.0 (GPL-3.0)",
    "summary": "database_wrapper for MySQL database",
    "version": "0.1.85",
    "project_urls": {
        "Changes": "https://github.com/gintsmurans/py_database_wrapper",
        "Code": "https://github.com/gintsmurans/py_database_wrapper",
        "Documentation": "https://github.com/gintsmurans/py_database_wrapper",
        "Download": "https://pypi.org/project/database_wrapper/",
        "Homepage": "https://github.com/gintsmurans/py_database_wrapper",
        "Issue Tracker": "https://github.com/gintsmurans/py_database_wrapper/issues"
    },
    "split_keywords": [
        "database",
        " wrapper",
        " python",
        " mysql",
        " mariadb"
    ],
    "urls": [
        {
            "comment_text": null,
            "digests": {
                "blake2b_256": "726c51e0376e2dbf46f1df1274b1cbccb61e7c5cdf822e5191bd6567a55d646f",
                "md5": "467b7100e904a28ac22469de1ed5dd94",
                "sha256": "6a2f71a0af11523b6c7340d90d4f3b95a6d319267baaaa5b4b358334e5b59171"
            },
            "downloads": -1,
            "filename": "database_wrapper_mysql-0.1.85-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "467b7100e904a28ac22469de1ed5dd94",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": ">=3.8",
            "size": 5050,
            "upload_time": "2025-04-25T21:34:49",
            "upload_time_iso_8601": "2025-04-25T21:34:49.747915Z",
            "url": "https://files.pythonhosted.org/packages/72/6c/51e0376e2dbf46f1df1274b1cbccb61e7c5cdf822e5191bd6567a55d646f/database_wrapper_mysql-0.1.85-py3-none-any.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": null,
            "digests": {
                "blake2b_256": "78e0d25091cf993df215aaae92ee5ab2d9c83dc663c6f9b639a63f4f6da4f1b9",
                "md5": "22452a9e7798971218e1cc9af251fdee",
                "sha256": "d94beeabc0a132eded056fe0c059d492b816038b10f6c90695e7d5da7a624cbd"
            },
            "downloads": -1,
            "filename": "database_wrapper_mysql-0.1.85.tar.gz",
            "has_sig": false,
            "md5_digest": "22452a9e7798971218e1cc9af251fdee",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": ">=3.8",
            "size": 4300,
            "upload_time": "2025-04-25T21:34:55",
            "upload_time_iso_8601": "2025-04-25T21:34:55.881095Z",
            "url": "https://files.pythonhosted.org/packages/78/e0/d25091cf993df215aaae92ee5ab2d9c83dc663c6f9b639a63f4f6da4f1b9/database_wrapper_mysql-0.1.85.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2025-04-25 21:34:55",
    "github": true,
    "gitlab": false,
    "bitbucket": false,
    "codeberg": false,
    "github_user": "gintsmurans",
    "github_project": "py_database_wrapper",
    "travis_ci": false,
    "coveralls": false,
    "github_actions": true,
    "lcname": "database-wrapper-mysql"
}
        
Elapsed time: 8.74065s