Time Series Scaffold

Fill a data table with every time in a sequence. A canonical use is supporting a chart where the x-axis shows a time series, like every month in the last year. Some elements in the series may have no associated rows for us to aggregate, and those elements will be dropped if we use SQL joins naively. If we instead prepopulate an SQL table with all valid x-axis values, a simple join works to cover the full sequence.

Outline Display: Every {{period}} seconds, we overwrite {{table}} with a time sequence following these rules: {{ingredients}}

Local scope

Names introduced within this component’s knobs:

• table – table chosen from the app’s schema (via table knob)
• cur – empty table populated by ingredients

Settings

Required

• table : table
  The table that will be overwritten with the time sequence

Optional

• period : constant value (type: integer; required, non-nullable)
  How long to wait (in seconds) between runs of regenerating the table

• ingredients : ingredient slot of timeSequenceIngredients(cur) (many)
  The sequence of times