2004-07-03 Darren Duncan <perl@DarrenDuncan.net>
* Release 0.05.
* Updated external dependencies on Locale::KeyedText to v0.04 and on
SQL::SyntaxModel to v0.22. Note that the Makefile.pl in release 0.04
mistakenly said that Locale::KeyedText 0.04 was a prerequisite, but that
wasn't true until now.
* Updated SQLBuilder.pm (now v0.05) extensively such that about 15% of the
module was added or changed. The most extensive change concerns its POD
documentation, as now 100% of the module's methods are documented;
previously, less than half of them were. Added 1 new state maintenance
property plus its accessor method. A few methods were re-ordered and/or
re-named. Rebuilt the methods for making INSERT, UPDATE, DELETE statements
so they should now actually appear to work. Literals are now escaped
according to their type. Now all Perl switch statement options are
explicitely specified rather than the last one going in 'else'; this is
meant to prevent bugs in the future caused by the addition of new options
to SQL::SyntaxModel. build_dmanip_into_clause() was renamed to
build_query_into_clause() and merged into the generic query function list.
build_dmanip_stmt_table_or_view_name() was converted to
build_dmanip_src_schema_object_name(). build_expr_call_cview() was merged
into build_query_subquery(). Split build_dmanip_call_sproc() into itself
plus build_dmanip_[insert|update|delete]_stmt(); build_dmanip_set_clause()
was merged into the latter, and build_query_table_value_constr() was merged
into 'insert'. A few other small code updates. All methods now have
SQL-2003 section/page references, where applicable.
2004-06-21 Darren Duncan <perl@DarrenDuncan.net>
* Release 0.04.
* Updated external dependencies on SQL::SyntaxModel to v0.21.
* Updated SQLBuilder.pm (now v0.04) extensively such that about 30% of the
module was added or rewritten. Added 8 new SQLBuilder properties, with 6
being for general configuration, and 2 for short term state maintenance.
Renamed build_expr_identifier_element() to build_identifier_element() and
split build_expr_identifier_chain() into 4 more specialized
build_identifier_*() methods. Further added or updated SQL generation code
corresponding to these sections of "SQL-2003 Foundation": 6 "Scalar
expressions", 7 "Query expressions", 11 "Schema definition and
manipulation", 14 "Data manipulation". All of the above concerned code
changes. Some documentation changes, mostly in the method list; most
methods are still not documented. Following these changes, all of the
existing methods in SQLBuilder are now "implemented" (no more empty methods
with 'to be done' comments); however, many of them stand to be updated
later with new or corrected features. A few empty methods were removed.
2004-05-12 Darren Duncan <perl@DarrenDuncan.net>
* Release 0.03.
* Updated external dependencies on SQL::SyntaxModel to v0.18.
* Updated SQLBuilder.pm (now v0.03) extensively such that about 20% of the
module was added or rewritten. Added a base property and renamed another.
Added or updated SQL generation code corresponding to these sections of
"SQL-2003 Foundation": 7 "Query expressions", 11 "Schema definition and
manipulation", 12 "Access control", 14 "Data manipulation". All of the
above concerned code changes. Documentation was added/changed for the
new/altered property accessors only.
2004-05-01 Darren Duncan <perl@DarrenDuncan.net>
* Release 0.02.
* This is a "middle of development" release that includes a large number of
changes, some of which are only partially implemented. It exists largely
so that I can have a reliable backup for (and historical record of) the
last 3 weeks of in-progress work. It compiles, but there are large gaps.
* Updated external dependencies on SQL::SyntaxModel to v0.17.
* Updated all relevant documentation, including the NAME of Extensions.pod,
to specify that the modules herein are "reference implementations of
fundamental Rosetta features". That is, they are not meant to be the best
or only implementations, but rather just examples of how the deed is done.
* Updated documentation to say that the SQL-2003 standard is now the focus
of influence rather than SQL-1999 (or SQL-1992).
* Updated SQLBuilder.pm (now v0.02) extensively such that over 70% of the
module was added or rewritten; probably 98%+ of all changes for this
distribution release were in this module. Most existing properties and
methods were renamed and/or reordered. Added 2 base properties and 4 'data
types' sub-properties. The 'data types' sub-property defaults are now more
standard-centric rather than MySQL centric; said sub-properties can now
contain substitution variables. Implemented most of the SQL generation
code corresponding to these sections of "SQL-2003 Foundation": 5 "Lexical
elements", 6 "Scalar expressions", 7 "Query expressions", 8 "Predicates",
11 "Schema definition and manipulation". All of the above concerned code
changes. For documentation, there were no descriptions for individual
functions/methods in 0.01, but now there are for about a third of them.
* Updated Generic.pm (now v0.02) so that the "engine configuration option"
named "insen_ident" (case-insensitive identifiers) was renamed to
"delim_ident" (delimited identifiers); rewrote that option's description.
* Updated en.pm (now v0.02) to add a "ROS_G_RAW_SQLSTATE" message.
2004-04-10 Darren Duncan <perl@DarrenDuncan.net>
* Release 0.01.
* This is the first release of the Rosetta-Extensions distribution. This
distribution is meant to be temporary, collecting a number of related
modules during their infancy, as they tend to be updated in tandem; said
modules will get split into their own distributions later when they
stabilize. This release features the first versions of the modules
Rosetta::Engine::Generic and Rosetta::Utility::SQLBuilder (plus the
placeholder Rosetta::Extensions and the localization file
Rosetta::Engine::L::en). These modules are mostly code complete such that
you can connect to or disconnect from databases, as well as create or
remove tables and sequences in a database. None of this functionality was
tested, though (except for compiling); that is planned for release 0.03.
* For more background information, see the "Rosetta" distribution and
everything of mine that it references.