New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Store daily, weekly, monthly and yearly statistics #3
Comments
Original comment by Dennis Siemensma (Bitbucket: dennissiemensma, GitHub: dennissiemensma): Ik heb het compacten in ieder geval, voor electriciteit, nu op minuut-basis ipv seconde-basis. Hiervoor mag een extra argument meegegeven worden aan het compacter-command + een (handmatige) call met --purge. Dit is in ieder geval al een voorzet voor bovenstaande, diepgaandere statistieken. |
Original comment by Dennis Siemensma (Bitbucket: dennissiemensma, GitHub: dennissiemensma): The source data should just be the daily consumption, stored in the database, while having trends plot out of them. |
Original comment by Dennis Siemensma (Bitbucket: dennissiemensma, GitHub: dennissiemensma): ElectricityStatistics should focus on usage only. Other data, such as long_power_failure_count, should be read from the last telegram reading anyway. ElectricityStatistics is just an expensive caching mechanism, now. |
Original comment by Dennis Siemensma (Bitbucket: dennissiemensma, GitHub: dennissiemensma): This will also greatly speed up the rendering of the history page. |
Original comment by Dennis Siemensma (Bitbucket: dennissiemensma, GitHub: dennissiemensma): Hmm I want this but only since Django 1.9: https://docs.djangoproject.com/en/dev/ref/models/querysets/#date |
Original comment by Dennis Siemensma (Bitbucket: dennissiemensma, GitHub: dennissiemensma): Django 1.9 seems to run fine, but I do not want to switch yet, as 1.8 is LTS. |
Original comment by Dennis Siemensma (Bitbucket: dennissiemensma, GitHub: dennissiemensma): Made quite some progress, tomorrow GUI I hope. |
Original comment by Dennis Siemensma (Bitbucket: dennissiemensma, GitHub: dennissiemensma): Merged into default! Rolling to production here before marking stable. |
Original comment by Dennis Siemensma (Bitbucket: dennissiemensma, GitHub: dennissiemensma): @JeroenPeters ook deze change is klaar en voegt eindelijk heel wat visuele dingen toe!
Voor het uitrollen is het wel handig om even je compactor/backend proces uit te zetten. Statistieken over alle gemeten dagen worden namelijk herberekend in de migratie (duurde bij mij ongeveer een minuut). Check ook even of je management commands in supervisnor nog bijgewerkt moeten worden (qua config). Dit is bij de vorige grote refactoreslag ook veranderd, maar ze zijn deprecated (nog) compatible. Deze processen zijn alleen nodig:
|
Merge with f8e9d284a27bb3e39e35ec36b6ad50c93bd564ad
Originally reported by: Dennis Siemensma (Bitbucket: dennissiemensma, GitHub: dennissiemensma)
The current compactor only compact gas each hour and electricity each reading (~ 10 seconds).
In order to support statistics and graphs on daily, weekly, monthly and yearly basis we should make another compactor.
To keep things separated, we might have to rename the existing compactor to something similar as 'extractor'.
The text was updated successfully, but these errors were encountered: