CHANGELOG

CHANGELOG
Last Update: 2018-10-01 07:21:49 -0700

5.13.0 (2018-10-01)

  • Support :single_value type in prepared statements (rintaun) (#1547)

  • Make Model.all in static_cache plugin accept a block (AlexWayfer, jeremyevans) (#1543)

  • Add constant_sql_override extension for overriding SQL used for constants such as CURRENT_TIMESTAMP (celsworth) (#1538)

  • Do not cache from_self datasets if options are given (jeremyevans)

5.12.0 (2018-08-31)

  • Make constraint_validations extension respect Database#constraint_validations_table setting (jeremyevans)

  • Make Sequel.extension load files from gems (jeremyevans)

  • Map clob prepared statement argument type to OCI8::CLOB in the oracle adapter (pipistrellka) (#1534)

  • Make Model.load_cache public in the static_cache plugin (AlexWayfer) (#1533)

  • Enable support for NOWAIT on MariaDB 10.3+ (jeremyevans)

  • Enable support for INTERSECT and EXCEPT on MariaDB 10.3+ (jeremyevans)

  • Make tactical_eager_loading plugin handle automatic eager loading for associated objects created by eager_graph (jeremyevans)

  • Cache eager_graph loader to speed up subsequent loads from the same dataset (jeremyevans)

  • Add caller_logging database extension to log callers before queries, useful during development (jeremyevans)

  • Add Database#call_procedure in the postgres adapter for calling PostgreSQL 11+ procedures (jeremyevans)

  • Add eager_graph_eager plugin for chaining eager association loads after eager_graph association loads (jeremyevans)

  • Support using Dataset#eager_graph in eager load callback for associations using join tables (jeremyevans)

  • Make Dataset#graph handle existing selections without determinable aliases by forcing a subselect (jeremyevans)

  • Freeze prepared statement arguments before returning the prepared statement (jeremyevans)

  • Refactor emulated prepared statement internals to use a placeholder literalizer (jeremyevans)

5.11.0 (2018-08-01)

  • Fix using the jdbc/sqlserver adapter on JRuby 9.2+ (jeremyevans)

  • Fix dumping schema for numeric/decimal columns with default values, broken starting in 5.9.0 (jeremyevans)

  • Recognize additional check constraint violations on certain versions of SQLite (jeremyevans)

  • Use cached model instances for Model.first calls without an argument or with a single integer argument in the static_cache plugin (AlexWayfer) (#1529)

  • Support ON CONFLICT clause for INSERT on SQLite 3.24+ (jeremyevans)

  • Support Dataset#window for WINDOW clause on MySQL 8 and SQLAnywhere (jeremyevans)

  • Enable window function support on SQLAnywhere (jeremyevans)

  • Support using a hash as a window function :frame option value, with support for ROWS/RANGE/GROUPS, numeric offsets, and EXCLUDE (jeremyevans)

  • Allow using set_column_default with a nil value to remove the default value for a column on MySQL when the column is NOT NULL (jeremyevans)

5.10.0 (2018-07-01)

  • Use input type casts when using the postgres adapter with pg 0.18+ to reduce string allocations for some primitive types used as prepared statement arguments (jeremyevans)

  • Assume local time if database timezone not specified when handling BC timestamps on JRuby 9.2.0.0 in the pg_extended_date_support extension (jeremyevans)

  • Fix parsing of timetz types in the jdbc/postgresql adapter (jeremyevans)

  • Make SQLTime.parse respect SQLTime.date and Sequel.application_timezone (jeremyevans)

  • Add :top as an option in the list plugin (celsworth) (#1526)

  • Fix Model#{ancestors,descendants,self_and_siblings} in the tree plugin when custom parent/children association names are used (jeremyevans) (#1525)

  • Treat read-only mode error as disconnect error on mysql and mysql2 adapters, for better behavior on AWS Aurora cluster (jeremyevans)

  • Don't use cached placeholder literalizers for in Dataset#{first,where_all,where_each,where_single_value} if argument is empty array or hash (jeremyevans)

  • Support :tablespace option when adding tables, indexes, and materialized views on PostgreSQL (jeremyevans)

  • Support :include option for indexes on PostgreSQL 11+ (jeremyevans)

  • Allow the use of IN/NOT IN operators with set returning functions for Sequel::Model datasets (jeremyevans)

  • Make many_to_pg_array associations in the pg_array_associations plugin work on PostgreSQL 11 (jeremyevans)

  • Only load strscan library in pg_array extension if it is needed (jeremyevans)

  • Don't remove related many_to_one associations from cache when setting column value to existing value for model instances that have not been persisted (jeremyevans) (#1521)

  • Support ruby 2.6+ endless ranges in the pg_range extension (jeremyevans)

  • Support ruby 2.6+ endless ranges in filters, using just a >= operator for them (jeremyevans)

5.9.0 (2018-06-01)

  • Support generated columns on MySQL 5.7+ and MariaDB 5.2+ (wjordan, jeremyevans) (#1517)

  • Add escaped_like extension for creation of LIKE expressions with placeholders in the pattern without access to a dataset (jeremyevans)

  • Modify jdbc adapter exception handling to work around ::NativeException deprecation in JRuby 9.2 (jeremyevans)

  • Work around broken BC date handling in JRuby 9.2.0.0 (jeremyevans)

  • Switch use of BigDecimal.new() to BigDecimal(), since the former is deprecated (jeremyevans)

  • Add Sequel::VERSION_NUMBER for easier version comparisons (jeremyevans)

  • Add Model.has_dataset? to determine if the model class has a dataset (AlexWayfer) (#1508)

  • Support use of LIKE with ANY function on PostgreSQL by avoiding unnecessary use of ESCAPE syntax (jeremyevans)

  • Disconnect connections left allocated by dead threads instead of returning the connections to the pool (jeremyevans)

  • Make both threaded connection pools avoid disconnecting connections while holding the connection pool mutex (jeremyevans)

  • Don't deadlock when disconnecting connections in the sharded_threaded connection pool when using connection_validator or connection_expiration extensions (jeremyevans)

  • Don't modify hash argument passed in Model.nested_attributes in the nested_attributes plugin (jeremyevans)

  • Avoid unnecessary hash creation in many places (jeremyevans)

  • Fix duplicate objects in nested associations when eager_graphing cascaded many_to_one=>one_to_many associations (jeremyevans)

5.8.0 (2018-05-01)

  • Don't mark SQLAnywhere as supporting WITH in INSERT statement (jeremyevans)

  • Support :search_path as a shard option on PostgreSQL (jeremyevans)

  • Add Dataset#nowait for raising a Sequel::DatabaseLockTimeout when a locked row is encountered, supported on PostgreSQL, MySQL 8+, MSSQL, and Oracle (jeremyevans)

  • Support Dataset#skip_locked on MySQL 8+ (jeremyevans)

  • Make schema modification methods in the pg_enum extension work on a frozen Database object (jeremyevans)

  • Support common table expressions and window functions on MySQL 8+ (jeremyevans)

  • Ignore Dataset#explain :extended option on MySQL 5.7+, since extended output is then the MySQL default (jeremyevans)

  • Work around REGEXP BINARY not working correctly on MySQL 8+ by using REGEXP_LIKE with the 'c' match_type (jeremyevans)

  • Force correct column order in Database#foreign_key_list on MySQL (jeremyevans)

  • Add ConnectionPool#connection_expiration_random_delay to connection_expiration extension, to avoid thundering herd if preallocating connections (hex2a, jeremyevans) (#1503)

  • Emit deprecation warning in association_proxies plugin if using filter on an association proxy, since behavior will change on ruby 2.6+ (utilum) (#1497)

  • Handle multiple add_constraint calls and a set_column_null call in the same alter_table block on SQLite (jeremyevans) (#1498)

  • Add Database#rename_enum to the pg_enum extension (AlexWayfer) (#1495)

  • Make tactical_eager_loading plugin respect the :allow_eager association option (jeremyevans) (#1494)

  • Add pg_auto_constraint_validations plugin, for automatically converting constraint violations to validation failures on PostgreSQL (jeremyevans)

  • Don't make Model#_valid? public in the error_splitter plugin (jeremyevans)

  • Support Database#indexes :include_partial option on PostgreSQL for including partial indexes (jeremyevans)

  • Include more diagnostic information in Database#error_info on PostgreSQL (jeremyevans)

  • Support Database#foreign_key_list :reverse option on PostgreSQL for parsing foreign key constraints that reference a given table (jeremyevans)

  • Add Database#check_constraints on PostgreSQL for parsing CHECK constraints (jeremyevans)

  • Don't use identity columns if :serial=>true or :type=>:serial|:bigserial column options are used (#1490) (jeremyevans)

  • Cache Dataset#select_all datasets if no arguments are given (jeremyevans)

  • Cache Dataset#returning datasets if no arguments are given (jeremyevans)

  • Cache Dataset#qualify datasets if no argument is given (jeremyevans)

  • Cache Dataset#lateral datasets (jeremyevans)

  • Cache Dataset#from_self datasets if no options are given (jeremyevans)

  • Cache Dataset#distinct datasets if no arguments or block is given (jeremyevans)

5.7.0 (2018-04-01)

  • Add Sequel.start_timer and .elapsed_seconds_since for more accurate elapsed time calculations on ruby 2.1+ (jeremyevans)

  • Run Dataset#with_sql_{all,each,first,single_value} using a cached dataset to avoid clobbering the dataset's columns (jeremyevans)

  • Add Database#convert_serial_to_identity on PostgreSQL 10.2+, which requires superuser access (jeremyevans)

  • Fix Database#server_version when connecting to PostgreSQL 10.1+ in certain cases (jeremyevans)

  • Free temporary clobs in the jdbc/oracle adapter to prevent a memory leak (jeremyevans) (#1482)

  • Treat prepared statement errors due to changing types as disconnect errors in the postgres adapter (jeremyevans) (#1481)

  • Add integer64 extension for treating Integer as a 64-bit integer when used as a generic type (jeremyevans)

  • Allow many_to_pg_array remove_all_* method cast appropriately to work correctly for non-integer types (jeremyevans)

  • Fix array_type for pg_array_to_many and many_to_pg_array associations in pg_array_associations plugin (jeremyevans)

  • Use identity columns instead of serial columns for primary keys on PostgreSQL 10.2+ (jeremyevans)

  • Support :identity option when creating columns on PostgreSQL 10+ to create identity columns (jeremyevans)

  • Add Dataset#overriding_{system,user}_value on PostgreSQL for use with PostgreSQL 10+ identity columns (jeremyevans)

  • Set :auto_increment schema entry correctly for PostgreSQL 10+ identity columns (jeremyevans)

5.6.0 (2018-03-01)

  • Dedup :db_type strings in schema hashes on Ruby 2.5+ (jeremyevans)

  • Make schema_caching extension work with :callable_default schema values (jeremyevans)

  • Freeze string valuse in hashes returned by Database#schema when using the schema_caching extension (jeremyevans)

  • Protect migration file loading with a mutex to not break when multiple threads load migration files simultaneously (jeremyevans)

  • Respect identifier mangling rules when renaming columns on Microsoft SQL Server (jeremyevans)

5.5.0 (2018-01-31)

  • Make Database#copy_table in the postgres adapter handle errors that occur while processing rows (jeremyevans) (#1470)

  • Cache results of changed_columns method in local variables in many places for better performance (jeremyevans)

  • Make modification_detection plugin not break column change detection for new objects (jeremyevans) (#1468)

  • Make pg_range extension set :ruby_default schema value for recognized range defaults (jeremyevans)

  • Make pg_interval extension set :ruby_default schema value for recognized interval defaults (jeremyevans)

  • Make pg_json extension set :callable_default schema value for empty json/jsonb array/hash defaults (jeremyevans)

  • Make pg_inet extension set :ruby_default schema value for recognized inet/cidr defaults (jeremyevans)

  • Make pg_hstore extension set :callable_default schema value for empty hstore defaults (jeremyevans)

  • Make pg_array extension set :callable_default schema value for recognized empty array defaults (jeremyevans) (#1466)

  • Make defaults_setter plugin prefer :callable_default db_schema values over :ruby_default db_schema values (jeremyevans)

  • Add defaults_setter plugin :cache option for caching default values returned (jeremyevans)

  • Freeze string values in hashes returned by Database#schema (jeremyevans)

5.4.0 (2018-01-04)

  • Enable fractional seconds in timestamps on DB2 (jeremyevans) (#1463)

  • Don't attempt to insert a second time if insert_select runs a query that doesn't return results, which can happen when triggers are used (jeremyevans)

  • Make Dataset#insert_select on PostgreSQL and MSSQL return false instead of nil if the INSERT query is sent to the database but returns no rows (jeremyevans)

  • Add index_caching extension for caching calls to Database#indexes (kenaniah, jeremyevans) (#1461)

  • Allow Database#indexes on SQLite, MSSQL, SQLAnywhere, and DB2 to handle SQL::Identifier values (jeremyevans)

  • Add pg_timestamptz extension for using timestamptz (timestamp with time zone) as the default timestamp type (jeremyevans)

  • Support Sequel.date_{add,sub} :cast option for setting cast type in date_arithmetic extension (jeremyevans)

  • Optimize Database#synchronize implementation on ruby 2.5+ (jeremyevans)

  • Add class_table_inheritance plugin :ignore_subclass_columns option (brianphillips) (#1459)

  • Make Dataset#to_xml in xml_serializer work with eager_graphed datasets (jeremyevans)

  • Make Dataset#to_json in json_serializer work with eager_graphed datasets (jeremyevans)

  • Cache Dataset#nullify dataset in the null_dataset extension (chanks) (#1456)

  • Add datetime_parse_to_time extension, for parsing timestamp strings without offsets using DateTime.parse.to_time (jeremyevans) (#1455)

  • Add WHERE NULL filter for Dataset#where calls with no existing filter, no argument, and where the virtual row block returns nil (jeremyevans)

5.3.0 (2017-12-01)

  • Add logger to Database instance before making first connection in bin/sequel (jeremyevans)

  • Drop support for PostgreSQL <8.1 in Database#indexes (jeremyevans)

  • Add synchronize_sql extension, for checking out a connection around SQL generation (KJTsanaktsidis, jeremyevans) (#1451)

  • Deprecate Dataset#where calls with no existing filter, no argument, and where the virtual row block returns nil (jeremyevans) (#1454)

  • Add DatasetModule#reverse for simpler use of descending orders (jeremyevans)

  • Support WITH clauses in subqueries on SQLite, but not in UNION/INTERSECT/EXCEPT (jeremyevans)

  • Hoist WITH clauses to INSERT statement level if INSERT subquery uses a CTE on MSSQL (jeremyevans)

  • Respect indislive and ignore indcheckxmin index attributes when using Database#indexes on PostgreSQL (jeremyevans)

  • Explicitly disallow use of server-side prepared statements when using Dataset#call in the jdbc/postgresql adapter (jeremyevans) (#1448)

  • Support common table expressions, window functions, dropping CHECK constraints, and recognizing CURRENT_DATE defaults on MariaDB 10.2+ (jeremyevans)

  • Make Database#reset_primary_key_sequence work on PostgreSQL 10+ (jeremyevans)

  • Support :connect_sqls Database option for easily issuing sql commands on all new connections (jeremyevans)

  • Support :extensions Database option for loading extensions when initializing, useful in connection strings (jeremyevans)

  • Avoid warning if trying to rollback after a commit or rollback raises an exception in the postgres adapter (jeremyevans)

  • Support Date::Infinity values in the pg_extended_date_support extension (jeremyevans)

5.2.0 (2017-10-27)

  • Fix type conversion for smallint unsigned and integer unsigned types on jdbc/mysql (jeremyevans) (#1443)

  • Add pg_extended_date_support extension, for handling infinite and BC dates/timestamps (jeremyevans)

  • Do not ignore existing @dataset instance variable when subclassing Sequel::Model (bjmllr) (#1435)

5.1.0 (2017-10-01)

  • Make jdbc/h2 and jdbc/hsqldb adapters respect :foreign_key_constraint_name option when adding new foreign key column (jeremyevans)

  • Do not issue unnecessary query for macaddr type oid when loading the pg_inet extension (jeltz) (#1423)

  • Make alter_table add_foreign_key with a column symbol reversible when using the :foreign_key_constraint_name option (jeremyevans) (#1422)

  • Do not raise an error if calling Model.freeze on a frozen model (jeremyevans) (#1421)

  • Make Database#copy_into in the jdbc/postgresql adapter handle multi-byte strings (ckoenig) (#1416)

  • Remove deprecated Model use_after_commit_rollback class and instance methods (jeremyevans)

  • Remove deprecated Model.allowed_columns method in the base model support (jeremyevans)

  • Remove deprecated Model.plugin_module_defined? private method (jeremyevans)

  • Remove deprecated support for Model#_before_validation private method (jeremyevans)

5.0.0 (2017-09-01)

  • Make bin/sequel -M option always use base 10 (jeremyevans)

  • Don't use savepoints when creating indexes inside a transaction on databases that don't support transactional schema modifications (jeremyevans) (#1407)

  • Support :if_not_exists option when creating indexes on PostgreSQL 9.5+ (DyegoCosta) (#1405)

  • Make threaded connection pools not block while connections are being made (jeremyevans)

  • SQL::Expression#clone and dup now return self, since all expressions should be frozen value objects (jeremyevans)

  • Don't create empty arrays for unused association callbacks (jeremyevans)

  • Cache association method name symbols instead of recomputing them everytime (jeremyevans)

  • Raise an exception if attempting to create a prepared statement using a dataset with a delayed evaluation (jeremyevans)

  • Make ConnectionPool#size thread safe by using the pool mutex (jeremyevans)

  • Use instance_exec instead of instance_eval when passing a block, to work with lambdas that accept no arguments (jeremyevans)

  • Freeze SQL::StringAgg instances in string_agg extension (jeremyevans)

  • Freeze SQL::DateAdd instances in date_arithmetic extension (jeremyevans)

  • Freeze SQL::Expression.comparison_attrs (jeremyevans)

  • Rename SQL::Subscript#f to expression, keeping f as an alias (jeremyevans)

  • Require the :pool_class Database option be a class to use a custom connection pool (jeremyevans)

  • Make the class_table_inheritance plugin raise an Error during update if any UPDATE query does not affect a single row (jeremyevans)

  • Change most send calls to public_send unless calling private methods is expected (jeremyevans)

  • Database schema and schema generator methods now return nil (jeremyevans)

  • Model#validates_unique in the validation helpers plugin now defaults to only checking on new or modified values (jeremyevans)

  • Deprecate Model#_before_validation (private_method), use Model#before_validation now (jeremyevans)

  • Always run before/after/around validation hooks when saving, even when not validating the object (jeremyevans)

  • Deprecate Model use_after_commit_rollback class and instance accessors (jeremyevans)

  • Deprecate Model.allowed_columns reader (jeremyevans)

  • Freeze internal constants that shouldn't be modified at runtime (jeremyevans)

  • Attempt to connect to the database immediately when creating the Database instance (jeremyevans)

  • Make association_pks plugin delay the setting of associated objects until the current object is saved by default (jeremyevans)

  • Joined datasets used as model datasets are now automatically wrapped in a subquery (jeremyevans)

  • Setting an invalid dataset for a model class now raises an exception by default (jeremyevans)

  • Getting all values for newly created models now happens before calling after_create, instead of after (jeremyevans)

  • Remove use of @was_new/@columns_updated instance variables when saving model objects (jeremyevans)

  • Disable symbol splitting by default (jeremyevans)

  • Make datasets frozen by default (jeremyevans)

  • Drop support for ruby 1.8.7, minimum now is 1.9.2 (jeremyevans)

  • Remove deprecated adapters, extensions, plugins, constants, and features (jeremyevans)

4.49.0 (2017-08-01)

  • Make dataset_associations plugin automatically alias tables when using many_through_many associations that join the same table multiple times (jeremyevans)

  • Deprecate using a :pool_class Database that is not a class or a symbol for a supported pool class (jeremyevans)

  • Deprecate :eager_loading_predicate_key association option and association reflection method (jeremyevans)

  • Deprecate Model.serialized_columns in the serialization plugin (jeremyevans)

  • Deprecate Model.cti_columns in the class_table_inheritance plugin (jeremyevans)

  • Deprecate SQL::AliasedExpression#aliaz, use alias instead (jeremyevans)

  • Deprecate SQL::Function#f, use name instead (jeremyevans)

  • Deprecate treating cross join with conditions as inner join on MySQL (jeremyevans)

  • Deprecate ConnectionPool#created_count, use size instead (jeremyevans)

  • Deprecate ConnectionPool::CONNECTION_POOL_MAP, use the :pool_class option to specify a non-default connection pool (jeremyevans)

  • Deprecate Sequel::IBMDB::Connection#prepared_statements= in the ibmdb adapter (jeremyevans)

  • Deprecate DEFAULT_OPTIONS in validation_helpers, override default_validation_helpers_options private method instead (jeremyevans)

  • Deprecate model association before callbacks returning false to cancel the action (jeremyevans)

  • Support native offset syntax on Oracle 12 (timon) (#1397)

  • Deprecate Dataset#nullify! in the null_dataset extension (jeremyevans)

  • Deprecate Dataset#autoid=, #_fetch=, and numrows= in the mock adapter (jeremyevans)

  • Deprecate loading plugins by requiring sequel_#{plugin} (jeremyevans)

  • Add Model.sti_class_from_sti_key in the single_table_inheritance plugin to get the appropriate class to use (Aryk) (#1396)

  • Make Sequel::Error#cause use wrapped_exception if it exists on ruby 2.1+ (jeremyevans)

  • Make Dataset#where_all, where_each, where_single_value core dataset methods instead of just model dataset methods (jeremyevans)

  • Make Database#extend_datasets and Dataset#with_extend now use a Dataset::DatasetModule instance if given a block (jeremyevans)

  • Add Sequel::Dataset::DatasetModule, now a superclass of Sequel::Model::DatasetModule (jeremyevans)

  • Make composition plugin with :mapping option work correctly if Model#get_column_value is overridden (jeremyevans)

  • Support Dataset#paged_each :stream => false option on mysql2 to disable streaming (Aryk) (#1395)

  • Make datetimeoffset handling in the jdbc/sqlserver adapter work on more drivers (jeremyevans)

  • Make alter_table add_primary_key work correctly on H2 1.4+ (jeremyevans)

  • Support :sslrootcert Database option in the postgres adapter (dleavitt) (#1391)

4.48.0 (2017-07-01)

  • Deprecate Model.<< (jeremyevans)

  • Deprecate Dataset#{and,exclude_where,range,interval}, move to sequel_4_dataset_methods extension (jeremyevans)

  • Make Database#indexes not include partial indexes on SQLite 3.8.8+ (jeremyevans)

  • Make Database#indexes include indexes created automatically from unique constraints on SQLite 3.8.8+ (jeremyevans)

  • Deprecate Sequel::Postgres::PG_TYPES, conversion procs should not be registered per-Database (jeremyevans)

  • Add Database#add_conversion_proc method on PostgreSQL for registering conversion procs (jeremyevans)

  • Deprecate unexpected values passed to Dataset#insert_conflict on SQLite (jeremyevans)

  • Deprecate Sequel::SqlAnywhere::Dataset#convert_smallint_to_bool= method (jeremyevans)

  • Deprecate Sequel::SqlAnywhere.convert_smallint_to_bool accessor (jeremyevans)

  • Use savepoints around index creation if creating table inside transaction if ignore_index_errors is used (jeremyevans)

  • Deprecate treating :natrual_inner join type on MySQL as NATURAL LEFT JOIN (jeremyevans)

  • Deprecate Dataset#mssql_unicode_strings= on Microsoft SQL Server (jeremyevans)

  • Preserve encoding when parsing PostgreSQL arrays (jeltz) (#1387)

  • Deprecate external modification of Sequel::JDBC::TypeConvertor (jeremyevans)

  • Deprecate Sequel::DB2.use_clob_as_blob accessor (jeremyevans)

  • Add Database#use_clob_as_blob accessor on DB2 (jeremyevans)

  • Deprecate SEQUEL_POSTGRES_USES_PG constant (jeremyevans)

  • Do not swallow original exception if exception is raised inside Database#copy_table on PostgreSQL (jeremyevans)

  • Deprecate Sequel::Postgres.client_min_messages and force_standard_strings accessors (jeremyevans)

  • Deprecate Sequel::Postgres.use_iso_date_format accessor (jeremyevans)

  • Do not allow connection in postgres adapter if postgres-pr driver is used and force_standard_strings is false (jeremyevans)

  • Drop support for ancient postgres driver in postgres adapter, now only pg and postgres-pr drivers are supported (jeremyevans)

  • Deprecate Sequel::MySQL.convert_invalid_date_time accessor (jeremyevans)

  • Deprecate Sequel::MySQL.convert_tinyint_to_bool accessor (jeremyevans)

  • Deprecate Sequel::MySQL.default_{charset,collate,engine} accessors (jeremyevans)

  • Add Database#default_{charset,collate,engine} accessors on MySQL (jeremyevans)

  • Make mock adapter thread safe (jeremyevans)

  • Deprecate Sequel::JDBC::Dataset#convert_types accessor (jeremyevans)

  • Add Dataset#with_convert_types in jdbc adapter (jeremyevans)

  • Deprecate Sequel::IBMDB::Dataset#convert_smallint_to_bool= method (jeremyevans)

  • Deprecate Sequel::IBMDB.convert_smallint_to_bool accessor (jeremyevans)

  • Add Database#convert_smallint_to_bool accessor in the ibmdb adapter (jeremyevans)

  • Deprecate sequel_3_dataset_methods extension (jeremyevans)

  • Deprecate query_literals extension (jeremyevans)

  • Deprecate using subtype conversion procs added after registering composite type in the pg_row extension (jeremyevans)

  • Don't try canceling copy in Database#copy_into if copier is not created yet (aakashAu) (#1384)

  • Deprecate global conversion procs added by pg_* extensions, when extension isn't loaded into Database instance (jeremyevans)

  • Deprecate Sequel::Postgres::PGRange.register in the pg_range extension (jeremyevans)

  • Deprecate Sequel::Postgres::PGArray.register in the pg_array extension (jeremyevans)

  • Deprecate Database#copy_conversion_procs (private method) on PostgreSQL (jeremyevans)

  • Deprecate Database#reset_conversion_procs on PostgreSQL (jeremyevans)

  • Deprecate meta_def extension (jeremyevans)

  • Make class_table_inheritance plugin with :alias option not use subquery for datasets that don't join (jeremyevans)

  • Deprecate hash_aliases extension (jeremyevans)

  • Deprecate filter_having extension (jeremyevans)

  • Deprecate empty_array_ignore_nulls extension (jeremyevans)

  • Deprecate Array#sql_array in the core_extensions extension (jeremyevans)

  • Make validation_helpers plugin :allow_blank option work correctly when the blank extension is not loaded (jeremyevans)

  • Make validation_class_methods plugin no longer require the blank extension (jeremyevans)

  • Clear cached associations when touching associations in the touch plugin (jeremyevans)

  • Make pg_array_associations model plugin load pg_array extension into database (jeremyevans)

  • Remove support for :strict option in nested_attributes plugin, use :unmatched_pk option instead (jeremyevans)

  • Make to_json class/dataset method in json_serializer plugin accept :instance_block option to pass block to Model#to_json (jeremyevans)

  • Make to_json methods in json_serializer plugin accept blocks that are used to transform values before serializing to JSON (jeremyevans)

  • Make Sequel.object_to_json pass block to to_json (jeremyevans)

  • Deprecate identifier_columns plugin, not needed with Sequel.split_symbols = false (jeremyevans)

  • Make reloading column_conflicts plugin not remove existing conflict markings (jeremyevans)

  • Deprecate cti_base_model, cti_key, and cti_model_map class methods in class_table_inheritance plugin (jeremyevans)

  • Make Model.skip_auto_validations(:not_null) in the auto_validations plugin skip not null checks for columns with default values (jeremyevans)

  • Make Database#copy_into in jdbc/postgresql adapter respect :server option (jeremyevans)

  • Make to_hash and to_hash_groups handle options in the static_cache plugin, and add rename to_hash to as_hash (jeremyevans)

  • Rename Dataset#to_hash to as_hash, and add to_hash as an alias, to allow undefing to_hash to fix ruby calling it implicitly (jeremyevans) (#1375)

  • Handle PG* constants deprecated in pg 0.21.0 in the postgres adapter (jeremyevans) (#1377, #1378)

  • Support :association_pks_use_associated_table association option in association_pks plugin (jeremyevans)

  • Make pg_hstore extension reset hstore conversion proc when running Database#reset_conversion_procs (jeremyevans)

  • Fix incorrect SQL used for inserting into a CTI subclass sharing the primary table when using the :alias option (jeremyevans)

4.47.0 (2017-06-01)

  • Deprecate pg_typecast_on_load plugin, only useful on deprecated do and swift adapters (jeremyevans)

  • Deprecate association_autoreloading and many_to_one_pk_lookup plugins, which were made the default model behavior in Sequel 4 (jeremyevans)

  • Deprecate setting invalid datasets for models unless required_valid_table = false (jeremyevans)

  • Make Model.require_valid_table = true not raise for datasets where Database#schema raises an error but Dataset#columns works (jeremyevans)

  • Make Database#with_server in the server_block extension accept a second argument for a different read_only shard (jeremyevans) (#1355)

  • Make schema_dumper extension handle Oracle 11g XE inclusion of not null in the db_type (StevenCregan, jeremyevans) (#1351)

  • Add Model.default_association_type_options for changing default association options per association type (jeremyevans)

  • Add :materialized option to Database#views on PostgreSQL to return materialized views (Blargel) (#1348)

  • Make defaults_setter plugin inherit custom default values when subclassing (jeremyevans)

4.46.0 (2017-05-01)

  • Recognize additional disconnect error on MySQL (jeremyevans)

  • Deconstantize dataset SQL generation, speeding up ruby 2.3+, slowing down earlier versions (jeremyevans)

  • Deprecate calling Dataset#set_graph_aliases before Dataset#graph (jeremyevans)

  • Don't swallow exception if there is an exception when rolling back a transaction when using :rollback=>:always option (jeremyevans)

  • Deprecate passing 2 arguments to Database#alter_table (jeremyevans)

  • Deprecate passing Schema::CreateTableGenerator instance as second argument to Database#create_table (jeremyevans)

  • Deprecate Database::DatasetClass as a way for getting default dataset classes for datasets (jeremyevans)

  • Deprecate SQLite pragma getting and setting methods (jeremyevans)

  • Remove handling of EMULATED_FUNCTION_MAP from adapter dataset classes, overide Dataset#native_function_name instead (jeremyevans)

  • Deprecate {Integer,Timestamp}Migrator::DEFAULT_SCHEMA_{COLUMN,TABLE} (jeremyevans)

  • Deprecate Database#jdbc_* methods for jdbc/db2 adapter Database instances (jeremyevans)

  • Remove addition of Database#jdbc_* to JDBC::Database in jdbc/db2 adapter (jeremyevans)

  • Deprecate many internal Database and Dataset string/regexp constants in core and included adapters (jeremyevans)

  • Remove use of Fixnum in sqlanywhere shared adapter (jeremyevans)

  • Deprecate Sequel::Schema::Generator constant, use Sequel::Schema::CreateTableGenerator instead (jeremyevans)

  • Deprecate Database#log_yield (jeremyevans)

  • Deprecate the set_overrides extension (jeremyevans)

  • If passing an empty array or hash and a block to a filtering method, ignore the array or hash and just use the block (jeremyevans)

  • Deprecate ignoring explicit nil argument when there is no existing filter (jeremyevans)

  • Deprecate ignoring explicit nil argument to filtering methods when passing a block (jeremyevans)

  • Deprecate ignoring empty strings and other empty? arguments passed to the filtering methods without a block (jeremyevans)

  • Deprecate calling filtering methods without an argument or a block (jeremyevans)

  • Deprecate Sequel::VirtualRow#` to create literal SQL, use Sequel.lit instead (jeremyevans)

  • Add auto_literal_strings extensions for treating plain strings passed to filtering/update methods as literal SQL (jeremyevans)

  • Deprecate automatically treating plain strings passed to filtering/update methods as literal SQL (jeremyevans)

  • Passing a PlaceholderLiteralString to a filtering method now uses parentheses around the expression (jeremyevans)

  • Make Dataset#full_text_search work on Microsoft SQL Server when no_auto_literal_strings extension is used (jeremyevans)

  • Fix Database#disconnect when using the single connection pool without an active connection (jeremyevans) (#1339)

  • Handle conversion of datetimeoffset values when using the jdbc/sqlserver adapter in some configurations (iaddict, jeremyevans) (#1338)

  • Fix conversion of some time values when using the jdbc/sqlserver adapter in some configurations (iaddict, jeremyevans) (#1337)

  • Use microsecond precision for time values on Microsoft SQL Server, instead of millisecond precision (jeremyevans)

  • Add Dataset#sqltime_precision private method for adapters to use different precision for Sequel::SQLTime than Time and Date (jeremyevans)

  • Use utc timezone in Sequel::SQLTime.create if Sequel.application_timezone is :utc (jeremyevans) (#1336)

  • Include migration filename in message about migration file without a single migration (jmettraux) (#1334)

  • Deprecate conversion of - to _ in adapter schemes (jeremyevans)

  • Don't quote function names that are SQL::Identifiers, unless SQL::Function#quoted is used (jeremyevans)

  • Deprecate splitting virtual row method names (jeremyevans)

  • Deprecate passing blocks to virtual row methods, move to virtual_row_method_block extension (jeremyevans)

  • Deprecate Sequel::SQL::Expression#sql_literal and lit (jeremyevans)

  • Don't issue deprecation warnings on ruby 1.8.7, as Sequel 5 is dropping support for it (jeremyevans)

  • Deprecate Sequel::BasicObject#remove_methods! (jeremyevans)

  • Deprecate sequel/no_core_ext file (jeremyevans)

  • Deprecate model dataset insert_sql accepting model instances (jeremyevans)

  • Deprecate model dataset join_table and graph accepting model classes (jeremyevans)

  • Support :alias option to class_table_inheritance plugin, wrapping subclass datasets in a subquery to fix ambiguous column issues (jeremyevans)

  • Deprecate Model.set_allowed_columns and Model#{set_all,set_only,update_all,update_only}, move to whitelist security plugin (jeremyevans)

  • Do not raise MassAssignmentRestriction when setting nested attributes and using the :fields option, only check for fields given (jeremyevans)

  • Do not add class methods for private methods definined in dataset_module (jeremyevans)

  • Deprecate Model.def_dataset_method and Model.subset, move to def_dataset_method plugin (jeremyevans)

  • Deprecate Model.finder and Model.prepared_finder, move to finder plugin (jeremyevans)

  • Deprecate calling Model.db= on a model with a dataset (jeremyevans)

  • Deprecate splitting symbols to look for qualified/aliased identifiers (e.g. :table__column) (jeremyevans)

  • Allow optimized lookups and deletes for models using SQL::Identifier and SQL::QualifiedIdentifier values as the FROM table (jeremyevans)

4.45.0 (2017-04-01)

  • Correctly handle datasets with offsets but no limits used in compound datasets on MSSQL <2012 (jeremyevans)

  • Correctly handle false values in the split_values plugin (bananarne) (#1333)

  • Deprecate Dataset#dup/clone and Model.dup/clone (jeremyevans)

  • Deprecate the schema and scissors plugins (jeremyevans)

  • Deprecate Model.{lazy_attributes,nested_attributes,composition,serialization}_module accessors (jeremyevans)

  • Deprecate Database#database_name on MySQL (jeremyevans)

  • Deprecate Database#use on MySQL (jeremyevans)

  • Make pg_hstore extension no longer update PG_NAMED_TYPES (jeremyevans)

  • Deprecate Sequel::PG_NAMED_TYPES (jeremyevans)

  • Add columns_updated plugin for making updated columns hash available in after_update and after_save hooks (jeremyevans)

  • Deprecate accessing @columns_updated directly in model after_update and after_save hooks (jeremyevans)

  • Deprecate Database#{add,remove}_servers when not using a sharded connection pool (jeremyevans)

  • Deprecate Database#each_server (jeremyevans)

  • Make Model#_valid? private method accept only an options hash (jeremyevans)

  • Deprecate returning false from model before hooks to cancel the action, use Model#cancel_action (jeremyevans)

  • Handle Model#cancel_action correctly in before hooks when Model#valid? is called (jeremyevans)

  • Deprecate Sequel::BeforeHookFailed (jeremyevans)

  • Deprecate passing multiple arguments as filter arguments when not using a conditions specifier (jeremyevans)

  • Deprecate passing Procs as filter arguments, require they be passed as blocks (jeremyevans)

  • Deprecate Sequel::Error::* exception class aliases (jeremyevans)

  • Deprecate prepared_statements_associations and prepared_statements_with_pk plugins (jeremyevans)

  • Deprecate Sequel::Unbinder, Sequel::UnbindDuplicate, and Dataset#unbind (jeremyevans)

  • Deprecating calling Sequel::Qualifier with two arguments (jeremyevans)

  • Add validation_contexts plugin for supporting custom contexts when validating (jeremyevans)

  • Deprecate Sequel::Database.single_threaded singleton accessor (jeremyevans)

  • Deprecate treating unrecognized prepared statement type as :select (jeremyevans)

  • Deprecate Sequel.identifier_{in,out}put_method= and .quote_identifiers= singleton setters (jeremyevans)

  • Deprecate Sequel::Database.identifier_{in,out}put_method and .quote_identifiers singleton accessors (jeremyevans)

  • Deprecate loading the identifier_mangling by default, require it be loaded explicitly if needed (jeremyevans)

  • Make Database#dump_{table_schema,schema_migration} in schema_dumper extension support :schema option (dadario) (#1328)

  • Make Dataset#delete respect an existing limit on Microsoft SQL Server (jeremyevans)

  • Add Dataset#skip_limit_check to mark a dataset as skipping the limit/offset check for updates and deletes (jeremyevans)

  • Deprecate calling Dataset#{update/delete/truncate} on datasets with limits or offsets unless the database supports it (jeremyevans)

  • Add deprecation message for using association_pks setter method with :delay_pks=>true association option (jeremyevans)

  • Add deprecation message for using association_pks setter method without :delay_pks association option (jeremyevans)

  • Deprecate having duplicate column names in subclass tables when using the class_table_inheritance plugin (jeremyevans)

  • Deprecate do (DataObjects), swift, and jdbc/as400 adapters (jeremyevans)

  • Deprecate support for Cubrid, Firebird, Informix, and Progress databases (jeremyevans)

  • The :proxy_argument option passed to association_proxies plugin block is now an empty hash if no arguments are passed to the association method (jeremyevans)

  • Deprecate passing non-hash arguments to association methods (jeremyevans)

  • Deprecate passing multiple arguments to association methods (jeremyevans)

  • Deprecate model transaction hook methods (jeremyevans)

  • Drop support for pg <0.8.0 in the postgres adapter (jeremyevans)

  • Deprecate passing a block to Database#from (jeremyevans)

  • Deprecate Sequel::Model::ANONYMOUS_MODEL_CLASSES{,_MUTEX} (jeremyevans)

  • Deprecate Sequel.cache_anonymous_models and Sequel.cache_anonymous_models= (jeremyevans)

  • Automatically use from_self when using a dataset as part of a compound if it has an offset but no limit (jeremyevans)

  • Drop order on existing datasets when using Dataset#union/intersect/except on Microsoft SQL Server unless a limit or offset is used (jeremyevans)

  • Deprecate dataset mutation (jeremyevans)

  • Handle dumping of autoincrementing 64-bit integer primary key columns correctly when using :same_db option in the schema dumper (jeremyevans) (#1324)

  • Add Model.dataset_module_class accessor, allowing plugins to support custom behavior in dataset_module blocks (jeremyevans)

  • Make ORDER BY come after UNION/INTERSECT/EXCEPT on Microsoft SQL Server and SQLAnywhere (jeremyevans)

  • Make Database#indexes on MySQL handle qualified identifiers (jeremyevans) (#1316)

  • Add oracle support to the odbc adapter (samuel02) (#1315)

4.44.0 (2017-03-01)

  • Add where_all, where_each, where_single_value model dataset methods, optimized for frozen datasets (jeremyevans)

  • Add eager method to dataset_module (jeremyevans)

  • Add implicit_subquery extension, for implicitly using a subquery for datasets using raw SQL when calling dataset methods that modify SQL (jeremyevans)

  • Make Dataset#from_self keep the columns from the current dataset if present (jeremyevans)

  • Add implicit_subquery extension, implicitly using subqueries for dataset methods if the current dataset uses raw SQL (jeremyevans)

  • Make SQL::ValueList#inspect show that it is a value list (jeremyevans)

  • Make LiteralString#inspect show that it is a literal string (jeremyevans)

  • Make Model::Associations::AssociationReflection#inspect show reflection class and guess at association definition line (jeremyevans)

  • Make SQLTime#inspect show it is an SQLTime instance, and only the time component (jeremyevans)

  • Make SQL::Blob#inspect show that it is a blob, the number of bytes, and some or all of the content (jeremyevans)

  • Make plugins not modify the constant namespace for the model class that uses them (jeremyevans)

  • Do not modify encoding of SQL::Blob instances in force_encoding plugin (jeremyevans)

  • Add Model.freeze_descendents to subclasses plugin, for easier finalizing associations/freezing of descendent classes (jeremyevans)

  • Add Model.finalize_associations method for finalizing associations, speeding up some association reflections methods almost 10x (jeremyevans)

  • Implement Model.freeze such that it can be used in production (jeremyevans)

  • Recognize another disconnect error in the jdbc/as400 adapter (perlun) (#1300)

  • Correctly handle conversion of false values when typecasting PostgreSQL arrays (mistoo) (#1299)

  • Raise error if the postgres adapter attempts to load an incompatible version of sequel_pg (mahlonsmith) (#1298)

  • Fix jdbc adapter so basic_type_convertor_map is not shared between instances, work with Database#freeze (jeremyevans)

4.43.0 (2017-02-01)

  • Make jdbc/postgresql adapter work if pg_hstore extension is loaded first (jeremyevans) (#1296)

  • Make prepared_statements_associations plugin work correctly on some instance specific associations (jeremyevans)

  • Make prepared_statements plugin not use prepared statements in cases where it is probably slower (jeremyevans)

  • Optimize Model#refresh similar to Model.with_pk (jeremyevans)

  • Make Database#extension not attempt to load the same extension more than once (jeremyevans)

  • Implement Database#freeze such that it can be used in production (jeremyevans)

  • Freeze enum_labels in the pg_enum extension (jeremyevans)

  • Handle Database#type_supported? thread-safely on PostgreSQL (jeremyevans)

  • Handle primary_key_sequences thread-safely on Oracle (jeremyevans)

  • Handle sharding better when using mysql2 native prepared statements (jeremyevans)

  • Use thread-safe incrementor for mock adapter autoid handling (jeremyevans)

  • Make Model#freeze not freeze associations hash until after validating the model instance (jeremyevans)

  • Make prepared_statements_associations plugin work correctly when model object explicitly specifies server to use when also using sharding plugin (jeremyevans)

  • Make prepared_statements_with_pk plugin work correctly when dataset explicitly specifies server to use (jeremyevans)

  • Make prepared_statements plugin work correctly when model object explicitly specifies server to use (jeremyevans)

  • Make dataset_module inherited to subclasses when using the single_table_inheritance plugin (jeremyevans) (#1284)

  • Support use of SQLite result codes in the jdbc-sqlite adapter, if the jdbc sqlite driver supports them (flash-gordon, jeremyevans) (#1283)

  • Make timestamp migrator handle key length limitations when using MySQL with InnoDB engine and utf8mb4 charset default (jeremyevans) (#1282)

4.42.0 (2017-01-01)

  • Handle eager load callbacks correctly for one_to_one associations with orders or offsets when window functions are not supported (jeremyevans)

  • Raise Sequel::Error if using an :eager_limit dataset option when eager loading a singular association (jeremyevans)

  • Replace internal uses of Dataset#select_more with select_append to save a method call (jeremyevans)

  • Make Dataset#order_append the primary method, and order_more the alias, for similarity to select_append and select_more (jeremyevans)

  • Replace internal uses of Dataset#filter with where to save a method call (jeremyevans)

  • Do not set :auto_increment in the schema information for integer columns that are part of a composite primary key on SQLite (jeremyevans)

  • Use autoincrement setting on integer primary key columns when emulating table modification methods on SQLite (thenrio, jeremyevans) (#1277, #1278)

  • Make the pagination extension work on frozen datasets (jeremyevans)

  • Make Dataset#server work for frozen model datasets using the sharding plugin (jeremyevans)

  • Make Dataset#nullify in the null_dataset extension work on frozen datasets (jeremyevans)

  • Make Model#set_server work when using a frozen model dataset (jeremyevans)

  • Make Dataset#ungraphed work on a frozen model dataset (jeremyevans)

  • Add Dataset#with_{autoid,fetch,numrows} to the mock adapter, returning cloned datasets with the setting changed (jeremyevans)

  • Make looser_typecasting extension handle the strict BigDecimal parsing introduced in ruby 2.4rc1 (jeremyevans)

  • Make Database#{db,opts}= in the sequel_3_dataset_methods extension raise for frozen datasets (jeremyevans)

  • Speed up repeated calls to Dataset#{interval,range} for frozen datasets using a cached placeholder literalizer (jeremyevans)

  • Speed up repeated calls to Dataset#get with a single argument for frozen datasets using a cached placeholder literalizer (jeremyevans)

  • Speed up repeated calls to Dataset#{first,last} with arguments/blocks for frozen datasets using a cached placeholder literalizer (jeremyevans)

  • Speed up repeated calls to Dataset#{avg,min,max,sum} for frozen datasets using a cached placeholder literalizer (jeremyevans)

  • Cache dataset returned by Dataset#skip_locked for frozen datasets (jeremyevans)

  • Cache dataset returned by Dataset#for_update for frozen datasets (jeremyevans)

  • Cache dataset returned by Dataset#un{filtered,grouped,limited,ordered} for frozen datasets (jeremyevans)

  • Cache dataset returned by Dataset#reverse (no args) for frozen datasets (jeremyevans)

  • Cache dataset returned by Dataset#invert for frozen datasets (jeremyevans)

  • Speed up repeated calls to Dataset#count with an argument or block for frozen datasets using a cached placeholder literalizer (jeremyevans)

  • Using :on_duplicate_columns=>:warn Database option with duplicate_columns_handler now prepends file/line to the warning message (jeremyevans)

  • Move identifier mangling code to identifier_mangling extension, load by default unless using :identifier_mangling=>false Database option (jeremyevans)

  • Allow Dataset#with_extend to accept a block and create a module with that block that the object is extended with (jeremyevans)

  • Speed up repeated calls to with_pk on the same frozen model dataset using a cached placeholder literalizer (jeremyevans)

  • Add dataset_module methods such as select and order that define dataset methods which support caching for frozen datasets (jeremyevans)

  • Cache subset datasets if they don't use blocks or procs for frozen model datasets (jeremyevans)

  • Cache intermediate dataset used in Dataset#{last,paged_each} for frozen model datasets without an order (jeremyevans)

  • Cache dataset returned by Dataset#naked for frozen datasets (jeremyevans)

  • Cache intermediate dataset used in Dataset#last (no args) for frozen datasets (jeremyevans)

  • Cache intermediate dataset used in Dataset#first (no args) and single_record for frozen datasets (jeremyevans)

  • Cache intermediate dataset used in Dataset#empty? for frozen datasets (jeremyevans)

  • Cache intermediate dataset used in Dataset#count (no args) for frozen datasets (jeremyevans)

  • Warn if :conditions option may be unexpectedly ignored during eager_graph/association_join (jeremyevans) (#1272)

  • Cache SELECT and DELETE SQL for most frozen datasets (jeremyevans)

  • Freeze most SQL::Expression objects and internal state by default (jeremyevans)

  • Freeze Dataset::PlaceholderLiteralizer and Dataset::PlaceholderLiteralizer::Argument instances (jeremyevans)

  • Freeze most dataset opts values to avoid unintentional modification (jeremyevans)

  • Add Dataset#with_convert_smallint_to_bool on DB2, returning a clone with convert_smallint_to_bool set (jeremyevans)

  • Make Dataset#freeze actually freeze the dataset on ruby 2.4+ (jeremyevans)

  • Avoid using instance variables other than @opts for dataset data storage (jeremyevans)

  • Add freeze_datasets extension, making all datasets for a given Database frozen (jeremyevans)

  • Refactor prepared statement internals, using opts instead of instance variables (jeremyevans)

  • Model.set_dataset now operates on a clone of the dataset given instead of modifying it, so it works with frozen datasets (jeremyevans)

4.41.0 (2016-12-01)

  • Add Dataset#with_mssql_unicode_strings on Microsoft SQL Server, returning a clone with mssql_unicode_strings set (jeremyevans)

  • Add Dataset#with_identifier_output_method, returning a clone with identifier_output_method set (jeremyevans)

  • Add Dataset#with_identifier_input_method, returning a clone with identifier_input_method set (jeremyevans)

  • Add Dataset#with_quote_identifiers, returning a clone with quote_identifiers set (jeremyevans)

  • Add Dataset#with_extend, returning a clone extended with given modules (jeremyevans)

  • Add Dataset#with_row_proc, returning a clone with row_proc set (jeremyevans)

  • Support use of SQL::AliasedExpressions as Model#to_json :include option keys in the json_serializer plugin (sensadrome) (#1269)

  • Major improvements to type conversion in the ado adapter (vais, jeremyevans) (#1265)

  • Avoid memory leak in ado adapter by closing result sets after yielding them (vais, jeremyevans) (#1259)

  • Fix hook_class_methods plugin handling of commit hooks (jeremyevans)

  • Make association dataset method correctly handle cases where key fields are nil (jeremyevans)

  • Handle pure java exceptions that don't support message= when reraising the exception in the jdbc adapter (jeremyevans)

  • Add support for :offset_strategy Database option on DB2, with :limit_offset and :offset_fetch values, to disable OFFSET emulation (#1254) (jeremyevans)

  • Remove deprecated support for using Bignum class as a generic type (jeremyevans)

4.40.0 (2016-10-28)

  • Make column_select plugin not raise an exception if the model's table does not exist (jeremyevans)

  • Make dataset_associations plugin correctly handle (many|one)_through_many associations with single join table (jeremyevans) (#1253)

  • Add s extension, with adds Sequel::S module that includes private #S method for calling Sequel.expr, including use as refinement (jeremyevans)

  • Add symbol_as and symbol_as_refinement extensions so that :column.as(:alias) is treated as Sequel.as(:column, :alias) (jeremyevans)

  • Add symbol_aref and symbol_aref_refinement extensions so that :table is treated as Sequel.qualify(:table, :column) (jeremyevans)

  • Add Sequel.split_symbols=, to support the disabling of splitting symbols with double/triple underscores (jeremyevans)

  • Make SQL::QualifiedIdentifier convert SQL::Identifier arguments to strings, fixing Sequel[:table] usage in schema methods (jeremyevans)

  • Do not attempt to combine non-associative operators (jeremyevans) (#1246)

  • Automatically add NOT NULL to columns when adding primary keys if the database doesn't handle it (jeremyevans)

  • Make prepared_statements plugin correctly handle lookup on joined datasets (jeremyevans) (#1244)

  • Make Database#tables with :qualify=>true option handle table names with double underscores correctly (jeremyevans) (#1241)

  • Add SQL::Identifier#[] and SQL::QualifiedIdentifier#[] for creating qualified identifiers (jeremyevans)

  • Add support for Dataset#insert_conflict :conflict_where option, for a predicate to use in ON CONFLICT clauses (chanks) (#1240)

  • Freeze Dataset::NON_SQL_OPTIONS, add private Dataset#non_sql_options, fixing thread safety issues during require (jeremyevans)

  • Make the callable returned by Database#rollback_checker thread safe (jeremyevans)

  • Make lazy_attributes and dataset_associations plugins work if insert_returning_select plugin is loaded before on model with no dataset (jeremyevans)

4.39.0 (2016-10-01)

  • Make active_model plugin use rollback_checker instead of after_rollback hook (jeremyevans)

  • Add Database#rollback_checker, which returns a proc that returns whether the in progress transaction is rolled back (jeremyevans)

  • Add Sequel::Database.set_shared_adapter_scheme to allow external adapters to support the mock adapter (jeremyevans)

  • Make hook_class_methods plugin not use after commit/rollback model hooks (jeremyevans)

  • Support add_column :after and :first options on MySQL (AnthonyBobsin, jeremyevans) (#1234)

  • Support ActiveSupport 5 in pg_interval extension when weeks/hours are used in ActiveSupport::Duration objects (chanks) (#1233)

  • Support IntegerMigrator :relative option, for running only the specified number of migrations up or down (jeremyevans)

  • Make the touch plugin also touch associations on create in addition to update and delete (jeremyevans)

  • Add :allow_manual_update timestamps plugin option for not overriding a manually set update timestamp (jeremyevans)

  • Add Sequel.[] as an alias to Sequel.expr, for easier expression creation (jeremyevans)

  • Add PostgreSQL full_text_search :to_tsquery=>:phrase option, for using PostgreSQL 9.6+ full text search phrase searching (jeremyevans)

  • Add JSONBOp#insert in pg_json_ops extension, for jsonb_insert support on PostgreSQL 9.6+ (jeremyevans)

  • Support add_column :if_not_exists option on PostgreSQL 9.6+ (jeremyevans)

4.38.0 (2016-09-01)

  • Support :driver_options option when using the postgres adapter with pg driver (jeremyevans)

  • Don't use after commit/rollback database hooks if the model instance methods are not overridden (jeremyevans)

  • Add SQL::NumericMethods#coerce, allowing code such as Sequel.expr{1 - x} (jeremyevans)

  • Support ** operator for exponentiation on expressions, similar to +, -, *, and / (jeremyevans)

  • Add Sequel::SQLTime.date= to set the date used for SQLTime instances (jeremyevans)

4.37.0 (2016-08-01)

  • Add support for regular expression matching on Oracle 10g+ using REGEXP_LIKE (johndcaldwell) (#1221)

  • Recognize an additional disconnect error in the postgres adapter (jeremyevans)

  • Make connection pool remove connections for disconnect errors not raised as DatabaseDisconnectError (jeremyevans)

  • Support mysql2 0.4+ native prepared statements and bound variables (jeremyevans)

  • Add Database#values for VALUES support on SQLite 3.8.3+ (jeremyevans)

  • Support create_view :columns option on SQLite 3.9.0+ (jeremyevans)

  • Make migration reverser handle alter_table add_constraint using a hash as the first argument (soupmatt) (#1215)

  • Make ASTTransformer handle Sequel.extract (jeremyevans) (#1213)

4.36.0 (2016-07-01)

  • Deprecate use of Bignum class as generic type, since the behavior will change in ruby 2.4 (jeremyevans)

  • Don't hold connection pool mutex while disconnecting connections (jeremyevans)

  • Don't hold references to disconnected connections in the connection_validator extension (jeremyevans)

  • Don't overwrite existing connection_validation_timeout when loading connection_validator extension multiple times (jeremyevans)

  • Add connection_expiration extension, for automatically removing connections open for too long (pdrakeweb) (#1208, #1209)

  • Handle disconnection errors raised during string literalization in mysql2 and postgres adapters (jeremyevans)

  • Add string_agg extension for aggregate string concatenation support on many databases (jeremyevans)

  • Add SQL::Function#order for ordered aggregate functions (jeremyevans)

  • Support operator validation in constraint_validations for <, <=, >, and >= operators with string and integer arguments (jeremyevans)

  • Make validates_operator validation consider nil values invalid unless :allow_nil or similar option is used (jeremyevans)

  • Close cursors for non-SELECT queries in the oracle adapter after execution, instead of waiting until GC (jeremyevans) (#1203)

  • Add :class_namespace association option for setting default namespace for :class option given as symbol/string (jeremyevans)

  • Add Sequel::Model.cache_anonymous_models accessor for changing caching on a per-model basis (jeremyevans)

  • Add Sequel::Model.def_Model for adding a Model() method to a module, for easier use of namespaced models (jeremyevans)

  • Add Sequel::Model::Model() for creating subclasses of Sequel::Model subclasses, instead of just Sequel::Model itself (jeremyevans)

4.35.0 (2016-06-01)

  • Add :headline option to PostgreSQL Dataset#full_text_search for adding an extract of the matched text to the SELECT list (jeremyevans)

  • Make :rollback=>:always inside a transaction use a savepoint automatically if supported (jeremyevans) (#1193)

  • Recognize bool type as boolean in the schema dumper (jeremyevans) (#1192)

  • Make Dataset#to_hash and to_hash_groups work correctly for model datasets doing eager loading (jeremyevans)

  • Make delay_add_association plugin handle hashes and primary keys passed to add_* association methods (jeremyevans) (#1187)

  • Treat :Bignum as a generic type, to support 64-bit integers on ruby 2.4+, where Bignum == Integer (jeremyevans)

  • Add server_logging extension for including server/shard information when logging queries (jeremyevans)

  • Add Database#log_connection_info, for including connection information when logging queries (jeremyevans)

  • Add Dataset#skip_locked for skipping locked rows on PostgreSQL 9.5+, MSSQL, and Oracle (jeremyevans)

  • Allow Sequel::Model#lock! to accept an optional lock style (petedmarsh) (#1183)

  • Add sql_comments extension for setting SQL comments on queries (jeremyevans)

  • Make Postgres::PGRange#cover? handle empty, unbounded, and exclusive beginning ranges (jeremyevans)

  • Fix frozen string literal issues on JRuby 9.1.0.0 (jeremyevans)

  • Allow json_serializer :include option with cascaded values to work correctly when used with association_proxies (jeremyevans)

4.34.0 (2016-05-01)

  • Add support for :dataset_associations_join association option to dataset_associations plugin, for making resulting datasets have appropriate joins (jeremyevans)

  • Log server connection was attempted to in PoolTimeout exception messages in sharded connection pool (jeremyevans)

  • Log Database :name option in PoolTimeout exception messages (bigkevmcd, jeremyevans) (#1176)

  • Add duplicate_columns_handler extension, for raising or warning if a dataset returns multiple columns with the same name (TSMMark, jeremyevans) (#1175)

  • Support registering per-Database custom range types in the pg_range extension (steveh) (#1174)

  • Support :preconnect=>:concurrently Database option for preconnecting in separate threads (kch, jeremyevans) (#1172)

  • Make prepared_statements_safe plugin work correctly with CURRENT_DATE/CURRENT_TIMESTAMP defaults (jeremyevans) (#1168)

  • Add validates_operator validation helper (petedmarsh) (#1170)

  • Recognize additional unique constraint violation on Microsoft SQL Server (jeremyevans)

  • Add :hash option to Dataset#(select|to)_hash(_groups)? methods for choosing object to populate (mwpastore) (#1167)

4.33.0 (2016-04-01)

  • Handle arbitrary objects passed as arguments to the association method (jeremyevans) (#1166)

  • Handle array with multiple columns as Dataset#insert_conflict :target value on PostgreSQL (chanks) (#1165)

  • Add Database#transaction :savepoint=>:only option, for only creating a savepoint if already inside a transaction (jeremyevans)

  • Make Database#sequence_for_table on Oracle handle cases where the schema for a table cannot be determined (jeremyevans)

  • The boolean_readers, boolean_subsets, and class_table_inheritance plugins no longer do blind rescues (jeremyevans) (#1162)

  • Add Model.require_valid_table setting, if set to true doesn't swallow any errors for invalid tables (jeremyevans)

  • Creating model classes inside a transaction when the table doesn't exist no longer rolls back the transaction on PostgreSQL (jeremyevans) (#1160)

  • Sequel::Model no longer swallows many errors when subclassing or setting datasets (jeremyevans) (#1160)

  • Handle altering column NULL settings for varchar(max) and text columns on MSSQL (Ilja Resch)

  • Remove Sequel.firebird and Sequel.informix adapter methods (jeremyevans)

  • Make graph_each extension handle result set splitting when using Dataset#first (jeremyevans)

  • Allow raising Sequel::ValidationFailed and Sequel::HookFailed without an argument (jeremyevans)

  • Allow schema_dumper to handle :qualify=>true option on PostgreSQL (jeremyevans)

  • Allow foreign_key schema method to handle SQL::Identifier and SQL::QualifiedIdentifier as 2nd argument (jeremyevans)

4.32.0 (2016-03-01)

  • Use mutex for synchronizing access to association reflection cache on MRI (jeremyevans)

  • Add Dataset#delete_from on MySQL, allowing deletions from multiple tables in a single query (jeremyevans) (#1146)

  • Add no_auto_literal_strings extension, which makes SQL injection vulnerabilities less likely (jeremyevans)

  • Add Model.default_association_options, for setting option defaults for all future associations (jeremyevans)

  • Support :association_pks_nil association option in association_pks setter for determining how to handle nil (jeremyevans)

  • Make association_pks setter handle empty array correctly when :delay_pks is set (jeremyevans)

  • Add a setter method for one_through_one associations (jeremyevans)

  • Include :remarks entry in JDBC schema parsing output, containing comments on the column (olleolleolle) (#1143)

  • Support :eager_reload and :eager options to associations in tactical_eager_loading plugin (jeremyevans)

  • Make tactical_eager_loading not eager load if passing proc or block to association method (jeremyevans)

  • Make eager_each plugin handle eager loading for Dataset#first and similar methods (jeremyevans)

4.31.0 (2016-02-01)

  • Convert types in association_pks setters before saving them, instead of just before running queries (jeremyevans)

  • Use getField and getOID instead of field and oid in the jdbc/postgresql adapter to work around JRuby 9.0.5.0 regression (jeremyevans) (#1137)

  • Support using PostgreSQL-specific types in bound variables in the jdbc/postgresql adapter (jeremyevans)

  • Add support for running with –enable-frozen-string-literal on ruby 2.3 (jeremyevans)

  • Make Database#disconnect in the oracle adapter work correctly on newer versions of oci8 (jeremyevans)

  • Support parsing PostgreSQL arrays with explicit bounds (jeremyevans) (#1131)

  • Raise an error if attempting to use a migration file not containing a single migration (jeremyevans) (#1127)

  • Automatically set referenced key for self referential foriegn key constraint for simple non-autoincrementing primary key on MySQL (jeremyevans) (#1126)

4.30.0 (2016-01-04)

  • Add Dataset#insert_conflict and insert_ignore on SQLite for handling uniqueness violations (Sharpie) (#1121)

  • Make Database#row_type in pg_row extension handle different formats of schema-qualified types (jeremyevans) (#1119)

  • Add identifier_columns plugin for handling column names containing 2 or more consecutive underscores when saving (jeremyevans) (#1117)

  • Support :eager_limit and :eager_limit_strategy dataset options in model eager loaders for per-call limits and strategies (chanks) (#1115)

  • Allow IPv6 addresses in database URLs on ruby 1.9+ (hellvinz, jeremyevans) (#1113)

  • Make Database#schema :db_type entries include sizes for string types on DB2 (jeremyevans)

  • Make Database#schema :db_type entries include sizes for string and decimal types in the jdbc adapter's schema parsing (jeremyevans)

  • Recognize another disconnect error in the tinytds adapter (jeremyevans)

4.29.0 (2015-12-01)

  • Add Model#json_serializer_opts method to json_serializer plugin, allowing for setting to_json defaults on per-instance basis (jeremyevans)

  • Add uuid plugin for automatically setting UUID column when creating a model object (pdrakeweb, jeremyevans) (#1106)

  • Allow the sqlanywhere adapter to work with sharding (jeremyevans)

  • Support blobs as bound variables in the oracle adapter (jeremyevans) (#1104)

  • Order by best results first when using the Database#full_text_search :rank option on PostgreSQL (chanks) (#1101)

  • Run Database#table_exists? inside a savepoint if currently in a transaction and the database supports savepoints (jeremyevans) (#1100)

  • Allow Database#transaction :retry_on option to work when using savepoints (jeremyevans)

  • Allow for external adapters to implement Dataset#date_add_sql_append to integrate with the date_arithmetic extension (jeremyevans)

  • Add Dataset#insert_empty_columns_values private method for easy overriding for databases that don't support INSERT with DEFAULT VALUES (jeremyevans)

4.28.0 (2015-11-02)

  • Add boolean_subsets plugin, which adds a subset for each boolean column (jeremyevans)

  • Add subset_conditions plugin, which adds a method for each subset returning the filter conditions for the subset (jeremyevans)

  • Make the list plugin work better with the auto_validations plugin when there is a validation on the position column (jeremyevans)

  • Make to_csv for model datasets call instance methods, just like Model#to_csv, in the csv_serializer plugin (skrobul) (#1088)

  • Raise Sequel::NoExistingObject instead of generic error if Model#refresh can't find the related row (jeremyevans)

4.27.0 (2015-10-01)

  • Don't stub Sequel.synchronize on MRI (YorickPeterse) (#1083)

  • Make bin/sequel warn if given arguments that it doesn't use (jeremyevans)

  • Fix the order of referenced composite keys returned by Database#foreign_key_list on PostgreSQL (jeremyevans) (#1081)

  • Recognize another disconnect error in the jdbc/postgresql adapter (jeremyevans)

  • In the active model plugin, make Model#persisted? return false if the transaction used for creation is rolled back (jeremyevans) (#1076)

  • Use primary_key :keep_order option in the schema dumper if the auto incrementing column is not the first column in the table (jeremyevans)

  • Set :auto_increment option correctly in the schema parser when the auto incrementing column is not the first column in the table (jeremyevans)

  • Support :keep_order option to primary_key in schema generator, to not automatically make the primary key the first column (jeremyevans)

  • Add new jsonb/json functions and operators supported in PostgreSQL 9.5+ (jeremyevans)

  • Add before_after_save plugin, for refreshing created objects and resetting modified flag before calling after_create/update/save hooks (jeremyevans)

  • Add Dataset#single_record! and single_value! which don't require cloning the receiver (jeremyevans)

  • Dataset#with_sql_single_value now works correctly for model datasets (jeremyevans)

  • Optimize Dataset#single_value and with_sql_single_value to not create an unnecessary array (jeremyevans)

  • Make postgres adapter work with postgres-pr 0.7.0 (jeremyevans) (#1074)

4.26.0 (2015-09-01)

  • Make Dataset#== not consider frozen status in determining equality (jeremyevans)

  • Support :if_exists option to drop_column on PostgreSQL (jeremyevans)

  • Add Dataset#grouping_sets to support GROUP BY GROUPING SETS on PostgreSQL 9.5+, MSSQL 2008+, Oracle, DB2, and SQLAnywhere (jeremyevans)

  • Fix handling of Class.new(ModelClass){set_dataset :table} on ruby 1.8 (jeremyevans)

  • Use range function constructors instead of casts for known range types in pg_range (jeremyevans) (#1066)

  • Make class_table_inheritance plugin work without sti_key (jeremyevans)

  • Detect additional disconnect errors when using the tinytds adapter (jeremyevans)

  • Make offset emulation without order but with explicit selection handle ambiguous column names (jeremyevans)

  • Allow preparing already prepared statements when emulating limits and/or offsets (jeremyevans)

  • Have Sequel::NoMatchingRow exceptions record the dataset related to the exception (pedro, jeremyevans) (#1060)

4.25.0 (2015-08-01)

  • Add Dataset#insert_conflict on PostgreSQL 9.5+, for upsert/insert ignore support using INSERT ON CONFLICT (jeremyevans)

  • Support Dataset#group_rollup and group_cube on PostgreSQL 9.5+ (jeremyevans)

  • Automatically REORG tables when altering when using jdbc/db2 (karlhe) (#1054)

  • Recognize constraint violation exceptions on swift/sqlite (jeremyevans)

  • Recognize another check constraint violation exception message on SQLite (jeremyevans)

  • Allow =~ and !~ to be used on ComplexExpressions (janko-m) (#1050)

  • Support case sensitive SQL Server 2012 in MSSQL metadata queries (knut2) (#1049)

  • Add Dataset#group_append, for appending to the existing GROUP BY clause (YorickPeterse) (#1047)

  • Add inverted_subsets plugin, for creating an inverted subset method for each subset (celsworth) (#1042)

  • Make Dataset#for_update not use the :read_only database when the dataset is executed (jeremyevans) (#1041)

  • Add singular_table_names plugin, for changing Sequel to not pluralize table names by default (jeremyevans)

  • PreparedStatement#prepare now raises an Error (jeremyevans)

  • Clear delayed association pks when refreshing an object (jeremyevans)

  • Add empty_array_consider_nulls extension to make Sequel consider NULL values when using IN/NOT IN with an empty array (jeremyevans)

  • Make Sequel default to ignoring NULL values when using IN/NOT IN with an empty array (jeremyevans)

  • Remove the deprecated firebird and informix adapters (jeremyevans)

  • Make :collate option when creating columns literalize non-String values on PostgreSQL (jeremyevans) (#1040)

  • Make dirty plugin notice when serialized column is changed (celsworth) (#1039)

  • Allow prepared statements to use RETURNING (jeremyevans) (#1036)

4.24.0 (2015-07-01)

  • Allow class_table_inheritance plugin to support subclasses that don't add additional columns (QuinnHarris, jeremyevans) (#1030)

  • Add :columns option to update_refresh plugin, specifying the columns to include in the RETURNING clause (celsworth) (#1029)

  • Use column symbol key for auto validation unique errors if the unique index is on a single column (jeremyevans)

  • Allow :timeout option to Database#listen in the postgres adapter to be a callable object (celsworth) (#1028)

  • Add pg_inet_ops extension, for DSL support for PostgreSQL inet/cidr operators and functions (celsworth, jeremyevans) (#1024)

  • Support :*_opts options in auto_validations plugin, for setting options for the underlying validation methods (celsworth, jeremyevans) (#1026)

  • Support :delay_pks association option in association_pks to delay setting of associated_pks until after saving (jeremyevans)

  • Make jdbc subadapters work if they issue queries while the subadapter is being loaded (jeremyevans) (#1022)

  • Handle 64-bit auto incrementing primary keys in jdbc subadapters (DougEverly) (#1018, #1019)

  • Remove the deprecated db2 and dbi adapters (jeremyevans)

  • Make auto_validation plugin use :from=>:values option to setup validations on the underlying columns (jeremyevans)

  • Add :from=>:values option to validation_helpers methods, for getting values from the values hash instead of a method call (jeremyevans)

4.23.0 (2015-06-01)

  • Make dataset.call_sproc(:insert) work in the jdbc adapter (flash-gordon) (#1013)

  • Add update_refresh plugin, for refreshing a model instance when updating (jeremyevans)

  • Add delay_add_association plugin, for delaying add_* method calls on new objects until after saving the object (jeremyevans)

  • Add validate_associated plugin, for validating associated objects when validating the current object (jeremyevans)

  • Make Postgres::JSONBOp#[] and get_text return JSONBOp instances (jeremyevans) (#1005)

  • Remove the fdbsql, jdbc/fdbsql, and openbase adapters (jeremyevans)

  • Database#transaction now returns block return value if :rollback=>:always is used (jeremyevans)

  • Allow postgresql:// connection strings as aliases to postgres://, for compatibility with libpq (jeremyevans) (#1004)

  • Make Model#move_to in the list plugin handle out-of-range targets without raising an exception (jeremyevans) (#1003)

  • Make Database#add_named_conversion_proc on PostgreSQL handle conversion procs for enum types (celsworth) (#1002)

4.22.0 (2015-05-01)

  • Deprecate the db2, dbi, fdbsql, firebird, jdbc/fdbsql, informix, and openbase adapters (jeremyevans)

  • Avoid hash allocations and rehashes (jeremyevans)

  • Don't silently ignore :jdbc_properties Database option in jdbc adapter (jeremyevans)

  • Make tree plugin set reciprocal association for children association correctly (lpil, jeremyevans) (#995)

  • Add Sequel::MassAssignmentRestriction exception, raised for mass assignment errors in strict mode (jeremyevans) (#994)

  • Handle ODBC::SQL_BIT type as boolean in the odbc adapter, fixing boolean handling on odbc/mssql (jrgns) (#993)

  • Make :auto_validations plugin check :default entry instead of :ruby_default entry for checking existence of default value (jeremyevans) (#990)

  • Adapters should now set :default schema option to nil when adapter can determine that the value is nil (jeremyevans)

  • Do not add a schema :max_length entry for a varchar(max) column on MSSQL (jeremyevans)

  • Allow :default value for PostgreSQL array columns to be a ruby array when using the pg_array extension (jeremyevans) (#989)

  • Add csv_serializer plugin for serializing model objects to and from csv (bjmllr, jeremyevans) (#988)

  • Make Dataset#to_hash and to_hash_groups handle single array argument for model datasets (jeremyevans)

  • Handle Model#cancel_action in association before hooks (jeremyevans)

  • Use a condition variable instead of busy waiting in the threaded connection pools on ruby 1.9+ (jeremyevans)

  • Use Symbol#to_proc instead of explicit blocks (jeremyevans)

4.21.0 (2015-04-01)

  • Support :tsquery and :tsvector options in Dataset#full_text_search on PostgreSQL, for using existing tsquery/tsvector expressions (jeremyevans)

  • Fix TinyTds::Error being raised when trying to cancel a query on a closed connection in the tinytds adapter (jeremyevans)

  • Add GenericExpression#!~ for inverting =~ on ruby 1.9 (similar to inverting a hash) (jeremyevans) (#979)

  • Add GenericExpression#=~ for equality, inclusion, and pattern matching (similar to using a hash) (jeremyevans) (#979)

  • Add Database#add_named_conversion_proc on PostgreSQL to make it easier to add conversion procs for types by name (jeremyevans)

  • Make Sequel.pg_jsonb return JSONBOp instances instead of JSONOp instances when passed other than Array or Hash (jeremyevans) (#977)

  • Demodulize default root name in json_serializer plugin (janko-m) (#968)

  • Make Database#transaction work in after_commit/after_rollback blocks (jeremyevans)

4.20.0 (2015-03-03)

  • Restore the use of AUTOINCREMENT on SQLite (jeremyevans) (#965)

  • Duplicate the associations hash when duplicating a model object (jeremyevans)

  • Correctly apply association limit when eager loading with an eager block using default limit strategy on some databases (jeremyevans)

  • Fix eager loading when using the :window_function limit strategy with an eager block and cascaded associations (jeremyevans)

  • Add support for set_column_type :auto_increment=>true to add AUTO_INCREMENT to existing column on MySQL (jeremyevans) (#959)

  • Add support for overridding the :instance_specific association option (jeremyevans)

  • Recognize MSSQL bit type as boolean in the schema_dumper (jeremyevans)

  • Skip eager loading queries if there are no matching keys (jeremyevans) (#952)

  • Dataset#paged_each now returns an enumerator if not passed a block (jeremyevans)

  • Use to_json :root option with string value as the JSON object key in the json_serializer plugin (jeremyevans)

  • Allow create_enum in the pg_enum extension be reversible in migrations (celsworth) (#951)

  • Have swift adapter respect database and application timezone settings (asppsa, jeremyevans) (#946)

  • Don't have the static cache plugin attempt to validate objects (jeremyevans)

  • Make freeze not validate objects if their errors are already frozen (jeremyevans)

  • Only use prepared statements for associations if caching association metadata (jeremyevans)

  • Set parent association when loading descendants in the rcte_tree plugin (jeremyevans)

  • Add Database#transaction :before_retry option, specifying a proc to call before retrying (uhoh-itsmaciek) (#941)

4.19.0 (2015-02-01)

  • Make jdbc/sqlanywhere correctly set :auto_increment entry in schema hashes (jeremyevans)

  • Add Model#cancel_action for canceling actions in before hooks, instead of having the hooks return false (jeremyevans)

  • Support not setting @@wait_timeout on MySQL via :timeout=>nil Database option (jeremyevans)

  • Add accessed_columns plugin, recording which columns have been accessed for a model instance (jeremyevans)

  • Use correct migration version when using IntegerMigrator with :allow_missing_migration_files (blerins) (#938)

  • Make Dataset#union, intersect, and except automatically handle datasets with raw SQL (jeremyevans) (#934)

  • Add column_conflicts plugin to automatically handle columns that conflict with method names (jeremyevans) (#929)

  • Add Model#get_column_value and set_column_value to get/set column values (jeremyevans) (#929)

4.18.0 (2015-01-02)

  • Make Dataset#empty? work when the dataset is ordered by a non-column expression (pete) (#923)

  • Fix passing a hash value to :eager association option (jeremyevans)

  • Treat all PG::ConnectionBad exceptions as disconnect errors in the postgres adapter (jeremyevans)

  • Add :auto_increment key to schema information for primary key columns (jeremyevans) (#919)

  • Fix handling of schema qualified tables in many_through_many associations (jeremyevans)

4.17.0 (2014-12-01)

  • Fix handling of Sequel::SQL::Blob instances in bound variables in the postgres adapter (jeremyevans) (#917)

  • Add :preconnect Database option for immediately creating the maximum number of connections (jeremyevans)

  • Support DB.pool.max_size for the single connection pools (jeremyevans)

  • Work around regression in jdbc-sqlite3 3.8.7 where empty blobs are returned as nil (jeremyevans)

  • Work around regression in jdbc-sqlite3 3.8.7 when using JDBC getDate method for date parsing (jeremyevans)

  • Make Model#update_or_create return object if existing object exists but updates are not necessary (contentfree) (#916)

  • Add Dataset#server? for conditionally setting a default server to use if no default is present (jeremyevans)

  • Add Database#sharded? for determining if database uses sharding (jeremyevans)

  • Fix server used by Dataset#insert_select on PostgreSQL (jeremyevans)

  • Fix server used for deleting model instances when using sharding (jeremyevans)

4.16.0 (2014-11-01)

  • Make Database#create_table? and create_join_table? not use IF NOT EXISTS if indexes are being added (jeremyevans) (#904)

  • Dataset#distinct now accepts virtual row blocks (chanks) (#901)

  • Recognize disconnect errors in the postgres adapter when SSL is used (jeremyevans) (#900)

  • Stop converting '' default values to nil default values on MySQL (jeremyevans)

  • Add Model#qualified_pk_hash, for returning a hash with qualified pk keys (jeremyevans)

  • Make validates_unique use a qualified primary key if the dataset is joined (jeremyevans) (#895)

  • Make Sequel::Model.cache_associations = false skip the database's schema cache when loading the schema (jeremyevans)

  • Make Database#foreign_key_list work on Microsoft SQL Server 2005 (jeremyevans)

  • Make create_table with :foreign option reversible on PostgreSQL (jeremyevans)

  • Make drop_table with :foreign option on PostgreSQL drop a foreign table (johnnyt) (#892)

4.15.0 (2014-10-01)

  • Make AssociationReflection#reciprocal not raise error if associated class contains association with invalid associated class (jeremyevans)

  • Make create_view(:view_name, dataset, :materialized=>true) reversible on PostgreSQL (jeremyevans)

  • Add support for creating foreign tables on PostgreSQL using :foreign and :options create_table options (jeremyevans)

  • Raise Error if a primary key is necessary to use an association, but the model doesn't have a primary key (jeremyevans)

  • Make tactical_eager_loading plugin work for limited associations (jeremyevans)

  • Add PlaceholderLiteralizer#with_dataset, for returning a new literalizer using a modified dataset (jeremyevans)

  • Support active_model 4.2.0beta1 in the active_model plugin (jeremyevans)

  • Make Dataset#insert in the informix adapter return last inserted id (jihwans) (#887)

  • Support :nolog option in the informix adapter to disable transactions (jihwans) (#887)

  • Remove optional argument for Postgres::{JSON,JSONB}Op#to_record and to_recordset (jeremyevans)

  • Add support for FoundationDB SQL Layer, via fdbsql and jdbc/fdbsql adapters (ScottDugas, jeremyevans) (#884)

  • Work around bug in old versions of MySQL when schema dumping a table with multiple timestamp columns (jeremyevans) (#882)

  • Support more array types by default in the pg_array extension, such as xml[] and uuid[] (jeremyevans)

  • Add Sequel::Model.cache_associations accessor, which can be set to false to not cache association metadata (jeremyevans)

  • Add split_values plugin, for moving noncolumn entries from the values hash into a separate hash (jeremyevans) (#868)

4.14.0 (2014-09-01)

  • Raise original exception if there is an exception raised when rolling back transaction/savepoint (jeremyevans) (#875)

  • Allow delayed evaluation blocks to take dataset as an argument (jeremyevans)

  • Allow more types as filter expressions, only specifically disallow Numeric/String expressions (jeremyevans)

  • Remove objects from cached association array at time of nested_attributes call instead of waiting until save (jeremyevans)

  • Handle composite primary keys when working around validation issues for one_to_(one|many) associations in nested_attributes plugin (jeremyevans) (#870)

  • Recognize additional disconnect error in jdbc/jtds adapter (jeremyevans)

  • Have association_join work with existing model selections (jeremyevans)

  • Fix regression in class_table_inheritance plugin when lazily loading column in middle table (jeremyevans) (#862)

  • Add cache_key_prefix method to caching plugin, which can be overridden for custom handling (pete) (#861)

  • Add :when option to PostgreSQL create_trigger method, for adding a filter to the trigger (aschrab) (#860)

  • Recognize an additional serialization failure on PostgreSQL (tmtm) (#857)

4.13.0 (2014-08-01)

  • Use copy constructors instead of overriding Model#dup and clone (ged, jeremyevans) (#852)

  • Fix handling of MySQL create_table foreign_key calls using :key option (mimperatore, jeremyevans) (#850)

  • Handle another disconnection error in the postgres adapter (lbosque) (#848)

  • Make list plugin update remaining positions after destroying an instance (ehq, jeremyevans) (#847)

  • Unalias aliased tables in Dataset#insert (jeremyevans)

  • Add insert_returning_select plugin, for setting up RETURNING for inserts for models selecting explicit columns (jeremyevans)

  • Make Model#save use insert_select if the dataset used for inserting already uses returning (jeremyevans)

  • Add Dataset#unqualified_column_for helper method, returning unqualified version of possibly qualified column (jeremyevans)

  • Calling Dataset#returning when the Database does not support or emulate RETURNING now raises an Error (jeremyevans)

  • Emulate RETURNING on Microsoft SQL Server using OUTPUT, as long as only simple column references are used (jeremyevans)

  • Switch class_table_inheritance plugin to use JOIN ON instead of JOIN USING (jeremyevans)

  • Qualify primary keys for models with joined datasets when looking up model instances by primary key (jeremyevans)

  • Fix qualification of columns when Dataset#graph automatically wraps the initially graphed dataset in a subselect (jeremyevans)

  • Make Dataset#joined_dataset? a public method (jeremyevans)

  • Allow external jdbc, odbc, and do subadapters to be loaded automatically (jeremyevans)

  • Recognize another disconnect error in the jdbc/mysql adapter (jeremyevans)

  • Set primary keys correctly for models even if datasets select specific columns (jeremyevans)

  • Add dataset_source_alias extension, for automatically aliasing datasets to their first source (jeremyevans)

  • Use qualified columns in the lazy_attributes plugin (jeremyevans)

  • Add column_select plugin, for using explicit column selections in model datasets (jeremyevans)

  • Use associated model's existing selection for join associations if it consists solely of explicitly quailfied columns (jeremyevans)

  • Add round_timestamps extension for automatically rounding timestamp values to database precision before literalizing (jeremyevans)

  • Make rake default task run plugin specs as well as core/model specs (jeremyevans)

  • Use all_tables and all_views for Database#tables and views on Oracle (jeremyevans)

  • Use all_tab_cols instead of user_tab cols for defaults parsing in the oracle adapter (jeremyevans)

  • Fix recursive mutex locking issue on JRuby when using Sequel::Model(dataset) (jeremyevans) (#841)

  • Make composition and serialization plugins support validations on underlying columns (jeremyevans)

  • Fix regression in timestamps and table inheritance plugin where column values would not be saved if validation is skipped (jeremyevans) (#839)

  • Add pg_enum extension, for dealing with PostgreSQL enums (jeremyevans)

  • Add modification_detection plugin, for automatic detection of in-place column value modifications (jeremyevans)

  • Speed up using plain strings, numbers, true, false, and nil in json columns if underlying json library supports them (jeremyevans) (#834)

4.12.0 (2014-07-01)

  • Support :readonly Database option in sqlite adapter (ippeiukai, jeremyevans) (#832)

  • Automatically setup max_length validations for string columns in the auto_validations plugin (jeremyevans)

  • Add :max_length entry to column schema hashes for string types (jeremyevans)

  • Add :before_thread_exit option to Database#listen_for_static_cache_updates in pg_static_cache_updater extension (jeremyevans)

  • Add Database#values on PostgreSQL to create a dataset that uses VALUES instead of SELECT (jeremyevans)

  • Add Model#set_nested_attributes to nested_attributes, allowing setting nested attributes options per-call (jeremyevans)

  • Use explicit columns when using automatically prepared SELECT statements in the prepared statement plugins (jeremyevans)

  • Make Dataset#insert_select on PostgreSQL respect existing RETURNING clause (jeremyevans)

  • Fix eager loading limited associations via a UNION when an association block is used (jeremyevans)

  • Associate reciprocal object before saving associated object when creating new objects in nested_attributes (chanks, jeremyevans) (#831)

  • Handle intervals containing more than 100 hours in the pg_interval extension's parser (will) (#827)

  • Remove methods/class deprecated in 4.11.0 (jeremyevans)

  • Allow Dataset#natural_join/cross_join and related methods to take a options hash passed to join_table (jeremyevans)

  • Add :reset_implicit_qualifier option to Dataset#join_table, to set false to not reset the implicit qualifier (jeremyevans)

  • Support :notice_receiver Database option when postgres adapter is used with pg driver (jeltz, jeremyevans) (#825)

4.11.0 (2014-06-03)

  • Add :model_map option to class_table_inheritance plugin so class names don't need to be stored in the database (jeremyevans)

  • Set version when using for MySQL/SQLite emulation in the mock adapter (jeremyevans)

  • Add support for CUBRID/SQLAnywhere emulation to the mock adapter (jeremyevans)

  • Add support for the jsonb operators added in PostgreSQL 9.4 to the pg_json_ops extension (jeremyevans)

  • Add support for new json/jsonb functions added in PostgreSQL 9.4 to the pg_json_ops extension (jeremyevans)

  • Add support for the PostgreSQL 9.4+ jsonb type to the pg_json_ops extension (jeremyevans)

  • Add support for derived column lists to Sequel.as and SQL::AliasMethods#as (jeremyevans)

  • Support connecting to a DB2 catalog name in the ibmdb adapter (calh) (#821)

  • Fix warnings in some cases in the ibmdb adapter (calh) (#820)

  • Add SQL::Function#with_ordinality for creating set returning functions WITH ORDINALITY (jeremyevans)

  • Add SQL::Function#filter for creating filtered aggregate function calls (jeremyevans)

  • Add SQL::Function#within_group for creating ordered-set and hypothetical-set aggregate functions (jeremyevans)

  • Add SQL::Function#lateral, for creating set returning functions that will be preceded by LATERAL (jeremyevans)

  • Add SQL::Function#quoted and unquoted methods, to enable/disable quoting of function names (jeremyevans)

  • Deprecate Dataset#{window,emulated,}_function_sql_append (jeremyevans)

  • Deprecate SQL::WindowFunction and SQL::EmulatedFunction classes, switch to using options on SQL::Function (jeremyevans)

  • Only modify changed_columns if deserialized value changes in the serialization plugin (jeremyevans) (#818)

  • Support PostgreSQL 9.4+ jsonb type in the pg_json extension (jeremyevans)

  • Allow Postgres::ArrayOp#unnest to accept arguments in the pg_array_ops extension (jeremyevans)

  • Add Postgres::ArrayOp#cardinality to the pg_array_ops extension (jeremyevans)

  • Add :check option to Database#create_view for WITH [LOCAL] CHECK OPTION support (jeremyevans)

  • Add :concurrently option to Database#refresh_view on PostgreSQL to support concurrent refresh of materialized views (jeremyevans)

  • Call the :after_connect Database option proc with both the connection and server/shard if it accepts 2 arguments (pedro, jeremyevans) (#813)

  • Make multiple plugins set values before validation instead of before create, works better with auto_validations (jeremyevans)

  • Support a default Dataset#import slice size, set to 500 on SQLite (jeremyevans) (#810)

  • Make :read_only transaction option be per-savepoint on PostgreSQL (jeremyevans) (#807)

  • Add :rank option to Dataset#full_text_search on PostgreSQL, to order by the ranking (jeremyevans) (#809)

  • Remove methods deprecated in 4.10.0 (jeremyevans)

4.10.0 (2014-05-01)

  • Make Model.include API same as Module.include (ged) (#803)

  • Dataset::PlaceholderLiteralizer now handles DelayedEvaluations correctly (jeremyevans)

  • Refactor type conversion in the jdbc adapter, for up to a 20% speedup (jeremyevans)

  • Add Dataset#with_fetch_size to jdbc adapter, for setting fetch size for JDBC ResultSets (jeremyevans)

  • Default to a fetch_size of 100 in the jdbc/oracle adapter, similar to the oci8-based oracle adapter (jeremyevans)

  • Add Database#fetch_size accessor and :fetch_size option to jdbc adapter, for setting JDBC Statement fetch size (jeremyevans)

  • Automatically determine array type in pg_array_associations plugin, explicitly cast arrays in more places (jeremyevans, maccman) (#800)

  • Speed up Dataset#literal for symbols 60% by caching results, speeding up dataset literalization up to 40% or more (jeremyevans)

  • Speed up Sequel.split_symbol 10-20x by caching results, speeding up dataset literalization up to 80% or more (jeremyevans)

  • Speed up dataset literalization for simple datasets by up to 100% (jeremyevans)

  • Support :fractional_seconds Database option on MySQL 5.6.5+ to support fractional seconds by default (jeremyevans) (#797)

  • Work around MySQL 5.6+ bug when combining DROP FOREIGN KEY and DROP INDEX in same ALTER TABLE statement (jeremyevans)

  • Make auto_validations plugin handle models that select from subqueries (jeremyevans)

  • Recognize additional disconnect errors in the postgres adapter (jeremyevans)

  • Make import/multi_insert insert multiple rows in a single query using a UNION on Oracle, DB2, and Firebird (jeremyevans)

  • Speed up association_pks many_to_many setter method by using Dataset#import (jeremyevans)

  • Add Model.prepared_finder, similar to .finder but using a prepared statement (jeremyevans)

  • Model.def_{add_method,association_dataset_methods,remove_methods} are now deprecated (jeremyevans)

  • Model.eager_loading_dataset and Model.apply_association_dataset_opts are now deprecated (jeremyevans)

  • Make prepared_statement_associations plugin handle one_through_one and one_through_many associations (jeremyevans)

  • Use placeholder literalizer for regular association loading for up to 85% speedup (jeremyevans)

  • Use placeholder literalizer for eager association loading for up to 20% speedup (jeremyevans)

  • Make Model#marshallable! work correctly when using the tactical_eager_loading plugin (jeremyevans)

  • Respect :foreign_key_constraint_name option when adding columns to existing table on MySQL (noah256) (#795)

  • AssociationReflection#association_dataset now handles joining tables if necessary (jeremyevans)

  • Support drop_view :if_exists option on SQLite, MySQL, H2, and HSQLDB (jeremyevans) (#793)

  • Support drop_table :if_exists option on HSQLDB (jeremyevans)

  • Add Database#transaction :auto_savepoint option, for automatically using a savepoint in nested transactions (jeremyevans)

  • Add :server_version Database option on Microsoft SQL Server, instead of querying the database for it (jeremyevans)

  • Support :correlated_subquery as an eager_graph and filter by associations limit strategy for one_to_* associations (jeremyevans)

  • Support named paramters in call_mssql_sproc on Microsoft SQL Server (y.zemlyanukhin, jeremyevans) (#792)

  • Handle placeholder literalizer arguments when emulating offsets (jeremyevans)

  • Don't attempt to emulate offsets if the dataset uses literal SQL (jeremyevans)

  • Use a UNION-based strategy by default to eagerly load limited associations (jeremyevans)

  • Support offsets without limits on MySQL, SQLite, H2, SQLAnywhere and CUBRID (jeremyevans)

  • Remove the install/uninstall rake tasks (jeremyevans)

  • Use INSERT VALUES with multiple rows for Dataset#import and multi_insert on more databases (jeremyevans)

  • Support common table expressions (WITH clause) on SQLite >=3.8.3 (jeremyevans)

4.9.0 (2014-04-01)

  • Recognize CHECK constraint violations on newer versions of SQLite (jeremyevans)

  • Do not attempt to eager load when calling Dataset#columns in the eager_each plugin (jeremyevans)

  • Support :driver option for jdbc adapter, for specifying driver class for cases where getConnection doesn't work (jeremyevans) (#785)

  • Massive speedup for PostgreSQL array parser (jeremyevans) (#788)

  • Add current_datetime_timestamp extension, for current Time/DateTime instances that are literalized as CURRENT_TIMESTAMP (jeremyevans)

  • Recognize additional unique constraint violations on SQLite (jeremyevans) (#782)

  • Don't remove column value when validating nested attributes for one_to_* association where association foreign key is the model's primary key (jeremyevans)

  • Add Dataset#disable_insert_returning on PostgreSQL for skipping implicit use of RETURNING (jeremyevans)

  • Automatically optimize Model.[], .with_pk, and .with_pk! for models with composite keys (jeremyevans)

  • Automatically optimize Model.[] when called with a hash (jeremyevans)

  • Automatically optimize Model.find, .first, and .first! when called with a single argument (jeremyevans)

  • Add Model.finder for creating optimized finder methods using Dataset::PlaceholderLiteralizer (jeremyevans)

  • Add Dataset::PlaceholderLiteralizer optimization framework (jeremyevans)

  • Add Dataset#with_sql_{each,all,first,single_value,insert,update} optimized methods (jeremyevans)

  • Make pg_array extension use correct type when typecasting column values for smallint, oid, real, character, and varchar arrays (jeremyevans)

  • Make Database#column_schema_to_ruby_default a public method in the schema_dumper extension (jeremyevans) (#776)

  • Fix multiple corner cases in the eager_graph support (jeremyevans) (#771)

  • Use streaming to implement paging for Dataset#paged_each in the mysql2 adapter (jeremyevans)

  • Use a cursor to implement paging for Dataset#paged_each in the postgres adapter (jeremyevans)

  • Add Database#create_join_table? and create_join_table! for consistency (jeremyevans)

  • Add Dataset#where_current_of to the postgres adapter for supporting updating rows based on a cursor's current position (jeremyevans)

  • Add Dataset#use_cursor :hold option in the postgres adapter for supporting cursor use outside of a transaction (jeremyevans)

  • Add Dataset#paged_each :strategy=>:filter option for increased performance (jeremyevans)

4.8.0 (2014-03-01)

  • Add SQL::AliasedExpression#alias alias for aliaz (jeremyevans)

  • Handle SQL::Identifier, SQL::QualifiedIdentifier, and SQL::AliasedExpression objects as first argument to Dataset#graph (jeremyevans)

  • Respect qualification and aliases in symbols passed as first argument to Dataset#graph (dividedmind) (#769)

  • Recognize new constraint violation error messages in SQLite 3.8.2+ (itswindtw) (#766)

  • Use limit strategy to correctly handle limited associations in the dataset_associations plugin (jeremyevans)

  • Handle issues in dataset_associations plugin when dataset uses unqualified identifiers for associations requiring joins (jeremyevans)

  • Handle fractional seconds in input timestamps in the odbc/mssql adapter (Ross Attrill, jeremyevans)

  • Return fractional seconds in timestamps in the odbc adapter (jeremyevans)

  • Support :plain and :phrase options to Dataset#full_text_search on PostgreSQL (jeremyevans)

  • Use limit strategy to correctly handle filtering by limited associations (jeremyevans)

  • Simplify queries used for filtering by associations with conditions (jeremyevans)

  • Use an eager limit strategy by default for *_one associations with orders (jeremyevans)

  • Support :limit_strategy eager_graph option, for specifying strategy used for limited associations in that eager graph (jeremyevans)

  • Add eager_graph_with_options to model datasets, for specifying options specific to the eager_graph call (jeremyevans)

  • Handle offsets on *_many associations when eager graphing when there are no associated results (jeremyevans)

  • Make Database#register_array_type work without existing scalar conversion proc in the pg_array extension (jeremyevans)

  • Handle presence validations on foreign keys in associated objects when creating new associated objects in the nested_attributes plugin (jeremyevans)

  • Respect offsets when eager graphing *_one associations (jeremyevans)

  • Add association_join to model datasets, for setting up joins based on associations (jeremyevans)

  • Add one_through_many association to many_through_many plugin, for only returning a single record (jeremyevans)

  • Add :graph_order association option, useful when :order needs to contain qualified identifiers (jeremyevans)

  • Add one_through_one association, similar to many_to_many but only returning a single record (jeremyevans)

4.7.0 (2014-02-01)

  • Don't swallow underlying exception if there is an exception closing the cursor on PostgreSQL (jeremyevans) (#761)

  • Recognize primary key unique constraint violations on MSSQL and SQLAnywhere (jeremyevans)

  • Recognize composite unique constraint violations on SQLite (timcraft) (#758)

  • Make #* method without arguments on SQL::Function return a Function with * prepended to the arguments (jeremyevans)

  • Add function to SQL::Identifier and SQL::QualifiedIdentifier, allowing for easy use of schema qualified functions or functions names that need quoting (jeremyevans)

  • Add SQL::Function#distinct for easier creation of aggregate functions using DISTINCT (jeremyevans)

  • Add SQL::Function#over for easier creation of window functions (jeremyevans)

  • Don't clear validation instance_hooks until after a successful save (jeremyevans)

  • Support :raise_on_save_failure option for one_to_many, pg_array_to_many, and many_to_pg_array associations (jeremyevans)

  • Make SQLTime#to_s return a string in HH:MM:SS format, since it shouldn't include date information (jeremyevans)

  • Support the Database#tables :schema option in the jdbc adapter (robbiegill, jeremyevans) (#755)

  • Automatically rollback transactions in killed threads in ruby 2.0+ (chanks) (#752)

  • Add update_or_create plugin, for updating an object if it exists, or creating such an object if it does not (jeremyevans)

  • Make auto_validations uniqueness validations work correctly for STI subclasses (jeremyevans)

  • Support :dataset option to validates_unique vaildation (jeremyevans)

4.6.0 (2014-01-02)

  • Add Database#call_mssql_sproc on MSSQL for calling stored procedures and handling output parameters (jrgns, jeremyevans) (#748)

  • Handle RuntimeErrors raised by oci8 in the oracle adapter (jeremyevans)

  • Support OFFSET/FETCH on Microsoft SQL Server 2012 (jeremyevans)

  • Support :server option for Database#{commit,rollback}_prepared_transaction on PostgreSQL, MySQL, and H2 (jeremyevans) (#743)

  • Do not attempt to eager load and raise an exception when doing Model.eager(…).naked.all (jeremyevans)

  • Recognize a couple additional disconnect errors in the jdbc/postgresql adapter (jeremyevans) (#742)

4.5.0 (2013-12-02)

  • Support :on_commit=>(:drop|:delete_rows|:preserve_rows) options when creating temp tables on PostgreSQL (rosenfeld) (#737)

  • Make Dataset#insert work on PostgreSQL if the table name is a SQL::PlaceholderLiteralString (jeremyevans) (#736)

  • Copy unique constraints when emulating alter_table operations on SQLite (jeremyevans) (#735)

  • Don't return clob column values as SQL::Blob instances in the db2 and ibmdb adapters unless use_clob_as_blob is true (jeremyevans)

  • Make use_clob_as_blob false by default on DB2 (jeremyevans)

  • Fix usage of Sequel::SQL::Blob objects as prepared statement arguments in jdbc/db2 adapter when use_clob_as_blob is false (jeremyevans)

  • Add mssql_optimistic_locking plugin, using a timestamp/rowversion column to protect against concurrent updates (pinx, jeremyevans) (#731)

  • Make Model.primary_key array immutable for composite keys (chanks) (#730)

4.4.0 (2013-11-01)

  • Make Database#tables not show tables in the recycle bin on Oracle (jeremyevans) (#728)

  • Don't automatically order on all columns when emulating offsets for unordered datasets on DB2 (jeremyevans)

  • Improve PostgreSQL type support in the jdbc/postgresql adapter (jeremyevans)

  • Make offset emulation on Oracle work when using columns that can't be ordered (jeremyevans, sdeming) (#724, #725)

  • Make filter by associations support handle associations with :conditions or block (jeremyevans)

  • Make association cloning handle :block correctly for clones of clones (jeremyevans)

  • Make association cloning handle :eager_block option correctly (jeremyevans)

  • Make add_primary_key work on h2 (jeremyevans)

  • Add support for foreign key parsing on Oracle (jeremyevans)

  • Add support for foreign key parsing to the jdbc adapter (jeremyevans)

  • Make add_foreign_key work on HSQLDB (jeremyevans)

  • Add table_select plugin for selecting table.* instead of * for model datasets (jeremyevans)

  • Issue constraint_validation table deletes before inserts, so modifying constraint via drop/add in same alter_table block works (jeremyevans)

  • Support add_*/remove_*/remove_all_* pg_array_to_many association methods on unsaved model objects (jeremyevans)

  • Add Sybase SQLAnywhere support via new sqlanywhere and jdbc/sqlanywhere adapters (gditrick, jeremyevans)

  • Add Dataset#offset for setting the offset separately from the limit (Paul Henry, jeremyevans) (#717)

4.3.0 (2013-10-02)

  • Fix literalization of empty blobs on MySQL (jeremyevans) (#715)

  • Ensure Dataset#page_count in pagination extension is at least one (jeremyevans) (#714)

  • Recognize another disconnect error in the jdbc/as400 adapter (jeremyevans)

  • Make Dataset#qualify and Sequel.delay work together (jeremyevans)

  • Recognize citext type as string on PostgreSQL (isc) (#710)

  • Support composite keys in the rcte_tree plugin (jeremyevans)

  • Support composite keys in the tree plugin (jeremyevans)

  • Make Migrator.migrator_class public (robertjpayne, jeremyevans) (#708)

  • Make PostgreSQL empty array literalization work correctly on PostgreSQL <8.4 (jeremyevans)

  • Add Sequel extensions guide (jeremyevans)

  • Add model plugins guide (jeremyevans)

  • Add error_sql Database extension, allowing DatabaseError#sql to return SQL query that caused underlying exception (jeremyevans)

  • Make Dataset#each_page in pagination extension return enumerator if no block is given (justinj) (#702)

4.2.0 (2013-09-01)

  • Support custom :flags option in mysql2 adapter (jeremyevans) (#700)

  • Add implementations of Dataset#freeze and Dataset#dup (jeremyevans)

  • Add implementations of Model#dup and Model#clone (jeremyevans)

  • Don't have partial_indexes returned by Database#indexes on MSSQL 2008+ (jeremyevans)

  • Support partial indexes on SQLite 3.8.0+ (jeremyevans)

  • Add Database#supports_partial_indexes? to check for partial index support (mluu, jeremyevans) (#698)

  • The static_cache plugin now disallows saving/destroying if the :frozen=>false option is not used (jeremyevans)

  • Support :frozen=>false option in static_cache plugin, for having new instances returned instead of frozen cached instances (jeremyevans)

  • Add pg_static_cache_updater Database extension for listening for changes to tables and updating static_cache caches automatically (jeremyevans)

  • Add mssql_emulate_lateral_with_apply extension for emulating LATERAL queries using CROSS/OUTER APPLY (jeremyevans)

  • Support LATERAL queries via Dataset#lateral (jeremyevans)

  • Add pg_loose_count Database extension, for fast approximate counts of PostgreSQL tables (jeremyevans)

  • Add from_block Database extension, for having Database#from block affect FROM instead of WHERE (jeremyevans)

  • Support :cursor_name option in postgres adapter Dataset#use_cursor (heeringa, jeremyevans) (#696)

  • Fix placeholder literal strings when used with an empty placeholder hash (trydionel, jeremyevans) (#695)

4.1.1 (2013-08-01)

  • Fix select_map, select_order_map, and single_value methods on eager_graphed datasets (jeremyevans)

4.1.0 (2013-08-01)

  • Support :inherits option in Database#create_table on PostgreSQL, for table inheritance (jeremyevans)

  • Handle dropping indexes for schema qualified tables on PostgreSQL (jeremyevans)

  • Add Database#error_info on PostgreSQL 9.3+ if pg-0.16.0+ is used, to get a hash of metadata for a given database exception (jeremyevans)

  • Allow prepared_statements plugin to work with instance_filters and update_primary_key plugins (jeremyevans)

  • Support deferrable exclusion constraints on PostgreSQL using the :deferrable option (mfoody) (#687)

  • Make Database#run and << accept SQL::PlaceholderLiteralString values (jeremyevans)

  • Deprecate :driver option in odbc adapter since it appears to be broken (jeremyevans)

  • Support :drvconnect option in odbc adapter for supplying the ODBC connection string directly (jeremyevans)

  • Support mysql2 0.3.12+ result streaming via Dataset#stream (jeremyevans)

  • Convert Java::JavaUtil::HashMap to ruby Hash in jdbc adapter, for better handling of PostgreSQL hstore type (jeremyevans) (#686)

  • Raise NoMatchingRow if calling add_association with a primary key value that doesn't match an existing row (jeremyevans)

  • Allow PostgreSQL add_constraint to support :not_valid option (jeremyevans)

  • Allow CHECK constraints to have options by using an options hash as the constraint name (jeremyevans)

  • Correctly raise error when using an invalid virtual row block function call (jeremyevans)

  • Support REPLACE on SQLite via Dataset#replace and multi_replace (etehtsea) (#681)

4.0.0 (2013-07-01)

  • Correctly parse composite primary keys on SQLite 3.7.16+ (jeremyevans)

  • Recognize another disconnect error in the jdbc/oracle adapter (jeremyevans)

  • Add pg_json_ops extension for calling JSON functions and operators in PostgreSQL 9.3+ (jeremyevans)

  • Handle non-JSON plain strings, integers, and floats in PostgreSQL JSON columns in pg_json extension (jeremyevans)

  • Dataset#from now accepts virtual row blocks (jeremyevans)

  • Add Database#refresh_view on PostgreSQL to support refreshing materialized views (jeremyevans)

  • Support the Database#drop_view :if_exists option on PostgreSQL (jeremyevans)

  • Support the Database#{create,drop}_view :materialized option for creating materialized views in PostgreSQL 9.3+ (jeremyevans)

  • Support the Database#create_view :recursive option for creating recursive views in PostgreSQL 9.3+ (jeremyevans)

  • Support the Database#create_view :columns option for using explicit columns (jeremyevans)

  • Support the Database#create_schema :owner and :if_not_exists options on PostgreSQL (jeremyevans)

  • Support :index_type=>:gist option to create GIST full text indexes on PostgreSQL (jeremyevans)

  • Add Postgres::ArrayOp#replace for the array_replace function in PostgreSQL 9.3+ (jeremyevans)

  • Add Postgres::ArrayOp#remove for the array_remove function in PostgreSQL 9.3+ (jeremyevans)

  • Add Postgres::ArrayOp#hstore for creating hstores from arrays (jeremyevans)

  • Make Postgres::ArrayOp#[] return ArrayOp if given a range (jeremyevans)

  • Ensure that CHECK constraints are surrounded with parentheses (jeremyevans)

  • Ensure Dataset#unbind returned variable hash uses symbol keys (jeremyevans)

  • Add pg_array_associations plugin, for associations based on PostgreSQL arrays containing foreign keys (jeremyevans)

  • Add Sequel.deep_qualify, for easily doing a deep qualification (jeremyevans)

  • Enable use of window functions for limited eager loading by default (jeremyevans)

  • Handle offsets correctly when eager loading one_to_one associations (jeremyevans)

  • Raise exception for infinite and NaN floats on MySQL (jeremyevans) (#677)

  • Make dataset string literalization that requires database connection use dataset's chosen server (jeremyevans)

  • Make sure an offset without a limit is handled correctly when eager loading (jeremyevans)

  • Allow providing ranges as subscripts for array (jeremyevans)

  • Prepare one_to_one associations in the prepared_statements_associations plugin (jeremyevans)

  • Use prepared statements when the association has :conditions in the prepared_statements_associations plugin (jeremyevans)

  • Fix prepared statement usage in some additional cases in the prepared_statements_associations plugin (jeremyevans)

  • Hex escape blob input on MySQL (jeremyevans)

  • Handle more disconnect errors when using the postgres adapter with the postgres-pr driver (jeremyevans)

  • Model#setter_methods private method now accepts 1 argument instead of 2 (jeremyevans)

  • Model#set_restricted and update_restricted private methods now accept 2 arguments instead of 3 (jeremyevans)

  • ungraphed on an eager_graph dataset now resets the original row_proc (jeremyevans)

  • eager_graph now returns a naked dataset (jeremyevans)

  • All behavior deprecated in Sequel 3.48.0 has been removed (jeremyevans)

  • Make adapter/integration spec environment variables more consistent (jeremyevans)

  • Sequel no longer provides default databases for adapter/integration specs (jeremyevans)

  • Model#save no longer calls #_refresh internally (jeremyevans)

  • Model#set_all and update_all can now update the primary key (jeremyevans)

  • Integrate many_to_one_pk_lookup and association_autoreloading plugins into main associations plugin (jeremyevans)

  • Make defaults_setter plugin operate in a lazy manner (jeremyevans)

  • Plugins now extend the model class with ClassMethods before including InstanceMethods (jeremyevans)

  • Remove Model::EMPTY_INSTANCE_VARIABLES (jeremyevans)

  • Model.raise_on_typecast_failure now defaults to false (jeremyevans)

  • Model#_save private method now only takes a single argument (jeremyevans)

  • Remove Dataset#columns_without_introspection from columns_introspection extension (jeremyevans)

  • Make boolean prepared statement arguments work on sqlite adapter when integer_booleans is true (jeremyevans)

  • Make Database#tables and views reflect search_path on PostgreSQL (jeremyevans)

  • SQLite now defaults to true for integer_booleans and false for use_timestamp_timezones (jeremyevans)

  • Make the default value for most option hashes a shared frozen hash (jeremyevans)

  • Remove Sequel::NotImplemented exception (jeremyevans)

  • Automatically alias single expressions in Dataset#get, select_map, and select_order_map, to work around possible DoS issues (jeremyevans)

  • Use a connection queue instead of stack by default for threaded connection pools (jeremyevans)

  • Remove SQL::SQLArray alias for SQL::ValueList (jeremyevans)

  • Remove SQL::NoBooleanInputMethods empty module (jeremyevans)

Older

See doc/CHANGELOG.old