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
|
= New Features
* The pg_json extension now adds a Database#wrap_json_primitives
accessor. When set to true, JSON primitive values (string, number,
true, false, and null) will be wrapped by delegate Ruby objects
instead of using Ruby primitives. This allows the values to round
trip, so the following code will work even for primitive values in
json_column:
DB.extension :pg_json
DB.wrap_json_primitives = true
value = DB[:table].get(:json_column)
DB[:other_table].insert(json_column: value)
This should be enabled with care, especially in cases where false
and null JSON values are used, as the behavior will change if
the objects are used in a boolean context in Ruby, as only false
and nil in Ruby are treated as false:
# assume JSON false or null value
value = DB[:table].get(:json_column)
if value
# executed if wrap_json_primitives is true
else
# executed by default
end
When typecasting input in model objects to a JSON type, string
input will still be parsed as JSON. However, you can set the
Database#typecast_json_strings accessor to true, and then string
input will be considered as a JSON string instead of parsing the
string as JSON.
To prevent backwards compatibility issues, Sequel.pg_json/pg_jsonb
behavior has not changed. To support wrapping Ruby primitives in
the delegate objects, new Sequel.pg_json_wrap/pg_jsonb_wrap methods
have been added. These methods only handle the Ruby primitives,
they cannot be used if the existing object is already a delegate
object.
As model objects always consider a nil value as SQL NULL and do
not typecast it, if you want to explicitly set a JSON null value,
you need to wrap it explicitly:
model_object.json_column = Sequel.pg_json_wrap(nil)
= Other Improvements
* Sequel now supports window function options :window, :exclude, and
:frame :type=>:groups, :start, and :end on SQLite 3.28.0+.
* The server_block extension now respects the :servers_hash Database
option. This makes it more similar to Sequel's default behavior.
However, that means by default, the server_block extension will
default to handling unknown shards as the default shard, instead
of raising an error for them.
* The rcte_tree plugin now disallows eager graphing of the ancestors
and descendants associations. Previously, eager graphing of these
associations generated incorrect results. It is not possible to
eager graph these extensions, but normal eager loading does work.
* The ado adapter's performance has been improved by using faster
callables for type conversion and a more efficient inner loop.
* The sqlite adapter now converts a :timeout option given as a string
to an integer. This allows you to use the option inside of a
connection string.
* The mysql and mysql2 adapters now recognize an additional
DatabaseLockTimeout error.
* The jdbc/mysql adapter now works correctly when using JRuby with
Java 11.
* The ado adapter now handles numeric values when using locales that
use comma instead of period as the decimal separator.
= Backwards Compatibility
* In the pg_json extension, the following singleton methods of
Sequel::Postgres::JSONDatabaseMethods are now deprecated:
* parse_json
* db_parse_json
* db_parse_jsonb
|
