Sequel 5.23.0 has been released!
= New Features
* An insert_conflict plugin has been added for automatically handling
constraint conflicts when saving new model instances. It is
supported on PostgreSQL 9.5+ and SQLite 3.24.0+.
Album.new(name: 'Foo', copies_sold: 1000).
insert_conflict(
target: :name,
update: {copies_sold: Sequel[:excluded][:b]}
).
save
* On Microsoft SQL Server, the Database :ansi option has been added,
which sets the following ANSI related options:
* ANSI_NULLS
* ANSI_PADDING
* ANSI_WARNINGS
* ANSI_NULL_DFLT_ON
* QUOTED_IDENTIFIER
* CONCAT_NULL_YIELDS_NULL
= Other Improvements
* Sequel.datetime_class = Time is now supported when using the
named_timezones extension. For backwards compatibility, the
named_timezones extension still sets
Sequel.datetime_class = DateTime. When using Ruby 2.6+, the
Time instances have the timezone set on them using Ruby 2.6+'s
timezone support, but basic support works correctly in earlier
versions of Ruby.
* On Microsoft SQL Server, Sequel now handles parsing schema for
tables in another database on the same server or in a database
on a linked server.
* The pg_json extension now correctly handles subclasses of core
classes when wrapping objects. This stopped working in Sequel
5.21.0, when support for wrapping JSON primitives was added.
* Sequel now works around a couple bugs in jdbc-sqlite 3.27.2.1,
allowing schema parsing and foreign key parsing to work.
* Dataset#execute* private methods now respect an explicitly given
:server option, fixing Dataset#paged_each in the postgres adapter
when using sharding.
* Timezone offsets are now handled correctly when typecasting an array
or hash to datetime when Sequel.datetime_class = Time.
* Sequel now avoids errors when parsing schema when using the mock
SQLite adapter.
* A minor thread-safety issue has been fixed in the named_timezones
extension.
Thanks,
Jeremy
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/sequel-talk/66c500b7-5d30-48d7-b0ed-bc8e508fd79e%40googlegroups.com.
