.\" Automatically generated by Pod::Man 4.11 (Pod::Simple 3.35)
.\"
.\" 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" ''
.    ds C`
.    ds C'
'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 >0, 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.
.\"
.\" Avoid warning from groff about undefined register 'F'.
.de IX
..
.nr rF 0
.if \n(.g .if rF .nr rF 1
.if (\n(rF:(\n(.g==0)) \{\
.    if \nF \{\
.        de IX
.        tm Index:\\$1\t\\n%\t"\\$2"
..
.        if !\nF==2 \{\
.            nr % 0
.            nr F 2
.        \}
.    \}
.\}
.rr rF
.\" ========================================================================
.\"
.IX Title "CPAN::SQLite::State 3pm"
.TH CPAN::SQLite::State 3pm "2020-06-03" "perl v5.30.2" "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"
CPAN::SQLite::State \- get state information on the database
.SH "VERSION"
.IX Header "VERSION"
version 0.219
.SH "DESCRIPTION"
.IX Header "DESCRIPTION"
This module gets information on the current state of the
database and compares it to that obtained from the \s-1CPAN\s0
index files from \fICPAN::SQLite::Info\fR and from the
repositories from \fICPAN::SQLite::PPM\fR. For each of the
four tables \fIdists\fR, \fImods\fR, \fIauths\fR, and \fIppms\fR,
two methods are used to get this information:
.IP "\(bu" 3
\&\f(CW\*(C`ids\*(C'\fR
.Sp
This method gets the ids of the relevant names, and
versions, if applicable, in the table.
.IP "\(bu" 3
\&\f(CW\*(C`state\*(C'\fR
.Sp
This method compares the information in the tables
obtained from the \f(CW\*(C`ids\*(C'\fR method to that from the
\&\s-1CPAN\s0 indices and ppm repositories. One of three actions
is then decided, which is subsequently acted upon in
\&\fICPAN::SQLite::Populate\fR.
.RS 3
.IP "\(bu" 3
\&\f(CW\*(C`insert\*(C'\fR
.Sp
If the information in the indices is not in the
database, this information is marked for insertion.
.IP "\(bu" 3
\&\f(CW\*(C`update\*(C'\fR
.Sp
If the information in the database is older than that
form the indices (generally, this means an older version),
the information is marked for updating.
.IP "\(bu" 3
\&\f(CW\*(C`delete\*(C'\fR
.Sp
If the information in the database is no longer present
in the indices, the information is marked for deletion.
.RE
.RS 3
.RE