This release is the first step in the major refactoring of Tangram, which is API-backwards compatible. The differences between 2.09 and 2.10 are limited to namespace re-organisation. The test suite still succeeds unmodified, but has been tweaked to suppress warnings that deprecated modules are being used.
Sync release with 2.09. svk this time made this extremely painful, but we must forgive it because after all trying to support distributed source management tool atop of a synchronised versioning filesystem is pushing shit uphill.
Sync release with 2.08_06. svk made this far, far, too easy.
Renamed lots of modules to a grand new layout scheme.
Various classes, such as Tangram::Scalar, Tangram::Set, etc, are now called Tangram::Type::Scalar, Tangram::Type::Coll::Set, etc.
Tangram::Scalar
Tangram::Set
However, so long as you use Tangram::Core, use Tangram or use Tangram::Compat before any of these old names are used, then @INC magic should be able to catch the inclusion and load the correct module instead.
use Tangram::Core
use Tangram
use Tangram::Compat
@INC
Added new use Tangram import arguments :core and :compat_quiet. to be documented.
:core
:compat_quiet
Disable some tests on MySQL, that try to do things far too difficult for its little brain.
Suppress a warning in the test suite.
Test suite changes: add a test for weakref, fix bad prefetch test that was causing false negatives.
Make Scalar::Util the hard dependency that it is.
Fix the default get_id function debug output, related to the test for weakref. Also fix a bug in get_id that caused bizarre erratic behaviour in the scariest of circumstances.
get_id
Disabled nested join tests on SQLite.
Previous aggregation function change broke $storage->count($filter). Fixed.
$storage->count($filter)
Fixed outer joins again. They've even documented now! :D See "select" in Tangram::Storage.
:D
Fix Makefile.PL so as not to deliver Changes.pod.
A very nasty but also obscure bug affecting horizontal mapping and polymorphic retrieval (or aggregation) was reported by Alex.
The fix for it has made remote expressions always include filtering (via WHERE) on the type column as well as the ID column in most queries. This should not affect the result of queries; it is just passing on an assertion in the code base through to the database back-end. The times it will affect results are when your currently active schema does not match the one used to create the database and you were previously relying on side-effects.
Examples of the query differences will follow here before the 2.09 release.
This version has broken outer joins; to be fixed in the next release.
Also, this Changes.pod seems to being delivered to some random place in your @INC; sorry about that, the next release will exclude it via the appropriate ExtUtils::MakeMaker voodoo.
Make Makefile.PL output display modules that failed, rather than letting ExtUtils::MakeMaker do it for it.
ExtUtils::MakeMaker
Make Data::Lazy 0.6 a "hard" requirement in the Makefile.PL. This is still slightly problematic as only version 0.5 will be installed via the CPAN shell.
Support direct use of SQL in order clauses via order => [ 'SQL' ] (see "select" in Tangram::Storage)
order => [ 'SQL' ]
Support the SQLite 2 found in Ubuntu Hoary's libdbd-sqlite-perl package, which uses a connection string of sqlite2.
libdbd-sqlite-perl
sqlite2
Fix Data::Lazy dependency version number
Allow one-column Tangram::Ref
add $storage->make_oid() (See "make_oid" in Tangram::Storage)
$storage->make_oid()
Various documentation fixes from Andres Kievsky
Make test suite fail gracefully (skip all) if disabled
Remove redundant confusing copyright messages; the whole work is copyrighted, such notices should either be complete or absent IMHO.
Fix link to Tangram site and mailing list
Merge in a whole lotta Oracle fixes
This release was 2.07_07 with a couple of minor bug fixes.
2.07_07
Tangram::Dump now checks (via $storage->id_maybe_insert()) whether objects that it is saving should be inserted to the DB first, which allows the practice illustrated by the t/musicstore/ test suite to work.
$storage->id_maybe_insert()
added support for multiple test suites, each with their own schema, to end the ballooning schema madness that was affecting the springfield test suite.
reworked the way the DBMS date formatting worked again, adding Tangram::CookedDateTime
added support for Time::Piece and DateTime.
much work on database portability. The Tangram::Pg back-end now works very well, and I have also ported to SQLite (see Tangram::SQLite).
much more documentation, including Tangram::Intro
reworked the test suite to have multiple sections
new test section for Object Persistathon (t/musicstore/ schema)
Support for SQL sequences. See Tangram::Schema.
lots of changes. full list to follow once I get the time to look at the revision history :-}
Various POD modifications, including the main Tangram page, the addition of the stub Tangram::Complicity and the removal of bogus Tangram::Dialect
Tangram::Dialect
Enhanced TRACE messages
Added support for Oracle via Tangram::Oracle
Added support for cursors that select no objects (just retrieve extra columns, eg for aggregate selects)
`Fixed' t/datetime.t so that it doesn't do PostgreSQL/MySQL specific tests unless it is running on those databases
Tangram::Storage and Tangram::Relational::Engine now hold a handle to the Tangram::Relational object that created them, allowing for various DBMS dependant hooks (used to rewrite column types, format dates, etc)
Extra sanity checking in the core
The id_col feature in Tangram::Schema now actually works :-). Previously, there were many places where .id was hard-coded.
.id
Added ->in() method, a Tangram::Expr object that allows direct use of the SQL IN () construct, rather than just via includes_or(), or with collections using joins.
->in()
IN ()
includes_or()
Tangram::DMDateTime now expects database to understand the ISO-8601 date format, but the MySQL driver has been enhanced to convert ISO-8601 to MySQL format.
New method Tangram::Storage::unload_all (see "unload_all" in Tangram::Storage)
Tangram::Storage::unload_all
Added Tangram::IDBIF to combine multiple object fields into one perl_dump style field (including a "catch-all" facility) Test suite for this isn't complete yet.
Most other changes from Kurt Stephens ks.perl@kurtstephens.com, with many thanks:
Do not $self->{db}->disconnect in Tangram::Storage::disconnect() and ::DESTROY(), if $self->{db} eq $opts->{dbh} in Tangram::Storage->connect($schema, $cs, $user, $pw, { 'dbh' => ... } ); See $self->{db_owned}.
$self->{db}->disconnect
Tangram::Storage::disconnect()
::DESTROY()
$self->{db} eq $opts->{dbh}
Tangram::Storage->connect($schema, $cs, $user, $pw, { 'dbh' => ... } )
$self->{db_owned}
Handle objects that lazily initialize Tangram::AbstractSet Set::Object fields. See UMMF.
Added Tangram::IntrRef ("Intrusive Ref") for 1-to-1 bi-directional Association navigation using only one column in one table. Derived from Tangram::IntrSet. I need help with this one. :)
Added @sums = $storage->sum([ $expr1, $expr2 ], ...) support.
@sums = $storage->sum([ $expr1, $expr2 ], ...)
Added support for reused tables for mapping both sides of many-to-many UML Associations to the same table with Tangram::Set and Tangram::Array. See UMMF's example/ex1.
Added support for timestamping all tables through $schema->{sql}{timestamp_all_tables}. See "Global Properties" in Tangram::Schema.
$schema->{sql}{timestamp_all_tables}
Prevent additional records being inserted to the Tangram control table on ->redeploy.
->redeploy
Added support for GROUP BY in Tangram::Cursor.
GROUP BY
Added COUNT($remote) and SUM($filter_expr) support.
COUNT($remote)
SUM($filter_expr)
Editorial release changes:
Started using _NN version style, so CPAN marks it as a development release
_NN
added brief test suite for aggregate functions
Tangram::IntrHash prefetch test added
Documentation enhancements
Tangram::Dump class to `fix' persistent references in data structures prior to insertion, so that :
Tangram::PerlDump now can contain persistent objects safely
and hey, why not write a Tangram::Storable
and a Tangram::YAML (not working, waiting for a CPAN bug to be fixed)
Tangram::IntrHash implemented at last :-). Tangram::IxHash and Tangram::IntrIxHash are next :->
Tangram::IxHash
Tangram::IntrIxHash
verbose error message in Tangram::Coll when demand paging is happening on stale tied collections (eg, erroneously created via dclone())
fix for Postgres sub-select detection (Pedro Alves)
make_1st_id_in_tx now only called for 1st insert (Chengzhi Liang)
make_1st_id_in_tx
Fixed bug with Tangram::Intr* and erasing objects that referred to a class which didn't use their class name as their table name [closes: 2650]
Tangram::Intr*
Added the ability to use limit => [ N, Y ] in Tangram::Storage->select statements (see "select" in Tangram::Storage)
limit => [ N, Y ]
Tangram::Storage->select
Added Tangram::Coll::includes_or; see Tangram::Expr
Tangram::Coll::includes_or
Enhancement of error message from Tangram::Relational::Engine [related to 2631]
Support for using table types via $schema->{sql}{table_type}
$schema->{sql}{table_type}
Support for sub-selects with MySQL, for the one test that uses them. Also $storage->{no_subselects} is auto-detected.
$storage->{no_subselects}
Completed $storage->prefetch() function for all working types, new test t/prefetch.t
$storage->prefetch()
If you have NULL values in array or hash slots in your database, then it won't cause a hard error, except possibly with prefetch() [related to 2631]
Various small fixes to bizarre internal error messages [related to 2631]
Minor documentation fixes
Exceptions on various DB failures are now thrown when DBI::execute() is called internally, rather than being largely ignored.
DBI::execute()
Cosmetic Test Suite change
ID column name wasn't being used for the index in Tangram::Relational::Engine (Kurt Stephens)
Lost patches from 2002/06/25 (Kurt Stephens):
Added missing Tangram::Expr and Tangram::Filter operators:
'+', '-', '*', '/', '&', '|', '!', '==', '!=', '<', '>', '<=', '>=', 'eq', 'ne', 'lt', 'gt', 'le', 'ge', 'cos', 'sin', 'acos',
Added argument swapping for non-commutative operators, like
"<"
Fixed export problem with 5.6.1 (reported by Kate Pugh)
deep_update with Tangram::Ref bug fix (reported by Aaron Mackey)
deep_update
Makefile.PL should now hopefully be more informative about which modules are needed for what.
Removed Selfloader from Tangram::Ref (Kate Pugh)
Selfloader
Added $storage->oid_isa($oid, "ClassName") method for marshalling OIDs
$storage->oid_isa($oid, "ClassName")
Fixed minor bugs causing test suite to issue large warnings on 5.8.1-RC2
Tangram::Scalar and Tangram::Ref column names are now passed through $schema->{normalize}->()
$schema->{normalize}->()
Minor Tangram::Expr defined vs logically-false fix (Aaron Mackey)
explicitly select all ORDER BY columns (Aaron Mackey)
ORDER BY
normalise default "slot" and "coll" column names in Tangram::Intr* types
slot
coll
First "not the momma" release.
Patches from lots of people were applied, don't know who 'coz the honourable grand master JLL applied a lot of them, I'll try to summarize and attribute them here:
back-porting pieces for 5.00503 (that was me)
a more elegant solution for the Tangram::AbstractArray/Tangram::AbstractHash corner case than the one I submitted :-)
code that (possibly) completes Tangram::Hash support (I haven't written a test case to confirm this yet)
A fix to Tangram::AbstractSet that again caters to some very strange corner cases (this was me too)
Working implementation of the Tangram::DMDateTime type mapping, a good thing that running a persistent application server offsets the huge time it takes to load in Date::Manip :-)
A bug fix to Tangram::FlatArray mapping type that affects deleting members (don't know whose)
Tangram::IntrSet::get_intrusions (? can anyone claim or explain this one?)
Tangram::IntrSet::get_intrusions
Minor Tangram::PerlDump fix (a simple one)
Deep, deep magic in Tangram::Relational::Engine; new function get_heterogeneity (anyone?)
Use of uninitialised variable in Tangram::Relational::Engine...
Use of uninitialised variable in Tangram::Relational::Engine
Other large changes to Tangram::Schema (? - get_bases, get_specs, is_root, etc)
A problem with merging schemas when you used a `back-ref' to a class that is later on in the schema (me)
Scattered showers of changes in Tangram::Storage (get_insert_statements etc, lots of `off by one' (reference nesting level that is) changes)
All I can say is that there have been some very smart people looking at this code and submitting patches.
Originally as Changes in the distribution
Revision history for Perl extension Tangram. 0.01 Sun Mar 21 10:46:45 1999 - original version; created by h2xs 1.18 0.03 Stardate: unknown - first public alpha release 0.08 Stardate: unknown - second public alpha release 0.09 Stardate: unknown - split Tangram.pm into several modules - replaced @ISA with 'use base' - replaced default typetags with automounting - prefetch now takes either class or remote - implemented prefetch for IntrArray and IntrSet *::prefetch still need real-life testing, especially when class(coll) <> class(item) 1.00 Nov 07 1999 - first mature release version - deploy() now also works directly on DBI handles - deploy() allows specification of SQL types via the schema hash - intrusive collections allow element-to-container navigation - improve speed of read_object - fixed various bugs - rewrote part of, and expanded documentation 1.01 Nov 12 1999 - interim version - added (raw) mapping between Perl strings and date/time SQL types 1.02 Nov 14 1999 - interim version - added support for aggregated refs, arrays and sets 1.03 Dec 28 1999 - interim version - added support for customizing object & class id types, etc - as a consequence Tangram should now work with PostgreSql - fixed bug: erase() failed in presence of stateless leaf classes - temporarily removed RawDate and RawTime tests because M$ SQL cannot handle them; those modules are still present though 1.04 Jan 03 2000 - interim version - fixed two bugs related to explicit tables 1.05 Jan 03 2000 - interim version - fixed: Storage::prefetch now works with inherited members - fixed: _insert() ignored collections in stateless classes 1.06 Feb 29 2000 - higly experimental interim version - added typechecks on collection members - started cleaning up autovivification of colls upon save - documented like() - documented extended select options retrieve, order & filter - changed _limit into the Limit in test suite - added temporary hack in Makefile.PL to support Access - added mapping for flat arrays - factorized code common to Array & FlatArray 1.07 Feb 29 2000 - interim version - adapted test suite for Sybase and other NULL-picky databases - added experimental support for vendor extensions (Dialect) - added skeleton Dialect::Sybase with support for datepart - did extensive rework on Expr instantiation - began documenting Type - added Storage::reload() 1.08 Mar 26 2000 - interim version - batch allocation of object ids - support for Lobs contributed by marian.kelc@ruhr-uni-bochum.de - Storage::reset() 1.09 ? - interim version - String calls DBI for correct quoting, as Marian Kelc suggested - fixed Array problem when removing elements from middle of collection - (?) 1.10 Apr 19 2000 - interim version - changed reset() into unload() and added support for partial unloading - tx_do() can now propagate arguments to closure/anon-sub; insert(), update() and erase() pass anon-subs to tx_do to prevent leaks (thanks Radu Greab) 1.11 May 29 2000 - public version - ordering result set by descending order is now supported - die() on attempt to load from an invalid id - removed silly table id allocation limit (t1000) in Coll.pm 1.13 Jul 11 2000 - interim version - new FlatHash and DMDateTime mappings contributed by Gabor Herr <herr@iti.informatik.tu-darmstadt.de> - some more doc in Type.pod - date & time doc moved to DateTime.pod - deploy() puts \n between instructions in trace 1.15 Jul 21 2000 - interim version - new PerlDump mapping contributed by Gabor Herr <herr@iti.informatik.tu-darmstadt.de> 1.16 Jul 25 2000 - interim version - fixed deploy() bug: didn't take col names into account for Array, Set and Hash - fixed query_expr bug in Scalar and Ref: used field name instead of col name 1.17 Jul 28 2000 - interim version - Gabor's patches on deep updates 1.18 Jul 28 2000 - stable version - weakrefs! - tuples - mysql tx acquired lock regardless of tx nesting 1.19 Jul 28 2000 - stable version - improved id allocation for mysql - bitwise operators for mysql - manual class id allocation - install now works in the absence of DBI and Set::Object - Makefile.PL prerequisites work now - Guided Tour is now generated & can be run - added support for LIMIT in selects - deploy() didn't take explicit oid/cid type into account; fixed - deploy() wrongly defaulted to NULLable types; fixed - class id can now be specified - oid and cid now default to INTEGER - fixed error in Expr.pod but I don't remember what it was - minor improvement to Schema.pod - added Springfield.pm for users to play with - added support for SELECT SUM 2.00 Feb ?? 2001 - first S.O.L. release - added copyright notices - added a copy of the GPL - implemented inlined exports - INSERT and UPDATE now make use of prepared statements when available - re-executable Cursors - changed database layout, Class Table is gone and 'control' table in there - object ids are no longer allocated on a class basis - introduced Tangram::Relational - dialect are now done via derivation - stored object id no longer contains type id - introduced Relational::Engine - flexible mapping
To install Tangram, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Tangram
CPAN shell
perl -MCPAN -e shell install Tangram
For more information on module installation, please visit the detailed CPAN module installation guide.