Typically, this is used to calculate the number of days of precipitation
greater than some amount during a time span, using the daily summaries. The
parameter %(val)s is the value.
In retrospect, the choice of column names in the daily summaries may not
have been a good one. The values "sum" in the expression "SUM(sum>90)"
represent two different things. The first sum ("SUM") is an aggregation,
the second sum ("sum") is a column name.
Perhaps you can escape the inner "sum"?
-tk
On Thu, Dec 21, 2023 at 10:12 PM Raoul Snyman <[email protected]>
wrote:
> I've been going through the queries in xtypes.py, and I've come across
> some queries that don't make sense to me, and definitely throw errors in
> PostgreSQL.
>
> For example:
>
> SELECT SUM(sum >= %(val)s) FROM %(table_name)s_day_%(obs_key)s WHERE
> dateTime >= %(start)s AND dateTime < %(stop)s
>
> SUM(sum >= 90) is not valid in PostgreSQL. Can you tell me what this is
> supposed to be doing, then perhaps I can translate the SQL into something
> that's more generic?
>
> Thanks!
>
> On Tuesday, December 12, 2023 at 3:27:19 PM UTC Raoul Snyman wrote:
>
>> On Tuesday, December 12, 2023 at 2:15:31 PM UTC matthew wall wrote:
>>
>> On Monday, December 11, 2023 at 11:47:04 PM UTC-5 Raoul Snyman wrote:
>>
>> I still don't have the tests running properly, I couldn't find any docs
>> on exactly how to set up the tests, and both the MySQL and PostgreSQL tests
>> fail when I just run "make test"
>>
>>
>> i am working on the unit tests. when we started them we just used python
>> directly. i am converting all of it to pytest.
>>
>> i would like to have the pytest conversion done when v5 comes out of
>> beta, but it might happen soon after that.
>>
>> the core in v5 is pretty solid, but we're still taking care of some
>> packaging and integration bits
>>
>>
>> Oh cool, that's good to know. I've used pytest fairly extensively, it's a
>> good test framework.
>>
>>
>>
> --
> You received this message because you are subscribed to the Google Groups
> "weewx-development" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/weewx-development/b298f3e6-ead9-4c5a-8458-d204cb0ac03dn%40googlegroups.com
> <https://groups.google.com/d/msgid/weewx-development/b298f3e6-ead9-4c5a-8458-d204cb0ac03dn%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>
--
You received this message because you are subscribed to the Google Groups
"weewx-development" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/weewx-development/CAPq0zEByGhvKrOfbPw5M7%3D3FnHEaVv29F5xiVZ_UojV0Ekq6Ew%40mail.gmail.com.
