aboutsummaryrefslogtreecommitdiffstats
path: root/databases/p5-Msql/pkg-descr
diff options
context:
space:
mode:
authorjfitz <jfitz@FreeBSD.org>1996-10-24 07:53:26 +0800
committerjfitz <jfitz@FreeBSD.org>1996-10-24 07:53:26 +0800
commitb3ec0d235e22d0624364b19a00045753038df668 (patch)
treedeba8f9454919fdfd135e5ff96334912fbabb97e /databases/p5-Msql/pkg-descr
parent2c42043bb6cd23cdabd49d817b19ef6e4b340e79 (diff)
downloadfreebsd-ports-gnome-b3ec0d235e22d0624364b19a00045753038df668.tar.gz
freebsd-ports-gnome-b3ec0d235e22d0624364b19a00045753038df668.tar.zst
freebsd-ports-gnome-b3ec0d235e22d0624364b19a00045753038df668.zip
Import of standalone module to allow access to mSQL databases in perl5.
Diffstat (limited to 'databases/p5-Msql/pkg-descr')
-rw-r--r--databases/p5-Msql/pkg-descr58
1 files changed, 58 insertions, 0 deletions
diff --git a/databases/p5-Msql/pkg-descr b/databases/p5-Msql/pkg-descr
new file mode 100644
index 000000000000..fd86725e90bc
--- /dev/null
+++ b/databases/p5-Msql/pkg-descr
@@ -0,0 +1,58 @@
+What you achieve with MsqlPerl
+------------------------------
+
+MsqlPerl is an interface between the perl programming language and the
+mSQL programming API that comes with the mSQL relational database
+management system. All functions provided by the mSQL programming API
+are supported.
+
+From perl you activate the interface with the statement
+
+ use Msql;
+
+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 = Msql->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 mSQL 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
+MsqlPerl 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.