diff mayachemtools/docs/modules/man3/DBUtil.3 @ 0:73ae111cf86f draft

Uploaded

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/mayachemtools/docs/modules/man3/DBUtil.3	Wed Jan 20 11:55:01 2016 -0500
@@ -0,0 +1,208 @@
+.\" Automatically generated by Pod::Man 2.25 (Pod::Simple 3.22)
+.\"
+.\" Standard preamble:
+.\" ========================================================================
+.de Sp \" Vertical space (when we can't use .PP)
+.if t .sp .5v
+.if n .sp
+..
+.de Vb \" Begin verbatim text
+.ft CW
+.nf
+.ne \\$1
+..
+.de Ve \" End verbatim text
+.ft R
+.fi
+..
+.\" Set up some character translations and predefined strings.  \*(-- will
+.\" give an unbreakable dash, \*(PI will give pi, \*(L" will give a left
+.\" double quote, and \*(R" will give a right double quote.  \*(C+ will
+.\" give a nicer C++.  Capital omega is used to do unbreakable dashes and
+.\" therefore won't be available.  \*(C` and \*(C' expand to `' in nroff,
+.\" nothing in troff, for use with C<>.
+.tr \(*W-
+.ds C+ C\v'-.1v'\h'-1p'\s-2+\h'-1p'+\s0\v'.1v'\h'-1p'
+.ie n \{\
+.    ds -- \(*W-
+.    ds PI pi
+.    if (\n(.H=4u)&(1m=24u) .ds -- \(*W\h'-12u'\(*W\h'-12u'-\" diablo 10 pitch
+.    if (\n(.H=4u)&(1m=20u) .ds -- \(*W\h'-12u'\(*W\h'-8u'-\"  diablo 12 pitch
+.    ds L" ""
+.    ds R" ""
+.    ds C` ""
+.    ds C' ""
+'br\}
+.el\{\
+.    ds -- \|\(em\|
+.    ds PI \(*p
+.    ds L" ``
+.    ds R" ''
+'br\}
+.\"
+.\" Escape single quotes in literal strings from groff's Unicode transform.
+.ie \n(.g .ds Aq \(aq
+.el       .ds Aq '
+.\"
+.\" If the F register is turned on, we'll generate index entries on stderr for
+.\" titles (.TH), headers (.SH), subsections (.SS), items (.Ip), and index
+.\" entries marked with X<> in POD.  Of course, you'll have to process the
+.\" output yourself in some meaningful fashion.
+.ie \nF \{\
+.    de IX
+.    tm Index:\\$1\t\\n%\t"\\$2"
+..
+.    nr % 0
+.    rr F
+.\}
+.el \{\
+.    de IX
+..
+.\}
+.\"
+.\" Accent mark definitions (@(#)ms.acc 1.5 88/02/08 SMI; from UCB 4.2).
+.\" Fear.  Run.  Save yourself.  No user-serviceable parts.
+.    \" fudge factors for nroff and troff
+.if n \{\
+.    ds #H 0
+.    ds #V .8m
+.    ds #F .3m
+.    ds #[ \f1
+.    ds #] \fP
+.\}
+.if t \{\
+.    ds #H ((1u-(\\\\n(.fu%2u))*.13m)
+.    ds #V .6m
+.    ds #F 0
+.    ds #[ \&
+.    ds #] \&
+.\}
+.    \" simple accents for nroff and troff
+.if n \{\
+.    ds ' \&
+.    ds ` \&
+.    ds ^ \&
+.    ds , \&
+.    ds ~ ~
+.    ds /
+.\}
+.if t \{\
+.    ds ' \\k:\h'-(\\n(.wu*8/10-\*(#H)'\'\h"|\\n:u"
+.    ds ` \\k:\h'-(\\n(.wu*8/10-\*(#H)'\`\h'|\\n:u'
+.    ds ^ \\k:\h'-(\\n(.wu*10/11-\*(#H)'^\h'|\\n:u'
+.    ds , \\k:\h'-(\\n(.wu*8/10)',\h'|\\n:u'
+.    ds ~ \\k:\h'-(\\n(.wu-\*(#H-.1m)'~\h'|\\n:u'
+.    ds / \\k:\h'-(\\n(.wu*8/10-\*(#H)'\z\(sl\h'|\\n:u'
+.\}
+.    \" troff and (daisy-wheel) nroff accents
+.ds : \\k:\h'-(\\n(.wu*8/10-\*(#H+.1m+\*(#F)'\v'-\*(#V'\z.\h'.2m+\*(#F'.\h'|\\n:u'\v'\*(#V'
+.ds 8 \h'\*(#H'\(*b\h'-\*(#H'
+.ds o \\k:\h'-(\\n(.wu+\w'\(de'u-\*(#H)/2u'\v'-.3n'\*(#[\z\(de\v'.3n'\h'|\\n:u'\*(#]
+.ds d- \h'\*(#H'\(pd\h'-\w'~'u'\v'-.25m'\f2\(hy\fP\v'.25m'\h'-\*(#H'
+.ds D- D\\k:\h'-\w'D'u'\v'-.11m'\z\(hy\v'.11m'\h'|\\n:u'
+.ds th \*(#[\v'.3m'\s+1I\s-1\v'-.3m'\h'-(\w'I'u*2/3)'\s-1o\s+1\*(#]
+.ds Th \*(#[\s+2I\s-2\h'-\w'I'u*3/5'\v'-.3m'o\v'.3m'\*(#]
+.ds ae a\h'-(\w'a'u*4/10)'e
+.ds Ae A\h'-(\w'A'u*4/10)'E
+.    \" corrections for vroff
+.if v .ds ~ \\k:\h'-(\\n(.wu*9/10-\*(#H)'\s-2\u~\d\s+2\h'|\\n:u'
+.if v .ds ^ \\k:\h'-(\\n(.wu*10/11-\*(#H)'\v'-.4m'^\v'.4m'\h'|\\n:u'
+.    \" for low resolution devices (crt and lpr)
+.if \n(.H>23 .if \n(.V>19 \
+\{\
+.    ds : e
+.    ds 8 ss
+.    ds o a
+.    ds d- d\h'-1'\(ga
+.    ds D- D\h'-1'\(hy
+.    ds th \o'bp'
+.    ds Th \o'LP'
+.    ds ae ae
+.    ds Ae AE
+.\}
+.rm #[ #] #H #V #F C
+.\" ========================================================================
+.\"
+.IX Title "DBUTIL 1"
+.TH DBUTIL 1 "2015-03-29" "perl v5.14.2" "MayaChemTools"
+.\" For nroff, turn off justification.  Always turn off hyphenation; it makes
+.\" way too many mistakes in technical documents.
+.if n .ad l
+.nh
+.SH "NAME"
+DBUtil
+.SH "SYNOPSIS"
+.IX Header "SYNOPSIS"
+use DBUtil;
+.PP
+use DBUtil qw(:all);
+.SH "DESCRIPTION"
+.IX Header "DESCRIPTION"
+\&\fBDBUtil\fR module provides the following functions:
+.PP
+DBConnect, DBDisconnect, DBFetchSchemaTableNames, DBSQLToTextFile,
+DBSetupDescribeSQL, DBSetupSelectSQL
+.PP
+DBUtil package uses Perl \s-1DBI\s0 for interacting with MySQL Oracle, and PostgreSQL
+databases.
+.SH "FUNCTIONS"
+.IX Header "FUNCTIONS"
+.IP "\fBDBConnect\fR" 4
+.IX Item "DBConnect"
+.Vb 1
+\&    $DBHandle = DBConnect($DBDriver, $DBName, $DBHost, $DBUser, $DBPassword);
+.Ve
+.Sp
+Connects to a database using specified parameters and returns a \fBDBHandle\fR.
+.IP "\fBDBDisconnect\fR" 4
+.IX Item "DBDisconnect"
+.Vb 1
+\&    DBDisconnect($DBHandle);
+.Ve
+.Sp
+Disconnects from a database specified by \fIDBHandle\fR.
+.IP "\fBDBFetchSchemaTableNames\fR" 4
+.IX Item "DBFetchSchemaTableNames"
+.Vb 2
+\&    @SchemaTableNames = DBFetchSchemaTableNames($DBDriver, $DBHandle,
+\&                       $SchemaName);
+.Ve
+.Sp
+Returns an array of all the table names in a database \fISchemaName\fR.
+.IP "\fBDBSetupDescribeSQL\fR" 4
+.IX Item "DBSetupDescribeSQL"
+.Vb 1
+\&    $DescribeSQL = DBSetupDescribeSQL($DBDriver, $TableName, [$SchemaName]);
+.Ve
+.Sp
+Sets up and returns a \s-1SQL\s0 statement to describe a table for MySQ, Oracle or PostgreSQL.
+.IP "\fBDBSetupSelectSQL\fR" 4
+.IX Item "DBSetupSelectSQL"
+.Vb 1
+\&    $SelectSQL = DBSetupSelectSQL($DBDriver, $TableName, $SchemaName);
+.Ve
+.Sp
+Sets up and returns a \s-1SQL\s0 statement to retrieve all columns from a table for MySQL,
+Oracle, or PostgreSQL.
+.IP "\fBDBSQLToTextFile\fR" 4
+.IX Item "DBSQLToTextFile"
+.Vb 3
+\&    $Status = DBSQLToTextFile($DBHandle, $SQL, \e*TEXTFILE, $OutDelim,
+\&              $OutQuote, [$ExportDataLabels, $ExportLOBs,
+\&              $ReplaceNullStr]);
+.Ve
+.Sp
+Executes a \fI\s-1SQL\s0\fR statement and export all data into a text file.
+.SH "AUTHOR"
+.IX Header "AUTHOR"
+Manish Sud <[e-mail]>
+.SH "COPYRIGHT"
+.IX Header "COPYRIGHT"
+Copyright (C) 2015 Manish Sud. All rights reserved.
+.PP
+This file is part of MayaChemTools.
+.PP
+MayaChemTools is free software; you can redistribute it and/or modify it under
+the terms of the \s-1GNU\s0 Lesser General Public License as published by the Free
+Software Foundation; either version 3 of the License, or (at your option)
+any later version.