| Name | shipyard-mysql JSON |
| Version |
0.1.0
JSON |
| download |
| home_page | None |
| Summary | A local client for connecting and working with MySQL databases |
| upload_time | 2024-03-26 02:25:49 |
| maintainer | None |
| docs_url | None |
| author | wrp801 |
| requires_python | <4.0,>=3.9 |
| license | Apache 2.0 |
| keywords |
|
| VCS |
|
| bugtrack_url |
|
| requirements |
No requirements were recorded.
|
| Travis-CI |
No Travis.
|
| coveralls test coverage |
No coveralls.
|
# MySQL Client
This Python module provides a client for interacting with MySQL databases, allowing users to perform various operations such as executing queries, uploading data from files, fetching data, and more.
## Installation
To use the MySQL Client, you need to have Python installed. You can install the module via pip:
```bash
pip install shipyard-mysql
```
## Usage
```python
from mysql_client import MySqlClient
# Initialize the MySQL client
client = MySqlClient(username='your_username', pwd='your_password', host='localhost', database='your_database')
# Execute a query
query = "SELECT * FROM your_table"
client.execute_query(query)
# Upload data from a file
client.upload(file='data.csv', table_name='your_table')
# Fetch data
result_df = client.fetch(query)
# Close the connection
client.close()
```
Raw data
{
"_id": null,
"home_page": null,
"name": "shipyard-mysql",
"maintainer": null,
"docs_url": null,
"requires_python": "<4.0,>=3.9",
"maintainer_email": null,
"keywords": null,
"author": "wrp801",
"author_email": "wespoulsen@gmail.com",
"download_url": "https://files.pythonhosted.org/packages/28/16/f0cb8b10fc16b1a5a00415b57c54fe161ce6e5f7e218e1a75feedc03257c/shipyard_mysql-0.1.0.tar.gz",
"platform": null,
"description": "# MySQL Client\n\nThis Python module provides a client for interacting with MySQL databases, allowing users to perform various operations such as executing queries, uploading data from files, fetching data, and more.\n\n## Installation\n\nTo use the MySQL Client, you need to have Python installed. You can install the module via pip:\n\n```bash\npip install shipyard-mysql\n```\n## Usage \n\n```python \nfrom mysql_client import MySqlClient\n\n# Initialize the MySQL client\nclient = MySqlClient(username='your_username', pwd='your_password', host='localhost', database='your_database')\n\n# Execute a query\nquery = \"SELECT * FROM your_table\"\nclient.execute_query(query)\n\n# Upload data from a file\nclient.upload(file='data.csv', table_name='your_table')\n\n# Fetch data\nresult_df = client.fetch(query)\n\n# Close the connection\nclient.close()\n```\n",
"bugtrack_url": null,
"license": "Apache 2.0",
"summary": "A local client for connecting and working with MySQL databases",
"version": "0.1.0",
"project_urls": null,
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "01d7873a9e819f640915e32279f3710b0bd80532188be8e638aa57a1c22135eb",
"md5": "84f830ee7051f301dffd11397ceb0c9e",
"sha256": "bc98c2ae27728a2baeaa496500c0c8081737d1d62e913bbbf1cb3aeeef29cabe"
},
"downloads": -1,
"filename": "shipyard_mysql-0.1.0-py3-none-any.whl",
"has_sig": false,
"md5_digest": "84f830ee7051f301dffd11397ceb0c9e",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": "<4.0,>=3.9",
"size": 7933,
"upload_time": "2024-03-26T02:25:47",
"upload_time_iso_8601": "2024-03-26T02:25:47.599039Z",
"url": "https://files.pythonhosted.org/packages/01/d7/873a9e819f640915e32279f3710b0bd80532188be8e638aa57a1c22135eb/shipyard_mysql-0.1.0-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "2816f0cb8b10fc16b1a5a00415b57c54fe161ce6e5f7e218e1a75feedc03257c",
"md5": "9e5ee722c8a946da525c06933708c245",
"sha256": "0000bd640692f9df3bd98e1249eff041b6caaa3c48f6cd632022bcc83e28f994"
},
"downloads": -1,
"filename": "shipyard_mysql-0.1.0.tar.gz",
"has_sig": false,
"md5_digest": "9e5ee722c8a946da525c06933708c245",
"packagetype": "sdist",
"python_version": "source",
"requires_python": "<4.0,>=3.9",
"size": 5313,
"upload_time": "2024-03-26T02:25:49",
"upload_time_iso_8601": "2024-03-26T02:25:49.209587Z",
"url": "https://files.pythonhosted.org/packages/28/16/f0cb8b10fc16b1a5a00415b57c54fe161ce6e5f7e218e1a75feedc03257c/shipyard_mysql-0.1.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-03-26 02:25:49",
"github": false,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"lcname": "shipyard-mysql"
}
