search

rszimm / sprinklers_pi

Sprinkling System Control Program for the Raspberry Pi
GNU General Public License v2.0
309 stars 100 forks source link

Is there a way to clear log entries? #188

Closed damgut closed 2 years ago

damgut commented 2 years ago

Hi! thank you very much for this great software, I've installed it on a raspberry 3B using a standard GPIO board and everything works perfect! The web interface is very good, simple and intuitive. I've just slightly changed the algorithm to calculate the overall scale to meet better the weather in my zone (Germany)

It would be nice to have a way to remove all the logs entries (or in a period of time) and of course without doing restore factory defaults

Is there a workaround to do that? I've tried sqlite3 /usr/local/etc/sprinklers_pi/db.sql but I couldn't find a way to do it. Can anyone help me? Thanks in advance

nhorvath commented 2 years ago

Stop the sprinklerspi service. Then you should be able to run sqlite commands on the db (make a backup copy first!). The query is DELETE FROM zonelog; which will truncate the table. So run the command: sudo sqlite3 /usr/local/etc/sprinklers_pi/db.sql "DELETE FROM zonelog;" Start the service again.

damgut commented 2 years ago

👍 thanks @nhorvath! The command did what I wanted. Perhaps you can add this hint to the (excellent) documentation already available. You can also consider to add this functionality in the web interface.

poiuztr123 commented 2 years ago

Hi! thank you very much for this great software, I've installed it on a raspberry 3B using a standard GPIO board and everything works perfect! The web interface is very good, simple and intuitive. I've just slightly changed the algorithm to calculate the overall scale to meet better the weather in my zone (Germany)

It would be nice to have a way to remove all the logs entries (or in a period of time) and of course without doing restore factory defaults

Is there a workaround to do that? I've tried sqlite3 /usr/local/etc/sprinklers_pi/db.sql but I couldn't find a way to do it. Can anyone help me? Thanks in advance

Hi damgut. I am interested in your modifications to the algorithm for the overall scale for the weather in Germany. Would you mind to share your modification? I also realized that under cold conditions the scale seems to drop a little bit too much in the german weather zone. Not sure where this topic would fit best.

damgut commented 2 years ago

@poiuztr123: exactly! the low temperature limit is quite low for Germany (where 15 C is normal average temperature. :cold_sweat: ) . I'm also ignoring humidity.

I've started with my tests a couple of days ago (I haven't even installed the controller) so it is a beginning of fine tuning. You can see my changes in this branch:

https://github.com/rszimm/sprinklers_pi/compare/master...damgut:adjust_weather

nhorvath commented 2 years ago

https://github.com/rszimm/sprinklers_pi/wiki/File-locations#clearing-zone-log

If you want to continue a thread on weather adjustment improvements for cold climates please open a new issue with an appropriate subject.

damgut commented 2 years ago

:+1: Thank you very much for extending the doc!!!

ThomasDtz commented 1 year ago

Hi , i am just as Interesses in the modified algorithm of the Werther calculation

Thomas from Germany

Von meinem iPad gesendet

Am 25.05.2022 um 12:54 schrieb poiuztr123 @.***>:  Hi! thank you very much for this great software, I've installed it on a raspberry 3B using a standard GPIO board and everything works perfect! The web interface is very good, simple and intuitive. I've just slightly changed the algorithm to calculate the overall scale to meet better the weather in my zone (Germany)

It would be nice to have a way to remove all the logs entries (or in a period of time) and of course without doing restore factory defaults

Is there a workaround to do that? I've tried sqlite3 /usr/local/etc/sprinklers_pi/db.sql but I couldn't find a way to do it. Can anyone help me? Thanks in advance

Hi damgut. I am interested in your modifications to the algorithm for the overall scale for the weather in Germany. Would you mind to share your modification? I also realized that under cold conditions the scale seems to drop a little bit too much in the german weather zone. Not sure where this topic would fit best.

— Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you are subscribed to this thread.