view release on metacpan or  search on metacpan

lib/App/BPOMUtils/Table/Input.pm  view on Meta::CPAN

=encoding UTF-8

=head1 NAME

App::BPOMUtils::Table::Input - List of basic characteristic and heavy metal pollutant references in BPOM processed food division

=head1 VERSION

This document describes version 0.015 of App::BPOMUtils::Table::Input (from Perl distribution App-BPOMUtils-Table), released on 2023-01-20.

=head1 FUNCTIONS


=head2 bpom_list_food_inputs

Usage:

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

List of basic characteristic and heavy metal pollutant references in BPOM processed food division.

This function is not exported.

Arguments ('*' denotes required arguments):

=over 4

=item * B<category> => I<str>

Only return records where the 'category' field equals specified value.

=item * B<category.contains> => I<str>

Only return records where the 'category' field contains specified text.

=item * B<category.in> => I<array[str]>

Only return records where the 'category' field is in the specified values.

=item * B<category.is> => I<str>

Only return records where the 'category' field equals specified value.

=item * B<category.isnt> => I<str>

Only return records where the 'category' field does not equal specified value.

=item * B<category.matches> => I<str>

Only return records where the 'category' field matches specified regular expression pattern.

=item * B<category.max> => I<str>

Only return records where the 'category' field is less than or equal to specified value.

=item * B<category.min> => I<str>

Only return records where the 'category' field is greater than or equal to specified value.

=item * B<category.not_contains> => I<str>

Only return records where the 'category' field does not contain specified text.

=item * B<category.not_in> => I<array[str]>

Only return records where the 'category' field is not in the specified values.

=item * B<category.not_matches> => I<str>

Only return records where the 'category' field does not match specified regular expression.

=item * B<category.xmax> => I<str>

Only return records where the 'category' field is less than specified value.

=item * B<category.xmin> => I<str>

Only return records where the 'category' field is greater than specified value.

=item * B<characteristic> => I<str>

Only return records where the 'characteristic' field equals specified value.

=item * B<characteristic.contains> => I<str>

Only return records where the 'characteristic' field contains specified text.

=item * B<characteristic.in> => I<array[str]>

Only return records where the 'characteristic' field is in the specified values.

=item * B<characteristic.is> => I<str>

Only return records where the 'characteristic' field equals specified value.

=item * B<characteristic.isnt> => I<str>

Only return records where the 'characteristic' field does not equal specified value.

=item * B<characteristic.matches> => I<str>

Only return records where the 'characteristic' field matches specified regular expression pattern.

=item * B<characteristic.max> => I<str>

Only return records where the 'characteristic' field is less than or equal to specified value.

=item * B<characteristic.min> => I<str>

Only return records where the 'characteristic' field is greater than or equal to specified value.

=item * B<characteristic.not_contains> => I<str>

Only return records where the 'characteristic' field does not contain specified text.

=item * B<characteristic.not_in> => I<array[str]>

Only return records where the 'characteristic' field is not in the specified values.

=item * B<characteristic.not_matches> => I<str>

Only return records where the 'characteristic' field does not match specified regular expression.

=item * B<characteristic.xmax> => I<str>

Only return records where the 'characteristic' field is less than specified value.

=item * B<characteristic.xmin> => I<str>

Only return records where the 'characteristic' field is greater than specified value.

=item * B<detail> => I<bool> (default: 0)

Return array of full records instead of just ID fields.

By default, only the key (ID) field is returned per result entry.

=item * B<exclude_fields> => I<array[str]>

Select fields to return.

=item * B<fields> => I<array[str]>

Select fields to return.

=item * B<id> => I<int>

Only return records where the 'id' field equals specified value.

=item * B<id.in> => I<array[int]>

Only return records where the 'id' field is in the specified values.

=item * B<id.is> => I<int>

Only return records where the 'id' field equals specified value.

=item * B<id.isnt> => I<int>

Only return records where the 'id' field does not equal specified value.

=item * B<id.max> => I<int>

Only return records where the 'id' field is less than or equal to specified value.

=item * B<id.min> => I<int>

Only return records where the 'id' field is greater than or equal to specified value.

=item * B<id.not_in> => I<array[int]>

Only return records where the 'id' field is not in the specified values.

=item * B<id.xmax> => I<int>

Only return records where the 'id' field is less than specified value.

=item * B<id.xmin> => I<int>

Only return records where the 'id' field is greater than specified value.

=item * B<lower_limit> => I<str>

Only return records where the 'lower_limit' field equals specified value.

=item * B<lower_limit.contains> => I<str>

