{ "info": { "author": "Graeme Perrow", "author_email": "graeme.perrow@sap.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 5 - Production/Stable", "Intended Audience :: Developers", "License :: OSI Approved :: Apache Software License", "Natural Language :: English", "Operating System :: OS Independent", "Programming Language :: Python :: 2", "Programming Language :: Python :: 2.4", "Programming Language :: Python :: 2.5", "Programming Language :: Python :: 2.6", "Programming Language :: Python :: 2.7", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.0", "Programming Language :: Python :: 3.1", "Programming Language :: Python :: 3.2", "Programming Language :: Python :: 3.3", "Programming Language :: Python :: 3.4", "Topic :: Database", "Topic :: Software Development :: Libraries :: Python Modules" ], "description": ".. ***************************************************************************\n.. Copyright (c) 2018 SAP SE or an SAP affiliate company. All rights reserved.\n.. ***************************************************************************\n\nsqlanydb\n========\n\nThis package provides a python interface to the SQL Anywhere database\nserver. This interface conforms to PEP 249.\n\nRequirements\n------------\nBefore installing the sqlanydb interface please make sure the\nfollowing components are installed on your system.\n\n* Python 2.4 or greater (including Python 3.x)\n* Python ctypes module if missing\n* SQL Anywhere 10 or higher\n\nInstalling the sqlanydb module\n------------------------------\nRun the following command as an administrative user to install\nsqlanydb::\n\n python setup.py install\n\nAlternatively, you can use pip::\n\n pip install sqlanydb\n\nConverter Functions\n-------------------\nThis library wraps around the sqlanydb ``dbcapi`` C library. When retrieving \nvalues from the database, the C API returns one of these types:\n\n* A_INVALID_TYPE\n* A_BINARY \n* A_STRING \n* A_DOUBLE \n* A_VAL64 \n* A_UVAL64 \n* A_VAL32 \n* A_UVAL32 \n* A_VAL16 \n* A_UVAL16 \n* A_VAL8 \n* A_UVAL8 \n\nOther types are returned as the above types. For example, the NUMERIC type is \nreturned as a string. \n\nTo have ``sqlanydb`` return a different or custom python object, you can register \ncallbacks with the ``sqlanydb`` module, using \n``register_converter(datatype, callback)``. Callback is a function that takes\none argument, the type to be converted, and should return the converted value.\nDatatype is one of the ``DT_`` variables present in the module.\n\nThe types available to register a converter for:\n\n* DT_NOTYPE \n* DT_DATE \n* DT_TIME \n* DT_TIMESTAMP \n* DT_VARCHAR \n* DT_FIXCHAR \n* DT_LONGVARCHAR \n* DT_STRING \n* DT_DOUBLE \n* DT_FLOAT \n* DT_DECIMAL \n* DT_INT \n* DT_SMALLINT \n* DT_BINARY \n* DT_LONGBINARY \n* DT_TINYINT \n* DT_BIGINT \n* DT_UNSINT \n* DT_UNSSMALLINT \n* DT_UNSBIGINT \n* DT_BIT \n* DT_LONGNVARCHAR \n\nFor example, to have NUMERIC types be returned as a python Decimal object::\n\n\n import decimal\n\n def decimal_callback(valueToConvert):\n return decimal.Decimal(valueToConvert)\n\n sqlanydb.register_converter(sqlanydb.DT_DECIMAL, decimal_callback)\n\n\nTesting the sqlanydb module\n---------------------------\nTo test that the Python interface to SQL Anywhere is working correctly\nfirst start the demo database included with your SQL Anywhere\ninstallation and then create a file named test_sqlany.py with the\nfollowing contents::\n\n import sqlanydb\n conn = sqlanydb.connect(uid='dba', pwd='sql', eng='demo', dbn='demo' )\n curs = conn.cursor()\n curs.execute(\"select 'Hello, world!'\")\n print( \"SQL Anywhere says: %s\" % curs.fetchone() )\n curs.close()\n conn.close()\n\nRun the test script and ensure that you get the expected output::\n\n > python test_sqlany.py\n SQL Anywhere says: Hello, world!\n\nLicense\n-------\nThis package is licensed under the terms of the Apache License, Version 2.0. See\nthe LICENSE file for details.\n\nFeedback and Questions\n----------------------\nFor feedback on this project, or for general questions about using SQL Anywhere\nplease use the SQL Anywhere Forum at http://sqlanywhere-forum.sap.com/", "description_content_type": "", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/sqlanywhere/sqlanydb", "keywords": "", "license": "Apache 2.0", "maintainer": "", "maintainer_email": "", "name": "sqlanydb", "package_url": "https://pypi.org/project/sqlanydb/", "platform": "", "project_url": "https://pypi.org/project/sqlanydb/", "project_urls": { "Homepage": "https://github.com/sqlanywhere/sqlanydb" }, "release_url": "https://pypi.org/project/sqlanydb/1.0.10/", "requires_dist": null, "requires_python": "", "summary": "pure Python SQL Anywhere database interface", "version": "1.0.10" }, "last_serial": 3933451, "releases": { "1.0.10": [ { "comment_text": "", "digests": { "md5": "98b3b2111fcd4216bc244d97efe3fd49", "sha256": "09d58f5c6a87a10a8af4b760330b3e297764eab483f7ea7c1b0bb89f91beb7b7" }, "downloads": -1, "filename": "sqlanydb-1.0.10.tar.gz", "has_sig": false, "md5_digest": "98b3b2111fcd4216bc244d97efe3fd49", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 19411, "upload_time": "2018-06-05T19:06:09", "url": "https://files.pythonhosted.org/packages/8e/2a/aa7713ae73dbe3397b43d7406f0820f042b7f9daba04c7ba8659e2ecad4c/sqlanydb-1.0.10.tar.gz" } ], "1.0.5": [ { "comment_text": "", "digests": { "md5": "d3d926f68106c15c5d7a783a14dc60f4", "sha256": "663814c7131a3865d78049891620407548a4570b8e924543e4e05ca34944b99a" }, "downloads": -1, "filename": "sqlanydb-1.0.5-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "d3d926f68106c15c5d7a783a14dc60f4", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 9941, "upload_time": "2013-11-26T14:29:56", "url": "https://files.pythonhosted.org/packages/61/0b/362b7fb208e5afe443acddfa9f4ddea54f35e04f4a5e8d4a2a2afb7178ac/sqlanydb-1.0.5-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "fca03434850acfdf692cd604d31a8def", "sha256": "2f1996cb2fdd84a08dcb3d74901912da94a180e31f8ce18b89e6d35729ac264d" }, "downloads": -1, "filename": "sqlanydb-1.0.5.tar.gz", "has_sig": false, "md5_digest": "fca03434850acfdf692cd604d31a8def", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 17045, "upload_time": "2013-11-26T14:29:16", "url": "https://files.pythonhosted.org/packages/7b/6e/626074dfb0375c8d813be774477e0e63d829d0689982f74e5e01b6374719/sqlanydb-1.0.5.tar.gz" } ], "1.0.6": [ { "comment_text": "", "digests": { "md5": "c8da935a91127598daa8ec848d5f3bde", "sha256": "0707f10e8abcc23224a619aa43e5211b8f73eded0ab41da0c3c6d963deebf009" }, "downloads": -1, "filename": "sqlanydb-1.0.6-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "c8da935a91127598daa8ec848d5f3bde", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 9988, "upload_time": "2014-06-26T19:07:59", "url": "https://files.pythonhosted.org/packages/46/18/786def35cb940c8a14cfb85ffb6202a367e47f4c3981eb007cd689227fa9/sqlanydb-1.0.6-py2.py3-none-any.whl" } ], "1.0.6.1": [ { "comment_text": "", "digests": { "md5": "54d9f560d8f04382b7d2d1ede5287af8", "sha256": "74703a7e495998b45566823ff5fa73509c75463b1d966456592bffca74b508ed" }, "downloads": -1, "filename": "sqlanydb-1.0.6.1-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "54d9f560d8f04382b7d2d1ede5287af8", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 11768, "upload_time": "2015-09-09T18:40:14", "url": "https://files.pythonhosted.org/packages/1b/a2/30d4de1e843aa006ac12c53500f031fc308e1265621c6515163d3c453f89/sqlanydb-1.0.6.1-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "ee31446d246562d7cf6b8bb397994c7c", "sha256": "cf28a9a5da560af8ef03b15095acc2f78a7bd94c8be3287a333fae1d02a21406" }, "downloads": -1, "filename": "sqlanydb-1.0.6.1.tar.gz", "has_sig": false, "md5_digest": "ee31446d246562d7cf6b8bb397994c7c", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 18551, "upload_time": "2015-09-09T18:40:05", "url": "https://files.pythonhosted.org/packages/aa/88/147e7f60e95c48fd6fe59abd34072bb69818f658e6ec9c634e8b013efcbc/sqlanydb-1.0.6.1.tar.gz" } ], "1.0.7": [ { "comment_text": "", "digests": { "md5": "422c2b7562a4dc546d3bc3fc16ee4add", "sha256": "a8eb3dc1077e8e3c69ca768e8f459d7d2d60dc17e2a227ce27e4fd39a3489b8e" }, "downloads": -1, "filename": "sqlanydb-1.0.7.tar.gz", "has_sig": false, "md5_digest": "422c2b7562a4dc546d3bc3fc16ee4add", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 18710, "upload_time": "2016-02-01T20:47:56", "url": "https://files.pythonhosted.org/packages/41/88/c6ff8da56c9fc6d4e977e36b3c4c6d3408936149090aa1c9daa53c822133/sqlanydb-1.0.7.tar.gz" } ], "1.0.8": [ { "comment_text": "", "digests": { "md5": "d310ab347fee983bd5f66dfcde8fe0ca", "sha256": "e0752315db1e563e82bd52679b257459a8921e54625705e0e9a78b1a390fecaf" }, "downloads": -1, "filename": "sqlanydb-1.0.8.tar.gz", "has_sig": false, "md5_digest": "d310ab347fee983bd5f66dfcde8fe0ca", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 18843, "upload_time": "2016-04-26T18:22:21", "url": "https://files.pythonhosted.org/packages/45/62/e0c80101e551fb16ca919cc80b1938ff225e0f20c3afdabf35d6ca79e52f/sqlanydb-1.0.8.tar.gz" } ], "1.0.9": [ { "comment_text": "", "digests": { "md5": "69d6d6818489bf824a6000ea01541b2d", "sha256": "e8fe3dfee566188b0cc96c923cf95b303983a2587d6396d79d955420ef8f5bd9" }, "downloads": -1, "filename": "sqlanydb-1.0.9.tar.gz", "has_sig": false, "md5_digest": "69d6d6818489bf824a6000ea01541b2d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 18825, "upload_time": "2017-10-27T12:51:46", "url": "https://files.pythonhosted.org/packages/84/ff/24f5f7224601e78d23ba6e3a8cb7dc9ca26be1b8300b67d878e2ca2c2350/sqlanydb-1.0.9.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "98b3b2111fcd4216bc244d97efe3fd49", "sha256": "09d58f5c6a87a10a8af4b760330b3e297764eab483f7ea7c1b0bb89f91beb7b7" }, "downloads": -1, "filename": "sqlanydb-1.0.10.tar.gz", "has_sig": false, "md5_digest": "98b3b2111fcd4216bc244d97efe3fd49", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 19411, "upload_time": "2018-06-05T19:06:09", "url": "https://files.pythonhosted.org/packages/8e/2a/aa7713ae73dbe3397b43d7406f0820f042b7f9daba04c7ba8659e2ecad4c/sqlanydb-1.0.10.tar.gz" } ] }