You are viewing a plain text version of this content. The canonical link for it is here.
Posted to embperl@perl.apache.org by Terrence Brannon <me...@urth.org> on 2003/12/31 04:17:22 UTC
[ANNOUNCE] DBIx::Recordset 0.25 now on CPAN
NEW FUNCTIONALITY (Cameron Prince, Terrence Brannon)
* Full SQL Query input via the !Query option to Search()
* added the '$makesql' flag to Search() so that generated SQL can
be returned instead of executed. It will remain undocumented until
it is supported for Update(), Delete(), and Insert(). It was added
in order that the SQL generated for the test "Order, Group,
Append" would pass on Postgres which finds the generated SQL
invalid.
BUGFIXES (Angus Lees, Terrence Brannon, Gerald Richter)
* when building the FROM clause for
LEFT JOINs Recordset placed parentheses around it, like this:
SELECT
dbixrs1.id,dbixrs1.name,dbixrs1.value1,dbixrs1.addon,dbixrs2.value2
FROM (dbixrs1 left join dbixrs2 on dbixrs1.id = dbixrs2.id)
WHERE dbixrs1.id IN (2, 5, 10);
but this caused a syntax error in sqlite, so a new leftjoin type
of 4 was introduced to support LEFT JOIN with no parentheses
around the join
* Fixed a bug that cause TableAttr with value zero not to work
correctly. Patch from Rene Seindal
* Made sure that filters given by name override filters given by type.
* Fixed PreFetchIfExpires() so that it works for a specified time period as
well as for a CODE ref
* Added support to DBIx::Compat so that the pseudo-type "counter" was
converted
to SERIAL when DBD::Pg is in use
* DBD::mysql versions > 2.9002 quote the table name. While is good and valid
practice, the other drivers tested (SQLite and Pg) do not do this, making it
difficult to create a consistent test suite. For the time being, a custom
ListTablesMySQL was added to DBIx::Compat which strips the backquotes.
---------------------------------------------------------------------
To unsubscribe, e-mail: embperl-unsubscribe@perl.apache.org
For additional commands, e-mail: embperl-help@perl.apache.org
Re: [ANNOUNCE] DBIx::Recordset 0.25 now on CPAN
Posted by Gerald Richter <ri...@ecos.de>.
Terrence,
thanks very much for getting the new version on CPAN and all your work you
put into DBIx::Recordset
Gerald
Terrence Brannon wrote:
> NEW FUNCTIONALITY (Cameron Prince, Terrence Brannon)
>
> * Full SQL Query input via the !Query option to Search()
>
> * added the '$makesql' flag to Search() so that generated SQL can
> be returned instead of executed. It will remain undocumented until
> it is supported for Update(), Delete(), and Insert(). It was added
> in order that the SQL generated for the test "Order, Group,
> Append" would pass on Postgres which finds the generated SQL
> invalid.
>
>
> BUGFIXES (Angus Lees, Terrence Brannon, Gerald Richter)
>
> * when building the FROM clause for
> LEFT JOINs Recordset placed parentheses around it, like this:
>
> SELECT
>
> dbixrs1.id,dbixrs1.name,dbixrs1.value1,dbixrs1.addon,dbixrs2.value2
> FROM (dbixrs1 left join dbixrs2 on dbixrs1.id = dbixrs2.id) WHERE
> dbixrs1.id IN (2, 5, 10);
>
> but this caused a syntax error in sqlite, so a new leftjoin type
> of 4 was introduced to support LEFT JOIN with no parentheses
> around the join
>
> * Fixed a bug that cause TableAttr with value zero not to work
> correctly. Patch from Rene Seindal
>
> * Made sure that filters given by name override filters given by type.
>
> * Fixed PreFetchIfExpires() so that it works for a specified time
> period as well as for a CODE ref
>
> * Added support to DBIx::Compat so that the pseudo-type "counter" was
> converted
> to SERIAL when DBD::Pg is in use
>
> * DBD::mysql versions > 2.9002 quote the table name. While is good
> and valid practice, the other drivers tested (SQLite and Pg) do not
> do this, making it difficult to create a consistent test suite. For
> the time being, a custom ListTablesMySQL was added to DBIx::Compat
> which strips the backquotes.
--------------------------------------------------------------
Gerald Richter ecos electronic communication services gmbh
IT-Securitylösungen * dynamische Webapplikationen * Consulting
Post: Tulpenstrasse 5 D-55276 Dienheim b. Mainz
E-Mail: richter@ecos.de Voice: +49 6133 939-122
WWW: http://www.ecos.de/ Fax: +49 6133 939-333
--------------------------------------------------------------
|
| ECOS BB-5000 Firewall- und IT-Security Appliance: www.bb-5000.info
|
+-------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: embperl-unsubscribe@perl.apache.org
For additional commands, e-mail: embperl-help@perl.apache.org
Re: DBIx::Recordset - Gerald -> Edit Module Metadata
Posted by Gerald Richter <ri...@ecos.de>.
Terrence Brannon wrote:
> Gerald, to turn the module over to me, goto https://pause.perl.org
>
> and set the CPAN userid of the owner of DBIx::Recordset to
>
> TBONE
>
> since that is my userid.
>
ok, done. Hopefully it will be indexed now correctly
Gerald
--------------------------------------------------------------
Gerald Richter ecos electronic communication services gmbh
IT-Securitylösungen * dynamische Webapplikationen * Consulting
Post: Tulpenstrasse 5 D-55276 Dienheim b. Mainz
E-Mail: richter@ecos.de Voice: +49 6133 939-122
WWW: http://www.ecos.de/ Fax: +49 6133 939-333
--------------------------------------------------------------
|
| ECOS BB-5000 Firewall- und IT-Security Appliance: www.bb-5000.info
|
+-------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: embperl-unsubscribe@perl.apache.org
For additional commands, e-mail: embperl-help@perl.apache.org
DBIx::Recordset - Gerald -> Edit Module Metadata
Posted by Terrence Brannon <me...@urth.org>.
Gerald, to turn the module over to me, goto https://pause.perl.org
and set the CPAN userid of the owner of DBIx::Recordset to
TBONE
since that is my userid.
---------------------------------------------------------------------
To unsubscribe, e-mail: embperl-unsubscribe@perl.apache.org
For additional commands, e-mail: embperl-help@perl.apache.org
Re: [ANNOUNCE] DBIx::Recordset 0.25 now on CPAN
Posted by Terrence Brannon <me...@urth.org>.
Kaare Rasmussen wrote:
>Just tried this:
>
>cpan> reload index
>cpan> i DBIx::Recordset
>Strange distribution name [DBIx::Recordset]
>Module id = DBIx::Recordset
> DESCRIPTION DB-Abtractionlayer / Access via Arrays/Hashs
> CPAN_USERID GRICHTER (Gerald Richter <ri...@ecos.de>)
> CPAN_VERSION 0.24
> CPAN_FILE G/GR/GRICHTER/DBIx-Recordset-0.24.tar.gz
>
>Seems it is still 0.24 on CPAN ?
>
>
>>* Full SQL Query input via the !Query option to Search()
>>
>
>It's not documented ?
>
>
http://search.cpan.org/~tbone/DBIx-Recordset-0.25/
this is the release under my name at search.cpan.org
but you're right - via CPAN.pm 0.24 release is downloaded:
~/bin/psql $ perl -MCPAN -e 'get DBIx::Recordset'
CPAN: Storable loaded ok
Going to read /home/metaperl/.cpan/Metadata
Database was generated on Wed, 31 Dec 2003 05:47:41 GMT
CPAN: LWP::UserAgent loaded ok
Fetching with LWP:
ftp://cpan.pair.com/pub/CPAN/authors/01mailrc.txt.gz
Going to read /home/metaperl/.cpan/sources/authors/01mailrc.txt.gz
CPAN: Compress::Zlib loaded ok
Fetching with LWP:
ftp://cpan.pair.com/pub/CPAN/modules/02packages.details.txt.gz
Going to read /home/metaperl/.cpan/sources/modules/02packages.details.txt.gz
Database was generated on Fri, 02 Jan 2004 15:52:26 GMT
Fetching with LWP:
ftp://cpan.pair.com/pub/CPAN/modules/03modlist.data.gz
Going to read /home/metaperl/.cpan/sources/modules/03modlist.data.gz
Going to write /home/metaperl/.cpan/Metadata
Running get for module DBIx::Recordset
CPAN: Digest::MD5 loaded ok
Checksum for
/home/metaperl/.cpan/sources/authors/id/G/GR/GRICHTER/DBIx-Recordset-0.24.tar.gz
ok
Scanning cache /home/metaperl/.cpan/build for sizes
DBIx-Recordset-0.24/
DBIx-Recordset-0.24/Makefile.PL
DBIx-Recordset-0.24/test.pl
DBIx-Recordset-0.24/Recordset.pm
DBIx-Recordset-0.24/eg/
DBIx-Recordset-0.24/eg/search.htm
DBIx-Recordset-0.24/eg/search.pl
DBIx-Recordset-0.24/eg/README
DBIx-Recordset-0.24/MANIFEST
DBIx-Recordset-0.24/Database.pm
DBIx-Recordset-0.24/Intrors.pod
DBIx-Recordset-0.24/Compat.pm
DBIx-Recordset-0.24/Recordset/
DBIx-Recordset-0.24/Recordset/DBSeq.pm
DBIx-Recordset-0.24/Recordset/FileSeq.pm
DBIx-Recordset-0.24/Changes
DBIx-Recordset-0.24/TODO
DBIx-Recordset-0.24/README
Re: [ANNOUNCE] DBIx::Recordset 0.25 now on CPAN
Posted by Kaare Rasmussen <ka...@kakidata.dk>.
Just tried this:
cpan> reload index
cpan> i DBIx::Recordset
Strange distribution name [DBIx::Recordset]
Module id = DBIx::Recordset
DESCRIPTION DB-Abtractionlayer / Access via Arrays/Hashs
CPAN_USERID GRICHTER (Gerald Richter <ri...@ecos.de>)
CPAN_VERSION 0.24
CPAN_FILE G/GR/GRICHTER/DBIx-Recordset-0.24.tar.gz
Seems it is still 0.24 on CPAN ?
> * Full SQL Query input via the !Query option to Search()
It's not documented ?
--
Kaare Rasmussen --Linux, spil,-- Tlf: 3816 2582
Kaki Data tshirts, merchandize Fax: 3816 2501
Howitzvej 75 Åben 12.00-18.00 Email: kar@kakidata.dk
2000 Frederiksberg Lørdag 12.00-16.00 Web: www.suse.dk
---------------------------------------------------------------------
To unsubscribe, e-mail: embperl-unsubscribe@perl.apache.org
For additional commands, e-mail: embperl-help@perl.apache.org