Index | index by Group | index by Distribution | index by Vendor | index by creation date | index by Name | Mirrors | Help | Search |
Name: perl-SQL-Statement | Distribution: openSUSE Leap 15.2 |
Version: 1.412 | Vendor: openSUSE |
Release: lp152.3.2 | Build date: Fri Sep 20 19:34:13 2019 |
Group: Development/Libraries/Perl | Build host: lamb18 |
Size: 537844 | Source RPM: perl-SQL-Statement-1.412-lp152.3.2.src.rpm |
Packager: https://bugs.opensuse.org | |
Url: http://search.cpan.org/dist/SQL-Statement/ | |
Summary: SQL parsing and processing engine |
The SQL::Statement module implements a pure Perl SQL parsing and execution engine. While it by no means implements full ANSI standard, it does support many features including column and table aliases, built-in and user-defined functions, implicit and explicit joins, complex nested search conditions, and other features. SQL::Statement is a small embeddable Database Management System (DBMS). This means that it provides all of the services of a simple DBMS except that instead of a persistent storage mechanism, it has two things: 1) an in-memory storage mechanism that allows you to prepare, execute, and fetch from SQL statements using temporary tables and 2) a set of software sockets where any author can plug in any storage mechanism. There are three main uses for SQL::Statement. One or another (hopefully not all) may be irrelevant for your needs: 1) to access and manipulate data in CSV, XML, and other formats 2) to build your own DBD for a new data source 3) to parse and examine the structure of SQL statements.
Artistic-1.0 or GPL-1.0+
* Fri Apr 07 2017 coolo@suse.com - updated to 1.412 see /usr/share/doc/packages/perl-SQL-Statement/Changes 1.412 2017-04-06 * Release 1.411_001 without further changes as 1.412 1.411_001 2017-03-30 [Bug fixes] * Fix http://www.perlmonks.org/?node_id=1167381 (NumericEval: fix typo on error handling) (thanks to Yanick Champoux, James R. Leu) * fix repo url and t/02execute.t (Reini Urban, Mohammad S Anwar) * fix test failing with blead-perl (Jens Rehsack) [Improvements] * Refactor constraints processing (Ovidiu Gheorghies) * Support parsing of complex JOIN clause (containing OR and ()'s) (James R. Leu) * handle backtick quoting (Ben Hengst) * Tue Apr 12 2016 coolo@suse.com - updated to 1.410 see /usr/share/doc/packages/perl-SQL-Statement/Changes 1.410 2016-04-11 [Bug fixes] * Fix RT#113625 - Unnecessary x-bits (Kent Fredric) [Documentation] * pod2markdown README.md from lib/SQL/Statement.pm * Thu Apr 07 2016 coolo@suse.com - updated to 1.409 see /usr/share/doc/packages/perl-SQL-Statement/Changes 1.409 2016-04-06 * Release 1.408_001 without further changes as 1.409 1.408_001 2016-03-07 [Bug fixes] * Fix RT#112530 - t/06virtual.t fails with -Duselongdouble (thanks Slaven Rezic) * Fix RT#105852 - dependency installation isn't triggered properly in cpan (thanks Mithaldu) * Fix RT#99349 - bind variables are not bound to placeholders in the correct order (thanks vulpeculus@gmx.de) [Documentation] * Update Copyright statements, add where missing (according to records) * Add license conditions where missing * bundle copy of license conditions to distribution * Sat Oct 10 2015 coolo@suse.com - updated to 1.407 see /usr/share/doc/packages/perl-SQL-Statement/Changes * Tue Jun 18 2013 coolo@suse.com - updated to 1.405 [Bug fixes] * INSERT now expands incomplete rows (Thanks to H.Merijn Brand) Version 1.404, released May 23, 2013 - ------------------------------------------------ [Bug fixes] * re-enable cleanup test_output* after test done * recommend Text::Soundex and do soundex-test only when have it, because it's going to be removed from core for Perl 5.19 (thank Merijn) Version 1.403, released May 22, 2013 - ------------------------------------------------ [Bug fixes] * fix documentation (rt#84889 - thanks Xavier Guimard and Florian, rt#85257 - thanks Andreas Koenig) Version 1.402, released December 19, 2012 - ------------------------------------------------ [Misc] * add Math::Complex 1.56 as recommendation (RT#81926, Sam Ferencik) * add Math::BigInt 1.88 as recommendation (RT#81927, Sam Ferencik) * clarify Test::Simple 1.90 is required for building (RT#81925, Sam Ferencik) [Bug fixes] * fix leaking reference to open tables outside SQL::Statement::execute (fixes RT#81523) * looks_like_number identifies 'nan' as number sometimes (add regex to t/06virtual.t) * Thu Mar 31 2011 coolo@novell.com - update to 1.33 [Bug fixes] * Move test dependencies to (unreleased) Bundle::Test::SQL::Statement to avoid circular dependencies * Fixed invalid check for escaped single quotes * Fixed unpermitted modification of array source for table creation (CREATE TABLE AS IMPORT(?),[[..],[..]]) * Fixing alias used in ORDER BY (RT#61384, thanks jvm) * Fixing ORDER BY behavior for multiple sort columns (slower, but guaranteed correct) [Improvements] * renamed fetch-method into fetch_row (keep fetch() as alias) and add a fetch_rows() to fetch all rows at once * Different accessors for direction of ORDER BY clause query part and it's boolean equivalent "desc" (0 or 1, respectively) * Add a lot of Pure-Perl DBD's as build dependency for testing (skip DBD::AnyData for now, because it seems to be broken - check for next release) [Misc] * Bump requirement of DBI to 1.616 * switch for fully external DBD tests from DBD::XBase to DBD::SQLite * Document another limitation (lacking implicit creating temp table during processing a query using the same table with different aliases twice) * Wed Dec 01 2010 coolo@novell.com - switch to perl_requires macro * Mon Aug 23 2010 chris@computersalat.de - update to 1.31 - [Bug fixes] * Fix misbehaviour of DELETE/UPDATE for tables with only basic capabilities and no matching where clause (reported by H.Merijn Brand and Drew ...) * Fix some column identifier splits to respect quoted tables - [Improvements] * Optimized some core routines between 25% and 50%. - fixed deps (Requires) o DBD::File, DBI::DBD::SqlEngine > Recommends * Tue Aug 10 2010 chris@computersalat.de - update to 1.30 - [Bug fixes] * remove blib directory from distfile - Version 1.29, released August 1st, 2010 - [Bug fixes] * add some getters as documented in SQL::Statement::Structure (fixes RT#59834, thanks John Wiersba) * add missing import of function croak to SQL::Statement::Term::ColumnValue * fix assignment of parser result (doesn't run with perl-5.13.3) - spec mods o rpmlint wrong-file-end-of-line-encoding replaced dos2unix with %{__perl} -p -i -e "s|\r\n|\n|" o removed BuildReq perl-macros pkg only build for suse_version >= 1120, and perl-macros is delivered with perl * Tue Jul 20 2010 chris@computersalat.de - update to 1.28 - [Improvements] * Introduce new "capability" method for SQL::Statement and SQL::Eval::Table + Add capability for "insert_new_row" to allow DBD::DBM to fix PK constrain on INSERT statements. * Performance of IMPORT feature improved (thanks to Sven Probst, RT#57322) - [Bug fixes] * expect every table object being derived from SQL::Eval::Table * rewrite DELETE and UPDATE command based on table capabilities * add abstract methods for all methods derived classes must override (this means, open_table for SQL::Statement deriveds must be overridden and all data access methods of tables - see SQL::Eval::Table for details) * Tests are fixed to use TEMP TABLES explicitely when required * check for invalid column names fixed * Don't let depreciated parser structures stay alive in SQL::Statement when reusing the Parser - [Documentation] * Method documentation of SQL::Statement and SQL::Eval::Table are improved * Add a Roadmap describing future plans for SQL::Statement (in addition to DBD::File::Roadmap). * POD spelling fixes provided by H.Merijn Brand and Pod::Spell::CommonMistakes (thanks Tux) * POD grammar fixes and reasonable sentences created by Martin Evans - [Things that may break your code] * SQL::Statement 1.28 is expected not to work proper in combination with DBI 1.611 and below * SQL::Statement::ColumnValue expects now every table being derived from SQL::Eval::Table - recreated by cpanspec 1.78 - added Authors
/usr/lib/perl5/vendor_perl/5.26.1/SQL /usr/lib/perl5/vendor_perl/5.26.1/SQL/Dialects /usr/lib/perl5/vendor_perl/5.26.1/SQL/Dialects/ANSI.pm /usr/lib/perl5/vendor_perl/5.26.1/SQL/Dialects/AnyData.pm /usr/lib/perl5/vendor_perl/5.26.1/SQL/Dialects/CSV.pm /usr/lib/perl5/vendor_perl/5.26.1/SQL/Dialects/Role.pm /usr/lib/perl5/vendor_perl/5.26.1/SQL/Eval.pm /usr/lib/perl5/vendor_perl/5.26.1/SQL/Parser.pm /usr/lib/perl5/vendor_perl/5.26.1/SQL/Statement /usr/lib/perl5/vendor_perl/5.26.1/SQL/Statement.pm /usr/lib/perl5/vendor_perl/5.26.1/SQL/Statement/Embed.pod /usr/lib/perl5/vendor_perl/5.26.1/SQL/Statement/Function.pm /usr/lib/perl5/vendor_perl/5.26.1/SQL/Statement/Functions.pm /usr/lib/perl5/vendor_perl/5.26.1/SQL/Statement/GetInfo.pm /usr/lib/perl5/vendor_perl/5.26.1/SQL/Statement/Operation.pm /usr/lib/perl5/vendor_perl/5.26.1/SQL/Statement/Placeholder.pm /usr/lib/perl5/vendor_perl/5.26.1/SQL/Statement/RAM.pm /usr/lib/perl5/vendor_perl/5.26.1/SQL/Statement/Roadmap.pod /usr/lib/perl5/vendor_perl/5.26.1/SQL/Statement/Structure.pod /usr/lib/perl5/vendor_perl/5.26.1/SQL/Statement/Syntax.pod /usr/lib/perl5/vendor_perl/5.26.1/SQL/Statement/Term.pm /usr/lib/perl5/vendor_perl/5.26.1/SQL/Statement/TermFactory.pm /usr/lib/perl5/vendor_perl/5.26.1/SQL/Statement/Util.pm /usr/lib/perl5/vendor_perl/5.26.1/x86_64-linux-thread-multi /usr/share/doc/packages/perl-SQL-Statement /usr/share/doc/packages/perl-SQL-Statement/Changes /usr/share/doc/packages/perl-SQL-Statement/GPL-1 /usr/share/doc/packages/perl-SQL-Statement/GPL-2.0 /usr/share/doc/packages/perl-SQL-Statement/README /usr/share/doc/packages/perl-SQL-Statement/README.md /usr/share/licenses/perl-SQL-Statement /usr/share/licenses/perl-SQL-Statement/ARTISTIC-1.0 /usr/share/licenses/perl-SQL-Statement/LICENSE /usr/share/man/man3/SQL::Dialects::ANSI.3pm.gz /usr/share/man/man3/SQL::Dialects::AnyData.3pm.gz /usr/share/man/man3/SQL::Dialects::CSV.3pm.gz /usr/share/man/man3/SQL::Dialects::Role.3pm.gz /usr/share/man/man3/SQL::Eval.3pm.gz /usr/share/man/man3/SQL::Parser.3pm.gz /usr/share/man/man3/SQL::Statement.3pm.gz /usr/share/man/man3/SQL::Statement::Embed.3pm.gz /usr/share/man/man3/SQL::Statement::Function.3pm.gz /usr/share/man/man3/SQL::Statement::Functions.3pm.gz /usr/share/man/man3/SQL::Statement::GetInfo.3pm.gz /usr/share/man/man3/SQL::Statement::Operation.3pm.gz /usr/share/man/man3/SQL::Statement::Placeholder.3pm.gz /usr/share/man/man3/SQL::Statement::RAM.3pm.gz /usr/share/man/man3/SQL::Statement::Roadmap.3pm.gz /usr/share/man/man3/SQL::Statement::Structure.3pm.gz /usr/share/man/man3/SQL::Statement::Syntax.3pm.gz /usr/share/man/man3/SQL::Statement::Term.3pm.gz /usr/share/man/man3/SQL::Statement::TermFactory.3pm.gz /usr/share/man/man3/SQL::Statement::Util.3pm.gz
Generated by rpm2html 1.8.1
Fabrice Bellet, Tue Jul 9 11:27:19 2024