{ "info": { "author": "Alex Gaynor and David Reid", "author_email": "", "bugtrack_url": null, "classifiers": [], "description": "alchimia\n========\n\n``alchimia`` lets you use most of the SQLAlchemy-core API with Twisted, it does\nnot allow you to use the ORM.\n\nGetting started\n---------------\n\n.. code:: python\n\n from alchimia import wrap_engine\n\n from sqlalchemy import (\n create_engine, MetaData, Table, Column, Integer, String\n )\n from sqlalchemy.schema import CreateTable\n\n from twisted.internet.defer import inlineCallbacks\n from twisted.internet.task import react\n\n\n @inlineCallbacks\n def main(reactor):\n engine = wrap_engine(reactor, create_engine(\"sqlite://\"))\n\n metadata = MetaData()\n users = Table(\"users\", metadata,\n Column(\"id\", Integer(), primary_key=True),\n Column(\"name\", String()),\n )\n\n # Create the table\n yield engine.execute(CreateTable(users))\n\n # Insert some users\n yield engine.execute(users.insert().values(name=\"Jeremy Goodwin\"))\n yield engine.execute(users.insert().values(name=\"Natalie Hurley\"))\n yield engine.execute(users.insert().values(name=\"Dan Rydell\"))\n yield engine.execute(users.insert().values(name=\"Casey McCall\"))\n yield engine.execute(users.insert().values(name=\"Dana Whitaker\"))\n\n result = yield engine.execute(users.select(users.c.name.startswith(\"D\")))\n d_users = yield result.fetchall()\n # Print out the users\n for user in d_users:\n print(\"Username: %s\" % user[users.c.name])\n\t# Queries that return results should be explicitly closed to\n\t# release the connection\n result.close()\n\n if __name__ == \"__main__\":\n react(main, [])\n\nDocumentation\n-------------\n\nThe documentation is all on `Read the Docs`_.\n\n.. _`Read the Docs`: https://alchimia.readthedocs.io/\n\nLimitations\n-----------\n\nThere are some limitations to ``alchimia's`` ability to expose the SQLAlchemy\nAPI.\n\n* Some methods simply haven't been implemented yet. If you file a bug, we'll\n implement them! See ``CONTRIBUTING.rst`` for more info.\n* Some methods in SQLAlchemy either have no return value, or don't have a\n return value we can control. Since most of the ``alchimia`` API is predicated\n on returning ``Deferred`` instances which fire with the underlying SQLAlchemy\n instances, it is impossible for us to wrap these methods in a useful way.\n Luckily, many of these methods have alternate spelling. `The docs`_ call these\n out in more detail.\n\n.. _`The docs`: https://alchimia.readthedocs.io/en/latest/limitations/\n\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/alex/alchimia", "keywords": "", "license": "", "maintainer": "", "maintainer_email": "", "name": "alchimia", "package_url": "https://pypi.org/project/alchimia/", "platform": "", "project_url": "https://pypi.org/project/alchimia/", "project_urls": { "Homepage": "https://github.com/alex/alchimia" }, "release_url": "https://pypi.org/project/alchimia/0.8.1/", "requires_dist": [ "twisted", "sqlalchemy" ], "requires_python": "", "summary": "(SQLAlchemy - ORM) + Twisted = win", "version": "0.8.1" }, "last_serial": 3680379, "releases": { "0.1-dev": [ { "comment_text": "", "digests": { "md5": "dd93d41893eb1212bfe271b3c53b170e", "sha256": "046b67eab7f88f2455211a3b371ec3e27af1ac1c431566c6756c9beacffa13fe" }, "downloads": -1, "filename": "alchimia-0.1_dev-py2.py3-none-any.whl", "has_sig": true, "md5_digest": "dd93d41893eb1212bfe271b3c53b170e", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 3128, "upload_time": "2013-09-07T00:02:42", "url": "https://files.pythonhosted.org/packages/b6/89/e3b461fea6860fac1c8f75722e00105050dfdd3a7f65531203594f5e6a14/alchimia-0.1_dev-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "b0a8836cc9cfbbf7659382f7be17f926", "sha256": "db8f04de325d3aba5b221233f61f836ffd75ba65afbc429fc382a38dde447ee1" }, "downloads": -1, "filename": "alchimia-0.1-dev.tar.gz", "has_sig": true, "md5_digest": "b0a8836cc9cfbbf7659382f7be17f926", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2787, "upload_time": "2013-09-07T00:01:47", "url": "https://files.pythonhosted.org/packages/ba/a3/5303ddad40f416945db874e9897e8f7717ffe14459c7720ccb0292a91f61/alchimia-0.1-dev.tar.gz" } ], "0.2-dev": [ { "comment_text": "", "digests": { "md5": "7967439f58c7d21855b4fdc45730345c", "sha256": "8216b9a65c63555d2cb78514bddaae3bfbda7ac7448f3d9c952b3baf3f5814ac" }, "downloads": -1, "filename": "alchimia-0.2_dev-py2.py3-none-any.whl", "has_sig": true, "md5_digest": "7967439f58c7d21855b4fdc45730345c", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 4996, "upload_time": "2013-09-07T00:04:45", "url": "https://files.pythonhosted.org/packages/0d/b9/a346be42d50cb9d63665b596262c08cf4608ead62349b9295c87a758f2ae/alchimia-0.2_dev-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "6de51d022d45d649f4d3c5e7d4aba96a", "sha256": "544d3d23871495ed24638cd37e714e97cb601842d64476b9596db49aeaaa6385" }, "downloads": -1, "filename": "alchimia-0.2-dev.tar.gz", "has_sig": true, "md5_digest": "6de51d022d45d649f4d3c5e7d4aba96a", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3083, "upload_time": "2013-09-07T00:04:26", "url": "https://files.pythonhosted.org/packages/b2/ff/14818eef6550449f0a41f1a3eec7af4e81f2deac42ee442b874a6de6f31f/alchimia-0.2-dev.tar.gz" } ], "0.3-dev": [ { "comment_text": "", "digests": { "md5": "221b491a3b7807681aebbc3a7d477720", "sha256": "b33d03c16794a3e69eba787ad7c432f4b771c136c54201a42fc5c4b2400ef848" }, "downloads": -1, "filename": "alchimia-0.3_dev-py2.py3-none-any.whl", "has_sig": true, "md5_digest": "221b491a3b7807681aebbc3a7d477720", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 5237, "upload_time": "2013-09-17T19:22:50", "url": "https://files.pythonhosted.org/packages/9c/41/a258efaa767f59053d0011361b3d37538fef32a672dc10dd40f6c5d831f9/alchimia-0.3_dev-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "088d5230bd2ac8d73a08c54f6b82dfe2", "sha256": "574ef9c7c55e1d7871edab7c70142901c5168fa9512f0a00ce5859f6b190dba0" }, "downloads": -1, "filename": "alchimia-0.3-dev.tar.gz", "has_sig": true, "md5_digest": "088d5230bd2ac8d73a08c54f6b82dfe2", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3275, "upload_time": "2013-09-17T19:22:27", "url": "https://files.pythonhosted.org/packages/48/50/8ffe36d5f5d25a22765b0c6f5ccd1af1b91c132405079ff70d7415c66e10/alchimia-0.3-dev.tar.gz" } ], "0.4": [ { "comment_text": "", "digests": { "md5": "350c5ad42ec193b87d6f55c9599b7ff0", "sha256": "1e2d72d5625ea5975b08631eba7b538446704dc184d65c76362c857a7979c4e8" }, "downloads": -1, "filename": "alchimia-0.4-py2.py3-none-any.whl", "has_sig": true, "md5_digest": "350c5ad42ec193b87d6f55c9599b7ff0", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 5346, "upload_time": "2013-10-07T14:23:47", "url": "https://files.pythonhosted.org/packages/06/5e/fe7f25423e7b95f350c7380059a9fc8d5e9f55176e4d8067d5bcd76617d7/alchimia-0.4-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "5464e9a342d53fc1807891770f2bfe90", "sha256": "fb407a2894e3d07e6d71672819a95c1492799c6819eab54e0a4d444939f29ef0" }, "downloads": -1, "filename": "alchimia-0.4.tar.gz", "has_sig": true, "md5_digest": "5464e9a342d53fc1807891770f2bfe90", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 17490, "upload_time": "2013-10-07T14:23:54", "url": "https://files.pythonhosted.org/packages/71/cd/5f8606bfcab7c0b3b00cfce1d9cf6836026e99a596ace1c3fd703d778a76/alchimia-0.4.tar.gz" } ], "0.5.0": [ { "comment_text": "", "digests": { "md5": "214b18c2e81332aff799d3318da53aca", "sha256": "cbf193c8c8c2ed2d07e91c73cee22daab8d54c558e360703c70f8a8f45343036" }, "downloads": -1, "filename": "alchimia-0.5.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "214b18c2e81332aff799d3318da53aca", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 5653, "upload_time": "2015-05-15T18:12:54", "url": "https://files.pythonhosted.org/packages/a4/23/d0a2038fd1f2d6654a98c55000ee782464e544b9747425e5d0b5cce9ceaa/alchimia-0.5.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "186d6b8f15561cf9b187c4627ce881a4", "sha256": "88a8d80b5ebfa021c36afb8f302b1d66fa1c2f2c0d54e5a6810425fa791468bf" }, "downloads": -1, "filename": "alchimia-0.5.0.tar.gz", "has_sig": false, "md5_digest": "186d6b8f15561cf9b187c4627ce881a4", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 14361, "upload_time": "2015-05-15T18:12:57", "url": "https://files.pythonhosted.org/packages/3d/19/356bf7965fd4cbb72c202a5999ce6713f142661fb3f401e0f1641ff42651/alchimia-0.5.0.tar.gz" } ], "0.6.0": [ { "comment_text": "", "digests": { "md5": "8cc50d0c86639dd36dea19fcd9f4e7af", "sha256": "d9c0dc57f2846e661b4b2a2c4b50d60a42e7b8ed869e85ff44eb93a62265ff62" }, "downloads": -1, "filename": "alchimia-0.6.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "8cc50d0c86639dd36dea19fcd9f4e7af", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 5682, "upload_time": "2015-05-26T18:40:15", "url": "https://files.pythonhosted.org/packages/43/4d/f952a5d0bf4bb3ad58eda045445995fcc6970b97991e89b3ff01bc932bf5/alchimia-0.6.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "8f1a97b8e36b596bec19632f27c6900d", "sha256": "eb30521e70a2c808b9aa6f69723d6bc6fb5a88151d279a06cde9c44c036e476b" }, "downloads": -1, "filename": "alchimia-0.6.0.tar.gz", "has_sig": false, "md5_digest": "8f1a97b8e36b596bec19632f27c6900d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 14541, "upload_time": "2015-05-26T18:40:19", "url": "https://files.pythonhosted.org/packages/b3/d5/5022f1f5e332006967bee17651b2f709e0c6a569c8d41d9427e65b41e2b7/alchimia-0.6.0.tar.gz" } ], "0.6.1": [ { "comment_text": "", "digests": { "md5": "0baae6a7fd3f77c8cdb0229eac179c27", "sha256": "5f4ba9a97009065e7bcc2a5c0c572b81c38d85d3c2d9782499d2616986295c47" }, "downloads": -1, "filename": "alchimia-0.6.1-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "0baae6a7fd3f77c8cdb0229eac179c27", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 5684, "upload_time": "2015-05-26T18:41:37", "url": "https://files.pythonhosted.org/packages/bf/30/e505e18a891c2be14d0c6439ba3faba56c7b9ff34702db5f4d87eaf84d6a/alchimia-0.6.1-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "fa452aad6bf7f005c2b057d9bb9fd923", "sha256": "9919046fe1940f7fc98ab31cb546acdc51c1271221d6e0608e9b2708b7e0ce9d" }, "downloads": -1, "filename": "alchimia-0.6.1.tar.gz", "has_sig": false, "md5_digest": "fa452aad6bf7f005c2b057d9bb9fd923", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 14546, "upload_time": "2015-05-26T18:41:41", "url": "https://files.pythonhosted.org/packages/ef/44/5650735fe3d05114197279da4dcd95b878d3c9eab0c0730d6f54937d496e/alchimia-0.6.1.tar.gz" } ], "0.7.0": [ { "comment_text": "", "digests": { "md5": "8e266cdf3fdded7e6295740dfffab19d", "sha256": "5eff0380a69f8e83d1fe291022db7bbd0108c943dd3e05721e876f5da734bb9d" }, "downloads": -1, "filename": "alchimia-0.7.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "8e266cdf3fdded7e6295740dfffab19d", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 6159, "upload_time": "2016-10-04T22:10:10", "url": "https://files.pythonhosted.org/packages/90/c5/6878e3318b990920952cbfdd6dfdfd53ad3d8f75217e4be3b1c73db3fc9b/alchimia-0.7.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "487cecd011b7cd9a4cf041d8c7790ce9", "sha256": "7e659356231b420a750828aa7133c78fffc7ded8d1b23f22bbfc877419772fda" }, "downloads": -1, "filename": "alchimia-0.7.0.tar.gz", "has_sig": false, "md5_digest": "487cecd011b7cd9a4cf041d8c7790ce9", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 15143, "upload_time": "2016-10-04T22:10:12", "url": "https://files.pythonhosted.org/packages/12/5b/09184196224617fd3b60fdfcf68f3bbad034ec50615b7b12a94fbf941012/alchimia-0.7.0.tar.gz" } ], "0.8.0": [ { "comment_text": "", "digests": { "md5": "228debaee9ce021a5c92644c1bf80141", "sha256": "9cc2a6e546667b5e6c2d9d4135cff52bfd61e36303e4f7dd609951907a4434c0" }, "downloads": -1, "filename": "alchimia-0.8.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "228debaee9ce021a5c92644c1bf80141", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 6352, "upload_time": "2018-03-18T06:34:31", "url": "https://files.pythonhosted.org/packages/f4/90/50a9f561adf2ce90ce78b3093f54dc401a8d76ad63b870cf83ec04885ff5/alchimia-0.8.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "a0cebd35928d770cafb20cece5355870", "sha256": "69956e03e62b3bbc342b4c63f54f5acbb69802347dcbca7cab36f2d319a866f0" }, "downloads": -1, "filename": "alchimia-0.8.0.tar.gz", "has_sig": false, "md5_digest": "a0cebd35928d770cafb20cece5355870", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 18334, "upload_time": "2018-03-18T06:34:32", "url": "https://files.pythonhosted.org/packages/81/c3/c8d10c263c1668a210ac4724b67ccec1b15a4db9a4b9e7896abd238ffbf1/alchimia-0.8.0.tar.gz" } ], "0.8.1": [ { "comment_text": "", "digests": { "md5": "24dec430e26c1b98d4dc1a30f1ff2f1a", "sha256": "161ebe7076d8b5feda728df7128b2f5aea1d26d9b67cf33212ebaaeb26cff1b7" }, "downloads": -1, "filename": "alchimia-0.8.1-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "24dec430e26c1b98d4dc1a30f1ff2f1a", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 6466, "upload_time": "2018-03-18T06:45:31", "url": "https://files.pythonhosted.org/packages/d2/41/7bf9f947d845318d0c8603c98e8dfae39151398793d5bb46ad9757139062/alchimia-0.8.1-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "e03d07a46e8bcd88ad1c7c05988f1f0f", "sha256": "c41b42e629ff8139b64dd28341704bdd5734be28d87b3e46259241f8b0173b8a" }, "downloads": -1, "filename": "alchimia-0.8.1.tar.gz", "has_sig": false, "md5_digest": "e03d07a46e8bcd88ad1c7c05988f1f0f", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 18407, "upload_time": "2018-03-18T06:45:33", "url": "https://files.pythonhosted.org/packages/d9/86/c63b218ad606a5538cbd777c0b926467e849e87b92cc863039843ebdc75c/alchimia-0.8.1.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "24dec430e26c1b98d4dc1a30f1ff2f1a", "sha256": "161ebe7076d8b5feda728df7128b2f5aea1d26d9b67cf33212ebaaeb26cff1b7" }, "downloads": -1, "filename": "alchimia-0.8.1-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "24dec430e26c1b98d4dc1a30f1ff2f1a", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 6466, "upload_time": "2018-03-18T06:45:31", "url": "https://files.pythonhosted.org/packages/d2/41/7bf9f947d845318d0c8603c98e8dfae39151398793d5bb46ad9757139062/alchimia-0.8.1-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "e03d07a46e8bcd88ad1c7c05988f1f0f", "sha256": "c41b42e629ff8139b64dd28341704bdd5734be28d87b3e46259241f8b0173b8a" }, "downloads": -1, "filename": "alchimia-0.8.1.tar.gz", "has_sig": false, "md5_digest": "e03d07a46e8bcd88ad1c7c05988f1f0f", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 18407, "upload_time": "2018-03-18T06:45:33", "url": "https://files.pythonhosted.org/packages/d9/86/c63b218ad606a5538cbd777c0b926467e849e87b92cc863039843ebdc75c/alchimia-0.8.1.tar.gz" } ] }