{ "info": { "author": "RedTurtle Technology", "author_email": "sviluppoplone@redturtle.it", "bugtrack_url": null, "classifiers": [ "Development Status :: 4 - Beta", "Framework :: Plone", "Framework :: Plone :: 3.2", "Framework :: Plone :: 3.3", "Framework :: Plone :: 4.0", "Framework :: Plone :: 4.1", "Framework :: Plone :: 4.2", "Framework :: Plone :: 4.3", "Intended Audience :: Developers", "License :: OSI Approved :: GNU General Public License (GPL)", "Programming Language :: Python :: 2.4", "Programming Language :: Python :: 2.5", "Programming Language :: Python :: 2.6", "Programming Language :: Python :: 2.7", "Topic :: Database :: Front-Ends" ], "description": ".. contents::\n\n============\nDisclaimer\n============\n**redturtle.sqlcontens** is a **dangerous** package. \n\nRead carefully the documentation before using it. \nEven if this package is developed to execute \"SELECT\" queries, it accepts any \nkind of query without validation. In the current development state you can **even DROP** stuff from your DB, \nand this is **dangerous** and **evilish**.\n\n**SECURITY HINT**: it is better, when possible to access the external DB with a\nread only account. This can **save the world**! \n\n**Do not query large amount of data or blobs**, \nredturtle.sqlcontents is not designed for that task!\n\nBe aware that long queries or network problems can **lock your instance threads**!\n\n============\nIntroduction\n============\n\nThis package is developed to satisfy the demand to execute and present simple SQL \nqueries on Plone using SQLAlchemy.\n\nIt introduces two archetypes to your Plone site:\n\n- `SQLFolder`_\n- `SQLQuery`_\n\nWith this contents you can display the data returned by the queries into Plone pages.\n\n===========\nDescription\n===========\n\nSQLFolder\n=========\n\nThe SQLFolder object is globally addable and can contain SQLQuery objects.\nThe SQLFolder has a **connection_url** field where you can specify how to connect \nto an external DB through SQLAlchemy.\nPlease take a look to `the SQLAlchemy documentation\n`_).\n\n.. image:: http://blog.redturtle.it/pypi-images/redturtle.sqlcontents/sqlfolder_edit.png/image_preview\n\nSQLQuery\n========\n\nInside a SQLFolder you can create SQLQueries, document like objects that \ncontain a field **query**.\nInside this field you can specify any kind of query to your database, **without\nconstraints**, even if it supposed to be a SELECT.\n\n.. image:: http://blog.redturtle.it/pypi-images/redturtle.sqlcontents/sqlquery_edit.png/image_preview\n\nThe default view for the SQLQuery objects takes the results from your query and\npresents them in a paginated table.\nThe header of the tables is composed, by default, by the column names, but you \ncan define a replacement mapping filling properly the field **column_names**.\n\n.. image:: http://blog.redturtle.it/pypi-images/redturtle.sqlcontents/sqlquery_view.png/image_preview\n\n============\nInstallation\n============\n \nAdd redturtle.sqlcontents to the egg section of your instance::\n \n [instance]\n eggs=\n ...\n redturtle.sqlcontents\n ...\n\nIn order to make the connection to your database server of choice effective \nyou may need to install (using systm tools or buildout) the proper libraries, \ne.g:\n\n- MySQL-python\n- cx_Oracle\n- psycopg2\n- python-sqlite\n\nIn older Plone (previous to version 3.3.2) you need to do the same with the \nzcml section.\n\n=====\nNotes\n=====\n**redturtle.sqlcontents** has been tested with Plone 3.3.4 and Plone 4.2. \nI assume the compatibility with the intermediate releases.\n\n**redturtle.sqlcontents** depends on:\n\n- `SQLAlchemy `_\n- `Products.DataGridField `_\n\nThose packages are automatically included by **redturtle.sqlcontents** inside\nyour buildout, so you do not have to take care about them.\n\nIn **Plone 3** installations you may want to pin the Products.DataGridField to \na version lower than 1.7 (1.6.2 is the proper one at the time of writing).\n\nCredits\n=======\n\nDeveloped with the support of `ARPA Veneto`__; ARPA Veneto supports the\n`PloneGov initiative`__.\n\n__ http://www.arpa.veneto.it/\n__ http://www.plonegov.it/\n\nAuthors\n=======\n\nThis product was developed by RedTurtle Technology team.\n\n.. image:: http://www.redturtle.it/redturtle_banner.png\n :alt: RedTurtle Technology Site\n :target: http://www.redturtle.it/\n\nTODO?\n=====\n- Validate the queries through registrable adapters;\n- Present the data through adapters to handle blob, dates and so on;\n- Add more connection parameters to the SQLFolder object;\n- Optimize DB connections;\n- Add some cache here and there;\n- More aggressive caching;\n- Caching;\n\n\nChangelog\n=========\n\n0.9.1 (2013-07-29)\n------------------\n\n- Fixed setup.py to correctly declare Products.DataGridField dependency\n (thanks to Olav Peeters for pointing it out)\n [ale-rt]\n\n\n0.9.0 (2012/08/31)\n------------------\n\n- Initial release", "description_content_type": null, "docs_url": null, "download_url": "UNKNOWN", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "http://plone.org/products/redturtle.sqlcontents/", "keywords": "Plone", "license": "GPL", "maintainer": null, "maintainer_email": null, "name": "redturtle.sqlcontents", "package_url": "https://pypi.org/project/redturtle.sqlcontents/", "platform": "UNKNOWN", "project_url": "https://pypi.org/project/redturtle.sqlcontents/", "project_urls": { "Download": "UNKNOWN", "Homepage": "http://plone.org/products/redturtle.sqlcontents/" }, "release_url": "https://pypi.org/project/redturtle.sqlcontents/0.9.1/", "requires_dist": null, "requires_python": null, "summary": "RedTurtle - SQL Contents", "version": "0.9.1" }, "last_serial": 827127, "releases": { "0.9.0": [ { "comment_text": "", "digests": { "md5": "8248765912fd392c06dac881eee36fae", "sha256": "1b3a0afd1610d9728aecc6659cdd311fdb0766f39a247806e5176827c496150e" }, "downloads": -1, "filename": "redturtle.sqlcontents-0.9.0.tar.gz", "has_sig": false, "md5_digest": "8248765912fd392c06dac881eee36fae", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 37608, "upload_time": "2012-08-31T14:14:02", "url": "https://files.pythonhosted.org/packages/bb/b7/e93bbc9db0988393518f746f02ce1b27247886c5180136e7e487d9f0ef84/redturtle.sqlcontents-0.9.0.tar.gz" } ], "0.9.1": [ { "comment_text": "", "digests": { "md5": "46517665c81651fc0d66628eb70f4b0b", "sha256": "7a151ccd9f550a484a75953711ea7df3c81bf94327ddb219e1d8f5ebdefca143" }, "downloads": -1, "filename": "redturtle.sqlcontents-0.9.1.zip", "has_sig": false, "md5_digest": "46517665c81651fc0d66628eb70f4b0b", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 52799, "upload_time": "2013-07-29T10:10:24", "url": "https://files.pythonhosted.org/packages/99/3b/1785fcefeb6874ee397d008b7e5c014c57ba9578dc208e08e11d61c88dc2/redturtle.sqlcontents-0.9.1.zip" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "46517665c81651fc0d66628eb70f4b0b", "sha256": "7a151ccd9f550a484a75953711ea7df3c81bf94327ddb219e1d8f5ebdefca143" }, "downloads": -1, "filename": "redturtle.sqlcontents-0.9.1.zip", "has_sig": false, "md5_digest": "46517665c81651fc0d66628eb70f4b0b", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 52799, "upload_time": "2013-07-29T10:10:24", "url": "https://files.pythonhosted.org/packages/99/3b/1785fcefeb6874ee397d008b7e5c014c57ba9578dc208e08e11d61c88dc2/redturtle.sqlcontents-0.9.1.zip" } ] }