{ "info": { "author": "Daniel Pepper", "author_email": "", "bugtrack_url": null, "classifiers": [ "License :: OSI Approved :: MIT License", "Programming Language :: Python", "Topic :: Utilities" ], "description": "SQLAlchemy Lightening\n===\nMaking SQLAlchemy great again\n\n\n#### Install\n```pip install sqlalchemy_ligthening```\n\n\n#### Usage\n```\n# load by id\nPerson.get(1)\n\n# load multiple by id\nPerson.get(1, 2, 3)\n# or\nPerson.get([1, 2, 3])\n\n# basic filter\nPerson.where(name='dpepper')\n\n# where `name` in ...\nPerson.where(name=['dpepper', 'thatguy'])\n\n# mix and match\nPerson.where(Person.id != 1, name='dpepper')\n\n# standard utilities\nPerson.all\nPerson.first\n\n# standard SQLAlchemy query\nPerson.query\n```\n\n## Example Setup\n```\nfrom sqlalchemy import create_engine\nfrom sqlalchemy.ext.declarative import declarative_base\nfrom sqlalchemy.orm import sessionmaker\nfrom sqlalchemy_lightening import LighteningBase\n\n\n# create base sqlalchemy model\nBase = declarative_base()\n\n# extend LighteningBase mixin\nclass Person(LighteningBase, Base):\n id = Column(Integer, primary_key=True)\n name = Column(String(250))\n\nengine = create_engine('sqlite:///:memory:')\nsession = sessionmaker(bind=engine)()\n\nBase.metadata.create_all(engine)\nBase.metadata.bind = engine\n\n# wire things up\nLighteningBase.query_class = session.query\n\n# good to go\nPerson.winning\n```\n\n\n----\n[![installs](https://img.shields.io/pypi/dm/sqlalchemy_lightening.svg?label=installs)](https://pypi.org/project/sqlalchemy_lightening)\n\n\n", "description_content_type": "text/markdown", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/dpep/pysqlalchemy_lightening", "keywords": "", "license": "MIT", "maintainer": "", "maintainer_email": "", "name": "sqlalchemy-lightening", "package_url": "https://pypi.org/project/sqlalchemy-lightening/", "platform": "any", "project_url": "https://pypi.org/project/sqlalchemy-lightening/", "project_urls": { "Homepage": "https://github.com/dpep/pysqlalchemy_lightening" }, "release_url": "https://pypi.org/project/sqlalchemy-lightening/0.4.4/", "requires_dist": [ "classproperties", "pluckit", "rekey", "sqlalchemy", "stringcase" ], "requires_python": "", "summary": "making SQLAlchemy great again", "version": "0.4.4" }, "last_serial": 5853109, "releases": { "0.0.1": [ { "comment_text": "", "digests": { "md5": "fc624035174f6bb4642339e0431c1ab8", "sha256": "a24f3cf40b9d63e05eda6a06a6a85083f640b4ef454047778f47f351bb71f4d9" }, "downloads": -1, "filename": "sqlalchemy_lightening-0.0.1.tar.gz", "has_sig": true, "md5_digest": "fc624035174f6bb4642339e0431c1ab8", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2734, "upload_time": "2018-02-22T18:09:20", "url": "https://files.pythonhosted.org/packages/0b/7d/e874b6b29a9c621558243efb67eb033911b5729b98b76788c531b4a6f26d/sqlalchemy_lightening-0.0.1.tar.gz" } ], "0.1.0": [ { "comment_text": "", "digests": { "md5": "9962fbb05d2e830b1696977900db84ca", "sha256": "022e57ccb184c104df5e2e7c10e9aef32b7ece22e00bec55f98a16a9e86d7d09" }, "downloads": -1, "filename": "sqlalchemy_lightening-0.1.0.tar.gz", "has_sig": true, "md5_digest": "9962fbb05d2e830b1696977900db84ca", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3052, "upload_time": "2018-02-26T23:52:15", "url": "https://files.pythonhosted.org/packages/24/da/9ca43fa563125a03d81044d6068abd705b47948adfe2e6a307486eb8c25f/sqlalchemy_lightening-0.1.0.tar.gz" } ], "0.1.1": [ { "comment_text": "", "digests": { "md5": "5e9e46d77ad5466a9cf376717316fa35", "sha256": "93647dbca07e4ed32359ffb8216f4a4f120b5383e3dc7f4a7d60e8a9e21d5e6c" }, "downloads": -1, "filename": "sqlalchemy_lightening-0.1.1.tar.gz", "has_sig": true, "md5_digest": "5e9e46d77ad5466a9cf376717316fa35", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3882, "upload_time": "2018-03-06T11:28:28", "url": "https://files.pythonhosted.org/packages/1a/c3/6631ab188ab168d37e2ec9aadcaac33301e855f13f3463ba6ab3e8b285e4/sqlalchemy_lightening-0.1.1.tar.gz" } ], "0.2.0": [ { "comment_text": "", "digests": { "md5": "88fafcbf2c5f6ba3042fc54d59559ce5", "sha256": "3e650abc77f192ae574c6a1b499fb41306cd82e9284137bbf649fbc6e1a4b2ac" }, "downloads": -1, "filename": "sqlalchemy_lightening-0.2.0.tar.gz", "has_sig": true, "md5_digest": "88fafcbf2c5f6ba3042fc54d59559ce5", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4007, "upload_time": "2018-03-14T06:36:29", "url": "https://files.pythonhosted.org/packages/11/a3/c25d4fd30f36586523e9714e8c204452531a47ef2fcb354e9b5b9f58670a/sqlalchemy_lightening-0.2.0.tar.gz" } ], "0.2.1": [ { "comment_text": "", "digests": { "md5": "4503863d1b384d442533a96c2910e006", "sha256": "fc4a050057415418668f4431e605b8724eceb78183cf4c82e431546c0ca1648b" }, "downloads": -1, "filename": "sqlalchemy_lightening-0.2.1.tar.gz", "has_sig": true, "md5_digest": "4503863d1b384d442533a96c2910e006", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4069, "upload_time": "2018-03-21T20:29:34", "url": "https://files.pythonhosted.org/packages/2a/c7/fdb3c61fcba6a5d9621dfbb1bbd078d0abf0b2b1c2a7908224ccad9d84cf/sqlalchemy_lightening-0.2.1.tar.gz" } ], "0.2.2": [ { "comment_text": "", "digests": { "md5": "1bddc689f9b990907f5265d451d65d7e", "sha256": "0d4a510465b569729d5497403793ad59a568b8639394220204b266c71b0d6d62" }, "downloads": -1, "filename": "sqlalchemy_lightening-0.2.2.tar.gz", "has_sig": true, "md5_digest": "1bddc689f9b990907f5265d451d65d7e", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4108, "upload_time": "2018-03-21T21:28:27", "url": "https://files.pythonhosted.org/packages/33/ba/7803df2a6f437fa03d02151f434960a651a3dc9f87bcad7a34e28e45adae/sqlalchemy_lightening-0.2.2.tar.gz" } ], "0.3.0": [ { "comment_text": "", "digests": { "md5": "f6893e589b28a31dfd60fbdf3c2e9c0d", "sha256": "02c587f4418333b1cdff22a736b521469c0e72f6fd53f6a9ccfc3ec0c25ffa24" }, "downloads": -1, "filename": "sqlalchemy_lightening-0.3.0.tar.gz", "has_sig": true, "md5_digest": "f6893e589b28a31dfd60fbdf3c2e9c0d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5196, "upload_time": "2019-04-08T18:47:18", "url": "https://files.pythonhosted.org/packages/a9/55/f5dbc28387e3495ba82f54b5ccd0986cfa11b9b6411dfccfd9b6252cf256/sqlalchemy_lightening-0.3.0.tar.gz" } ], "0.3.1": [ { "comment_text": "", "digests": { "md5": "44675fd0f3c2b88b608bb5550aa7d173", "sha256": "d28c967c076b8face9be0df2ca9741b9eba0a8f257f890fed6a20314e5bf2a44" }, "downloads": -1, "filename": "sqlalchemy_lightening-0.3.1.tar.gz", "has_sig": true, "md5_digest": "44675fd0f3c2b88b608bb5550aa7d173", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5312, "upload_time": "2019-04-16T00:33:30", "url": "https://files.pythonhosted.org/packages/da/a5/2e4b30874e60f9e73c38bfaa9e5fefb81aeb630a017457ba2f68a7b58b6f/sqlalchemy_lightening-0.3.1.tar.gz" } ], "0.3.2": [ { "comment_text": "", "digests": { "md5": "aa4074aa43a0cbf4397ad43330fe2735", "sha256": "3cdc0bcda55ba8f3acffbe653754098335ce067dccc70813010518d3b0a34f9b" }, "downloads": -1, "filename": "sqlalchemy_lightening-0.3.2.tar.gz", "has_sig": true, "md5_digest": "aa4074aa43a0cbf4397ad43330fe2735", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5902, "upload_time": "2019-05-31T23:39:01", "url": "https://files.pythonhosted.org/packages/84/b5/52acc1d8eb329f271ede310f59fdbd6ead592c34408c2d5d1294d029ffe8/sqlalchemy_lightening-0.3.2.tar.gz" } ], "0.3.3": [ { "comment_text": "", "digests": { "md5": "243bb9e56803a35bac9ab20e0225af31", "sha256": "f83a9aed1bb3025dfb4959585d6b270b07414940507fd1c8330a673e4b43a203" }, "downloads": -1, "filename": "sqlalchemy_lightening-0.3.3-py3-none-any.whl", "has_sig": true, "md5_digest": "243bb9e56803a35bac9ab20e0225af31", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 5934, "upload_time": "2019-07-26T21:06:42", "url": "https://files.pythonhosted.org/packages/c6/7e/827b870d9b8f5249b686075e9d59aa0bca24bd205ecc2a18ca29b5ab7dc9/sqlalchemy_lightening-0.3.3-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "400c55c0201995ba3465d66448f221d8", "sha256": "d4b12d26022801df9d09e4b38909a8ff9bbc4516de8d15fe34f3674fe67b89a5" }, "downloads": -1, "filename": "sqlalchemy_lightening-0.3.3.tar.gz", "has_sig": true, "md5_digest": "400c55c0201995ba3465d66448f221d8", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5871, "upload_time": "2019-07-26T21:06:44", "url": "https://files.pythonhosted.org/packages/bf/16/81bc162362cbd4b09242a993e9c5c7763361536ed0a1d6ca6e45d8ba8a02/sqlalchemy_lightening-0.3.3.tar.gz" } ], "0.3.4": [ { "comment_text": "", "digests": { "md5": "951b30f3d3e6943f4d80c4e7233c5bb8", "sha256": "1f799b82ccaebacaa21799e2b8945aecc70c8906aa9c668d975d9b6bad0c59cf" }, "downloads": -1, "filename": "sqlalchemy_lightening-0.3.4-py3-none-any.whl", "has_sig": true, "md5_digest": "951b30f3d3e6943f4d80c4e7233c5bb8", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 7977, "upload_time": "2019-08-27T17:06:14", "url": "https://files.pythonhosted.org/packages/92/a6/cef4b8abc2f2ff5af1ce025a1ea5c50b7c62edc420450da4706488832c7d/sqlalchemy_lightening-0.3.4-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "357c44533fa4efd8689d108057cff936", "sha256": "b88f8ffc4b1a391717766856b361afccf18288e84a1b1818e03d6173ef284191" }, "downloads": -1, "filename": "sqlalchemy_lightening-0.3.4.tar.gz", "has_sig": true, "md5_digest": "357c44533fa4efd8689d108057cff936", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 7468, "upload_time": "2019-08-27T17:06:15", "url": "https://files.pythonhosted.org/packages/23/c7/21d31b6e83634127465d537ce4d95e888bc03cd9ede8f6ee72dae789bcdb/sqlalchemy_lightening-0.3.4.tar.gz" } ], "0.4.0": [ { "comment_text": "", "digests": { "md5": "40400980387149c67534b29afbdb749e", "sha256": "a346141cc41b1422faf0a9a54355637f17b181fc759ef05456c13b8f5377eeff" }, "downloads": -1, "filename": "sqlalchemy_lightening-0.4.0-py3-none-any.whl", "has_sig": true, "md5_digest": "40400980387149c67534b29afbdb749e", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 7928, "upload_time": "2019-08-28T17:55:24", "url": "https://files.pythonhosted.org/packages/3e/95/62dca62f9a7c5ebd4a4bdef1f572d1b021180b3bc882e4dae1ea318454ac/sqlalchemy_lightening-0.4.0-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "fc1c064fff5239a409e6d941746564ff", "sha256": "49d44d35d2289f9142cd82964257d4681e72a865b03a687bd9f84905f91b7832" }, "downloads": -1, "filename": "sqlalchemy_lightening-0.4.0.tar.gz", "has_sig": true, "md5_digest": "fc1c064fff5239a409e6d941746564ff", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 7518, "upload_time": "2019-08-28T17:55:26", "url": "https://files.pythonhosted.org/packages/06/de/89926a11a2eb185649827a57c273bb19a933a0f4c38423c24d07347a2039/sqlalchemy_lightening-0.4.0.tar.gz" } ], "0.4.1": [ { "comment_text": "", "digests": { "md5": "124da7f9258a167b2a35add3696f8e0b", "sha256": "e605d6219a9a99e1f648a9d4fa3644bb3f831eed0aa318d3a62c77f1e03f43d3" }, "downloads": -1, "filename": "sqlalchemy_lightening-0.4.1-py3-none-any.whl", "has_sig": true, "md5_digest": "124da7f9258a167b2a35add3696f8e0b", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 7886, "upload_time": "2019-08-29T00:26:35", "url": "https://files.pythonhosted.org/packages/ff/cc/fae9ee60d963b0dbf9129ca4d557a83259f846d90dc03fb953179e69516a/sqlalchemy_lightening-0.4.1-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "219d1bff315b6ba9cd6248ba5b70cd0f", "sha256": "d96c71ca631af0bb06e5d32514809ae547c86d6ee27f72976352b1c684450bcc" }, "downloads": -1, "filename": "sqlalchemy_lightening-0.4.1.tar.gz", "has_sig": true, "md5_digest": "219d1bff315b6ba9cd6248ba5b70cd0f", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 7513, "upload_time": "2019-08-29T00:26:37", "url": "https://files.pythonhosted.org/packages/49/90/47118d2eb748e1b1ce10e8d1230e3a61077f541b51ab5632e8837b5922d6/sqlalchemy_lightening-0.4.1.tar.gz" } ], "0.4.2": [ { "comment_text": "", "digests": { "md5": "c796d3a108d106443704cfdb9fd3c1ce", "sha256": "a5b062d7695804f9000bc8e3e4c742711d431df8dddc75edd7e0d2370735ed3a" }, "downloads": -1, "filename": "sqlalchemy_lightening-0.4.2-py3-none-any.whl", "has_sig": true, "md5_digest": "c796d3a108d106443704cfdb9fd3c1ce", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 7981, "upload_time": "2019-09-17T01:45:11", "url": "https://files.pythonhosted.org/packages/7e/87/805e4c53c013fd6f644259eab455818dc0fd125ed4b265c789476ae365b2/sqlalchemy_lightening-0.4.2-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "dc4d284f93468f013a3037cd994a2312", "sha256": "1becaf957a9e98cc5595469e7f6ab8deed8f04944cf50f499359d8388d1b3f5a" }, "downloads": -1, "filename": "sqlalchemy_lightening-0.4.2.tar.gz", "has_sig": true, "md5_digest": "dc4d284f93468f013a3037cd994a2312", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 7603, "upload_time": "2019-09-17T01:45:13", "url": "https://files.pythonhosted.org/packages/b2/c6/bc0ba968b6aad2c08eb0e9070db69e7081c5b8d7497f5ca77443ea5833b5/sqlalchemy_lightening-0.4.2.tar.gz" } ], "0.4.3": [ { "comment_text": "", "digests": { "md5": "5e83bb57bfec0a78808219afe9f6854b", "sha256": "41e4933ecdd37c05ec2f3d8f826535f6795d2d8811a9179c13fced7ae2908b14" }, "downloads": -1, "filename": "sqlalchemy_lightening-0.4.3-py3-none-any.whl", "has_sig": true, "md5_digest": "5e83bb57bfec0a78808219afe9f6854b", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 7981, "upload_time": "2019-09-17T20:57:31", "url": "https://files.pythonhosted.org/packages/8d/dd/4e0102f4a5134d4b0758452f620369192689034bf228ebfe7485f1ca88a6/sqlalchemy_lightening-0.4.3-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "aedd066dbc451f7e0550e1ca577f94c0", "sha256": "84cd18b64a94b383e4967f5806484fd868efe77dc7887217233296c0bd756069" }, "downloads": -1, "filename": "sqlalchemy_lightening-0.4.3.tar.gz", "has_sig": true, "md5_digest": "aedd066dbc451f7e0550e1ca577f94c0", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 7631, "upload_time": "2019-09-17T20:57:33", "url": "https://files.pythonhosted.org/packages/d8/c0/d1fc09561b975a8d9a7a77ecb7330dd056fed1c91614ce1a0e16bbec52a5/sqlalchemy_lightening-0.4.3.tar.gz" } ], "0.4.4": [ { "comment_text": "", "digests": { "md5": "463beda4892d4c92b43437ac1fb6073c", "sha256": "a7782e20c9cfecf5c0cb706f43cf463a20a3c3903ddaf95b796ceb1073800cec" }, "downloads": -1, "filename": "sqlalchemy_lightening-0.4.4-py3-none-any.whl", "has_sig": true, "md5_digest": "463beda4892d4c92b43437ac1fb6073c", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 7984, "upload_time": "2019-09-18T23:41:00", "url": "https://files.pythonhosted.org/packages/59/c4/f8566cb57887c409445a31801c984b4998544c41b8a4cec6ec07601ab18d/sqlalchemy_lightening-0.4.4-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "3bc8604a0b0be72ee89491c1e690804d", "sha256": "fb0f058b3b84523b0555f3dbc91949be3ce72f534e9432733f836b1f5f59c085" }, "downloads": -1, "filename": "sqlalchemy_lightening-0.4.4.tar.gz", "has_sig": true, "md5_digest": "3bc8604a0b0be72ee89491c1e690804d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 7649, "upload_time": "2019-09-18T23:41:02", "url": "https://files.pythonhosted.org/packages/67/fd/79cc358a9f138c914f9c008a1f609a3de0546a9b4a75b177be14985a4b16/sqlalchemy_lightening-0.4.4.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "463beda4892d4c92b43437ac1fb6073c", "sha256": "a7782e20c9cfecf5c0cb706f43cf463a20a3c3903ddaf95b796ceb1073800cec" }, "downloads": -1, "filename": "sqlalchemy_lightening-0.4.4-py3-none-any.whl", "has_sig": true, "md5_digest": "463beda4892d4c92b43437ac1fb6073c", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 7984, "upload_time": "2019-09-18T23:41:00", "url": "https://files.pythonhosted.org/packages/59/c4/f8566cb57887c409445a31801c984b4998544c41b8a4cec6ec07601ab18d/sqlalchemy_lightening-0.4.4-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "3bc8604a0b0be72ee89491c1e690804d", "sha256": "fb0f058b3b84523b0555f3dbc91949be3ce72f534e9432733f836b1f5f59c085" }, "downloads": -1, "filename": "sqlalchemy_lightening-0.4.4.tar.gz", "has_sig": true, "md5_digest": "3bc8604a0b0be72ee89491c1e690804d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 7649, "upload_time": "2019-09-18T23:41:02", "url": "https://files.pythonhosted.org/packages/67/fd/79cc358a9f138c914f9c008a1f609a3de0546a9b4a75b177be14985a4b16/sqlalchemy_lightening-0.4.4.tar.gz" } ] }