---
name: "CPAN::SQLite::Util"
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::Util"
---

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

export some common data structures used by CPAN::SQLite::\*

## NAME

CPAN::SQLite::Util - export some common data structures used by CPAN::SQLite::\*

## VERSION

version 0.220

## DESCRIPTION

This module exports some common data structures used by other *CPAN::Search::Lite::\** modules. At present these are

- •

  `$table_id`

  This is a hash reference whose keys are the tables used and whose values are the associated primary keys.

- •

  `$full_id`

  This is a hash reference whose keys are the primary keys of the tables and whose values are the associated fully qualified primary keys (ie, with the table name prepended).

- •

  `$mode_info`

  This is a hash reference whose keys are the allowed modes of *CPAN::Search::Lite::Query* and whose associated values are hash references with keys `"id"`, `"name"`, and `"text"` describing what columns to use for that key.

- •

  `$query_info`

  This is a hash reference whose purpose is to provide shortcuts to making queries using *CPAN::Search::Lite::Query*. The keys of this reference is the shortcut name, and the associated value is a hash reference specifying the required *mode* and *type* keys.

- •

  `"vcmp"`

  This routine, used as

  ```
    if (vcmp($v1, $v2) > 0) {
      print "$v1 is higher than $v2\n";
    }
  ```

  is used to compare two versions, and returns 1/0/-1 if the first argument is considered higher/equal/lower than the second. It uses `"Sort::Versions"`.