Contents

# filename: daily_summary.sql
owner: jackdanger
schedule: hourly
requires:
  - daily_payments
  - hourly_users
  - some_other_value
environments:
  production:
    output_table: summaries
    update_condition:
  development:
    output_table: jackdanger_summaries
    update_condition: WHERE 1 <> 1
---
INSERT INTO {{{output_table}}} -- this query is joined to one line
  SELECT COUNT(*)
  FROM interesting_information; -- and the comments get stripped
UPDATE summaries_performed SET complete = 1 {{{update_condition}}};

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
hsql-0.4.1	examples/simple.sql
hsql-0.4.0	examples/simple.sql