django-postgres-refresher

Name	django-postgres-refresher JSON
Version	1.0.0 JSON
	download
home_page
Summary	postgres `REFRESH MATVIEW` manager
upload_time	2023-09-24 14:12:02
maintainer
docs_url	None
author
requires_python
license
keywords	django postgres
VCS
bugtrack_url
requirements	No requirements were recorded.
Travis-CI	No Travis.
coveralls test coverage	No coveralls.

            ### Installation
```bash
$ pip install django-postgres-refresher
```

#### `settings.py`
```python
INSTALLED_APPS+=['django_postgres_refresher']
```

#### `migrate`
```bash
$ python manage.py migrate
```

### Features
+   admin interface
+   refresh reports (`duration`,`time`) and stat (`count`,`avg_duration`,`min_duration`,`max_duration`)

### Examples
refresh matviews
```bash
python manage.py postgres_refresher
```

`INSERT` to `postgres_refresher_config`
```sql
INSERT INTO postgres_refresher_config(schemaname,matviewname,"concurrently",seconds)
VALUES
('schemaname','matviewname',true,600),
('schemaname','matviewname2',true,600)
ON CONFLICT(schemaname,matviewname) DO NOTHING;
```



            

Raw data

            {
    "_id": null,
    "home_page": "",
    "name": "django-postgres-refresher",
    "maintainer": "",
    "docs_url": null,
    "requires_python": "",
    "maintainer_email": "",
    "keywords": "django,postgres",
    "author": "",
    "author_email": "",
    "download_url": "https://files.pythonhosted.org/packages/0a/df/d94e8a3a9346748356f2bebf99c724dd637f0983c9e845680a0b52682dee/django-postgres-refresher-1.0.0.tar.gz",
    "platform": null,
    "description": "### Installation\n```bash\n$ pip install django-postgres-refresher\n```\n\n#### `settings.py`\n```python\nINSTALLED_APPS+=['django_postgres_refresher']\n```\n\n#### `migrate`\n```bash\n$ python manage.py migrate\n```\n\n### Features\n+   admin interface\n+   refresh reports (`duration`,`time`) and stat (`count`,`avg_duration`,`min_duration`,`max_duration`)\n\n### Examples\nrefresh matviews\n```bash\npython manage.py postgres_refresher\n```\n\n`INSERT` to `postgres_refresher_config`\n```sql\nINSERT INTO postgres_refresher_config(schemaname,matviewname,\"concurrently\",seconds)\nVALUES\n('schemaname','matviewname',true,600),\n('schemaname','matviewname2',true,600)\nON CONFLICT(schemaname,matviewname) DO NOTHING;\n```\n\n\n",
    "bugtrack_url": null,
    "license": "",
    "summary": "postgres `REFRESH MATVIEW` manager",
    "version": "1.0.0",
    "project_urls": null,
    "split_keywords": [
        "django",
        "postgres"
    ],
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "0adfd94e8a3a9346748356f2bebf99c724dd637f0983c9e845680a0b52682dee",
                "md5": "25eafd9298faa7e774eb5ee4c2d324c1",
                "sha256": "5cb681a42e5e1b4f5378fe7b44d490c33f0aea67ae4f0d79a9f08d0fe90d8024"
            },
            "downloads": -1,
            "filename": "django-postgres-refresher-1.0.0.tar.gz",
            "has_sig": false,
            "md5_digest": "25eafd9298faa7e774eb5ee4c2d324c1",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 4426,
            "upload_time": "2023-09-24T14:12:02",
            "upload_time_iso_8601": "2023-09-24T14:12:02.630900Z",
            "url": "https://files.pythonhosted.org/packages/0a/df/d94e8a3a9346748356f2bebf99c724dd637f0983c9e845680a0b52682dee/django-postgres-refresher-1.0.0.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2023-09-24 14:12:02",
    "github": false,
    "gitlab": false,
    "bitbucket": false,
    "codeberg": false,
    "lcname": "django-postgres-refresher"
}