Skip to content

Releases: moertel/sQucumber-postgres

sQucumber

27 Aug 11:01
59f8241
Compare
Choose a tag to compare
  • (9b3f297) Raise error for unknown column names

sQucumber

09 Apr 15:09
5c94ee6
Compare
Choose a tag to compare
  • (3d88391) Add keywords to fuzzy match "today" and "yesterday"

sQucumber

29 Mar 15:00
6e6bdee
Compare
Choose a tag to compare
  • (6b25d24) Fix multi-step jump for months of different length

sQucumber

24 Sep 14:08
afce781
Compare
Choose a tag to compare
  • (ee62946) Change default to return query results
  • (ace9456) Fix typos in documentation
  • (b706292) Add step to support ordering of results
  • (ae2e8bc) Return placeholder matchers as strings

sQucumber

23 Sep 12:25
86f4f62
Compare
Choose a tag to compare

(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             |

sQucumber

05 Sep 09:40
cbc5e86
Compare
Choose a tag to compare
  • (89615b5) Add support for jsonb and array columns

sQucumber

05 Sep 09:40
7ba6a41
Compare
Choose a tag to compare
  • (582fc82) Add support for extra configuration via environment variables