|
|
|
|
Changelog for ruby2.1-rubygem-sequel-5.16.0-1.1.x86_64.rpm :
* Mon Jan 14 2019 Stephan Kulow - updated to version 5.16.0 see installed CHANGELOG === 5.16.0 (2019-01-02) * Convert integer columns to bigint columns when copying SQLite databases to other databases using bin/sequel -C (jeremyevans) (#1584) * Use nicer error messages for missing or empty migration directories (Lavode) (#1585) * Make alter table emulation work correctly in SQLite 3.26.0+ (jeremyevans) (#1582) * Do not unset new one_to_one associated objects\' reciprocal associations before saving associated objects in the nested_attributes plugin (jeremyevans) * Do not validate new one_to_one associated objects twice when saving in the nested_attributes plugin (jeremyevans) * Fix :qualify_tables option to class_table_inheritance plugin to work correctly with subclasses of subclasses (benalavi) (#1581) * Make class_table_inheritance plugin use the schema cache instead of sending a query to get columns for tables (kenaniah) (#1580) * Remove loading of mysqlplus in the mysql adapter (jeremyevans) * Make mysql adapter work correctly on ruby 2.6+ (jeremyevans) * Add Database#rollback_on_exit to rollback transactions instead of committing them when exiting the transaction block (jeremyevans) * Enable window functions in SQLite 3.26.0+ (jeremyevans) * Do not override existing methods when creating Sequel::Model attribute getter/setter methods (jeremyevans) (#1578) * Use parentheses for expressions being subscripted (e.g. (array_agg(column))[1]) (jeremyevans) * Sat Dec 08 2018 Stephan Kulow - updated to version 5.15.0 see installed CHANGELOG === 5.15.0 (2018-12-01) * Add :conn_str option in the postgres adapter for PostgreSQL connection strings, if the pg driver is used (graywolf) (#1572) * Add :qualify_tables option to class_table_inheritance plugin to automatically qualify subclass tables with superclass qualifier (benalavi) (#1571) * Access already allocated connections in a thread safe manner when checking out connections in the sharded threaded connection pool (jeremyevans) * Automatically support datasets using qualified tables in the class_table_inheritance plugin without having to use the :alias option (benalavi) (#1565) * Support rename_column without emulation on SQLite 3.25+ (jeremyevans) * Do not remove currently cached many_to_one associated objects when changing the related foreign key value from nil to non-nil (jeremyevans) * Do not validate new *_to_many associated objects twice when saving in the nested_attributes plugin (jeremyevans) * Add Model#skip_validation_on_next_save! for skipping validation on next save call (jeremyevans) * Thu Nov 22 2018 Stephan Kulow - updated to version 5.14.0 see installed CHANGELOG === 5.14.0 (2018-11-01) * Drop defaulting the :port option to 5432 in the postgres adapter, so that setting the :service option in :driver_options works (jeremyevans) (#1558) * Do not cache values for columns without parseable defaults when using :cache option in defaults_setter plugin (jeremyevans) * Emulate NULLS FIRST/LAST ordering on databases that do not natively support it (jeremyevans) * Do not modify boolean expressions created from string or array if string or array is modified (jeremyevans) * Make roots and roots_dataset dataset methods instead of class methods in the tree plugin (JelF) (#1554) * Do not cache dataset SQL if dataset uses subquery that cannot cache SQL (jeremyevans) * Make Model#=== work correctly for models with composite primary keys (jeremyevans) * Add Model#pk_equal? as a more descriptive name for Model#=== (AlexWayfer) (#1550) * Do not push down expression inversion in cases where it may result in incorrect behavior (e.g. ANY/SOME/ALL operators) (jeremyevans) (#1549) === 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) * Wed Sep 05 2018 cooloAATTsuse.com- updated to version 5.12.0 see installed CHANGELOG === 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) * Sun Jul 01 2018 factory-autoAATTkulow.org- updated to version 5.10.0 see installed CHANGELOG === 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) * Fri Jun 01 2018 factory-autoAATTkulow.org- updated to version 5.9.0 see installed CHANGELOG === 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) * Tue May 01 2018 factory-autoAATTkulow.org- updated to version 5.8.0 see installed CHANGELOG * Thu Apr 05 2018 factory-autoAATTkulow.org- updated to version 5.7.1 see installed CHANGELOG === 5.7.1 (2018-04-04) * Don\'t use identity columns if :serial=>true or :type=>:serial|:bigserial column options are used (#1490) (jeremyevans) * Mon Apr 02 2018 factory-autoAATTkulow.org- updated to version 5.7.0 see installed CHANGELOG === 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) * Fri Mar 02 2018 factory-autoAATTkulow.org- updated to version 5.6.0 see installed CHANGELOG === 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) * Tue Feb 27 2018 factory-autoAATTkulow.org- updated to version 5.5.0 see installed CHANGELOG === 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 AATTdataset instance variable when subclassing Sequel::Model (bjmllr) (#1435) * Wed Oct 11 2017 cooloAATTsuse.com- updated to version 5.1.0 see installed CHANGELOG === 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) * Mon Sep 11 2017 cooloAATTsuse.com- updated to version 5.0.0 see installed CHANGELOG === 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 AATTwas_new/AATTcolumns_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) * Thu Aug 03 2017 cooloAATTsuse.com- updated to version 4.49.0 see installed CHANGELOG === 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) * Tue Jun 06 2017 cooloAATTsuse.com- updated to version 4.47.0 see installed CHANGELOG === 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) * Tue May 23 2017 cooloAATTsuse.com- updated to version 4.46.0 see installed CHANGELOG === 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) * Sun Apr 02 2017 cooloAATTsuse.com- updated to version 4.45.0 see installed CHANGELOG === 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 AATTcolumns_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) * Thu Mar 02 2017 cooloAATTsuse.com- updated to version 4.44.0 see installed CHANGELOG === 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) * Thu Feb 02 2017 cooloAATTsuse.com- updated to version 4.43.0 see installed CHANGELOG * Sat Jan 14 2017 cooloAATTsuse.com- updated to version 4.42.1 see installed CHANGELOG === 4.42.1 (2017-01-12) * Make dataset_module inherited to subclasses when using the single_table_inheritance plugin (jeremyevans) (#1284) * Mon Jan 02 2017 cooloAATTsuse.com- updated to version 4.42.0 see installed CHANGELOG === 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 AATTopts 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) * Fri Dec 02 2016 cooloAATTsuse.com- updated to version 4.41.0 see installed CHANGELOG === 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) * Sat Oct 29 2016 cooloAATTsuse.com- updated to version 4.40.0 see installed CHANGELOG === 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[:column] 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[:schema][: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) * Sun Oct 02 2016 cooloAATTsuse.com- updated to version 4.39.0 see installed CHANGELOG === 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) * Fri Sep 02 2016 cooloAATTsuse.com- updated to version 4.38.0 see installed CHANGELOG === 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) * Tue Aug 02 2016 cooloAATTsuse.com- updated to version 4.37.0 see installed CHANGELOG === 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) * Sat Jul 02 2016 cooloAATTsuse.com- updated to version 4.36.0 see installed CHANGELOG === 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) * Thu Jun 02 2016 cooloAATTsuse.com- updated to version 4.35.0 see installed CHANGELOG === 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) * Mon May 02 2016 cooloAATTsuse.com- updated to version 4.34.0 see installed CHANGELOG === 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) * Wed Apr 06 2016 cooloAATTsuse.com- updated to version 4.33.0 see installed CHANGELOG === 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) * Wed Mar 02 2016 cooloAATTsuse.com- updated to version 4.32.0 see installed CHANGELOG === 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) * Tue Feb 02 2016 cooloAATTsuse.com- updated to version 4.31.0 see installed CHANGELOG === 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) * Thu Jan 21 2016 cooloAATTsuse.com- updated to version 4.30.0 see installed CHANGELOG === 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) * Wed Dec 02 2015 cooloAATTsuse.com- updated to version 4.29.0 see installed CHANGELOG === 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) * Tue Nov 03 2015 cooloAATTsuse.com- updated to version 4.28.0 see installed CHANGELOG === 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) * Fri Oct 02 2015 cooloAATTsuse.com- updated to version 4.27.0 see installed CHANGELOG === 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) * Wed Sep 02 2015 cooloAATTsuse.com- updated to version 4.26.0 see installed CHANGELOG === 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) * Sun Aug 02 2015 cooloAATTsuse.com- updated to version 4.25.0 see installed CHANGELOG === 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) * Thu Jul 02 2015 cooloAATTsuse.com- updated to version 4.24.0 see installed CHANGELOG === 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) * Tue Jun 02 2015 cooloAATTsuse.com- updated to version 4.23.0 see installed CHANGELOG === 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) * Sat May 02 2015 cooloAATTsuse.com- updated to version 4.22.0 see installed CHANGELOG === 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) * Thu Apr 02 2015 cooloAATTsuse.com- updated to version 4.21.0 * Thu Mar 05 2015 cooloAATTsuse.com- updated to version 4.20.0 * 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) * Tue Feb 10 2015 cooloAATTsuse.com- updated to version 4.19.0 * Wed Nov 12 2014 cooloAATTsuse.com- updated to version 4.16.0 * 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) * Fri Oct 17 2014 cooloAATTsuse.com- updated to version 4.15.0, see CHANGELOG * Mon Oct 13 2014 cooloAATTsuse.com- adapt to new rubygem packaging * Sun May 18 2014 cooloAATTsuse.com- updated to version 4.10.0 * 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) * Sun Apr 06 2014 cooloAATTsuse.com- updated to version 4.9.0 * 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) * Tue Mar 18 2014 cooloAATTsuse.com- updated to version 4.8.0 * 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) * Thu Feb 06 2014 cooloAATTsuse.com- updated to version 4.7.0 * 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) * Sun Jan 05 2014 cooloAATTsuse.com- updated to version 4.6.0 * 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) * Tue Dec 03 2013 cooloAATTsuse.com- updated to version 4.5.0 * 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) * Fri Nov 22 2013 cooloAATTsuse.com- updated to version 4.4.0 * 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) * Fri Oct 04 2013 cooloAATTsuse.com- updated to version 4.3.0 * 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) * Tue Sep 03 2013 cooloAATTsuse.com- updated to version 4.2.0 * 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) * Tue Aug 06 2013 cooloAATTsuse.com- updated to version 4.1.1 * Fix select_map, select_order_map, and single_value methods on eager_graphed datasets (jeremyevans) * 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) * Wed Jul 31 2013 cooloAATTsuse.com- updated to version 4.0.0 * Correctly parse composite primary keys on SQLite 3.7.16+ (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) * Mon Jun 03 2013 cooloAATTsuse.com- updated to version 3.48.0 * Make named_timezones extension usable by databases allowing timezone strings to be given to Database#timezone= (jeremyevans) * Make Dataset#or just clone if given an empty argument (jeremyevans) * Deprecated using a mismatched number of placeholders and arguments in a placeholder literal string (jeremyevans) * Add Dataset#qualify_to and #qualify_to_first_source to sequel_3_dataset_methods extension (jeremyevans) * Add scissors plugin for Model.update, .delete, and .destroy (jeremyevans) * Validate against explicit nil values in NOT NULL columns with default values in the auto_validations plugin (jeremyevans) * Support :not_null=>:presence option for auto_validations plugin, for using presence validation for not null columns (jeremyevans) * Rename auto_validate_presence_columns to auto_validate_not_null_columns (jeremyevans) * Make pg_hstore_ops extension integrate with pg_array, pg_hstore, and pg_array_ops extensions (jeremyevans) * Add Sequel.json_parser_error_class and Sequel.object_to_json to allow the use of alternative JSON implementations (jeremyevans) (#662) * Deprecate JSON.create_id usage in the json_serializer plugin (jeremyevans) * Emulate offsets on Microsoft Access using reverse orders and total counts (jeremyevans) (#661) * Make ado adapter handle disconnecting an already disconnected connection (jeremyevans) * Deprecate parsing columns for the same table name in multiple schemas on jdbc (jeremyevans) * Allow association_proxies plugin to accept a block to give user control over which methods are proxied to the dataset (jeremyevans) (#660) * Deprecate calling Dataset#add_graph_aliases before #graph or #set_graph_aliases (jeremyevans) * Deprecate Model.add_graph_aliases, .insert_multiple, .query, .set_overrides, .set_defaults, .to_csv, and .paginate (jeremyevans) * Add guide for ordering code with Sequel (jeremyevans) * Deprecate Database#transaction :disconnect=>:retry option (jeremyevans) * Deprecate Model.set, .update, .delete, and .destroy (jeremyevans) * Deprecate Dataset#set (jeremyevans) * Add specs for bin/sequel (jeremyevans) * Make constraint_validations plugin reflect validations by column (jeremyevans) * Allow for per-model/per-validation type customization of validation options in constraint_validations plugin (jeremyevans) * Mon May 13 2013 cooloAATTsuse.com- updated to version 3.47.0 * Don\'t fail for missing conversion proc in pg_typecast_on_load plugin (jeremyevans) * Rename PGRangeOp #starts_before and #ends_after to #ends_before and #starts_after (soupmatt) (#655) * Add Database#supports_schema_parsing? for checking for schema parsing support (jeremyevans) * Handle hstore[] types on PostgreSQL if using pg_array and pg_hstore extensions (jeremyevans) * Don\'t reset conversion procs when loading pg_ * extensions (jeremyevans) * Handle domain types when parsing the schema on PostgreSQL (jeremyevans) * Handle domain types in composite types in the pg_row extension (jeremyevans) * Add Database.extension, for loading an extension into all future databases (jeremyevans) * Support a :search_path Database option for setting PostgreSQL search_path (jeremyevans) * Support a :convert_infinite_timestamps Database option in the postgres adapter (jeremyevans) * Support a :use_iso_date_format Database option in the postgres adapter, for per-Database specific behavior (jeremyevans) * Add Model.default_set_fields_options, for having a model-wide default setting (jeremyevans) * Make Model.map, .to_hash, and .to_hash_groups work without a query when using the static_cache plugin (jeremyevans) * Support :hash_dup and Proc Model inherited instance variable types (jeremyevans) * Handle aliased tables in the pg_row plugin (jeremyevans) * Add input_transformer plugin, for automatically transform input to model column setters (jeremyevans) * Add auto_validations plugin, for automatically adding not null, type, and unique validations (jeremyevans) * Add validates_not_null to validation_helpers (jeremyevans) * Add :setter, :adder, :remover, and :clearer association options for overriding the default modification behavior (jeremyevans) * Add Database#register_array_type to the pg_array extension, for registering database-specific array types (jeremyevans) * Speed up fetching model instances when using update_primary_key plugin (jeremyevans) * In the update_primary_key plugin, if the primary key column changes, clear related associations (jeremyevans) * Add :allow_missing_migration_files option to migrators, for not raising if migration files are missing (bporterfield) (#652) * Fix race condition related to prepared_sql for newly prepared statements (jeremyevans) (#651) * Support :keep_reference=>false Database option for not adding reference to Sequel::DATABASES (jeremyevans) * Sat Apr 13 2013 cooloAATTsuse.com- updated to version 3.46.0 * Add Dataset#cross_apply and Dataset#outer_apply on Microsoft SQL Server (jeremyevans) * Speed up threaded connection pools when :connection_handling=>:queue is used (jeremyevans) * Allow external connection pool classes to be loaded automatically (jeremyevans) * Add Dataset#with_pk! for model datasets, like #with_pk, but raising instead of returning nil (jeremyevans) * Add Dataset#first!, like #first, but raising a Sequel::NoMatchingRow exception instead of returning nil (jeremyevans) * Dataset #select_map, #select_order_map, and #get no longer support a plain string inside an array of arguments (jeremyevans) * Escape ] characters in identifiers on Microsoft SQL Server (jeremyevans) * Add security guide (jeremyevans) * Make validates_type handle false values correctly (jeremyevans) (#636) * Have associations, composition, serialization, and dirty plugins clear caches in some additional cases (jeremyevans) (#635) * Add alter_table drop_foreign_key method for dropping foreign keys by column names (raxoft, jeremyevans) (#627) * Allow creation named column constraints via : *_constraint_name column options (jeremyevans) * Handle drop_constraint :type=>:primary_key on H2 (jeremyevans) * Handle infinite dates in the postgres adapter using Database#convert_infinite_timestamps (jeremyevans) * Make the looser_typecasting extension use looser typecasting for decimal columns as well as integers and floats (jeremyevans) * Do strict typecasting of decimal columns by default, similar to integer/float typecasting (jeremyevans) * Wed Mar 20 2013 cooloAATTsuse.com- updated to version 3.45.0 * Remove bad model typecasting of money type on PostgreSQL (jeremyevans) (#624) * Use simplecov instead of rcov for coverage testing on 1.9+ (jeremyevans) * Make the Database#quote_identifier method public (jeremyevans) * Make PostgreSQL metadata parsing handle tables with the same name in multiple schemas (jeremyevans) * Switch query extension to use a proxy instead of Object#extend (chanks, jeremyevans) * Remove Dataset#def_mutiation_method instance method (jeremyevans) * Make foreign key parsing on MySQL not pick up foreign keys in other databases (jeremyevans) * Allow per-instance overrides of Postgres.force_standard_strings and .client_min_messages (jeremyevans) (#618) * Add Sequel.tzinfo_disambiguator= to the named_timezones plugin for automatically handling TZInfo::AmbiguousTime exceptions (jeremyevans) (#616) * Add Dataset#escape_like, for escaping LIKE metacharacters (jeremyevans) (#614) * The LIKE operators now use an explicit ESCAPE \'\\\' clause for similar behavior across databases (jeremyevans) * Make Database#tables and #views accept a :qualify option on PostgreSQL to return qualified identifiers (jeremyevans) * Make json_serializer and xml_serializer plugins secure by default (jeremyevans) * Address JSON.parse vulnerabilities (jeremyevans) * Fix Dataset#from_self! to no longer create a self-referential dataset (jeremyevans) * Use SQLSTATE or database error codes if available instead of regexp parsing for more specific DatabaseErrors (jeremyevans) * Add unlimited_update plugin to work around MySQL warning in replicated environments (jeremyevans) * Add the :retry_on and :num_retries transaction options for automatically retrying transactions (jeremyevans) * Raise serialization failures/deadlocks as Sequel::SerializationFailure exceptions (jeremyevans) * Support transaction isolation levels on Oracle and DB2 (jeremyevans) * Support transaction isolation levels when using the JDBC transaction support (jeremyevans) * Sat Feb 09 2013 cooloAATTsuse.com- updated to version 3.44.0 * Speedup mysql2 adapter with identifier output method fetch speed by up to 50% (jeremyevans) * Speedup tinytds adapter fetch speed by up to 60% (jeremyevans) * Expand columns_introspection extension to consider cached schema values in the database (jeremyevans) * Expand columns_introspection extension to handle subselects (jeremyevans) * Have #last and #paged_each for model datasets order by the model\'s primary key by default (jeremyevans) * Improve emulated offset support to handle subqueries (jeremyevans) * Remove use of Object#extend from the eager_each plugin (jeremyevans) * Add support for temporary views on SQLite and PostgreSQL via the :temp option to create_view (chanks, jeremyevans) * Emulate Database#create_or_replace_view if not supported directly (jeremyevans) * Add Dataset#paged_each, for processing entire datasets without keeping all rows in memory (jeremyevans) * Add Sequel::ConstraintViolation exception class and subclasses for easier exception handling (jeremyevans) * Fix use of identity_map plugin with many_to_many associations with right composite keys (chanks) (#603) * Increase virtual row performance by using a shared VirtualRow instance (jeremyevans) * Allow the :dataset association option to accept the association reflection as an argument (jeremyevans) * Improve association method performance by caching intermediate dataset (jeremyevans) * Thu Jan 24 2013 cooloAATTsuse.com- updated to version 3.43.0 * Move the #meta_def support for Database, Dataset, and Model to the meta_def extension (jeremyevans) * Fix Database#copy_into on jdbc/postgres when an exception is raised (jeremyevans) * Add core_refinements extension, providing refinement versions of Sequel\'s core extensions (jeremyevans) * Make Database#copy_into raise a DatabaseError if the database signals an error in the postgres adapter (jeremyevans) * Define respond_to_missing? where method_missing is defined and the object supports respond_to? (jeremyevans) * Allow lambda procs with 0 arity as virtual row blocks on ruby 1.9 (jeremyevans) * Handle schema-qualified row_types in the pg_array integration in the pg_row extension (jeremyevans) (#595) * Support default_schema when reseting primary key sequences on PostgreSQL (jeremyevans) (#596) * Allow treating tinyint(1) unsigned columns as booleans in the mysql adapters (jeremyevans) * Support the jdbc-hsqldb gem in the jdbc adapter, since it has been updated to 2.2.9 (jeremyevans) * Work with new jdbc- * gems that require manual driver loading (kares) (#598) * Cast blobs correctly on DB2 when use_clob_as_blob is false (mluu, jeremyevans) (#594) * Add date_arithmetic extension for database-independent date calculations (jeremyevans) * Make Database#schema handle [host.]database.schema.table qualified tables on Microsoft SQL Server (jeremyevans) * Add Dataset#split_qualifiers helper method for splitting a qualifier identifier into array of strings (jeremyevans) * Make Database#schema_and_table always return strings for the schema and table (jeremyevans) * Skip stripping of blob columns in the string_stripper plugin (jeremyevans) (#593) * Allow Dataset#get to take an array to return multiple values, similar to map/select_map (jeremyevans) * Default :prefetch_rows to 100 in the Oracle adapter (andrewhr) (#592) * Thu Dec 06 2012 cooloAATTsuse.com- updated to version 3.42.0 * If an exception occurs while committing a transaction, attempt to rollback (jeremyevans) * Support setting default string column sizes on a per-Database basis via default_string_column_size (jeremyevans) * Reset Model.instance_dataset when extending the model\'s dataset (jeremyevans) * Make the force_encoding plugin work with frozen strings (jeremyevans) * Add Database#do on PostgreSQL for using the DO anonymous code block execution statement (jeremyevans) * Remove Model.dataset_methods (jeremyevans) * Allow subset to be called inside a dataset_module block (jeremyevans) * Make Dataset#avg, #interval, #min, #max, #range, and #sum accept virtual row blocks (jeremyevans) * Make Dataset#count use a subselect when the dataset has an offset without a limit (jeremyevans) (#587) * Dump deferrable status of unique indexes on PostgreSQL (radford) (#583) * Extend deferrable constraint support to all types of constraints, not just foreign keys (radford, jeremyevans) (#583) * Support Database#copy_table and #copy_into on jdbc/postgres (bdon) (#580) * Make Dataset#update not use a limit (TOP) on Microsoft SQL Server 2000 (jeremyevans) (#578) * Sat Nov 03 2012 cooloAATTsuse.com- updated to version 3.41.0 * Add bin/sequel usage guide (jeremyevans) * Make Dataset#reverse and #reverse_order accept virtual row blocks (jeremyevans) * Add Sequel.delay for generic delayed evaluation (jeremyevans) * Make uniqueness validations correctly handle nil values (jeremyevans) * Support :unlogged option for create_table on PostgreSQL (JonathanTron) (#575) * Add ConnectionPool#pool_type to get the type of connection pool in use (jeremyevans) * Explicitly mark primary keys as NOT NULL on SQLite (jeremyevans) * Add support for renaming primary key columns on MySQL (jeremyevans) * Add connection_validator extension for automatically checking connections and transparently handling disconnects (jeremyevans) * Add Database#valid_connection? for checking whether a given connection is valid (jeremyevans) * Make dataset.limit(nil, nil) reset offset as well as limit (jeremyevans) (#571) * Support IMMEDIATE/EXCLUSIVE/DEFERRED transaction modes on SQLite (Eric Wong) * Major change in the Database <-> ConnectionPool interface (jeremyevans) * Make touch plugin handle touching of many_ *_many associations (jeremyevans) * Make single_table_inheritance plugin handle non-bijective mappings (hannesg) (#567) * Support foreign key parsing on MSSQL (munkyboy) (#564) * Include SQL::AliasMethods in most pg_ * extension objects (treydempsey, jeremyevans) (#563) * Handle failure to create a prepared statement better in the postgres, mysql, and mysql2 adapters (jeremyevans) (#560) * Treat clob columns as strings instead of blobs (jeremyevans) * Thu Sep 27 2012 cooloAATTsuse.com- updated to version 3.40.0 * Add a cubrid adapter for accessing CUBRID databases via the cubrid gem (jeremyevans) * Add a jdbc/cubrid adapter for accessing CUBRID databases via JDBC on JRuby (jeremyevans) * Return OCI8::CLOB values as ruby Strings in the Oracle adapter (jeremyevans) * Use clob for String :text=>true types on Oracle, DB2, HSQLDB, and Derby (jeremyevans) (#555) * Allowing marshalling of Sequel::Postgres::HStore (jeremyevans) (#556) * Quote channel identifier names when using LISTEN/NOTIFY on PostgreSQL (jeremyevans) * Handle nil values when formatting bound variable arguments in the pg_row extension (jeremyevans) (#548) * Handle nil values when parsing composite types in the pg_row extension (jeremyevans) (#548) * Add :disconnect=>:retry option to Database#transaction, for automatically retrying the transaction on disconnect (jeremyevans) * Greatly improved support on Microsoft Access (jeremyevans) * Support Database#{schema,tables,views,indexes,foreign_key_list} when using ado/access adapter (ericgj) (#545, #546) * Add ado/access adapter for accessing Microsoft Access via the ado adapter (jeremyevans) * Combine disconnect error detection for mysql and mysql2 adapters (jeremyevans) * Update the association_pks plugin to handle composite primary keys (chanks, jeremyevans) (#544) * Sat Sep 01 2012 cooloAATTsuse.com- updated to version 3.39.0 * Fri Aug 03 2012 cooloAATTsuse.com- updated to version 3.38.0 * Sequel now recognizes the double(x, y) and double(x, y) unsigned MySQL types (Slike9, jeremyevans) (#528) * The swift subadapters now require swift-db- * instead of swift itself (deepfryed, jeremyevans) (#526) * Add :textsize option to tinytds adapter to override the default TEXTSIZE (jeremyevans, wardrop) (#525) * Support an output identifier method in the swift adapter (jeremyevans) * Add Model#to_hash as an alias to Model#values (jeremyevans) * When loading multiple pg_ * extensions via Database#extension, only reset the conversion procs once (jeremyevans) * Don\'t allow model typecasting from string to postgres array, hstore, or composite types (jeremyevans) * Add pg_typecast_on_load plugin for converting advanced PostgreSQL types on load the {jdbc,do,swift}/postgres adapters (jeremyevans) * Make all adapters that connect to PostgreSQL store type conversion procs (jeremyevans) * Add type oid to column schema on PostgreSQL (jeremyevans) * Add pg_row plugin, for using Sequel::Model classes to represent PostgreSQL row-valued/composite types (jeremyevans) * Add pg_row_ops extension for DSL support for PostgreSQL row-valued/composite types (jeremyevans) * Add pg_row extension for dealing with PostgreSQL row-valued/composite types (jeremyevans) * Allow custom registered array types in the pg_array extension to be Database instance specific (jeremyevans) * Remove Sequel::SQL::IdentifierMethods (jeremyevans) * Don\'t have the schema_dumper extension produce code that relies on the core_extensions (jeremyevans) * Fix dropping of columns with constraints on Microsoft SQL Server (mluu, jeremyevans) (#515, #518) * Don\'t have pg_ * extensions add methods to core classes unless the core_extensions extension is loaded (jeremyevans) * Use real boolean literals on derby 10.7+ (jeremyevans, matthauck) (#514) * Work around JRuby 1.6 ruby 1.9 mode bug in Time#nsec for Time prepared statement arguments on jdbc (jeremyevans) * Handle blob prepared statement arguments on jdbc/db2 and jdbc/oracle (jeremyevans) * Handle blob values in the swift adapter (jeremyevans) * Handle better nil prepared statement arguments on jdbc (jeremyevans) (#513) * Make SQL::Blob objects handle as, cast, and lit methods even if the core extensions are not loaded (jeremyevans) * Make # * with no arguments produce a ColumnAll for Identifier and QualifiedIdentifier (jeremyevans) * Sequel.expr(:symbol) now returns Identifier, QualifiedIdentifier, or AliasedExpression instead of Wrapper (jeremyevans) * Treat clob columns as string instead of blob on Derby (jeremyevans) (#509) * Mon Jun 14 2010 mrueckertAATTsuse.de- update to 3.12.1 * Make :encoding option work on MySQL even if config file specifies different encoding (jeremyevans) (#300) for more see /usr/lib */ruby/gems/1.8/gems/sequel-3.12.1/CHANGELOG * Fri Jun 11 2010 mrueckertAATTsuse.de- use rubygems_requires macro * Wed Jan 06 2010 prusnakAATTsuse.cz- updated to 3.7.0 * Fri Dec 25 2009 prusnakAATTsuse.cz- update to 3.7.0 * Thu Nov 12 2009 mrueckertAATTsuse.de- initial package
|
|
|