Skip to content

sQucumber

Choose a tag to compare

@moertel moertel released this 23 Sep 12:25
· 42 commits to master since this release
86f4f62

(b3e1a38) Add sophisticated date matchers

This release adds date matchers with the following modifiers:

  • beginning/end of day/month/year
  • X days/months/years ago/from now
  • (as day/month/year/custom )

Which can be combined freely to e.g.:

  • beginning of month 7 years from now (as day)
  • end of year 10 months ago (as custom '%Y/%m/%d')

The custom formatter uses Ruby formatting:

Modifiers can be used in any with date placeholder directive, in both input and output:

Scenario: Showcase date placeholders
  Given the existing table "tracking.visitors" with date placeholders:
    | date         | visitor_id |
    | today        | abc123     |
    | 1 month ago  | def456     |
  When the given SQL files are executed
  And the resulting table "kpi.reporting" is queried
  Then the result with date placeholders exactly matches:
    | year                  | month                  | visitor_count |
    | today (as year)       | today (as month)       | 1             |
    | 1 month ago (as year) | 1 month ago (as month) | 1             |