| Age | Commit message (Collapse) | Author | Files | Lines |
|---|
|
=== 3.27.0 (2011-09-01)
* Add support for native prepared statements to the tinytds adapter
(jeremyevans)
* 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
(jeremyevans)
* Make prepared_statements_safe plugin work on classes without datasets
(jeremyevans)
* Make Dataset#hash work correctly when referencing SQL::Expression instances
(jeremyevans)
* 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)
|
|
=== 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
(jeremyevans)
* 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
(jeremyevans)
* 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
(jeremyevans)
* 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
(jeremyevans)
* 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
(jeremyevans)
* 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)
|
|
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 (damir.si) (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)
|
|
=== 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)
|
|
* Use lang/ruby/gem.mk instead of misc/rubygems/rubygem.mk.
* Add LICENSE.
It is really renamed from ruby-sequel-core and changes are too may,
please refer CHANGELOG file.
|
|
|
|
distribution include spec/rake/spectask.
|
|
|
|
* 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
design).
|
|
* 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
|
|
version 1.4.0.
|
|
+ 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.
|
|
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.
|
