0.17 2008-11-21
- Fey::SQL::Select->group_by() was not returning $self, so it could be
in the middle of a chain. Reported by Aristotle Pagaltzis. RT
#41062.
- Made (almost) all the methods that generate portions of a query
public, for example, $select->select_clause(), ->where_clause(),
etc. See the various Fey::SQL::* docs for details. Requested by
Dieter Pearcey.
0.16 2008-11-14
- Fey::SQL::Select did not allow outer joins using table
aliases. Reported by Aristotle Pagaltzis. RT #40856.
- Fey::SQL::Select->select will now accept another Fey::SQL::Select,
allowing subselects in the SELECT clause. Requested by Aristotle
Pagaltzis. RT #40858.
- Fey::Table->alias() and Fey::Column->alias() now allow a single
argument, an alias name. This is a shortcut for the most common use
case. Requested by Aristotle Pagaltzis.
- Added Fey::Table->aliased_column() and Fey::Table->aliased_columns()
methods. Requested by Aristotle Pagaltzis. RT #40857.
0.15 2008-10-28
- Added Fey::SQL::Select->select_clause_elements(), most for the
benefit of Fey::ORM.
0.14 2008-09-19
- Fey did not handle this join correctly:
$q->from( $s->table('User') );
$q->from( $s->table('User'), $s->table('UserGroup') );
It added a spurious comma so you got
FROM "User", JOIN ...
Reported by Aristotle Pagaltzis.
- The Fey::FK docs for the constructor did not name the parameters it
expects correctly. Reported by Aristotle Pagaltzis.
0.13 2008-09-19
- Including a table in a from clause failed. Now the Fey::Schema
object will accept a table alias as a parameter for the
foreign_keys_between_tables() method. When given an alias, it
returns a Fey::FK object which contains columns from that
alias. This faciliates creating SQL that joins on an alias. Reported
by Aristotle Pagaltzis.
0.12 2008-09-01
- Changes to work with the latest versions of Moose.
0.11 2008-08-26
- 0.10 was missing a dependency - MooseX::AttributeHelpers.
0.10 2008-08-25
- Optimizations to cache frequently used (and rarely changing) method
return values as attributes.
- As a result of the above, several methods that used to return arrays
now return array references. These are Fey::FK->column_pairs(),
Fey::Table->candidate_keys(), and Fey::Table->primary_key(), and
Fey::Literal::Function->args().
- Overloaded objects are now handled (mostly) correctly when used as
parameters in SQL statements. I say mostly because overloading in
Perl is so broken that it's not possible to deal with them 100%
correctly.
0.09 2008-07-31
- If a where clause had a subgroup after a comparison (like "WHERE x =
1 AND ( y = 2 )", it didn't properly add the needed "AND".
0.08 2008-07-02
- The fix for "SELECT statements with multiple joins generated bogus
SQL (a spurious comma separating JOIN clauses)" still generated
bogus SQL in some cases.
0.07 2008-06-26
- SELECT statements with multiple joins generated bogus SQL (a
spurious comma separating JOIN clauses).
0.06 2008-03-06
- Allow a Fey::Column object to have a column with precision but no
length, since Postgres allows this.
0.05 2008-02-20
- Some small tweaks to take advantage of recent Moose changes.
- Added Fey::FK->pretty_print().
- Some internal changes for the benefit of Fey::ORM.
0.04 2008-02-13
- Some SQL methods (order_by() and limit()) did not return the object
on which they were called, so they broke method chaining.
0.03 2008-02-06
- Renamed the distro from Fey-Core to just Fey.
- Added automatic use of placeholders to Fey::SQL. Now when you pass
literal values, the default is to convert them to placeholders. The
values can be retrieved from the new
bind_params(). method. Suggested by Daisuke Maki.
0.02 2008-02-05
- Moved Fey::Test to its own distro, and made it a build prereq.
0.01 2008-02-02
- First release upon an unsuspecting world.