Changelog for ruby1.8-rubygem-sequel-doc-4.47.0-1.2.i586.rpm :
Tue Jun 6 14:00:00 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 14:00:00 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 2 14:00:00 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 2 13:00:00 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 2 13:00:00 2017 cooloAATTsuse.com
- updated to version 4.43.0
see installed CHANGELOG

Sat Jan 14 13:00:00 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 2 13:00:00 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 2 13:00:00 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 14:00:00 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 2 14:00:00 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 2 14:00:00 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 2 14:00:00 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 2 14:00:00 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 2 14:00:00 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 2 14:00:00 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 6 14:00:00 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 2 13:00:00 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 2 13:00:00 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 13:00:00 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 2 13:00:00 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 3 13:00:00 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 2 14:00:00 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 2 14:00:00 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 2 14:00:00 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 2 14:00:00 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 2 14:00:00 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 2 14:00:00 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 2 14:00:00 2015 cooloAATTsuse.com
- updated to version 4.21.0

Thu Mar 5 13:00:00 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 13:00:00 2015 cooloAATTsuse.com
- updated to version 4.19.0

Wed Nov 12 13:00:00 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 14:00:00 2014 cooloAATTsuse.com
- updated to version 4.15.0, see CHANGELOG

Mon Oct 13 14:00:00 2014 cooloAATTsuse.com
- adapt to new rubygem packaging

Sun May 18 14:00:00 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 6 14:00:00 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 13:00:00 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 6 13:00:00 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 5 13:00:00 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 3 13:00:00 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 13:00:00 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 4 14:00:00 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 3 14:00:00 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 6 14:00:00 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 14:00:00 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 3 14:00:00 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 14:00:00 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 14:00:00 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 13:00:00 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 9 13:00:00 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 13:00:00 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 6 13:00:00 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 3 13:00:00 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 14:00:00 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 1 14:00:00 2012 cooloAATTsuse.com
- updated to version 3.39.0

Fri Aug 3 14:00:00 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 14:00:00 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 14:00:00 2010 mrueckertAATTsuse.de
- use rubygems_requires macro

Wed Jan 6 13:00:00 2010 prusnakAATTsuse.cz
- updated to 3.7.0

Fri Dec 25 13:00:00 2009 prusnakAATTsuse.cz
- update to 3.7.0

Thu Nov 12 13:00:00 2009 mrueckertAATTsuse.de
- initial package