---
name: "CPAN::SQLite::State"
section: "3pm"
platform: "linux"
package: "libcpan-sqlite-perl"
version: "0.220-1"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/CPAN::SQLite::State"
---

# CPAN::SQLite::State(3pm)

get state information on the database

## NAME

CPAN::SQLite::State - get state information on the database

## VERSION

version 0.220

## DESCRIPTION

This module gets information on the current state of the database and compares it to that obtained from the CPAN index files from *CPAN::SQLite::Info* and from the repositories from *CPAN::SQLite::PPM*. For each of the four tables *dists*, *mods*, *auths*, and *ppms*, two methods are used to get this information:

- •

  `"ids"`

  This method gets the ids of the relevant names, and versions, if applicable, in the table.

- •

  `"state"`

  This method compares the information in the tables obtained from the `"ids"` method to that from the CPAN indices and ppm repositories. One of three actions is then decided, which is subsequently acted upon in *CPAN::SQLite::Populate*.

  - •

    `"insert"`

    If the information in the indices is not in the database, this information is marked for insertion.

  - •

    `"update"`

    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.

  - •

    `"delete"`

    If the information in the database is no longer present in the indices, the information is marked for deletion.