{ "info": { "author": "sunurdy", "author_email": "sunurdy@hotmail.com", "bugtrack_url": null, "classifiers": [], "description": "# Sqlalchemy bulk insert helper\n\nA simple helper for bulk insert data with sqlalchemy\n\n\n\nusage:\n\nLet's assume we have a session and model\n\n```python\nfrom sqlalchemy import create_engine, INTEGER, String, Column\nfrom sqlalchemy.ext.declarative import declarative_base\nfrom sqlalchemy.orm import sessionmaker\n\nBase = declarative_base()\nmetadata = Base.metadata\nsess = sessionmaker(bind=create_engine(\"DB_URL\"))()\n\nclass User(Base):\n __tablename__ = 'user'\n\n id = Column(INTEGER, primary_key=True, autoincrement=True)\n name = Column(String(100))\n```\n\ncreate users for simple which need to be inserted into db\n\n```\nusers = [User(name=i) for i in ('Thor', 'Stark', 'Rogers', 'Scarlet Witch', 'Strange')]\n```\n\nAnd we can insert users with following code:\n\n```python\nfrom sa_insert_helper import bulk_insert\n\nwith bulk_insert(session=sess, model=User, n=1000) as bi:\n for u in users:\n bi.insert(u)\n```", "description_content_type": "", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/sunurdy/sa_insert_helper", "keywords": "bulk insert", "license": "MIT License", "maintainer": "", "maintainer_email": "", "name": "sa-insert-helper", "package_url": "https://pypi.org/project/sa-insert-helper/", "platform": "", "project_url": "https://pypi.org/project/sa-insert-helper/", "project_urls": { "Homepage": "https://github.com/sunurdy/sa_insert_helper" }, "release_url": "https://pypi.org/project/sa-insert-helper/0.0.1/", "requires_dist": null, "requires_python": "", "summary": "a library for bulk insert", "version": "0.0.1" }, "last_serial": 4536834, "releases": { "0.0.1": [ { "comment_text": "", "digests": { "md5": "798d002036cec14425a6bd3a61e4f1c2", "sha256": "b56291e36b967249a4e134ec0d24b89469362859689098a8f701d0bed6ce8e85" }, "downloads": -1, "filename": "sa-insert-helper-0.0.1.tar.gz", "has_sig": false, "md5_digest": "798d002036cec14425a6bd3a61e4f1c2", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 1919, "upload_time": "2018-11-28T04:02:08", "url": "https://files.pythonhosted.org/packages/9f/7f/5803d9540e5cb0584248cd2db20ac2454598987261685627285750910db5/sa-insert-helper-0.0.1.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "798d002036cec14425a6bd3a61e4f1c2", "sha256": "b56291e36b967249a4e134ec0d24b89469362859689098a8f701d0bed6ce8e85" }, "downloads": -1, "filename": "sa-insert-helper-0.0.1.tar.gz", "has_sig": false, "md5_digest": "798d002036cec14425a6bd3a61e4f1c2", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 1919, "upload_time": "2018-11-28T04:02:08", "url": "https://files.pythonhosted.org/packages/9f/7f/5803d9540e5cb0584248cd2db20ac2454598987261685627285750910db5/sa-insert-helper-0.0.1.tar.gz" } ] }