ANN: Sequel 3.47.0 Released

Sequel is a lightweight database access toolkit for Ruby.

* Sequel provides thread safety, connection pooling and a concise
  DSL for constructing SQL queries and table schemas.
* Sequel includes a comprehensive ORM layer for mapping records to
  Ruby objects and handling associated records.
* Sequel supports advanced database features such as prepared
  statements, bound variables, stored procedures, savepoints,
  two-phase commit, transaction isolation, master/slave
  configurations, and database sharding.
* Sequel currently has adapters for ADO, Amalgalite, CUBRID,
  DataObjects, DB2, DBI, Firebird, IBM_DB, Informix, JDBC, MySQL,
  Mysql2, ODBC, OpenBase, Oracle, PostgreSQL, SQLite3, Swift, and
  TinyTDS.

Sequel 3.47.0 has been released and should be available on the gem
mirrors.

= New Plugins

* An auto_validations plugin has been added, which automatically
  adds not null, type, and unique validations based on information
  obtained from parsing the database schema.  If you don't
  require customization of the validation error message per
  column, this can significantly DRY up validation code.  Currently
  this plugin requires the database support index parsing; that
  restriction will be removed in Sequel 4.

* An input_transformer plugin has been added, for automatically
  running a transformation proc on all model column setter
  input before use.  This is a generalization of the
  string_stripper plugin, allowing arbitrary modifications
  to the input.

* An error_splitter plugin has been added, for splitting validation
  errors applying to multiple columns into a separate validation
  error per column.  This is useful if you want to to include such
  errors when using Errors#on to get all errors on the column. In
  general, only uniqueness errors apply to multiple columns, so
  those are the only errors likely to be affected.

= Other New Features

* Database.extension has been added, allowing you to load an
  extension into all future databases.  This is similar to loading a
  plugin into Sequel::Model itself.  For example, if you want all
  Database instances to use the query_literals extension, run the
  following before creating your Database instances:

    Sequel::Database.extension :query_literals

* Database.after_initialize has been added for running a hook
  on all new databases created.

* Model.default_set_fields_options has been added, allowing you
  to set the default options for the #set_fields and #update_fields
  methods.  This is useful if you want to make :missing=>:raise
  or :missing=>:skip the default behavior.

* The :setter, :adder, :remover, and :clearer association options
  have been added.  These allow you to override the default
  implementation used to modify the association.  :setter affects
  the *_to_one setter method, :adder the *_to_many add_* method,
  :remover the *_to_many remove_* method, and :clearer the
  *_to_many remove_all_* method.

  Previously, you had to override a private method to get the same
  behavior, this just offers a nicer API for that.

* A :keep_reference Database option has been added.  When set to
  false, a reference to the Database instance is not kept in
  Sequel::DATABASES.  This is designed for Database instances
  created by libraries, so they don't accidentally get chosen as
  the default Sequel::Model database.

* Model#modified! now accepts a column and marks that column
  as changed.  This is useful if you plan on mutating the column
  value as opposed to reassigning it.

* Model#modified? now accepts a column and returns whether the
  column has been changed.

* The migrators now support an :allow_missing_migration_files
  option, which makes them silently ignore errors related to
  missing migration files.

* validates_schema_types has been added to validation_helpers,
  which validates that the column values are instances of the
  expected ruby type for the given database schema type.  This
  is a more robust version of the validates_not_string
  extension, and users of validates_not_string are encouraged
  to switch soon, as validates_not_string is going away in
  Sequel 4.

  validates_schema_type has been added to validation_class_methods,
  which preforms the same validation, but it requires the columns
  be listed explicitly.

  validates_type in validation_helpers has been expanded to
  accept an array of allowable classes.

  Related to this is the addition of Database#schema_type_class for
  returning the type class(es) for the given schema type symbol.

* validates_not_null has been added to the validation_helpers
  plugin.  This is similar to the validates_presence validation,
  but only checks for nil values, allowing empty/blank strings.

* In the caching plugin, when the :ignore_exceptions option is true,
  exceptions raised when deleting an object from the cache are now
  ignored correctly.

* On PostgreSQL, Sequel now supports a :search_path Database
  option to automatically set the client connection search_path.
  This allows you to control which schemas do no require
  qualification, and in which order to check schemas when
  referencing unqualified objects.  If you were using the
  default_schema setting, it is recommended that you switch
  to using :search_path instead.

* The pg_array extension can now register array types on a
  per-Database basis via Database#register_array_type. Previously,
  only global registration of array types was allowed.  Additionally,
  when registering array types on a per-Database basis, the oids can
  be looked up automatically, making it possible to register array
  types with just a type name:

    DB.register_array_type(:interval)

* The pg_array extension now automatically creates conversion
  procs for array types of all named types used by the
  database.  This means that if you use the pg_array and
  pg_hstore extensions, the hstore[] type is now handled
  correctly.

* The postgres adapter now supports :use_iso_date_format and
  :convert_infinite_timestamps Database options.  Previously,
  use_iso_date_format was only a global setting, and
  convert_infinite_timestamps could only be set after
  initialization.

* Database#supports_schema_parsing? has been added to check
  if schema parsing via the Database#schema method is
  supported.

= Other Improvements

* A race condition related to prepared_sql for newly prepared
  statements has been fixed.

