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
|
= New Features
* A pg_inet_ops extension has been added, for DSL support for
calling PostgreSQL inet functions and operators. Example:
r = Sequel.pg_inet_op(:inet)
~r # ~inet
r & :other # inet & other
r | :other # inet | other
r << :other # inet << other
r >> :other # inet >> other
r.contained_by(:other) # inet << other
r.contained_by_or_equals(:other) # inet <<= other
r.contains(:other) # inet >> other
r.contains_or_equals(:other) # inet >>= other
r.contains_or_contained_by(:other) # inet && other
r.abbrev # abbrev(inet)
r.broadcast # broadcast(inet)
r.family # family(inet)
r.host # host(inet)
r.hostmask # hostmask(inet)
r.masklen # masklen(inet)
r.netmask # netmask(inet)
r.network # network(inet)
r.set_masklen(16) # set_masklen(inet, 16)
r.text # text(inet)
* The association_pks plugin now supports a :delay_pks association
option. When set to true, this makes the methods created by the
plugin usable on new objects, by delaying the saving of the
associated pks until after the new object has been saved. When
set to :always, this also changes the behavior of the methods
for existing objects, so that nothing is persisted until the
object has been saved. Example:
Album.plugin :association_pks
Album.many_to_many :tags, :delay_pks=>true
album = Album.new(:tag_pks=>[1,2,3]) # No database query
album.save # Queries to insert album, and then update albums_tags
* The class_table_inheritance plugin now supports subclasses that
don't require additional columns, and therefore do not need to
join to additional tables. It now loads the
single_table_inheritance plugin and supports options that were
previously only supported by single_table_inheritance, such as the
:key_map and :key_chooser options.
* The validation_helpers plugin now supports a :from=>:values option
in the validation methods, which will take the value directly from
the values hash instead of calling the related method. This
allows validation_helpers to differentiate between validations on
underlying database column and validations on the model.
The auto_validations plugin has been modified to use this feature,
since all validations it generates are for validations on the
underlying database columns.
* The auto_validations plugin now supports options to pass to each
of the underlying validation methods:
Sequel::Model.plugin :auto_validations,
:unique_opts=>{:only_if_modified=>true}
In addition to :unique_opts, there is support for :not_null_opts
(for NOT NULL columns without a default), :explicit_not_null_opts
(for NOT NULL columns with a default), :max_length_opts, and
:schema_types_opts.
* The update_refresh plugin now accepts a :columns option, which
specifies the columns to refresh. This option is currently only
respected if the related dataset supports RETURNING.
* The :timeout option to Database#listen in the postgres adapter can
now be a callable object, previously it had to be Numeric. This
allows you to dynamically change the timeout based on current
application state.
= Other Improvements
* The uniqueness validations added by the auto_validations plugin now
use a symbol key in the related Errors instance if the underlying
index was on a single column. Previously, the uniqueness
validations for a single column would use an array key in the
related Errors instance.
* The jdbc subadapters now correctly handle 64-bit autoincrementing
primary keys.
* The jdbc subadapters now work correctly if they issue queries while
the subadapter is being loaded. This can happen in the
jdbc/postgresql adapter if the pg_hstore extension is used.
= Backwards Compatibility
* The deprecated db2 and dbi adapters have been removed.
|
