canned-views


Namecanned-views JSON
Version 0.1.8 PyPI version JSON
download
home_pagehttps://github.com/erikvw/canned-views
SummarySQL views presented as simple Django ListView reports
upload_time2023-08-06 22:56:49
maintainer
docs_urlNone
authorErik van Widenfelt
requires_python>=3.11
licenseGPL license, see LICENSE
keywords django sql view listview clinicedc clinical trials
VCS
bugtrack_url
requirements No requirements were recorded.
Travis-CI No Travis.
coveralls test coverage
            Canned Views
------------

Views, as in SQL views.

SQL views presented as simple Django ListView reports rendered by DataTables.

Overview
========

The online report renders from the results of an SQL VIEW using ``DataTables``.

* Each report is defined in the model ``CannedViews``;
* The SQL VIEW must exist in the DB and the name must be prefixed with ``canned_``;
* The rendered report is limited to 500 records for now. If the query returns more than 500 records, the report will only render the first 500 in the order of the query;
* You can specify one column to render as a hyperlink. In almost all cases this will be the ``subject_identifier`` column.

Rendering one column as a url
=============================

To reverse a url, include the columns by name separated by commas in the ``reverse_url_args`` column. It is up to you to ensure that the ``reverse_url_name`` is valid and in the global dictionary ```url_names```.


            

Raw data

            {
    "_id": null,
    "home_page": "https://github.com/erikvw/canned-views",
    "name": "canned-views",
    "maintainer": "",
    "docs_url": null,
    "requires_python": ">=3.11",
    "maintainer_email": "",
    "keywords": "django sql view ListView,clinicedc,clinical trials",
    "author": "Erik van Widenfelt",
    "author_email": "ew2789@gmail.com",
    "download_url": "https://files.pythonhosted.org/packages/b8/bd/cf262cc24a0ce4e11fa0a8f2e49b8e7938732ca29800f973b1116268206b/canned-views-0.1.8.tar.gz",
    "platform": null,
    "description": "Canned Views\n------------\n\nViews, as in SQL views.\n\nSQL views presented as simple Django ListView reports rendered by DataTables.\n\nOverview\n========\n\nThe online report renders from the results of an SQL VIEW using ``DataTables``.\n\n* Each report is defined in the model ``CannedViews``;\n* The SQL VIEW must exist in the DB and the name must be prefixed with ``canned_``;\n* The rendered report is limited to 500 records for now. If the query returns more than 500 records, the report will only render the first 500 in the order of the query;\n* You can specify one column to render as a hyperlink. In almost all cases this will be the ``subject_identifier`` column.\n\nRendering one column as a url\n=============================\n\nTo reverse a url, include the columns by name separated by commas in the ``reverse_url_args`` column. It is up to you to ensure that the ``reverse_url_name`` is valid and in the global dictionary ```url_names```.\n\n",
    "bugtrack_url": null,
    "license": "GPL license, see LICENSE",
    "summary": "SQL views presented as simple Django ListView reports",
    "version": "0.1.8",
    "project_urls": {
        "Homepage": "https://github.com/erikvw/canned-views"
    },
    "split_keywords": [
        "django sql view listview",
        "clinicedc",
        "clinical trials"
    ],
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "11caf0eeb0384737a509fb8766ede64c68241b97199c8ff71b755f623d4fec0b",
                "md5": "902438a3b7c5409ed69984abff3687ee",
                "sha256": "8bb276b554cd68a50bbc68e4278a6f277cacc40e9cb42c03ea783a5fb60b3908"
            },
            "downloads": -1,
            "filename": "canned_views-0.1.8-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "902438a3b7c5409ed69984abff3687ee",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": ">=3.11",
            "size": 42728,
            "upload_time": "2023-08-06T22:56:48",
            "upload_time_iso_8601": "2023-08-06T22:56:48.075781Z",
            "url": "https://files.pythonhosted.org/packages/11/ca/f0eeb0384737a509fb8766ede64c68241b97199c8ff71b755f623d4fec0b/canned_views-0.1.8-py3-none-any.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "b8bdcf262cc24a0ce4e11fa0a8f2e49b8e7938732ca29800f973b1116268206b",
                "md5": "ed06dced6a618c72a94426fb73358eed",
                "sha256": "fba41b52c0a78702a88bc43ae9bc5098af72aa3231f118c3dde756d218a635fa"
            },
            "downloads": -1,
            "filename": "canned-views-0.1.8.tar.gz",
            "has_sig": false,
            "md5_digest": "ed06dced6a618c72a94426fb73358eed",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": ">=3.11",
            "size": 35574,
            "upload_time": "2023-08-06T22:56:49",
            "upload_time_iso_8601": "2023-08-06T22:56:49.256431Z",
            "url": "https://files.pythonhosted.org/packages/b8/bd/cf262cc24a0ce4e11fa0a8f2e49b8e7938732ca29800f973b1116268206b/canned-views-0.1.8.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2023-08-06 22:56:49",
    "github": true,
    "gitlab": false,
    "bitbucket": false,
    "codeberg": false,
    "github_user": "erikvw",
    "github_project": "canned-views",
    "travis_ci": false,
    "coveralls": true,
    "github_actions": true,
    "lcname": "canned-views"
}
        
Elapsed time: 0.55391s