Only return records where the 'lower_limit' field contains specified text.

=item * B<lower_limit.in> => I<array[str]>

Only return records where the 'lower_limit' field is in the specified values.

=item * B<lower_limit.is> => I<str>

Only return records where the 'lower_limit' field equals specified value.

=item * B<lower_limit.isnt> => I<str>

Only return records where the 'lower_limit' field does not equal specified value.

=item * B<lower_limit.matches> => I<str>

Only return records where the 'lower_limit' field matches specified regular expression pattern.

=item * B<lower_limit.max> => I<str>

Only return records where the 'lower_limit' field is less than or equal to specified value.

=item * B<lower_limit.min> => I<str>

Only return records where the 'lower_limit' field is greater than or equal to specified value.

=item * B<lower_limit.not_contains> => I<str>

Only return records where the 'lower_limit' field does not contain specified text.

=item * B<lower_limit.not_in> => I<array[str]>

Only return records where the 'lower_limit' field is not in the specified values.

=item * B<lower_limit.not_matches> => I<str>

Only return records where the 'lower_limit' field does not match specified regular expression.

=item * B<lower_limit.xmax> => I<str>

Only return records where the 'lower_limit' field is less than specified value.

=item * B<lower_limit.xmin> => I<str>

Only return records where the 'lower_limit' field is greater than specified value.

=item * B<queries> => I<array[str]>

Search.

This will search all searchable fields with one or more specified queries. Each
query can be in the form of C<-FOO> (dash prefix notation) to require that the
fields do not contain specified string, or C</FOO/> to use regular expression.
All queries must match if the C<query_boolean> option is set to C<and>; only one
query should match if the C<query_boolean> option is set to C<or>.

=item * B<query_boolean> => I<str> (default: "and")

Whether records must match all search queries ('and') or just one ('or').

If set to C<and>, all queries must match; if set to C<or>, only one query should
match. See the C<queries> option for more details on searching.

=item * B<random> => I<bool> (default: 0)

Return records in random order.

=item * B<result_limit> => I<int>

Only return a certain number of records.

=item * B<result_start> => I<int> (default: 1)

Only return starting from the n'th record.

=item * B<sort> => I<array[str]>

Order records according to certain field(s).

A list of field names separated by comma. Each field can be prefixed with '-' to
specify descending order instead of the default ascending.

=item * B<upper_limit> => I<str>

Only return records where the 'upper_limit' field equals specified value.

=item * B<upper_limit.contains> => I<str>

Only return records where the 'upper_limit' field contains specified text.

=item * B<upper_limit.in> => I<array[str]>

Only return records where the 'upper_limit' field is in the specified values.

=item * B<upper_limit.is> => I<str>

Only return records where the 'upper_limit' field equals specified value.

=item * B<upper_limit.isnt> => I<str>

Only return records where the 'upper_limit' field does not equal specified value.

=item * B<upper_limit.matches> => I<str>

Only return records where the 'upper_limit' field matches specified regular expression pattern.

=item * B<upper_limit.max> => I<str>

Only return records where the 'upper_limit' field is less than or equal to specified value.

=item * B<upper_limit.min> => I<str>

Only return records where the 'upper_limit' field is greater than or equal to specified value.

=item * B<upper_limit.not_contains> => I<str>

Only return records where the 'upper_limit' field does not contain specified text.

=item * B<upper_limit.not_in> => I<array[str]>

Only return records where the 'upper_limit' field is not in the specified values.

=item * B<upper_limit.not_matches> => I<str>

Only return records where the 'upper_limit' field does not match specified regular expression.

=item * B<upper_limit.xmax> => I<str>

Only return records where the 'upper_limit' field is less than specified value.

=item * B<upper_limit.xmin> => I<str>

Only return records where the 'upper_limit' field is greater than specified value.

=item * B<with_field_names> => I<bool>

Return field names in each record (as hashE<sol>associative array).

When enabled, function will return each record as hash/associative array
(field name => value pairs). Otherwise, function will return each record
as list/array (field value, field value, ...).


=back

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)

=head1 HOMEPAGE

Please visit the project's homepage at L<https://metacpan.org/release/App-BPOMUtils-Table>.

=head1 SOURCE

Source repository is at L<https://github.com/perlancar/perl-App-BPOMUtils-Table>.

=head1 AUTHOR

perlancar <perlancar@cpan.org>

=head1 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 L<Dist::Zilla>,
L<Dist::Zilla::PluginBundle::Author::PERLANCAR>,
L<Pod::Weaver::PluginBundle::Author::PERLANCAR>, and sometimes one or two other