Graphics with calculation of data of the database

[Mic G77]

Hello,

i've been looking for a way to produce graph with data calculated from the database.

I Finally find a solution. So I share it with you.

This is an exemple :

        [[[dayPoid]]]
            yscale = None, None, None
            [[[[extraTemp2]]]]
            [[[[extraTest]]]]
                data_type = 18.3+0.03*extraHumid2

In this case, i'm able to see a graph of the function : 18.3 +0.03extraHumid2.

I hope it could help.

[Thomas Keffer]

That is very clever! It occurs to me you could probably combine SQL data types. It doesn’t have to be just one type.

--
You received this message because you are subscribed to the Google Groups "weewx-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to weewx-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/5689249a-ef2b-4c38-ad2a-72a1a2b643dc%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

-tk

[Christian Nimmervoll]

Thanks for posting.
Maybe this will important some day for me.  :)

[Mic G77]

Hello,

Last weekend, I moved from weewx3.8 to weewx4.0 and I'm not any more able to produce graph with data calculated from the database.

If someone can help....

Thank you in advance.

Le mardi 4 juin 2019 23:31:52 UTC+2, Thomas Keffer a écrit :

That is very clever! It occurs to me you could probably combine SQL data types. It doesn’t have to be just one type.

On Tue, Jun 4, 2019 at 1:03 PM Mic G77 <micg...@gmail.com> wrote:

Hello,

i've been looking for a way to produce graph with data calculated from the database.

I Finally find a solution. So I share it with you.

This is an exemple :

        [[[dayPoid]]]
            yscale = None, None, None
            [[[[extraTemp2]]]]
            [[[[extraTest]]]]
                data_type = 18.3+0.03*extraHumid2

In this case, i'm able to see a graph of the function : 18.3 +0.03extraHumid2.

I hope it could help.

--
You received this message because you are subscribed to the Google Groups "weewx-user" group.

To unsubscribe from this group and stop receiving emails from it, send an email to weewx...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/5689249a-ef2b-4c38-ad2a-72a1a2b643dc%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

-tk

[Tom Keffer]

This trick worked by using an expression in the SQL SELECT statement. Unfortunately, that ability got lost in V4.0. 

Nevertheless, there's no good reason why it should not be allowed. Commit e76e374 brings this ability back. Give it a try. Swap your version of xtypes.py (probably located in either /usr/share/weewx/weewx/xtypes.py or /home/weewx/bin/weewx/xtypes.py) with this one. Let me know how it goes.

-tk

To unsubscribe from this group and stop receiving emails from it, send an email to weewx-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/eab7c178-93f5-4ccc-accc-d83c818a285b%40googlegroups.com.

[Mic G77]

Thank you very much for your availability and your  answer

It works !

To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/eab7c178-93f5-4ccc-accc-d83c818a285b%40googlegroups.com.