{ "info": { "author": "Teradata Corporation", "author_email": "teradatasql@teradata.com", "bugtrack_url": null, "classifiers": [ "License :: Other/Proprietary License", "Operating System :: MacOS :: MacOS X", "Operating System :: Microsoft :: Windows", "Operating System :: POSIX :: Linux", "Programming Language :: Python :: 3.4", "Programming Language :: Python :: 3.5", "Programming Language :: Python :: 3.6", "Programming Language :: Python :: 3.7", "Programming Language :: Python :: 3 :: Only", "Topic :: Database :: Front-Ends" ], "description": "## Teradata SQL Driver Dialect for SQLAlchemy\n\nThis package enables [SQLAlchemy](https://pypi.org/project/SQLAlchemy/) to connect to the Teradata Database.\n\nThis package requires 64-bit Python 3.4 or later, and runs on Windows, macOS, and Linux. 32-bit Python is not supported.\n\nFor community support, please visit the [Connectivity Forum](http://community.teradata.com/t5/Connectivity/bd-p/DevXConnectivityBoard).\n\nFor Teradata customer support, please visit [Teradata Access](https://access.teradata.com/).\n\nCopyright 2018 Teradata. All Rights Reserved.\n\n### Table of Contents\n\n* [Installation](#Installation)\n* [License](#License)\n* [Documentation](#Documentation)\n* [Using the Teradata SQL Driver Dialect for SQLAlchemy](#Using)\n* [Connection Parameters](#ConnectionParameters)\n\n\n\n### Installation\n\nUse pip to install the Teradata SQL Driver Dialect for SQLAlchemy.\n\nPlatform | Command\n-------------- | ---\nmacOS or Linux | `pip install teradatasqlalchemy`\nWindows | `py -3 -m pip install teradatasqlalchemy`\n\nWhen upgrading to a new version of the Teradata SQL Driver Dialect for SQLAlchemy, you may need to use pip install's `--no-cache-dir` option to force the download of the new version.\n\nPlatform | Command\n-------------- | ---\nmacOS or Linux | `pip install --no-cache-dir -U teradatasqlalchemy`\nWindows | `py -3 -m pip install --no-cache-dir -U teradatasqlalchemy`\n\n\n\n### License\n\nUse of the Teradata SQL Driver Dialect for SQLAlchemy is governed by the *License Agreement for the Teradata SQL Driver Dialect for SQLAlchemy*.\n\nWhen the Teradata SQL Driver Dialect for SQLAlchemy is installed, the `LICENSE` file is placed in the `teradatasqlalchemy` directory under your Python installation directory.\n\n\n\n### Documentation\n\nWhen the Teradata SQL Driver Dialect for SQLAlchemy is installed, the `README.md` file is placed in the `teradatasqlalchemy` directory under your Python installation directory. This permits you to view the documentation offline, when you are not connected to the Internet.\n\nThe `README.md` file is a plain text file containing the documentation for the Teradata SQL Driver Dialect for SQLAlchemy. While the file can be viewed with any text file viewer or editor, your viewing experience will be best with an editor that understands Markdown format.\n\n\n\n### Using the Teradata SQL Driver Dialect for SQLAlchemy\n\nYour Python script must import the `sqlalchemy` package in order to use the Teradata SQL Driver Dialect for SQLAlchemy.\n\n import sqlalchemy\n\nAfter importing the `sqlalchemy` package, your Python script calls the `sqlalchemy.create_engine` function to open a connection to the Teradata Database.\n\nSpecify the Teradata Database hostname as the *host* component of the URL. Note that COP Discovery is not implemented yet.\n\nThe URL's *host* component may optionally be followed by a slash and question mark `/?` and the URL's *query* component consisting of connection parameters specified as *key*`=`*value* pairs separated by ampersand `&` characters.\n\nThe username and password may be specified as a *host* prefix, or as connection URL parameters.\n\nUsername and password specified as a *host* prefix:\n\n eng = sqlalchemy.create_engine('teradatasql://guest:please@whomooz')\n\nUsername and password specified as connection URL parameters:\n\n eng = sqlalchemy.create_engine('teradatasql://whomooz/?user=guest&password=please')\n\nUsername and password specified as connection URL parameters take precedence over a *host* prefix, if both are specified.\n\n\n\n### Connection Parameters\n\nThe following table lists the connection parameters currently offered by the Teradata SQL Driver Dialect for SQLAlchemy.\n\nOur goal is consistency for the connection parameters offered by the Teradata SQL Driver Dialect for SQLAlchemy and the Teradata JDBC Driver, with respect to connection parameter names and functionality. For comparison, Teradata JDBC Driver connection parameters are [documented here](http://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_2.html#BGBHDDGB).\n\nParameter | Default | Type | Description\n------------------ | --------- | ------- | ---\n`account` | | string | Specifies the Teradata Database account. Equivalent to the Teradata JDBC Driver `ACCOUNT` connection parameter.\n`column_name` | `false` | boolean | Controls the behavior of cursor `.description` sequence `name` items. Equivalent to the Teradata JDBC Driver `COLUMN_NAME` connection parameter. False specifies that a cursor `.description` sequence `name` item provides the AS-clause name if available, or the column name if available, or the column title. True specifies that a cursor `.description` sequence `name` item provides the column name if available, but has no effect when StatementInfo parcel support is unavailable.\n`dbs_port` | `1025` | integer | Specifies Teradata Database port number. Equivalent to the Teradata JDBC Driver `DBS_PORT` connection parameter.\n`encryptdata` | `false` | boolean | Controls encryption of data exchanged between the Teradata Database and the Teradata SQL Driver for Python. Equivalent to the Teradata JDBC Driver `ENCRYPTDATA` connection parameter.\n`lob_support` | `true` | boolean | Controls LOB support. Equivalent to the Teradata JDBC Driver `LOB_SUPPORT` connection parameter.\n`log` | `0` | integer | Controls debug logging. Somewhat equivalent to the Teradata JDBC Driver `LOG` connection parameter. This parameter's behavior is subject to change in the future. This parameter's value is currently defined as an integer in which the 1-bit governs function and method tracing, the 2-bit governs debug logging, and the 4-bit governs transmit and receive message hex dumps.\n`logdata` | | string | Specifies extra data for the chosen logon authentication method. Equivalent to the Teradata JDBC Driver `LOGDATA` connection parameter.\n`logmech` | `TD2` | string | Specifies the logon authentication method. Equivalent to the Teradata JDBC Driver `LOGMECH` connection parameter. Possible values are `TD2` (the default), `LDAP`, `KRB5` for Kerberos, or `TDNEGO`. Note that JWT authentication is not supported yet.\n`max_message_body` | `2097000` | integer | Not fully implemented yet and intended for future usage. Equivalent to the Teradata JDBC Driver `MAX_MESSAGE_BODY` connection parameter.\n`partition` | `DBC/SQL` | string | Specifies the Teradata Database Partition. Equivalent to the Teradata JDBC Driver `PARTITION` connection parameter.\n`password` | | string | Specifies the Teradata Database password. Equivalent to the Teradata JDBC Driver `PASSWORD` connection parameter.\n`sip_support` | `true` | boolean | Controls whether StatementInfo parcel is used. Equivalent to the Teradata JDBC Driver `SIP_SUPPORT` connection parameter.\n`teradata_values` | `true` | boolean | Controls whether `str` or a more specific Python data type is used for certain result set column value types.\n`tmode` | `DEFAULT` | string | Specifies the transaction mode. Equivalent to the Teradata JDBC Driver `TMODE` connection parameter. Possible values are `DEFAULT` (the default), `ANSI`, or `TERA`.\n`user` | | string | Specifies the Teradata Database username. Equivalent to the Teradata JDBC Driver `USER` connection parameter.\n\n\n", "description_content_type": "text/markdown", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "http://www.teradata.com/", "keywords": "Teradata", "license": "Teradata License Agreement", "maintainer": "", "maintainer_email": "", "name": "teradatasqlalchemy", "package_url": "https://pypi.org/project/teradatasqlalchemy/", "platform": "Windows", "project_url": "https://pypi.org/project/teradatasqlalchemy/", "project_urls": { "Homepage": "http://www.teradata.com/" }, "release_url": "https://pypi.org/project/teradatasqlalchemy/16.20.0.7/", "requires_dist": [ "sqlalchemy (>=1.2.11)", "teradatasql" ], "requires_python": ">=3.4", "summary": "Teradata SQL Driver Dialect for SQLAlchemy", "version": "16.20.0.7" }, "last_serial": 5223486, "releases": { "16.20.0.1": [ { "comment_text": "", "digests": { "md5": "61fdc65fa82db2adecdb2cdd1610766c", "sha256": "5a3618420bbcdb44a0594e632355ea0d4d0c5498c114dd8afdcbe8dd9c0a937a" }, "downloads": -1, "filename": "teradatasqlalchemy-16.20.0.1-py3-none-any.whl", "has_sig": false, "md5_digest": "61fdc65fa82db2adecdb2cdd1610766c", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.4", "size": 27109, "upload_time": "2018-09-14T21:06:53", "url": "https://files.pythonhosted.org/packages/bd/b3/a210063cbb8b1d038f5ce4b02e23cc4bcac7251a593fd7a63980f90c4a45/teradatasqlalchemy-16.20.0.1-py3-none-any.whl" } ], "16.20.0.2": [ { "comment_text": "", "digests": { "md5": "11d01f8be316c74bb1c817ed9195a1b2", "sha256": "b94d2ae9896e855f70fe0518ca097badc36fb494a749f36887cd9d17bfa1e166" }, "downloads": -1, "filename": "teradatasqlalchemy-16.20.0.2-py3-none-any.whl", "has_sig": false, "md5_digest": "11d01f8be316c74bb1c817ed9195a1b2", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.4", "size": 36589, "upload_time": "2018-09-20T22:20:41", "url": "https://files.pythonhosted.org/packages/cb/d0/28933640d49d451917812da172108f246952d6b2db4ae7d2a20c5f06bdf0/teradatasqlalchemy-16.20.0.2-py3-none-any.whl" } ], "16.20.0.3": [ { "comment_text": "", "digests": { "md5": "95060d15fd669b1b0eee8cdfbb1c963d", "sha256": "908f8615e716067f3501bc84a87343ef5171ddc469ffbb200854db6c6add5bce" }, "downloads": -1, "filename": "teradatasqlalchemy-16.20.0.3-py3-none-any.whl", "has_sig": false, "md5_digest": "95060d15fd669b1b0eee8cdfbb1c963d", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.4", "size": 36437, "upload_time": "2018-09-24T16:03:01", "url": "https://files.pythonhosted.org/packages/a9/c0/1475f1597b5ff46f0a3b5d0bcfc29325d7661215f60130c3e56d9f372a43/teradatasqlalchemy-16.20.0.3-py3-none-any.whl" } ], "16.20.0.4": [ { "comment_text": "", "digests": { "md5": "68f168f13e56e20ad89173ffaf95a5c3", "sha256": "92a6b7ee1432f32653b978400b43687e08f3e737d9893d6377cd4adfe5940752" }, "downloads": -1, "filename": "teradatasqlalchemy-16.20.0.4-py3-none-any.whl", "has_sig": false, "md5_digest": "68f168f13e56e20ad89173ffaf95a5c3", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.4", "size": 36506, "upload_time": "2018-09-28T22:20:47", "url": "https://files.pythonhosted.org/packages/62/4d/97b3b81f50d26787be7c59248ffabb30719396e56ea5b7079e34a5558036/teradatasqlalchemy-16.20.0.4-py3-none-any.whl" } ], "16.20.0.5": [ { "comment_text": "", "digests": { "md5": "a8cf94cf5eeb6579919558b4cc7daa62", "sha256": "4563b98d1ef99f3de7a1d4e9cdf7ec2fdc3779a8392792fafe00f45cd737c945" }, "downloads": -1, "filename": "teradatasqlalchemy-16.20.0.5-py3-none-any.whl", "has_sig": false, "md5_digest": "a8cf94cf5eeb6579919558b4cc7daa62", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.4", "size": 41749, "upload_time": "2018-11-05T23:53:25", "url": "https://files.pythonhosted.org/packages/16/c3/0cc59b6f8a1791b168087769c3bdeca2476f71bc31d76e10a1de4cc3d9ad/teradatasqlalchemy-16.20.0.5-py3-none-any.whl" } ], "16.20.0.6": [ { "comment_text": "", "digests": { "md5": "3fcdada0c3a5b5f7f915d5d982d1d2ae", "sha256": "12e915c83eafb915b785aebf13f38178745636ebf2f2f7570e8e54cf0a0fb8a6" }, "downloads": -1, "filename": "teradatasqlalchemy-16.20.0.6-py3-none-any.whl", "has_sig": false, "md5_digest": "3fcdada0c3a5b5f7f915d5d982d1d2ae", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.4", "size": 44300, "upload_time": "2019-04-25T16:36:40", "url": "https://files.pythonhosted.org/packages/80/27/d8da14af90e8d02ad8efdd659b08a32d1be452401042f7c535fdf8ab1834/teradatasqlalchemy-16.20.0.6-py3-none-any.whl" } ], "16.20.0.7": [ { "comment_text": "", "digests": { "md5": "a94207caf7d7c417876a4b8a2a600788", "sha256": "2752e305536898ef748c1f11b7c00b69ccc97d030d9461ec85bd71b752b75f39" }, "downloads": -1, "filename": "teradatasqlalchemy-16.20.0.7-py3-none-any.whl", "has_sig": false, "md5_digest": "a94207caf7d7c417876a4b8a2a600788", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.4", "size": 44424, "upload_time": "2019-05-03T19:55:04", "url": "https://files.pythonhosted.org/packages/f2/c4/2f8e71eb629a170250d0c1839e037681bfd3da5a9257c74e98d16f8017e8/teradatasqlalchemy-16.20.0.7-py3-none-any.whl" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "a94207caf7d7c417876a4b8a2a600788", "sha256": "2752e305536898ef748c1f11b7c00b69ccc97d030d9461ec85bd71b752b75f39" }, "downloads": -1, "filename": "teradatasqlalchemy-16.20.0.7-py3-none-any.whl", "has_sig": false, "md5_digest": "a94207caf7d7c417876a4b8a2a600788", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.4", "size": 44424, "upload_time": "2019-05-03T19:55:04", "url": "https://files.pythonhosted.org/packages/f2/c4/2f8e71eb629a170250d0c1839e037681bfd3da5a9257c74e98d16f8017e8/teradatasqlalchemy-16.20.0.7-py3-none-any.whl" } ] }