On Sunday, January 12, 2020 at 2:43:48 PM UTC-8, KnC Mc wrote: > > I have some weird reporting while executing wee_reports, and trying to > decipher sqlite archive data... I am running v3.8.0 and trying to generate > html with cheetah generate with the Standard Template using wee_reports; I > can see that the from logs that the data is being imported from WU, but the > data appears to have different data (float, and long?) being populated in > the database. My graphs being generated have gaps, and I think it is > because of the long data? Is this supposed to populate like this? Is some > of this cause by the missing_calc=True switch? It seems when the long data > is present the graphs do not generate? Any thoughts? > > The schema dictates the data type, which by default is REAL everywhere basically. I'm guessing you're seeing 29.945 and thinking it's a different data type than 29.500001324567 perhaps (?)
To see the schema, try: echo ".schema" | sqlite3 /home/weewx/archive/weewx.sdb | grep "TABLE archive" (or substitute in the path to your weewx.sdb if you used a pre-packaged weewx or if you put your db in an unusual place) -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/5540892e-cef3-4e28-9672-dd1f4245196b%40googlegroups.com.
