The NetBSD Project

CVS log for pkgsrc/databases/ruby-sequel/distinfo

[BACK] Up to [] / pkgsrc / databases / ruby-sequel

Request diff between arbitrary revisions

Default branch: MAIN

Revision 1.116 / (download) - annotate - [select for diffs], Sat Nov 11 09:50:57 2023 UTC (3 weeks, 3 days ago) by taca
Branch: MAIN
Changes since 1.115: +4 -4 lines
Diff to previous 1.115 (colored)

databases/ruby-sequel: update to 5.74.0

5.74.0 (2023-11-01)

* Make generated columns show up in Database#schema when using SQLite 3.37+
  (jeremyevans) (#2087)
* Add revert method for Sequel.migration blocks, to revert changes inside
  the block on up, and apply the changes on down (jeremyevans)
* Re-add is_json and is_not_json methods to the pg_json_ops extension, as
  the support was re-added in PostgreSQL 16 (jeremyevans)
* Avoid infinite loop when handling exceptions with a cause loop in jdbc
  adapter (jeremyevans)

Revision 1.115 / (download) - annotate - [select for diffs], Tue Oct 24 14:33:12 2023 UTC (5 weeks, 6 days ago) by taca
Branch: MAIN
Changes since 1.114: +4 -4 lines
Diff to previous 1.114 (colored)

databases/ruby-sequel: update to 5.73.0

5.73.0 (2023-10-01)

* Handle disconnect errors in ibmdb and jdbc/db2 adapters (jeremyevans) (#2083)

* Support skipping transactions in Dataset#{import,paged_each} using
  :skip_transaction option (jeremyevans)

* Add Database#transaction :skip_transaction option to skip creating a
  transaction or savepoint (jeremyevans)

* Stop using a transaction for a single query if calling Dataset#import
  with a dataset (jeremyevans)

* Add paged_operations plugin for paged deletes and updates and other
  custom operations (jeremyevans) (#2080)

* Support to_tsquery: :websearch option to Dataset#full_text_search on
  PostgreSQL 11+ (jeremyevans) (#2075)

* Add MassAssignmentRestriction#model and #column for getting the model
  instance and related column for mass assignment errors (artofhuman,
  jeremyevans) (#2079)

* Stop using base64 library in column_encryption plugin (jeremyevans)

Revision 1.114 / (download) - annotate - [select for diffs], Sun Sep 3 01:42:32 2023 UTC (3 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2023Q3-base, pkgsrc-2023Q3
Changes since 1.113: +4 -4 lines
Diff to previous 1.113 (colored)

databases/ruby-sequel: update to 5.72.0

5.72.0 (2023-09-01)

* Sort caches before marshalling when using schema_caching, index_caching,
  static_cache_cache, and pg_auto_constraint_validations (jeremyevans)

* Change the defaults_setter plugin do a deep-copy of database default
  hash/array values and delegates (jeremyevans) (#2069)

* Add pg_auto_parameterize_in_array extension, for converting IN/NOT IN to =
  ANY or != ALL for more types (jeremyevans)

* Fix literalization of infinite and NaN float values in PostgreSQL array
  bound variables (jeremyevans)

Revision 1.113 / (download) - annotate - [select for diffs], Sat Aug 5 08:51:11 2023 UTC (4 months ago) by taca
Branch: MAIN
Changes since 1.112: +4 -4 lines
Diff to previous 1.112 (colored)

databases/ruby-sequel: update to 5.71.0

5.71.0 (2023-08-01)

* Support ILIKE ANY on PostgreSQL by not forcing the use of ESCAPE for ILIKE
  (gilesbowkett) (#2066)

* Add pg_xmin_optimistic_locking plugin for optimistic locking for all
  models without database changes (jeremyevans)

* Recognize the xid PostgreSQL type as an integer type in the
  jdbc/postgresql adapter (jeremyevans)

* Make set_column_allow_null method reversible in migrations (enescakir)

Revision 1.112 / (download) - annotate - [select for diffs], Sun Jul 2 04:54:41 2023 UTC (5 months ago) by taca
Branch: MAIN
Changes since 1.111: +4 -4 lines
Diff to previous 1.111 (colored)

databases/ruby-sequel: upate to 5.70.7

5.70.0 (2023-07-01)

* Make static_cache plugin better handle cases where forbid_lazy_load plugin
  is already loaded (jeremyevans)

* Fix ShardedThreadedConnectionPool#remove_server to disconnect all
  connections if removing multiple servers (jeremyevans)

* Support SEQUEL_DEFAULT_CONNECTION_POOL environment variable for choosing
  connection pool when :pool_class Database option is not set (jeremyevans)

* Add sharded_timed_queue connection pool (jeremyevans)

* Make connection_{validator,expiration} and async_thread_pool extensions
  work with timed_queue connection pool (jeremyevans)

* Make connection_{validator,expiration} extensions raise error when used
  with single threaded pools (HoneyryderChuck, jeremyevans) (#2049)

* Workaround possible resource starvation in threaded connection pool
  (ioquatix) (#2048)

Revision 1.111 / (download) - annotate - [select for diffs], Tue Jun 6 13:27:42 2023 UTC (5 months, 4 weeks ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2023Q2-base, pkgsrc-2023Q2
Changes since 1.110: +4 -4 lines
Diff to previous 1.110 (colored)

databases/ruby-sequel: update to 5.69.0

5.69.0 (2023-06-01)

* Avoid unsupported flag warning when using the mysql adapter with
  ruby-mysql 3+ (jeremyevans)
* Make mysql adapter work with ruby-mysql 4+ (jeremyevans)
* Add Model::DatasetModule#model accessor (davekaro) (#2040)
* Add trilogy adapter (jeremyevans)

Revision 1.110 / (download) - annotate - [select for diffs], Wed May 3 14:19:36 2023 UTC (7 months ago) by taca
Branch: MAIN
Changes since 1.109: +4 -4 lines
Diff to previous 1.109 (colored)

databases/ruby-sequel: update to 5.68.0

5.68.0 (2023-05-01)

* Add validation_helpers_generic_type_messages plugin for more useful type
  validation failure messages (jeremyevans) (#2028)

* Make constraint_validations plugin not validate missing columns that have
  a default value (jeremyevans) (#2023)

* Skip normal type name parsing for enum/array/composite/range/multirange
  types on PostgreSQL (jeremyevans) (#2019)

* Fix corner case where pg_extended_date_support did not work correctly when
  using the jdbc/postgresql adapter (jeremyevans)

* Include :min_value and :max_value schema entries for
  date/timestamp/timestamptz columns on PostgreSQL 9.6+ (jeremyevans)

Revision 1.109 / (download) - annotate - [select for diffs], Sat Apr 8 13:13:28 2023 UTC (7 months, 4 weeks ago) by taca
Branch: MAIN
Changes since 1.108: +4 -4 lines
Diff to previous 1.108 (colored)

databases/ruby-sequel: update to 5.67.0

5.67.0 (2023-04-01)

* Fix dumping of string column sizes in the schema dumper on MSSQL
  (jeremyevans) (#2013)

* Improve dumping of tables in non-default schemas in the schema_dumper
  extension (jeremyevans) (#2006)

* Make Database#{tables,views} support :qualify option on Microsoft SQL
  Server (jeremyevans)

* Avoid use of singleton classes for datasets instances on Ruby 2.4+
  (jeremyevans) (#2007)

* Deprecate registering datasets extensions using an object other than a
  module (jeremyevans)

* Add set_literalizer extension, for treating set usage in datasets similar
  to array usage (jeremyevans) (#1997)

Revision 1.108 / (download) - annotate - [select for diffs], Sun Mar 5 13:33:35 2023 UTC (9 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2023Q1-base, pkgsrc-2023Q1
Changes since 1.107: +4 -4 lines
Diff to previous 1.107 (colored)

databases/ruby-sequel: update to 5.66.0

5.66.0 (2023-03-01)

* Recognize SQLite error related to strict tables as a constraint violation
  when using the amalgalite adapter (jeremyevans)
* Make Dataset#count work correctly for datasets using Dataset#values
  (jeremyevans) (#1992)
* Make Dataset#count with no argument/block handle dataset with custom SQL
  using ORDER BY on MSSQL (jeremyevans)
* Make Dataset#empty? correctly handle datasets with custom SQL or using
  Dataset#values where the first value is NULL (andy-k, jeremyevans) (#1990)

Revision 1.107 / (download) - annotate - [select for diffs], Sat Feb 4 09:41:59 2023 UTC (9 months, 4 weeks ago) by taca
Branch: MAIN
Changes since 1.106: +4 -4 lines
Diff to previous 1.106 (colored)

databases/ruby-sequel: update to 5.65.0

5.65.0 (2023-02-01)

* Allow pg_auto_parameterize extension to use placeholder loaders

* Do not include :min_value and :max_value schema entries for
  decimal/numeric columns on MySQL versions not supporting check constraints

* Make Database#indexes return indexes for partitioned tables on PostgreSQL
  11+ (jeremyevans)

Revision 1.106 / (download) - annotate - [select for diffs], Tue Jan 3 05:50:32 2023 UTC (11 months ago) by taca
Branch: MAIN
Changes since 1.105: +4 -4 lines
Diff to previous 1.105 (colored)

databases/ruby-sequel: update to 5.64.0

5.64.0 (2023-01-01)

* Make :db_type column schema entries on SQLAnywhere include precision/scale
  information (jeremyevans)

* Include :min_value and :max_value schema entries for decimal/numeric
  columns on most databases (rolftimmermans, jeremyevans) (#1975)

* Support :graph_use_association_block association option to make
  eager_graph use the association block (jeremyevans)

* Make many_through_many and many_through_one associations support
  eager_graph callbacks (jeremyevans)

Revision 1.105 / (download) - annotate - [select for diffs], Sat Dec 3 06:27:57 2022 UTC (12 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2022Q4-base, pkgsrc-2022Q4
Changes since 1.104: +4 -4 lines
Diff to previous 1.104 (colored)

databases/ruby-sequel: update to 5.63.0

5.63.0 (2022-12-01)

* Make validates_associated plugin avoid database type errors for
  non-integer association keys (jeremyevans) (#1968)

* Make tactical_eager_loading plugin work better with table inheritance
  plugins (rolftimmermans, jeremyevans) (#1962)

* Add support for pool_class: :timed_queue on Ruby 3.2+, using a Queue for
  available connections (jeremyevans)

* Allow :pool_class Database option to be specified as a string to more
  easily choose a different pool type (jeremyevans)

* Use compare_by_identity hashes for Thread-keyed hashes in threaded
  connection pools (jeremyevans)

* Skip use of JRuby workaround on JRuby in named_timezones
  extension as JRuby fixed the related bug (jeremyevans)

Revision 1.104 / (download) - annotate - [select for diffs], Fri Nov 11 13:13:39 2022 UTC (12 months, 3 weeks ago) by taca
Branch: MAIN
Changes since 1.103: +4 -4 lines
Diff to previous 1.103 (colored)

databases/ruby-sequel: update to 5.62.0

5.62.0 (2022-11-01)

* Add back the pg_auto_parameterize extension for automatically using bound
  variables when using postgres adapter with pg driver (jeremyevans)

* Add pg_extended_integer_support extension for customizing behavior when
  literalizing a Ruby integer outside PostgreSQL bigint range (jeremyevans)

* Raise Postgres::IntegerOutsideBigintRange if attempting to literalize a
  Ruby integer outside PostgreSQL bigint range (jeremyevans)

* Add primary_key_lookup_check_values plugin for typecasting and checking
  primary key values during lookup (jeremyevans)

* Setup validation of minimum and maximum values for integer columns in
  auto_validations (jeremyevans)

* Add validates_max_value and validates_min_value to validation_helpers

* Include :min_value and :max_value schema entries for integer columns on
  most databases (jeremyevans)

* Don't wrap multi-inserts in a transaction when it's not required
  (shannoncole, jeremyevans) (#1945)

* Update mock PostgreSQL adapter to default to PostgreSQL 15 instead of
  PostgreSQL 14 (jeremyevans)

* Support fractional seconds in the named_timezones extension (jeremyevans)

* Cache reflection datasets in the postgres adapter to improve performance

* Handle BC dates and timestamps in bound variables when using the
  pg_extended_date_support extension (jeremyevans)

* Correctly format hstore[] types in bound variables on PostgreSQL

* Fix corner case in eager loading where window function eager limit
  strategy is used, but row number entry is not removed (jeremyevans)

* Support server/shard specific :after_connect and :connect_sqls Database
  options (jeremyevans) (#1935)

Revision 1.103 / (download) - annotate - [select for diffs], Thu Oct 6 14:16:05 2022 UTC (13 months, 4 weeks ago) by taca
Branch: MAIN
Changes since 1.102: +4 -4 lines
Diff to previous 1.102 (colored)

databases/ruby-sequel: update to 5.61.0

5.61.0 (2022-10-01)

* Make Database#foreign_key_list on PostgreSQL return results for
  partitioned tables (jeremyevans)

* Add Database#check_string_typecast_bytesize for checking bytesize of
  strings before typecasting (jeremyevans)

* Treat negative hexidecimal strings similar to positive hexidecimal strings
  when typecasting to integer (jeremyevans)

* Remove is_json and is_not_json methods from the pg_json_ops extension, as
  the support was removed in PostgreSQL 15 beta 4 (jeremyevans)

* Fix handling of timestamps before the date of calendar reform when using
  pg_extended_date_support extension on Ruby 3.2 (jeremyevans)

Revision 1.102 / (download) - annotate - [select for diffs], Sat Sep 3 13:59:46 2022 UTC (15 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2022Q3-base, pkgsrc-2022Q3
Changes since 1.101: +4 -4 lines
Diff to previous 1.101 (colored)

databases/ruby-sequel: update to 5.60.1

5.60.1 (2022-09-02)

* Revert conversion of respond_to? to defined?, as it breaks with unused
  refinements on Ruby 2 (jeremyevans) (#1919)

5.60.0 (2022-09-01)

* Support arbitrary expressions for date_arithmetic interval values on
  PostgreSQL 9.4+ (jeremyevans)

* Support native IS DISTINCT FROM on SQLite 3.39+ instead of emulating
  support in the is_distinct_from extension (jeremyevans)

* Support HAVING without GROUP BY on SQLite 3.39+ (jeremyevans)

* Convert most respond_to? calls to equivalent defined? for better
  performance (jeremyevans)

Revision 1.101 / (download) - annotate - [select for diffs], Thu Aug 11 04:13:18 2022 UTC (15 months, 3 weeks ago) by taca
Branch: MAIN
Changes since 1.100: +4 -4 lines
Diff to previous 1.100 (colored)

databases/ruby-sequel: update to 5.59.0

5.59.0 (2022-08-01)

* Set :allow_eager association option to false for instance specific
  associations without eager loaders (jeremyevans)

* Add require_valid_schema plugin for checking that model classes have
  schema parsed as expected (jeremyevans)

* Model classes created from aliased expressions and literal strings no
  longer use the simple table optimization (jeremyevans)

* Model code that does not swallow connection errors will now also not
  swallow disconnect errors (jeremyevans) (#1892)

* Add is_json and is_not_json methods to the pg_json_ops extension, for the
  PostgreSQL 15+ IS [NOT] JSON operator (jeremyevans)

* Support :security_invoker view option on PostgreSQL 15+, for views where
  access uses permissions of user instead of owner (jeremyevans)

* Support :nulls_distinct index option on PostgreSQL 15+, for NULLS [NOT]
  DISTINCT (jeremyevans)

* Support sequel-postgres-pr driver in the postgres adapter (jeremyevans)

Revision 1.100 / (download) - annotate - [select for diffs], Tue Jul 19 14:38:39 2022 UTC (16 months, 2 weeks ago) by taca
Branch: MAIN
Changes since 1.99: +4 -4 lines
Diff to previous 1.99 (colored)

databases/ruby-sequel: update to 5.58.0

5.58.0 (2022-07-01)

* Support :disable_split_materialized Database option on MySQL to work
  around optimizer bug in MariaDB 10.5+ affecting association tests

* Add Dataset#merge* methods to support MERGE statement on PostgreSQL 15+,
  MSSQL, Oracle, DB2, H2, HSQLDB, and Derby (jeremyevans)

Revision 1.99 / (download) - annotate - [select for diffs], Mon Jun 6 13:39:58 2022 UTC (17 months, 4 weeks ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2022Q2-base, pkgsrc-2022Q2
Changes since 1.98: +4 -4 lines
Diff to previous 1.98 (colored)

databases/ruby-sequel: update to 5.57.0

5.57.0 (2022-06-01)

* Make Database#create_function on PostgreSQL accept :parallel option
  (bananarne) (#1870)

* Add support for :on_update_current_timestamp column option on MySQL

* Add is_distinct_from extension with support for the IS DISTINCT FROM
  operator (jeremyevans)

5.56.0 (2022-05-01)

* Make alter_table add_column/add_foreign_key methods support :index option
  to create an index on the column (jeremyevans)

* Support creation of STRICT tables on SQLite 3.37.0+ via create_table
  :strict option (jeremyevans)

* Add sqlite_json_ops extension for DSL support for JSON functions and
  operators added in SQLite 3.38.0 (jeremyevans)

* Recognize "INTEGER" type same as "integer" type in the schema dumper,
  helpful on SQLite 3.37.0+ (jeremyevans)

Revision 1.98 / (download) - annotate - [select for diffs], Sun Apr 3 06:58:49 2022 UTC (20 months ago) by taca
Branch: MAIN
Changes since 1.97: +4 -4 lines
Diff to previous 1.97 (colored)

databases/ruby-sequel: update to 5.55.0

5.55.0 (2022-04-01)

* Support :setup_regexp_function Database option in the sqlite adapter to
  allow the use of regexps when querying (jeremyevans)

* Add auto_restrict_eager_graph plugin for automatically disallow
  eager_graph with associations needing but lacking graph options

* Fix placeholder literalizer optimization for dataset aggregate methods on
  a model dataset (belousovAV) (#1847, #1848)

Revision 1.97 / (download) - annotate - [select for diffs], Sun Mar 6 03:58:20 2022 UTC (21 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2022Q1-base, pkgsrc-2022Q1
Changes since 1.96: +4 -4 lines
Diff to previous 1.96 (colored)

databases/ruby-sequel: update to 5.54.0

5.54.0 (2022-03-01)

* Add enum plugin for treating columns as enums in a model (jeremyevans)

Revision 1.96 / (download) - annotate - [select for diffs], Sat Feb 12 07:22:03 2022 UTC (21 months, 3 weeks ago) by taca
Branch: MAIN
Changes since 1.95: +4 -4 lines
Diff to previous 1.95 (colored)

databases/ruby-sequel: update to 5.53.0

5.52.0 (2022-01-01)

* Use Class#subclasses if available in the subclasses plugin, instead of a
  custom Model.subclasses accessor (jeremyevans)

* Add Model.descendants and .freeze_descendants to subclasses plugin

* Avoid use of deprecated Refinement#include on Ruby 3.1+ (jeremyevans)

* Add date_parse_input_handler extension for custom handling of input to
  date parsing methods (jeremyevans)

* Make postgres adapter respect Database#default_string_column_size

* Make pg_interval extension work with ActiveSupport 7.0 (jeremyevans)

* Make :ruby_default schema entry for type: :datetime respect
  Sequel.datetime_class (jeremyevans)

* Make alter_table drop_constraint have an effect on MySQL 8.0.19+

* Make mysql adapter support ruby-mysql 3 API (jeremyevans) (#1795)

* Make mysql adapter no longer use connection's server_version, since it
  isn't accurate when using the ruby-mysql driver (jeremyevans)

* Add sql_comments plugin for automatically including comments on queries
  generated by model class, instance, and dataset methods (jeremyevans)

* Make sql_comments Database extension support Database#with_comments, for
  automatically including comments for queries executed inside the block

* Fix sql_comments extension to not modify cached SQL for a dataset

5.53.0 (2022-02-01)

* Make Dataset#_sql_comment private when using the Database sql_comments
  extension (jeremyevans)

* Fix prepared statements in the mysql2 adapter to reuse native prepared
  statements (jeremyevans) (#1832)

* Support H2 version 2+ in the jdbc/h2 adapter (jeremyevans) (#1817)

* Work around active_support breaking subclasses plugin on Ruby <3.1
  (jeremyevans) (#1816)

* Fix error handling if trying to setup column_encryption plugin without
  keys (jeremyevans) (#1815)

Revision 1.95 / (download) - annotate - [select for diffs], Sun Dec 5 15:29:32 2021 UTC (23 months, 4 weeks ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2021Q4-base, pkgsrc-2021Q4
Changes since 1.94: +4 -4 lines
Diff to previous 1.94 (colored)

databases/ruby-sequel: update to 5.51.0

5.51.0 (2021-12-01)

* Make eager loading via tactical_eager_loading no longer modify objects who
  already have a cached value for the association (jeremyevans)
* Make association cloning handle cases where clone association sets
  different :class option than cloned association (jeremyevans)
* Make column schema entries on MySQL include an :extra entry for the Extra
  column in DESCRIBE output (bschmeck) (#1791)
* Update mock PostgreSQL adapter to default to PostgreSQL 14 instead of
  PostgreSQL 9.5 (jeremyevans)
* Support Dataset#with_recursive :search and :cycle options on PostgreSQL
  14+ for result ordering and cycle detection (jeremyevans)
* Avoid method redefined verbose mode warnings in lazy_attributes plugin

Revision 1.94 / (download) - annotate - [select for diffs], Tue Nov 9 14:02:52 2021 UTC (2 years ago) by taca
Branch: MAIN
Changes since 1.93: +4 -4 lines
Diff to previous 1.93 (colored)

databases/ruby-sequel: update to 5.50.0

=== 5.50.0 (2021-11-01)

* Make Migrator :allow_missing_migration_files also allow down migrations
  where the current database version is greater than the last migration file
  version (francisconeves97) (#1789)

* Fix Model#freeze in composition, serialization, and
  serialization_modification_detection plugins to return self (jeremyevans)

* Fix typecasting of lazy columns when using lazy_attributes plugin in model
  where dataset selects from subquery (jeremyevans)

* Add :before_preconnect Database option, for configuring extensions loaded
  via :preconnect_extensions (MarcPer, jeremyevans) (#1786)

* Change Dataset#columns! to use a LIMIT 0 query instead of a LIMIT 1 query

* Add sql_log_normalizer extension for normalizing logged SQL, helpful for
  analytics and sensitive data (jeremyevans)

* Add support for range_merge, multirange, and unnest, and PGMultiRange#op
  to pg_range_ops extension (jeremyevans)

* Add pg_multirange extension with support for PostgreSQL 14+ multirange
  types (jeremyevans)

=== 5.49.0 (2021-10-01)

* Switch block_given? usage to defined?(yield) (jeremyevans)

* Support table aliases for JOIN USING columns on PostgreSQL 14+

* Support calling PostgreSQL procedures without arguments (jeremyevans)

* Support hstore subscripts in pg_hstore_ops on PostgreSQL 14+, for updating
  only part of an hstore value (jeremyevans)

* Support JSONB subscripts in pg_json_ops on PostgreSQL 14+, for updating
  only part of a JSONB value (jeremyevans)

* Support SQL::Expression#sequel_ast_transform for custom AST transforms on
  arbitrary expressions (jeremyevans)

* Add Database#create_trigger :replace option on PostgreSQL 14+ for CREATE
  OR REPLACE TRIGGER (jeremyevans)

* Make auto_validations plugin automatically setup no_null_byte validations

* Add Model#validates_no_null_byte to validation_helpers plugin

Revision 1.93 / (download) - annotate - [select for diffs], Tue Oct 26 10:10:03 2021 UTC (2 years, 1 month ago) by nia
Branch: MAIN
Changes since 1.92: +2 -2 lines
Diff to previous 1.92 (colored)

databases: Replace RMD160 checksums with BLAKE2s checksums

All checksums have been double-checked against existing RMD160 and
SHA512 hashes

The following distfiles could not be fetched (some may be only fetched

./databases/cstore/distinfo cstore0.2.tar.gz
./databases/cstore/distinfo data4.tar.gz

Revision 1.92 / (download) - annotate - [select for diffs], Thu Oct 7 13:35:49 2021 UTC (2 years, 1 month ago) by nia
Branch: MAIN
Changes since 1.91: +1 -2 lines
Diff to previous 1.91 (colored)

databases: Remove SHA1 distfile hashes

Revision 1.91 / (download) - annotate - [select for diffs], Sat Sep 18 13:53:29 2021 UTC (2 years, 2 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2021Q3-base, pkgsrc-2021Q3
Changes since 1.90: +5 -5 lines
Diff to previous 1.90 (colored)

databases/ruby-sequel: update to 5.48.0

5.48.0 (2021-09-01)

* Make the unused_associations plugin association reflection tracking work
  correctly when combining coverage runs (jeremyevans)
* Add Database#like_without_collate on MSSQL, to avoid using COLLATE on LIKE
  arguments, which can significantly improve performance (jeremyevans)
* Add Model::Errors#full_message private method for easiest i18n support for
  errors with multiple attributes (jeremyevans) (#1779)

Revision 1.90 / (download) - annotate - [select for diffs], Thu Aug 12 14:58:31 2021 UTC (2 years, 3 months ago) by taca
Branch: MAIN
Changes since 1.89: +5 -5 lines
Diff to previous 1.89 (colored)

databases/ruby-sequel: update to 5.47.0

5.47.0 (2021-08-01)

* Make the unused_associations plugin track access to association
  reflections to determine whether associations are used (jeremyevans)

* Support :db option for join tables in {many,one}_through_many to use a
  separate query for each join table (jeremyevans)

* Support :join_table_db option for many_to_many/one_through_one
  associations, to use a separate query for the join table (jeremyevans)

* Support :allow_eager_graph and :allow_filtering_by association options

* Add Database#rename_tables on MySQL, for renaming multiple tables in a
  single call (nick96) (#1774)

* Support Dataset#returning on SQLite 3.35+ (jeremyevans)

5.46.0 (2021-07-01)

* Add unused_associations plugin, for determining which associations and
  association methods are not used (jeremyevans)

* Make nil :setter/:adder/:remover/:clearer association options not create
  related methods (jeremyevans)

Revision 1.89 / (download) - annotate - [select for diffs], Wed Jun 2 15:23:58 2021 UTC (2 years, 6 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2021Q2-base, pkgsrc-2021Q2
Changes since 1.88: +5 -5 lines
Diff to previous 1.88 (colored)

databases/ruby-sequel: update to 5.45.0

5.45.0 (2021-06-01)

* Fix handling of NULL values in boolean columns in the ODBC adapter
  (jeremyevans) (#1765)
* Add auto_validations_constraint_validations_presence_message plugin for
  auto_validations/constraint_validations presence message integration
* Support Dataset#with :materialized option on SQLite 3.35+ for [NOT]
  MATERIALIZED (jeremyevans)
* Use ALTER TABLE DROP COLUMN for dropping columns on SQLite 3.35+

Revision 1.88 / (download) - annotate - [select for diffs], Tue May 4 07:01:55 2021 UTC (2 years, 7 months ago) by taca
Branch: MAIN
Changes since 1.87: +5 -5 lines
Diff to previous 1.87 (colored)

databases/ruby-sequel: update to 5.44.0

5.44.0 (2021-05-01)

* Add concurrent_eager_loading plugin, for eager loading multiple
  associations concurrently using separate threads (jeremyevans)

* Support :weeks as a interval unit in the date_arithmetic extension
  (jeremyevans) (#1759)

* Raise an exception if an interval hash with an unsupported key is passed
  in the date_arithmetic extension (jeremyevans) (#1759)

* Support dropping non-composite unique constraints on SQLite (jeremyevans)

Revision 1.87 / (download) - annotate - [select for diffs], Sun Apr 11 14:08:43 2021 UTC (2 years, 7 months ago) by taca
Branch: MAIN
Changes since 1.86: +5 -5 lines
Diff to previous 1.86 (colored)

databases/ruby-sequel: update to 5.43.0

5.43.0 (2021-04-01)

* Add column_encryption plugin, for encrypting column values (jeremyevans)

Revision 1.86 / (download) - annotate - [select for diffs], Sun Mar 7 03:10:55 2021 UTC (2 years, 8 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2021Q1-base, pkgsrc-2021Q1
Changes since 1.85: +5 -5 lines
Diff to previous 1.85 (colored)

databases/ruby-sequel: update to 5.42.0

5.42.0 (2021-03-01)

* Make the ado timestamp conversion proc a normal conversion proc that can
  be overridden similar to other conversion procs (jeremyevans)

* Add :reject_nil option to the nested_attributes method, to ignore calls
  where nil is passed as the associated object data (jeremyevans)

* Add async_thread_pool plugin for easier async usage with model classes and
  support for async destroy, with_pk, and with_pk! methods (jeremyevans)

* Add async_thread_pool Database extension for executing queries
  asynchronously using a thread pool (jeremyevans)

* Fix possible thread safety issue in Database#extension that could allow
  Module#extended to be called twice with the same Database instance

* Support cases where validations make modifications beyond setting errors
  in Model#freeze (jeremyevans)

* Add Model#to_json_data to the json_serializer plugin, returning a JSON
  data structure (jeremyevans)

Revision 1.85 / (download) - annotate - [select for diffs], Tue Feb 2 15:36:20 2021 UTC (2 years, 10 months ago) by taca
Branch: MAIN
Changes since 1.84: +5 -5 lines
Diff to previous 1.84 (colored)

databases/ruby-sequel: update to 5.41.0

5.41.0 (2021-02-01)

* Have explicit :text option for a String column take priority over :size
  option on PostgreSQL (jeremyevans) (#1750)

* Support a :skip_invalid option in auto_validations plugin for not adding
  errors to a column that already has an error (jeremyevans)

* Support a :skip_invalid option in validation_helpers for not adding an
  error to a column that already has an error (jeremyevans)

* Support :adder, :remover, and :clearer association options that use
  keyword arguments in Ruby 2.7+ (jeremyevans)

* Make pg_interval use the same number of seconds per year and per month
  as ActiveSupport::Duration when using ActiveSupport 5.1+ (jeremyevans)

Revision 1.84 / (download) - annotate - [select for diffs], Sun Jan 10 14:28:46 2021 UTC (2 years, 10 months ago) by taca
Branch: MAIN
Changes since 1.83: +5 -5 lines
Diff to previous 1.83 (colored)

databases/ruby-sequel: update to 5.40.0

=== 5.40.0 (2021-01-01)

* Support UPDATE FROM syntax in SQLite 3.33.0+ (jeremyevans)

* Have pg_interval extension work with ActiveSupport 6.1 (jeremyevans)

* Have date_arithmetic extension work with ActiveSupport 6.1 (jeremyevans)

* Avoid method redefinition warnings in verbose warning mode (jeremyevans)

=== 5.39.0 (2020-12-01)

* Support :clustered option for primary key and unique constraints on Microsoft SQL Server (jeremyevans)

* Do not modify the size of binary columns when using set_column_allow_null on Microsoft SQL Server (jeremyevans) (#1736)

* Add a fork safety guide with more detail on how to use Sequel with libraries that fork (janko) (#1733)

* Make the roots_dataset method in the tree plugin work with queries using joins (jeremyevans) (#1731)

* Make Database#tables return partitioned tables on PostgreSQL 10+ (epoberezhny) (#1729, #1730)

=== 5.38.0 (2020-11-01)

* Do not add new Database instances to Sequel::DATABASES if the test connection fails (jeremyevans) (#1727)

* Support the newer com.mysql.cj.jdbc.Driver in the jdbc/mysql adapter (jeremyevans)

* Do not swallow disconnect errors in Database#create_or_replace_view or Database#create_table* on Oracle (jeremyevans)

* Only rescue non-disconnect Sequel::DatabaseErrors in Postgres::Database#server_version (jeremyevans) (#1724)

* Make the single_table_inheritance and prepared_statements plugins work if loaded into the same class (jeremyevans) (#1721)

Revision 1.83 / (download) - annotate - [select for diffs], Mon Oct 19 15:10:06 2020 UTC (3 years, 1 month ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2020Q4-base, pkgsrc-2020Q4
Changes since 1.82: +5 -5 lines
Diff to previous 1.82 (colored)

databases/ruby-sequel: update to 5.37.0

=== 5.37.0 (2020-10-01)

* Recognize more unsigned decimal/float types in the schema dumper (akimd, jeremyevans) (#1720)

* Add Postgres::PGRow::{Array,Hash}Row#op to the pg_row_ops extension if the pg_row extension is loaded (jeremyevans)

* Add Model#column_previously_was and #column_previously_changed? to the dirty plugin (jeremyevans)

* Raise Migrator::Error if attempting to migrate down to a version where there are necessary migration files missing (jeremyevans) (#1716)

Revision 1.82 / (download) - annotate - [select for diffs], Sun Sep 13 15:13:19 2020 UTC (3 years, 2 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2020Q3-base, pkgsrc-2020Q3
Changes since 1.81: +5 -5 lines
Diff to previous 1.81 (colored)

databases/ruby-sequel: update to 5.36.0

Update ruby-sequel to 5.36.0.

=== 5.36.0 (2020-09-01)

* Handle passing keyword arguments through class methods defined via
  Plugins.def_dataset_method on Ruby 2.7+ (jeremyevans)

* Handle passing keyword arguments through when loading plugins on Ruby 2.7+

* Handle passing keyword arguments through migrations when defining custom
  Database methods that accept keywords on Ruby 2.7+ (jeremyevans)

* Handle passing keyword arguments through Dataset#query when using the
  query extension on Ruby 2.7+ (jeremyevans)

* Handle passing keyword arguments through the association proxy when using
  the association_proxies plugin on Ruby 2.7+ (jeremyevans)

* Handle passing keyword arguments through the class method to a method
  defined in dataset_module on Ruby 2.7+ (adam12) (#1713)

* Stream result sets in the odbc adapter for better performance and lower
  memory usage (sparrovv) (#1711)

* Add Postgres::JSONBOp#set_lax and #path_*_tz methods to the pg_json_ops
  extension for new jsonb functions added in PostgreSQL 13 (jeremyevans)

* Add Dataset#with_ties on PostgreSQL 13+ and Microsoft SQL Server to
  include rows with same order as final row (jeremyevans)

* Add a :current_schema option to Database#view_exists? (only defined on
  Oracle) to look in the current schema instead of non-system schemas
  (jeremyevans) (#1710)

* Recognize another disconnect error in the mysql and mysql2 adapters
  (jeremyevans) (#1706)

Revision 1.81 / (download) - annotate - [select for diffs], Sun Aug 9 15:07:20 2020 UTC (3 years, 3 months ago) by taca
Branch: MAIN
Changes since 1.80: +5 -5 lines
Diff to previous 1.80 (colored)

databases/ruby-sequel: update to 5.35.0

Update ruby-sequel to 5.35.0.

=== 5.35.0 (2020-08-01)

* Recognize another disconnect error in the oracle adapter (sterlzbd) (#1705)

* Consider all associations with :dataset options as instance-specific associations (jeremyevans)

* Make Model.finalize_associations not break with instance-specific associations (jeremyevans)

* Make association placeholder loader consider block if instance_specific: false association option is used (jeremyevans)

* Copy composite unique constraints when emulating alter table operations on SQLite (jeremyevans) (#1704)

* Add instance_specific_default plugin for setting default association :instance_specific value, or warning/raising for cases where it is not specified (jeremyevans)

* Make Model.plugin issue deprecation warning if loading plugin with arguments and block if plugin does not accept arguments/block (jeremyevans)

* Make validation_class_methods consider all :if, :allow_missing, :allow_nil, and :allow_blank settings, instead of just the first (jeremyevans)

* Include hash entries with nil keys in Dataset#to_dot output in to_dot extension (jeremyevans)

* Remove unneeded conditionals from plugins and extensions (jeremyevans)

* Fix exception class in run_transaction_hooks extension if calling run_after_{commit,rollback}_hooks outside of a transaction (jeremyevans)

=== 5.34.0 (2020-07-01)

* Make eager_graph work correctly if called with no associations (jeremyevans)

* Make :ruby eager limit strategy handle cases where there is no limit or
  offset (jeremyevans)

* Do not keep a reference to a Sequel::Database instance that raises an
  exception during initialization (jeremyevans)

* Make Database#pool.all_connections not yield for a single connection pool
  in disconnected state (jeremyevans)

* Raise an exception if trying to disconnect a server that doesn't exist in
  the sharded connection pools (jeremyevans)

* Support :refresh option when calling *_pks getter method in the
  association_pks plugin (jeremyevans)

* Support caching of repeated calls to *_pks getter method in the association_pks plugin using :cache_pks association option (jeremyevans)

* Add *_pks_dataset methods for one_to_many and many_to_many associations
  when using the association_pks plugin (jeremyevans)

Revision 1.80 / (download) - annotate - [select for diffs], Sun Jun 7 06:21:36 2020 UTC (3 years, 5 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2020Q2-base, pkgsrc-2020Q2
Changes since 1.79: +5 -5 lines
Diff to previous 1.79 (colored)

databases/ruby-sequel: update to 5.33.0

Update ruby-sequel to 5.33.0.

=== 5.33.0 (2020-06-01)

* Support custom join types on a per-association basis when using eager_graph/association_join (jeremyevans)

* Support primary_key with type: :smallserial on PostgreSQL (j-a-m-l) (#1698)

* Add Database#current_timestamp_utc accessor on SQLite to keep CURRENT_* in UTC instead of converting to localtime (jeremyevans)

Revision 1.79 / (download) - annotate - [select for diffs], Sat May 2 13:22:00 2020 UTC (3 years, 7 months ago) by taca
Branch: MAIN
Changes since 1.78: +5 -5 lines
Diff to previous 1.78 (colored)

databases/ruby-sequel: update to 5.32.0

Update ruby-sequel to 5.32.0.

=== 5.32.0 (2020-05-01)

* Allow Database#create_table? work with :partition_of option on PostgreSQL (jeremyevans) (#1690)

* Add fiber_concurrency extension, for using Fiber.current instead of Thread.current for checking out connections (jeremyevans)

* Move most Sequel singleton methods into a module that extends Sequel for easier overriding (jeremyevans)

* Fix method visibility issues in model, plugin, extension, and adapter code (jeremyevans)

* Avoid defining conversion procs for PostgreSQL inet/cidr types in pg_inet extension when using sequel_pg 1.13.0+ (jeremyevans)

* Add run_transaction_hooks Database extension, allowing for running the transaction hooks before commit/rollback, for use with transactional testing (jeremyevans)

* Recognize timestamp(N) with time zone type (isc) (#1684)

Revision 1.78 / (download) - annotate - [select for diffs], Sun Apr 26 08:40:47 2020 UTC (3 years, 7 months ago) by taca
Branch: MAIN
Changes since 1.77: +5 -5 lines
Diff to previous 1.77 (colored)

databases/ruby-sequel: update to 5.31.0

Update ruby-sequel to 5.31.0.

=== 5.31.0 (2020-04-01)

* Fix alter_table drop_constraint :primary_key option on SQLite for non-integer primary keys (jeremyevans)

* Add skip_saving_columns plugin, which supports columns to skip when saving, and skips generated columns by default (joeosburn, jeremyevans) (#1681, #1682)

* Add support for creating partitioned tables in PostgreSQL 10+ using :partition_by and :partition_of options (jeremyevans)

* Dump generated columns as generated columns when using the schema_dumper with :same_db option on PostgreSQL 12+ (jeremyevans) (#1680)

* Ignore defaults for generated columns by default when using the schema dumper (jeremyevans) (#1680)

* Include generated columns in schema on SQLite 3.31+ (jeremyevans)

* Add :generated schema entry on PostgreSQL 12+ and SQLite 3.31+ for whether the columns is generated (jeremyevans)

* Add association_lazy_eager_option plugin for supporting :eager option for association method (jeremyevans)

* Add forbid_lazy_load plugin for forbidding lazy loading of associations, to help find N+1 issues (jeremyevans)

Revision 1.77 / (download) - annotate - [select for diffs], Sun Mar 8 13:21:16 2020 UTC (3 years, 8 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2020Q1-base, pkgsrc-2020Q1
Changes since 1.76: +5 -5 lines
Diff to previous 1.76 (colored)

databases/ruby-sequel: update to 5.30.0

Update ruby-sequel to 5.30.0.

=== 5.30.0 (2020-03-01)

* Remove specs and old release notes from the gem to reduce gem size by over 40% (jeremyevans)

* When using Database#transaction :retry_on, call :before_retry option if retrying even if :num_retries is nil (jcmfernandes) (#1678)

* Support generated columns on SQLite 3.31+ using :generated_always_as and :generated_type options (jeremyevans)

Revision 1.76 / (download) - annotate - [select for diffs], Wed Feb 5 14:40:29 2020 UTC (3 years, 9 months ago) by taca
Branch: MAIN
Changes since 1.75: +5 -5 lines
Diff to previous 1.75 (colored)

databases/ruby-sequel: update to 5.29.0

Update ruby-sequel to 5.29.0.

=== 5.29.0 (2020-02-01)

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

* Fix verbose warning in postgres adapter when using prepared statements and recent versions of ruby-pg (jeremyevans)

* Work correctly on Ruby 2.8+ by supporting second argument for initialize_clone (jeremyevans)

* Add empty_failure_backtraces plugin for empty backtraces for ValidationFailed and HookFailed exceptions, much faster on JRuby (jeremyevans)

* Add Dataset#json_serializer_opts to json_serializer plugin, allowing to set json_serializer options on a per-dataset basis (jeremyevans)

Revision 1.75 / (download) - annotate - [select for diffs], Thu Jan 16 15:18:45 2020 UTC (3 years, 10 months ago) by taca
Branch: MAIN
Changes since 1.74: +5 -5 lines
Diff to previous 1.74 (colored)

databases/ruby-sequel: update to 5.28.0

=== 5.28.0 (2020-01-01)

* Warn when calling Sequel::JDBC::Postgres::Dataset#with_fetch_size (jeremyevans) (#1665)

* Add exclude_or_null extension, for filtering datasets where the condition is false or NULL (jeremyevans)

* Add any_not_empty extension, for making Dataset#any? without a block mean !empty? (jeremyevans)

=== 5.27.0 (2019-12-01)

* Add Sequel::DEFAULT for a DEFAULT expression, useful for assigning to default values (jeremyevans)

* Make Postgres::ArrayOp#join in pg_array_ops extension work correctly on PostgreSQL <9.1 (jeremyevans)

* Make pg_enum extension work correctly on PostgreSQL 8.3-9.0 (jeremyevans)

* Emulate FILTER clause for aggregate functions using CASE on databases not supporting it directly (jeremyevans)

* Support ordering by NULLS FIRST/NULLS LAST without emulation on SQLite 3.30+ (jeremyevans)

Revision 1.74 / (download) - annotate - [select for diffs], Sat Nov 2 14:26:04 2019 UTC (4 years, 1 month ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2019Q4-base, pkgsrc-2019Q4
Changes since 1.73: +5 -5 lines
Diff to previous 1.73 (colored)

databases/ruby-sequel: update to 5.26.0

Update ruby-sequel to 5.26.0.

=== 5.26.0 (2019-11-01)

* Recognize two additional foreign key constraint violation codes on MySQL 8.0.13+ (rianmcguire) (#1657)

* Support table aliases for single-table INSERT statements on PostgreSQL 9.5+ (jeremyevans) (#1656)

* Implement Sequel::Postgres::PGRange#hash so instances work correctly in hashes (jeremyevans) (#1648)

* Make dirty plugin work correctly with typecast_on_load plugin (jeremyevans) (#1647)

* Add support for :require_modification option when setting up nested_attributes (jeremyevans)

* Add support for SQL/JSON path expressions to the pg_json_ops extension, supported by PostgreSQL 12+ (jeremyevans)

Revision 1.73 / (download) - annotate - [select for diffs], Wed Oct 23 16:13:23 2019 UTC (4 years, 1 month ago) by taca
Branch: MAIN
Changes since 1.72: +5 -5 lines
Diff to previous 1.72 (colored)

databases/ruby-sequel: update to 5.25.0

Update ruby-sequel to 5.25.0.

=== 5.25.0 (2019-10-01)

* Fix Sequel::SQL::NumericMethods#coerce to not raise NoMethodError if super method is not defined (jeremyevans) (#1645)

* Allow setting a default for a column that already has a default on Microsoft SQL Server (jeremyevans)

* Fix keyword argument separation warnings on Ruby master branch in csv_serializer plugin (jeremyevans)

* Add association_multi_add_remove plugin for adding/removing multiple associated objects in a single method call (AlexWayfer, jeremyevans) (#1641, #1643)

* Make sharding plugin integrate with server_block extension (jeremyevans)

Revision 1.72 / (download) - annotate - [select for diffs], Fri Sep 13 15:33:13 2019 UTC (4 years, 2 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2019Q3-base, pkgsrc-2019Q3
Changes since 1.71: +5 -5 lines
Diff to previous 1.71 (colored)

databases/ruby-sequel: update to 5.24.0

=== 5.24.0 (2019-09-01)

* Add Database#skip_logging? private method designed for extensions to force query timing even if no logger is present (adam12) (#1640)

* Allow a hostname specified in a defaults_file in the mysql2 adapter, by not explicitly setting :host (sapio-bdeamer) (#1638)

* Convert all database array types to Ruby arrays in the jdbc adapter (jeremyevans)

* Add static_cache_cache plugin for caching rows for static_cache models to a file to avoid database queries during model initialization (jeremyevans)

* Add :cache_file plugin option to pg_auto_constraint_validations plugin, for caching metadata to a file for faster initialization (jeremyevans)

* Support :unique_deferrable and :primary_key_deferrable column options (jeremyevans)

* Support :generated_always_as column option on PostgreSQL 12+ (jeremyevans)

=== 5.23.0 (2019-08-01)

* Work around a bug on jdbc-sqlite3 when parsing schema for tables with columns with default values (jeremyevans)

* Work around a bug in jdbc-sqlite3 when in Database#foreign_key_list in the jdbc/sqlite3 adapter (jeremyevans)

* Make Dataset#execute* private methods respect explicit servers option, fixing Dataset#paged_each in the postgres adapter when sharding (jeremyevans) (#1632)

* Handle instances of subclasses of core classes when wrapping objects in the pg_json extension (jeremyevans) (#1631)

* Support :ansi Database option in the tinytds adapter (kenaniah) (#1629)

* Support cross-database and linked servers when parsing schema on Microsoft SQL Server (kenaniah) (#1629)

* Add insert_conflict plugin for automatically handling unique constraint conflicts when saving new model instances on PostgreSQL 9.5+ and SQLite 3.24.0+ (jeremyevans)

* Avoid errors when parsing schema in the mock sqlite adapter (jeremyevans)

* Avoid possible thread-safety issue in the timezones support (jeremyevans)

* Handle offsets when typecasting an array or hash to datetime when Sequel.datetime_class = Time (jeremyevans)

* Support Sequel.datetime_class = Time when using the named_timezones extension (jeremyevans)

Revision 1.71 / (download) - annotate - [select for diffs], Sat Jul 13 14:28:18 2019 UTC (4 years, 4 months ago) by taca
Branch: MAIN
Changes since 1.70: +5 -5 lines
Diff to previous 1.70 (colored)

databases/ruby-sequel: update to 5.22.0

=== 5.22.0 (2019-07-01)

* Fix Dataset#multi_insert and #import with return: :primary_key on MSSQL when the dataset has a row_proc (jeremyevans) (#1627)

* Support Dataset#with :materialized option on PostgreSQL 12 for [NOT] MATERIALIZED (jeremyevans)

* Make Database#primary_key_sequence work on tables without serial sequences on PostgreSQL 12 (jeremyevans)

* Support ruby 2.7+ startless ranges in the pg_range extension (jeremyevans)

* Support ruby 2.7+ startless, endless ranges in filters, using an always true condition for them (jeremyevans)

* Support ruby 2.7+ startless ranges in filters, using just a <= or < operator for them (jeremyevans)

Revision 1.70 / (download) - annotate - [select for diffs], Mon Jun 10 16:02:39 2019 UTC (4 years, 5 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2019Q2-base, pkgsrc-2019Q2
Changes since 1.69: +5 -5 lines
Diff to previous 1.69 (colored)

databases/ruby-sequel: update to 5.21.0

=== 5.21.0 (2019-06-01)

* Recognize additional DatabaseLockTimeout errors in mysql and mysql2 adapters (jeremyevans)

* Disallow eager_graph of ancestors and descendants associations when using the rcte_tree plugin (jeremyevans)

* Make jdbc/mysql adapter work when using JRuby with Java 11 (jeremyevans)

* Support window function options :window, :exclude, and :frame :type=>:groups, :start, and :end on SQLite 3.28.0+ (jeremyevans)

* Make the server_block extension respect the :servers_hash Database option (jeremyevans)

* Typecast string input for json/jsonb types as JSON strings instead of parsing as JSON in the pg_json extension when Database#typecast_json_strings is set to true (jeremyevans)

* Wrap JSON primitives (string, number, true, false, nil) in the pg_json extension when Database#wrap_json_primitives is set to true (jeremyevans)

* Convert the Database :timeout option to an integer in the sqlite adapter (jeremyevans) (#1620)

* Improve performance in ado adapter using more efficient inner loop (jeremyevans)

* Improve performance in ado adapter using faster callables for type conversion (jeremyevans)

* Fix handling of decimal values in the ado adapter when using locales where the decimal separator is , and not . (jeremyevans) (#1619)

Revision 1.69 / (download) - annotate - [select for diffs], Mon May 6 05:12:28 2019 UTC (4 years, 7 months ago) by taca
Branch: MAIN
Changes since 1.68: +5 -5 lines
Diff to previous 1.68 (colored)

databases/ruby-sequel: update to 5.20.0

=== 5.20.0 (2019-05-01)

* Fix reversing of alter_table add_foreign_key when :type option is used (jeremyevans) (#1615)

* Switch from using instance_exec to define_method for model associations and in some plugins (jeremyevans)

* Fix Database#server_version when using mysql2 adapter with mysql driver on MariaDB 10+ database (v-kolesnikov) (#1614)

* Make one_to_one setter method handle models that use joined datasets (jeremyevans) (#1612)

* Make auto_validations plugin work with the class_table_inheritance plugin (jeremyevans) (#1611)

* Avoid use of instance_exec for PlaceholderLiteralString#with_dataset (jeremyevans)

* Recognize float unsigned database types as float (keeguon, jeremyevans) (#1609)

* Support :savepoint options to Database#{after_commit,after_rollback} for making the hooks handle savepoints (jeremyevans)

* Avoid use of instance_exec in association_dependencies plugin (jeremyevans)

* Add pg_auto_constraint_validation_override to the pg_auto_constraint_validations plugin, for customizing columns and error message per constraint (jeremyevans)

* Make Database#check_constraints on PostgreSQL also include constraints where the related columns are not known (jeremyevans)

Revision 1.68 / (download) - annotate - [select for diffs], Sun Apr 14 09:37:13 2019 UTC (4 years, 7 months ago) by taca
Branch: MAIN
Changes since 1.67: +5 -5 lines
Diff to previous 1.67 (colored)

databases/ruby-sequel: update to 5.19.0

=== 5.19.0 (2019-04-02)

* Use more optimized approach to merging hashes in ruby 2.5+ (jeremyevans)

* Use SQLite extended result codes when using ruby-sqlite3 1.4.0+ (jeremyevans)

* Recognize additional SQLite extended result codes in the shared sqlite adapter (jeremyevans)

* Add Database#rename_enum_value to the pg_enum extension (AlexWayfer) (#1603)

* Make Database#drop_table delete constraint validations metadata for that table if using the constraint_validations extension (jeremyevans)

* Speed up row fetching in the sqlite adapter (jeremyevans)

* Speed up row fetching and type conversion in the sqlanywhere adapter (jeremyevans)

Revision 1.67 / (download) - annotate - [select for diffs], Sun Mar 3 15:24:03 2019 UTC (4 years, 9 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2019Q1-base, pkgsrc-2019Q1
Changes since 1.66: +5 -5 lines
Diff to previous 1.66 (colored)

databases/ruby-sequel update to 5.18.0

=== 5.18.0 (2019-03-01)

* Use singleton .call methods on plain objects instead of procs/methods for faster type conversion (jeremyevans)

* Add to avoid indirection when converting values from the database (jeremyevans)

* Use while instead of each for inner loops in sqlite and jdbc adapters for better performance (jeremyevans)

* Make after_initialize plugin not make the argument to optional (jeremyevans)

* Allow Dataset#paged_each to be called without a block in the postgres and mysql2 adapters (jeremyevans)

* Remove flow-control exceptions in connection_expiration and connection_validator extensions (jeremyevans)

* Add throw_failures plugin for throwing ValidationFailed and HookFailed exceptions instead of raising them, up to 10x performance increase on JRuby (jeremyevans)

* Support tzinfo 2 in addition to tzinfo 1 in the named_timezones extension (jeremyevans) (#1596)

Revision 1.66 / (download) - annotate - [select for diffs], Sun Feb 3 14:30:59 2019 UTC (4 years, 10 months ago) by taca
Branch: MAIN
Changes since 1.65: +5 -5 lines
Diff to previous 1.65 (colored)

databases/ruby-sequel: update to 5.17.0

=== 5.17.0 (2019-02-01)

* Support skip_auto_validations instance method in auto_validations plugin
  (oldgreen, jeremyevans) (#1592)

* Support :preconnect_extensions Database option for loading extensions before
  :preconnect option (jeremyevans)

* Avoid usage of with implicit block as ruby 2.7+ deprecates this
  behavior (jeremyevans)

* Allow Sequel[].as to be used for constructing aliases with eager_graph
  (e.g. Model.eager_graph(Sequel[:a].as(:b))) (jeremyevans) (#1588)

Revision 1.65 / (download) - annotate - [select for diffs], Sun Jan 6 14:58:28 2019 UTC (4 years, 10 months ago) by taca
Branch: MAIN
Changes since 1.64: +5 -5 lines
Diff to previous 1.64 (colored)

databases/ruby-sequel: update to 5.16.0

=== 5.16.0 (2019-01-02)

* Convert integer columns to bigint columns when copying SQLite databases to other databases using bin/sequel -C (jeremyevans) (#1584)

* Use nicer error messages for missing or empty migration directories (Lavode) (#1585)

* Make alter table emulation work correctly in SQLite 3.26.0+ (jeremyevans) (#1582)

* Do not unset new one_to_one associated objects' reciprocal associations before saving associated objects in the nested_attributes plugin (jeremyevans)

* Do not validate new one_to_one associated objects twice when saving in the nested_attributes plugin (jeremyevans)

* Fix :qualify_tables option to class_table_inheritance plugin to work correctly with subclasses of subclasses (benalavi) (#1581)

* Make class_table_inheritance plugin use the schema cache instead of sending a query to get columns for tables (kenaniah) (#1580)

* Remove loading of mysqlplus in the mysql adapter (jeremyevans)

* Make mysql adapter work correctly on ruby 2.6+ (jeremyevans)

* Add Database#rollback_on_exit to rollback transactions instead of committing them when exiting the transaction block (jeremyevans)

* Enable window functions in SQLite 3.26.0+ (jeremyevans)

* Do not override existing methods when creating Sequel::Model attribute getter/setter methods (jeremyevans) (#1578)

* Use parentheses for expressions being subscripted (e.g. (array_agg(column))[1]) (jeremyevans)

Revision 1.64 / (download) - annotate - [select for diffs], Sun Dec 2 06:36:52 2018 UTC (5 years ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2018Q4-base, pkgsrc-2018Q4
Changes since 1.63: +5 -5 lines
Diff to previous 1.63 (colored)

databases/ruby-sequel: update to 5.15.0

=== 5.15.0 (2018-12-01)

* Add :conn_str option in the postgres adapter for PostgreSQL connection strings, if the pg driver is used (graywolf) (#1572)

* Add :qualify_tables option to class_table_inheritance plugin to automatically qualify subclass tables with superclass qualifier (benalavi) (#1571)

* Access already allocated connections in a thread safe manner when checking out connections in the sharded threaded connection pool (jeremyevans)

* Automatically support datasets using qualified tables in the class_table_inheritance plugin without having to use the :alias option (benalavi) (#1565)

* Support rename_column without emulation on SQLite 3.25+ (jeremyevans)

* Do not remove currently cached many_to_one associated objects when changing the related foreign key value from nil to non-nil (jeremyevans)

* Do not validate new *_to_many associated objects twice when saving in the nested_attributes plugin (jeremyevans)

* Add Model#skip_validation_on_next_save! for skipping validation on next save call (jeremyevans)

Revision 1.63 / (download) - annotate - [select for diffs], Thu Nov 1 16:21:49 2018 UTC (5 years, 1 month ago) by taca
Branch: MAIN
Changes since 1.62: +5 -5 lines
Diff to previous 1.62 (colored)

databases/ruby-sequel: update to 5.14.0

* pkgsrc change: make USE_LANGUAGES empty.

=== 5.14.0 (2018-11-01)

* Drop defaulting the :port option to 5432 in the postgres adapter, so that
  setting the :service option in :driver_options works (jeremyevans) (#1558)

* Do not cache values for columns without parseable defaults when using :cache
  option in defaults_setter plugin (jeremyevans)

* Emulate NULLS FIRST/LAST ordering on databases that do not natively support
  it (jeremyevans)

* Do not modify boolean expressions created from string or array if string or
  array is modified (jeremyevans)

* Make roots and roots_dataset dataset methods instead of class methods in the
  tree plugin (JelF) (#1554)

* Do not cache dataset SQL if dataset uses subquery that cannot cache SQL

* Make Model#=== work correctly for models with composite primary keys

* Add Model#pk_equal? as a more descriptive name for Model#=== (AlexWayfer)

* Do not push down expression inversion in cases where it may result in
  incorrect behavior (e.g. ANY/SOME/ALL operators) (jeremyevans) (#1549)

Revision 1.62 / (download) - annotate - [select for diffs], Sat Oct 13 13:56:25 2018 UTC (5 years, 1 month ago) by taca
Branch: MAIN
Changes since 1.61: +5 -5 lines
Diff to previous 1.61 (colored)

databases/ruby-sequel: update to 5.13.0

=== 5.13.0 (2018-10-01)

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

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

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

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

Revision 1.61 / (download) - annotate - [select for diffs], Mon Sep 10 15:22:27 2018 UTC (5 years, 2 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2018Q3-base, pkgsrc-2018Q3
Changes since 1.60: +5 -5 lines
Diff to previous 1.60 (colored)

databases/ruby-sequel: update to 5.12.0

=== 5.12.0 (2018-08-31)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

=== 5.11.0 (2018-08-01)

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

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

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

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

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

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

* Enable window function support on SQLAnywhere (jeremyevans)

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

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

=== 5.10.0 (2018-07-01)

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

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

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

* Make SQLTime.parse respect and Sequel.application_timezone (jeremyevans)

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

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

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

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

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

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

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

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

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

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

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

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

Revision 1.60 / (download) - annotate - [select for diffs], Wed Jun 6 04:44:51 2018 UTC (5 years, 6 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2018Q2-base, pkgsrc-2018Q2
Changes since 1.59: +5 -5 lines
Diff to previous 1.59 (colored)

databases/ruby-sequel: Update to 5.9.0

=== 5.9.0 (2018-06-01)

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

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

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

* Work around broken BC date handling in JRuby (jeremyevans)

* Switch use of to BigDecimal(), since the former is deprecated (jeremyevans)

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

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

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

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

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

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

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

* Avoid unnecessary hash creation in many places (jeremyevans)

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

Revision 1.59 / (download) - annotate - [select for diffs], Sat May 5 14:19:58 2018 UTC (5 years, 7 months ago) by taca
Branch: MAIN
Changes since 1.58: +5 -5 lines
Diff to previous 1.58 (colored)

databases/ruby-sequel: update to 5.8.0

=== 5.8.0 (2018-05-01)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

* Cache Dataset#lateral datasets (jeremyevans)

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

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

=== 5.7.0 (2018-04-01)

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

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

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

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

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

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

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

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

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

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

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

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

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

Revision 1.58 / (download) - annotate - [select for diffs], Fri Mar 9 14:15:22 2018 UTC (5 years, 8 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2018Q1-base, pkgsrc-2018Q1
Changes since 1.57: +5 -5 lines
Diff to previous 1.57 (colored)

databases/ruby-sequel: update to 5.6.0

=== 5.6.0 (2018-03-01)

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

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

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

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

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

Revision 1.57 / (download) - annotate - [select for diffs], Sun Feb 25 15:22:31 2018 UTC (5 years, 9 months ago) by taca
Branch: MAIN
Changes since 1.56: +5 -5 lines
Diff to previous 1.56 (colored) update to 5.5.0

=== 5.5.0 (2018-01-31)

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

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

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

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

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

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

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

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

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

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

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

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

=== 5.4.0 (2018-01-04)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Revision 1.56 / (download) - annotate - [select for diffs], Sat Dec 9 02:26:16 2017 UTC (5 years, 11 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2017Q4-base, pkgsrc-2017Q4
Changes since 1.55: +5 -5 lines
Diff to previous 1.55 (colored)

databases/ruby-sequel: update to 5.3.0

=== 5.3.0 (2017-12-01)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Revision 1.55 / (download) - annotate - [select for diffs], Tue Oct 31 15:53:04 2017 UTC (6 years, 1 month ago) by taca
Branch: MAIN
Changes since 1.54: +5 -5 lines
Diff to previous 1.54 (colored)

databases/ruby-sequel: update to 5.2.0

=== 5.2.0 (2017-10-27)

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

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

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

=== 5.1.0 (2017-10-01)

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

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

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

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

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

* Remove deprecated Model use_after_commit_rollback class and instance methods

* Remove deprecated Model.allowed_columns method in the base model support

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

* Remove deprecated support for Model#_before_validation private method

Revision 1.54 / (download) - annotate - [select for diffs], Sat Sep 2 14:13:11 2017 UTC (6 years, 3 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2017Q3-base, pkgsrc-2017Q3
Changes since 1.53: +5 -5 lines
Diff to previous 1.53 (colored)

Update ruby-sequel to 5.0.0.

=== 5.0.0 (2017-09-01)

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

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

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

* Make threaded connection pools not block while connections are being made

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

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

* Cache association method name symbols instead of recomputing them everytime

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

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

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

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

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

* Freeze SQL::Expression.comparison_attrs (jeremyevans)

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

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

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

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

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

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

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

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

* Deprecate Model use_after_commit_rollback class and instance accessors

* Deprecate Model.allowed_columns reader (jeremyevans)

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

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

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

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

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

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

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

* Disable symbol splitting by default (jeremyevans)

* Make datasets frozen by default (jeremyevans)

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

* Remove deprecated adapters, extensions, plugins, constants, and features

Revision 1.53 / (download) - annotate - [select for diffs], Fri Aug 18 10:17:27 2017 UTC (6 years, 3 months ago) by taca
Branch: MAIN
Changes since 1.52: +5 -5 lines
Diff to previous 1.52 (colored)

Update ruby-sequel to 4.49.0

=== 4.49.0 (2017-08-01)

* Make dataset_associations plugin automatically alias tables when using
  many_through_many associations that join the same table multiple times

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

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

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

* Deprecate Model.cti_columns in the class_table_inheritance plugin

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

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

* Deprecate treating cross join with conditions as inner join on MySQL

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

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

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

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

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

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

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

* Deprecate Dataset#autoid=, #_fetch=, and #numrows= in the mock adapter

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

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

* Make Sequel::Error#cause use #wrapped_exception if it exists on ruby 2.1+

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

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

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

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

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

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

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

* Support :sslrootcert Database option in the postgres adapter (dleavitt)

Revision 1.52 / (download) - annotate - [select for diffs], Thu Jul 13 14:29:54 2017 UTC (6 years, 4 months ago) by taca
Branch: MAIN
Changes since 1.51: +5 -5 lines
Diff to previous 1.51 (colored)

Update ruby-sequel to 4.48.0.

=== 4.48.0 (2017-07-01)

* Deprecate Model.<< (jeremyevans)
* Deprecate Dataset#{and,exclude_where,range,interval}, move to
  sequel_4_dataset_methods extension (jeremyevans)
* Make Database#indexes not include partial indexes on SQLite 3.8.8+
* Make Database#indexes include indexes created automatically from unique
  constraints on SQLite 3.8.8+ (jeremyevans)
* Deprecate Sequel::Postgres::PG_TYPES, conversion procs should not be
  registered per-Database (jeremyevans)
* Add Database#add_conversion_proc method on PostgreSQL for registering
  conversion procs (jeremyevans)
* Deprecate unexpected values passed to Dataset#insert_conflict on SQLite
* Deprecate Sequel::SqlAnywhere::Dataset#convert_smallint_to_bool= method
* Deprecate Sequel::SqlAnywhere.convert_smallint_to_bool accessor
* Use savepoints around index creation if creating table inside transaction if
  ignore_index_errors is used (jeremyevans)
* Deprecate treating :natrual_inner join type on MySQL as NATURAL LEFT JOIN
* Deprecate Dataset#mssql_unicode_strings= on Microsoft SQL Server
* Preserve encoding when parsing PostgreSQL arrays (jeltz) (#1387)
* Deprecate external modification of Sequel::JDBC::TypeConvertor (jeremyevans)
* Deprecate Sequel::DB2.use_clob_as_blob accessor (jeremyevans)
* Add Database#use_clob_as_blob accessor on DB2 (jeremyevans)
* Deprecate SEQUEL_POSTGRES_USES_PG constant (jeremyevans)
* Do not swallow original exception if exception is raised inside
  Database#copy_table on PostgreSQL (jeremyevans)
* Deprecate Sequel::Postgres.client_min_messages and force_standard_strings
  accessors (jeremyevans)
* Deprecate Sequel::Postgres.use_iso_date_format accessor (jeremyevans)
* Do not allow connection in postgres adapter if postgres-pr driver is used
  and force_standard_strings is false (jeremyevans)
* Drop support for ancient postgres driver in postgres adapter, now only pg
  and postgres-pr drivers are supported (jeremyevans)
* Deprecate Sequel::MySQL.convert_invalid_date_time accessor (jeremyevans)
* Deprecate Sequel::MySQL.convert_tinyint_to_bool accessor (jeremyevans)
* Deprecate Sequel::MySQL.default_{charset,collate,engine} accessors
* Add Database#default_{charset,collate,engine} accessors on MySQL
* Make mock adapter thread safe (jeremyevans)
* Deprecate Sequel::JDBC::Dataset#convert_types accessor (jeremyevans)
* Add Dataset#with_convert_types in jdbc adapter (jeremyevans)
* Deprecate Sequel::IBMDB::Dataset#convert_smallint_to_bool= method
* Deprecate Sequel::IBMDB.convert_smallint_to_bool accessor (jeremyevans)
* Add Database#convert_smallint_to_bool accessor in the ibmdb adapter
* Deprecate sequel_3_dataset_methods extension (jeremyevans)
* Deprecate query_literals extension (jeremyevans)
* Deprecate using subtype conversion procs added after registering composite
  type in the pg_row extension (jeremyevans)
* Don't try canceling copy in Database#copy_into if copier is not created yet
  (aakashAu) (#1384)
* Deprecate global conversion procs added by pg_* extensions, when extension
  isn't loaded into Database instance (jeremyevans)
* Deprecate Sequel::Postgres::PGRange.register in the pg_range extension
* Deprecate Sequel::Postgres::PGArray.register in the pg_array extension
* Deprecate Database#copy_conversion_procs (private method) on PostgreSQL
* Deprecate Database#reset_conversion_procs on PostgreSQL (jeremyevans)
* Deprecate meta_def extension (jeremyevans)
* Make class_table_inheritance plugin with :alias option not use subquery for
  datasets that don't join (jeremyevans)
* Deprecate hash_aliases extension (jeremyevans)
* Deprecate filter_having extension (jeremyevans)
* Deprecate empty_array_ignore_nulls extension (jeremyevans)
* Deprecate Array#sql_array in the core_extensions extension (jeremyevans)
* Make validation_helpers plugin :allow_blank option work correctly when the
  blank extension is not loaded (jeremyevans)
* Make validation_class_methods plugin no longer require the blank extension
* Clear cached associations when touching associations in the touch plugin
* Make pg_array_associations model plugin load pg_array extension into
  database (jeremyevans)
* Remove support for :strict option in nested_attributes plugin, use
  :unmatched_pk option instead (jeremyevans)
* Make to_json class/dataset method in json_serializer plugin accept
  :instance_block option to pass block to Model#to_json (jeremyevans)
* Make to_json methods in json_serializer plugin accept blocks that are used
  to transform values before serializing to JSON (jeremyevans)
* Make Sequel.object_to_json pass block to #to_json (jeremyevans)
* Deprecate identifier_columns plugin, not needed with Sequel.split_symbols =
  false (jeremyevans)
* Make reloading column_conflicts plugin not remove existing conflict markings
* Deprecate cti_base_model, cti_key, and cti_model_map class methods in
  class_table_inheritance plugin (jeremyevans)
* Make Model.skip_auto_validations(:not_null) in the auto_validations plugin
  skip not null checks for columns with default values (jeremyevans)
* Make Database#copy_into in jdbc/postgresql adapter respect :server option
* Make #to_hash and #to_hash_groups handle options in the static_cache plugin,
  and add rename #to_hash to #as_hash (jeremyevans)
* Rename Dataset#to_hash to #as_hash, and add #to_hash as an alias, to allow
  undefing #to_hash to fix ruby calling it implicitly (jeremyevans) (#1375)
* Handle PG* constants deprecated in pg 0.21.0 in the postgres adapter
  (jeremyevans) (#1377, #1378)
* Support :association_pks_use_associated_table association option in
  association_pks plugin (jeremyevans)
* Make pg_hstore extension reset hstore conversion proc when running
  Database#reset_conversion_procs (jeremyevans)
* Fix incorrect SQL used for inserting into a CTI subclass sharing the primary
  table when using the :alias option (jeremyevans)

Revision 1.51 / (download) - annotate - [select for diffs], Sun Jun 4 15:03:09 2017 UTC (6 years, 6 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2017Q2-base, pkgsrc-2017Q2
Changes since 1.50: +5 -5 lines
Diff to previous 1.50 (colored)

Update ruby-sequel to 4.47.0.

=== 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

=== 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
* 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}
* Deprecate Database#jdbc_* methods for jdbc/db2 adapter Database instances
* Remove addition of Database#jdbc_* to JDBC::Database in jdbc/db2 adapter
* 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
* 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
* Deprecate Sequel::VirtualRow#` to create literal SQL, use Sequel.lit instead
* 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
* 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
* 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
* 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)

Revision 1.50 / (download) - annotate - [select for diffs], Sat Apr 22 16:18:39 2017 UTC (6 years, 7 months ago) by taca
Branch: MAIN
Changes since 1.49: +5 -5 lines
Diff to previous 1.49 (colored)

Update ruby-sequel to 4.45.0.

=== 4.45.0 (2017-04-01)

* Correctly handle datasets with offsets but no limits used in compound datasets on MSSQL <2012 (jeremyevans)
* Correctly handle false values in the split_values plugin (bananarne) (#1333)
* Deprecate Dataset#dup/clone and Model.dup/clone (jeremyevans)
* Deprecate the schema and scissors plugins (jeremyevans)
* Deprecate Model.{lazy_attributes,nested_attributes,composition,serialization}_module accessors (jeremyevans)
* Deprecate Database#database_name on MySQL (jeremyevans)
* Deprecate Database#use on MySQL (jeremyevans)
* Make pg_hstore extension no longer update PG_NAMED_TYPES (jeremyevans)
* Deprecate Sequel::PG_NAMED_TYPES (jeremyevans)
* Add columns_updated plugin for making updated columns hash available in after_update and after_save hooks (jeremyevans)
* Deprecate accessing @columns_updated directly in model after_update and after_save hooks (jeremyevans)
* Deprecate Database#{add,remove}_servers when not using a sharded connection pool (jeremyevans)
* Deprecate Database#each_server (jeremyevans)
* Make Model#_valid? private method accept only an options hash (jeremyevans)
* Deprecate returning false from model before hooks to cancel the action, use Model#cancel_action (jeremyevans)
* Handle Model#cancel_action correctly in before hooks when Model#valid? is called (jeremyevans)
* Deprecate Sequel::BeforeHookFailed (jeremyevans)
* Deprecate passing multiple arguments as filter arguments when not using a conditions specifier (jeremyevans)
* Deprecate passing Procs as filter arguments, require they be passed as blocks (jeremyevans)
* Deprecate Sequel::Error::* exception class aliases (jeremyevans)
* Deprecate prepared_statements_associations and prepared_statements_with_pk plugins (jeremyevans)
* Deprecate Sequel::Unbinder, Sequel::UnbindDuplicate, and Dataset#unbind (jeremyevans)
* Deprecating calling Sequel::Qualifier with two arguments (jeremyevans)
* Add validation_contexts plugin for supporting custom contexts when validating (jeremyevans)
* Deprecate Sequel::Database.single_threaded singleton accessor (jeremyevans)
* Deprecate treating unrecognized prepared statement type as :select (jeremyevans)
* Deprecate Sequel.identifier_{in,out}put_method= and .quote_identifiers= singleton setters (jeremyevans)
* Deprecate Sequel::Database.identifier_{in,out}put_method and .quote_identifiers singleton accessors (jeremyevans)
* Deprecate loading the identifier_mangling by default, require it be loaded explicitly if needed (jeremyevans)
* Make Database#dump_{table_schema,schema_migration} in schema_dumper extension support :schema option (dadario) (#1328)
* Make Dataset#delete respect an existing limit on Microsoft SQL Server (jeremyevans)
* Add Dataset#skip_limit_check to mark a dataset as skipping the limit/offset check for updates and deletes (jeremyevans)
* Deprecate calling Dataset#{update/delete/truncate} on datasets with limits or offsets unless the database supports it (jeremyevans)
* Add deprecation message for using association_pks setter method with :delay_pks=>true association option (jeremyevans)
* Add deprecation message for using association_pks setter method without :delay_pks association option (jeremyevans)
* Deprecate having duplicate column names in subclass tables when using the class_table_inheritance plugin (jeremyevans)
* Deprecate do (DataObjects), swift, and jdbc/as400 adapters (jeremyevans)
* Deprecate support for Cubrid, Firebird, Informix, and Progress databases (jeremyevans)
* The :proxy_argument option passed to association_proxies plugin block is now an empty hash if no arguments are passed to the association method (jeremyevans)
* Deprecate passing non-hash arguments to association methods (jeremyevans)
* Deprecate passing multiple arguments to association methods (jeremyevans)
* Deprecate model transaction hook methods (jeremyevans)
* Drop support for pg <0.8.0 in the postgres adapter (jeremyevans)
* Deprecate passing a block to Database#from (jeremyevans)
* Deprecate Sequel::Model::ANONYMOUS_MODEL_CLASSES{,_MUTEX} (jeremyevans)
* Deprecate Sequel.cache_anonymous_models and Sequel.cache_anonymous_models= (jeremyevans)
* Automatically use from_self when using a dataset as part of a compound if it has an offset but no limit (jeremyevans)
* Drop order on existing datasets when using Dataset#union/intersect/except on Microsoft SQL Server unless a limit or offset is used (jeremyevans)
* Deprecate dataset mutation (jeremyevans)
* Handle dumping of autoincrementing 64-bit integer primary key columns correctly when using :same_db option in the schema dumper (jeremyevans) (#1324)
* Add Model.dataset_module_class accessor, allowing plugins to support custom behavior in dataset_module blocks (jeremyevans)
* Make ORDER BY come after UNION/INTERSECT/EXCEPT on Microsoft SQL Server and SQLAnywhere (jeremyevans)
* Make Database#indexes on MySQL handle qualified identifiers (jeremyevans) (#1316)
* Add oracle support to the odbc adapter (samuel02) (#1315)

Revision 1.49 / (download) - annotate - [select for diffs], Sat Mar 11 16:43:31 2017 UTC (6 years, 8 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2017Q1-base, pkgsrc-2017Q1
Changes since 1.48: +5 -5 lines
Diff to previous 1.48 (colored)

Update ruby-sequel to 4.44.0.

=== 4.44.0 (2017-03-01)

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

* Add eager method to dataset_module (jeremyevans)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

=== 4.43.0 (2017-02-01)

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

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

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

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

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

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

* Freeze enum_labels in the pg_enum extension (jeremyevans)

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

* Handle primary_key_sequences thread-safely on Oracle (jeremyevans)

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

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

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

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

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

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

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

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

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

Revision 1.48 / (download) - annotate - [select for diffs], Fri Jan 13 15:30:04 2017 UTC (6 years, 10 months ago) by taca
Branch: MAIN
Changes since 1.47: +5 -5 lines
Diff to previous 1.47 (colored)

Update ruby-sequel to 4.42.1.

=== 4.42.1 (2017-01-12)

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

=== 4.42.0 (2017-01-01)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

=== 4.41.0 (2016-12-01)

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

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

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

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

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

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

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

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

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

* Fix hook_class_methods plugin handling of commit hooks (jeremyevans)

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

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

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

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

Revision 1.47 / (download) - annotate - [select for diffs], Tue Nov 1 16:44:15 2016 UTC (7 years, 1 month ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2016Q4-base, pkgsrc-2016Q4
Changes since 1.46: +5 -5 lines
Diff to previous 1.46 (colored)

Update ruby-sequel to 4.40.0.

=== 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 is treated as, :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)

Revision 1.46 / (download) - annotate - [select for diffs], Sun Oct 9 12:48:41 2016 UTC (7 years, 1 month ago) by taca
Branch: MAIN
Changes since 1.45: +5 -5 lines
Diff to previous 1.45 (colored)

Update ruby-sequel to 4.39.0.

=== 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)

Revision 1.45 / (download) - annotate - [select for diffs], Sat Sep 10 06:24:14 2016 UTC (7 years, 2 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2016Q3-base, pkgsrc-2016Q3
Changes since 1.44: +5 -5 lines
Diff to previous 1.44 (colored)

Update ruby-sequel to 4.38.0.

=== 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 to set the date used for SQLTime instances (jeremyevans)

Revision 1.44 / (download) - annotate - [select for diffs], Sun Aug 21 08:30:24 2016 UTC (7 years, 3 months ago) by taca
Branch: MAIN
Changes since 1.43: +5 -5 lines
Diff to previous 1.43 (colored)

Update ruby-sequel to 4.37.0.

=== 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)

Revision 1.43 / (download) - annotate - [select for diffs], Sun Jul 17 14:27:46 2016 UTC (7 years, 4 months ago) by taca
Branch: MAIN
Changes since 1.42: +5 -5 lines
Diff to previous 1.42 (colored)

Update ruby-sequel to 4.36.0.

=== 4.36.0 (2016-07-01)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

=== 4.35.0 (2016-06-01)

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

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

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

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

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

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

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

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

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

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

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

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

* Fix frozen string literal issues on JRuby (jeremyevans)

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

=== 4.34.0 (2016-05-01)

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

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

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

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

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

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

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

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

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

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

Revision 1.42 / (download) - annotate - [select for diffs], Sat Apr 9 13:42:09 2016 UTC (7 years, 7 months ago) by wen
Branch: MAIN
CVS Tags: pkgsrc-2016Q2-base, pkgsrc-2016Q2
Changes since 1.41: +5 -5 lines
Diff to previous 1.41 (colored)

Update to 4.33.0

Upstream changes:

Last Update: 2016-04-01 07:24:12 -0700
New Features

    A Sequel::Model.require_valid_table accessor has been added. This setting is false for backwards compatibility, but if set to true, will raise an error you try to create a model class where an invalid table name is used or the schema or columns cannot be determined. This makes it easier to catch bugs, as things will fail fast, but it means that you must change code like:

    class Foo < Sequel::Model
      set_dataset :my_foos


    class Foo < Sequel::Model(:my_foos)

    as otherwise Foo will attempt to use the foos table by default when creating the class, which will raise an error as it is not the correct table name.

    Sequel::Database#transaction now supports a :savepoint=>:only option, which will create a savepoint if already inside a transaction, but will yield without creating a transaction if not inside a transaction. The use case for this is when you are running code that may raise an exception, and you don't want to invalidate the current transaction state.

Other Improvements

    The graph_each extension now splits results into subhashes when using Sequel::Dataset#first, as it did before Sequel 4.27.0.

    On PostgreSQL, Dataset#insert_conflict now accepts an array of columns as the value for the :target option.

    You can now pass a Sequel::SQL::Identifier or a Sequel::SQL::QualifiedIdentifer as the table argument when creating a foreign key. Previously, only symbols were supported, and using other values required specifying the :table option. So this will now work to reference a table that includes a double underscore:

    foreign_key :foo_id, Sequel.identifier(:fo__oo)

    Creating model classes inside a transaction on PostgreSQL where the implicit table name isn't correct no longer causes the transaction to fail.

    Similar issues were also fixed in the boolean_readers, boolean_subsets, and class_table_inheritance plugins.

    On PostgreSQL, You can now use the :qualify=>true option in the schema dumper, to dump using schema-qualified table names.

    On Microsoft SQL Server, the set_column_allow_null and set_column_not_null alter table methods now work on varchar(max), text, and similar columns.

    On Oracle, Sequel::Database#sequence_for_table now returns nil if given a table that doesn't exist or that the user does not have access to.

    Passing arbitrary objects to a model association method now indicates that the association should be reloaded, which was used to work but was broken in Sequel 4.32.0.

    It is now possible to raise Sequel::ValidationFailed and Sequel::HookFailed without an argument.

Backwards Compatibility

    Sequel::Model no longer swallows many errors when subclassing or setting datasets. While this should hopefully not affect backwards compatibility, it may break things where the methods were raising exceptions. If this does break backwards compatibility, it is most likely because it is no longer hiding another bug that should be fixed. Specific changes include:

        Model.inherited no longer rescues exceptions raised by set_dataset

        When subclassing a model that has a dataset, the columns and schema are just copied from the superclass

        Only Sequel::Error is rescued in calls to columns and schema, before it would rescue StandardError.

    The Sequel.firebird and Sequel.informix adapter methods have been removed, they are no longer needed as the firebird and informix adapters were removed a few versions back.

Revision 1.41 / (download) - annotate - [select for diffs], Tue Mar 8 13:57:23 2016 UTC (7 years, 8 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2016Q1-base, pkgsrc-2016Q1
Changes since 1.40: +5 -5 lines
Diff to previous 1.40 (colored)

Update ruby-sequel to 4.32.0.

=== 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)

Revision 1.40 / (download) - annotate - [select for diffs], Tue Feb 16 14:31:58 2016 UTC (7 years, 9 months ago) by taca
Branch: MAIN
Changes since 1.39: +5 -5 lines
Diff to previous 1.39 (colored)

Update ruby-sequel to 4.31.0.

= Improvements

* Sequel now works with ruby 2.3's --enable-frozen-string-literal,
  and all of the library files are set to use frozen string
  literals by default.

  A couple adapters and extensions depend on libraries that have
  issues with frozen string literals.  Pull requests have been sent
  to each of those dependencies.

* The migrators will now raise an exception if a migration file
  contains no migrations or more than one migration.

* The jdbc/postgresql adapter now supports using PostgreSQL specific
  types in bound variables.  Note that the current version of
  jdbc-postgres (9.4.1204) has regressions that affect this, users
  who need this support should stick with jdbc-postgres 9.4.1200 or

* The jdbc/postgresql adapter now works around a regression in Java
  method lookup in JRuby

* The setter methods added by the association_pks plugin now do type
  casting immediately, instead of right before the data will be used.
  This makes them more similar to column setter methods, and ensures
  that future calls to the getters that use cached values will
  return correctly typecast data.

* The PostgreSQL array parser in the pg_array extension now handles
  arrays with explicit bounds.  The explicit bounds are ignored, so
  such values do not round trip, and there is currently no support for
  creating arrays with explicit bounds.

* Creating a table with a simple non-incrementing primary key and a
  self-referential foreign key now works correctly on MySQL:

    DB.create_table!(:table) do
      Integer :id, :primary_key=>true
      foreign_key :fk, :table

* Database#disconnect in the oracle adapter now works correctly on
  more recent versions of oci8 where #logoff can raise OCIException
  instead of OCIInvalidHandle.

= Backwards Compatibility

* The pg_array extension no longer defines
  Sequel::Postgres::PGArray::JSONCreator.  This should only affect
  backwards compatibility if you were accessing the constant directly.
  The :parser option to Sequel::Postgres::PGArray.register is also no
  longer respected, but that should not affect backwards compatibility.

* The Sequel::Model#convert_cpk_array private method that was added by
  the association_pks plugin has been removed.
  Sequel::Model#convert_pk_array handles both simple and composite
  primary keys now.

Revision 1.39 / (download) - annotate - [select for diffs], Wed Jan 6 15:21:02 2016 UTC (7 years, 11 months ago) by taca
Branch: MAIN
Changes since 1.38: +5 -5 lines
Diff to previous 1.38 (colored)

Update ruby-sequel to 4.30.0.

= New Features

* Overriding the :limit and :eager_limit_strategy association options
  can now be done on a per-call basis when eager loading, by using an
  eager block callback and setting the :eager_limit or
  :eager_limit_strategy dataset options. Example:

    Album.eager(:tracks=>proc{|ds| ds.clone(:eager_limit=>5)}).all

* Dataset#insert_conflict and #insert_ignore have been added on
  SQLite, adding support for the INSERT OR ... SQL syntax:

    DB[:table].insert_ignore.insert(:a=>1, :b=>2)

    DB[:table].insert_conflict(:replace).insert(:a=>1, :b=>2)

* An identifier_columns plugin has been added, which allows
  Sequel::Model#save to work when column names contain double

= Other Improvements

* IPv6 addresses can now be used in connection URLs when using
  ruby 1.9.3+.

* The :db_type entries in column schema hashes now include sizes
  for string and decimal types on DB2 and when using the jdbc
  adapter's generic schema parsing.

* Database#row_type in the pg_row extension now handles different
  formats of specifying schema qualified types.  So a row type
  registered via :schema__type can be found using
  Sequel.qualify(:schema, :type).

* Another disconnect error is recognized in the tinytds adapter.

Revision 1.38 / (download) - annotate - [select for diffs], Wed Dec 2 14:11:58 2015 UTC (8 years ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2015Q4-base, pkgsrc-2015Q4
Changes since 1.37: +5 -5 lines
Diff to previous 1.37 (colored)

Update ruby-sequel to 4.29.0.

=== 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)

Revision 1.37 / (download) - annotate - [select for diffs], Sun Nov 29 12:12:41 2015 UTC (8 years ago) by taca
Branch: MAIN
Changes since 1.36: +5 -5 lines
Diff to previous 1.36 (colored)

Update sequel to 4.28.0.

=== 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)

Revision 1.36 / (download) - annotate - [select for diffs], Tue Nov 3 01:56:34 2015 UTC (8 years, 1 month ago) by agc
Branch: MAIN
Changes since 1.35: +2 -1 lines
Diff to previous 1.35 (colored)

Add SHA512 digests for distfiles for databases category

Problems found with existing distfiles:
No changes made to the cstore or mariadb55-client distinfo files.

Otherwise, existing SHA1 digests verified and found to be the same on
the machine holding the existing distfiles (morden).  All existing
SHA1 digests retained for now as an audit trail.

Revision 1.35 / (download) - annotate - [select for diffs], Sun Oct 4 08:50:13 2015 UTC (8 years, 2 months ago) by taca
Branch: MAIN
Changes since 1.34: +4 -4 lines
Diff to previous 1.34 (colored)

Update ruby-sequel to 4.27.0.

=== 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)

Revision 1.34 / (download) - annotate - [select for diffs], Sun Sep 13 04:48:44 2015 UTC (8 years, 2 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2015Q3-base, pkgsrc-2015Q3
Changes since 1.33: +4 -4 lines
Diff to previous 1.33 (colored)

Upadte ruby-sequel to 4.26.0.

=== 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{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)

Revision 1.33 / (download) - annotate - [select for diffs], Sun Aug 2 15:51:20 2015 UTC (8 years, 4 months ago) by taca
Branch: MAIN
Changes since 1.32: +4 -4 lines
Diff to previous 1.32 (colored)

Update ruby-sequel to 4.25.0.

=== 4.25.0 (2015-08-01)

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

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

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

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

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

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

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

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

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

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

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

* PreparedStatement#prepare now raises an Error (jeremyevans)

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

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

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

* Remove the deprecated firebird and informix adapters (jeremyevans)

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

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

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

=== 4.24.0 (2015-07-01)

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

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

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

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

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

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

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

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

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

* Remove the deprecated db2 and dbi adapters (jeremyevans)

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

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

Revision 1.32 / (download) - annotate - [select for diffs], Wed Jun 3 11:11:15 2015 UTC (8 years, 6 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2015Q2-base, pkgsrc-2015Q2
Changes since 1.31: +4 -4 lines
Diff to previous 1.31 (colored)

Update ruby-sequel to 4.23.0.

=== 4.23.0 (2015-06-01)

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

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

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

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

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

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

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

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

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

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

=== 4.22.0 (2015-05-01)

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

* Avoid hash allocations and rehashes (jeremyevans)

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

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

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

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

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

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

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

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

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

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

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

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

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

=== 4.21.0 (2015-04-01)

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

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

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

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

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

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

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

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

Revision 1.31 / (download) - annotate - [select for diffs], Sun Mar 8 16:12:05 2015 UTC (8 years, 9 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2015Q1-base, pkgsrc-2015Q1
Changes since 1.30: +4 -4 lines
Diff to previous 1.30 (colored)

Update ruby-sequel to 4.20.0.

=== 4.20.0 (2015-03-03)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Revision 1.30 / (download) - annotate - [select for diffs], Mon Feb 2 12:55:48 2015 UTC (8 years, 10 months ago) by taca
Branch: MAIN
Changes since 1.29: +4 -4 lines
Diff to previous 1.29 (colored)

Update ruby-sequel to 4.19.0.

=== 4.19.0 (2015-02-01)

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

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

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

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

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

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

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

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

Revision 1.29 / (download) - annotate - [select for diffs], Sun Feb 1 13:35:41 2015 UTC (8 years, 10 months ago) by taca
Branch: MAIN
Changes since 1.28: +4 -4 lines
Diff to previous 1.28 (colored)

Update ruby-sequel to 4.18.0.

Changes are too many to write here, please refer CHANGELOG file.

Revision 1.28 / (download) - annotate - [select for diffs], Sun Jun 15 16:32:31 2014 UTC (9 years, 5 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2014Q4-base, pkgsrc-2014Q4, pkgsrc-2014Q3-base, pkgsrc-2014Q3, pkgsrc-2014Q2-base, pkgsrc-2014Q2
Changes since 1.27: +4 -4 lines
Diff to previous 1.27 (colored)

Update ruby-sequel to 4.11.0.
Changes from 4.8.0 is too many to write here, please refer there files:


Revision 1.27 / (download) - annotate - [select for diffs], Thu Mar 13 18:24:52 2014 UTC (9 years, 8 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2014Q1-base, pkgsrc-2014Q1
Changes since 1.26: +4 -4 lines
Diff to previous 1.26 (colored)

Update ruby-sequel to 4.8.0.

=== 4.8.0 (2014-03-01)

* Add SQL::AliasedExpression#alias alias for #aliaz (jeremyevans)

* Handle SQL::Identifier, SQL::QualifiedIdentifier, and SQL::AliasedExpression objects as first argument to Dataset#graph (jeremyevans)

* Respect qualification and aliases in symbols passed as first argument to Dataset#graph (dividedmind) (#769)

* Recognize new constraint violation error messages in SQLite 3.8.2+ (itswindtw) (#766)

* Use limit strategy to correctly handle limited associations in the dataset_associations plugin (jeremyevans)

* Handle issues in dataset_associations plugin when dataset uses unqualified identifiers for associations requiring joins (jeremyevans)

* Handle fractional seconds in input timestamps in the odbc/mssql adapter (Ross Attrill, jeremyevans)

* Return fractional seconds in timestamps in the odbc adapter (jeremyevans)

* Support :plain and :phrase options to Dataset#full_text_search on PostgreSQL (jeremyevans)

* Use limit strategy to correctly handle filtering by limited associations (jeremyevans)

* Simplify queries used for filtering by associations with conditions (jeremyevans)

* Use an eager limit strategy by default for *_one associations with orders (jeremyevans)

* Support :limit_strategy eager_graph option, for specifying strategy used for limited associations in that eager graph (jeremyevans)

* Add eager_graph_with_options to model datasets, for specifying options specific to the eager_graph call (jeremyevans)

* Handle offsets on *_many associations when eager graphing when there are no associated results (jeremyevans)

* Make Database#register_array_type work without existing scalar conversion proc in the pg_array extension (jeremyevans)

* Handle presence validations on foreign keys in associated objects when creating new associated objects in the nested_attributes plugin (jeremyevans)

* Respect offsets when eager graphing *_one associations (jeremyevans)

* Add association_join to model datasets, for setting up joins based on associations (jeremyevans)

* Add one_through_many association to many_through_many plugin, for only returning a single record (jeremyevans)

* Add :graph_order association option, useful when :order needs to contain qualified identifiers (jeremyevans)

* Add one_through_one association, similar to many_to_many but only returning a single record (jeremyevans)

=== 4.7.0 (2014-02-01)

* Don't swallow underlying exception if there is an exception closing the cursor on PostgreSQL (jeremyevans) (#761)

* Recognize primary key unique constraint violations on MSSQL and SQLAnywhere (jeremyevans)

* Recognize composite unique constraint violations on SQLite (timcraft) (#758)

* Make #* method without arguments on SQL::Function return a Function with * prepended to the arguments (jeremyevans)

* Add #function to SQL::Identifier and SQL::QualifiedIdentifier, allowing for easy use of schema qualified functions or functions names that need quoting (jeremyevans)

* Add SQL::Function#distinct for easier creation of aggregate functions using DISTINCT (jeremyevans)

* Add SQL::Function#over for easier creation of window functions (jeremyevans)

* Don't clear validation instance_hooks until after a successful save (jeremyevans)

* Support :raise_on_save_failure option for one_to_many, pg_array_to_many, and many_to_pg_array associations (jeremyevans)

* Make SQLTime#to_s return a string in HH:MM:SS format, since it shouldn't include date information (jeremyevans)

* Support the Database#tables :schema option in the jdbc adapter (robbiegill, jeremyevans) (#755)

* Automatically rollback transactions in killed threads in ruby 2.0+ (chanks) (#752)

* Add update_or_create plugin, for updating an object if it exists, or creating such an object if it does not (jeremyevans)

* Make auto_validations uniqueness validations work correctly for STI subclasses (jeremyevans)

* Support :dataset option to validates_unique vaildation (jeremyevans)

=== 4.6.0 (2014-01-02)

* Add Database#call_mssql_sproc on MSSQL for calling stored procedures and handling output parameters (jrgns, jeremyevans) (#748)

* Handle RuntimeErrors raised by oci8 in the oracle adapter (jeremyevans)

* Support OFFSET/FETCH on Microsoft SQL Server 2012 (jeremyevans)

* Support :server option for Database#{commit,rollback}_prepared_transaction on PostgreSQL, MySQL, and H2 (jeremyevans) (#743)

* Do not attempt to eager load and raise an exception when doing Model.eager(...).naked.all (jeremyevans)

* Recognize a couple additional disconnect errors in the jdbc/postgresql adapter (jeremyevans) (#742)

Revision 1.26 / (download) - annotate - [select for diffs], Sun Dec 8 16:51:45 2013 UTC (9 years, 11 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2013Q4-base, pkgsrc-2013Q4
Changes since 1.25: +4 -4 lines
Diff to previous 1.25 (colored)

Update ruby-sequel to 4.5.0.

=== 4.5.0 (2013-12-02)

* Support :on_commit=>(:drop|:delete_rows|:preserve_rows) options when creating temp tables on PostgreSQL (rosenfeld) (#737)

* Make Dataset#insert work on PostgreSQL if the table name is a SQL::PlaceholderLiteralString (jeremyevans) (#736)

* Copy unique constraints when emulating alter_table operations on SQLite (jeremyevans) (#735)

* Don't return clob column values as SQL::Blob instances in the db2 and ibmdb adapters unless use_clob_as_blob is true (jeremyevans)

* Make use_clob_as_blob false by default on DB2 (jeremyevans)

* Fix usage of Sequel::SQL::Blob objects as prepared statement arguments in jdbc/db2 adapter when use_clob_as_blob is false (jeremyevans)

* Add mssql_optimistic_locking plugin, using a timestamp/rowversion column to protect against concurrent updates (pinx, jeremyevans) (#731)

* Make Model.primary_key array immutable for composite keys (chanks) (#730)

=== 4.4.0 (2013-11-01)

* Make Database#tables not show tables in the recycle bin on Oracle (jeremyevans) (#728)

* Don't automatically order on all columns when emulating offsets for unordered datasets on DB2 (jeremyevans)

* Improve PostgreSQL type support in the jdbc/postgresql adapter (jeremyevans)

* Make offset emulation on Oracle work when using columns that can't be ordered (jeremyevans, sdeming) (#724, #725)

* Make filter by associations support handle associations with :conditions or block (jeremyevans)

* Make association cloning handle :block correctly for clones of clones (jeremyevans)

* Make association cloning handle :eager_block option correctly (jeremyevans)

* Make add_primary_key work on h2 (jeremyevans)

* Add support for foreign key parsing on Oracle (jeremyevans)

* Add support for foreign key parsing to the jdbc adapter (jeremyevans)

* Make add_foreign_key work on HSQLDB (jeremyevans)

* Add table_select plugin for selecting table.* instead of * for model datasets (jeremyevans)

* Issue constraint_validation table deletes before inserts, so modifying constraint via drop/add in same alter_table block works (jeremyevans)

* Support add_*/remove_*/remove_all_* pg_array_to_many association methods on unsaved model objects (jeremyevans)

* Add Sybase SQLAnywhere support via new sqlanywhere and jdbc/sqlanywhere adapters (gditrick, jeremyevans)

* Add Dataset#offset for setting the offset separately from the limit (Paul Henry, jeremyevans) (#717)

=== 4.3.0 (2013-10-02)

* Fix literalization of empty blobs on MySQL (jeremyevans) (#715)

* Ensure Dataset#page_count in pagination extension is at least one
  (jeremyevans) (#714)

* Recognize another disconnect error in the jdbc/as400 adapter (jeremyevans)

* Make Dataset#qualify and Sequel.delay work together (jeremyevans)

* Recognize citext type as string on PostgreSQL (isc) (#710)

* Support composite keys in the rcte_tree plugin (jeremyevans)

* Support composite keys in the tree plugin (jeremyevans)

* Make Migrator.migrator_class public (robertjpayne, jeremyevans) (#708)

* Make PostgreSQL empty array literalization work correctly on PostgreSQL <8.4

* 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)

Revision 1.25 / (download) - annotate - [select for diffs], Wed Sep 11 15:16:55 2013 UTC (10 years, 2 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2013Q3-base, pkgsrc-2013Q3
Changes since 1.24: +4 -4 lines
Diff to previous 1.24 (colored)

Update ruby-sequel to 4.2.0.

Changes from 3.48.0 are too many to write here, please refer CHANGELOG

Revision 1.24 / (download) - annotate - [select for diffs], Fri Jun 14 16:51:39 2013 UTC (10 years, 5 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2013Q2-base, pkgsrc-2013Q2
Changes since 1.23: +4 -4 lines
Diff to previous 1.23 (colored)

Update ruby-sequel to 3.48.0.

Changes are too many to write here, please refer CHANGELOG or release notes.

Revision 1.23 / (download) - annotate - [select for diffs], Sun Mar 10 13:14:00 2013 UTC (10 years, 8 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2013Q1-base, pkgsrc-2013Q1
Changes since 1.22: +4 -4 lines
Diff to previous 1.22 (colored)

Update ruby-sequel to 3.45.0.

=== 3.45.0 (2013-03-01)

* 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,

* 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)

* 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

* Address JSON.parse vulnerabilities (jeremyevans)

* Fix Dataset#from_self! to no longer create a self-referential dataset

* 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

Revision 1.22 / (download) - annotate - [select for diffs], Sat Feb 9 15:41:43 2013 UTC (10 years, 9 months ago) by taca
Branch: MAIN
Changes since 1.21: +4 -4 lines
Diff to previous 1.21 (colored)

Update ruby-sequel to 3.44.0.

=== 3.44.0 (2013-02-04)

* 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

* 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

* Allow the :dataset association option to accept the association reflection
  as an argument (jeremyevans)

* Improve association method performance by caching intermediate dataset

Revision 1.21 / (download) - annotate - [select for diffs], Sat Jan 12 04:50:00 2013 UTC (10 years, 10 months ago) by taca
Branch: MAIN
Changes since 1.20: +4 -4 lines
Diff to previous 1.20 (colored)

[>Update ruby-sequel to 3.43.0.

=== 3.43.0 (2013-01-08)

* 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)

Revision 1.20 / (download) - annotate - [select for diffs], Sun Dec 16 16:07:10 2012 UTC (10 years, 11 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2012Q4-base, pkgsrc-2012Q4
Changes since 1.19: +4 -4 lines
Diff to previous 1.19 (colored)

Update ruby-sequel to 3.42.0.

=== 3.42.0 (2012-12-03)

* 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)

=== 3.41.0 (2012-11-01)

* 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)

=== 3.40.0 (2012-09-26)

* 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)

Revision 1.19 / (download) - annotate - [select for diffs], Mon Sep 3 15:14:49 2012 UTC (11 years, 3 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2012Q3-base, pkgsrc-2012Q3
Changes since 1.18: +4 -4 lines
Diff to previous 1.18 (colored)

Update ruby-sequel to 3.39.0.

=== 3.39.0 (2012-09-01)

* Fix defaults_setter to set false default values (jeremyevans)

* Fix serial sequence query in Database#primary_key_sequence on PostgreSQL
  (jeremyevans) (#538)

* Add Database#copy_into when using postgres adapter with pg driver, for very
  fast inserts into tables (jeremyevans)

* Combine multiple alter_table operations into a single query where possible
  on MySQL and PostgreSQL (jeremyevans)

* Handle sets of alter_table operations on MySQL and MSSQL where later
  operations depend on earlier ones (jeremyevans)

* Add constraint_validations plugin for automatic validations of constaints
  defined by extension (jeremyevans)

* Add constraint_validations extension for defining database constraints
  similar to validations (jeremyevans)

* Add Database#supports_regexp? for checking for regular expression support

* Add Sequel.trim for cross platform trim function (jeremyevans)

* Add Sequel.char_length for cross platform char_length function (jeremyevans)

* Fixing caching of MySQL server version (hannesg) (#536)

* Allow overriding the convert_tinyint_to_bool setting on a per-Dataset basis
  in the mysql and mysql2 adapters (jeremyevans)

* Make ValidationFailed and HookFailed exceptions have model method that
  returns the related model (jeremyevans)

* Automatically wrap array arguments to most PGArrayOp methods in PGArrays

* Add set_column_not_null to alter table generator for marking a column as not
  null (jeremyevans)

* Default second argument of set_column_allow_null to true in alter table
  generator (jeremyevans)

* Allow Dataset#count to take an argument or virtual row block (jeremyevans)

* Attempt to recognize CURRENT_{DATE,TIMESTAMP} defaults and return them as
  Sequel::CURRENT_{DATE,TIMESTAMP} (jeremyevans)

* Make dataset.insert(model) assume a single column if model uses the pg_row
  plugin (jeremyevans)

* No longer handle model instances in plain (non-model) datasets when
  inserting (jeremyevans)

* Use subselects for model classes as tables in join methods in model datasets
  if the model's dataset isn't a simple select (jeremyevans)

* No longer handle model classes as tables in join/graph methods in plain
  (non-model) datasets (jeremyevans)

* Make Time->DateTime and DateTime->Time typecasts retain fractional seconds
  on ruby 1.8 (jeremyevans) (#531)

* Add bin/sequel -c support, for running code string instead of using an IRB
  prompt (jeremyevans)

* Allow subclasses plugin to take a block, which is called with each
  subclasses created (jeremyevans)

* Add :where option to validates_unique, for custom uniqueness filters

* Add :connection_handling=>:disconnect option for threaded connection pools

* Add Postgres::PGRowOp#* for referencing the members of the composite type as
  separate columns (jeremyevans)

* Make identity_map plugin work with models lacking a primary key (jeremyevans)

* Recognize MySQL set type and default value (jeremyevans) (#529)

Revision 1.18 / (download) - annotate - [select for diffs], Wed Aug 29 16:09:01 2012 UTC (11 years, 3 months ago) by taca
Branch: MAIN
Changes since 1.17: +4 -4 lines
Diff to previous 1.17 (colored)

Update ruby-sequel to 3.38.0.

=== 3.38.0 (2012-08-01)

* 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

* 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

* 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

* 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)

Revision 1.17 / (download) - annotate - [select for diffs], Tue Jul 31 13:50:37 2012 UTC (11 years, 4 months ago) by taca
Branch: MAIN
Changes since 1.16: +4 -4 lines
Diff to previous 1.16 (colored)

Update ruby-sequel to 3.37.0.

=== 3.37.0 (2012-07-02)

* Allow specifying eager_graph alias base on a per-call basis using an AliasedExpression (jeremyevans)

* Allow bin/sequel to respect multiple -l options for logging to multiple files (jeremyevans)

* Correctly handle cases where SCOPE_IDENTITY is nil in the odbc/mssql adapter (stnoonan, jeremyevans)

* Add pg_interval extension, for returning interval types as ActiveSupport::Duration instances (jeremyevans)

* Save a new one_to_one associated object once instead of twice in the nested_attributes plugin (jeremyevans)

* Don't add unnecessary filter condition when passing a new object to a one_to_one setter method (jeremyevans)

* Differentiate between column references and method references in many_through_many associations (jeremyevans)

* Use :qualify=>:deep option when joining tables in model association datasets (jeremyevans)

* Support :qualify=>:deep option to Dataset#join_table to qualify subexpressions in the expression tree (jeremyevans)

* Support :qualify=>false option to Dataset#join_table to not automatically qualify keys/values (jeremyevans)

* Make filter by associations support use column references and method references correctly (jeremyevans)

* Call super in list plugin before_create (jeremyevans) (#504)

* Do not automatically cast String to text in pg_auto_parameterize extension (jeremyevans)

* Support alter_table validate_constraint on PostgreSQL for validating constraints previously declared with NOT VALID (jeremyevans)

* Support :not_valid option when adding foreign key constraints on PostgreSQL (jeremyevans)

* Support exclusion constraints on PostgreSQL (jeremyevans)

* Allow for overriding the create/alter table generators used per Database object (jeremyevans)

* Make casting to Date/(Time/DateTime) use date/datetime functions on SQLite (jeremyevans)

* Add pg_range_ops extension for DSL support for PostgreSQL range operators and functions (jeremyevans)

* The json library is now required when running the plugin/extension specs (jeremyevans)

* Use change migrations instead of up/down migrations in the schema_dumper (jeremyevans)

* Dump unsigned integer columns with a check >= 0 constraint in the schema_dumper (stu314)

* Switch the :key_hash entry to the association :eager_loader option to use the method symbol(s) instead of the column symbol(s) (jeremyevans)

* Add :id_map entry to the hash passed to the association :eager_loader option, for easier custom eager loading (jeremyevans)

* Fix dumping of non-integer foreign key columns in the schema_dumper (jeremyevans) (#502)

* Add nested_attributes :fields option to be a proc that is called with the associated object (chanks) (#498)

* Add split_array_nil extension, for compiling :col=>[1, nil] to col IN (1) OR col IS NULL (jeremyevans)

* Add Database#extension and Dataset#extension for loading extension modules into objects automatically (jeremyevans)

* Respect an existing dataset limit when updating on Microsoft SQL Server (jeremyevans)

* Add pg_range extension, for dealing with PostgreSQL 9.2+ range types (jeremyevans)

* Make pg_array extension convert array members when typecasting Array to PGArray (jeremyevans)

* Make jdbc/postgres adapter convert array type elements (e.g. date[] arrays are returned as arrays of Date instances) (jeremyevans)

* Make the pg_inet extension handle inet[]/cidr[]/macaddr[] types when used with the pg_array extension (jeremyevans)

* Make the pg_json extension handle json[] type when used with the pg_array extension (jeremyevans)

* Fix schema parsing of h2 clob types (jeremyevans)

* Make the pg_array extension handle array types for scalar types handled by the native postgres adapter (jeremyevans)

* Generalize handling of array types in the pg_array extension, allowing easy support of custom array types (jeremyevans)

* Remove type conversion of int2vector and money types on PostgreSQL, since previous conversions were wrong (jeremyevans)

* Add eval_inspect extension, which makes Sequel::SQL::Expression#inspect attempt to return a string suitable for eval (jeremyevans)

* When emulating offset with ROW_NUMBER, default to ordering by all columns if no specific order is given (stnoonan, jeremyevans) (#490)

* Work around JRuby 1.6 ruby 1.9 mode bug in Time -> SQLTime conversion (jeremyevans)

=== 3.36.1 (2012-06-01)

* Fix jdbc adapter when DriverManager#getConnection fails (aportnov) (#488)

Revision 1.16 / (download) - annotate - [select for diffs], Sat Jun 2 00:35:15 2012 UTC (11 years, 6 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2012Q2-base, pkgsrc-2012Q2
Changes since 1.15: +4 -4 lines
Diff to previous 1.15 (colored)

Update ruby-sequel to 3.36.0.

=== 3.36.0 (2012-06-01)

* Use Bignum generic type when dumping unsigned integer types that could potentially overflow 32-bit signed integer values (stu314)

* Support :transform option in the nested_attributes plugin, for automatically preprocessing input hashes (chanks)

* Support :unmatched_pk option in the nested_attributes plugin, can be set to :create for associated objects with natural keys (chanks)

* Support composite primary keys in the nested_attributes plugin (chanks)

* Allow Model#from_json in the json_serializer plugin to use set_fields if a :fields option is given (jeremyevans)

* Support :using option to set_column_type on PostgreSQL, to force a specific conversion from the old value to the new value (jeremyevans)

* Drop indexes in the reverse order that they were added in the schema dumper (jeremyevans)

* Add :index_names option to schema dumper method, can be set to false or :namespace (stu314, jeremyevans)

* Add Database#global_index_namespace? for checking if index namespace is global or per table (jeremyevans)

* Fix typecasting of time columns on jdbc/postgres, before could be off by a millisecond (jeremyevans)

* Add document explaining Sequel's object model (jeremyevans)

* Attempt to detect more disconnect errors in the mysql2 adapter (jeremyevans)

* Add is_current? and check_current to the migrators, for checking/raising if there are unapplied migrations (pvh, jeremyevans) (#487)

* Add a jdbc subadapter for the Progress database (Michael Gliwinski, jeremyevans)

* Add pg_inet extension, for working with PostgreSQL inet and cidr types (jeremyevans)

* Fix bug in model column setters when passing an object that raises an exception for ==('') (jeremyevans)

* Add eager_each plugin, which makes each on an eagerly loaded dataset do eager loading (jeremyevans)

* Fix bugs when parsing foreign keys for tables with explicit schema on PostgreSQL (jeremyevans)

* Remove Database#case_sensitive_like on SQLite (jeremyevans)

* Remove Database#single_value in the native sqlite adapter (jeremyevans)

* Make Dataset#get work with nil and false arguments (jeremyevans)

* Make json_serializer plugin respect :root=>:collection and :root=>:instance options (jeremyevans)

* Support savepoints in prepared transactions on MySQL 5.5.23+ (jeremyevans)

* Add pg_json extension, for working with PostgreSQL 9.2's new json type (jeremyevans)

* In the optimistic locking plugin, make refresh and save after a failed save work correctly (jeremyevans)

* Support partial indexes on Microsoft SQL Server 2008 (jeremyevans)

* Make Database#call pass blocks (jeremyevans)

* Support :each when preparing statements, useful for iterating over large datasets (jeremyevans)

* Support :if_exists and :cascade options when dropping indexes on PostgreSQL (jeremyevans)

* Support :concurrently option when adding and dropping indexes on PostgreSQL (jeremyevans)

* Make Database#transaction on PostgreSQL recognize :synchronous, :read_only, and :deferrable options (jeremyevans)

* Support :sql_mode option when connecting to MySQL (jeremyevans)

* Apply :timeout MySQL connection setting on do, jdbc, and swift adapters (jeremyevans)

* Don't set Sequel::Model.db automatically when creating an anonymous class with an associated database object (jeremyevans)

* Add :connection_handling=>:queue option to the threaded connection pools, may reduce chance of stale connections (jeremyevans) (#481)

* Handle JRuby 1.7 exception handling changes when connecting in the jdbc adapter (jeremyevans) (#477)

* Make *_to_one association setters be noops if you pass a value that is the same as the cached value (jeremyevans)

* Make Model#refresh return self when using dirty plugin (jeremyevans)

Revision 1.15 / (download) - annotate - [select for diffs], Fri Jun 1 14:23:41 2012 UTC (11 years, 6 months ago) by taca
Branch: MAIN
Changes since 1.14: +4 -4 lines
Diff to previous 1.14 (colored)

Update ruby-sequel to 3.35.0.

=== 3.35.0 (2012-05-01)

* Correctly handle parsing schema for tables in other databases on MySQL (jeremyevans)

* Add DSL support for the modulus operator (%), similar to the bitwise operators (jeremyevans)

* Fix possible thread-safety issues on non-GVL ruby implementations (jeremyevans)

* Allow truncation of multiple tables at the same time on PostgreSQL (jeremyevans)

* Allow truncate to take a :cascade, :only, and :restart options on PostgreSQL (hgimenez, jeremyevans)

* Allow json and xml serializers to support :array option in class to_json method to serialize existing array of model instances (jeremyevans)

* Add dirty plugin, which saves the initial value of the column when the value is changed (jeremyevans)

* create_table now supports an :as option to create a table directly from the results of a query (jeremyevans)

* The :index option when creating columns in the schema generator can now be a hash of options passed to index (jeremyevans)

* Parsing the default column values in the oracle adapter no longer requires superuser privileges (Jason Hines)

* Add Database#cache_schema to allow schema caching to be turned of, useful for development modes where models are reloaded (jeremyevans)

* Correctly handle errors that occur when rolling back transactions (jeremyevans)

* Recognize identity type in the schema dumper (jeremyevans) (#468)

* Don't assign instance variables to Java objects, for future JRuby 2.0 support (jeremyevans) (#466)

* Use date and timestamp formats that are multilanguage and not DATEFORMAT dependent on Microsoft SQL Server (jeremyevans)

* Add Database#log_exception, which logs when a query raises an exception, for easier overriding (jeremyevans) (#465)

* Make the migrators only use transactions by default if the database supports transactional DDL (jeremyevans)

* Add Database#supports_transactional_ddl? for checking if DDL statements can be rolled back in transactions (jeremyevans)

* Don't use auto parameterization when using cursors in the pg_auto_parameterize extension (jeremyevans) (#463)

* No longer escape backslashes in strings by default, fixes doubled backslashes on some adapters (jeremyevans)

* Escape blackslash-carriage return-line feed in strings on Microsoft SQL Server (mluu, jeremyevans) (#462, #461)

* Remove Array#all_two_pairs? (jeremyevans)

* Remove Dataset#disable_insert_returning on PostgreSQL (jeremyevans)

* Remove support for PostgreSQL <8.2 (jeremyevans)

* Remove support for Ruby <1.8.7 (jeremyevans)

Revision 1.14 / (download) - annotate - [select for diffs], Sat Apr 28 14:06:51 2012 UTC (11 years, 7 months ago) by taca
Branch: MAIN
Changes since 1.13: +4 -4 lines
Diff to previous 1.13 (colored)

Update ruby-sequel package to 3.34.1.

=== 3.34.1 (2012-04-02)

* Fix bug in optimization of primary key lookup (jeremyevans) (#460)

As for 3.34.0, changes are too many, please refer:

Revision 1.13 / (download) - annotate - [select for diffs], Sat Mar 17 14:29:27 2012 UTC (11 years, 8 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2012Q1-base, pkgsrc-2012Q1
Changes since 1.12: +4 -4 lines
Diff to previous 1.12 (colored)

Update ruby-sequel package to 3.33.0.

=== 3.33.0 (2012-03-01)

* Add ability to force or disable transactions completely in the migrators
  using the :use_transactions option (jeremyevans)

* Add ability to turn off transactions for migrations by calling
  no_transaction inside the Sequel.migration block (jeremyevans)

* Allow specifically choosing which migrator to use via
  TimestampMigrator.apply or IntegerMigrator.apply (jeremyevans)

* Add arbitrary_servers extension to allow the use of arbitrary servers/shards
  by providing a hash of options as the server (jeremyevans)

* Add server_block extension to scope database access inside the block to a
  specific default server/shard (jeremyevans)

* Respect :collate column option on MySQL (jeremyevans) (#445)

* Use Mysql2::Client::FOUND_ROWS to get accurate number of rows matched in the
  mysql2 adapter (jeremyevans)

* Use Mysql#info to get accurate number of rows matched in the mysql adapter

* Make mock adapter with specific SQL dialect use appropriate defaults for
  quoting identifiers (jeremyevans)

* Make list plugin automatically set position field value on creation if not
  already set (jeremyevans)

* Add Database#integer_booleans setting on SQLite to store booleans as
  integers (jeremyevans)

* Typecast columns stored as integers/floats in the SQLite adapter (jeremyevans)

* In the instance_hooks plugin, (before|after)_*_hook instance methods now
  return self (jeremyevans)

* Handle NaN, Infinity, and -Infinity floats on PostgreSQL (kf8a, jeremyevans)

* Support an :sslmode option when using the postgres adapter with the pg
  driver (jeremyevans)

* Add Database#create_schema and #drop_schema to the shared postgres adapter
  (tkellen, jeremyevans) (#440)

* Add Database#supports_savepoints_in_prepared_transactions?, false on MySQL
  >=5.5.12 (jeremyevans) (#437)

* Support an identifier output method in the mysql2 adapter (jeremyevans)

* Make foreign key creation work on MySQL with InnoDB engine without
  specifying :key option (jeremyevans)

* Allow disabling use of sudo with SUDO='' when running the rake
  install/uninstall tasks (jeremyevans) (#433)

Revision 1.12 / (download) - annotate - [select for diffs], Thu Feb 23 14:20:31 2012 UTC (11 years, 9 months ago) by taca
Branch: MAIN
Changes since 1.11: +4 -4 lines
Diff to previous 1.11 (colored)

Update databases/ruby-sequel package to 3.32.0.

=== 3.32.0 (2012-02-01)

* Make serialization_modification_detection plugin work correctly with
  new objects and after saving existing objects (jeremyevans) (#432)

* Make refreshes after model creation clear the deserialized values in
  the serialization plugin (jeremyevans)

* Add Dataset#update_ignore on MySQL, for using UPDATE IGNORE in
  queries (danielb2) (#429)

* Allow select_map/select_order_map to take both a column argument and
  a block (jeremyevans)

* Fix virtual row block handling in select_map/select_order_map if
  block returns an array (jeremyevans) (#428)

* Add Sequel.empty_array_handle_nulls setting, can be set to false for
  possible better performance on some databases (jeremyevans)

* Change exclude(:b=>[]) to not return rows where b is NULL (jeremyevans) (#427)

* Support ActiveModel 3.2 in the active_model plugin, by adding
  support for to_partial_path (jeremyevans)

* Fix metadata methods (e.g. tables) on Oracle when custom identifier
  input methods are used (jeremyevans)

* Fix Database#indexes on DB2 (jeremyevans)

* Make DateTime/Time columns with Sequel::CURRENT_TIMESTAMP default
  values use timestamp column on MySQL (jeremyevans)

* Wrap column default values in extra parens on SQLite, fixes some
  cases (jeremyevans)

* Make Database#indexes not include primary key indexes on Derby,
  HSQLDB, Oracle, and DB2 using the jdbc adapter (jeremyevans)

* Support Database#indexes in shared MSSQL adapter (jeremyevans)

* Support :include option when creating indexes on MSSQL, for storing
  column values in the index (crawlik) (#426)

* Make set_column_type not modify defaults and NULL/NOT NULL setting
  on MSSQL, H2, and SQLite (jeremyevans)

* Qualify identifiers when filtering/excluding by associations (jeremyevans)

* Make table_exists? better handle tables where you don't have
  permissions for all columns (jeremyevans) (#422)

* Using new association options, support associations based on columns
  that clash with ruby method names (jeremyevans) (#417)

* Add use_after_commit_rollback setting to models, can be turned off
  to allow model usage with prepared transactions (jeremyevans)

* Fix alter table emulation on SQLite when foreign keys reference the
  table being altered (jeremyevans)

* Fix progress shared adapter, broken since the dataset literalization
  refactoring (jeremyevans) (#414)

* Support :map and :to_hash prepared statement types (jeremyevans)

* Make Dataset#naked! work correctly (jeremyevans)

* Remove Dataset#paginate!, as it was broken (jeremyevans)

* Fix query extension to not break usage of #clone without arguments
  (jeremyevans) (#413)

=== 3.31.0 (2012-01-03)

* Dataset#from no longer handles :a__b__c___d as a.b.c AS d (jeremyevans)

* Support many_to_one associations with the same name as their column,
  using the :key_column option (jeremyevans)

* Add Model.def_column_alias for defining alias methods for columns

* Support :server option in Dataset#import and #multi_insert (jeremyevans)

* Respect existing RETURNING/OUTPUT clauses in #import/#multi_insert on
  PostgreSQL/MSSQL (jeremyevans)

* Support :return=>:primary_key option to Dataset#import and #multi_insert

* Correctly handle return value for Dataset#insert with column array and value
  array on PostgreSQL <8.2 (jeremyevans)

* Dataset#insert_multiple now returns an array of inserted primary keys
  (jeremyevans) (#408)

* Support RETURNING with DELETE and UPDATE on PostgreSQL 8.2+ (funny-falcon)

* Raise error if tables from two separate schema are detected when parsing the
  schema for a single table on PostgreSQL (jeremyevans)

* Handle clob types as string instead of blob on H2 (jeremyevans)

* Add database type support to the mock adapter, e.g. mock://postgres

* Allow creation of full text indexes on Microsoft SQL Server, but you need to
  provide a :key_index option (jeremyevans)

* Allow Dataset#full_text_search usage with prepared statements (jeremyevans)

* Make Dataset#exists use a PlaceholderLiteralString so it works with prepared
  statements (jeremyevans)

* Fix Dataset#empty? for datasets with offsets when offset support is emulated

* Add Dataset#group_rollup and #group_cube methods for GROUP BY ROLLUP and
  CUBE support (jeremyevans)

* Add support for custom serialization formats to the serialization plugin

* Support a :login_timeout option in the jdbc adapter (glebpom) (#406)

Revision 1.11 / (download) - annotate - [select for diffs], Thu Dec 15 15:01:22 2011 UTC (11 years, 11 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2011Q4-base, pkgsrc-2011Q4
Changes since 1.10: +4 -4 lines
Diff to previous 1.10 (colored)

Update ruby-sequel package to 3.30.0.

=== 3.30.0 (2011-12-01)

* Handle usage of on_duplicate_key_update in MySQL prepared statements (jeremyevans) (#404)

* Make after_commit and after_rollback respect :server option (jeremyevans) (#401)

* Respect :connect_timeout option in the postgres adapter when using pg (glebpom, jeremyevans) (#402)

* Make Dataset#destroy for model datasets respect dataset shard when using a transaction (jeremyevans)

* Make :server option to Model#save set the shard to use (jeremyevans)

* Move Model#set_server from the sharding plugin to the base plugin (jeremyevans)

* Add :graph_alias_base association option for setting base name to use for table aliases when eager graphing (jeremyevans)

* Make ILIKE work correctly on Microsoft SQL Server if database/column collation is case sensitive (jfirebaugh) (#398)

* When starting a new dataset graph, assume existing selection is the columns to select from the current table (jeremyevans)

* Allow specifying nanoseconds and offsets when converting a hash or array to a timestamp (jeremyevans, jfirebaugh) (#395)

* Improve performance when converting Java types to ruby types in the jdbc adapter (jeremyevans, jfirebaugh) (#395)

* Fix tinytds adapter if DB.identifier_output_method = nil (jeremyevans)

* Explicitly order by the row number column when emulating offsets (jfirebaugh) (#393)

* Fix Dataset#graph and #eager_graph modifying the receiver if the receiver is already graphed (jeremyevans) (#392)

* Change dataset literalization to an append-only-all-the-way-down design (jeremyevans)

Revision 1.10 / (download) - annotate - [select for diffs], Tue Dec 13 16:24:34 2011 UTC (11 years, 11 months ago) by taca
Branch: MAIN
Changes since 1.9: +4 -4 lines
Diff to previous 1.9 (colored)

Update ruby-sequel package to 3.29.0.

Changes are too many to write here, pelase refer CHANGELOG file.

Revision 1.9 / (download) - annotate - [select for diffs], Mon Sep 12 14:45:51 2011 UTC (12 years, 2 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2011Q3-base, pkgsrc-2011Q3
Changes since 1.8: +4 -4 lines
Diff to previous 1.8 (colored)

Update ruby-sequel pacakge to 3.27.0.

=== 3.27.0 (2011-09-01)

* Add support for native prepared statements to the tinytds adapter

* Add support for native prepared statements and stored procedures to the
  mysql2 adapter (jeremyevans)

* Support dropping primary key, foreign key, and unique constraints on MySQL
  via the drop_constraint :type option (jeremyevans)

* Add Sequel::SQLTime class for handling SQL time columns (jeremyevans)

* Typecast DateTime objects to Date for date columns (jeremyevans)

* When typecasting Date objects to timestamps, make the resulting objects
  always have no fractional date components (jeremyevans)

* Add Model.dataset_module for simplifying many def_dataset_method calls

* Make prepared_statements_safe plugin work on classes without datasets

* Make Dataset#hash work correctly when referencing SQL::Expression instances

* Handle allowed mass assignment methods correctly when including modules in
  classes or extending instances with modules (jeremyevans)

* Fix Model#hash to work correctly with composite primary keys and with no
  primary key (jeremyevans)

* Model#exists? now returns false without issuing a query for new model
  objects (jeremyevans)

Revision 1.8 / (download) - annotate - [select for diffs], Fri Aug 12 16:48:07 2011 UTC (12 years, 3 months ago) by taca
Branch: MAIN
Changes since 1.7: +4 -4 lines
Diff to previous 1.7 (colored)

Update databases/ruby-sequel package to 3.26.0.

=== 3.26.0 (2011-08-01)

* Fix bug in default connection pool if a disconnect error is raised and the
  disconnection_proc also raises an error (jeremyevans)
* Disallow eager loading via eager of many_*_many associations with
  :eager_graph option (jeremyevans)
* Major speedup in dataset creation (jeremyevans)
* Replace internal implementation of eager_graph with much faster version
* Don't treat strings with leading zeros as octal format in the default
  typecasting (jeremyevans)
* Fix literalization of Date, Time, and DateTime values on Microsoft Access
* Fix handling of nil values with the pure-Java version of nokogiri in the
  xml_serializer plugin (jeremyevans)
* Make identity_map plugin work with standard eager loading of many_to_many
  and many_through_many associations (jeremyevans)
* Make create_table! only attempt to drop the table if it already exists
* Remove custom table_exists? implementations in the oracle and postgres
  adapters (jeremyevans)
* Handle another type of disconnection in the postgres adapter (jeremyevans)
* Handle disconnections in the ado adapter and do postgres subadapter
* Recognize disconnections when issuing BEGIN/ROLLBACK/COMMIT statements
  (jeremyevans) (#368)

=== 3.25.0 (2011-07-01)

* Work with tiny_tds-0.4.5 in the tinytds adapter, older versions are no
  longer supported (jeremyevans)
* Make association_pks plugin typecast provided values to integer if the
  primary key column type is integer (jeremyevans)
* Model.set_dataset now accepts Identifier, QualifiedIdentifier, and
  AliasedExpression arguments (jeremyevans)
* Fix handling of nil values in bound variables and prepared statement and
  stored procedure arguments in the jdbc adapter (jeremyevans, wei)
* Allow treating Datasets as Expressions, e.g. DB[:table1].select(:column1)
  > DB[:table2].select(:column2) (jeremyevans)
* No longer use CASCADE by default when dropping tables on PostgreSQL
* Support :cascade option to #drop_table, #drop_view, #drop_column, and
  #drop_constraint for using CASCADE (jeremyevans)
* If validation error messages are LiteralStrings, don't add the column name
  to them in Errors#full_messages (jeremyevans)
* Fix bug loading plugins on 1.9 where ::ClassMethods, ::InstanceMethods, or
  ::DatasetMethods is defined (jeremyevans)
* Add Dataset#exclude_where and Dataset#exclude_having methods, so you can
  force use of having or where clause (jeremyevans)
* Allow Dataset#select_all to take table name arguments and select all
  columns from each given table (jeremyevans)
* Add Dataset#select_group method, for selecting and grouping on the same
  columns (jeremyevans)
* Allow Dataset#group and Dataset#group_and_count to accept a virtual row
  block (jeremyevans)

Revision 1.7 / (download) - annotate - [select for diffs], Fri Jun 17 14:13:50 2011 UTC (12 years, 5 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2011Q2-base, pkgsrc-2011Q2
Changes since 1.6: +4 -4 lines
Diff to previous 1.6 (colored)

Update ruby-sequel package to 3.24.1.

3.24.1 (2011-06-03)

* Ignore index creation errors if using create_table? with the IF NOT EXISTS syntax (jeremyevans) (362)

3.24.0 (2011-06-01)

* Add prepared_statements_association plugin, for using prepared statements by default for regular association loading (jeremyevans)
* Add prepared_statements_safe plugin, for making prepared statement use with models more safe (jeremyevans)
* Add prepared_statements_with_pk plugin, for using prepared statements for dataset lookups by primary key (jeremyevans)
* Fix bug in emulated prepared statement support not supporting nil or false as bound values (jeremyevans)
* Add Dataset#unbind for unbinding values from a dataset, for use with creating prepared statements (jeremyevans)
* Add prepared_statements plugin for using prepared statements for updates, inserts, deletes, and lookups by primary key (jeremyevans)
* Make Dataset#[] for model datasets consider a single integer argument as a lookup by primary key (jeremyevans)
* Add Dataset#with_pk for model datasets, for finding first record with matching primary key value (jeremyevans)
* Add defaults_setter plugin for setting default values when initializing model instances (jeremyevans)
* Add around hooks (e.g. around_save) to Sequel::Model (jeremyevans)
* Add Model#initialize_set private method to ease extension writing (jeremyevans)
* Only typecast bit fields to booleans on MSSQL, the MySQL bit type is a bitfield, not a boolean (jeremyevans)
* Set SQL_AUTO_IS_NULL=0 by default when connecting to MySQL via the swift and jdbc adapters (jeremyevans)
* Fix bug in multiple column IN/NOT IN emulation when a model dataset is used (jeremyevans)
* Add support for filtering and excluding by association datasets (jeremyevans)
* Fix literalization of boolean values in filters on SQLite and MSSQL (jeremyevans)
* Add support for filtering and excluding by multiple associations (jeremyevans)
* Add support for inverting some SQL::Constant instances such as TRUE, FALSE, NULL, and NOTNULL (jeremyevans)
* Add support for excluding by associations to model datasets (jeremyevans)
* The Sequel::Postgres.use_iso_date_format setting now only affects future Database objects (jeremyevans)
* Add Sequel::Postgres::PG_NAMED_TYPES hash for extensions to register type conversions for non-standard types (jeremyevans, pvh)
* Make create_table? use IF NOT EXISTS instead of using SELECT to determine existence, if supported (jeremyevans)
* Fix bug in association_pks plugin when associated table has a different primary key column name (jfirebaugh)
* Fix limiting rows when connecting to DB2 (semmons99)
* Exclude columns from tables in the INFORMATION_SCHEMA when parsing table schema on JDBC (jeremyevans)
* Fix limiting rows when connecting to Microsoft Access (jeremyevans)
* Add Database#views for getting an array of symbols of view names for the database (jeremyevans, christian.michon)
* Make Datbase#tables no longer include view names on MySQL (jeremyevans)
* Convert Java CLOB objects to ruby strings when using the JDBC JTDS subadapter (christian.michon)
* If Thread#kill is called on a thread with an open transaction, roll the transaction back on ruby 1.8 and rubinius (jeremyevans)
* Split informix adapter into shared/specific parts, add JDBC informix subadapter (jeremyevans)

3.23.0 (2011-05-02)

* Migrate issue tracker from Google Code to GitHub Issues (jeremyevans)
* Add support for filtering by associations to model datasets (jeremyevans)
* Don°«t call insert_select when saving a model that doesn°«t select all columns of the table (jeremyevans)
* Fix bug when using :select=>[] option for a many_to_many association (jeremyevans)
* Add a columns_introspection extension that attempts to skip database queries by introspecting selected columns (jeremyevans)
* When combining old integer migrations and new timestamp migrations, make sure old integer migrations are all applied first (jeremyevans)
* Support dynamic callbacks to customize regular association loading at query time (jeremyevans)
* Support cascading of eager loading with dynamic callbacks for both eager and eager_graph (jeremyevans)
* Make the xml_serializer plugin handle namespaced models by using __ instead of / as a separator (jeremyevans)
* Allow the :eager_grapher association proc to accept a single hash instead of 3 arguments (jfirebaugh)
* Support dynamic callbacks to customize eager loading at query time (jfirebaugh, jeremyevans)
* Fix bug in the identity_map plugin for many_to_one associations when the association reflection hadn°«t been filled in yet (funny-falcon)
* Add serialization_modification_detection plugin for detecting changes in serialized columns (jeremyevans) (333)

3.22.0 (2011-04-01)

* Add disconnect detection to tinytds adapter, though correct behavior may require an update to tiny_tds (cult_hero)
* Add Dataset/Database#mssql_unicode_strings accessor when connecting to MSSQL to control string literalization (semmons99, jeremyevans)
* Fix ODBC::Time instance handling in the odbc adapter (jeremyevans)
* Use Sequel.application_timezone when connecting in the oracle adapter to set the connection°«s session°«s timezone (jmthomas)
* In the ADO adapter, assume access to SQL Server if a :conn_string option is given that doesn°«t indicate Access/Jet ( (332)
* Use the correct class when loading instances for descendents of model classes that use single table inheritance (jeremyevans)
* Support for COLLATE in column definitions (jfirebaugh)
* Don°«t use a schema when creating a temporary table (jeremyevans)
* Make migrator work correctly when a default_schema is set (jeremyevans) (331)

Revision 1.6 / (download) - annotate - [select for diffs], Wed Mar 23 15:49:05 2011 UTC (12 years, 8 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2011Q1-base, pkgsrc-2011Q1
Changes since 1.5: +4 -4 lines
Diff to previous 1.5 (colored)

Update ruby-sequel package to 3.21.0.

=== 3.21.0 (2011-03-01)

* Make symbol splitting (:table__column___alias) work correctly for identifiers that are not in the \w character class (authorNari)
* Enable row locks in Oracle (authorNari)
* Prefer cover? over include? for validates_includes/validates_inclusion_of (jeremyevans)
* Make using NULL/NOT NULL, DEFAULT, and UNIQUE column options work correctly on H2 and possibly Oracle (jeremyevans)
* Make bin/sequel accept file arguments and work correctly when $stdin is not a tty (jeremyevans)
* Add support for -I and -r options to bin/sequel (jeremyevans)
* Sequel::Model.plugin can now be overridden just like the other Model methods (jeremyevans)
* Add tinytds adapter, the best way to connect to MSSQL from a C based ruby running on *nix (jeremyevans)
* Recognize bigint unsigned as a Bignum type in the schema dumper (gamespy-tech) (#327)
* Add Dataset#calc_found_rows for MySQL datasets (macks)
* Add association_autoreloading plugin for clearing association cache when foreign key value changes (jfirebaugh, jeremyevans)
* Fix join_table on MySQL ignoring the block (jfirebaugh)
* Transfer CTE WITH clauses in subselect to main query when joining on MSSQL (jfirebaugh)
* Make specs support both RSpec 1 and RSpec 2 (jeremyevans)
* Work with ruby-informix versions >= 0.7.3 in the informix adapter (jeremyevans) (#326)

=== 3.20.0 (2011-02-01)

* Allow a :partial option to Database#indexes on MySQL to include partial indexes (roland.swingler) (#324)
* Add a SQLite subadapter to the swift adapter, now that swift supports it (jeremyevans)
* Update swift adapter to support swift 0.8.1, older versions no longer supported (jeremyevans)
* Allow setting arbitrary JDBC properties in the jdbc adapter with the :jdbc_properties option (jeremyevans)
* Use a better error message if a validates_max_length validation is applied to a nil value (jeremyevans) (#322)
* Add some basic Microsoft Access support to the ado adapter, autoincrementing primary keys now work (jeremyevans)
* Make class_table_inheritance plugin handle subclass associations better (jeremyevans) (#320)

=== 3.19.0 (2011-01-03)

* Handle Date and DateTime types in prepared statements when using the jdbc adapter (jeremyevans)
* Handle Date, DateTime, Time, SQL::Blob, true, and false in prepared statements when using the SQLite adapter (jeremyevans)
* Use varbinary(max) instead of image for the generic blob type on MSSQL (jeremyevans)
* Close prepared statements when disconnecting when using SQLite (jeremyevans)
* Allow reflecting on validations in the validation_class_methods plugin (jeremyevans)
* Allow passing a primary key value to the add_* association method (gucki)
* When typecasting model column values, check the classes of the new and existing values (jeremyevans)
* Improve type translation performance in the postgres, mysql, and sqlite adapters by using methods instead of procs (jeremyevans)

=== 3.18.0 (2010-12-01)

* Allow the user to control how the connection pool deals with attempts to access shards that aren't configured (jeremyevans)
* Typecast columns when creating model objects from JSON in the json_serializer plugin (jeremyevans)
* When parsing the schema for a model that uses an aliased table, use the unaliased table name (jeremyevans)
* When emulating schema methods such as drop_column on SQLite, recreate applicable indexes on the recreated table (jeremyevans)
* Only remove hook pairs that have been run successfully in the instance_hooks plugin (jeremyevans)
* Add reversible migration support to the migration extension (jeremyevans)
* Add to_dot extension, for producing visualizations of Dataset abstract syntax trees with Graphviz (jeremyevans)
* Switch to using manual type translation in the SQLite adapter (jeremyevans)
* Support :read_timeout option in the native mysql adapter (tmm1)
* Support :connect_timeout option in the native mysql and mysql2 adapters (tmm1)

=== 3.17.0 (2010-11-05)

* Ensure that the optimistic locking plugin increments the lock column when using Model#modified! (jfirebaugh)
* Correctly handle nil values in the xml_serializer plugin, instead of converting them to empty strings (george.haff) (#313)
* Use a default wait_timeout that's allowed on Windows for the mysql and mysql2 adapters (jeremyevans) (#314)
* Add support for connecting to MySQL over SSL using the :sslca, :sslkey, and related options (jeremyevans)
* Fix Database#each_server when used with jdbc or do connection strings without separate :adapter option (jeremyevans) (#312)
* Much better support in the AS400 JDBC subadapter (bhauff)
* Allow cloning of many_through_many associations (gucki, jeremyevans)
* In the nested_attributes plugin, don't make unnecessary update calls to modify associated objects that are about to be deleted (jeremyevans, gucki)
* Allow Dataset#(add|set)_graph_aliases to accept as hash values symbols and arrays with a single element (jeremyevans)
* Add Databse#views and #view_exists? to the Oracle adapter (gpheruson)
* Add Database#sql_log_level for changing the level at which SQL queries are logged (jeremyevans)
* Remove unintended use of prepared statements in swift adapter (jeremyevans)
* Fix logging in the swift PostgreSQL subadapter (jeremyevans)

=== 3.16.0 (2010-10-01)

* Support composite foreign keys for associations in the identity_map plugin (harukizaemon, jeremyevans) (#310)
* Handle INTERSECT and EXCEPT on Microsoft SQL Server 2005+ (jfirebaugh)
* Add :replace option to Database#create_language in the postgresql adapter (jeremyevans)
* Make rcte_tree plugin work when not all columns are selected (jeremyevans)
* Add swift adapter (jeremyevans)
* Fix literalization of DateTime objects on 1.9 for databases that support fractional seconds (jeremyevans)

Revision 1.5 / (download) - annotate - [select for diffs], Fri Sep 10 04:45:46 2010 UTC (13 years, 2 months ago) by taca
Branch: MAIN
CVS Tags: pkgsrc-2010Q4-base, pkgsrc-2010Q4, pkgsrc-2010Q3-base, pkgsrc-2010Q3
Changes since 1.4: +4 -6 lines
Diff to previous 1.4 (colored)

Update databases/ruby-sequel 3.15.0.

* Use lang/ruby/ instead of misc/rubygems/

It is really renamed from ruby-sequel-core and changes are too may,
please refer CHANGELOG file.

Revision 1.4 / (download) - annotate - [select for diffs], Thu May 1 17:30:28 2008 UTC (15 years, 7 months ago) by jlam
Branch: MAIN
CVS Tags: pkgsrc-2010Q2-base, pkgsrc-2010Q2, pkgsrc-2010Q1-base, pkgsrc-2010Q1, pkgsrc-2009Q4-base, pkgsrc-2009Q4, pkgsrc-2009Q3-base, pkgsrc-2009Q3, pkgsrc-2009Q2-base, pkgsrc-2009Q2, pkgsrc-2009Q1-base, pkgsrc-2009Q1, pkgsrc-2008Q4-base, pkgsrc-2008Q4, pkgsrc-2008Q3-base, pkgsrc-2008Q3, pkgsrc-2008Q2-base, pkgsrc-2008Q2, cwrapper, cube-native-xorg-base, cube-native-xorg
Changes since 1.3: +4 -4 lines
Diff to previous 1.3 (colored)

Update databases/ruby-sequel to 1.5.1.  Changes from version 1.5.0 include:

* Fix Dataset#eager_graph when not all objects have associated objects.
  This changes how eager_graph handles missing records in associated
  tables (which occur because graph defaults to LEFT OUTER joins by

Revision 1.3 / (download) - annotate - [select for diffs], Tue Apr 29 18:39:02 2008 UTC (15 years, 7 months ago) by jlam
Branch: MAIN
Changes since 1.2: +4 -4 lines
Diff to previous 1.2 (colored)

Update databases/ruby-sequel to 1.5.0.  Changes from version 1.4.0 include:

* No longer depend on the assistance gem, merge the Inflector and
  Validations code

* Make the validation errors API compatible with Merb
* Add validates_uniqueness_of, for protecting against duplicate entries
  in the database

* Use reciprocal associations for all types of associations in the
  getter/setter/add_/remove_ methods
* Fix many_to_one associations to cache negative lookups
* Add eager loading of associations via new sequel_core object graphing
* Fix many_to_many associations with classes inside modules without an
  explicit join table

* Add the eager! and eager_graph! mutation methods to model datasets
* Add Model.def_dataset_method, for defining methods on the model that
  reference methods on the dataset
* Change Model#=== to always be false if the primary key is nil
* Add Model#hash, which should be unique for a given class and primary
  key (or values if primary key is nil)
* Make Model#reload clear any cached associations
* Fix Model#destroy so that it returns self, not the result of after_destroy
* Make Model#initialize, Model#set, and Model#update_with_params
  invulnerable to memory exhaustion
* Add Model.str_columns, which gives a list of columns as frozen strings

Revision 1.2 / (download) - annotate - [select for diffs], Sun Apr 13 06:56:30 2008 UTC (15 years, 7 months ago) by jlam
Branch: MAIN
Changes since 1.1: +6 -4 lines
Diff to previous 1.1 (colored)

Update databases/ruby-sequel to 1.4.0.  Changes from version 1.3 include:

+ Add patch-aa and patch-ab which are changes pulled from upstream to
  allow the creation of new records that don't have a primary key when
  the cache is on.

* Merge ``sequel_model'' into ``sequel''.
* Eager loading for all types of associations.
* One-to-many associations now populate the corresponding many-to-one
  instance variable (even when eagerly loaded).
* ActiveRecord style has_many :through associations are now supported
  via many_to_many.  many_to_many will no longer select the entire result
  set, just the columns of the associated table (and not the join table),
  so it works for both has_and_belongs_to_many (simple join table) and
  has_many :through (join table model) scenarios.

Revision / (download) - annotate - [select for diffs] (vendor branch), Fri Apr 4 15:16:06 2008 UTC (15 years, 8 months ago) by jlam
Branch: TNF
CVS Tags: pkgsrc-base
Changes since 1.1: +0 -0 lines
Diff to previous 1.1 (colored)

Initial import of ruby18-sequel-1.3 as databases/ruby-sequel.

Sequel is a database access toolkit for Ruby.  Sequel provides thread
safety, connection pooling, and a concise DSL for constructing queries
and table schemas.

Sequel makes it easy to deal with multiple records without having to
break your teeth on SQL.

Revision 1.1 / (download) - annotate - [select for diffs], Fri Apr 4 15:16:06 2008 UTC (15 years, 8 months ago) by jlam
Branch: MAIN

Initial revision

This form allows you to request diff's between any two revisions of a file. You may select a symbolic revision name using the selection box or you may type in a numeric name using the type-in text box.

CVSweb <>