| Index | index by Group | index by Distribution | index by Vendor | index by creation date | index by Name | Mirrors | Help | Search |
| Name: perl-SQL-Abstract | Distribution: SUSE Linux Enterprise 15 SP3 |
| Version: 1.85 | Vendor: openSUSE |
| Release: bp153.1.16 | Build date: Sat Mar 6 09:42:40 2021 |
| Group: Development/Libraries/Perl | Build host: sheep87 |
| Size: 239557 | Source RPM: perl-SQL-Abstract-1.85-bp153.1.16.src.rpm |
| Packager: https://bugs.opensuse.org | |
| Url: http://search.cpan.org/dist/SQL-Abstract/ | |
| Summary: Generate SQL from Perl data structures | |
This module was inspired by the excellent DBIx::Abstract. However, in using
that module I found that what I really wanted to do was generate SQL, but
still retain complete control over my statement handles and use the DBI
interface. So, I set out to create an abstract SQL generation module.
While based on the concepts used by DBIx::Abstract, there are several
important differences, especially when it comes to WHERE clauses. I have
modified the concepts used to make the SQL easier to generate from Perl
data structures and, IMO, more intuitive. The underlying idea is for this
module to do what you mean, based on the data structures you provide it.
The big advantage is that you don't have to modify your code every time
your data changes, as this module figures it out.
To begin with, an SQL INSERT is as easy as just specifying a hash of
'key=value' pairs:
my %data = (
name => 'Jimbo Bobson',
phone => '123-456-7890',
address => '42 Sister Lane',
city => 'St. Louis',
state => 'Louisiana',
);
The SQL can then be generated with this:
my($stmt, @bind) = $sql->insert('people', \%data);
Which would give you something like this:
$stmt = "INSERT INTO people
(address, city, name, phone, state)
VALUES (?, ?, ?, ?, ?)";
@bind = ('42 Sister Lane', 'St. Louis', 'Jimbo Bobson',
'123-456-7890', 'Louisiana');
These are then used directly in your DBI code:
my $sth = $dbh->prepare($stmt);
$sth->execute(@bind);
Artistic-1.0 or GPL-1.0+
* Wed Jan 31 2018 coolo@suse.com
- updated to 1.85
see /usr/share/doc/packages/perl-SQL-Abstract/Changes
1.85 - 2018-01-27
- Restore perl version requirement missed in the Distar port
- Factor out the SET ... part of UPDATE for subclassability (GH#12)
* Tue Apr 04 2017 coolo@suse.com
- updated to 1.84
see /usr/share/doc/packages/perl-SQL-Abstract/Changes
1.84 - 2017-04-03
- Restore 'dynamic_config => 0' missed in the Distar port
1.83 - 2017-04-03
- Support for DELETE ... RETURNING (GH#9)
- Port to Distar
* Tue Mar 21 2017 coolo@suse.com
- updated to 1.82
see /usr/share/doc/packages/perl-SQL-Abstract/Changes
revision 1.82 2017-03-20
- ------------------------
- Add explicit dependency on Sub::Quote (GH#8)
- Fix syntax errors in ORDER BY docs (GH#7)
revision 1.81_01 2017-02-28
- ---------------------------
- Fix order clauses with bind parameters in ->where
- Fix ->insert($table, \@values) with >26 values (RT#112684)
- Teach ::Tree that ILIKE (PostgreSQL) and REGEXP (MySQL) are binary ops
- Support for UPDATE ... RETURNING
- Documentation improvements for ORDER BY
* Wed Nov 12 2014 coolo@suse.com
- updated to 1.81
- Fix overly-enthusiastic parenthesis unroller (RT#99503)
revision 1.80 2014-10-05
- ---------------------------
- Fix erroneous behavior of is_literal_value($) wrt { -ident => ... }
- Explicitly croak on top-level special ops (they didn't work anyway)
revision 1.79 2014-09-25
- ---------------------------
- New exportable functions: is_literal_value($) and is_plain_value($)
- New attribute 'escape_char' allowing for proper escape of quote_chars
present in an identifier
- Deprecate { "" => \... } constructs
- Treat { -value => undef } as plain undef in all cases
- Explicitly throw on { -ident => undef }
* Mon Sep 15 2014 coolo@suse.com
- updated to 1.78
- Fix parsing of binary ops to correctly take up only a single LHS
element, instead of gobbling up the entire parse-to-date
- Explicitly handle ROW_NUMBER() OVER as the snowflake-operator it is
- Improve signatures/documentation of is_same_sql_bind / eq_sql_bind
- Retire script/format-sql - the utility needs more work to be truly
end-user convenient
* Mon Feb 24 2014 coolo@suse.com
- updated to 1.77
- Reintroduce { -not => undef } column operator (regression from 1.75)
- *UPCOMING INCOMPATIBLE BUGFIX*: SQLA used to generate incorrect SQL
on undef-containing lists fed to -in and -not_in. An exception will
be raised for a while before properly fixing this, to avoid quiet
but subtle changes to query results in production
- Deprecate and warn when supplying an empty arrayref to like/not_like
operators (likely to be removed before 2.0)
- Warn when using an inequality operator with a multi-value array to
arrive at what amounts to a 1=1 condition (no pre-2.0 plans to fix
this behavior due to backwards comp concerns)
- Fix false negative comparison of ORDER BY <function> ASC
- More improvements of incorrect parsing (placeholder at end of list
element)
- Fix typos in POD and comments (RT#87776)
- Augment -not_bool example with nesting (RT#89601)
* Sat Jul 27 2013 coolo@suse.com
- updated to 1.74
- Fix insufficient parenthesis unroll during operator comparison
- 'ORDER BY foo' and 'ORDER BY foo ASC' are now considered equal
by default (with a switch to reenable old behavior when necessary)
- Change parser to not eagerly slurp RHS expressions it doesn't recognize
* Tue Jun 04 2013 coolo@suse.com
- updated to 1.73
- Fix parsing of ORDER BY foo + ?
- Stop filling in placeholders in `format-sql` since it does not support
passing values for them anyway
- Fix parsing of NOT EXISTS
- Fix over-eager parenthesis unrolling
- Fix deep recursion warnings while parsing obnoxiously long sql statements
- Fix incorrect comparison of malformed lists
- Fix incorrect reporting of mismatch-members in SQLA::Test
- Migrate the -ident operator from DBIC into SQLA
- Migrate the -value operator from DBIC into SQLA
* Thu Mar 31 2011 coolo@novell.com
- update to 1.72
* lots of changes, see Changes
* Wed Dec 01 2010 coolo@novell.com
- switch to perl_requires macro
/usr/lib/perl5/vendor_perl/5.26.1/DBIx /usr/lib/perl5/vendor_perl/5.26.1/DBIx/Class /usr/lib/perl5/vendor_perl/5.26.1/DBIx/Class/Storage /usr/lib/perl5/vendor_perl/5.26.1/DBIx/Class/Storage/Debug /usr/lib/perl5/vendor_perl/5.26.1/DBIx/Class/Storage/Debug/PrettyPrint.pm /usr/lib/perl5/vendor_perl/5.26.1/SQL /usr/lib/perl5/vendor_perl/5.26.1/SQL/Abstract /usr/lib/perl5/vendor_perl/5.26.1/SQL/Abstract.pm /usr/lib/perl5/vendor_perl/5.26.1/SQL/Abstract/Test.pm /usr/lib/perl5/vendor_perl/5.26.1/SQL/Abstract/Tree.pm /usr/lib/perl5/vendor_perl/5.26.1/x86_64-linux-thread-multi /usr/share/doc/packages/perl-SQL-Abstract /usr/share/doc/packages/perl-SQL-Abstract/Changes /usr/share/doc/packages/perl-SQL-Abstract/README /usr/share/doc/packages/perl-SQL-Abstract/examples /usr/share/doc/packages/perl-SQL-Abstract/examples/console.pl /usr/share/doc/packages/perl-SQL-Abstract/examples/dbic-console.pl /usr/share/doc/packages/perl-SQL-Abstract/examples/sqla-format /usr/share/man/man3/DBIx::Class::Storage::Debug::PrettyPrint.3pm.gz /usr/share/man/man3/SQL::Abstract.3pm.gz /usr/share/man/man3/SQL::Abstract::Test.3pm.gz /usr/share/man/man3/SQL::Abstract::Tree.3pm.gz
Generated by rpm2html 1.8.1
Fabrice Bellet, Tue Apr 9 14:50:04 2024