echo ".schema" | sqlite3 mydatabasename.sdb or look at https://github.com/weewx/weewx/blob/master/bin/schemas/wview_extended.py for the default schema for current v4 weewx.
On Thursday, February 25, 2021 at 1:48:45 PM UTC-8 [email protected] wrote: > Looking through both SQLite and Weewx documentation, i can't find a > reference to a tool or report that will take a existing SQLdb and display > the underlying DB's structure? I can see that wee-debug will give a listing > of fields and key's, but there's no references to the relationships > established for the exiting db. I ask because i'd like to understand how > the existing data maintains keys. i.e., if data is stored with the only > primary key as epoch time, can weewx manage joined keys of epoch+Device-ID? > That would allow me to store multiple occurrences of epochDT, but different > devices. that would allow me to store data from devices as raw data and > data from WF (or other weather services) corrected data concurrently. It > would also solve the often-mentioned "What's raw data and what has WF > 'conditioned' data in my SQLdb?" issues. > /David > > -- 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/8085ba4b-1f3a-42d8-9881-4d082fd7cb52n%40googlegroups.com.
