{
    "info": {
        "author": "Kees Hink",
        "author_email": "hink@gw20e.com",
        "bugtrack_url": null,
        "classifiers": [
            "Framework :: Plone",
            "Programming Language :: Python"
        ],
        "description": "Introduction\n============\n\nThe goal for this package is:\n\n- to make SQL storage from PloneFormGen easy\n- to be usable with collective.megaphone\n\nTo achieve this, we create a new PloneFormGen action-adapter_. \nThis uses SQLAlchemy_ (collective.lead_) to save the form data to the database.\n(SQLAlchemy should work on most SQL dialects.)\n\nYou could also save PFG data in SQL by using a Z SQL Method as an\nafter-validation script, as described in the SQL-CRUD-tutorial_.  \nThis works, but: \n\n- it's a lot of manual work, and quite cumbersome for ordinary users\n- it doesn't work with collective.megaphone_ (see mailinglist-discussion_)\n\n\nInstalling\n==========\n\nDevelopers\n----------\n\nTo install a complete development setup::\n\n    svn co https://svn.plone.org/svn/collective/Products.PloneFormGen/adapters/Products.sqlpfgadapter/buildout/plone4 sqlpfg-plone4\n    cd sqlpfg-plone4\n    python2.6 bootstrap.py\n    ./bin/buildout -c buildout-dvl.cfg\n\nOr, for Plone 3::\n\n    svn co https://svn.plone.org/svn/collective/Products.PloneFormGen/adapters/Products.sqlpfgadapter/buildout/plone3 sqlpfg-plone3\n    cd sqlpfg-plone3\n    python2.4 bootstrap.py\n    ./bin/buildout -c buildout-dvl.cfg\n\nIf you use another buildout configuration, be sure to include the \"Known good\nset\" for plone.app.registry for your version of Plone. In the case of Plone 3,\nyou'll also want to pin `z3c.form` to `1.9.0`.\n\n\nConfiguration\n=============\n\nAs a site admin, go to the \"SQL Settings\" in Plone's control panel. You'll be\ntaken to \"@@sqlpfg-controlpanel\". Here you can set your database connection\nsettings.\n\n\nUsage\n=====\n\nTo save a form's data in the database, add an \"SQL Storage\" from the \"Add\nnew...\" menu in the Form Folder. Give it a title and save it.\n\n    A database table will be created. Its name is generated (from the Form\n    Folder's id, among others), you can see it by viewing the adapter object.\n    The table has an 'id' column, and a column for each form field.\n\nThat's it! From now on, succesfully submitted forms will be stored in the\ndatabase.\n\nUsage with collective.megaphone\n-------------------------------\n\nThe product will work just as well with collective.megaphone. However, to be\nable to add the action adapter to an Action Letter or Megaphone Action, you\nhave to add \"SQLPFGAdapter\" to the \"Allowed content types\" via the ZMI.\n\nThe product collective.megaphonesql_ can do this for you.\n\n\nLimitations\n===========\n\nThis product is under development. For now, we have major limitations:\n\n- Not all PloneFormGen fields work, notably:\n\n  - file field\n  - rating-scale field\n\n- Adding and removing fields, or changing their names, doesn't change the\n  database table. Field names for which there is no column will just be\n  discarded.\n\n\nCompatibility / Dependencies\n============================\n\nTested with: \n\n- Plone: 3.3.5, 4.0 \n- PloneFormGen: 1.6.0b4, 1.6.0b5\n- megaphone: 1.4.1, 2.0b1\n- collective.lead 1.0, SQLAlchemy 0.4.8\n- SQL: MySQL 5.1.41\n\nThis product uses plone.app.registry for its controlpanel. In order for it to\nwork, use its \"Known good set\" (see section \"Developers\" above).\n\n.. _PloneFormGen: http://plone.org/products/ploneformgen\n.. _collective.megaphone: http://plone.org/products/megaphone\n.. _SQL-CRUD-tutorial: http://plone.org/products/ploneformgen/documentation/tutorial/sql-crud \n.. _mailinglist-discussion: http://plone.293351.n2.nabble.com/plan-for-easy-MySQL-storage-for-collective-megaphone-td5481845.html#a5481845\n.. _action-adapter: http://plone.org/products/ploneformgen/documentation/reference/fields-and-objects/adapters\n.. _SQLAlchemy: http://www.sqlalchemy.org\n.. _collective.lead: http://pypi.python.org/pypi/collective.lead\n..  _collective.megaphonesql: http://svn.plone.org/svn/collective/collective.megaphonesql \n\nChangelog\n=========\n\n1.0.1 (2011-01-10)\n------------------\n\nRe-release as source dist.\n\n1.0.0 (2010-11-10)\n------------------\n\nPython 2.4 binary release.\n\n0.1b2 (2010-09-26)\n------------------\n\n- typo in sqlApadapter.py \n\n0.1b1 (2010-09-26)\n------------------\n\n- Updated doc (tested and works on Plone 4)\n- Add handling for decimal form field \n\n0.1a2 (2010-09-22)\n------------------\n\n- Renamed all \"MySQL\" to \"SQL\", including content types. No upgrade provided! \n- Added documentation about usage with collective.megaphone.\n\n0.1a1 (2010-09-20)\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/sqlpfgadapter",
        "keywords": "web plone sql",
        "license": "GPL",
        "maintainer": null,
        "maintainer_email": null,
        "name": "Products.sqlpfgadapter",
        "package_url": "https://pypi.org/project/Products.sqlpfgadapter/",
        "platform": "UNKNOWN",
        "project_url": "https://pypi.org/project/Products.sqlpfgadapter/",
        "project_urls": {
            "Download": "UNKNOWN",
            "Homepage": "http://plone.org/products/sqlpfgadapter"
        },
        "release_url": "https://pypi.org/project/Products.sqlpfgadapter/1.0.1/",
        "requires_dist": null,
        "requires_python": null,
        "summary": "A PloneFormGen Action Adapter for SQL storage",
        "version": "1.0.1"
    },
    "last_serial": 238711,
    "releases": {
        "0.1a1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "daae8fceffd159badccbae33bbbbf14c",
                    "sha256": "6282fbda94857f282c4dfb792eaa1b0e40b2ca54c45728bd4d93d5f1e14688ad"
                },
                "downloads": -1,
                "filename": "Products.sqlpfgadapter-0.1a1.tar.gz",
                "has_sig": false,
                "md5_digest": "daae8fceffd159badccbae33bbbbf14c",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 19547,
                "upload_time": "2010-09-20T09:10:18",
                "url": "https://files.pythonhosted.org/packages/fc/34/cdc2782f2d30ef41aef1deb09d9a8e670760aa01b3712874daf778fbb3bf/Products.sqlpfgadapter-0.1a1.tar.gz"
            }
        ],
        "0.1a2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "a5f42993ecc64c34ed8837bec1a18c62",
                    "sha256": "63f045a75e0fdfadc3d36945b92d82cff3e12c25e835b3400b0e62e25139ad04"
                },
                "downloads": -1,
                "filename": "Products.sqlpfgadapter-0.1a2.tar.gz",
                "has_sig": false,
                "md5_digest": "a5f42993ecc64c34ed8837bec1a18c62",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 19991,
                "upload_time": "2010-09-22T10:23:17",
                "url": "https://files.pythonhosted.org/packages/31/5b/31cff4cefc8aac6099b34eb040c69ca78e940f10bc84743dd5d0e20d5750/Products.sqlpfgadapter-0.1a2.tar.gz"
            }
        ],
        "0.1b1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "06eb9a718bce5948f17105f3651126f7",
                    "sha256": "4ea3dfb7f80b5e86e7f18ca9b8c10ba1d923015f8307a683d6d4bc154b8ab911"
                },
                "downloads": -1,
                "filename": "Products.sqlpfgadapter-0.1b1.tar.gz",
                "has_sig": false,
                "md5_digest": "06eb9a718bce5948f17105f3651126f7",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 20113,
                "upload_time": "2010-09-26T02:35:25",
                "url": "https://files.pythonhosted.org/packages/1b/6e/6713612513965cb5b334a479d64735efbdf6dada18f240996a9e2a5e5d31/Products.sqlpfgadapter-0.1b1.tar.gz"
            }
        ],
        "0.1b2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "2a6d206f45ecfbcf458c32953a37ccb7",
                    "sha256": "6600160b7a132c4e706bdc6fd5076bac360b8a6832fedd3cd75bec3fe7953085"
                },
                "downloads": -1,
                "filename": "Products.sqlpfgadapter-0.1b2.tar.gz",
                "has_sig": false,
                "md5_digest": "2a6d206f45ecfbcf458c32953a37ccb7",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 20196,
                "upload_time": "2010-09-26T02:49:37",
                "url": "https://files.pythonhosted.org/packages/34/38/38d1a9606e548be7eec9bc25370137c5cc64ca1d6c102c97939f8339779a/Products.sqlpfgadapter-0.1b2.tar.gz"
            }
        ],
        "1.0.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "07d37090fe5e78f1191419ca28595cbc",
                    "sha256": "16b486e5d4b7bf4072ab3b8f82283c4102d7ffe753da17e84721e65461d86a36"
                },
                "downloads": -1,
                "filename": "Products.sqlpfgadapter-1.0.0-py2.4.egg",
                "has_sig": false,
                "md5_digest": "07d37090fe5e78f1191419ca28595cbc",
                "packagetype": "bdist_egg",
                "python_version": "2.4",
                "requires_python": null,
                "size": 25734,
                "upload_time": "2010-11-10T11:57:40",
                "url": "https://files.pythonhosted.org/packages/bb/36/417197fc86e0a460ce1795073b009bb9e2ee43542e61a8fed64d1265e813/Products.sqlpfgadapter-1.0.0-py2.4.egg"
            }
        ],
        "1.0.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "28e3b7c2854408ff4b3a57e1fcceb3e8",
                    "sha256": "ab642ec5ca0c36e5163751ec9a0b180dbd2a1f7f968f2475d49acac909e3c7b5"
                },
                "downloads": -1,
                "filename": "Products.sqlpfgadapter-1.0.1.tar.gz",
                "has_sig": false,
                "md5_digest": "28e3b7c2854408ff4b3a57e1fcceb3e8",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 20125,
                "upload_time": "2011-01-10T16:06:20",
                "url": "https://files.pythonhosted.org/packages/e0/59/c533052dd49648fc6bee8a2c8524160828bae7b10527668f0f418be01d01/Products.sqlpfgadapter-1.0.1.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "28e3b7c2854408ff4b3a57e1fcceb3e8",
                "sha256": "ab642ec5ca0c36e5163751ec9a0b180dbd2a1f7f968f2475d49acac909e3c7b5"
            },
            "downloads": -1,
            "filename": "Products.sqlpfgadapter-1.0.1.tar.gz",
            "has_sig": false,
            "md5_digest": "28e3b7c2854408ff4b3a57e1fcceb3e8",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 20125,
            "upload_time": "2011-01-10T16:06:20",
            "url": "https://files.pythonhosted.org/packages/e0/59/c533052dd49648fc6bee8a2c8524160828bae7b10527668f0f418be01d01/Products.sqlpfgadapter-1.0.1.tar.gz"
        }
    ]
}