{
"info": {
"author": "Michel Nemnom",
"author_email": "michel.nemnom+pypi@gmail.com",
"bugtrack_url": null,
"classifiers": [
"Development Status :: 5 - Production/Stable",
"Environment :: Web Environment",
"Framework :: Flask",
"Framework :: Pyramid",
"Intended Audience :: Developers",
"License :: OSI Approved :: MIT License",
"Natural Language :: English",
"Operating System :: OS Independent",
"Programming Language :: Python",
"Programming Language :: Python :: 3",
"Topic :: Internet :: WWW/HTTP",
"Topic :: Software Development :: Libraries",
"Topic :: Software Development :: Libraries :: Python Modules"
],
"description": "======================\nsqlalchemy-datatables\n======================\n\n|Build Status| |PyPi Version| |Scrutinizer| |Coverage|\n\n.. |Build Status| image:: https://travis-ci.org/Pegase745/sqlalchemy-datatables.svg?branch=master\n :target: https://travis-ci.org/Pegase745/sqlalchemy-datatables\n\n.. |PyPi Version| image:: https://badge.fury.io/py/sqlalchemy-datatables.svg\n :target: https://pypi.python.org/pypi/sqlalchemy-datatables/\n\n.. |Scrutinizer| image:: https://scrutinizer-ci.com/g/Pegase745/sqlalchemy-datatables/badges/quality-score.png\n :target: https://scrutinizer-ci.com/g/Pegase745/sqlalchemy-datatables/\n\n.. |Coverage| image:: https://codecov.io/gh/Pegase745/sqlalchemy-datatables/branch/master/graph/badge.svg\n :target: https://codecov.io/gh/Pegase745/sqlalchemy-datatables\n\nsqlalchemy-datatables is a framework agnostic library providing an `SQLAlchemy `_ integration of jQuery `DataTables `_ >= 1.10, and helping you manage server side requests in your application.\n\nInstallation\n------------\n\n**To install via pip:**\n\n*Python 3*\n\n.. code-block:: bash\n\n $ pip3 install sqlalchemy-datatables\n\n**To install from source:**\n\n.. code-block:: bash\n\n $ git clone git@github.com:Pegase745/sqlalchemy-datatables.git\n $ cd sqlalchemy-datatables\n $ pip3 install .\n\n**To contribute:**\n\n.. code-block:: bash\n\n In a virtualenv\n $ git clone git@github.com:Pegase745/sqlalchemy-datatables.git\n $ cd sqlalchemy-datatables\n $ make all\n\nUsage\n-----\n\n.. code-block:: python\n\n @view_config(route_name='data', renderer='json')\n def data(request):\n \"\"\"Return server side data.\"\"\"\n # defining columns\n # - explicitly cast date to string, so string searching the date\n # will search a date formatted equal to how it is presented\n # in the table\n columns = [\n ColumnDT(User.id),\n ColumnDT(User.name),\n ColumnDT(Address.description),\n ColumnDT(func.strftime('%d-%m-%Y', User.birthday)),\n ColumnDT(User.age)\n ]\n\n # defining the initial query depending on your purpose\n # - don't include any columns\n # - if you need a join, also include a 'select_from'\n query = DBSession.query().\\\n select_from(User).\\\n join(Address).\\\n filter(Address.id > 4)\n\n # instantiating a DataTable for the query and table needed\n rowTable = DataTables(request.GET, query, columns)\n\n # returns what is needed by DataTable\n return rowTable.output_result()\n\nExamples\n--------\n\nYou can find working examples `in the repository `_, including an integration with the `yadcf `_ plugin:\n\n- `Pyramid example `_\n- `Flask example `_\n\nChangelog\n---------\n\nAll notable changes to this project will be documented in `this section `_.\n\nThis project adheres to `Semantic Versioning `_ and `Keep A Changelog `_.\n\nLicense\n-------\n\nThe project is licensed under the MIT license.",
"description_content_type": "",
"docs_url": null,
"download_url": "",
"downloads": {
"last_day": -1,
"last_month": -1,
"last_week": -1
},
"home_page": "https://github.com/pegase745/sqlalchemy-datatables",
"keywords": "sqlalchemy datatables jquery pyramid flask dt1.10",
"license": "MIT",
"maintainer": "",
"maintainer_email": "",
"name": "sqlalchemy-datatables",
"package_url": "https://pypi.org/project/sqlalchemy-datatables/",
"platform": "",
"project_url": "https://pypi.org/project/sqlalchemy-datatables/",
"project_urls": {
"Homepage": "https://github.com/pegase745/sqlalchemy-datatables"
},
"release_url": "https://pypi.org/project/sqlalchemy-datatables/2.0.1/",
"requires_dist": null,
"requires_python": "",
"summary": "SQLAlchemy integration of jQuery DataTables",
"version": "2.0.1"
},
"last_serial": 4988225,
"releases": {
"0.1.0": [
{
"comment_text": "",
"digests": {
"md5": "1933caa62e6099476e90adbe01fabf81",
"sha256": "f67c361f8b1676b016a8b4aef7a700c8671a415a940fe5a1f754f407ecb7cad7"
},
"downloads": -1,
"filename": "sqlalchemy-datatables-0.1.0.tar.gz",
"has_sig": false,
"md5_digest": "1933caa62e6099476e90adbe01fabf81",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 4801,
"upload_time": "2013-08-11T14:52:26",
"url": "https://files.pythonhosted.org/packages/b3/d7/9be2199601c9758b28d713e758ba7ef20fc7502d27384b344285a1029d38/sqlalchemy-datatables-0.1.0.tar.gz"
}
],
"0.1.1": [
{
"comment_text": "",
"digests": {
"md5": "7e0ef10e3d161c40e2f4b817dfeb08b1",
"sha256": "cd2efe5524a60041983e693016f4b332847f89c886d014983dd8ad354a81f407"
},
"downloads": -1,
"filename": "sqlalchemy-datatables-0.1.1.tar.gz",
"has_sig": false,
"md5_digest": "7e0ef10e3d161c40e2f4b817dfeb08b1",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 4961,
"upload_time": "2013-08-12T15:26:01",
"url": "https://files.pythonhosted.org/packages/be/9d/6e3e113a20daeebe8fd6be99276067157d03810a9709a662617c922e07ac/sqlalchemy-datatables-0.1.1.tar.gz"
}
],
"0.1.2": [
{
"comment_text": "",
"digests": {
"md5": "632ea1bafb07d779c16b8cd7a50c88a8",
"sha256": "17205b859f1ab6859822487e03d7173be4c2e96e26597d1d5c0f86df4256c080"
},
"downloads": -1,
"filename": "sqlalchemy-datatables-0.1.2.tar.gz",
"has_sig": false,
"md5_digest": "632ea1bafb07d779c16b8cd7a50c88a8",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 5529,
"upload_time": "2013-08-13T16:15:21",
"url": "https://files.pythonhosted.org/packages/5f/05/e94164cc2886abacbaff8265a61ce69c008fcd0d63c0b8f985c8995fce53/sqlalchemy-datatables-0.1.2.tar.gz"
}
],
"0.1.3": [
{
"comment_text": "",
"digests": {
"md5": "5ec586a7f8786b834431ab8bfd8a0e9d",
"sha256": "e5758d3c7cb40f3f852edbcf4cb1dd0958b44420c0cae594219006dc388ed11c"
},
"downloads": -1,
"filename": "sqlalchemy-datatables-0.1.3.tar.gz",
"has_sig": false,
"md5_digest": "5ec586a7f8786b834431ab8bfd8a0e9d",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 3600,
"upload_time": "2013-09-16T08:16:01",
"url": "https://files.pythonhosted.org/packages/6a/83/e3fae041e5dc86a793f93acc9821a687db4fd980934b07bd28202e0b6728/sqlalchemy-datatables-0.1.3.tar.gz"
}
],
"0.1.4": [
{
"comment_text": "",
"digests": {
"md5": "7a37c5a10c6bfa48a00358ec6742c688",
"sha256": "c9e0ab88d41e74509365a5a2f5cc3a89108fc7eaea99d292679a4c373e3cd880"
},
"downloads": -1,
"filename": "sqlalchemy-datatables-0.1.4.tar.gz",
"has_sig": false,
"md5_digest": "7a37c5a10c6bfa48a00358ec6742c688",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 3811,
"upload_time": "2013-09-17T12:57:40",
"url": "https://files.pythonhosted.org/packages/b3/1d/983d0fc192a780cf5edbcef784c9788a878e91e23a613e23f23ad91aa88c/sqlalchemy-datatables-0.1.4.tar.gz"
}
],
"0.1.5": [
{
"comment_text": "",
"digests": {
"md5": "7bcf10bd9eab125bc12057ff8ecfd12a",
"sha256": "ad5e0f6277374edbaa54de94e9a78e5fa981b6792805d66ecb348b4e1c451065"
},
"downloads": -1,
"filename": "sqlalchemy-datatables-0.1.5.tar.gz",
"has_sig": false,
"md5_digest": "7bcf10bd9eab125bc12057ff8ecfd12a",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 6572,
"upload_time": "2013-10-18T14:18:12",
"url": "https://files.pythonhosted.org/packages/01/6f/b48c7e7ab8f384a8687cc3b4414ac39ce72ccf2244acda4c7bb4725c3bda/sqlalchemy-datatables-0.1.5.tar.gz"
}
],
"0.1.6": [
{
"comment_text": "",
"digests": {
"md5": "565ccc333c1acb8bb49ea1d2de966841",
"sha256": "3bf3297363899f64e8c0751474c2f680c3983f1065b08011bd17b31bcf283d72"
},
"downloads": -1,
"filename": "sqlalchemy-datatables-0.1.6.tar.gz",
"has_sig": false,
"md5_digest": "565ccc333c1acb8bb49ea1d2de966841",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 6771,
"upload_time": "2013-12-16T11:27:03",
"url": "https://files.pythonhosted.org/packages/f3/b6/40e75bcef62d4bc92d2b3f33eef65a6d84723dd2f0862a88788a4cca9fe6/sqlalchemy-datatables-0.1.6.tar.gz"
}
],
"0.1.7": [
{
"comment_text": "",
"digests": {
"md5": "065e1d1a32d80f19bd49c0e58f1c34a7",
"sha256": "73f99f6e15d37c9129e7e243d2afab50a6e355ffbc0fcdf9222f8e38bace2fe7"
},
"downloads": -1,
"filename": "sqlalchemy-datatables-0.1.7.tar.gz",
"has_sig": false,
"md5_digest": "065e1d1a32d80f19bd49c0e58f1c34a7",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 8260,
"upload_time": "2015-10-16T07:44:17",
"url": "https://files.pythonhosted.org/packages/84/be/4c772a972c4d807179979914b3c3157b148df640d2702e4c02a677bf00e0/sqlalchemy-datatables-0.1.7.tar.gz"
}
],
"0.2.0": [
{
"comment_text": "",
"digests": {
"md5": "e408d1130c10491438009e8a3f06e443",
"sha256": "a8ecaf29576c312ea37a0f34f26c3c3e69479e4da9789dff4795ec36664d6aa6"
},
"downloads": -1,
"filename": "sqlalchemy-datatables-0.2.0.tar.gz",
"has_sig": false,
"md5_digest": "e408d1130c10491438009e8a3f06e443",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 9325,
"upload_time": "2015-12-06T14:12:24",
"url": "https://files.pythonhosted.org/packages/b1/b1/4a214f7032a129e243a5335b454541018f9bddd2959226d6bf95b89f67f8/sqlalchemy-datatables-0.2.0.tar.gz"
}
],
"0.2.1": [
{
"comment_text": "",
"digests": {
"md5": "9a3fd2d7f088cbcab447910a66ed56bd",
"sha256": "7dc50280e87b5fdaab018cef048373763da326b046e88f3ab62e10a7ddf6ac49"
},
"downloads": -1,
"filename": "sqlalchemy-datatables-0.2.1.tar.gz",
"has_sig": false,
"md5_digest": "9a3fd2d7f088cbcab447910a66ed56bd",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 9464,
"upload_time": "2016-01-08T19:32:56",
"url": "https://files.pythonhosted.org/packages/54/51/b8890bb78fead4ec62f140af865d6a193e4c014a8c0328c450d8f6e753bf/sqlalchemy-datatables-0.2.1.tar.gz"
}
],
"0.3.0": [
{
"comment_text": "",
"digests": {
"md5": "c79ba42e7cf6298ca168e91bdc2bfadc",
"sha256": "479d1aa0e63870e011dc651ad67c0bb52108ef55270e32474a86775d2edba923"
},
"downloads": -1,
"filename": "sqlalchemy-datatables-0.3.0.tar.gz",
"has_sig": false,
"md5_digest": "c79ba42e7cf6298ca168e91bdc2bfadc",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 9939,
"upload_time": "2016-04-10T21:44:51",
"url": "https://files.pythonhosted.org/packages/0f/63/1f42a9fe534aab1df6d7c901a18904404d19af038cadd681b4d2d793b11f/sqlalchemy-datatables-0.3.0.tar.gz"
}
],
"0.4.0": [
{
"comment_text": "",
"digests": {
"md5": "5385c0c7d11428d9d83b2584bf0f454b",
"sha256": "54971d7534d2b8a617c73e6982a9c737bef943b473191fe6bd1885cc09804364"
},
"downloads": -1,
"filename": "sqlalchemy-datatables-0.4.0.tar.gz",
"has_sig": false,
"md5_digest": "5385c0c7d11428d9d83b2584bf0f454b",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 10865,
"upload_time": "2016-05-05T10:46:53",
"url": "https://files.pythonhosted.org/packages/eb/81/8173fbfb8db0234aba320f49c092f5a12b60bb4a31b3c7bc5971b515d5fd/sqlalchemy-datatables-0.4.0.tar.gz"
}
],
"1.0.0": [
{
"comment_text": "",
"digests": {
"md5": "7dd8fa9becf6924284117817c6cff7dd",
"sha256": "ccc7a4abd93af093c4b12d2f5307301f7b3504458b976a3d74b19cadcac3b03e"
},
"downloads": -1,
"filename": "sqlalchemy-datatables-1.0.0.tar.gz",
"has_sig": false,
"md5_digest": "7dd8fa9becf6924284117817c6cff7dd",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 11815,
"upload_time": "2016-12-06T12:23:33",
"url": "https://files.pythonhosted.org/packages/bd/67/2fcfb8e70d7a32a7029a4906d59b15ee212e709452a9fa87531d9895f056/sqlalchemy-datatables-1.0.0.tar.gz"
}
],
"1.1.0": [
{
"comment_text": "",
"digests": {
"md5": "7bbda014e52b7cb9134f1e7ba2a69d42",
"sha256": "ec09a5df36dfa9810fcc6cc39b10bc8ffde6ec3c68a7e88c6893a20842ac591a"
},
"downloads": -1,
"filename": "sqlalchemy-datatables-1.1.0.tar.gz",
"has_sig": false,
"md5_digest": "7bbda014e52b7cb9134f1e7ba2a69d42",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 11946,
"upload_time": "2016-12-06T16:34:27",
"url": "https://files.pythonhosted.org/packages/a8/57/95404eff7cadf42647d243d0e40ab767129a73d08909e27d0e79a431832b/sqlalchemy-datatables-1.1.0.tar.gz"
}
],
"1.2.0": [
{
"comment_text": "",
"digests": {
"md5": "5d1f4ff4f7d5f423e2c6509209c5fe32",
"sha256": "db0e37d213e61f2fefa999e0e1b180160df22ee28765d4ebe563840be8bdef71"
},
"downloads": -1,
"filename": "sqlalchemy-datatables-1.2.0.tar.gz",
"has_sig": false,
"md5_digest": "5d1f4ff4f7d5f423e2c6509209c5fe32",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 11784,
"upload_time": "2016-12-08T12:43:00",
"url": "https://files.pythonhosted.org/packages/df/97/fa5a8c4f7bf3067bcffac5a151ceca746365da2f951a074bd37b689440d5/sqlalchemy-datatables-1.2.0.tar.gz"
}
],
"2.0.0": [
{
"comment_text": "",
"digests": {
"md5": "5db1be3ee04de56cd698692b30192a2b",
"sha256": "6354aa992509c9aefe2846700bb0ad45060d723c6f3dd00e516b422c31e480d2"
},
"downloads": -1,
"filename": "sqlalchemy-datatables-2.0.0.tar.gz",
"has_sig": false,
"md5_digest": "5db1be3ee04de56cd698692b30192a2b",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 8941,
"upload_time": "2019-03-24T13:59:09",
"url": "https://files.pythonhosted.org/packages/8f/ce/d4553753d7558a09a4553ff04cd18a5bf2e68cad05cd3cc21d05eabc81e7/sqlalchemy-datatables-2.0.0.tar.gz"
}
],
"2.0.1": [
{
"comment_text": "",
"digests": {
"md5": "b2591d6d786ba1aff2f643b6ab014763",
"sha256": "a46e7aa26a1ce6fc291d9c81408d28957362695aacc4ec12054eeeb0fa27bd68"
},
"downloads": -1,
"filename": "sqlalchemy-datatables-2.0.1.tar.gz",
"has_sig": false,
"md5_digest": "b2591d6d786ba1aff2f643b6ab014763",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 12948,
"upload_time": "2019-03-26T15:37:57",
"url": "https://files.pythonhosted.org/packages/f1/59/ddb629c570f4645d532d7dd8b0d36c6901eb15c368304bd33b5728c46d3b/sqlalchemy-datatables-2.0.1.tar.gz"
}
]
},
"urls": [
{
"comment_text": "",
"digests": {
"md5": "b2591d6d786ba1aff2f643b6ab014763",
"sha256": "a46e7aa26a1ce6fc291d9c81408d28957362695aacc4ec12054eeeb0fa27bd68"
},
"downloads": -1,
"filename": "sqlalchemy-datatables-2.0.1.tar.gz",
"has_sig": false,
"md5_digest": "b2591d6d786ba1aff2f643b6ab014763",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 12948,
"upload_time": "2019-03-26T15:37:57",
"url": "https://files.pythonhosted.org/packages/f1/59/ddb629c570f4645d532d7dd8b0d36c6901eb15c368304bd33b5728c46d3b/sqlalchemy-datatables-2.0.1.tar.gz"
}
]
}