Hello community, here is the log from the commit of package perl-DBD-XBase for openSUSE:Factory checked in at 2016-04-28 16:54:57 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Comparing /work/SRC/openSUSE:Factory/perl-DBD-XBase (Old) and /work/SRC/openSUSE:Factory/.perl-DBD-XBase.new (New) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Package is "perl-DBD-XBase" Changes: -------- --- /work/SRC/openSUSE:Factory/perl-DBD-XBase/perl-DBD-XBase.changes 2013-06-05 13:33:50.000000000 +0200 +++ /work/SRC/openSUSE:Factory/.perl-DBD-XBase.new/perl-DBD-XBase.changes 2016-04-28 16:57:58.000000000 +0200 @@ -1,0 +2,15 @@ +Thu Apr 7 09:11:50 UTC 2016 - [email protected] + +- updated to 1.06 + see /usr/share/doc/packages/perl-DBD-XBase/Changes + + 1.06 Sun Mar 6 20:48:11 CET 2016 + Add support for W column type (byte array by Visual FoxPro). + + Fixed overload arg warning. + + Restore the table_info functionality. + + Fix for type B little endian issue, reported by Andres Thomas. + +------------------------------------------------------------------- Old: ---- DBD-XBase-1.05.tar.gz New: ---- DBD-XBase-1.06.tar.gz cpanspec.yml ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Other differences: ------------------ ++++++ perl-DBD-XBase.spec ++++++ --- /var/tmp/diff_new_pack.6VXxub/_old 2016-04-28 16:58:01.000000000 +0200 +++ /var/tmp/diff_new_pack.6VXxub/_new 2016-04-28 16:58:01.000000000 +0200 @@ -1,7 +1,7 @@ # # spec file for package perl-DBD-XBase # -# Copyright (c) 2013 SUSE LINUX Products GmbH, Nuernberg, Germany. +# Copyright (c) 2016 SUSE LINUX GmbH, Nuernberg, Germany. # # All modifications and additions to the file contributed by third parties # remain the property of their copyright owners, unless otherwise agreed @@ -17,50 +17,55 @@ Name: perl-DBD-XBase -BuildRequires: perl-DBI -BuildRequires: perl-macros -Version: 1.05 +Version: 1.06 Release: 0 -Obsoletes: dbdxbase -Provides: dbdxbase -Url: http://cpan.org/modules/by-module/DBD/ -Summary: Provides Access to XBase Files -License: Artistic-1.0 +%define cpan_name DBD-XBase +Summary: Reads and writes XBase (dbf) files, includes DBI support +License: GPL-1.0+ or Artistic-1.0 Group: Development/Libraries/Perl -Source: http://www.cpan.org/authors/id/JANPAZ/DBD-XBase-%{version}.tar.gz +Url: http://search.cpan.org/dist/DBD-XBase/ +Source0: http://www.cpan.org/authors/id/J/JA/JANPAZ/%{cpan_name}-%{version}.tar.gz +Source1: cpanspec.yml +BuildArch: noarch BuildRoot: %{_tmppath}/%{name}-%{version}-build +BuildRequires: perl +BuildRequires: perl-macros %{perl_requires} %description -Module XBase provides access to XBase (dBase, Fox*) database files, -namely dbf, dbt, fpt, ndx, ntx, mdx, idx and cdx. +DBI compliant driver for module XBase. Please refer to DBI(3) documentation +for how to actually use the module. In the *connect* call, specify the +directory containing the dbf files (and other, memo, etc.) as the third +part of the connect string. It defaults to the current directory. + +Note that with dbf, there is no database server that the driver would talk +to. This DBD::XBase calls methods from XBase.pm module to read and write +the files on the disk directly, so any limitations and features of XBase.pm +apply to DBD::XBase as well. DBD::XBase basically adds SQL, DBI compliant +interface to XBase.pm. + +The DBD::XBase doesn't make use of index files at the moment. If you really +need indexed access, check XBase(3) for notes about support for variour +index types. %prep -%setup -n DBD-XBase-%{version} +%setup -q -n %{cpan_name}-%{version} +find . -type f ! -name \*.pl -print0 | xargs -0 chmod 644 %build -perl Makefile.PL -make %{?_smp_mflags} +%{__perl} Makefile.PL INSTALLDIRS=vendor +%{__make} %{?_smp_mflags} %check -make test +%{__make} test %install -rm -rf $RPM_BUILD_ROOT %perl_make_install %perl_process_packlist +%perl_gen_filelist -%clean -rm -rf $RPM_BUILD_ROOT - -%files -%defattr(-,root,root) -%doc Changes README ToDo -%doc %{_mandir}/man?/* -%{perl_vendorlib}/DBD -%{perl_vendorlib}/XBase -%{perl_vendorlib}/XBase.pm -%{perl_vendorarch}/auto/XBase -%{_bindir}/* +%files -f %{name}.files +%defattr(-,root,root,755) +%doc Changes driver_characteristics new-XBase README ToDo %changelog ++++++ DBD-XBase-1.05.tar.gz -> DBD-XBase-1.06.tar.gz ++++++ diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/DBD-XBase-1.05/Changes new/DBD-XBase-1.06/Changes --- old/DBD-XBase-1.05/Changes 2013-04-24 19:37:43.000000000 +0200 +++ new/DBD-XBase-1.06/Changes 2016-03-06 20:56:56.000000000 +0100 @@ -1,6 +1,15 @@ Revision history for Perl extension XBase and DBD::XBase. +1.06 Sun Mar 6 20:48:11 CET 2016 + Add support for W column type (byte array by Visual FoxPro). + + Fixed overload arg warning. + + Restore the table_info functionality. + + Fix for type B little endian issue, reported by Andres Thomas. + 1.05 Wed Apr 24 19:37:09 CEST 2013 Fix for prepare_select_eq and empty MDX indexes, patch by Julian Bridle. diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/DBD-XBase-1.05/DBD-XBase-1.06/Changes new/DBD-XBase-1.06/DBD-XBase-1.06/Changes --- old/DBD-XBase-1.05/DBD-XBase-1.06/Changes 1970-01-01 01:00:00.000000000 +0100 +++ new/DBD-XBase-1.06/DBD-XBase-1.06/Changes 2016-03-06 20:56:56.000000000 +0100 @@ -0,0 +1,662 @@ + +Revision history for Perl extension XBase and DBD::XBase. + +1.06 Sun Mar 6 20:48:11 CET 2016 + Add support for W column type (byte array by Visual FoxPro). + + Fixed overload arg warning. + + Restore the table_info functionality. + + Fix for type B little endian issue, reported by Andres Thomas. + +1.05 Wed Apr 24 19:37:09 CEST 2013 + Fix for prepare_select_eq and empty MDX indexes, patch by Julian + Bridle. + +1.04 Wed Apr 17 19:47:21 CEST 2013 + Fix for handling MDX indexes, patch by Julian Bridle. + +1.03 Sun Mar 6 07:32:21 CET 2011 + Fixing output of tests when DBI is not available. + +1.02 Thu Mar 3 20:40:54 CET 2011 + Added the URL to the AVAILABLE FROM sections. + +1.01 Wed Feb 9 21:22:07 CET 2011 + Updated the Changes file. + +1.00 Wed Feb 9 21:19:35 CET 2011 + Changed the location of the distribution to + http://www.adelton.com/perl/DBD-XBase/ + + Changed author's email address. + + Require perl 5.10 and use O_BINARY from Fcntl. + + Updated the clean target to make distclean clean. + + Updated URL of Erik's documentation. + +0.241 Thu Nov 20 21:12:56 MET 2003 + XBase: codepage option to XBase->create added, suggested by + Chris Greenhill. + +0.240 Mon Aug 25 15:03:57 MEST 2003 + XBase: delete_record/undelete_record now corrctly returns + false when the delete fails, problem reported by Boris Kocak. + +0.234 Mon Jul 7 20:41:14 CEST 2003 + Added test to Makefile.PL and note to INSTALL about case + insensitive clash with Xbase.pm, suggested by Michael Higgins + and Jan from AS. + + Added documentation / comments about datetime, suggested + by John Freed. + + Xbase: Added the recompute_lastrecno parameter, suggested by + Kevin J. Rice. Added EOF to create, suggested by Ilya Sandler. + +0.232 Thu Apr 3 17:47:39 CEST 2003 + XBase::SQL: Fieldname can contain the table name (silently + dropped), suggested by Michael Semich, and table name now + matches [^\(\s]+ to allow paren immediately following it, + problem reported by belg4mit. + +0.231 Thu Oct 31 17:48:19 MET 2002 + t/9_dbd_create.t: patched a test failure on Windows platform, + path by Yves Orton. + +0.230 Wed Oct 9 11:05:28 MET DST 2002 + DBD::XBase: added docs about xbase_ignorememo. + + DBD::XBase: fixed dropping table so that the driver forgets + the table, patch by Mike P. Mikhailov. + +0.220 Mon Sep 2 12:26:34 MET DST 2002 + XBase::Index::ntx: type option has higher priority than dbf. + + XBase::read_header: fail if the header is not valid. + + XBase::Memo::read_header: allow length 512 and 24. + + XBase::FAQ: reformatted, slightly. + + XBase, XBase::SQL: added support for type money (Y). + + Code and indentation cleanup. + +0.210 Fri Dec 7 12:56:37 MET 2001 + README and INSTALL made uptodate. + Fixed attributes (TYPE) handling, problem reported by Jacek + Ciolek. + +0.200 Sun Aug 19 13:48:27 MET DST 2001 + Source code reformated to unified indentation. + +0.190 Sat Aug 18 18:02:04 MEST 2001 + XBase::SDBM: documentation added. + + DBD::XBase: order by with more fields supported. + +0.177 Thu May 10 17:19:07 MET DST 2001 + XBase: retry with nolongchars if the char lengths do not match + the record length. + + Memo field not written when empty, suggested by Sascha Knific. + + XBase::Base::open: now allows option 'fh' to point to + IO::Scalar or generally any filehandle to be passed in. + +0.176 Thu Feb 8 13:19:16 MET 2001 + DBD::XBase: select * with order by was failing, reported by + Filipe Luis Geschaeft + +0.173 Tue Feb 6 11:18:46 MET 2001 + XBase: year encoding not correct in dbf header, reported + by Helmut Jarausch. + +0.172 Tue Feb 6 10:22:11 MET 2001 + XBase::Memo: creating of fpt supported; bug pointed out by + Massimo Matteuzzi. + +0.170 Fri Jan 26 18:35:01 MET 2001 + XBase::idx: create support and better reading support. + + XBase: password protection explored + +0.165 Mon Jan 22 19:33:01 MET 2001 + XBase: better sanity checks in dump_records. + + XBase::SQL: added support for not in SQL command. + +0.162 Sun Jan 21 17:53:05 MET 2001 + XBase::IndexCursor: error by one in last_fetched. + + XBase: Y2K problem fixed, patch by Phillip Millman. + + XBase::Index, XBase::SDBM: added support for SDBM index + files. + + XBase, XBase::cdx: added support for type specification of cdx + files even when called via prepare_select_with_index, to + allow use even if we don't support expressions. + + XBase::SQL: multiplication support added, patch by Thoren + Johne and Stuart Lemmen. + +0.161 Sat May 20 12:52:35 MET DST 2000 + indexdump: had bug in option handling. + + XBase::Index: minor tweaks, bug reporting fixed, support + for cdx dates added, reported by Dan Albertsson. + + XBase: long numeric values weren't truncated correctly, + reported by Dan Albertsson. + +0.160 Sat Feb 12 20:03:56 MET 2000 + + XBase::Index: cdx now supports the delete, insert and + write_header methods for updating the index file. Handling + of negative integers fixed, as well as trailing nulls. + + XBase: preliminary support for attach_index. Code for + making the module happy with _NULLFLAGS/0 type (we do not + interpret this at the moment, we just correctly ignore) + provided by Sebastien Nameche. + + XBase::SQL: like operator now matches multiline strings as + well, problem reported by Petr Nalevka. + + DBD::XBase: stump DBD::XBase::db::DESTROY added, to silence DBI, + patch by Gregory McCann. + +0.1551 Sat Jan 9 19:21:16 CET 2000 + + dbfdump: Accepts --SQL modifier to --info, prints structure + of the table as a create table SQL. + +0.155 Sun Nov 7 15:43:59 CET 1999 + + XBase::SQL and DBD::XBase: arbitraty arithmetic expression + possible in the select list. NAME attribute works fine for them. + SQL functions length, *trim, concat and substr supported. Fixed + bug in XBase::SQL causing bad division results. The DBD::XBase + documentation revised. + + t/5_dbd_select* tests extended. + +0.147 Mon Aug 16 10:48:37 MET DST 1999 + + XBase::SQL and DBD::XBase: fixed broken handling of NAME + attribute, introduced in 0.145 by an attempt to support + arbitrary expressions in the selected part. So I rolled back + that change and it's (again) only possible to select * or + select list of field names -- problem reported by adelton, + William McKee and Martin Treusch. + + XBase::Index: fixed handling of indexes with 32-bit record + number -- patch by Jon Bloom. + + XBase::Base: fixed typo _unlockex, pointed by Mike Sanders. + +0.145 Mon Jun 21 12:49:19 MET DST 1999 + + DBD::XBase: updated TYPE_INFO for BOOLEAN and BLOB. + + t/5_dbd_select.t: added tests for the named bind params. + +0.144 Fri May 14 07:50:23 CEST 1999 + + XBase::SQL, DBD::XBase: added support for named bind parameters; + added comments. + +0.141 Thu Apr 29 23:17:25 CEST 1999 + + XBase::Index: added code for multiple page cdx and fix for big + endian. Added code for negative ntx numeric values. + +0.140 Thu Apr 29 10:50:58 MET DST 1999 + + XBase: the -1 memo records handle the 4 byte fields as well, + patch by Zbigniew Malinowski. + + XBase::Index: support for cdx files improved (numeric fields), + subindexes. + + XBase::SQL: code properly commented. + + DBD::XBase: added the time type, aptch by Nikolai Saoukh. + +0.132 Sun Apr 18 17:35:10 MET DST 1999 + + XBase::Base: dealing of openoptions fixed, problem spotted by + Zbigniew Malinowski. + + XBase::SQL: added type numeric, patch by Nikolai Saoukh. + + XBase::Index: added support for cdx (one page index so far), + added support for idx (untested). + + DBD::XBase: added attributes PRECISION and SCALE, changed SQL + type for NUMERIC, patch by Nikolai Saoukh. + + driver_characteristics now includes Tim's additions of Apr 4, + 1999. + + Created new XBase::FAQ.pod. + +0.131 Sun Apr 18 8:47:12 MET DST 1999 + + XBase: memo records marked -1 are returned empty now, + spotted by Zbigniew Malinowski. + + XBase::SQL: added possibility to have expression to the left + from the relational operator, suggested by Nikolai Saoukh. + + DBD::XBase: fixed type_info to return array, bug spotted by + Alan Grover. + +0.130 Sat Feb 27 18:09:04 MET 1999 + + DBD::XBase: fixed handling of the rows method. + + Added driver_characteristics.pod to list characteristics of + DBD::XBase according to the draft by Tim Bunce. + +0.129 Fri Feb 26 22:02:12 MET 1999 + + XBase.pm: added support for datetime fields T, testing data + provided by William McKee. Fix for ignorememo. + + XBase::SQL: added time and datetime names to the SQL parser. + + XBase::Memo and XBase.pm: added support for Apollo SMT memo + files, code based on that provided by Dirk Tostmann. + + O_BINARY is only loaded on evil systems now. + +0.127 Mon Feb 22 10:56:23 MET 1999 + + XBase::Base: opening readonly files fixed, patch by Petr + Machacek. + + _unlockex fixed to _unlock. locksh, lockex and unlock now + return true/false based on result. + + DBD::XBase::disconnect now closes the tables, patch by Martin + Treusch von Buttlar. Fixed typo in delete code. + + t/2_write.t: added $table->close before size check, patch by + Ilya Chelpanov. + +0.121 Thu Jan 21 20:07:04 MET 1999 + + XBase::Memo: fixed a typo in measuring the next_for_append, + pointed out by Dan Albertsson. + + t/2_write.t: added afox5.dbf/FPT and a Fox* test. + +0.120 Wed Jan 13 13:24:15 MET 1999 + + XBase.pm: added XBase::Cursor::rewind, names, + prepare_select_nf. Added readonly option. Added option 'table' + for dump -- using Data::ShowTable. + + XBase.pm, XBase::Base.pm: open method now accepts hash of + options. + + XBase::Memo: we now reset next_for_append to point behind the + end of the file, problem pointed out by Artem Belevich. + + dbfdump: option --table, --fields now handles intervals. + + t/2_read.t: fixed problem with order of fields in hash, patch + by Andreas J. Koenig. + + t/4_dbfdump.t: added quotes for Win* systems, patch by Randy + Kobes. + +0.115 Wed Jan 6 17:02:28 MET 1999 + + XBase::Memo: tries to find out which format (\x1a versus + \x1a\x1a) to use for dBaseIII memo files. It also writes back + this separator. + +0.110 Sun Dec 20 21:29:05 MET 1998 + + XBase::SQL: added LIKE clause to WHERE part of SQL commands. + +0.105 Sun Dec 20 17:09:43 MET 1998 + + XBase::Base: added workaround for systems that not only write + to files something else than they are told to, but also damage + the files by merely opening it. + + XBase::Memo: fixed problem with fpt files -- thanks to Dan + Albertsson for providing many test files. + + XBase::SQL: fix of handling of double quoted strings. + + dbfdump: memosep and memofile options fixed. + + t/4_dbfdump.t: avoided using cat. + + t/*_dbd_*.t: forcing use of DBI version at least 1.0. + +0.100 Mon Dec 7 11:00:23 MET 1998 + + DBD::XBase: capitalized AND/OR in SQL commands now work, + method rows implemented, reported by cybertoast. Updated to + use _set_fbav. Unpolished support to *info* methods. + + XBase::SQL: fixed the primary key/key parsing problem, patch + by Bill Brinkley & Joe Johnston. A quick fix to avoid bug in + Perl with long blobs. + + XBase::Memo: fixed appending record to dBaseIV memo used to + corrupt the data -- reported by Dan Albertsson. + +0.0696 Mon Oct 26 11:57:01 MET 1998 + + DBD::XBase: added bug reporting by INSERT command and fixed + example in man page, spotted by Dmitry Dorofeev. Added DESC + part of ORDER BY clause, requested by Dmitry Dorofeev. Fixed + number of fields returned with ORDER BY clause, patch by + Paul Lindner. If the directory is not specified in call to + connect, it now defaults to current directory, not to root. + Fixed the fetch method -- it doesn't deadlock anymore, problem + reported by Ken Yamaguchi. + + XBase::Index: added some MDX code. + + XBase::Memo: header_len is now set to block_size, not 512, + patch by Fergus Lee. + + XBase.pm: The type B is Fox double, not memo, spotted by + George F. Frazier. Added support for Fox* 4 byte memo fields, + data provided by William McKee. + + All of the reads/tells rewritten to allow stream-lined processing, + suggested by Sergey Lukashevich. Use with caution, however. + + Added autoflush to each opened file, so it's safe to read the + table with other process before closing the table in the first + one, spotted by Thomas Hahn. + +0.0694 Tue Aug 25 23:24:35 MET DST 1998 + + XBase::Memo: Fixed error by 8 in dBaseIV reading/writing + code, bug reported by Kendal Van Dyke. + + t/5_dbd_select.t changed to be non-unique-key in sort + independent, reported by Larry W. Virden. + +0.0693 Tue Aug 25 10:25:20 MET DST 1998 + + DBD::XBase: Fixed handling ORDER BY with WHERE clauses, + reported by Kendal Van Dyke. + + XBase: added nolongchars -- omitted from 0.068. + + XBase::Index: added ro support for Clipper's ntx, the whole + module reworked. Thanks to Frans van Loon for providing + example ntx files and code that helped me to understand the + format. Also thanks to Robert Geer for his C code that also + helps me to check the expected results. + + XBase::Base: last_record can be -1, meaning unknown -- + disables checks. + + Added t/3_ntx.t and added ORDER BY test to t/5_dbd_select.t. + + Some documentation improvements. + +0.068 Thu Aug 20 18:43:17 MET DST 1998 + + DBD::XBase: added support for ORDER BY, defined using substh. + + Fixed error by 1 in deleting all records. + + Added support for NULLABLE, NUM_OF_PARAMS and TYPE in FETCH. + + Defined data_sources to dbi:XBase:.; disconnect_all returns 1; + defined tables, disconnect and DESTROY; quote adds support for + NULL. + + XBase: create now marks presence of a dbt file in dbf. + + Added attribute nolongchars to disable character fields longer + than 255. + + Erik Bachmann's homepage moved. + + XBase::Memo: added suport for memosep attribute, default + \x1a\x1a. Correct header is now written for dBaseIV memo + files. + + Fix of handling dBaseIV memo records, patch by Barry Fishman. + + XBase::SQL: added ORDER BY support, recognizes VARCHAR. + + In dbit/40blobs.t we only try blob size 64 -- fix for bug in + Perl regexp engine. Change in dbit/40bindparam.t, quick fix + for missing NULL chars. In dbit/50chopblanks.t swapped + $$ref[1] and $name. + +0.065 Sun Jun 7 15:18:57 MET DST 1998 + + Added table specific ChopBlanks. Added fetch_hashref to + XBase::Cursor. + + Docs updated. + +0.064 Sun May 31 18:56:26 MET DST 1998 (*****) + + Major rewrite of the DBD and SQL part. New features: + support for bind parameters in where, insert and update. + Support for NULL and IS NULL tests. The XBase::SQL is faster + and hopefully clearer. The DBD::XBase supports (among others) + bind_col. The DBD driver now passes 98.39 % of the standard + DBD tests. + + Added support for data type 'I' for Fox* into XBase.pm. + +0.0632 Wed May 27 12:27:04 MET DST 1998 + + Added --nomemo option to dbfdump. The list of entires is made + longer in any non-leaf page in ndx. Added check for the magic + "FFFF0800" tag in dBaseIV dbt file when reading it. + +0.0631 Fri May 22 22:24:02 CEST 1998 + + Fixed handling big endian in numeric fields in ndx, fixe + problem with key/record length. + +0.063 Sun May 17 21:46:08 CEST 1998 + + Added first support for ndx index files. From XBase module + it's available using prepare_select_with_index. It's very + alpha but it seems to handle character and numeric (not date + yet) types. And yes, it's read only. + + Added FETCH('NAME') and _ListTables to DBD::XBase, added drop + table, integer type and dummy not null to XBase::SQL. The + generic DBI test suite now goes well up until bind params, put + on ToDo list. + +0.062 Thu May 14 15:11:32 MET DST 1998 + + Field and table names in XBase::SQL now accept digits and + underscores, in XBase::Memo, we check for + ($dbf_version & 15), patches by Jens Quade. + + Fixed handling of Fox* fpt files and a problem with memo + files that have record length different than 512, patches + by Thomas Grueter. + +0.061 Tue Apr 7 21:52:07 MET DST 1998 + + Fixed writing undefined values in numeric fields. + Fixed dealing with uppercase extensions. + + XBase::SQL fixed to support int, found by Chris Winters. + + Offset in the record headers in dbf now set properly, patch by + Dave Frascone. + + Added ignorememo option to new XBase call. Use this if you + have a memo field in dbt but do not have the memo file. + Otherwise you will get an error, request by Martin Jost. + Other fixes by Martin Jost included. + +0.060 Fri Mar 20 10:20:45 MET 1998 + + Added method prepare_select and XBase::Cursor to implement + long selects. Method dump_records now prints directly, + doesn't use get_all_records. + + Added parameter --info into the script dbfdump to print the + header info. + + Changed way of determining the type of the dbt file after + discussion with Sergey Lukashevich. + +0.0599 Wed Mar 11 22:58:45 MET 1998 + + Option to specify the memo file in call to XBase::new added. + + Dump_records made customizable. + +0.0598 Tue Mar 10 22:40:00 MET 1998 + + Fixed bug when finding a name for the memo file in XBase; in + dBaseIII memo field we will only check for one \x1a to allow + as many formats possible, we still write two of them; typo in + init_memo fixed -- patches by Martin Jost. + +0.0597 Tue Mar 3 23:40:56 MET 1998 (*****) + + Major code revision and check: + + Error handling fixed, locking added. Rewritten process_* to + rproc and wproc arrays. + + Added read_all_records. Minor typos and bugs fixed. + + Test suite extended. + +0.0584 Mon Mar 2 10:04:00 MET 1998 + + Fix of XBase::Memo::dBaseIV::read_record for memo fields + longer than record length by Jochen Friedrich. + +0.0583 Thu Feb 12 00:08:07 MET 1998 + + Bug fix for floating fields, patch by Carlos Augusto de + Almeida. + +0.058 Mon Feb 9 19:15:03 MET 1998 (*****) + + XBase::SQL rewritten, DBD::XBase now supports select, delete, + insert, update and create table. Documentation for DBD::XBase + extended. DBD::XBase is still alpha but rather stable. + + Added support for fpt memo files. + + Fixed bug with dBase IV memo files, the block length is stored + somewhere else, patch by James LewisMoss. Fixed bug with field + names in newer dbf files, terminated by zero byte, patch by Petr + Olsak. Added binmode for the OSes that write to disk something + else that they are told to, reported by Robert Bauer. Removed + the test that caused read to fail on read-only files, reported + by Stewart Russell. + + The error handling reviewed, most of the error messages are + now local to the object ($table->errstr()). + +0.039 Wed Dec 17 19:53:49 MET 1997 (*****) + + DBD::XBase supports select where and delete where. + +0.0352 Mon Dec 15 11:29:46 MET 1997 + + Fixed bug with long memo fields, reported by Tejinderpal + Singh. + +0.0345 Mon Dec 8 13:02:46 MET 1997 + + Fixed bug with "\0" at the end of field names in header, + spotted by Roberto Congiu. + +0.0343 Thu Dec 4 10:52:41 MET 1997 + + Column names are converted to uppercase. SQL parsing moved to + XBase::SQL module. Added require XBase::Memo when creating new + Memo file. Added test for create and drop. + +0.0342 Fri Nov 28 18:30:31 MET 1997 + + Fixed bug when creating new file, spotted by Roberto Congiu. + $XBase::errstr depreciated, using XBase->errstr instead. Minor + changes in the documentation. + +0.03301 Thu Nov 20 17:32:53 MET 1997 + + Handling null numeric fields (John D Groenveld). Changed + "look for error" test in header.t to be OS portable. Fixed bug + in decode_version_info (dbtflag). Fixed bug with field length + in XBase::create, spotted by Risto Wichman. + +0.032 Thu Nov 6 16:27:10 MET 1997 + + Fixed bugs: test on "\r" in read_header; check of record + number in delete and undelete (spotted by Frans van Loon). + Added methods field_lengths and field_decimals and changed + *_on_read in [NF] section (spotted by John D Groenveld). + +0.031 Thu Oct 30 19:47:37 MET 1997 + + Fixed bug in docs about write_record. Changed format of + get_field_info to include field number. Fixed bug with decimals. + +0.03 Mon Oct 27 23:23:17 MET 1997 (*****) + + Minor bug fixes. XBase::create added. Tests extended. Module + released on CPAN. + +0.029 Fri Oct 24 19:34:32 MET DST 1997 + + Bug fixes. Added methods for writing dbt files. + + The writing methods are now set_record, set_record_hash and + update_record. + +0.024 Mon Oct 20 22:17:44 MET DST 1997 + + The original release. Includes XBase that reads dbf and dbt + and writes dbf (but not dbt). Put on CPAN mainly for other + people to test and comment. + +--- + +Note: Versions tagged (*****) were major updates and code changes. + +I have been using the Xbase(3) module by Pratap Pereira for quite +a time to read the dbf files, but it had no writing capabilities, it +was not use strict clean and the author did not support the module +behind the version 1.07. So I started to make my own patches and +thought it would be nice if other people could make use of them. +I thought about taking over the development of the original Xbase +package, but the interface seemed rather complicated to me. + +So with the help of article XBase File Format Description by Erik +Bachmann on URL + + http://www.clicketyclick.dk/databases/xbase/format/ + formerly http://www.e-bachmann.dk/docs/xbase.htm + +I have written a new module. It doesn't use any code from Xbase-1.07 +and you are free to use and distribute it under the same terms as Perl +itself. + diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/DBD-XBase-1.05/README new/DBD-XBase-1.06/README --- old/DBD-XBase-1.05/README 2011-02-09 21:14:24.000000000 +0100 +++ new/DBD-XBase-1.06/README 2016-03-06 20:56:56.000000000 +0100 @@ -100,7 +100,7 @@ Contact the author at jpx dash perl at adelton dot com. -Copyright: (c) 1997--2011 Jan Pazdziora. +Copyright: (c) 1997--2016 Jan Pazdziora. All rights reserved. This package is free software; you can redistribute it and/or modify it under the same terms as Perl itself. diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/DBD-XBase-1.05/lib/DBD/XBase.pm new/DBD-XBase-1.06/lib/DBD/XBase.pm --- old/DBD-XBase-1.05/lib/DBD/XBase.pm 2013-04-24 19:35:43.000000000 +0200 +++ new/DBD-XBase-1.06/lib/DBD/XBase.pm 2016-03-06 20:56:56.000000000 +0100 @@ -19,7 +19,7 @@ use vars qw( $VERSION @ISA @EXPORT $err $errstr $drh $sqlstate ); # a couple of global variables that may come handy -$VERSION = '1.05'; +$VERSION = '1.06'; $err = 0; $errstr = ''; @@ -284,9 +284,7 @@ # binded parameters my $bind_values = $sth->{'xbase_bind_values'}; - ### the following code seems to somehow protect those "fixed" - ### statements but I do not understand it at the moment - ### if (defined $sth->{'xbase_lines'}) { return -1; } + if (defined $sth->{'xbase_lines'}) { return -1; } # cancel the count of rows done in the previous run, this is a # new execute @@ -764,7 +762,7 @@ =head1 VERSION -1.05 +1.06 =head1 AVAILABLE FROM @@ -772,7 +770,7 @@ =head1 AUTHOR -(c) 1997--2013 Jan Pazdziora. +(c) 1997--2016 Jan Pazdziora. Contact the author at jpx dash perl at adelton dot com. diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/DBD-XBase-1.05/lib/XBase/SQL.pm new/DBD-XBase-1.06/lib/XBase/SQL.pm --- old/DBD-XBase-1.05/lib/XBase/SQL.pm 2003-04-04 18:08:47.000000000 +0200 +++ new/DBD-XBase-1.06/lib/XBase/SQL.pm 2016-03-06 20:55:24.000000000 +0100 @@ -8,7 +8,7 @@ use strict; use vars qw( $VERSION %COMMANDS ); -$VERSION = '0.233'; +$VERSION = '1.06'; # ################################# # Type conversions for create table @@ -658,7 +658,7 @@ '""' => sub { ref shift; }, '.' => sub { XBase::SQL::Expr->string($_[0]->value . $_[1]->value); }, '*' => sub { XBase::SQL::Expr->number($_[0]->value * $_[1]->value);}, - 'not' => sub { not $_[0]->value }, + '!' => sub { not $_[0]->value }, ; sub new { bless {}, shift; } diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/DBD-XBase-1.05/lib/XBase.pm new/DBD-XBase-1.06/lib/XBase.pm --- old/DBD-XBase-1.05/lib/XBase.pm 2011-03-03 20:38:22.000000000 +0100 +++ new/DBD-XBase-1.06/lib/XBase.pm 2016-03-06 20:56:56.000000000 +0100 @@ -20,7 +20,7 @@ use vars qw( $VERSION $errstr $CLEARNULLS @ISA ); @ISA = qw( XBase::Base ); -$VERSION = '1.02'; +$VERSION = '1.06'; $CLEARNULLS = 1; # Cut off white spaces from ends of char fields *errstr = \$XBase::Base::errstr; @@ -137,10 +137,15 @@ $wproc = sub { pack 'V', shift; }; } elsif ($type eq 'B') { # Fox double - $rproc = sub { unpack 'd', reverse scalar shift; }; - $wproc = sub { reverse scalar pack 'd', shift; }; + if (pack("L", 1) eq pack("V", 1)) { + $rproc = sub { unpack 'd', scalar shift; }; + $wproc = sub { scalar pack 'd', shift; }; + } else { + $rproc = sub { unpack 'd', reverse scalar shift; }; + $wproc = sub { reverse scalar pack 'd', shift; }; + } } - elsif ($type =~ /^[MGP]$/) { # memo fields + elsif ($type =~ /^[WMGP]$/) { # memo fields my $memo = $self->{'memo'}; if (not defined $memo and not $self->{'openoptions'}{'ignorememo'}) { $memo = $self->{'memo'} = $self->init_memo_field() or return; @@ -1397,7 +1402,7 @@ =head1 VERSION -1.02 +1.06 =head1 AVAILABLE FROM @@ -1405,7 +1410,7 @@ =head1 AUTHOR -(c) 1997--2011 Jan Pazdziora. +(c) 1997--2016 Jan Pazdziora. All rights reserved. This package is free software; you can redistribute it and/or modify it under the same terms as Perl itself. diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/DBD-XBase-1.05/t/9_dbd_create.t new/DBD-XBase-1.06/t/9_dbd_create.t --- old/DBD-XBase-1.05/t/9_dbd_create.t 2011-03-06 07:31:28.000000000 +0100 +++ new/DBD-XBase-1.06/t/9_dbd_create.t 2015-05-02 11:55:00.000000000 +0200 @@ -11,7 +11,7 @@ print "Error returned from eval was:\n", $@; exit; } - print "1..12\n"; + print "1..16\n"; print "DBI loaded\n"; } @@ -118,6 +118,26 @@ } print "ok 12\n"; +my $table_info_sth = $dbh->table_info(); +if (defined $table_info_sth) { + print "ok 13\n"; + my $table_info_data = $table_info_sth->fetchall_arrayref; + if (defined $table_info_data) { + print "ok 14\n"; + if (scalar @$table_info_data != 12) { + print 'not '; + } + print "ok 15\n"; + my @tables = sort map { $_->[2] } grep { not defined $_->[0] and not defined $_->[1] and $_->[3] eq 'TABLE' } @$table_info_data; + my $expected_tables = 'afox5 ndx-char ndx-date ndx-num ntx-char rooms rooms1 test tstidx types write write1'; + if ("@tables" ne $expected_tables) { + print STDERR "Expected table_info: [$expected_tables]\nGot table_info: [@tables]\n"; + print 'not '; + } + print "ok 16\n"; + } +} + $dbh->disconnect(); 1; ++++++ cpanspec.yml ++++++ --- #description_paragraphs: 3 #description: |- # override description from CPAN #summary: override summary from CPAN #no_testing: broken upstream #sources: # - source1 # - source2 #patches: # foo.patch: -p1 # bar.patch: #preamble: |- # BuildRequires: gcc-c++ #post_prep: |- # hunspell=`pkg-config --libs hunspell | sed -e 's,-l,,; s, *,,g'` # sed -i -e "s,hunspell-X,$hunspell," t/00-prereq.t Makefile.PL #post_build: |- # rm unused.files #post_install: |- # sed on %{name}.files #license: SUSE-NonFree #skip_noarch: 1 #custom_build: |- #./Build build flags=%{?_smp_mflags} --myflag #custom_test: |- #startserver && make test #ignore_requires: Bizarre::Module
