redturtle.sqlcontents 0.9.1

RedTurtle - SQL Contents
redturtle.sqlcontents
  3 Screenshots
redturtle.sqlcontents is a Plone product developed to satisfy the demand to execute and present simple SQL queries on Plone using SQLAlchemy.

It introduces two archetypes to your Plone site:

- SQLFolder
- SQLQuery

With this contents you can display the data returned by the queries into Plone pages.

SQLFolder

The SQLFolder object is globally addable and can contain SQLQuery objects. The SQLFolder has a connection_url field where you can specify how to connect to an external DB through SQLAlchemy. Please take a look to the SQLAlchemy documentation).

Installation

Add redturtle.sqlcontents to the egg section of your instance:

[instance]
eggs=
 ...
 redturtle.sqlcontents
 ...


In order to make the connection to your database server of choice effective you may need to install (using systm tools or buildout) the proper libraries, e.g:

- MySQL-python
- cx_Oracle
- psycopg2
- python-sqlite

In older Plone (previous to version 3.3.2) you need to do the same with the zcml section.

Disclaimer

redturtle.sqlcontens is a dangerous package.

Read carefully the documentation before using it. Even if this package is developed to execute "SELECT" queries, it accepts any kind of query without validation. In the current development state you can even DROP stuff from your DB, and this is dangerous and evilish.

SECURITY HINT: it is better, when possible to access the external DB with a read only account. This can save the world!

Do not query large amount of data or blobs, redturtle.sqlcontents is not designed for that task!

Be aware that long queries or network problems can lock your instance threads!

last updated on:
August 11th, 2013, 3:46 GMT
price:
FREE!
homepage:
plone.org
license type:
GPL (GNU General Public License) 
developed by:
RedTurtle Technology
category:
ROOT \ Internet \ Plone Extensions
redturtle.sqlcontents
Download Button

In a hurry? Add it to your Download Basket!

user rating

UNRATED
0.0/5
 

0/5

Rate it!
3 Screenshots
redturtle.sqlcontentsredturtle.sqlcontents
What's New in This Release:
  • Fixed setup.py to correctly declare Products.DataGridField dependency (thanks to Olav Peeters for pointing it out) [ale-rt]
read full changelog

Add your review!

SUBMIT