Changelog History
Page 9
-
v4.34.0 Changes
May 01, 2016Add 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, 2016Convert 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)
-
v4.30.0 Changes
January 04, 2016Add 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)
-
v4.29.0 Changes
December 01, 2015Add 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)
-
v4.28.0 Changes
November 02, 2015โ 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)
-
v4.27.0 Changes
October 01, 2015๐ 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)
-
v4.26.0 Changes
September 01, 2015๐ 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)
-
v4.25.0 Changes
August 01, 2015โ 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)
0๏ธโฃ 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)