./databases/ruby-sequel, Model classes for the Sequel Database Toolkit

[ CVSweb ] [ Homepage ] [ RSS ] [ Required by ] [ Add to tracker ]

Branch: CURRENT, Version: 5.12.0, Package name: ruby24-sequel-5.12.0, Maintainer: pkgsrc-users

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.

This package contains model classes for Sequel that allow it to be used
as an object-relational mapping (ORM).

Required to run:

Required to build:

Master sites:

SHA1: 170b9dc197e9e65c59c484e0e9321ef158d7a87e
RMD160: 609269092029d87ce68bfdae0ee03a3410aded41
Filesize: 1189.5 KB

Version history: (Expand)

CVS history: (Expand)

   2018-09-10 17:22:27 by Takahiro Kambe | Files touched by this commit (3) | Package updated
Log message:
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 \ 

* 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 \ 

* 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 \ 

* 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 \ 

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

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

* Make SQLTime.parse respect SQLTime.date and Sequel.application_timezone \ 

* 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)
   2018-06-06 06:44:51 by Takahiro Kambe | Files touched by this commit (3) | Package updated
Log message:
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 BigDecimal.new() to BigDecimal(), since the former is deprecated \ 

* 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)
   2018-05-05 16:19:58 by Takahiro Kambe | Files touched by this commit (3) | Package updated
Log message:
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 \ 

* 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 \ 

* 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 \ 

* 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 \ 
   2018-03-09 15:15:23 by Takahiro Kambe | Files touched by this commit (3) | Package updated
Log message:
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 \ 

* 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)
   2018-02-25 16:22:31 by Takahiro Kambe | Files touched by this commit (3) | Package updated
Log message:
letsencrypt.org: 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 \ 

* 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 \ 

* Make Dataset#to_json in json_serializer work with eager_graphed datasets \ 

* 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)
   2017-12-09 03:26:16 by Takahiro Kambe | Files touched by this commit (3) | Package updated
Log message:
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 \ 

* 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 \ 

* 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+ \ 

* 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 \ 
   2017-10-31 16:53:05 by Takahiro Kambe | Files touched by this commit (3) | Package updated
Log message:
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
   2017-09-02 16:13:11 by Takahiro Kambe | Files touched by this commit (3) | Package updated
Log message:
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