dbd::interbase.3

视频监控网络部分的协议ddns,的模块的实现代码,请大家大胆指正.

.\" Automatically generated by Pod::Man 2.16 (Pod::Simple 3.05)
.\"
.\" Standard preamble:
.\" ========================================================================
.de Sh \" Subsection heading
.br
.if t .Sp
.ne 5
.PP
\fB\\$1\fR
.PP
..
.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 (.Sh), 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 "InterBase 3"
.TH InterBase 3 "2008-01-08" "perl v5.10.0" "User Contributed Perl Documentation"
.\" 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"
DBD::InterBase \- DBI driver for Firebird and InterBase RDBMS server
.SH "SYNOPSIS"
.IX Header "SYNOPSIS"
.Vb 1
\&  use DBI;
\&
\&  $dbh = DBI\->connect("dbi:InterBase:db=$dbname", "sysdba", "masterkey");
\&
\&  # See the DBI module documentation for full details
.Ve
.SH "DESCRIPTION"
.IX Header "DESCRIPTION"
DBD::InterBase is a Perl module which works with the \s-1DBI\s0 module to provide
access to Firebird and InterBase databases.
.SH "MODULE DOCUMENTATION"
.IX Header "MODULE DOCUMENTATION"
This documentation describes driver specific behavior and restrictions. 
It is not supposed to be used as the only reference for the user. In any 
case consult the \s-1DBI\s0 documentation first !
.SH "THE DBI CLASS"
.IX Header "THE DBI CLASS"
.Sh "\s-1DBI\s0 Class Methods"
.IX Subsection "DBI Class Methods"
.IP "\fBconnect\fR" 4
.IX Item "connect"
To connect to a database with a minimum of parameters, use the 
following syntax:
.Sp
.Vb 1
\&  $dbh = DBI\->connect("dbi:InterBase:dbname=$dbname", "sysdba", "masterkey");
.Ve
.Sp
This connects to the database \f(CW$dbname\fR at localhost as \s-1SYSDBA\s0 user with the
default password.
.Sp
Multiline \s-1DSN\s0 is acceptable. Here is an example of connect statement which uses all 
possible parameters:
.Sp
.Vb 9
\&   $dsn =<< "DSN";
\& dbi:InterBase:dbname=$dbname;
\& host=$host;
\& port=$port;
\& ib_dialect=$dialect;
\& ib_role=$role;
\& ib_charset=$charset;
\& ib_cache=$cache
\& DSN
\&
\& $dbh =  DBI\->connect($dsn, $username, $password);
.Ve
.Sp
The \f(CW$dsn\fR is prefixed by 'dbi:InterBase:', and consists of key-value
parameters separated by \fBsemicolons\fR. New line may be added after the
semicolon. The following is the list of valid parameters and their
respective meanings:
.Sp
.Vb 10
\&    parameter       meaning                                 optional?
\&    \-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-
\&    database        path to the database                    required
\&    dbname          path to the database
\&    db              path to the database
\&    hostname        hostname / IP address                   optional
\&    host            hostname / IP address
\&    port            port number                             optional
\&    ib_dialect      the SQL dialect to be used              optional
\&    ib_role         the role of the user                    optional
\&    ib_charset      character set to be used                optional
\&    ib_cache        number of database cache buffers        optional
\&    ib_dbkey_scope  change default duration of RDB$DB_KEY   optional
.Ve
.Sp
\&\fBdatabase\fR could be used interchangebly with \fBdbname\fR and \fBdb\fR. 
To connect to a remote host, use the \fBhost\fR parameter. 
Here is an example of \s-1DSN\s0 to connect to a remote Windows host:
.Sp
.Vb 1
\& $dsn = "dbi:InterBase:db=C:/temp/test.gdb;host=rae.cumi.org;ib_dialect=3";
.Ve
.Sp
Database file alias introduced in Firebird 1.5 can be used too. In the following 
example, \*(L"billing\*(R" is defined in aliases.conf:
.Sp
.Vb 1
\& $dsn = \*(Aqdbi:InterBase:hostname=192.168.88.5;db=billing;ib_dialect=3\*(Aq;
.Ve
.Sp
Firebird as of version 1.0 listens on port specified within the services
file. To connect to port other than the default 3050, add the port number at
the end of host name, separated by a slash. Example:
.Sp
.Vb 1
\& $dsn = \*(Aqdbi:InterBase:db=/data/test.gdb;host=localhost/3060\*(Aq;
.Ve
.Sp
InterBase 6.0 introduces \fB\s-1SQL\s0 dialect\fR to provide backward compatibility with
databases created by older versions of InterBase. In short, \s-1SQL\s0 dialect
controls how InterBase interprets:
.Sp
.Vb 4
\& \- double quotes
\& \- the DATE datatype
\& \- decimal and numeric datatypes
\& \- new 6.0 reserved keywords
.Ve
.Sp
Valid values for \fBib_dialect\fR are 1, 2, and 3. The driver's default value is
1.
.Sp
\&\fBib_role\fR specifies the role of the connecting user. \fB\s-1SQL\s0 role\fR is
implemented by InterBase to make database administration easier when dealing
with lots of users. A detailed reading can be found at:
.Sp
.Vb 1
\& http://www.ibphoenix.com/ibp_sqlroles.html
.Ve
.Sp
If \fBib_cache\fR is not specified, the default database's cache size value will be 
used. The InterBase Operation Guide discusses in full length the importance of 
this parameter to gain the best performance.
.IP "\fBavailable_drivers\fR" 4
.IX Item "available_drivers"
.Vb 1
\&  @driver_names = DBI\->available_drivers;
.Ve
.Sp
Implemented by \s-1DBI\s0, no driver-specific impact.
.IP "\fBdata_sources\fR" 4
.IX Item "data_sources"
This method is not yet implemented.
.IP "\fBtrace\fR" 4
.IX Item "trace"
.Vb 1
\&  DBI\->trace($trace_level, $trace_file)
.Ve
.Sp
Implemented by \s-1DBI\s0, no driver-specific impact.
.Sh "\s-1DBI\s0 Dynamic Attributes"
.IX Subsection "DBI Dynamic Attributes"
See Common Methods.
.SH "METHODS COMMON TO ALL DBI HANDLES"
.IX Header "METHODS COMMON TO ALL DBI HANDLES"
.IP "\fBerr\fR" 4
.IX Item "err"
.Vb 1
\&  $rv = $h\->err;
.Ve
.Sp
Supported by the driver as proposed by \s-1DBI\s0.
.IP "\fBerrstr\fR" 4
.IX Item "errstr"
.Vb 1
\&  $str = $h\->errstr;
.Ve
.Sp
Supported by the driver as proposed by \s-1DBI\s0.
.IP "\fBstate\fR" 4
.IX Item "state"
This method is not yet implemented.
.IP "\fBtrace\fR" 4
.IX Item "trace"
.Vb 1
\&  $h\->trace($trace_level, $trace_filename);
.Ve
.Sp
Implemented by \s-1DBI\s0, no driver-specific impact.
.IP "\fBtrace_msg\fR" 4
.IX Item "trace_msg"
.Vb 1
\&  $h\->trace_msg($message_text);
.Ve
.Sp
Implemented by \s-1DBI\s0, no driver-specific impact.
.IP "\fBfunc\fR" 4
.IX Item "func"
See \fBTransactions\fR section for information about invoking \f(CW\*(C`ib_set_tx_param()\*(C'\fR
from \fIfunc()\fR method.
.SH "ATTRIBUTES COMMON TO ALL DBI HANDLES"
.IX Header "ATTRIBUTES COMMON TO ALL DBI HANDLES"
.IP "\fBWarn\fR (boolean, inherited)" 4
.IX Item "Warn (boolean, inherited)"
Implemented by \s-1DBI\s0, no driver-specific impact.
.IP "\fBActive\fR (boolean, read-only)" 4
.IX Item "Active (boolean, read-only)"
Supported by the driver as proposed by \s-1DBI\s0. A database 
handle is active while it is connected and  statement 
handle is active until it is finished.
.IP "\fBKids\fR (integer, read-only)" 4
.IX Item "Kids (integer, read-only)"
Implemented by \s-1DBI\s0, no driver-specific impact.
.IP "\fBActiveKids\fR (integer, read-only)" 4
.IX Item "ActiveKids (integer, read-only)"
Implemented by \s-1DBI\s0, no driver-specific impact.
.IP "\fBCachedKids\fR (hash ref)" 4
.IX Item "CachedKids (hash ref)"
Implemented by \s-1DBI\s0, no driver-specific impact.
.IP "\fBCompatMode\fR (boolean, inherited)" 4
.IX Item "CompatMode (boolean, inherited)"
Not used by this driver.
.IP "\fBInactiveDestroy\fR (boolean)" 4
.IX Item "InactiveDestroy (boolean)"
Implemented by \s-1DBI\s0, no driver-specific impact.
.IP "\fBPrintError\fR (boolean, inherited)" 4
.IX Item "PrintError (boolean, inherited)"
Implemented by \s-1DBI\s0, no driver-specific impact.
.IP "\fBRaiseError\fR (boolean, inherited)" 4
.IX Item "RaiseError (boolean, inherited)"
Implemented by \s-1DBI\s0, no driver-specific impact.
.IP "\fBChopBlanks\fR (boolean, inherited)" 4
.IX Item "ChopBlanks (boolean, inherited)"
Supported by the driver as proposed by \s-1DBI\s0.
.IP "\fBLongReadLen\fR (integer, inherited)" 4
.IX Item "LongReadLen (integer, inherited)"
Supported by the driver as proposed by \s-1DBI\s0.The default value is 80 bytes.
.IP "\fBLongTruncOk\fR (boolean, inherited)" 4
.IX Item "LongTruncOk (boolean, inherited)"
Supported by the driver as proposed by \s-1DBI\s0.
.IP "\fBTaint\fR (boolean, inherited)" 4
.IX Item "Taint (boolean, inherited)"
Implemented by \s-1DBI\s0, no driver-specific impact.
.SH "DATABASE HANDLE OBJECTS"
.IX Header "DATABASE HANDLE OBJECTS"
.Sh "Database Handle Methods"
.IX Subsection "Database Handle Methods"
.IP "\fBselectrow_array\fR" 4
.IX Item "selectrow_array"
.Vb 1
\&  @row_ary = $dbh\->selectrow_array($statement, \e%attr, @bind_values);
.Ve
.Sp
Implemented by \s-1DBI\s0, no driver-specific impact.
.IP "\fBselectall_arrayref\fR" 4
.IX Item "selectall_arrayref"
.Vb 1
\&  $ary_ref = $dbh\->selectall_arrayref($statement, \e%attr, @bind_values);
.Ve
.Sp
Implemented by \s-1DBI\s0, no driver-specific impact.
.IP "\fBselectcol_arrayref\fR" 4
.IX Item "selectcol_arrayref"
.Vb 1
\&  $ary_ref = $dbh\->selectcol_arrayref($statement, \e%attr, @bind_values);
.Ve
.Sp
Implemented by \s-1DBI\s0, no driver-specific impact.
.IP "\fBprepare\fR" 4
.IX Item "prepare"
.Vb 1
\&  $sth = $dbh\->prepare($statement, \e%attr);
.Ve
.Sp
Supported by the driver as proposed by \s-1DBI\s0.
When AutoCommit is On, this method implicitly starts a new transaction,
which will be automatically committed after the following \fIexecute()\fR or the
last \fIfetch()\fR, depending on the statement type. For select statements,
commit automatically takes place after the last \fIfetch()\fR, or by explicitly 
calling \fIfinish()\fR method if there are any rows remaining. For non-select
statements, \fIexecute()\fR will implicitly commits the transaction.
.IP "\fBprepare_cached\fR" 4
.IX Item "prepare_cached"
.Vb 1
\&  $sth = $dbh\->prepare_cached($statement, \e%attr);
.Ve
.Sp
Implemented by \s-1DBI\s0, no driver-specific impact.
.IP "\fBdo\fR" 4
.IX Item "do"
.Vb 1
\&  $rv  = $dbh\->do($statement, \e%attr, @bind_values);
.Ve