Publisher review:Relations-Family module is a DBI/DBD::mysql relational query engine object. With Relations::Family you can create a 'family' of members for querying records. A member could be a table, or it could be a query on a table, like all the different months from a table's date field. Once the members are created, you can specify how those members are related, who's using who as a foreign key lookup, and what values in members you might be interested in reporting on, like whether a customer has paid their bill.
Once the 'family' is complete, you can select records from one member, and the query all the matching records from another member. For example, say you a product table being used as a lookup for a order items tables, and you want to find all the order items for a certain product. You can select that product's record from the product member, and then view the order item records to find all the order items for that product.
You can also build a large query for report purposes using the selections from various members as well as values you might be interested in. For example, say you want to know which customer are paid up and how much business they've generated in the past. You can specify which members' selections you want to use to narrow down the report and which values you'd like in the report and then use the query returned to see who's paid and for how much.
Relations-Family 0.94 is a Perl script for Perl Modules scripts design by George A. Fitch III.
It runs on following operating system: Windows / Linux / Mac OS / BSD / Solaris.
Relations-Family module is a DBI/DBD::mysql relational query engine object.
Operating system:Windows / Linux / Mac OS / BSD / Solaris