1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
|
= New Features
* A provenance dataset extension has been added. This extension makes
SQL queries include a comment describing how the dataset was built.
This can make debugging complex cases significantly easier. Here's
a simple example:
DB.extension :provenance
DB[:table].
select(:a).
where{b > 10}.
order(:c).
limit(10)
# SQL:
# SELECT a FROM table WHERE (b > 10) ORDER BY c LIMIT 10 --
# -- Dataset Provenance
# -- Keys:[:from] Source:(eval at bin/sequel:257):2:in `<main>'
# -- Keys:[:select] Source:(eval at bin/sequel:257):3:in `<main>'
# -- Keys:[:where] Source:(eval at bin/sequel:257):4:in `<main>'
# -- Keys:[:order] Source:(eval at bin/sequel:257):5:in `<main>'
# -- Keys:[:limit] Source:(eval at bin/sequel:257):6:in `<main>'
With the above example, it's obvious how the dataset is created, but
but in real applications, where datasets can be built from multiple
files, seeing where each dataset clone was made can be helpful.
The source listed will skip locations in the Ruby standard library
as well as Sequel itself. Other locations can be skipped by
providing a Database :provenance_caller_ignore Regexp option:
DB.opts[:provenance_caller_ignore] = /\/gems\/library_name-/
= Other Improvements
* For dataset methods where Sequel can determine that the return
value would be equivalent to the receiver, Sequel now returns the
receiver. This reduces the number of dataset allocations.
* Sequel now supports Dataset#skip_locked on MariaDB 10.6+.
|
