{ "info": { "author": "Vadim Tsander", "author_email": "ts.taiye@live.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 4 - Beta", "Environment :: Web Environment", "Intended Audience :: Developers", "License :: OSI Approved :: BSD License", "Natural Language :: English", "Operating System :: OS Independent", "Programming Language :: Python", "Programming Language :: Python :: 2.6", "Programming Language :: Python :: 2.7", "Topic :: Software Development :: Libraries :: Python Modules" ], "description": "Status\n======\n\nLatest stable\n-------------\n\n.. image:: https://travis-ci.org/ts-taiye/raw-sql-migrate.svg?branch=master\n :target: https://travis-ci.org/ts-taiye/raw-sql-migrate\n\n.. image:: https://coveralls.io/repos/ts-taiye/raw-sql-migrate/badge.svg?branch=master\n :target: https://coveralls.io/r/ts-taiye/raw-sql-migrate?branch=master\n\nDevelop\n-------\n\n.. image:: https://travis-ci.org/ts-taiye/raw-sql-migrate.svg?branch=develop\n :target: https://travis-ci.org/ts-taiye/raw-sql-migrate\n\n.. image:: https://coveralls.io/repos/ts-taiye/raw-sql-migrate/badge.svg?branch=develop\n :target: https://coveralls.io/r/ts-taiye/raw-sql-migrate?branch=develop\n\n\nGoal\n====\nRaw-sql-migrate is tool for managing your raw SQL migrations.\n\n\nDocs\n====\nSee page for full docs.\n\n\nShort guide\n===========\n1. Create rsm.yaml or rsm.py in your project dir with next structure:\n\n.. code-block:: yaml\n\n database:\n engine: engine backend module\n host: database host\n port: database port\n name: database name\n user: user name\n password: user password\n history_table_name: migration history table name\n\n.. code-block:: python\n\n RSM_CONFIG = {\n 'database': {\n 'engine': engine backend module,\n 'host': database host,\n 'port': database port,\n 'name': database name,\n 'user': user name,\n 'password': user password,\n },\n 'history_table_name': migration history table name,\n 'packages': [\n 'package_a',\n 'package_b',\n 'package_c.package_d',\n ],\n }\n\n\n2. Create first migration\n\n.. code-block:: shell\n\n rsm create package_a.package_b initial\n\n3. Edit migration file found package_a/package_b/migrations/0001_initial.py. Example:\n\n.. code-block:: python\n\n def forward(database_api):\n database_api.execute(\n '''\n CREATE TABLE test (\n id INT PRIMARY KEY NOT NULL,\n test_value BIGINT NOT NULL,\n );\n CREATE INDEX test_value_index ON test(test_value);\n '''\n )\n\n def backward(database_api):\n database_api.execute('DROP TABLE test;')\n\n4. Run migrations:\n\n.. code-block:: shell\n\n rsm migrate package_a.package_b\n\n5. Migrating backwards:\n\n.. code-block:: shell\n\n rsm migrate package_a.package_b 0", "description_content_type": null, "docs_url": null, "download_url": "UNKNOWN", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/ts-taiye/raw-sql-migrate", "keywords": null, "license": "UNKNOWN", "maintainer": null, "maintainer_email": null, "name": "raw-sql-migrate", "package_url": "https://pypi.org/project/raw-sql-migrate/", "platform": "UNKNOWN", "project_url": "https://pypi.org/project/raw-sql-migrate/", "project_urls": { "Download": "UNKNOWN", "Homepage": "https://github.com/ts-taiye/raw-sql-migrate" }, "release_url": "https://pypi.org/project/raw-sql-migrate/0.3.4/", "requires_dist": null, "requires_python": null, "summary": "Simple tool for managing raw sql migrations scripts.", "version": "0.3.4" }, "last_serial": 1748568, "releases": { "0.1": [ { "comment_text": "", "digests": { "md5": "9b53fa05e7d893337f04a385e9899ff1", "sha256": "9bb3fc9753578bfc04ba9f492a869c1de4638008e67979e248093cc0b3f83517" }, "downloads": -1, "filename": "raw-sql-migrate-0.1.tar.gz", "has_sig": false, "md5_digest": "9b53fa05e7d893337f04a385e9899ff1", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 19371, "upload_time": "2015-06-03T06:26:05", "url": "https://files.pythonhosted.org/packages/80/d2/cdfebc8f45beadc51812aa15c38d42a0dc7145edff42468dc63cb1dae69d/raw-sql-migrate-0.1.tar.gz" } ], "0.1.1": [ { "comment_text": "", "digests": { "md5": "747304eed680e4139724f4e722ed6244", "sha256": "0e0304154dced125d03b64a064fab15243cf41c8d99786d7001cef6455498ca0" }, "downloads": -1, "filename": "raw-sql-migrate-0.1.1.tar.gz", "has_sig": false, "md5_digest": "747304eed680e4139724f4e722ed6244", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 19381, "upload_time": "2015-06-03T12:04:14", "url": "https://files.pythonhosted.org/packages/01/15/56c3ceaebf252d7dcce49f447d1e254f495a7c6429a9b72ee17e4922e90f/raw-sql-migrate-0.1.1.tar.gz" } ], "0.2": [ { "comment_text": "", "digests": { "md5": "ec18158fcb83f9d33a7e7e50c306f68d", "sha256": "bdc4bb049950d79eac3a2db78ab9f918a543739fc86052ac4dca1578b163abc7" }, "downloads": -1, "filename": "raw-sql-migrate-0.2.tar.gz", "has_sig": false, "md5_digest": "ec18158fcb83f9d33a7e7e50c306f68d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 21903, "upload_time": "2015-07-01T07:43:48", "url": "https://files.pythonhosted.org/packages/b3/71/16af16d72d06c85cb488171a46789ae7b6ff65259a7b6ca2e2bbde5874a6/raw-sql-migrate-0.2.tar.gz" } ], "0.2.1": [ { "comment_text": "", "digests": { "md5": "dc97cca3487a3dffb339ac6847f8ab5a", "sha256": "9d605a99937bdde0ce93d010e8907c93a96af72e793c010a88ca680e67e041ac" }, "downloads": -1, "filename": "raw-sql-migrate-0.2.1.zip", "has_sig": false, "md5_digest": "dc97cca3487a3dffb339ac6847f8ab5a", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 36143, "upload_time": "2015-07-02T16:17:36", "url": "https://files.pythonhosted.org/packages/76/a7/8a34ccc8836d5a85d8124d6a170b23bec214f58faa71771a684ce0d15a82/raw-sql-migrate-0.2.1.zip" } ], "0.3.0": [ { "comment_text": "", "digests": { "md5": "dcb755e80df653a736098d009646bec2", "sha256": "b07cf8b8dc65b62fcfd79a49991578818ee660e7a1555c923deab08bb21b9442" }, "downloads": -1, "filename": "raw-sql-migrate-0.3.0.tar.gz", "has_sig": false, "md5_digest": "dcb755e80df653a736098d009646bec2", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 25358, "upload_time": "2015-08-24T10:05:31", "url": "https://files.pythonhosted.org/packages/29/3b/789430c960cbb1998f49a64a92f911d4e29e756bfe276ce8d2f9d2831437/raw-sql-migrate-0.3.0.tar.gz" } ], "0.3.1": [ { "comment_text": "", "digests": { "md5": "186ff132b4a9108daad1cccebd65145d", "sha256": "79672857776517c10634afbcd9204f2f5023df825b73455ad75229a56e05bf49" }, "downloads": -1, "filename": "raw-sql-migrate-0.3.1.tar.gz", "has_sig": false, "md5_digest": "186ff132b4a9108daad1cccebd65145d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 26247, "upload_time": "2015-08-29T15:07:37", "url": "https://files.pythonhosted.org/packages/3e/62/f4ac944ef6143c1f64ed998bffa205db9190143560cda6c9098c29dc2a0a/raw-sql-migrate-0.3.1.tar.gz" } ], "0.3.2": [ { "comment_text": "", "digests": { "md5": "cff67513035cfd469b58341c99b1c513", "sha256": "54bcff332113a068484438ade9ec02da10b4880c8c2426b0ba82d93230405f00" }, "downloads": -1, "filename": "raw-sql-migrate-0.3.2.tar.gz", "has_sig": false, "md5_digest": "cff67513035cfd469b58341c99b1c513", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 26316, "upload_time": "2015-08-29T17:57:32", "url": "https://files.pythonhosted.org/packages/23/f2/3be76f08b1900596f0d8a04d1702adbfc7e3b2289e99f55218d34d1ae780/raw-sql-migrate-0.3.2.tar.gz" } ], "0.3.4": [ { "comment_text": "", "digests": { "md5": "111689ad8d37042b4003037c2350e03d", "sha256": "4e41e38f81fccae36640a1f64837c107ff8289dc76b7aab624a250dc6a136151" }, "downloads": -1, "filename": "raw-sql-migrate-0.3.4.tar.gz", "has_sig": false, "md5_digest": "111689ad8d37042b4003037c2350e03d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 11421, "upload_time": "2015-10-02T08:57:27", "url": "https://files.pythonhosted.org/packages/17/1b/7655426de3169d5b383399c30216260ebdf76e6c16ec17bfc1f1f78e5336/raw-sql-migrate-0.3.4.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "111689ad8d37042b4003037c2350e03d", "sha256": "4e41e38f81fccae36640a1f64837c107ff8289dc76b7aab624a250dc6a136151" }, "downloads": -1, "filename": "raw-sql-migrate-0.3.4.tar.gz", "has_sig": false, "md5_digest": "111689ad8d37042b4003037c2350e03d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 11421, "upload_time": "2015-10-02T08:57:27", "url": "https://files.pythonhosted.org/packages/17/1b/7655426de3169d5b383399c30216260ebdf76e6c16ec17bfc1f1f78e5336/raw-sql-migrate-0.3.4.tar.gz" } ] }