torhve / amatyr Goto Github PK

Hello - I have been looking at alternatives to weewx and the setup that you have here looks lovely! I am currently running my Davis console into a MySQL DB via weewx running on Linux Mint and would like to couple this with Amatyr. I have some issues, however, I just do not understand your installation instructions - sorry I am a bit of a Linux newb...be gentle :)

Can you provide me with more detailed help about how to install all of the required FrontEnd components step by step and where to source??

Where do I stick the files that I download? Can this be run through Apache which is what I am currently running (apache2).

I don't have an issue/questions with cutting weewx over to postgreSQL.

Many Thanks :)

A bit offtopic. And not trying to start a religious war. But, finding in https://hveem.no/a-modern-IRC-experience things like /script install colorize_nicks.py gives a hope that community hasn't lost a great pythonista in you yet ;-). And we know why people use Lua - because it's small and unbloated, etc. Well, would like to share a revelation that there's now a small unbloated Python3 implementation which might put even Lua into shame (well, we definitely target higher features/size ratio): https://github.com/micropython/micropython . There's web microframework for it at https://github.com/pfalcon/picoweb . Maybe for your next cute hack you could consider them ;-). Thanks!

I have your code plus weewx 3.7.1 installed and everything appears to be working except I appear to not have a dayrain column so error.log is throwing this:

2017/05/26 09:57:11 [error] 26806#0: *219 [lua] api.lua:46: view(): Failed SQL query:        SELECT
            datetime,
			date_trunc('second', age(NOW(), date_trunc('second', datetime))) AS age,
            dayrain        FROM archive        WHERE
        dayrain =
        (
            SELECT
                MIN(dayrain)
            FROM archive            WHERE         (
            datetime BETWEEN CURRENT_DATE            AND
            CURRENT_DATE + INTERVAL '1 DAY'
        )
                    LIMIT 1
        )
        AND         (
            datetime BETWEEN CURRENT_DATE            AND
            CURRENT_DATE + INTERVAL '1 DAY'
        )
                LIMIT 1
        , client: 192.168.211.236, server: localhost, request: "GET /api/record/dayrain/min?start=today HTTP/1.1", host: "weather:8080", referrer: "http://weather:8080/"

Any ideas how to go about fixing this query to work?