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
|
= New Features
* MERGE WHEN NOT MATCHED BY SOURCE is now supported when using
PostgreSQL 17+. You can use this SQL syntax via the following
Dataset methods:
* merge_delete_when_not_matched_by_source
* merge_update_when_not_matched_by_source
* merge_do_nothing_when_not_matched_by_source
These are similar to the existing merge_delete, merge_update,
and merge_do_nothing_when_matched, except they use
WHEN NOT MATCHED BY SOURCE instead of WHEN MATCHED.
* An stdio_logger extension has been added. This adds the
Sequel::StdioLogger class, which is a minimal logger implementation
that is compatible for usage with Sequel::Database. Example:
Sequel.extension :stdio_logger
DB.loggers << Sequel::StdioLogger.new($stdout)
= Other Improvements
* Database#inspect now only displays the database type, host, database
name, and user. In addition to being easier to read, this also
prevents displaying the password, enhancing security.
* The string_agg extension now supports SQLite 3.44+.
* The defaults_setter plugin now passes the model instance to a
default_values proc if the proc has arity 1. This allows default
values to depend on model instance state.
* The optimistic_locking plugin no longer adds the lock column to
changed_columns after updating the model instance.
* Database#create_temp with :temp option and an
SQL::QualifiedIdentifier table name will now attempt to create a
schema qualified table. Note that schema qualified temporary
tables are not supported by many (any?) databases, but this
change prevents the CREATE TABLE statement from succeeding with
an unexpected table name.
= Backwards Compatibility
* The Database.uri_to_options private class method now handles
conversion of URI parameters to options. Previously, this was
handled by callers of this method (change reverted in 5.83.1).
* The _merge_matched_sql and _merge_not_matched_sql private Dataset
methods in PostgreSQL have been replaced with
_merge_do_nothing_sql.
* An unnecessary space in submitted SQL has been removed when using
MERGE INSERT on PostgreSQL. This should only affect your code if
you are explicitly checking the produced SQL.
|
