{ "info": { "author": "Bulat Gaifullin", "author_email": "gaifullinbf@gmail.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 4 - Beta", "Environment :: Other Environment", "License :: OSI Approved :: MIT License", "Operating System :: MacOS :: MacOS X", "Operating System :: OS Independent", "Operating System :: POSIX", "Operating System :: POSIX :: Linux", "Operating System :: Unix", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.3", "Programming Language :: Python :: 3.4", "Topic :: Database", "Topic :: Database :: Database Engines/Servers" ], "description": "WSQL-SDK\n========\n.. image:: https://travis-ci.org/WebSQL/sdk.svg?branch=master\n :target: https://travis-ci.org/WebSQL/sdk\n\n.. image:: https://coveralls.io/repos/WebSQL/sdk/badge.png?branch=master\n :target: https://coveralls.io/r/WebSQL/sdk?branch=master\n\nThe chain of tools that make work with SQL procedures easier.\n\nSyntax\n******\n* *#include \"\"* - include the specified filename, the absolute and relative urls supported.\n* *#define name * - specify the value, that can be used as *$name*\n* *#define name(arg1, ..., argN)* - the function, that can be used as *$name(a1,...aN)*\n* *#undef name* - undefine previously defined instruction\n* *#if condition expression else alternative* - conditional expressions\n* *SELECT ... ; -- > array* - hint, that informs about query returns more that one element\n* *SELECT ... ; -- > object* - hint, that informs about query returns exactly one element\n* *COMMENT \"returns union\"* - hint, to merge all objects from results sets to one\n* *COMMENT \" (,...);\"* - hint, that allow to pass the list of arguments to procedure via temporary table\n\nwsql-trans:\n-----------\nThe extensions above native SQL.\n\nsupports:\n#########\n\n* macros\n\n.. code-block::\n \n #define table_name \"mytable\"\n select * from $table_name;\n\n\n* macro-functions\n\n.. code-block:: sql\n\n #define quote(a) \"a\"\n select upper(quote(a));\n\n \n* conditions\n\n.. code-block:: sql\n\n #define a 1\n #if a == 1\n select * from t1;\n #else\n select * from t2;\n #endif\n\n* includes\n\n.. code-block:: sql\n\n #include \"common.sql\"\n\nwsql-codegen:\n-------------\n\nGenerate the native code to work with SQL procedures.\nNow supports python3 native and aio.\nThe C++ under development.\nRequired `WSQL`_.\n\nHints\n#####\n* *SELECT ... ; -- > array* - hint, that informs about query returns more that one element\n* *SELECT ... ; -- > object* - hint, that informs about query returns exactly one element\n* *COMMENT \"returns union\"* - hint, to merge all objects from results sets to one\n* *COMMENT \"
(,...);\"* - hint, that allow to pass the list of arguments to procedure via temporary table\n\n\nSQL\n###\n.. code-block:: sql\n\n CREATE PROCEDURE table1.insert (value VARCHAR(10))\n BEGIN\n INSERT INTO table1 (value) VALUES(value);\n SELECT LAST_INSERT_ID() AS id;\n END\n\nPython3\n#######\n\n.. code-block:: python\n\n @coroutine\n def insert(connection, value=None):\n \"\"\"\n insert, table1\n :param value: the value(VARCHAR(10), IN))\n :return (id,)\n \"\"\"\n @coroutine\n def __query(__connection):\n __cursor = __connection.cursor()\n try:\n yield from __cursor.callproc(b\"procedure4\", (value,))\n return (yield from __cursor.fetchall())[0]\n finally:\n yield from __cursor.close()\n try:\n return (yield from connection.execute(__query))\n except Error as e:\n raise handle_error(exceptions, e)\n\n\n.. _`WSQL`: http://www.mysql.com/", "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/WebSQL/sdk", "keywords": null, "license": "MIT", "maintainer": null, "maintainer_email": null, "name": "wsql_sdk", "package_url": "https://pypi.org/project/wsql_sdk/", "platform": "UNKNOWN", "project_url": "https://pypi.org/project/wsql_sdk/", "project_urls": { "Download": "UNKNOWN", "Homepage": "https://github.com/WebSQL/sdk" }, "release_url": "https://pypi.org/project/wsql_sdk/0.3.17/", "requires_dist": null, "requires_python": null, "summary": "The chain of tools, that to make work with SQL easier", "version": "0.3.17" }, "last_serial": 2031295, "releases": { "0.2.2": [ { "comment_text": "", "digests": { "md5": "2d02e7301bae5b0a1ae46b77238bc090", "sha256": "bd648f43e9edb71df099d0615d343161bf5d1f4620cc2c94d4ea0ae7b256ee9e" }, "downloads": -1, "filename": "wsql_sdk-0.2.2.tar.gz", "has_sig": false, "md5_digest": "2d02e7301bae5b0a1ae46b77238bc090", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 630613, "upload_time": "2015-06-28T13:55:56", "url": "https://files.pythonhosted.org/packages/93/ed/515abcc3d41a7a897ef331ffe22b24e025754d9c75814413632512bc1a6a/wsql_sdk-0.2.2.tar.gz" } ], "0.2.4": [ { "comment_text": "", "digests": { "md5": "cbc4874095a3ee77b136ca9891cba059", "sha256": "5e17cc0fa66b39b573552f2971ed2aace9f733b72ee5a2835a0be5223c85d67c" }, "downloads": -1, "filename": "wsql_sdk-0.2.4.tar.gz", "has_sig": false, "md5_digest": "cbc4874095a3ee77b136ca9891cba059", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 631031, "upload_time": "2015-07-09T20:14:00", "url": "https://files.pythonhosted.org/packages/0f/db/de8642acbc1e318875e9d4c25f7b490118e94a036b56f63659209adbb327/wsql_sdk-0.2.4.tar.gz" } ], "0.3.1": [ { "comment_text": "", "digests": { "md5": "9eea80909f76cd7d309edf292f672777", "sha256": "b7e5e4e0f0782ffeba9842351a7ccea2366b3cd02fd8a51939fe925c2c251b8d" }, "downloads": -1, "filename": "wsql_sdk-0.3.1.tar.gz", "has_sig": false, "md5_digest": "9eea80909f76cd7d309edf292f672777", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 632311, "upload_time": "2015-07-10T20:54:46", "url": "https://files.pythonhosted.org/packages/6d/57/8d577bece08205706802161207ecefaf28be06524d17b76eb512294b1853/wsql_sdk-0.3.1.tar.gz" } ], "0.3.10": [], "0.3.11": [ { "comment_text": "", "digests": { "md5": "461f683cfc70117d6ef03cd0f2758581", "sha256": "6583f264ee06ffa5dd571c94cde0acf7dd48afe826f5c7d47fe064664925047e" }, "downloads": -1, "filename": "wsql_sdk-0.3.11.tar.gz", "has_sig": false, "md5_digest": "461f683cfc70117d6ef03cd0f2758581", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 633143, "upload_time": "2016-01-08T10:42:02", "url": "https://files.pythonhosted.org/packages/d1/03/fcc7b0745025ec261e6f3912aa873401f562650cec0b21297cde7902c1c7/wsql_sdk-0.3.11.tar.gz" } ], "0.3.12": [ { "comment_text": "", "digests": { "md5": "949f4b8ce85a4d4ea2655f91e876a8b8", "sha256": "301f366bedb942cea1a9a4d3029c80e41e6f8a6eb1d73d7b000e77e572ed5dbf" }, "downloads": -1, "filename": "wsql_sdk-0.3.12.tar.gz", "has_sig": false, "md5_digest": "949f4b8ce85a4d4ea2655f91e876a8b8", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 633127, "upload_time": "2016-01-09T20:15:43", "url": "https://files.pythonhosted.org/packages/ec/00/3edd763a7b85fce86fbcb1cc5b99bccaf45c2ad959c8482abe88e3b3678f/wsql_sdk-0.3.12.tar.gz" } ], "0.3.13": [ { "comment_text": "", "digests": { "md5": "72fcb121b83120767990c9ffb53a3372", "sha256": "a121350f4ac0efaf496692bb3ae3dcf90d6981a7902c9db0a7383577e9d4ec7c" }, "downloads": -1, "filename": "wsql_sdk-0.3.13.tar.gz", "has_sig": false, "md5_digest": "72fcb121b83120767990c9ffb53a3372", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 633181, "upload_time": "2016-02-08T10:18:32", "url": "https://files.pythonhosted.org/packages/76/b0/b55ad6ea8ba72a7c34b275b91e59dd390d42965ad168d59256d61696bd6c/wsql_sdk-0.3.13.tar.gz" } ], "0.3.14": [ { "comment_text": "", "digests": { "md5": "0bf0ca1da2735d05fe5d22418e779c70", "sha256": "c9244e7600b7ef95936f4cb99096888994b6051d5605c85f3d3b2f259c0fcbc7" }, "downloads": -1, "filename": "wsql_sdk-0.3.14.tar.gz", "has_sig": false, "md5_digest": "0bf0ca1da2735d05fe5d22418e779c70", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 633196, "upload_time": "2016-02-08T10:32:19", "url": "https://files.pythonhosted.org/packages/6c/9b/6e06c17395065cec6b8ca1aa987e140269a3d45de04b17f3e00a574ccf14/wsql_sdk-0.3.14.tar.gz" } ], "0.3.15": [ { "comment_text": "", "digests": { "md5": "9129c2c991f0b6384d80d020bf73363f", "sha256": "caccc22551cbe6f64478590763c09a21d188288f87250f243a2eafc4f4cc35d9" }, "downloads": -1, "filename": "wsql_sdk-0.3.15.tar.gz", "has_sig": false, "md5_digest": "9129c2c991f0b6384d80d020bf73363f", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 633220, "upload_time": "2016-02-14T23:23:27", "url": "https://files.pythonhosted.org/packages/31/37/eb492188d7304da3e5945b389ba52e77dba2c223354f736fe6018de17909/wsql_sdk-0.3.15.tar.gz" } ], "0.3.16": [ { "comment_text": "", "digests": { "md5": "5e61544560df1a52baea28c728c06e7b", "sha256": "427d5def37f569f72aa4d70cfc99cd81d85cfbc999ffa988d2fb0131894ba392" }, "downloads": -1, "filename": "wsql_sdk-0.3.16.tar.gz", "has_sig": false, "md5_digest": "5e61544560df1a52baea28c728c06e7b", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 633203, "upload_time": "2016-02-26T16:11:37", "url": "https://files.pythonhosted.org/packages/ff/7f/b7c244b032ab79c847b8f5a3104f9e81b97adb826f8da8118e8b76e977d4/wsql_sdk-0.3.16.tar.gz" } ], "0.3.17": [ { "comment_text": "", "digests": { "md5": "44c843d478e61f0cf3f46e16229dd882", "sha256": "8d31148bc59eedc4bb23fb0c92fc066c3e0ac1d09ca4a77917b1e42f512ed771" }, "downloads": -1, "filename": "wsql_sdk-0.3.17.tar.gz", "has_sig": false, "md5_digest": "44c843d478e61f0cf3f46e16229dd882", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 633203, "upload_time": "2016-03-28T10:28:24", "url": "https://files.pythonhosted.org/packages/83/c2/d7fb36dee4f45e55671a25c2fbdc777acdc2f303f215d1d635a33b53ec53/wsql_sdk-0.3.17.tar.gz" } ], "0.3.2": [ { "comment_text": "", "digests": { "md5": "f6d790cf06e6b4d90c92596e130b3c74", "sha256": "1328524591e10f866881c7c3248b2651d48be63bfd74333ad9d55eba6c29aa84" }, "downloads": -1, "filename": "wsql_sdk-0.3.2.tar.gz", "has_sig": false, "md5_digest": "f6d790cf06e6b4d90c92596e130b3c74", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 632583, "upload_time": "2015-07-12T21:22:28", "url": "https://files.pythonhosted.org/packages/56/50/279ac120ccd3f9efbe09177c21d1cdd7bf09b77ba822223a66ea2351efb5/wsql_sdk-0.3.2.tar.gz" } ], "0.3.3": [ { "comment_text": "", "digests": { "md5": "573dbbbcfbfb766ac602226b7b431c5b", "sha256": "0c2513f47cdbf48f406ff28ab3dd3623e13b22cd968aa29c0be7efb3e4096334" }, "downloads": -1, "filename": "wsql_sdk-0.3.3.tar.gz", "has_sig": false, "md5_digest": "573dbbbcfbfb766ac602226b7b431c5b", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 632577, "upload_time": "2015-07-13T19:31:04", "url": "https://files.pythonhosted.org/packages/2f/45/0e20477dac0cbc4d2573f0758b7a155445793307c07edbd9248bf35f69cc/wsql_sdk-0.3.3.tar.gz" } ], "0.3.4": [ { "comment_text": "", "digests": { "md5": "b6382c3dce023ba58722b317691a82e8", "sha256": "869bc5711e669a9ac19166f00ac6521a985a2c307ec3e7619f6ca3f8dc0a18aa" }, "downloads": -1, "filename": "wsql_sdk-0.3.4.tar.gz", "has_sig": false, "md5_digest": "b6382c3dce023ba58722b317691a82e8", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 632585, "upload_time": "2015-07-23T06:08:41", "url": "https://files.pythonhosted.org/packages/6a/af/231949d96fda6faf8d95d0122db7b184cb4f7fce75846066a80c17b8b07f/wsql_sdk-0.3.4.tar.gz" } ], "0.3.5": [ { "comment_text": "", "digests": { "md5": "01969a395cad75b00dca3ed4b5e8b362", "sha256": "76db797c0b47308bc98835dc52c9e2629a7bb8257a710529b33e55c6615cb896" }, "downloads": -1, "filename": "wsql_sdk-0.3.5.tar.gz", "has_sig": false, "md5_digest": "01969a395cad75b00dca3ed4b5e8b362", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 632588, "upload_time": "2015-07-23T16:17:19", "url": "https://files.pythonhosted.org/packages/8c/ed/8975c733ee4851226eedf5ca2763429357ac559d7073de9f0b244aa3cfdd/wsql_sdk-0.3.5.tar.gz" } ], "0.3.6": [ { "comment_text": "", "digests": { "md5": "c34e29d91ec73f4e71709be2de789e99", "sha256": "9b2b3644544e104676ace1f9aa030baabdb9d432e560712404a8b8b991a526fe" }, "downloads": -1, "filename": "wsql_sdk-0.3.6.tar.gz", "has_sig": false, "md5_digest": "c34e29d91ec73f4e71709be2de789e99", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 632835, "upload_time": "2015-12-20T20:41:09", "url": "https://files.pythonhosted.org/packages/ca/d4/51f76fc407aa5b4f97dd648681fe46b76bd41f46f33dc340213d597a3bb8/wsql_sdk-0.3.6.tar.gz" } ], "0.3.7": [ { "comment_text": "", "digests": { "md5": "28484c70bf55eddc5f34bf94ed3ed47a", "sha256": "124c01ad17c769661b76311b5932aebdf65d5a018b564907ecd2bf47f097d80a" }, "downloads": -1, "filename": "wsql_sdk-0.3.7.tar.gz", "has_sig": false, "md5_digest": "28484c70bf55eddc5f34bf94ed3ed47a", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 632871, "upload_time": "2015-12-20T23:35:12", "url": "https://files.pythonhosted.org/packages/77/0f/344addd30251114af7773f690e5659f5af0da621a8f0ec20cbc7f7a945ee/wsql_sdk-0.3.7.tar.gz" } ], "0.3.8": [ { "comment_text": "", "digests": { "md5": "9a9f4391c55dbafc6c91d8a0261ad810", "sha256": "5a2a9d8b11370d67228bb0997159ed8e020dc176f241993c41926e3b8d12fb91" }, "downloads": -1, "filename": "wsql_sdk-0.3.8.tar.gz", "has_sig": false, "md5_digest": "9a9f4391c55dbafc6c91d8a0261ad810", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 633120, "upload_time": "2016-01-01T22:05:21", "url": "https://files.pythonhosted.org/packages/84/06/7976cdb8ed3df7a91efdee5968014977a70b1fc4aceb2879ea2265eb1c89/wsql_sdk-0.3.8.tar.gz" } ], "0.3.9": [ { "comment_text": "", "digests": { "md5": "7fa31cee27c0d1cb326c5e67afcaac4a", "sha256": "f881c3174bd74bc48c65fea835a5ab402ba9b918d0e0838dc2b16086d20aa81a" }, "downloads": -1, "filename": "wsql_sdk-0.3.9.tar.gz", "has_sig": false, "md5_digest": "7fa31cee27c0d1cb326c5e67afcaac4a", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 633121, "upload_time": "2016-01-07T16:18:46", "url": "https://files.pythonhosted.org/packages/e0/f8/d4a70b88746ab3877adb46de5c9dceb2cc8462d64661babf7436906ccdaf/wsql_sdk-0.3.9.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "44c843d478e61f0cf3f46e16229dd882", "sha256": "8d31148bc59eedc4bb23fb0c92fc066c3e0ac1d09ca4a77917b1e42f512ed771" }, "downloads": -1, "filename": "wsql_sdk-0.3.17.tar.gz", "has_sig": false, "md5_digest": "44c843d478e61f0cf3f46e16229dd882", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 633203, "upload_time": "2016-03-28T10:28:24", "url": "https://files.pythonhosted.org/packages/83/c2/d7fb36dee4f45e55671a25c2fbdc777acdc2f303f215d1d635a33b53ec53/wsql_sdk-0.3.17.tar.gz" } ] }