diff options
author | James FitzGibbon <jfitz@FreeBSD.org> | 1997-09-14 02:55:26 +0000 |
---|---|---|
committer | James FitzGibbon <jfitz@FreeBSD.org> | 1997-09-14 02:55:26 +0000 |
commit | d2efc9486f1083050f50eb2370bb60ddff7f3ee6 (patch) | |
tree | 29b3be796f2a09b2913cb59336bd0c6eaf24b909 /databases | |
parent | 95d2da76533d8ba9a9d361956649cd02a06b29ee (diff) | |
download | ports-d2efc9486f1083050f50eb2370bb60ddff7f3ee6.tar.gz ports-d2efc9486f1083050f50eb2370bb60ddff7f3ee6.zip |
Notes
Diffstat (limited to 'databases')
-rw-r--r-- | databases/p5-DBD-Pg-13/Makefile | 8 | ||||
-rw-r--r-- | databases/p5-DBD-Pg-13/distinfo | 2 | ||||
-rw-r--r-- | databases/p5-DBD-Pg/Makefile | 8 | ||||
-rw-r--r-- | databases/p5-DBD-Pg/distinfo | 2 | ||||
-rw-r--r-- | databases/p5-DBD-mysql/Makefile | 28 | ||||
-rw-r--r-- | databases/p5-DBD-mysql/distinfo | 2 | ||||
-rw-r--r-- | databases/p5-DBD-mysql/pkg-comment | 2 | ||||
-rw-r--r-- | databases/p5-DBD-mysql/pkg-descr | 71 | ||||
-rw-r--r-- | databases/p5-DBD-mysql/pkg-plist | 10 | ||||
-rw-r--r-- | databases/p5-Msql/Makefile | 10 | ||||
-rw-r--r-- | databases/p5-Msql/distinfo | 2 | ||||
-rw-r--r-- | databases/p5-Mysql/Makefile | 28 | ||||
-rw-r--r-- | databases/p5-Mysql/distinfo | 2 | ||||
-rw-r--r-- | databases/p5-Mysql/pkg-comment | 2 | ||||
-rw-r--r-- | databases/p5-Mysql/pkg-descr | 71 | ||||
-rw-r--r-- | databases/p5-Mysql/pkg-plist | 10 |
16 files changed, 94 insertions, 164 deletions
diff --git a/databases/p5-DBD-Pg-13/Makefile b/databases/p5-DBD-Pg-13/Makefile index 43ecd0af48eb..1f46dd013a97 100644 --- a/databases/p5-DBD-Pg-13/Makefile +++ b/databases/p5-DBD-Pg-13/Makefile @@ -1,13 +1,13 @@ # New ports collection makefile for: p5-DBD-Pg -# Version required: 0.3 +# Version required: 0.62 # Date created: June 17th 1997 # Whom: James FitzGibbon <jfitz@FreeBSD.org> # -# $Id: Makefile,v 1.2 1997/06/19 07:46:16 asami Exp $ +# $Id: Makefile,v 1.3 1997/06/24 18:43:10 jfitz Exp $ # -DISTNAME= DBD-Pg-0.3 -PKGNAME= p5-DBD-Pg-0.3 +DISTNAME= DBD-Pg-0.62 +PKGNAME= p5-DBD-Pg-0.62 CATEGORIES= databases perl5 MASTER_SITES= ${MASTER_SITE_PERL_CPAN} MASTER_SITE_SUBDIR= DBD diff --git a/databases/p5-DBD-Pg-13/distinfo b/databases/p5-DBD-Pg-13/distinfo index 09cf8655a868..8c7d08be2ffa 100644 --- a/databases/p5-DBD-Pg-13/distinfo +++ b/databases/p5-DBD-Pg-13/distinfo @@ -1 +1 @@ -MD5 (DBD-Pg-0.3.tar.gz) = dd1e2d3e87f5308d7671c6acfbafff50 +MD5 (DBD-Pg-0.62.tar.gz) = fbb6144ad32762d8dae71d40c7af10c5 diff --git a/databases/p5-DBD-Pg/Makefile b/databases/p5-DBD-Pg/Makefile index 43ecd0af48eb..1f46dd013a97 100644 --- a/databases/p5-DBD-Pg/Makefile +++ b/databases/p5-DBD-Pg/Makefile @@ -1,13 +1,13 @@ # New ports collection makefile for: p5-DBD-Pg -# Version required: 0.3 +# Version required: 0.62 # Date created: June 17th 1997 # Whom: James FitzGibbon <jfitz@FreeBSD.org> # -# $Id: Makefile,v 1.2 1997/06/19 07:46:16 asami Exp $ +# $Id: Makefile,v 1.3 1997/06/24 18:43:10 jfitz Exp $ # -DISTNAME= DBD-Pg-0.3 -PKGNAME= p5-DBD-Pg-0.3 +DISTNAME= DBD-Pg-0.62 +PKGNAME= p5-DBD-Pg-0.62 CATEGORIES= databases perl5 MASTER_SITES= ${MASTER_SITE_PERL_CPAN} MASTER_SITE_SUBDIR= DBD diff --git a/databases/p5-DBD-Pg/distinfo b/databases/p5-DBD-Pg/distinfo index 09cf8655a868..8c7d08be2ffa 100644 --- a/databases/p5-DBD-Pg/distinfo +++ b/databases/p5-DBD-Pg/distinfo @@ -1 +1 @@ -MD5 (DBD-Pg-0.3.tar.gz) = dd1e2d3e87f5308d7671c6acfbafff50 +MD5 (DBD-Pg-0.62.tar.gz) = fbb6144ad32762d8dae71d40c7af10c5 diff --git a/databases/p5-DBD-mysql/Makefile b/databases/p5-DBD-mysql/Makefile index 1057a14455c0..0024c0b567f4 100644 --- a/databases/p5-DBD-mysql/Makefile +++ b/databases/p5-DBD-mysql/Makefile @@ -1,27 +1,29 @@ -# New ports collection makefile for: p5-MySQL -# Version required: 1.17 -# Date created: June 17th 1997 +# New ports collection makefile for: p5-Mysql-modules +# Version required: 1.1809 +# Date created: September 29th 1996 # Whom: James FitzGibbon <jfitz@FreeBSD.org> # -# $Id: Makefile,v 1.1.1.1 1997/06/18 19:39:25 jfitz Exp $ +# $Id: Makefile,v 1.14 1997/09/13 17:55:20 jfitz Exp $ # -DISTNAME= Mysqlperl-1.17 -PKGNAME= p5-Mysql-1.17 +DISTNAME= Mysql-modules-1.1809 +PKGNAME= p5-Mysql-modules-1.1809 CATEGORIES= databases perl5 -MASTER_SITES= http://www.tcx.se/Contrib/ -EXTRACT_SUFX= .tgz +MASTER_SITES= ${MASTER_SITE_PERL_CPAN} +MASTER_SITE_SUBDIR= DBD MAINTAINER= jfitz@FreeBSD.ORG -BUILD_DEPENDS= ${PREFIX}/lib/mysql/libmysqlclient.a:${PORTSDIR}/databases/mysql +BUILD_DEPENDS= ${PREFIX}/lib/libmysqlclient.a:${PORTSDIR}/databases/mysql/ \ + ${PREFIX}/lib/perl5/site_perl/Data/ShowTable.pm:${PORTSDIR}/devel/p5-Data-ShowTable/ \ + ${PREFIX}/lib/perl5/site_perl/DBI.pm:${PORTSDIR}/databases/p5-DBI/ +CONFIGURE_ENV+= PREFIX=${PREFIX} MSQL_HOME=${PREFIX} USE_PERL5= YES -MAN3= Mysql.3 -MANPREFIX= ${PREFIX}/lib/perl5 - -CONFIGURE_ENV+= PREFIX=${PREFIX} +MAN1= pmsql.1 dbimon.1 +MAN3= Mysql.3 DBD::mSQL.3 +MAN3PREFIX= ${PREFIX}/lib/perl5 do-configure: @cd ${WRKSRC}; ${SETENV} ${CONFIGURE_ENV} ${PREFIX}/bin/perl Makefile.PL diff --git a/databases/p5-DBD-mysql/distinfo b/databases/p5-DBD-mysql/distinfo index 71ed1556874a..3ead7771bd96 100644 --- a/databases/p5-DBD-mysql/distinfo +++ b/databases/p5-DBD-mysql/distinfo @@ -1 +1 @@ -MD5 (Mysqlperl-1.17.tgz) = a92064386ff373a31fb1fe854e81e461 +MD5 (Mysql-modules-1.1809.tar.gz) = 53372267db84fb9d4c0807407a8a286d diff --git a/databases/p5-DBD-mysql/pkg-comment b/databases/p5-DBD-mysql/pkg-comment index 5487f8277445..1b5acbde68be 100644 --- a/databases/p5-DBD-mysql/pkg-comment +++ b/databases/p5-DBD-mysql/pkg-comment @@ -1 +1 @@ -perl5 interface to the MySQL database +perl5 modules for accessing MiniSQL (mSQL) databases. diff --git a/databases/p5-DBD-mysql/pkg-descr b/databases/p5-DBD-mysql/pkg-descr index 72e2acba0c74..c87518913b6d 100644 --- a/databases/p5-DBD-mysql/pkg-descr +++ b/databases/p5-DBD-mysql/pkg-descr @@ -1,58 +1,13 @@ -What you achieve with MysqlPerl ------------------------------- - -MysqlPerl is an interface between the perl programming language and the -MySQL programming API that comes with the MySQL relational database -management system. All functions provided by the MySQL programming API -are supported. - -From perl you activate the interface with the statement - - use Mysql; - -After that you can connect to multiple msql database servers and send -multiple queries to any of them via an simple object oriented -interface. Two types of objects are available: database handles and -statement handles. Perl returns a database handle to the Connect -method like so: - - $dbh = Mysql->connect($hostname,$databasename); - -Once you have connected to a database, you get a statement handle -with: - - $sth = $dbh->query("select foo from bar"); - -You can open as many queries as you like simultaneously by selecting a -different scalar to hold the object: - - $another_sth = $dbh->Query("select bar from foo"); - - -The statement handle allows you to step through the virtual table -returned from the database with the FetchRow method: - - @row = $sth->fetchrow; -or - %hash = $sth->fetchhash; - -You can access all metadata that MySQL supplies for a given table. To -find out the number of rows or the number of fields returned by a -query you simply say: - - $numrows = $sth->numrows; - $numfields = $sth->numfields; - -To find out the size in bytes for the field with the offset 0 (the -first field of a query), you say: - - $length = $sth->length->[0]; - -The list of the names for each column is returned by - - @list => $sth->name; - -As for other metadata available, consult the manpage that comes with -MysqlPerl and study the examples in the file t/msql.t, which is the -extensive testscript to test your installation, but is heavily -commented, so you may use it as a tutorial. +Msql.pm and DBD::mSQL implement two different approaches to +communicate with an mSQL server. DBD::mSQL is built upon the DBI, the +generic Perl Database Interface. It brings you an identical interface +to a broad variety of databases and is in this regard comparable to +ODBC. The advantage of the DBI approach is portability and +interoperability. Msql.pm is the elder species. It was written before +DBI was available but it was inspired by an early draft of the DBI +specification. As it has been circulating longer it is more mature and +pretty stable. It's also more complete than DBD::mSQL. + +Some day in the future DBD::mSQL will probably be the clearly superior +competitor in this package. Today you have to decide on your own about +the trade-offs. diff --git a/databases/p5-DBD-mysql/pkg-plist b/databases/p5-DBD-mysql/pkg-plist index fcdf2c198273..4b8e82c51fb8 100644 --- a/databases/p5-DBD-mysql/pkg-plist +++ b/databases/p5-DBD-mysql/pkg-plist @@ -1,8 +1,16 @@ +bin/dbimon +bin/pmsql +lib/perl5/man/man3/DBD::mysql.3.gz lib/perl5/man/man3/Mysql.3.gz +lib/perl5/site_perl/DBD/mysql.pm lib/perl5/site_perl/Mysql.pm lib/perl5/site_perl/Mysql/Statement.pm +lib/perl5/site_perl/i386-freebsd/auto/DBD/mysql/mysql.bs +lib/perl5/site_perl/i386-freebsd/auto/DBD/mysql/mysql.so lib/perl5/site_perl/i386-freebsd/auto/Mysql/Mysql.bs lib/perl5/site_perl/i386-freebsd/auto/Mysql/Mysql.so +man/man1/pmsql.1.gz +man/man1/dbimon.1.gz lib/perl5/site_perl/i386-freebsd/auto/Mysql/.packlist +@dirrm lib/perl5/site_perl/i386-freebsd/auto/DBD/mysql @dirrm lib/perl5/site_perl/i386-freebsd/auto/Mysql -@dirrm lib/perl5/site_perl/Mysql diff --git a/databases/p5-Msql/Makefile b/databases/p5-Msql/Makefile index ec58d819e444..d9e16eae292f 100644 --- a/databases/p5-Msql/Makefile +++ b/databases/p5-Msql/Makefile @@ -1,13 +1,13 @@ # New ports collection makefile for: p5-Msql-modules -# Version required: 1.1808 +# Version required: 1.1809 # Date created: September 29th 1996 # Whom: James FitzGibbon <jfitz@FreeBSD.org> # -# $Id: Makefile,v 1.13 1997/07/14 13:23:27 jfitz Exp $ +# $Id: Makefile,v 1.14 1997/09/13 17:55:20 jfitz Exp $ # -DISTNAME= Msql-modules-1.1808 -PKGNAME= p5-Msql-modules-1.1808 +DISTNAME= Msql-modules-1.1809 +PKGNAME= p5-Msql-modules-1.1809 CATEGORIES= databases perl5 MASTER_SITES= ${MASTER_SITE_PERL_CPAN} MASTER_SITE_SUBDIR= Msql @@ -15,7 +15,7 @@ MASTER_SITE_SUBDIR= Msql MAINTAINER= jfitz@FreeBSD.ORG BUILD_DEPENDS= ${PREFIX}/lib/libmsql.a:${PORTSDIR}/databases/msql/ \ - ${PREFIX}/lib/perl5/site_perl/Data/ShowTable.pm:${PORTSDIR}/misc/p5-Data/ShowTable/ \ + ${PREFIX}/lib/perl5/site_perl/Data/ShowTable.pm:${PORTSDIR}/devel/p5-Data-ShowTable/ \ ${PREFIX}/lib/perl5/site_perl/DBI.pm:${PORTSDIR}/databases/p5-DBI/ CONFIGURE_ENV+= PREFIX=${PREFIX} MSQL_HOME=${PREFIX} diff --git a/databases/p5-Msql/distinfo b/databases/p5-Msql/distinfo index c02bda1d7144..16c32fd33e02 100644 --- a/databases/p5-Msql/distinfo +++ b/databases/p5-Msql/distinfo @@ -1 +1 @@ -MD5 (Msql-modules-1.1808.tar.gz) = 764e0267a86b479be1ac33de4860dfe1 +MD5 (Msql-modules-1.1809.tar.gz) = 2d6f02d62b26cb2bb105c77b8e740f49 diff --git a/databases/p5-Mysql/Makefile b/databases/p5-Mysql/Makefile index 1057a14455c0..0024c0b567f4 100644 --- a/databases/p5-Mysql/Makefile +++ b/databases/p5-Mysql/Makefile @@ -1,27 +1,29 @@ -# New ports collection makefile for: p5-MySQL -# Version required: 1.17 -# Date created: June 17th 1997 +# New ports collection makefile for: p5-Mysql-modules +# Version required: 1.1809 +# Date created: September 29th 1996 # Whom: James FitzGibbon <jfitz@FreeBSD.org> # -# $Id: Makefile,v 1.1.1.1 1997/06/18 19:39:25 jfitz Exp $ +# $Id: Makefile,v 1.14 1997/09/13 17:55:20 jfitz Exp $ # -DISTNAME= Mysqlperl-1.17 -PKGNAME= p5-Mysql-1.17 +DISTNAME= Mysql-modules-1.1809 +PKGNAME= p5-Mysql-modules-1.1809 CATEGORIES= databases perl5 -MASTER_SITES= http://www.tcx.se/Contrib/ -EXTRACT_SUFX= .tgz +MASTER_SITES= ${MASTER_SITE_PERL_CPAN} +MASTER_SITE_SUBDIR= DBD MAINTAINER= jfitz@FreeBSD.ORG -BUILD_DEPENDS= ${PREFIX}/lib/mysql/libmysqlclient.a:${PORTSDIR}/databases/mysql +BUILD_DEPENDS= ${PREFIX}/lib/libmysqlclient.a:${PORTSDIR}/databases/mysql/ \ + ${PREFIX}/lib/perl5/site_perl/Data/ShowTable.pm:${PORTSDIR}/devel/p5-Data-ShowTable/ \ + ${PREFIX}/lib/perl5/site_perl/DBI.pm:${PORTSDIR}/databases/p5-DBI/ +CONFIGURE_ENV+= PREFIX=${PREFIX} MSQL_HOME=${PREFIX} USE_PERL5= YES -MAN3= Mysql.3 -MANPREFIX= ${PREFIX}/lib/perl5 - -CONFIGURE_ENV+= PREFIX=${PREFIX} +MAN1= pmsql.1 dbimon.1 +MAN3= Mysql.3 DBD::mSQL.3 +MAN3PREFIX= ${PREFIX}/lib/perl5 do-configure: @cd ${WRKSRC}; ${SETENV} ${CONFIGURE_ENV} ${PREFIX}/bin/perl Makefile.PL diff --git a/databases/p5-Mysql/distinfo b/databases/p5-Mysql/distinfo index 71ed1556874a..3ead7771bd96 100644 --- a/databases/p5-Mysql/distinfo +++ b/databases/p5-Mysql/distinfo @@ -1 +1 @@ -MD5 (Mysqlperl-1.17.tgz) = a92064386ff373a31fb1fe854e81e461 +MD5 (Mysql-modules-1.1809.tar.gz) = 53372267db84fb9d4c0807407a8a286d diff --git a/databases/p5-Mysql/pkg-comment b/databases/p5-Mysql/pkg-comment index 5487f8277445..1b5acbde68be 100644 --- a/databases/p5-Mysql/pkg-comment +++ b/databases/p5-Mysql/pkg-comment @@ -1 +1 @@ -perl5 interface to the MySQL database +perl5 modules for accessing MiniSQL (mSQL) databases. diff --git a/databases/p5-Mysql/pkg-descr b/databases/p5-Mysql/pkg-descr index 72e2acba0c74..c87518913b6d 100644 --- a/databases/p5-Mysql/pkg-descr +++ b/databases/p5-Mysql/pkg-descr @@ -1,58 +1,13 @@ -What you achieve with MysqlPerl ------------------------------- - -MysqlPerl is an interface between the perl programming language and the -MySQL programming API that comes with the MySQL relational database -management system. All functions provided by the MySQL programming API -are supported. - -From perl you activate the interface with the statement - - use Mysql; - -After that you can connect to multiple msql database servers and send -multiple queries to any of them via an simple object oriented -interface. Two types of objects are available: database handles and -statement handles. Perl returns a database handle to the Connect -method like so: - - $dbh = Mysql->connect($hostname,$databasename); - -Once you have connected to a database, you get a statement handle -with: - - $sth = $dbh->query("select foo from bar"); - -You can open as many queries as you like simultaneously by selecting a -different scalar to hold the object: - - $another_sth = $dbh->Query("select bar from foo"); - - -The statement handle allows you to step through the virtual table -returned from the database with the FetchRow method: - - @row = $sth->fetchrow; -or - %hash = $sth->fetchhash; - -You can access all metadata that MySQL supplies for a given table. To -find out the number of rows or the number of fields returned by a -query you simply say: - - $numrows = $sth->numrows; - $numfields = $sth->numfields; - -To find out the size in bytes for the field with the offset 0 (the -first field of a query), you say: - - $length = $sth->length->[0]; - -The list of the names for each column is returned by - - @list => $sth->name; - -As for other metadata available, consult the manpage that comes with -MysqlPerl and study the examples in the file t/msql.t, which is the -extensive testscript to test your installation, but is heavily -commented, so you may use it as a tutorial. +Msql.pm and DBD::mSQL implement two different approaches to +communicate with an mSQL server. DBD::mSQL is built upon the DBI, the +generic Perl Database Interface. It brings you an identical interface +to a broad variety of databases and is in this regard comparable to +ODBC. The advantage of the DBI approach is portability and +interoperability. Msql.pm is the elder species. It was written before +DBI was available but it was inspired by an early draft of the DBI +specification. As it has been circulating longer it is more mature and +pretty stable. It's also more complete than DBD::mSQL. + +Some day in the future DBD::mSQL will probably be the clearly superior +competitor in this package. Today you have to decide on your own about +the trade-offs. diff --git a/databases/p5-Mysql/pkg-plist b/databases/p5-Mysql/pkg-plist index fcdf2c198273..4b8e82c51fb8 100644 --- a/databases/p5-Mysql/pkg-plist +++ b/databases/p5-Mysql/pkg-plist @@ -1,8 +1,16 @@ +bin/dbimon +bin/pmsql +lib/perl5/man/man3/DBD::mysql.3.gz lib/perl5/man/man3/Mysql.3.gz +lib/perl5/site_perl/DBD/mysql.pm lib/perl5/site_perl/Mysql.pm lib/perl5/site_perl/Mysql/Statement.pm +lib/perl5/site_perl/i386-freebsd/auto/DBD/mysql/mysql.bs +lib/perl5/site_perl/i386-freebsd/auto/DBD/mysql/mysql.so lib/perl5/site_perl/i386-freebsd/auto/Mysql/Mysql.bs lib/perl5/site_perl/i386-freebsd/auto/Mysql/Mysql.so +man/man1/pmsql.1.gz +man/man1/dbimon.1.gz lib/perl5/site_perl/i386-freebsd/auto/Mysql/.packlist +@dirrm lib/perl5/site_perl/i386-freebsd/auto/DBD/mysql @dirrm lib/perl5/site_perl/i386-freebsd/auto/Mysql -@dirrm lib/perl5/site_perl/Mysql |