Contents

# filename: daily_summary.sql
owner: jackdanger
schedule: hourly
requires:
  - daily_payments
  - hourly_users
  - some_other_value
data:
  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

4 entries across 4 versions & 1 rubygems

Version	Path
hsql-0.3.8	examples/simple.sql
hsql-0.3.7	examples/simple.sql
hsql-0.3.6	examples/simple.sql
hsql-0.3.5	examples/simple.sql