athenaSql

Name	athenaSql JSON
Version	0.1.1 JSON
	download
home_page	https://github.com/nabilseid/athenaSQL
Summary	SQL builder for AWS Athena, inspired by sparkSQL
upload_time	2024-11-01 18:46:09
maintainer	None
docs_url	None
author	Nabil Seid
requires_python	<4.0,>=3.7
license	MIT
keywords	packaging athena sql athenasql
VCS
bugtrack_url
requirements	No requirements were recorded.
Travis-CI	No Travis.
coveralls test coverage	No coveralls.

            # athenaSQL

<!-- start intro -->

athenaSQL is Athena SQL query builder, inspired by sparkSQL. It borrow some sparkSQL's concept [sparkSQL](https://spark.apache.org/docs/preview/api/python/_modules/index.html).

It was initially designed to eliminate the need for hard-coding SQL queries as strings within Python scripts and as an alternative to any bespoke SQL query templating. However, it offers the flexibility to be used in various ways as needed.

<!-- end intro -->

## Quickstart

<!-- start quickstart -->

### Installing athenaSQL

```bash
$ pip install athenaSQL
```

### Usage

<!-- start usage -->

Using athenaSQL is stright forward. First we create a table abstraction class then building a query is just calling chain methods on top of it.

```python
from athenaSQL import Athena

# creating athena table instance from database
table = Athena('database_name').table('table_name')

# creating athena table instance from database
query = table.select()

query.show_query()
```

```
SELECT
    *
FROM "database_name"."table_name"
```

<!-- end usage -->

<!-- end quickstart -->

            

Raw data

            {
    "_id": null,
    "home_page": "https://github.com/nabilseid/athenaSQL",
    "name": "athenaSql",
    "maintainer": null,
    "docs_url": null,
    "requires_python": "<4.0,>=3.7",
    "maintainer_email": null,
    "keywords": "packaging, athena, sql, athenaSQL",
    "author": "Nabil Seid",
    "author_email": "nabeelseid@gmail.com",
    "download_url": "https://files.pythonhosted.org/packages/3c/b0/7641cc3536437aee6570ff5a938ee33b14ef90b3b04541e1408e589fdad7/athenasql-0.1.1.tar.gz",
    "platform": null,
    "description": "# athenaSQL\n\n<!-- start intro -->\n\nathenaSQL is Athena SQL query builder, inspired by sparkSQL. It borrow some sparkSQL's concept [sparkSQL](https://spark.apache.org/docs/preview/api/python/_modules/index.html).\n\nIt was initially designed to eliminate the need for hard-coding SQL queries as strings within Python scripts and as an alternative to any bespoke SQL query templating. However, it offers the flexibility to be used in various ways as needed.\n\n<!-- end intro -->\n\n## Quickstart\n\n<!-- start quickstart -->\n\n### Installing athenaSQL\n\n```bash\n$ pip install athenaSQL\n```\n\n### Usage\n\n<!-- start usage -->\n\nUsing athenaSQL is stright forward. First we create a table abstraction class then building a query is just calling chain methods on top of it.\n\n```python\nfrom athenaSQL import Athena\n\n# creating athena table instance from database\ntable = Athena('database_name').table('table_name')\n\n# creating athena table instance from database\nquery = table.select()\n\nquery.show_query()\n```\n\n```\nSELECT\n    *\nFROM \"database_name\".\"table_name\"\n```\n\n<!-- end usage -->\n\n<!-- end quickstart -->\n",
    "bugtrack_url": null,
    "license": "MIT",
    "summary": "SQL builder for AWS Athena, inspired by sparkSQL",
    "version": "0.1.1",
    "project_urls": {
        "Documentation": "https://github.com/nabilseid/athenaSQL/docs",
        "Homepage": "https://github.com/nabilseid/athenaSQL",
        "Repository": "https://github.com/nabilseid/athenaSQL"
    },
    "split_keywords": [
        "packaging",
        " athena",
        " sql",
        " athenasql"
    ],
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "7a7f0e6936d2166faf8add9aa76fe204bcefb549b8ea23996afa3fa1b90c83b4",
                "md5": "04033cd013947f259e447d026254f3a0",
                "sha256": "6e158f0001c3563c1047547714a48718c351f1d84a45e60aa8c1604ad28bf57a"
            },
            "downloads": -1,
            "filename": "athenasql-0.1.1-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "04033cd013947f259e447d026254f3a0",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": "<4.0,>=3.7",
            "size": 30470,
            "upload_time": "2024-11-01T18:46:08",
            "upload_time_iso_8601": "2024-11-01T18:46:08.167200Z",
            "url": "https://files.pythonhosted.org/packages/7a/7f/0e6936d2166faf8add9aa76fe204bcefb549b8ea23996afa3fa1b90c83b4/athenasql-0.1.1-py3-none-any.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "3cb07641cc3536437aee6570ff5a938ee33b14ef90b3b04541e1408e589fdad7",
                "md5": "988b178c9c13f68ae9e59de491dcbc1b",
                "sha256": "72df75f4fd83211339fdb04c7e2b2bf2920c841cd3798259340921a7066c6cc1"
            },
            "downloads": -1,
            "filename": "athenasql-0.1.1.tar.gz",
            "has_sig": false,
            "md5_digest": "988b178c9c13f68ae9e59de491dcbc1b",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": "<4.0,>=3.7",
            "size": 20931,
            "upload_time": "2024-11-01T18:46:09",
            "upload_time_iso_8601": "2024-11-01T18:46:09.095155Z",
            "url": "https://files.pythonhosted.org/packages/3c/b0/7641cc3536437aee6570ff5a938ee33b14ef90b3b04541e1408e589fdad7/athenasql-0.1.1.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2024-11-01 18:46:09",
    "github": true,
    "gitlab": false,
    "bitbucket": false,
    "codeberg": false,
    "github_user": "nabilseid",
    "github_project": "athenaSQL",
    "travis_ci": false,
    "coveralls": false,
    "github_actions": true,
    "lcname": "athenasql"
}