summaryrefslogtreecommitdiff
path: root/databases
AgeCommit message (Collapse)AuthorFilesLines
2008-04-23Include bsd.prefs.mk so that the options appended by the package Makefilejlam2-2/+6
take precedence.
2008-04-23Update to 1.53:wiz2-6/+6
1.53 Tue Apr 2 03:06:56 UTC 2008 * Fix mysql version check in DistinctQuery function * Fix order by outer column on Oracle * Improve tests 1.52 Tue Apr 1 00:48:56 UTC 2008 * Fix order by outer column on SQLite, mysql, adjust Pg. Add test that cover this. 1.51 Tue Jan 15 22:53:56 UTC 2008 * Fix CountAll method when paging is enabled and data is in memory already 1.50 Fri Nov 23 23:24:00 UTC 2007 * Oracle: Don't DISTINCT query when there is a group by clause * Fix a problem when we have more then two collections in a union and some of them are empty 1.49 Sat Jul 7 18:45:41 EDT 2007 * Fix a CPAN signature issue
2008-04-23Update to 0.36:wiz2-6/+6
0.36 Thu Dec 13 17:49:35 PST 2007 - Patch from ISHIGAKI@cpan.org to suppress unnecessary warnings about undefined local_options, thanks! - fix bug preventing adding new columns as primary keys under Pg 0.35 Mon Oct 29 18:58:36 PDT 2007 - Fix minor breakage (pretty_print) resulting from Jesse's changes. - Update mysql driver to handle BIGSERIAL columns - Update Column.pm, move all mysql and Pg-specific code to DBD driver callbacks - Update Table.pm, add local_options - Fix mysql NULL reverse-engineering and updating code 0.34 Sun Aug 19 10:08:51 PDT 2007 - More work on update schema from Slaven Rezic <srezic@cpan.org>, thanks! + implement table dropping (closes: CPAN#27936) + implement column dropping (closes: CPAN#27896) - Fix to quiet warnings from internal use of old API from Jesse Vincent <jesse+cpan@fsck.com>, thanks! (closes: CPAN#27958) - Make table dropping optional, not the default. 0.33 Thu Jun 28 18:46:15 PDT 2007 - Overhaul of index representation: indices (both normal and unique) now have names and are DBIx::DBSchema::Index objects - update_schema now handles indices! - Bump version numbers in Table.pm, Column.pm and DBD.pm - Pg reverse-engineering fix for column order in multi-column indices, to prevent needless drop/add of identical indices - mysql reverse-engineering patch from Brian Phillips <bphillips@cpan.org>, closes: CPAN#17582, thanks! - mysql NAME vs NAME_lc patch from Ralf Hack <ralf@beetlecraft.net>, closes: CPAN#16715, thanks! - mysql fix for additional column data from Chris Mungall <cjm@fruitfly.org>, closes: CPAN#20859, thanks! - SQLite SERIAL patch from IN SUK JOUNG <i.joung@gmail.com>, and fix for mis-application of said patch from Slaven Rezic <srezic@cpan.org>, thanks! - Update README wrt current CVS info and URL, closes: CPAN#27577 0.32 Wed Apr 18 15:02:25 PDT 2007 - increment the version numbers in Column.pm and Table.pm and the "use" statements accordingly - Error reporting for load constructor - Update documentation wrt supported databases and new update_schema stuff - Fixes for dropping nullability on old Pg (<= 7.2) - Fixes for adding nullability on old Pg (<= 7.3) - Throw a warning if pg_server_version is unavailable, assume >= 7.3 - fix POD error in DBSchema::DBD::SQLite that confused pod2man and prevented the documentation from being installed. Patch from Niko Tyni <ntyni@iki.fi>, thanks!
2008-04-23Add missing CONFLICTS with postgresql83-* packages. Reported by ASau` on irc.ghen1-1/+2
2008-04-22Restructure the following packages:jlam7-103/+110
databases/sqsh databases/sqsh-motif databases/sqsh-x11 The latter two are now just databases/sqsh built with a specific set of options. Changes include: + Add options.mk that supports three options: sqsh-motif Motif GUI sqsh-xaw Athena GUI sybase-openclient Use real Sybase Note that USE_SYBASE_OPENCLIENT is a legacy variable for the new global "sybase-openclient" option. + Remove Makefile.common and move all logic into sqsh/Makefile and sqsh/options.mk. + Remove section in patch-aa that tried to deal with termcap/curses issues for readline. That is now automatically taken care of in pkgsrc through termcap.buildlink3.mk, which is included here indirectly by readline/buildlink3.mk. + Add full DESTDIR support. + Bump the PKGREVISION for sqsh, sqsh-motif and sqsh-x11 to 5. All three packages now track and use the same PKGREVISION number.
2008-04-21update to 4.6.3drochner4-20/+34
changes: many fixes, improvements and API extensions, see http://www.jcea.es/programacion/pybsddb.htm pkgsrc note: 'egg' (setuptools) support was added upstream, but disabled in pkgsrc because it leads to nondeterministic results depending on OS version and installed pkgs
2008-04-14Add full DESTDIR support.jlam1-2/+5
2008-04-14Add patches missing from previous commit which updated ruby-sequel tojlam2-0/+38
version 1.4.0.
2008-04-14Update rrdtool to version 1.2.27.he5-82/+6
Changes: * doc/rrdcreate.pod, doc/rrdgraph.pod, doc/rrdgraph_graph.pod, doc/rrdgraph_rpn.pod, doc/rrdtutorial.pod: fixes for better web rendering * COPYRIGHT: added ZPL 2.1 to floss exception * src/rrd_graph.c, trunk/program/src/rrd_graph.c: fixed parsing of fontnames with embeded spaces * bindings/tcl/tclrrd.c, configure.ac, src/rrd_cgi.c: * fix fadvice and madvice inclusion ... again * fix rrdcgi warning * fix warnings in tcl bindings -- Peter Breitenlohner peb mppmu.mpg.de * src/rrd_graph.c: weekday and time are too tight * configure.ac: fixing the solaris build * netware/Makefile, src/rrd_update.c, win32/Makefile: updates for netware and mingw32 ... allows for crosscompilation * src/rrd_update.c: make update compile for mingw32 3.4.5 * bindings/perl-shared/Makefile.PL, configure.ac, src/rrd_tool.h, src/rrd_update.c: * improve portability of compile environment to netbsd and solaris
2008-04-13ruby-sequel-model has been removedjlam1-2/+1
2008-04-13+ Remove databases/ruby-sequel-model -- it has been merged intojlam4-61/+0
databases/ruby-sequel as of version 1.4.0. + Update dependencies for www/thoth and www/merb-sequel to reflect removal of ruby-sequel-model -- use ruby-sequel instead. Bump the PKGREVISION for these two packages.
2008-04-13Update databases/ruby-sequel to 1.4.0. Changes from version 1.3 include:jlam4-11/+48
+ 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.
2008-04-13Update databases/ruby-sequel-core to 1.4.0. Changes from version 1.3jlam4-9/+14
include fixes to the MySQL and PostgreSQL adapters.
2008-04-12Convert to use PLIST_VARS instead of manually passing "@comment "jlam9-61/+57
through PLIST_SUBST to the plist module.
2008-04-11Switch from PYTHON_VERSIONS_ACCEPTED= to PYTHON_VERSIONS_INCOMPATIBLE= (and ↵abs1-2/+2
enable 25)
2008-04-11rather than accepting python 24 23 & 22, mark 15 20 & 21 as incompatabs1-2/+2
2008-04-10Drop maintainership.obache1-2/+2
These packages was switched to gem version, I'm not in the area.
2008-04-07Add p5-Class-DBI-Pg.he1-1/+2
2008-04-07Import p5-Class-DBI-Pg version 0.06,he3-0/+25
which automates the setup of Class::DBI for Postgres.
2008-04-06update p5-Rose-DB-Object to 0.768abs2-7/+7
0.768 (02.25.2008) - John Siracusa <siracusa@gmail.com> * Changed mailing list and wiki URLs. * Fixed the "warn" overflow mode for character columns to carp instead of croaking. (Reported by John Ingram) * Refined workaround for http://rt.cpan.org//Ticket/Display.html?id=33193 to apply only to versions that exhibited this bug. * Added the forget_related() helper method to the "all" export tag. 0.767 (02.15.2008) - John Siracusa <siracusa@gmail.com> * Added the forget_related() helper method. * Enhanced and documented the long-dormant "hints" Manager parameter. * Added a work-around for a DBD::Pg 2.0.0 array/bind_col() bug: http://rt.cpan.org//Ticket/Display.html?id=33193 * Improved the column method handling for array-reference values that may be fetched from array columns by DBD::Pg 2.0.0. * Fixed a bug in the test suite that caused some Postgres tests to fail if the "chkpass" column type was not installed. (Reported by Randal Schwartz) 0.7665 (02.08.2008) - John Siracusa <siracusa@gmail.com> * Fixed a bug that prevented the convention manager's auto_table_name() method from honoring the tables_are_singular() attribute value. (Reported by Ben Tilly) * The new, more correct behavior of Rose::DB 0.739's array column value parsing and formatting revealed a bug in QueryBuilder's handling of "(any|all)_in_array" conditions involving empty list arguments. This is now fixed. 0.7664 (02.06.2008) - John Siracusa <siracusa@gmail.com> * Fixed a bug that caused boolean columns to be incorrectly marked as modified. (Reported by Grzegorz Nosek) * Added sql_qualify_column_names_on_load() Metadata method to help support Postgres functions that can masquerade as columns if they're prefixed by the table name. (Suggested by Grzegorz Nosek) 0.7663 (02.04.2008) - John Siracusa <siracusa@gmail.com> * Fixed a bug that caused delete_on_save method creation for foreign keys to fail in some circumstances. (Reported by Justin Ellison) * Fixed a bug that prevented Perl code from being emitted for non-set columns with check_in attributes. (Reported by Sam Tregar) * Pushed cache control methods down into Rose::DB::Object::Cached in preparation for more caching subclasses. * The clear_object_cache() method now correctly clears load timestamps as well. (Patch by Justin Ellison) 0.7662 (01.30.2008) - John Siracusa <siracusa@gmail.com> * Fixed copy-and-paste-o in Rose::DB::Object::Cached code. 0.7661 (01.29.2008) - John Siracusa <siracusa@gmail.com> * Fixed method clash detection in Rose::DB::Object::Manager. * Streamlined caching implementation in Rose::DB::Object::Cached. 0.766 (12.13.2007) - John Siracusa <siracusa@gmail.com> * Added the unique_key_by_name() metadata method. * Added the ability to do unrestricted joins in some circumstances. * Added the remember_all() class method to Rose::DB::Object::Cached. * Added the undef_overrides_default column attribute. * The key_column() method in the ForeignKey class now works correctly. (Patch by Christopher Masto) * Further synced datetime and timestamp method-maker code. * Added a test suite exclusion for DBD::SQLite 1.14, which still suffers from this bug: http://rt.cpan.org/Public/Bug/Display.html?id=21472 * Improved detection of fatal errors during class setup. * Added a "gotchas" section to the Loader documentation. * Fixed propagation of db objects in update and delete Manager methods. * Fixed a bug that caused some cached SQL to persist incorrectly after inheritance. (Patch by Daniel Koch) * Fiddled with not_found() detection. (Changes suggested by Philip Dye) * Made one-to-one relationships (attempt to) work even when uniqueness is not apparent in the metadata. * The Loader no longer chokes on SQLite columns that use the current_timestamp keyword. (Reported by George Hartzell) * Setting undef integer attributes to zero is now correctly detected as a modification. 0.765 (07.21.2007) - John Siracusa <siracusa@gmail.com> * Added a value_type attribute to SET columns. * Added a normalize_get_objects_args() utility method to make custom Manager methods less cumbersome to implement. * Setting a BigInt column to undef no longer sets it to zero. (Reported by Jeffrey Horn) * Corrected error propagation in many-to-many "find" methods when bad arguments are passed. (Reported by Michael Reece) * Added "use strict" the output of perl_manager_class(). * Restored default use of table aliases in Manager queries. The new table_aliases parameter can be used to alter the behavior. * Added support for literal sort_by parameters using scalar references. * Added is/is_not comparison operators to QueryBuilder. (Suggested by Jonathan Vanasco) * Scalar references appearing in the select => ... list in Manager calls are now passed through unmodified. * Existing map records are now correctly checked for when adding items through a many-to-many relationship. (Reported by Drew Taylor) * Using a nonexistent column name in a primary or unique key is now a fatal error. (Reported by Philip Dye) * Multi-columns "select count(distinct ...)" queries now fall back to count(*) on a subselect in databases that do not support calling count on multi-argument distinct clauses. (Reported by Derek Watson) * The auto-init system will now skip Postgres functional indexes when extracting unique keys. (Reported by Jonathan Vanasco) * Fixed a bug that caused inner joins to be used inappropriately in certain cases with many-to-many relationships or when nested joins are disabled. * Fixed a bug that caused the auto-init system to fold multiple foreign keys that reference the same remote key into a single multi-column foreign key. (Reported by Marlon Bailey) * Fixed a Manager bug that caused count queries to use incorrect table aliases when passed empty with_objects or require_objects array reference values. (Reported by Denis Moskowitz) * Fixed a bug that prevented relationship and foreign key names from being resolved when used in nested query parameters. * Relationship count methods no longer die when the count is zero. (Reported by Derek Watson) * Setting enum fields to undef now works correctly. (Reported by Ovid) * Columns with custom DBI bind attributes are now updated correctly. (Reported by Derek Watson) * Epoch columns with zero (0) default values now work correctly. (Reported by Peter Karman) * Setting boolean columns to null (undef) now works correctly. (Reported by Derek Watson) * Fixed a bug that caused literal query parameters with bind arguments to become corrupted after their first use. * Changed the way classes are registered in order to fix a Loader bug that caused cross-database foreign keys to be erroneously created when tables with the same names exists in two different databases. (Reported by Adrian Howard) * Deleting one-to-one related objects on save now works correctly. (Reported by Ovid) * The "find" method for many-to-many relationships now propagates custom Manager arguments correctly. (Patch by Michael Reece) * The use_key parameter to load() now dies if an invalid key is passed. (Reported by Jonathan Vanasco)
2008-04-06Update p5-Rose-DB to 0.741:abs2-6/+6
0.741 (02.25.2008) - John Siracusa <siracusa@gmail.com> * Changed mailing list URLs. 0.740 (02.15.2008) - John Siracusa <siracusa@gmail.com> * Added support for Rose::DB::Object 0.767's new hints features. 0.739 (02.08.2008) - John Siracusa <siracusa@gmail.com> * Caching of db objects during mod_perl server start-up is now turned off by default, with new API to turn it back on and do the necessary pre-fork clean-up that this entails. This change solved a segmentation fault problem triggered in DBD::Informix when database handles created in the parent were not properly disconnected prior to the first fork of the apache process. 0.738 (02.06.2008) - John Siracusa <siracusa@gmail.com> * The Informix INT8 column type is now detected and mapped to "bigint" on behalf of Rose::DB::Object. * Fixed a bug that prevented format_array() and parse_array() from correctly handling arrays containing undef or NULL, respectively. (Reported by Derek Watson) 0.737 (12.13.2007) - John Siracusa <siracusa@gmail.com> * Altered the behavior of connect() and disconnect() to account for the possibility that dbi_connect() may return a DBI $dbh that is already connected and has already been initialized. * Added optional (on by default) coercion of column type metadata from (big)int auto-increment to (big)serial for MySQL and SQLite. * Added support for the current_timestamp keyword to SQLite. * Added a dozen or so new MySQL connection attributes that must be inlined into the DSN rather than passed as connect() options. 0.736 (11.13.2007) - John Siracusa <siracusa@gmail.com> * Added new_or_cached() method and associated caching framework. * Added dbi_connect() method. (Patch by Peter Karman) * Removed mistakenly checked in breakpoint. 0.735 (07.21.2007) - John Siracusa <siracusa@gmail.com> * Improved parsing of SET values. * Fixed the test suite's detection of the broken DBD::SQLite 1.13.
2008-04-05Changes 8.2.7:adam12-36/+30
* Fix character string comparison for Windows locales that consider different character combinations as equal * Repair potential deadlock between concurrent "VACUUM FULL" operations on different system catalogs * Fix longstanding "LISTEN"/"NOTIFY" race condition * Disallow "LISTEN" and "UNLISTEN" within a prepared transaction * Disallow dropping a temporary table within a prepared transaction * Fix rare crash when an error occurs during a query using a hash index * Fix memory leaks in certain usages of set-returning functions * Fix input of datetime values for February 29 in years BC * Fix "unrecognized node type" error in some variants of "ALTER OWNER" * Ensure pg_stat_activity.waiting flag is cleared when a lock wait is aborted * Fix handling of process permissions on Windows Vista * More...
2008-04-05Changes 8.3.1:adam6-22/+24
* Fix character string comparison for Windows locales that consider different character combinations as equal * Repair corner-case bugs in "VACUUM FULL" * Fix misbehavior of foreign key checks involving character or bit columns * Avoid needless deadlock failures in no-op foreign-key checks * Fix possible core dump when re-planning a prepared query * Fix possible failure when re-planning a query that calls an SPI-using function * Fix failure in row-wise comparisons involving columns of different datatypes * Fix longstanding "LISTEN"/"NOTIFY" race condition * Disallow "LISTEN" and "UNLISTEN" within a prepared transaction * Disallow dropping a temporary table within a prepared transaction * Fix rare crash when an error occurs during a query using a hash index * Fix incorrect comparison of tsquery values * Fix incorrect behavior of LIKE with non-ASCII characters in single-byte encodings * Disable xmlvalidate
2008-04-04Add and enable new ruby-* packages.jlam1-1/+9
2008-04-04Install as a gem using the pkgsrc rubygem.mk framework instead ofjlam8-265/+389
directly into site_ruby.
2008-04-04Initial import of ruby18-sequel-model-0.5.0.2 asjlam4-0/+61
databases/ruby-sequel-model. 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.
2008-04-04Initial import of ruby18-sequel-core-1.3 as databases/ruby-sequel-core.jlam4-0/+98
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.
2008-04-04Initial import of ruby18-sequel-1.3 as databases/ruby-sequel.jlam4-0/+36
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.
2008-04-04Update ruby-postgresql to version 0.7.9.2008.01.28. Changes fromjlam3-57/+32
version 0.7.1 include: + Install as a Ruby gem. - Aliases to make it easier for ActiveRecord to support both ruby-pg (the successor to ruby-postgres) and ruby-postgres. - Fix connections to PostgreSQL>8.2.
2008-04-04Initial import of ruby18-postgres-pr-0.4.0 as databases/ruby-postgres-pr.jlam4-0/+48
This library is a pure Ruby implementation of a PostgreSQL adapter.
2008-04-04Initial import of ruby18-odbc-0.9995 as databases/ruby-odbc.jlam6-0/+114
This package contains a Ruby extension for accessing ODBC data sources.
2008-04-04Initial import of ruby18-datamapper-0.3.0 as databases/ruby-datamapper.jlam5-0/+251
DataMapper is a Object Relational Mapper written in Ruby. The goal is to create an ORM which is fast, thread-safe and feature-rich with ActiveRecord-compatibility.
2008-04-04Initial import of ruby18-acts-as-versioned-0.2.3 asjlam4-0/+48
databases/ruby-acts-as-versioned. This library adds simple versioning to an ActiveRecord module.
2008-04-04Initial import of ruby18-activerecord-odbc-1.4 asjlam4-0/+118
databases/ruby-activerecord-odbc. Data adapter for ODBC-accessible databases such as Oracle, Informix, Ingres, OpenLink Virtuoso, SQL Server, Sybase, MySQL, PostgreSQL, DB2, Firebird, Progress, and others, providing consistent behaviour to ActiveRecord.
2008-04-03No idea what __os_clock is, but replace it with portable gettimeofdayjoerg4-7/+67
usage. Add DESTDIR support. Bump revision.
2008-04-01Fixes DESTDIR installation.obache1-2/+2
2008-04-01Update "phpmyadmin" package to version 2.11.5.1.tron2-6/+6
The new version fixes a credentials disclosure on shared hosts via session data reported in security announcement PMASA-2008-2.
2008-04-01Update nss_ldap package to 260 based on PR pkg/38346 from Taku YASUI.taca5-51/+68
This update includes security fix for CVE-2007-5794. Changes from 240 is too much to list here. See ChangeLog, please.
2008-03-26pkglint cleanup.wiz3-10/+14
2008-03-26Only accept mysql-4.1 again.wiz1-2/+2
2008-03-26Re-add mysql4 packages.wiz46-1/+2506
Andreas Hallmann graciously agreed to maintain them.
2008-03-26Update HOMEPAGE. Update MASTER_SITES, but comment it out, since it doeswiz1-4/+4
not provide the old distfile. Accept mysql-5.0 (untested, but 4.1 is removed).
2008-03-25Remove mysql4 (4.1 branch) packages.wiz46-2506/+1
They have security problems and are not maintained. Removal was announced on pkgsrc-users on March 13.
2008-03-24Configure PostgreSQL client with --enable-thread-safety on NetBSD 4.0 andrmind1-2/+3
newer versions, as done in other versions of PostgreSQL packages. This gives a performance improvement on client-side, especially on NetBSD -current.
2008-03-17Add dependency on p5-version, which appears to be a new requirement.dsainty1-2/+4
Bump PKGREVISION, because the package will gladly build and install without p5-version, it just won't actually work unless p5-version is available both at build time and at run time.
2008-03-13Support user-destdir installationjlam1-1/+3
2008-03-13Remove PostgreSQL 8.0.joerg48-3464/+1
2008-03-13Make PostgreSQL 8.2 the default version. Bump all packages using it.joerg16-26/+32
Remove PostgreSQL 8.0 as choice.
2008-03-13Kill pgadmin3, it has been marked broken for ages.joerg6-1298/+0
2008-03-13Mark the main postgresql8[0-3] packages as meta packages.joerg4-36/+8
This avoids the problems in PR 34914.