diff options
author | jfitz <jfitz@FreeBSD.org> | 1996-10-24 07:53:26 +0800 |
---|---|---|
committer | jfitz <jfitz@FreeBSD.org> | 1996-10-24 07:53:26 +0800 |
commit | b3ec0d235e22d0624364b19a00045753038df668 (patch) | |
tree | deba8f9454919fdfd135e5ff96334912fbabb97e /databases/p5-Msql/pkg-descr | |
parent | 2c42043bb6cd23cdabd49d817b19ef6e4b340e79 (diff) | |
download | freebsd-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-descr | 58 |
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. |