Sha256: b70356e988b780513a738a9a9fc64a34146a571daa31407157581b1224b8852c
Contents?: true
Size: 1.44 KB
Versions: 87
Compression:
Stored size: 1.44 KB
Contents
= New Features
* Support for SQL/JSON path expressions has been added to the
pg_json_ops extension. These are supported in PostgreSQL 12+.
Examples:
j = Sequel.pg_json_op(:json_column)
j.path_exists('$.foo') # (jsonb_column @? '$.foo')
j.path_match('$.foo') # (jsonb_column @@ '$.foo')
j.path_exists!('$.foo') # jsonb_path_exists(jsonb_column, '$.foo')
j.path_match!('$.foo') # jsonb_path_match(jsonb_column, '$.foo')
j.path_query('$.foo') # jsonb_path_query(jsonb_column, '$.foo')
j.path_query_array('$.foo') # jsonb_path_query_array(jsonb_column, '$.foo')
j.path_query_first('$.foo') # jsonb_path_query_first(jsonb_column, '$.foo')
* The nested_attributes method in the nested_attributes plugin now
supports a :require_modification option, which can override the
default require_modification setting for the nested objects. This
can be useful to avoid errors if multiple requests are submitted
simultaneously to delete the same nested row.
= Other Improvements
* The dirty plugin now works correctly with the typecast_on_load
plugin.
* Sequel::Postgres::PGRange#hash has been added to the pg_range
extension, allowing PGRange instances to be usable as hash keys.
* Table aliases are now supported for single table INSERT
statements on PostgreSQL 9.5+, which can make some insert_conflict
usage easier.
* Two more foreign key constraint violation types are now recognized
on MySQL 8.0.13+.
Version data entries
87 entries across 73 versions & 2 rubygems