This software provides a Class::DBI library for Fry::Shell that presents multiple database queries in a structured outline style.
Fry::Lib::CDBI::Outline is a Perl class::DBI library designed for Fry::Shell, which offers a convenient way to display several database queries in an outline format. The module includes one command, outlineSearches, which is used to take a query outline and produce results in the same outline format.
To make writing an outline simpler for command-line apps, there is a shorthand syntax offered. For instance, a sample outline of 0 dog, 1 rex, 1 cartoon, 2 snoopy, 2 brian, 0 cat, would be written as 'dog(rex,cartoon(snoopy,brian))cat'. Note that the numbers indicating the outline levels are not seen, as they are used for organizational purposes.
Each node in the query is considered a query chunk and follows the same syntax as the search commands in Fry::Lib::CDBI::Basic. There are three characters that delimit indent levels between nodes: '(' indicates that the following node is indented one level, ')' shows that the following node is unindented one level, while ',' shows that the following node remains at the same level.
The resulting outline shows results under the last level children. By default, the query chunks are ANDed. However, if no $splitter ('=' here) is used in a given query chunk, then a default column name is assumed by $otlcol. For instance, $otlcol='tags' for the 'read' node in the example given.
While Fry::Lib::CDBI::Outline can be used for any table format, it is most commonly used for tagging tables. Refer to Fry::Lib::CDBI::Tags for more detailed information on this.
To make writing an outline simpler for command-line apps, there is a shorthand syntax offered. For instance, a sample outline of 0 dog, 1 rex, 1 cartoon, 2 snoopy, 2 brian, 0 cat, would be written as 'dog(rex,cartoon(snoopy,brian))cat'. Note that the numbers indicating the outline levels are not seen, as they are used for organizational purposes.
Each node in the query is considered a query chunk and follows the same syntax as the search commands in Fry::Lib::CDBI::Basic. There are three characters that delimit indent levels between nodes: '(' indicates that the following node is indented one level, ')' shows that the following node is unindented one level, while ',' shows that the following node remains at the same level.
The resulting outline shows results under the last level children. By default, the query chunks are ANDed. However, if no $splitter ('=' here) is used in a given query chunk, then a default column name is assumed by $otlcol. For instance, $otlcol='tags' for the 'read' node in the example given.
While Fry::Lib::CDBI::Outline can be used for any table format, it is most commonly used for tagging tables. Refer to Fry::Lib::CDBI::Tags for more detailed information on this.
What's New
Version 0.15: N/A