* Dataset#get now works correctly if given an array with multiple
  columns if there were no returned rows.

* The plugins that ship with Sequel now handle frozen model instances
  correctly.

* Freezing of model instances now works correctly for models without
  primary keys.

* Database constraints added with the constraint_validations
  plugin now handle NULL values correctly if the :allow_nil=>true
  setting is used.

* The  pagination, pretty_table, query, schema_caching,
  schema_dumper, and select_remove extensions can now be
  loaded by Database#extension.  If you are loading them
  globally via Sequel.extension, switch to using
  Database#extension, since that will be required starting
  in Sequel 4.

* The lazy_attributes plugin no longer uses the identity_map plugin
  internally, and eager loading lazy attributes now works correctly
  without an active identity map.

* The many_to_one_pk_lookup plugin now handles many more corner
  cases, and should be safe to enable by default.

* The static_cache plugin now has optimized implementations of
  Model.map, .to_hash, and .to_hash_groups which work without a
  database query.  Model.count without arguments has also been
  optimized to not require a database query.

* Fetching new records has been made faster when using the
  update_primary_key plugin, since it was changed to cache the primary
  key values lazily.

* When using the update_primary_key plugin, if the primary key
  changes, clear the associations cache of all non-many_to_one
  associations (since those will likely be based on the primary
  key).

* The pg_typecast_on_load plugin no longer errors if given a
  column that doesn't have a matching oid conversion proc.

* Handling of domain types on PostgreSQL has been significantly
  improved.  Domain type columns now have correct model
  typecasting, and the pg_row extension correctly sets up
  conversion procs for domain types inside composite types.

* Postgres::HStoreOp#- now automatically casts string input to
  text, so that PostgreSQL doesn't assume the string is an
  hstore.

* Postgres::PGRangeOp#starts_before and #ends_after have been
  renamed to #ends_before and #starts_after.  The previous
  names were misleading.  The old names are still available
  for backwards compatibility, but they will be removed in the
  Sequel 4.

* The pg_row plugin now handles aliased tables correctly.

* Model#validate in the validation_class_methods plugin no
  longer skips validate methods in superclasses or previously
  loaded plugins.

* Loading the touch plugin into a model subclass after it has
  been loaded into a model superclass no longer ignores
  inherited touched associations.

* Sequel no longer resets the conversion procs for the
  Database instance when using Databaset#extension to load a
  pg_* extension that adds global conversion procs.  Instead,
  the global conversion procs are added to the instance-specific
  conversion procs.  The result of this is that manually added
  conversion procs will not be lost if an extension is loaded
  afterward.

* The jdbc adapter now references the driver class before loading
  subadapter specific code, which can fix issues if the database
  tries to connect on initialization (such as the jdbc/postgres
  adapter if the pg_hstore extension is loaded previously).

* A guide describing Sequel's support for advanced PostgreSQL
  features has been added.

= Backwards Compatibility

* If you have already used the constraint_validations plugin to
  create validations with the :allow_nil=>true option, you should
  drop and regenerate those constraints to ensure they handle NULL
  values correctly.

* The change to make PostgreSQL automatically handle domain
  types can break previous code that set up special conversions
  and typecasts per domain type.  In the schema parsing, if you
  want to get the domain type information, it will be contained
  in the :db_domain_type and :domain_oid schema entries.

* Sequel::Postgres.use_iso_date_format is now only defined if
  you are using the postgres adapter.  Previously, it could
  be defined when using other adapters with a pg_* extension,
  even though the setting had no effect in that case.

* The validation_class_methods plugin now copies validations into
  the subclass upon inheritance, instead of recursing into the
  superclass on validation.  This makes it more similar to how
  all the other Sequel plugins work.  However, it also means that
  if you add validations to a superclass after creating a
  subclass, the subclass won't have those validations.  Additionally
  if you skip superclass validations in a child class after creating
  a grandchild class, the grandchild class could still have the
  parent class's validations.

* The validates_unique validation in validation_helpers no longer
  attempts to do the uniqueness query if the underlying columns
  have validation errors.  The reasoning behind this is that if the
  underlying columns are not valid, the uniqueness query can cause
  a DatabaseError.

* If you were passing strings in hstore format to
  Postgres::HStoreOp#-, you should manually cast them to hstore:

    hstore_op - Sequel.cast('a=>b', :hstore)

* The default validation error message for validates_type has been
  modified.

* Database#schema_column_type was made public accidently by an
  adapter and a few extensions.  That has been fixed, but if you
  were calling it with an explicit receiver and it happened to
  work by accident before, you'll need to update your code.

= Sequel 4 Implementation Planning

* Sequel 4 implementation work will begin shortly.  All Sequel users
  are encouraged to read about the proposed changes and provide
  feedback on the implementation plan. For details, see
  https://github.com/jeremyevans/sequel-4-plans.

Thanks,
Jeremy

* {Website}[http://sequel.rubyforge.org]
* {Source code}[http://github.com/jeremyevans/sequel]
* {Blog}[http://sequel.heroku.com]
* {Bug tracking}[http://github.com/jeremyevans/sequel/issues]
* {Google group}[http://groups.google.com/group/sequel-talk]
* {RDoc}[http://sequel.rubyforge.org/rdoc]

-- 
Posted via http://www.ruby-forum.com/.