summaryrefslogtreecommitdiff
path: root/databases
AgeCommit message (Collapse)AuthorFilesLines
2012-03-20Remove dependency to ruby-fast_gettext since it is indirectly depenededtaca1-2/+4
by ruby-gettext_i18n_rails. Bump PKGREVISION.
2012-03-18Remove ruby-activerecord, say good-by to Ruby on Rails 2.taca4-392/+0
2012-03-18Remove Ruby on Rails 2 pacakges:taca1-2/+1
databases/ruby-activerecord devel/ruby-activesupport mail/ruby-actionmailer www/ruby-actionpack www/ruby-activeresource www/ruby-rails
2012-03-18Remove ruby-acts-as-versioned02 package for Ruby on Rails 2.taca4-44/+0
2012-03-18Remove ruby-acts-as-versioned02.taca1-2/+1
2012-03-18Add and enable ruby-activerecord32.taca1-1/+2
2012-03-18Importing ruby-activerecord32 3.2.2.taca4-0/+185
## Rails 3.2.1 (January 26, 2012) ## * The threshold for auto EXPLAIN is ignored if there's no logger. *fxn* * Call `to_s` on the value passed to `table_name=`, in particular symbols are supported (regression). *Sergey Nartimov* * Fix possible race condition when two threads try to define attribute methods for the same class. *Jon Leighton* ## Rails 3.2.0 (January 20, 2012) ## * Added a `with_lock` method to ActiveRecord objects, which starts a transaction, locks the object (pessimistically) and yields to the block. The method takes one (optional) parameter and passes it to `lock!`. Before: class Order < ActiveRecord::Base def cancel! transaction do lock! # ... cancelling logic end end end After: class Order < ActiveRecord::Base def cancel! with_lock do # ... cancelling logic end end end *Olek Janiszewski* * 'on' and 'ON' boolean columns values are type casted to true *Santiago Pastorino* * Added ability to run migrations only for given scope, which allows to run migrations only from one engine (for example to revert changes from engine that you want to remove). Example: rake db:migrate SCOPE=blog *Piotr Sarnacki* * Migrations copied from engines are now scoped with engine's name, for example 01_create_posts.blog.rb. *Piotr Sarnacki* * Implements `AR::Base.silence_auto_explain`. This method allows the user to selectively disable automatic EXPLAINs within a block. *fxn* * Implements automatic EXPLAIN logging for slow queries. A new configuration parameter `config.active_record.auto_explain_threshold_in_seconds` determines what's to be considered a slow query. Setting that to `nil` disables this feature. Defaults are 0.5 in development mode, and `nil` in test and production modes. As of this writing there's support for SQLite, MySQL (mysql2 adapter), and PostgreSQL. *fxn* * Implemented ActiveRecord::Relation#pluck method Method returns Array of column value from table under ActiveRecord model Client.pluck(:id) *Bogdan Gusiev* * Automatic closure of connections in threads is deprecated. For example the following code is deprecated: Thread.new { Post.find(1) }.join It should be changed to close the database connection at the end of the thread: Thread.new { Post.find(1) Post.connection.close }.join Only people who spawn threads in their application code need to worry about this change. * Deprecated: * `set_table_name` * `set_inheritance_column` * `set_sequence_name` * `set_primary_key` * `set_locking_column` Use an assignment method instead. For example, instead of `set_table_name`, use `self.table_name=`: class Project < ActiveRecord::Base self.table_name = "project" end Or define your own `self.table_name` method: class Post < ActiveRecord::Base def self.table_name "special_" + super end end Post.table_name # => "special_posts" *Jon Leighton* * Generated association methods are created within a separate module to allow overriding and composition using `super`. For a class named `MyModel`, the module is named `MyModel::GeneratedFeatureMethods`. It is included into the model class immediately after the `generated_attributes_methods` module defined in ActiveModel, so association methods override attribute methods of the same name. *Josh Susser* * Implemented ActiveRecord::Relation#explain. *fxn* * Add ActiveRecord::Relation#uniq for generating unique queries. Before: Client.select('DISTINCT name') After: Client.select(:name).uniq This also allows you to revert the unqueness in a relation: Client.select(:name).uniq.uniq(false) *Jon Leighton* * Support index sort order in sqlite, mysql and postgres adapters. *Vlad Jebelev* * Allow the :class_name option for associations to take a symbol (:Client) in addition to a string ('Client'). This is to avoid confusing newbies, and to be consistent with the fact that other options like :foreign_key already allow a symbol or a string. *Jon Leighton* * In development mode the db:drop task also drops the test database. For symmetry with the db:create task. *Dmitriy Kiriyenko* * Added ActiveRecord::Base.store for declaring simple single-column key/value stores *DHH* class User < ActiveRecord::Base store :settings, accessors: [ :color, :homepage ] end u = User.new(color: 'black', homepage: '37signals.com') u.color # Accessor stored attribute u.settings[:country] = 'Denmark' # Any attribute, even if not specified with an accessor * MySQL: case-insensitive uniqueness validation avoids calling LOWER when the column already uses a case-insensitive collation. Fixes #561. *Joseph Palermo* * Transactional fixtures enlist all active database connections. You can test models on different connections without disabling transactional fixtures. *Jeremy Kemper* * Add first_or_create, first_or_create!, first_or_initialize methods to Active Record. This is a better approach over the old find_or_create_by dynamic methods because it's clearer which arguments are used to find the record and which are used to create it: User.where(:first_name => "Scarlett").first_or_create!(:last_name => "Johansson") *Andrés Mejía* * Fix nested attributes bug where _destroy parameter is taken into account during :reject_if => :all_blank (fixes #2937) *Aaron Christy* * Add ActiveSupport::Cache::NullStore for use in development and testing. *Brian Durand*
2012-03-18Update ruby-arel to 3.0.2.taca3-27/+14
* Tweak HOMEPAGE and COMMENT. Exact changes are unknown.
2012-03-18Add and enable ruby-arel22.taca1-1/+2
2012-03-18Importing ruby-arel22 verison 2.2.3 as databases/ruby-arel22.taca4-0/+162
2012-03-18Update ruby-activerecord31 to 3.1.4.taca2-7/+7
Tweak COMMENT. ## Rails 3.1.4 (unreleased) ## * Fix a custom primary key regression *GH 3987* *Jon Leighton* * Perf fix (second try): don't load records for `has many :dependent => :delete_all` *GH 3672* *Jon Leighton* * Fix accessing `proxy_association` method from an association extension where the calls are chained. *GH #3890* (E.g. `post.comments.where(bla).my_proxy_method`) *Jon Leighton* * Perf fix: MySQL primary key lookup was still slow for very large tables. *GH 3678* *Kenny J* * Perf fix: If a table has no primary key, don't repeatedly ask the database for it. *Julius de Bruijn*
2012-03-18Update ruby-activerecord3 to 3.0.12.taca2-7/+6
pkgsrc change: * Tweak COMMENT. No changes except version.
2012-03-17Update ruby-sequel package to 3.33.0.taca3-7/+16
=== 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 (jeremyevans) * 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) (#444) * 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)
2012-03-17Update ruby-do_sqlite3 package to 0.10.8.taca2-6/+6
## 0.10.8 2012-02-10 * Ruby 1.9.3 compatibility on Windows * Fix issue with sqlite3_load_extension
2012-03-17Update ruby-do_postgres package to 0.10.8.taca2-6/+6
Exacat changes are unknown.
2012-03-17Update ruby-do_mysql package to 0.10.8.taca2-6/+6
## 0.10.8 2012-02-10 * Ruby 1.9.3 compatibility on Windows
2012-03-17Update ruby-data_objects package to 0.10.8.taca2-6/+6
## 0.10.8 2012-02-10 * Ruby 1.9.3 compatibility on Windows * Don't display password in URI
2012-03-17Remove ruby-postgresql.taca1-2/+1
2012-03-17Remove ruby-postgresql.taca6-167/+0
There is postgresql.gem named 0.8.1 and its README.txt says: This is an old, deprecated version of the Ruby PostgreSQL driver that hasn't been maintained or supported since early 2008. You should install/require 'pg' instead. So, say good-by to databases/ruby-postgresql and use databases/ruby-pg.
2012-03-15Changes 2.4.9:adam2-6/+6
* ldapobject.ReconnectLDAPObject.reconnect() now does kind of an internal locking to pause other threads while reconnecting is pending. * Changes to bind- and startTLS-related operation methods of class ReconnectLDAPObject for more robustness * New constant ldap.OPT_NAMES_DICT contains mapping from integer to variable name for all option-related constants.
2012-03-15fix BUILDLINK_INCDIRS & BUILDLINK_LIBDIRS - thanks wizabs1-3/+3
2012-03-15iodbc 3.52.7nb2 needed for conflict free lifeabs1-2/+2
2012-03-15Also put libs in iodbc subdir, patch to ensure pkgconfigdir is not affectedabs10-18/+118
bump PKGREVISION. Test built soprano
2012-03-15Update CONFLICTS to iodbc<3.52.7nb1abs1-3/+3
2012-03-15Set --includedir to avoid conflict with unixodbc, adjust BUILDLINK_INCDIRSabs3-16/+17
2012-03-15Bump PKGREVISION from default python to 2.7.obache6-8/+12
2012-03-14Fixed building with PostgreSQL>=9, works with any 8.x and 9.x version now.fhajny3-3/+30
Bumpe PKGREVISION.
2012-03-14Add optional DTrace supportfhajny3-6/+27
2012-03-13Changes 2.4.30:adam27-243/+177
Fixed libldap socket polling for writes Fixed liblutil string modifications Fixed slapd crash when attrsOnly is true Fixed slapd syncrepl delete handling Fixed slapd-mdb slapadd with -q Fixed slapd-mdb slapadd with -w Fixed slapd-mdb slapindex with -q and -t Fixed slapo-pcache time-to-refesh handling Fixed slapo-syncprov loop detection Build Environment Fixed POSIX make support Fixed slapd-mdb build on POSIX Documentation Added option "-o" to ldap*(1) pages Fixed ldap*(1) page cleanup Fixed ldap_modify(3) prototypes
2012-03-12Avoid double definition of double on SunOS.fhajny2-1/+16
2012-03-12Use "GCC_REQD+=4.4" instead of a direct dependence on lang/gcc44.sbd1-9/+5
2012-03-11Add the correct version of the previosu patches.markd6-21/+21
2012-03-11Use MASTER_SITE_PGSQL from mk/fetch/sites.mk instead of having anotherwiz10-396/+12
outdated list of mirrors.
2012-03-10Fix build with gcc4.6markd6-1/+76
2012-03-09Fix build on a mix of GNU/Sun tools.fhajny2-1/+16
2012-03-09Bump PKGREVISION for python default version change to 2.7.wiz5-10/+10
py-* not affected, since it built different versions depending on the setting already.
2012-03-09Make sure GNU diff is available.fhajny1-1/+7
Fixes PR pkg/44828.
2012-03-09Only include the OpenSSL BL3 if mysql-client was built with the 'ssl' option.fhajny1-2/+8
2012-03-08Move the inclusion of openldap-server/options.mk to *before* krb5.bl3.mk.dholland1-2/+3
Otherwise, with non-native kerberos, bdb.buildlink3.mk is included by heimdal's bl3.mk before BDB_ACCEPTED is set, we get the wrong answer out, and the package fails to build. It's a good thing heimdal doesn't also need to set BDB_ACCEPTED I guess...
2012-03-07no need to propagate dependencies heredrochner1-4/+1
2012-03-06Recursive PKGREVISION bump for xulrunner, nss, and nspr.ryoon1-1/+2
2012-03-05Changes 8.4.11:adam3-7/+9
* Require execute permission on the trigger function for CREATE TRIGGER * Convert newlines to spaces in names written in pg_dump comments * Fix btree index corruption from insertions concurrent with vacuuming * Allow non-existent values for some settings in ALTER USER/DATABASE SET * Track the OID counter correctly during WAL replay, even when it wraps around * Fix regular expression back-references with * attached * Fix recently-introduced memory leak in processing of inet/cidr values * Avoid double close of file handle in syslogger on Windows * Fix I/O-conversion-related memory leaks in plpgsql * Improve pg_dump's handling of inherited table columns * Fix pg_restore's direct-to-database mode for INSERT-style table data * Fix error in contrib/intarray's int[] & int[] operator * Fix error detection in contrib/pgcrypto's encrypt_iv() and decrypt_iv() * Fix one-byte buffer overrun in contrib/test_parser * Use __sync_lock_test_and_set() for spinlocks on ARM, if available * Use -fexcess-precision=standard option when building with gcc versions that accept it * Allow use of threaded Python on FreeBSD
2012-03-05Changes 8.3.17:adam3-7/+8
* Require execute permission on the trigger function for CREATE TRIGGER * Convert newlines to spaces in names written in pg_dump comments * Fix btree index corruption from insertions concurrent with vacuuming * Allow non-existent values for some settings in ALTER USER/DATABASE SET * Track the OID counter correctly during WAL replay, even when it wraps around * Fix regular expression back-references with * attached * Fix recently-introduced memory leak in processing of inet/cidr values * Avoid double close of file handle in syslogger on Windows * Fix I/O-conversion-related memory leaks in plpgsql * Improve pg_dump's handling of inherited table columns * Fix pg_restore's direct-to-database mode for INSERT-style table data * Fix error in contrib/intarray's int[] & int[] operator * Fix error detection in contrib/pgcrypto's encrypt_iv() and decrypt_iv() * Fix one-byte buffer overrun in contrib/test_parser * Use __sync_lock_test_and_set() for spinlocks on ARM, if available * Use -fexcess-precision=standard option when building with gcc versions that accept it * Allow use of threaded Python on FreeBSD
2012-03-05Doesn't build with python24. (it appears that Py_ssize_t isn't defined)dholland1-1/+3
2012-03-05Add missing <fcntl.h>; may fix Solaris build.dholland2-5/+6
2012-03-03Changes:adam17-28/+59
* Fix btree index corruption from insertions concurrent with vacuuming * Recover from errors occurring during WAL replay of DROP TABLESPACE * Fix transient zeroing of shared buffers during WAL replay * Fix postmaster to attempt restart after a hot-standby crash * Fix corner case in SSI transaction cleanup * Update per-column permissions, not only per-table permissions, when changing table owner * Fix handling of data-modifying WITH subplans in READ COMMITTED rechecking * Fix for "could not find plan for CTE" failures * Fix unsupported node type error caused by COLLATE in an INSERT expression * Avoid crashing when we have problems deleting table files post-commit * Fix recently-introduced memory leak in processing of inet/cidr * Fix GIN cost estimation to handle column IN (...) index conditions * Fix I/O-conversion-related memory leaks in plpgsql * Teach pg_upgrade to handle renaming of plpython's shared library (affecting upgrades to 9.1)
2012-03-03Recursive bump for pcre-8.30* (shlib major change)wiz24-47/+48
2012-03-02Update ruby-arel package to 2.2.3.taca3-8/+9
Exacat changes aren't available but some bugfixes and support of bind parameters can be differentiated from sql literals.
2012-03-01+py-tokyocabinetgdt1-1/+2
2012-03-01Import py26-tokyocabinet-0.5 as databases/py-tokyocabinet.gdt4-0/+46
tokyocabinet aims to be a complete python wrapper for the ass-kicking Tokyo Cabinet database library by Mikio Hirabayashi (http://1978th.net/). While there are other wrappers out there none were found to be comprehensive enough. At present, the btree, hash and table APIs are available as hand-written C extensions. A similar effort is underway for the Tokyo Tyrant client API here: http://code.google.com/p/python-tokyotyrant-client/ Omissions, bugs, patches and feedback are greatly welcome. This package is written and maintained by Elisha Cook.