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
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
|
= New Features
* Dataset#first! has been added. This is identical to #first,
except where #first would return nil due to no row matching,
#first! raises a Sequel::NoMatchingRow exception. The main
benefit here is that a standard exception class is now used,
so external libraries can deal with these exceptions appropriately
(such as web applications returning a 404 error).
* Dataset#with_pk! has been added to model datasets. Similar to
#first!, this raises a Sequel::NoMatchingRow exception instead of
returning nil if there is no matching row.
* A drop_foreign_key method has been added to the alter_table
generator:
alter_table(:tab){drop_foreign_key :col}
This relies on foreign_key_list working and including the name
of the foreign key. Previously, you'd have to drop the foreign key
constraint before dropping the column in some cases.
* Column constraints can now be named using :*_constraint_name
options:
create_table(:tab) do
primary_key :id, :primary_key_constraint_name=>:pk_name
foriegn_key :t_id, :t, :foreign_key_constraint_name=>:fk_name,
:unique=>true, :unique_constraint_name=>:uk_name
end
This makes it easier to name constraints, which has always been
recommended as it makes it easier to drop such constraints in the
future.
* On Microsoft SQL Server, Dataset#cross_apply and #outer_apply have
been added to use CROSS/OUTER APPLY. These are useful if you
want to join a table to the output of a function that takes the
table as an argument.
= Other Improvements
* The connection pools are now faster when using the
:connection_handling=>:queue option.
* External connection pool classes can now be loaded automatically by
the :pool_class option.
* Database#each_server now raises if not given a block. Previously,
it just leaked Database references.
* On Microsoft SQL Server, ] characters are now escaped correctly in
identifiers.
* On PostgreSQL, infinite dates are also handled when using
Database#convert_infinite_timestamps. Previously, infinite dates
were incorrectly converted to 0000-01-01.
* The associations, composition, serialization, and dirty plugins
now clear caches stored in the instance in some additional cases,
such as when saving model instances when the dataset supports
insert_select.
* Model#validates_type in the validation_helpers plugin now handles
false values correctly.
* The string_stripper plugin has been fixed to not change the result
of Model.set_dataset.
* You can now drop primary key constraints on H2, using:
alter_table(:tab){drop_constraint :foo, :type=>:primary_key}
* The jdbc/as400 adapter has been fixed, it was broken starting in
Sequel 3.44.0.
* A Security guide has been added explaining various security issues
to think about when using Sequel.
= Backwards Compatibility
* The change to make associations, composition, serialization, and
dirty now clear caches after saving when the dataset supports
insert_select can break code that expected the previous behavior.
For example:
artist = Artist[1]
artist.has_albums # => false
album = Album.new(:artist=>artist)
def album.after_create
super
artist.update(:has_albums=>true)
end
album.save
artist.has_albums # => false
Such code should either refresh the artist after saving the album,
or use album.artist.has_albums. You already had to do that if
the dataset did not support insert_select; the impetus for this
change was to make the behavior consistent.
* Decimal/numeric columns are now strictly typecast by default,
similar to integer and real/double precision columns. If you want
the previous loose typecasting to for decimal/numeric columns,
use the looser_typecasting extension.
* External adapters that called Database.set_adapter_scheme with a
string should change to using a symbol.
* Dataset#select_map, #select_order_map, and #get now raise an
exception if they are passed a plain string inside an array.
If you do want to use a plain string, you now need to alias it:
dataset.get([Sequel.as('string', :some_alias)])
= Sequel 4 Implementation Planning
* Sequel 4 implementation planning has begun. If you want to view
and/or provide feedback on the implementation plan, see
https://github.com/jeremyevans/sequel-4-plans
|
