All Versions
Latest Version
Avg Release Cycle
30 days
Latest Release
17 days ago

Changelog History
Page 8

  • v4.39.0 Changes

    October 01, 2016
    • โช 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)

  • v4.38.0 Changes

    September 01, 2016
    • ๐Ÿ‘Œ 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 to set the date used for SQLTime instances (jeremyevans)

  • v4.37.0 Changes

    August 01, 2016
    • โž• 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)

  • v4.36.0 Changes

    July 01, 2016
    • ๐Ÿ—„ 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)

  • v4.35.0 Changes

    June 01, 2016
    • 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 (jeremyevans)

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

  • v4.34.0 Changes

    May 01, 2016
    • 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)

  • v4.33.0 Changes

    April 01, 2016
    • ๐Ÿ– 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)

  • v4.32.0 Changes

    March 01, 2016
    • ๐Ÿ”€ 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)

  • v4.31.0 Changes

    February 01, 2016
    • 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 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)

  • v4.30.0 Changes

    January 04, 2016
    • 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)