4.36.0.txt

= New Features

* Sequel::Model::Model() has been added, which allows for
  Sequel::Model() like behavior where the base class used is a
  subclass of Sequel::Model.  To make it easier to use,
  Sequel::Model.def_Model has also been added, which takes a module
  and adds a Model() method to the module that calls Model() on the
  receiver.

  A :class_namespace association option has been added to make it
  possible to set a default namespace for the :class option if given
  as a symbol or string.

  Sequel::Model.Model.cache_anonymous_models has been added and
  controls whether to cache anonymous model subclasses created by
  Sequel::Model::Model() on a per-class basis.

  These changes are designed to make it easier to use namespaced
  models, for example:

    module Foo
       Model = Class.new(Sequel::Model)
       Model.def_Model(self)
       DB = Model.db = Sequel.connect(ENV['FOO_DATABASE_URL'])
       Model.plugin :prepared_statements
       Model.default_association_options[:class_namespace] = 'Foo'

       class Bar < Model
         # Uses Foo::DB[:bars] as dataset

         # Implicitly uses Foo::Baz as associated class
         one_to_many :bazes

         # Uses Foo::Baz due to :class_namespace option
         one_to_many :oldest_bazes, :class=>:Baz, :order=>:id
       end

       class Baz < Model(:my_baz)
         # Uses Foo::DB[:my_baz] as dataset

         # Implicitly uses Foo::Bar as associated class
         one_to_many :bars

         # Uses Foo::Bar due to :class_namespace option
         one_to_many :oldest_bars, :class=>:Bar, :order=>:id
       end
     end

* A string_agg extension has been added for aggregate string
  concatentation support on PostgreSQL 9+, SQLAnywhere 12+,
  Oracle11g+, DB 9.7+, MySQL, HSQLDB, H2, and CUBRID:

    DB.extension :string_agg
    ds = DB[:table]
    ds.get(Sequel.string_agg(:c))             # ',' default separator
    ds.get(Sequel.string_agg(:c, ' - '))      # custom separator
    ds.get(Sequel.string_agg(:c).order(:bar)) # force order
    ds.get(Sequel.string_agg(:c).distinct)    # remove duplicates

* A connection_expiration extension has been added, for automatically
  removing connections from the connection pool after they have been
  open for a given amount of time (4 hours by default).

* Support for <, <=, >, and >= operator validations when using integer
  and string arguments has been added to the constraint_validations
  extension and plugin.

* Sequel::SQL::Function#order has been added to support ordered
  aggregate functions:

    Sequel.function(:foo, :bar).order(:baz)
    # foo(bar ORDER BY baz)

= Other Improvements

* The validates_operator validation in validation_helpers now
  considers nil values as invalid unless :allow_nil or a similar
  option is used.  Previously, using validates_operator with a nil
  value would probably raise a NoMethodError.  This makes
  validates_operator more similar to other validations.

* The threaded connection pools no longer hold the pool mutex when
  disconnecting connections, which is useful if the driver blocks
  when disconnecting connections.

* The connection_validator extension no longer holds a reference
  to connections that have been disconnected.

* The connection_validator extension no longer overwrites the
  connection_validation_timeout if loaded a second time.

* Sequel now closes cursors as soon as it is done using them in the
  oracle adapter, instead of waiting for GC to clean them up.

* Sequel now handles disconnect errors that occur when literalizing
  strings in the mysql2 and postgres adapters.

= Backwards Compatibility

* Using the Bignum class as a generic type is now deprecated.  As
  announced in the 4.35.0 release notes, ruby 2.4 is unifying the
  Fixnum and Bignum classes into Integer, which results in the
  behavior of the Bignum class changing.  4.35.0 added support for
  using the :Bignum symbol as a generic 64-bit integer type, and
  Sequel users now need to switch to that to avoid the deprecation
  warning.

  Sequel 4.41.0 (to be released in December), will drop support
  for using the Bignum class as a generic type.  This is being done
  before the release of ruby 2.4 to hopefully make it unlikely that
  users will be subject to a behavior changes when upgrading ruby
  versions.

  Related to this change, external adapters need to switch from
  overriding Database#type_literal_generic_bignum to 
  Database#type_literal_generic_bignum_symbol.