Name | SQLLink JSON |
Version |
1.0.0
JSON |
| download |
home_page | https://github.com/TRC-Loop/SQLLink |
Summary | SQLLink is a simple library which enables you to use SQLite databases without SQL. |
upload_time | 2024-05-06 19:54:51 |
maintainer | None |
docs_url | None |
author | AK |
requires_python | >=3.6 |
license | None |
keywords |
|
VCS |
 |
bugtrack_url |
|
requirements |
No requirements were recorded.
|
Travis-CI |
No Travis.
|
coveralls test coverage |
No coveralls.
|
# SQLLink
SQLLink is a Python library designed to simplify interactions with SQLite databases, abstracting away the need for direct SQL queries.
## Features
- Simplified database operations through intuitive Python functions.
- Automatic SQL query generation based on user input.
- Custom exception handling for robust error management.
## Installation
Install SQLLink using pip:
```bash
pip3 install sqllink
```
## Usage
### Creating a Table
```python
from sqllink import db_utils
import sqlite3
s
conn = sqlite3.connect('example.db')
columns = {
'id': 'integer PRIMARY KEY',
'name': 'text NOT NULL',
'salary': 'real'
}
db_utils.create_table(conn, 'employees', columns)
```
### Adding Data
```python
data = [(1, 'Alice', 80000.0), (2, 'Bob', 90000.0)]
db_utils.add_data(conn, 'employees', data)
```
### Querying Data
```python
results = db_utils.query_data(conn, 'employees', "salary > 85000")
print(results)
```
### Deleting a Table
```python
db_utils.delete_table(conn, 'employees')
```
## Troubleshooting
If you encounter any issues:
- Verify that SQLite is correctly installed and accessible in your environment.
- Ensure that you're using Python 3.6 or later.
- Review the error messages carefully; they are designed to provide insights into potential issues.
## Contributions
Contributions to SQLLink are welcome! Please fork the repository and submit a pull request to contribute.
## License
SQLLink is released under the MIT License. View the license [here](https://github.com/TRC-Loop/SQLLink/blob/main/LICENSE).
## Repository
Link to the repository: [SQLLink Repository](https://github.com/TRC-Loop/SQLLink)
Raw data
{
"_id": null,
"home_page": "https://github.com/TRC-Loop/SQLLink",
"name": "SQLLink",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3.6",
"maintainer_email": null,
"keywords": null,
"author": "AK",
"author_email": "ak@stellar-code.com",
"download_url": "https://files.pythonhosted.org/packages/83/1e/ebcac18caf20d68f14e35f296c7dee912c4414adf1d3e1f7d59d9031d884/SQLLink-1.0.0.tar.gz",
"platform": null,
"description": "# SQLLink\n\nSQLLink is a Python library designed to simplify interactions with SQLite databases, abstracting away the need for direct SQL queries.\n\n## Features\n\n- Simplified database operations through intuitive Python functions.\n- Automatic SQL query generation based on user input.\n- Custom exception handling for robust error management.\n\n## Installation\n\nInstall SQLLink using pip:\n\n```bash\npip3 install sqllink\n```\n\n## Usage\n\n### Creating a Table\n\n```python\nfrom sqllink import db_utils\nimport sqlite3\ns\nconn = sqlite3.connect('example.db')\ncolumns = {\n 'id': 'integer PRIMARY KEY',\n 'name': 'text NOT NULL',\n 'salary': 'real'\n}\ndb_utils.create_table(conn, 'employees', columns)\n```\n\n### Adding Data\n\n```python\ndata = [(1, 'Alice', 80000.0), (2, 'Bob', 90000.0)]\ndb_utils.add_data(conn, 'employees', data)\n```\n\n### Querying Data\n\n```python\nresults = db_utils.query_data(conn, 'employees', \"salary > 85000\")\nprint(results)\n```\n\n### Deleting a Table\n\n```python\ndb_utils.delete_table(conn, 'employees')\n```\n\n## Troubleshooting\n\nIf you encounter any issues:\n- Verify that SQLite is correctly installed and accessible in your environment.\n- Ensure that you're using Python 3.6 or later.\n- Review the error messages carefully; they are designed to provide insights into potential issues.\n\n## Contributions\n\nContributions to SQLLink are welcome! Please fork the repository and submit a pull request to contribute.\n\n## License\n\nSQLLink is released under the MIT License. View the license [here](https://github.com/TRC-Loop/SQLLink/blob/main/LICENSE).\n\n## Repository\n\nLink to the repository: [SQLLink Repository](https://github.com/TRC-Loop/SQLLink)\n",
"bugtrack_url": null,
"license": null,
"summary": "SQLLink is a simple library which enables you to use SQLite databases without SQL.",
"version": "1.0.0",
"project_urls": {
"Homepage": "https://github.com/TRC-Loop/SQLLink"
},
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "70f0fe86ebab385b329bbe686a79ddb5609ee2154d260305aa492d536d60e5d3",
"md5": "ee707d869991b0bb5d637cc252781eb1",
"sha256": "f98e82fa935b9e080d1b0378b2a50acd1b4b60c0c854a4526d0c516308aa600a"
},
"downloads": -1,
"filename": "SQLLink-1.0.0-py3-none-any.whl",
"has_sig": false,
"md5_digest": "ee707d869991b0bb5d637cc252781eb1",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.6",
"size": 6104,
"upload_time": "2024-05-06T19:54:49",
"upload_time_iso_8601": "2024-05-06T19:54:49.486064Z",
"url": "https://files.pythonhosted.org/packages/70/f0/fe86ebab385b329bbe686a79ddb5609ee2154d260305aa492d536d60e5d3/SQLLink-1.0.0-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "831eebcac18caf20d68f14e35f296c7dee912c4414adf1d3e1f7d59d9031d884",
"md5": "cc3faf8f3bb8823275c9f0aabff695e2",
"sha256": "ad81d1209917626df560cf3a8b14e1b8f9187291ddfda38d4b11b9ae8513392a"
},
"downloads": -1,
"filename": "SQLLink-1.0.0.tar.gz",
"has_sig": false,
"md5_digest": "cc3faf8f3bb8823275c9f0aabff695e2",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.6",
"size": 5075,
"upload_time": "2024-05-06T19:54:51",
"upload_time_iso_8601": "2024-05-06T19:54:51.327392Z",
"url": "https://files.pythonhosted.org/packages/83/1e/ebcac18caf20d68f14e35f296c7dee912c4414adf1d3e1f7d59d9031d884/SQLLink-1.0.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-05-06 19:54:51",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "TRC-Loop",
"github_project": "SQLLink",
"travis_ci": false,
"coveralls": false,
"github_actions": false,
"lcname": "sqllink"
}