Perinci::Sub::Gen::AccessTable::Simple - Generate function (and its metadata) to read table data


This document describes version 0.002 of Perinci::Sub::Gen::AccessTable::Simple (from Perl distribution Perinci-Sub-Gen-AccessTable-Simple), released on 2020-10-28.



 use strict;
 use warnings;
 use Perinci::CmdLine;
 use Perinci::Sub::Gen::AccessTable::Simple qw(gen_read_table_func);

 our %SPEC;

 my $countries = [
     ['cn', 'China', 'Cina'],
     ['id', 'Indonesia', 'Indonesia'],
     ['sg', 'Singapore', 'Singapura'],
     ['us', 'United States of America', 'Amerika Serikat'],

 my $res = gen_read_table_func(
     name          => 'list_countries',
     summary       => 'func summary',     # optional
     description   => 'func description', # optional
     table_data    => $countries,
     field_names   => [qw/code en_name id_name/],
     filter_fields => ['code'],
 die "Can't generate function: $res->[0] - $res->[1]" unless $res->[0] == 200;


Now you can do:

 # list all countries
 | en_name                  | code | id_name         |
 | China                    | cn   | Indonesia       |
 | Indonesia                | id   | Indonesia       |
 | Singapore                | sg   | Singapura       |
 | United States of America | us   | Amerika Serikat |

 # filter by code
 % --code id
 | en_name   | code | id_name   |
 | Indonesia | id   | Indonesia |

 # unknown code
 % --code xx

 # output json
 % --code id --json
 [200, "OK", [{"en_name":"Indonesia","code":"id","id_name":"Indonesia"}]


This module is like Perinci::Sub::Gen::AccessTable, but simpler. No table spec is needed, only list of fields (field_names). The function does not do sorting or paging. Only the simplest filter (exact matching) is created.

Some other differences:

  • Table data must be AoAoS (array of array of scalars)

    AoH or coderef not accepted.

  • Function returns AoHoS, records are returned as HoS (hash of scalars)




 gen_read_table_func(%args) -> [status, msg, payload, meta]

Generate function (and its metadata) to read table data.

The generated function acts like a simple single table SQL SELECT query, featuring filtering by zero or more fields (exact matching). For more features, see the Perinci::Sub::Gen::AccessTable variant. This routine is a simplified version.

The resulting function returns an array of hashrefs and accepts these arguments.

  • Filter arguments

    They will be generated for each field specified in filter_fields.

This function is not exported by default, but exportable.

Arguments ('*' denotes required arguments):

  • case_insensitive_comparison => bool

  • field_names* => array[str]

  • filter_fields => array[str]

  • table_data* => array[array]

Returns an enveloped result (an array).

First element (status) is an integer containing HTTP status code (200 means OK, 4xx caller error, 5xx function error). Second element (msg) is a string containing error message, or 'OK' if status is 200. Third element (payload) is optional, the actual result. Fourth element (meta) is called result metadata and is optional, a hash that contains extra information.

Return value: A hash containing generated function, metadata (hash)



Please visit the project's homepage at


Source repository is at


Please report any bugs or feature requests on the bugtracker website

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.




perlancar <>


This software is copyright (c) 2020 by

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