| Name : perl-SQL-Abstract-More
| |
| Version : 1.43
| Vendor : obs://build_opensuse_org/devel:languages:perl
|
| Release : 1.3
| Date : 2024-08-05 20:16:45
|
| Group : Unspecified
| Source RPM : perl-SQL-Abstract-More-1.43-1.3.src.rpm
|
| Size : 0.11 MB
| |
| Packager : (none)
| |
| Summary : extension of SQL::Abstract with more constructs and more flexible API
|
Description :
This module generates SQL from Perl data structures. It is a subclass of
SQL::Abstract::Classic or SQL::Abstract, fully compatible with the parent
class, but with many improvements :
* methods take arguments as _named parameters_ instead of positional
parameters. This is more flexible for identifying and assembling various
SQL clauses, like \'-where\', \'-order_by\', \'-group_by\', etc.
* additional SQL constructs like \'-union\', \'-group_by\', \'join\',
\'-with_recursive\', etc. are supported
* subqueries can be used in a column list or as a datasource (i.e \'SELECT ...
FROM (SELECT ..)\')
* \'WHERE .. IN\' clauses can range over multiple columns (tuples)
* values passed to \'select\', \'insert\' or \'update\' can directly incorporate
information about datatypes, in the form of arrayrefs of shape \'[{dbd_attrs
=> \\%type}, $value]\'
* several _SQL dialects_ can adapt the generated SQL to various DBMS vendors
This module was designed for the specific needs of DBIx::DataModel, but is
published as a standalone distribution, because it may possibly be useful
for other needs.
Unfortunately, this module cannot be used with DBIx::Class, because
\'DBIx::Class\' creates its own instance of \'SQL::Abstract\' and has no API to
let the client instantiate from any other class.
|
RPM found in directory: /packages/linux-pbone/ftp5.gwdg.de/pub/opensuse/repositories/devel:/languages:/perl:/CPAN-S/openSUSE_Tumbleweed/noarch |
