/ 
TableDataRole-Source-SQLite-0.001
River stage zero No dependents
/ TableData::SQLite

NAME

TableData::SQLite - Get table data from SQLite database

VERSION

This document describes version 0.001 of TableData::SQLite (from Perl distribution TableDataRole-Source-SQLite), released on 2024-05-14.

SYNOPSIS

use TableData::SQLite;

my $table = TableData::SQLite->new(
    sth           => $dbh->prepare("SELECT * FROM mytable"),
    row_count_sth => $dbh->prepare("SELECT COUNT(*) FROM table"),
);

# or
my $table = TableData::DBI->new(
    filename      => "/home/ujang/albums.db",
    table         => "mytable",
);

DESCRIPTION

This is a TableData:: module to table data from a SQLite query/table.

METHODS

new

Usage:

new(%args) -> [$status_code, $reason, $payload, \%result_meta]

This function is not exported.

Arguments ('*' denotes required arguments):

  • dbh => obj

    (No description)

  • filename => filename

    (No description)

  • query => str

    (No description)

  • row_count_query => obj

    (No description)

  • row_count_sth => obj

    (No description)

  • row_count_sth_bind_params => array

    (No description)

  • sth => obj

    (No description)

  • sth_bind_params => array

    (No description)

  • table => str

    (No description)

Returns an enveloped result (an array).

First element ($status_code) is an integer containing HTTP-like status code (200 means OK, 4xx caller error, 5xx function error). Second element ($reason) is a string containing error message, or something like "OK" if status is 200. Third element ($payload) is the actual result, but usually not present when enveloped result is an error response ($status_code is not 2xx). Fourth element (%result_meta) is called result metadata and is optional, a hash that contains extra information, much like how HTTP response headers provide additional metadata.

Return value: (any)

HOMEPAGE

Please visit the project's homepage at https://metacpan.org/release/TableDataRole-Source-SQLite.

SOURCE

Source repository is at https://github.com/perlancar/perl-TableDataRole-Source-SQLite.

SEE ALSO

More general module: TableData::DBI

DBD::SQLite

TableData

AUTHOR

perlancar <perlancar@cpan.org>

CONTRIBUTING

To contribute, you can send patches by email/via RT, or send pull requests on GitHub.

Most of the time, you don't need to build the distribution yourself. You can simply modify the code, then test via:

% prove -l

If you want to build the distribution (e.g. to try to install it locally on your system), you can install Dist::Zilla, Dist::Zilla::PluginBundle::Author::PERLANCAR, Pod::Weaver::PluginBundle::Author::PERLANCAR, and sometimes one or two other Dist::Zilla- and/or Pod::Weaver plugins. Any additional steps required beyond that are considered a bug and can be reported to me.

COPYRIGHT AND LICENSE

This software is copyright (c) 2024 by perlancar <perlancar@cpan.org>.

This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.

BUGS

Please report any bugs or feature requests on the bugtracker website https://rt.cpan.org/Public/Dist/Display.html?Name=TableDataRole-Source-SQLite

When submitting a bug or request, please include a test-file or a patch to an existing test-file that illustrates the bug or desired feature.