SQLLink


NameSQLLink JSON
Version 1.0.0 PyPI version JSON
download
home_pagehttps://github.com/TRC-Loop/SQLLink
SummarySQLLink is a simple library which enables you to use SQLite databases without SQL.
upload_time2024-05-06 19:54:51
maintainerNone
docs_urlNone
authorAK
requires_python>=3.6
licenseNone
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"
}
        
AK
Elapsed time: 0.65355s