{ "info": { "author": "MonetDB BV", "author_email": "info@monetdb.org", "bugtrack_url": null, "classifiers": [ "Development Status :: 5 - Production/Stable", "Intended Audience :: Developers", "License :: Other/Proprietary License", "Programming Language :: Python :: 2", "Topic :: Database", "Topic :: Database :: Database Engines/Servers" ], "description": ".. The contents of this file are subject to the MonetDB Public License\r\n.. Version 1.1 (the \"License\"); you may not use this file except in\r\n.. compliance with the License. You may obtain a copy of the License at\r\n.. http://www.monetdb.org/Legal/MonetDBLicense\r\n..\r\n.. Software distributed under the License is distributed on an \"AS IS\"\r\n.. basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the\r\n.. License for the specific language governing rights and limitations\r\n.. under the License.\r\n..\r\n.. The Original Code is the MonetDB Database System.\r\n..\r\n.. The Initial Developer of the Original Code is CWI.\r\n.. Portions created by CWI are Copyright (C) 1997-July 2008 CWI.\r\n.. Copyright August 2008-2014 MonetDB B.V.\r\n.. All Rights Reserved.\r\n\r\n.. This document is written in reStructuredText (see\r\n http://docutils.sourceforge.net/ for more information).\r\n Use ``rst2html.py`` to convert this file to HTML.\r\n\r\n==========================================\r\nThe MonetDB MAPI and SQL client python API\r\n==========================================\r\n\r\n\r\nIntroduction\r\n============\r\n\r\nThis is the new native python client API. This API is cross-platform,\r\nand doesn't depend on any monetdb libraries. It has support for\r\npython 2.5+ and is Python DBAPI 2.0 compatible.\r\n\r\nDEPRECATION WARNING\r\n===================\r\n\r\npython-monetdb is replaced by `pymonetdb `_. python-monetdb won't\r\nreceive any more updates. Please switch to pymonetdb, which should\r\nbe a drop-in replacement. Only change your import statement from\r\n``import monetdb`` to ``import pymonetdb``\r\n\r\n\r\nInstallation\r\n============\r\n\r\nTo install the MonetDB python API run the following command from the\r\npython source directory::\r\n\r\n # python setup.py install\r\n\r\nThat's all, now you are ready to start using the API.\r\n\r\n\r\nDocumentation\r\n=============\r\n\r\nThe python code is well documented, so if you need to find\r\ndocumentation you should have a look at the source code. Below is an\r\ninteractive example on how to use the monetdb SQL API which should get\r\nyou started quite fast.\r\n\r\n\r\nRunning the test suite\r\n======================\r\n\r\nInstall tox and run tox in the root.\r\n\r\nYou can control the testing behavior using environment variables::\r\n\r\n * MAPIPORT - what port is MonetDB running? _50000_ by default\r\n * TSTHOSTNAME - where is MonetDB running? _localhost_ by default\r\n * TSTPASSPHRASE - what passphrase to test control command? _testdb_ by default\r\n * TSTDB - what database to use for testing? _demo_ by default\r\n * TSTUSERNAME - username, _monetdb_ by default\r\n * TSTPASSWORD - password, _monetdb_ by default\r\n\r\nNote that you first need to create and start a monetdb database. Also if you\r\nwant to run the control tests you need to set a passphrase and set control=true.\r\n\r\n\r\nExamples\r\n========\r\n\r\nThere are some examples in the 'examples' folder, but here are is a\r\nline by line example of the SQL API::\r\n\r\n > # import the SQL module\r\n > import monetdb.sql\r\n > \r\n > # set up a connection. arguments below are the defaults\r\n > connection = monetdb.sql.connect(username=\"monetdb\", password=\"monetdb\", hostname=\"localhost\", database=\"demo\")\r\n > \r\n > # create a cursor\r\n > cursor = connection.cursor()\r\n > \r\n > # increase the rows fetched to increase performance (optional)\r\n > cursor.arraysize = 100\r\n >\r\n > # execute a query (return the number of rows to fetch)\r\n > cursor.execute('SELECT * FROM tables')\r\n 26\r\n >\r\n > # fetch only one row\r\n > cursor.fetchone()\r\n [1062, 'schemas', 1061, None, 0, True, 0, 0]\r\n >\r\n > # fetch the remaining rows\r\n > cursor.fetchall()\r\n [[1067, 'types', 1061, None, 0, True, 0, 0],\r\n [1076, 'functions', 1061, None, 0, True, 0, 0],\r\n [1085, 'args', 1061, None, 0, True, 0, 0],\r\n [1093, 'sequences', 1061, None, 0, True, 0, 0],\r\n [1103, 'dependencies', 1061, None, 0, True, 0, 0],\r\n [1107, 'connections', 1061, None, 0, True, 0, 0],\r\n [1116, '_tables', 1061, None, 0, True, 0, 0],\r\n ...\r\n [4141, 'user_role', 1061, None, 0, True, 0, 0],\r\n [4144, 'auths', 1061, None, 0, True, 0, 0],\r\n [4148, 'privileges', 1061, None, 0, True, 0, 0]]\r\n >\r\n > # Show the table meta data\r\n > cursor.description \r\n [('id', 'int', 4, 4, None, None, None),\r\n ('name', 'varchar', 12, 12, None, None, None),\r\n ('schema_id', 'int', 4, 4, None, None, None),\r\n ('query', 'varchar', 168, 168, None, None, None),\r\n ('type', 'smallint', 1, 1, None, None, None),\r\n ('system', 'boolean', 5, 5, None, None, None),\r\n ('commit_action', 'smallint', 1, 1, None, None, None),\r\n ('temporary', 'tinyint', 1, 1, None, None, None)]\r\n\r\n \r\nIf you would like to communicate with the database at a lower level\r\nyou can use the MAPI library::\r\n\r\n > from monetdb import mapi\r\n > server = mapi.Server()\r\n > server.connect(hostname=\"localhost\", port=50000, username=\"monetdb\", password=\"monetdb\", database=\"demo\", language=\"sql\")\r\n > server.cmd(\"sSELECT * FROM tables;\")\r\n ...", "description_content_type": null, "docs_url": null, "download_url": "http://dev.monetdb.org/downloads/sources/Oct2014/python2-monetdb-11.19.3.tar.gz", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "http://www.monetdb.org/", "keywords": "", "license": "UNKNOWN", "maintainer": "", "maintainer_email": "", "name": "python-monetdb", "package_url": "https://pypi.org/project/python-monetdb/", "platform": "UNKNOWN", "project_url": "https://pypi.org/project/python-monetdb/", "project_urls": { "Download": "http://dev.monetdb.org/downloads/sources/Oct2014/python2-monetdb-11.19.3.tar.gz", "Homepage": "http://www.monetdb.org/" }, "release_url": "https://pypi.org/project/python-monetdb/11.19.3.2/", "requires_dist": null, "requires_python": null, "summary": "Native MonetDB client Python API", "version": "11.19.3.2" }, "last_serial": 2166246, "releases": { "11.11.6": [ { "comment_text": "", "digests": { "md5": "1d2c98f204efdd56454f961b4fa9aac5", "sha256": "35b7838d3b3e7710e9910fda53b6f153e6015fc373a5ef633391adeecd688ad0" }, "downloads": -1, "filename": "python-monetdb-11.11.6.tar.gz", "has_sig": false, "md5_digest": "1d2c98f204efdd56454f961b4fa9aac5", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 16607, "upload_time": "2012-07-19T16:41:13", "url": "https://files.pythonhosted.org/packages/07/31/7252f473227c090c4e1c81e6a27c620e26a8cad0e7fcc42d51dbb454a217/python-monetdb-11.11.6.tar.gz" } ], "11.11.6.1": [ { "comment_text": "", "digests": { "md5": "b599aae49cc613c93a629e89aec4fed3", "sha256": "650abb22c9951bb0b7b948413bfeafa7e389bff9f8503529873d6346c13af976" }, "downloads": -1, "filename": "python-monetdb-11.11.6.1.tar.gz", "has_sig": false, "md5_digest": "b599aae49cc613c93a629e89aec4fed3", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5691, "upload_time": "2012-07-31T14:43:15", "url": "https://files.pythonhosted.org/packages/f5/da/4e512bf065908a87c4988dfd14583cbcc33c3bc9667bb14b7aacccd23573/python-monetdb-11.11.6.1.tar.gz" } ], "11.11.6.2": [ { "comment_text": "", "digests": { "md5": "d9b76ab829b30deea5b67ef3819aca1f", "sha256": "a14a2366be2504bb889381f38c105ae1f9fab23b598858769907030823126d4e" }, "downloads": -1, "filename": "python-monetdb-11.11.6.2.tar.gz", "has_sig": false, "md5_digest": "d9b76ab829b30deea5b67ef3819aca1f", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 14705, "upload_time": "2012-08-02T12:21:51", "url": "https://files.pythonhosted.org/packages/c6/dd/8f5c537778612a096150904d57559a35c1e7b4bd85495737ea53ba04a4e2/python-monetdb-11.11.6.2.tar.gz" } ], "11.13.0.1": [ { "comment_text": "", "digests": { "md5": "f6849208803af633b2aeb90273f6ff53", "sha256": "e0463559f23907132d78360d8a748e32140336944a83db07d9b3e4d534d85466" }, "downloads": -1, "filename": "python-monetdb-11.13.0.1.tar.gz", "has_sig": false, "md5_digest": "f6849208803af633b2aeb90273f6ff53", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 16856, "upload_time": "2012-09-13T12:02:51", "url": "https://files.pythonhosted.org/packages/d8/62/ce3882f0d95b289f9061104651d0873dbd682e2dbddd71262347c42cf6ef/python-monetdb-11.13.0.1.tar.gz" } ], "11.13.5.1": [ { "comment_text": "", "digests": { "md5": "d57ea420587c291f3b5749254e0f35bc", "sha256": "2964fd06f56858ab6ddb282395568978120f0dd071655bd0427414586727908c" }, "downloads": -1, "filename": "python-monetdb-11.13.5.1.tar.gz", "has_sig": false, "md5_digest": "d57ea420587c291f3b5749254e0f35bc", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 16747, "upload_time": "2012-12-11T11:31:06", "url": "https://files.pythonhosted.org/packages/1c/1a/a4d56490cf7d262ffd6ab9bd75a73b35f3139cb865d395015f6b5c58db26/python-monetdb-11.13.5.1.tar.gz" } ], "11.16.0.1": [ { "comment_text": "", "digests": { "md5": "4a2a832c30a45ea7e4f4ae95e7bf249f", "sha256": "595801c233ef143a78c5cd700b4566fc63d2ba1140e952677ed4aaecaef87069" }, "downloads": -1, "filename": "python-monetdb-11.16.0.1.tar.gz", "has_sig": false, "md5_digest": "4a2a832c30a45ea7e4f4ae95e7bf249f", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 16803, "upload_time": "2012-12-14T11:13:46", "url": "https://files.pythonhosted.org/packages/42/40/6bef29d1c40f4bbcaa0bc34b097e05b90044190e26aa780d020a480b27a6/python-monetdb-11.16.0.1.tar.gz" } ], "11.16.0.2": [ { "comment_text": "", "digests": { "md5": "0414002cf3732b3509b8ac5d9bb42456", "sha256": "59d26ca064c0f7929a55f147db27ac52bc209c75bdaed5fbd6c40c6c0c580527" }, "downloads": -1, "filename": "python-monetdb-11.16.0.2.tar.gz", "has_sig": false, "md5_digest": "0414002cf3732b3509b8ac5d9bb42456", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 16782, "upload_time": "2012-12-19T15:15:59", "url": "https://files.pythonhosted.org/packages/45/db/e56c4dc1e5bbdfcc76989d9168d9c79f28b96e97c5a1fbe9514d1f23521d/python-monetdb-11.16.0.2.tar.gz" } ], "11.16.0.3": [ { "comment_text": "", "digests": { "md5": "46f43413dc4818dce29867463ac9e20e", "sha256": "ad15c142bd11390d307fee83cbdde3a036fbefb24e91c2eba8094f201e945476" }, "downloads": -1, "filename": "python-monetdb-11.16.0.3.tar.gz", "has_sig": false, "md5_digest": "46f43413dc4818dce29867463ac9e20e", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 17177, "upload_time": "2013-03-08T16:21:56", "url": "https://files.pythonhosted.org/packages/b5/58/3f0423339ef9c6b135f2039f6b3ce826706cb8b3ab5e337a8b1147d33b6a/python-monetdb-11.16.0.3.tar.gz" } ], "11.16.0.4": [ { "comment_text": "", "digests": { "md5": "25f79157e96384a2ab4aeb2f8bbd99f2", "sha256": "4be3be2cdb8c080263e2bd91a7ff1eeade4ac66c17d49c547d8a8f56a4dc3181" }, "downloads": -1, "filename": "python-monetdb-11.16.0.4.tar.gz", "has_sig": false, "md5_digest": "25f79157e96384a2ab4aeb2f8bbd99f2", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 16941, "upload_time": "2013-03-11T17:46:04", "url": "https://files.pythonhosted.org/packages/80/75/cb7c276fd3b227cf5a98df188f2b0e01487598a5aa4eb868be1a9c0ab13e/python-monetdb-11.16.0.4.tar.gz" } ], "11.16.0.5": [ { "comment_text": "", "digests": { "md5": "a8aa71db66ec6b87d3e0564e0010d72d", "sha256": "b915cffad2769163ab72034931eab520d282baa1b95f4ba9ccc9c76dbfb02162" }, "downloads": -1, "filename": "python-monetdb-11.16.0.5.tar.gz", "has_sig": false, "md5_digest": "a8aa71db66ec6b87d3e0564e0010d72d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 16541, "upload_time": "2013-04-05T09:36:01", "url": "https://files.pythonhosted.org/packages/f0/a2/1f2f11c1e534c53d775fc46fa40686b3feb663147b5100e7e2d53db4bcfe/python-monetdb-11.16.0.5.tar.gz" } ], "11.16.0.6": [ { "comment_text": "", "digests": { "md5": "db6a4c648442933b2489220e0f5229b6", "sha256": "247c39c67e6f055d20e45c6b79cf2f2b4b259c99d6f48cdee4df8944f11d546e" }, "downloads": -1, "filename": "python-monetdb-11.16.0.6.tar.gz", "has_sig": false, "md5_digest": "db6a4c648442933b2489220e0f5229b6", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 17064, "upload_time": "2013-09-05T12:25:31", "url": "https://files.pythonhosted.org/packages/5b/de/9c138e3dc78132bc225ffa59adb3c3bb8fddaaad5d29753bae9e851ce877/python-monetdb-11.16.0.6.tar.gz" } ], "11.16.0.7": [ { "comment_text": "", "digests": { "md5": "c44dcdc120304584ee11c198377b84ee", "sha256": "3d1c1592f3525704dc344bddce698be245123873a3d12930db415bf8df1449b1" }, "downloads": -1, "filename": "python-monetdb-11.16.0.7.tar.gz", "has_sig": false, "md5_digest": "c44dcdc120304584ee11c198377b84ee", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 17134, "upload_time": "2013-09-06T07:56:18", "url": "https://files.pythonhosted.org/packages/d0/a8/9927033f1b1f7e9d13f3464e0ff570e4cd8d8514eefc645591db8f81339a/python-monetdb-11.16.0.7.tar.gz" } ], "11.19.3": [ { "comment_text": "", "digests": { "md5": "5f7e54b598de477bfb6748d984c33512", "sha256": "225ff976a4a58363faf349b4cf9ca353965defc152941f23235261cab28efce5" }, "downloads": -1, "filename": "python-monetdb-11.19.3.tar.gz", "has_sig": false, "md5_digest": "5f7e54b598de477bfb6748d984c33512", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 17324, "upload_time": "2014-11-14T13:54:07", "url": "https://files.pythonhosted.org/packages/b4/3b/0e9a14a540bcbb31541c64bef44b35694be15464b8678ca378c5b2e1eff1/python-monetdb-11.19.3.tar.gz" } ], "11.19.3.1": [ { "comment_text": "", "digests": { "md5": "3712ae485cc375de172d7c3e824096f6", "sha256": "faf96ef80e5df8a39b07087ef050435053b281eb4b7cfc8f2a3e821df0fd5132" }, "downloads": -1, "filename": "python-monetdb-11.19.3.1.tar.gz", "has_sig": false, "md5_digest": "3712ae485cc375de172d7c3e824096f6", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 34968, "upload_time": "2014-11-14T15:37:30", "url": "https://files.pythonhosted.org/packages/e8/d0/37ee0561814a282ec170c8e33168ddba7a8369d535affce4f97bb61f3651/python-monetdb-11.19.3.1.tar.gz" } ], "11.19.3.2": [ { "comment_text": "", "digests": { "md5": "9031fd2ea4b86a2bc2d5dd1ab4b10a77", "sha256": "fc976189c933a6a7740e7e0b48251488572e2d1e2011e7bdf8aa488ad03a5dc7" }, "downloads": -1, "filename": "python-monetdb-11.19.3.2.tar.gz", "has_sig": false, "md5_digest": "9031fd2ea4b86a2bc2d5dd1ab4b10a77", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 35205, "upload_time": "2015-01-07T15:27:21", "url": "https://files.pythonhosted.org/packages/60/98/ceb0a6eb00df4422b37ba7a2acb9e77b53a7aeaebbe3839f7005e5e0c3bb/python-monetdb-11.19.3.2.tar.gz" } ], "11.9.5": [ { "comment_text": "", "digests": { "md5": "2ea381d9de53b908195490a1fcb53add", "sha256": "50f40b0bc564b7419f2094bb4cfe0177379368fcb1238668d30091c07f8bf312" }, "downloads": -1, "filename": "python-monetdb-11.9.5.tar.gz", "has_sig": false, "md5_digest": "2ea381d9de53b908195490a1fcb53add", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 14488, "upload_time": "2012-06-13T12:03:06", "url": "https://files.pythonhosted.org/packages/36/f9/5f2ba032d474df079ddf3525357cffa21952c75dad1c9e87a6bdb54d8ad7/python-monetdb-11.9.5.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "9031fd2ea4b86a2bc2d5dd1ab4b10a77", "sha256": "fc976189c933a6a7740e7e0b48251488572e2d1e2011e7bdf8aa488ad03a5dc7" }, "downloads": -1, "filename": "python-monetdb-11.19.3.2.tar.gz", "has_sig": false, "md5_digest": "9031fd2ea4b86a2bc2d5dd1ab4b10a77", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 35205, "upload_time": "2015-01-07T15:27:21", "url": "https://files.pythonhosted.org/packages/60/98/ceb0a6eb00df4422b37ba7a2acb9e77b53a7aeaebbe3839f7005e5e0c3bb/python-monetdb-11.19.3.2.tar.gz" } ] }