{ "info": { "author": "Shinya Ohyanagi", "author_email": "sohyanagi@gmail.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 4 - Beta", "Intended Audience :: Developers", "License :: OSI Approved :: BSD License", "Operating System :: OS Independent", "Programming Language :: Python", "Topic :: Database" ], "description": "sqlalchemy_seed\n----------------\n\n.. image:: https://travis-ci.org/heavenshell/py-sqlalchemy_seed.svg?branch=master\n :target: https://travis-ci.org/heavenshell/py-sqlalchemy_seed\n.. image:: https://pyup.io/repos/github/heavenshell/py-sqlalchemy_seed/python-3-shield.svg\n :target: https://pyup.io/repos/github/heavenshell/py-sqlalchemy_seed/\n :alt: Python 3\n.. image:: https://pyup.io/repos/github/heavenshell/py-sqlalchemy_seed/shield.svg\n :target: https://pyup.io/repos/github/heavenshell/py-sqlalchemy_seed/\n :alt: Updates\n\n`sqlalchemy_seed` is a seed library which provides initial data to database using SQLAlchemy.\n\n`sqlalchemy_seed` is similar to `Django fixtures `_.\n\nInstallation\n============\n\n.. code::\n\n pip install sqlalchemy_seed\n\nAdding seed\n===========\n\n.. code::\n\n /myapp\n __init__.py\n models.py\n /fixtures\n accounts.yaml\n\nModel file.\n\n.. code:: python\n\n # -*- coding: utf-8 -*-\n\n from sqlalchemy import create_engine\n from sqlalchemy.exc import OperationalError\n from sqlalchemy.ext.declarative import declarative_base\n from sqlalchemy.orm import scoped_session, sessionmaker, relationship\n engine = create_engine('sqlite://', convert_unicode=True)\n\n Base = declarative_base()\n Base.metadata.bind = engine\n Session = sessionmaker(autocommit=False, autoflush=False, bind=engine)\n session = scoped_session(Session)\n\n class Account(Base):\n __tablename__ = 'accounts'\n\n id = Column(Integer, primary_key=True)\n first_name = Column(String(100), nullable=False)\n last_name = Column(String(100), nullable=False)\n age = Column(Integer(), nullable=True)\n\n\nSeed code.\n\n.. code:: python\n\n # -*- coding: utf-8 -*-\n\n from sqlalchemy_seed import (\n create_table,\n drop_table,\n load_fixtures,\n load_fixture_files,\n )\n from myapp.models import Base, session\n\n\n def main():\n path = '/path/to/fixtures'\n fixtures = load_fixture_files(path, ['accounts.yaml'])\n load_fixtures(session, fixtures)\n\n\n if __name__ == '__main__':\n main()\n\nSeed file.\n\n.. code::\n\n - model: myapp.models.Account\n id: 1\n fields:\n first_name: John\n last_name: Lennon\n age: 20\n\n - model: myapp.models.Account\n id: 2\n fields:\n first_name: Paul\n last_name: McCartney\n age: 21\n\nLICENSE\n=======\nNEW BSD LICENSE.\n", "description_content_type": "", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "http://github.com/heavenshell/py-sqlalchemy_seed", "keywords": "", "license": "BSD", "maintainer": "", "maintainer_email": "", "name": "sqlalchemy_seed", "package_url": "https://pypi.org/project/sqlalchemy_seed/", "platform": "any", "project_url": "https://pypi.org/project/sqlalchemy_seed/", "project_urls": { "Homepage": "http://github.com/heavenshell/py-sqlalchemy_seed" }, "release_url": "https://pypi.org/project/sqlalchemy_seed/0.3.0/", "requires_dist": null, "requires_python": "", "summary": "sqlalchemy_seed is simple data seeder using SQLAlchmy.", "version": "0.3.0" }, "last_serial": 5242513, "releases": { "0.1.1": [ { "comment_text": "", "digests": { "md5": "754c50284bd6198c3370e35c5071fd4c", "sha256": "80a598476b148ced7b66038f15b5623bad9867e3e6b89d96ad6b28c8a5174da2" }, "downloads": -1, "filename": "sqlalchemy_seed-0.1.1.tar.gz", "has_sig": false, "md5_digest": "754c50284bd6198c3370e35c5071fd4c", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4244, "upload_time": "2017-02-12T09:46:32", "url": "https://files.pythonhosted.org/packages/b7/b7/960117351cbd79c5cb4c61318c08b2b758db0c99673e04d251e65be9f779/sqlalchemy_seed-0.1.1.tar.gz" } ], "0.1.2": [ { "comment_text": "", "digests": { "md5": "97132744f163daf7ddbaae792db633a9", "sha256": "32593850ef3df1e62ed9e9d4a5f718873b7d90c29363c6fbf8f83db375552b4e" }, "downloads": -1, "filename": "sqlalchemy_seed-0.1.2.tar.gz", "has_sig": false, "md5_digest": "97132744f163daf7ddbaae792db633a9", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4424, "upload_time": "2018-06-02T14:46:14", "url": "https://files.pythonhosted.org/packages/41/1a/d19340a543132a88c7928b753a1e38f0e3feb9101368e64f28bb967616cd/sqlalchemy_seed-0.1.2.tar.gz" } ], "0.2.0": [ { "comment_text": "", "digests": { "md5": "c2d3aabe55d752f8e745306769b6e5df", "sha256": "da43d72ae8372c6acca08e82f9139878d001ced5b98b9a3546c72a0a75d4e172" }, "downloads": -1, "filename": "sqlalchemy_seed-0.2.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "c2d3aabe55d752f8e745306769b6e5df", "packagetype": "bdist_wheel", "python_version": "3.6", "requires_python": null, "size": 5645, "upload_time": "2019-05-04T10:34:24", "url": "https://files.pythonhosted.org/packages/5d/83/d10dfd1df66578788ba5924a88951b712186b4088a6eef367fb1f3445640/sqlalchemy_seed-0.2.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "012a22cd4c8842120ac66b1c44e58d04", "sha256": "fca2f257473c7fba79337248dd142bf3b763229254552160ec8720d61dcdb3ba" }, "downloads": -1, "filename": "sqlalchemy_seed-0.2.0.tar.gz", "has_sig": false, "md5_digest": "012a22cd4c8842120ac66b1c44e58d04", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4470, "upload_time": "2019-05-04T10:34:21", "url": "https://files.pythonhosted.org/packages/d7/2c/13be00b23ce362cde39b8988feeff163e5a2d0b66859ae97db4e9c9a5807/sqlalchemy_seed-0.2.0.tar.gz" } ], "0.3.0": [ { "comment_text": "", "digests": { "md5": "7765e8efb227baff645c420f53a44e5f", "sha256": "7e241331cfd20a65b79b24c66b4d1a1911a13bfb9aac76f84e60b100c88b1930" }, "downloads": -1, "filename": "sqlalchemy_seed-0.3.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "7765e8efb227baff645c420f53a44e5f", "packagetype": "bdist_wheel", "python_version": "3.6", "requires_python": null, "size": 5645, "upload_time": "2019-05-08T11:51:58", "url": "https://files.pythonhosted.org/packages/22/d2/c55b8d416e94b771f0c7b0616292f3340e603e82a1e7af5753d280985c21/sqlalchemy_seed-0.3.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "c4bb2bfe9cb88b41e54f625b1ded4a9c", "sha256": "be89813140fa4fe39d4121d364f9c00090c9509c5ec310bfb9579591fe923a95" }, "downloads": -1, "filename": "sqlalchemy_seed-0.3.0.tar.gz", "has_sig": false, "md5_digest": "c4bb2bfe9cb88b41e54f625b1ded4a9c", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4466, "upload_time": "2019-05-08T11:51:56", "url": "https://files.pythonhosted.org/packages/2f/e1/ab53ae4d7d9467ee8d17355f4e9f9160662feef68b1fd1dfbf52335224ff/sqlalchemy_seed-0.3.0.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "7765e8efb227baff645c420f53a44e5f", "sha256": "7e241331cfd20a65b79b24c66b4d1a1911a13bfb9aac76f84e60b100c88b1930" }, "downloads": -1, "filename": "sqlalchemy_seed-0.3.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "7765e8efb227baff645c420f53a44e5f", "packagetype": "bdist_wheel", "python_version": "3.6", "requires_python": null, "size": 5645, "upload_time": "2019-05-08T11:51:58", "url": "https://files.pythonhosted.org/packages/22/d2/c55b8d416e94b771f0c7b0616292f3340e603e82a1e7af5753d280985c21/sqlalchemy_seed-0.3.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "c4bb2bfe9cb88b41e54f625b1ded4a9c", "sha256": "be89813140fa4fe39d4121d364f9c00090c9509c5ec310bfb9579591fe923a95" }, "downloads": -1, "filename": "sqlalchemy_seed-0.3.0.tar.gz", "has_sig": false, "md5_digest": "c4bb2bfe9cb88b41e54f625b1ded4a9c", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4466, "upload_time": "2019-05-08T11:51:56", "url": "https://files.pythonhosted.org/packages/2f/e1/ab53ae4d7d9467ee8d17355f4e9f9160662feef68b1fd1dfbf52335224ff/sqlalchemy_seed-0.3.0.tar.gz" } ] }