{
    "info": {
        "author": "Jan Ripke",
        "author_email": "jan.ripke@oxyma.nl",
        "bugtrack_url": null,
        "classifiers": [
            "Development Status :: 5 - Production/Stable",
            "Intended Audience :: Developers",
            "License :: OSI Approved :: GNU General Public License v3 or later (GPLv3+)",
            "Programming Language :: Python :: 2",
            "Programming Language :: Python :: 2.7",
            "Topic :: Database :: Front-Ends"
        ],
        "description": "# ![noora logo](https://a.fsdn.com/allura/p/noora/icon)\n\n\n# Welcome to Noora\nNoora is a deployment tool that can be used to automate the database deployment cycle. It allows you to organize your database structure, do versioning on your data model, set up environments and generate self-contained Python packages that can deploy your structure to a server.\n\nNoora was created with the DevOps paradigm in mind; especially when as a team you manage many database models it enables you to standardize your DDL and streamline development, testing, acceptance and deployment in production.\n\nNOTE: This project is currently split across two branches, where Noora 1.1.0 provides MySQL and MSSQL support using Python 2 and 3 and Noora 1.0.2 supports Oracle and MySQL using Python 2 only. This documentation describes Noora >= 1.1.\n\nNoora is released under the [GNU General Public License](LICENSE).\n\n\n# Quick Start\nTo install Noora, you can either install a release from Github or install from source:\n\n```\n# Install a release from Github\n$> pip install https://github.com/janripke/noora/archive/1.1.0.zip\n\n# Clone and install from source\n$> git clone https://github.com/janripke/noora/\n$> cd noora\n$> pip install .\n```\n\nWe'll set up a MySQL project, so first make sure to create a user and database for your project:\n\n```\n$> mysql -uroot\nmysql> create database acme;\nmysql> create user apps@'localhost' identified by 'apps';\nmysql> grant all on acme.* to apps@'localhost';\nmysql> -- This is currently required to be able to drop functions and procedures, to be fixed\nmysql> grant select, delete on mysql.proc to apps@'localhost';\nmysql> flush privileges;\n```\n\nThen, on the command line create your project:\n\n```\n$> mynoora generate -t=mysql\ndatabase : acme\nhost [localhost] :\nusername : apps\npassword : apps\nversion [1.0.0]:\nversion 1.0.0 created.\n```\n\nAdd a table and some data to your newly created project:\n\n```\n$> echo \"CREATE TABLE hello ( value VARCHAR(128) );\" > acme-db/create/acme/ddl/tab/hello.sql\n$> echo \"INSERT INTO hello SET value='world';\" > acme-db/create/acme/dat/hello.sql\n```\n\nNow, let's deploy the project and see what happens:\n\n```\n$> cd acme-db\n$> mynoora create -h=localhost\ncreating database 'acme' on host 'localhost' using environment 'dev'\n/home/niels/tmp/acme-db/create/acme/ddl/tab/application_properties.sql\n/home/niels/tmp/acme-db/create/acme/ddl/tab/hello.sql\n/home/niels/tmp/acme-db/create/acme/ddl/fct/get_property.sql\n/home/niels/tmp/acme-db/create/acme/ddl/trg/application_properties_bi.sql\n/home/niels/tmp/acme-db/create/acme/ddl/trg/application_properties_bu.sql\n/home/niels/tmp/acme-db/create/acme/ddl/idx/application_properties.sql\n/home/niels/tmp/acme-db/create/acme/dat/hello.sql\n/home/niels/tmp/acme-db/create/acme/dat/version.sql\n/home/niels/tmp/acme-db/create/acme/dat/dev/environment.sql\ndatabase 'acme' created.\n```\n\nYou can verify that the table you added along with some default data was deployed, and that the current version of your database model is 1.0.0 in the 'dev' environment: \n\n```\n$> mysql -uapps -p acme\nEnter password:\nmysql> select * from hello;\n+--------+\n| value  |\n+--------+\n| world; |\n+--------+\n1 row in set (0.00 sec)\n\nmysql> select get_property('application.version');\n+-------------------------------------+\n| get_property('application.version') |\n+-------------------------------------+\n| 1.0.0                               |\n+-------------------------------------+\n1 row in set (0.00 sec)\n```\n\nThat's it! To learn more about Noora projects, check out http://noora.readthedocs.org/getting-started. For now, you can clear out your database like this::\n\n```\n$> mynoora drop -h=localhost\ndropping database 'acme' on host 'localhost' using environment 'dev'\n/home/niels/projects/noora/noora/plugins/mysql/drop/vw/drop_views.sql\n/home/niels/projects/noora/noora/plugins/mysql/drop/tab/drop_tables.sql\n/home/niels/projects/noora/noora/plugins/mysql/drop/prc/drop_procedures.sql\n/home/niels/projects/noora/noora/plugins/mysql/drop/fct/drop_functions.sql\ndatabase 'acme' dropped.\n```\n\nNote that this does not actually drop the database itself, rather it removes all objects, including views and procedures.\n\n\n# Next Steps\n\nCheck out the documentation over at http://noora.readthedocs.org/\n\n\n",
        "description_content_type": "",
        "docs_url": null,
        "download_url": "",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://github.com/janripke/noora",
        "keywords": "development database",
        "license": "GNU General Public License v3 or later (GPLv3+)",
        "maintainer": "Jan Ripke",
        "maintainer_email": "jan.ripke@oxyma.nl",
        "name": "noora",
        "package_url": "https://pypi.org/project/noora/",
        "platform": "",
        "project_url": "https://pypi.org/project/noora/",
        "project_urls": {
            "Homepage": "https://github.com/janripke/noora"
        },
        "release_url": "https://pypi.org/project/noora/1.1.0/",
        "requires_dist": [
            "nose",
            "pytest"
        ],
        "requires_python": "",
        "summary": "NoOra a database deployment tool.",
        "version": "1.1.0"
    },
    "last_serial": 4901374,
    "releases": {
        "0.0.4": [],
        "0.0.5": [],
        "0.0.6": [],
        "0.0.7": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "0d7a29b085413b352131187b7e8689ed",
                    "sha256": "7e9a31b4d40577232e85e9388d46f8d8bdf158dfe79c3f4a65e6b80b88aa97d9"
                },
                "downloads": -1,
                "filename": "noora_0.0.7.tar.gz",
                "has_sig": false,
                "md5_digest": "0d7a29b085413b352131187b7e8689ed",
                "packagetype": "bdist_dumb",
                "python_version": "2.7",
                "requires_python": null,
                "size": 469132,
                "upload_time": "2012-07-22T12:38:17",
                "url": "https://files.pythonhosted.org/packages/dd/08/db9e13c847f0930b3ee6354fee8b5d60fdce59ba15e1cb4b8e255d0145b7/noora_0.0.7.tar.gz"
            }
        ],
        "0.0.8": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "eca0430c9bb9a90fd04cb007bfcc41c0",
                    "sha256": "681c27e07aa8be15656910980f777d72a229f007c8029e01e4a1e00343f00102"
                },
                "downloads": -1,
                "filename": "noora_0.0.8.tar.gz",
                "has_sig": false,
                "md5_digest": "eca0430c9bb9a90fd04cb007bfcc41c0",
                "packagetype": "bdist_dumb",
                "python_version": "2.7",
                "requires_python": null,
                "size": 536491,
                "upload_time": "2013-05-17T20:21:08",
                "url": "https://files.pythonhosted.org/packages/b4/be/b4ac6826d26a0ac6dc0d74e6b11a481ee2dd0bef06abd110637d25e4131d/noora_0.0.8.tar.gz"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "5364def974ad7b266ecfd8f285813894",
                    "sha256": "792e8da9f8791a6d3aacc87c83c6e0534e974a27f50860b63e86d0ef804790e7"
                },
                "downloads": -1,
                "filename": "noora_0.0.8.zip",
                "has_sig": false,
                "md5_digest": "5364def974ad7b266ecfd8f285813894",
                "packagetype": "bdist_dumb",
                "python_version": "2.7",
                "requires_python": null,
                "size": 944931,
                "upload_time": "2013-05-17T20:22:09",
                "url": "https://files.pythonhosted.org/packages/34/40/6eac456eb4ae2800b8c67b47036f8fe9cd6965ab68500743bd05788fc5cc/noora_0.0.8.zip"
            }
        ],
        "0.0.8.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "3660fe994f7ce4eb42a62c6da42e5658",
                    "sha256": "6d525b335d8211475e9ab6d71c814d17e7f9e923fb030ed540298bc6fd91efb9"
                },
                "downloads": -1,
                "filename": "noora_0.0.8.1.tar.gz",
                "has_sig": false,
                "md5_digest": "3660fe994f7ce4eb42a62c6da42e5658",
                "packagetype": "bdist_dumb",
                "python_version": "2.7",
                "requires_python": null,
                "size": 536367,
                "upload_time": "2013-05-28T19:10:14",
                "url": "https://files.pythonhosted.org/packages/84/bb/f7ba5919d52ba6e8c0379c37343cb80aad600bc95965c44a4aae4ca191e5/noora_0.0.8.1.tar.gz"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "4d97c3c40e6f2562d317d3aca32693db",
                    "sha256": "b782b72bcc37edd5ea2b355a4b5c23aa8c803a4e389ae9ce1702d5468e11e5e1"
                },
                "downloads": -1,
                "filename": "noora_0.0.8.1.zip",
                "has_sig": false,
                "md5_digest": "4d97c3c40e6f2562d317d3aca32693db",
                "packagetype": "bdist_dumb",
                "python_version": "2.7",
                "requires_python": null,
                "size": 946942,
                "upload_time": "2013-05-28T19:10:48",
                "url": "https://files.pythonhosted.org/packages/68/56/76275f9ce6c83aab8b3a50b2b11bd8f0631c25ec9231f13bd9e242d300b3/noora_0.0.8.1.zip"
            }
        ],
        "0.0.8.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "5cc67f2f0462809207a4b4beeddc5bd9",
                    "sha256": "b1cbeae71945c020436eba0f28f8c54aa6ace6c281fa7d136c327e5b08f1ac25"
                },
                "downloads": -1,
                "filename": "noora_0.0.8.2.tar.gz",
                "has_sig": false,
                "md5_digest": "5cc67f2f0462809207a4b4beeddc5bd9",
                "packagetype": "bdist_dumb",
                "python_version": "2.6",
                "requires_python": null,
                "size": 543918,
                "upload_time": "2013-07-04T21:41:01",
                "url": "https://files.pythonhosted.org/packages/2b/c2/3a7d0ac961f4d5d3a5f765b9de1a6792bd79fd8feafcdf5b67150c718ed0/noora_0.0.8.2.tar.gz"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "043ae9f3340ab3bdbabea46dc975d6e7",
                    "sha256": "e26ce46be2e2333e0a2bfdeebc9da40b1f8b8f32792f82f07af4895a5edd414f"
                },
                "downloads": -1,
                "filename": "noora_0.0.8.2.zip",
                "has_sig": false,
                "md5_digest": "043ae9f3340ab3bdbabea46dc975d6e7",
                "packagetype": "bdist_dumb",
                "python_version": "2.6",
                "requires_python": null,
                "size": 950816,
                "upload_time": "2013-07-04T21:41:31",
                "url": "https://files.pythonhosted.org/packages/00/4b/775408d1cd23bda4a3b1c394b23d15fe8fa26f6088c2539cf2b750fcde00/noora_0.0.8.2.zip"
            }
        ],
        "0.0.9": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "efb671b0aded05a5a67c17a1c47aab87",
                    "sha256": "126b2ceabb194d746e9af361054cef5ebd66a51546f7bb8c92ce86c66d5e707e"
                },
                "downloads": -1,
                "filename": "noora_0.0.9.tar.gz",
                "has_sig": false,
                "md5_digest": "efb671b0aded05a5a67c17a1c47aab87",
                "packagetype": "bdist_dumb",
                "python_version": "2.7",
                "requires_python": null,
                "size": 677343,
                "upload_time": "2013-12-07T13:32:47",
                "url": "https://files.pythonhosted.org/packages/ee/b8/e296d5ddef6e9749b76cc49a8903ff4d960bca73ad799069250d5b87328d/noora_0.0.9.tar.gz"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "fb461a4d0d1bb91f9bb7be78ab0de33a",
                    "sha256": "51db3d813014d4b10055ae85764af4012f05c50413b023ffebc0dbe767e9029d"
                },
                "downloads": -1,
                "filename": "noora_0.0.9.zip",
                "has_sig": false,
                "md5_digest": "fb461a4d0d1bb91f9bb7be78ab0de33a",
                "packagetype": "bdist_dumb",
                "python_version": "2.7",
                "requires_python": null,
                "size": 962943,
                "upload_time": "2013-12-07T13:32:27",
                "url": "https://files.pythonhosted.org/packages/8b/d6/06c39eec710fbd83490a5b5b045bf53fa925951e53461610bab4fbf145d9/noora_0.0.9.zip"
            }
        ],
        "1.0.1": [],
        "1.1.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "a03e416965dca23214786521b680e089",
                    "sha256": "c8f0146342101384dfe450a19d24bd44dc4732164a046d3afe4304b8dcc76a33"
                },
                "downloads": -1,
                "filename": "noora-1.1.0-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "a03e416965dca23214786521b680e089",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 62862,
                "upload_time": "2019-03-05T19:04:39",
                "url": "https://files.pythonhosted.org/packages/68/36/aa86ddfd1a614e5421ca7988f145ad64821d263018d73aa5c10399dc0931/noora-1.1.0-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "cba629672a2545732cb7b9bd56e78a92",
                    "sha256": "bd8d1b5210c44ee0aef53f42e490b5061c519013ef703b6fe6d966e7e46351ec"
                },
                "downloads": -1,
                "filename": "noora-1.1.0.tar.gz",
                "has_sig": false,
                "md5_digest": "cba629672a2545732cb7b9bd56e78a92",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 36265,
                "upload_time": "2019-03-05T19:04:41",
                "url": "https://files.pythonhosted.org/packages/5e/02/4fee92e63edd5d68db18e6e509882e479451a00e22b0520630f00d968c28/noora-1.1.0.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "a03e416965dca23214786521b680e089",
                "sha256": "c8f0146342101384dfe450a19d24bd44dc4732164a046d3afe4304b8dcc76a33"
            },
            "downloads": -1,
            "filename": "noora-1.1.0-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "a03e416965dca23214786521b680e089",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": null,
            "size": 62862,
            "upload_time": "2019-03-05T19:04:39",
            "url": "https://files.pythonhosted.org/packages/68/36/aa86ddfd1a614e5421ca7988f145ad64821d263018d73aa5c10399dc0931/noora-1.1.0-py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "cba629672a2545732cb7b9bd56e78a92",
                "sha256": "bd8d1b5210c44ee0aef53f42e490b5061c519013ef703b6fe6d966e7e46351ec"
            },
            "downloads": -1,
            "filename": "noora-1.1.0.tar.gz",
            "has_sig": false,
            "md5_digest": "cba629672a2545732cb7b9bd56e78a92",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 36265,
            "upload_time": "2019-03-05T19:04:41",
            "url": "https://files.pythonhosted.org/packages/5e/02/4fee92e63edd5d68db18e6e509882e479451a00e22b0520630f00d968c28/noora-1.1.0.tar.gz"
        }
    ]
}