| 1 |
lars |
1 |
a:22:{s:7:"attribs";a:6:{s:15:"packagerversion";s:5:"1.9.4";s:7:"version";s:3:"2.0";s:5:"xmlns";s:35:"http://pear.php.net/dtd/package-2.0";s:11:"xmlns:tasks";s:33:"http://pear.php.net/dtd/tasks-1.0";s:9:"xmlns:xsi";s:41:"http://www.w3.org/2001/XMLSchema-instance";s:18:"xsi:schemaLocation";s:147:"http://pear.php.net/dtd/tasks-1.0 http://pear.php.net/dtd/tasks-1.0.xsd http://pear.php.net/dtd/package-2.0 http://pear.php.net/dtd/package-2.0.xsd";}s:4:"name";s:13:"DB_DataObject";s:7:"channel";s:12:"pear.php.net";s:7:"summary";s:51:"An SQL Builder, Object Interface to Database Tables";s:11:"description";s:356:"DataObject performs 2 tasks:
|
|
|
2 |
1. Builds SQL statements based on the objects vars and the builder methods.
|
|
|
3 |
2. acts as a datastore for a table row.
|
|
|
4 |
The core class is designed to be extended for each of your tables so that you put the
|
|
|
5 |
data logic inside the data classes.
|
|
|
6 |
included is a Generator to make your configuration files and your base classes.";s:4:"lead";a:4:{s:4:"name";s:12:"Alan Knowles";s:4:"user";s:6:"alan_k";s:5:"email";s:17:"alan@akbkhome.com";s:6:"active";s:3:"yes";}s:4:"date";s:10:"2011-08-29";s:4:"time";s:8:"04:19:19";s:7:"version";a:2:{s:7:"release";s:5:"1.9.6";s:3:"api";s:5:"1.9.0";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:35:"http://www.php.net/license/3_01.txt";}s:8:"_content";s:16:"PHP License 3.01";}s:5:"notes";s:805:"Small fix release.
|
|
|
7 |
|
|
|
8 |
#18749 - Fix is_a() for 5.3.7+ due to php-core stupidity
|
|
|
9 |
#18602 - optimize fetch - thanks to shadesofgraylin
|
|
|
10 |
#18605 - optimize sprintf in toArray()
|
|
|
11 |
#18446 - use table() method rather than accessing static global.
|
|
|
12 |
#----- - toArray support for only returning returned columns use "0" as the second parameter
|
|
|
13 |
#----- - allow tableless dataobject connect() call to work
|
|
|
14 |
#----- - disable overload using DB_DATAOBJECT_NO_OVERLOAD on PHP5 - Im supprised no one ever noticed this - overload is EVIL ;)
|
|
|
15 |
#----- - Add autoJoin method, which will build a full join with all related tables.
|
|
|
16 |
#16867 - fix doc comments - change to public methods for the ones that are supposed to be overridden
|
|
|
17 |
#17637 - fix detection of non-existant links files resulting in defaulting to autolinks";s:8:"contents";a:1:{s:3:"dir";a:2:{s:7:"attribs";a:1:{s:4:"name";s:1:"/";}s:4:"file";a:7:{i:0;a:1:{s:7:"attribs";a:4:{s:14:"baseinstalldir";s:2:"DB";s:6:"md5sum";s:32:"b50c79d3a19d9e156c7bfd9a221fab55";s:4:"name";s:19:"DataObject/Cast.php";s:4:"role";s:3:"php";}}i:1;a:1:{s:7:"attribs";a:4:{s:14:"baseinstalldir";s:2:"DB";s:6:"md5sum";s:32:"8f7382a61580d5be68e31a7544d454d7";s:4:"name";s:27:"DataObject/createTables.php";s:4:"role";s:3:"php";}}i:2;a:1:{s:7:"attribs";a:4:{s:14:"baseinstalldir";s:2:"DB";s:6:"md5sum";s:32:"06e890beb94da0cfd9782b220989f25f";s:4:"name";s:20:"DataObject/Error.php";s:4:"role";s:3:"php";}}i:3;a:1:{s:7:"attribs";a:4:{s:14:"baseinstalldir";s:2:"DB";s:6:"md5sum";s:32:"3cdc2349086d9fd6bea4a8c09cc38186";s:4:"name";s:24:"DataObject/Generator.php";s:4:"role";s:3:"php";}}i:4;a:1:{s:7:"attribs";a:4:{s:14:"baseinstalldir";s:2:"DB";s:6:"md5sum";s:32:"9d98e006265435a3e6e8a3e08a659c3b";s:4:"name";s:16:"docs/example.ini";s:4:"role";s:3:"doc";}}i:5;a:1:{s:7:"attribs";a:4:{s:14:"baseinstalldir";s:2:"DB";s:6:"md5sum";s:32:"cdcc4ead8ef5e06df4381ca0976dcdad";s:4:"name";s:38:"scripts/DB_DataObject_createTables.bat";s:4:"role";s:6:"script";}}i:6;a:2:{s:7:"attribs";a:4:{s:14:"baseinstalldir";s:2:"DB";s:6:"md5sum";s:32:"b035e6bcb1cbdc4cf4d6eb4bc88dbc41";s:4:"name";s:14:"DataObject.php";s:4:"role";s:3:"php";}s:13:"tasks:replace";a:1:{s:7:"attribs";a:3:{s:4:"from";s:9:"@version@";s:2:"to";s:7:"version";s:4:"type";s:12:"package-info";}}}}}}s:12:"dependencies";a:2:{s:8:"required";a:3:{s:3:"php";a:1:{s:3:"min";s:3:"4.3";}s:13:"pearinstaller";a:1:{s:3:"min";s:7:"1.4.0b1";}s:7:"package";a:2:{i:0;a:3:{s:4:"name";s:2:"DB";s:7:"channel";s:12:"pear.php.net";s:3:"min";s:5:"1.7.0";}i:1;a:3:{s:4:"name";s:4:"Date";s:7:"channel";s:12:"pear.php.net";s:3:"min";s:5:"1.4.3";}}}s:8:"optional";a:1:{s:7:"package";a:2:{i:0;a:3:{s:4:"name";s:4:"MDB2";s:7:"channel";s:12:"pear.php.net";s:3:"min";s:8:"2.0.0RC1";}i:1;a:3:{s:4:"name";s:8:"Validate";s:7:"channel";s:12:"pear.php.net";s:3:"min";s:5:"0.1.1";}}}}s:10:"phprelease";s:0:"";s:9:"changelog";a:1:{s:7:"release";a:62:{i:0;a:5:{s:4:"date";s:10:"2010-07-07";s:7:"version";a:2:{s:7:"release";s:5:"1.9.5";s:3:"api";s:5:"1.9.0";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:35:"http://www.php.net/license/3_01.txt";}s:8:"_content";s:16:"PHP License 3.01";}s:5:"notes";s:127:"Small fix release.
|
|
|
18 |
|
|
|
19 |
fix bug #17554 - update when id=0 (or primary key is 0) - thanks to the persistance of Jacek Pawlowski";}i:1;a:5:{s:4:"date";s:10:"2010-06-21";s:7:"version";a:2:{s:7:"release";s:5:"1.9.4";s:3:"api";s:5:"1.9.0";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:35:"http://www.php.net/license/3_01.txt";}s:8:"_content";s:16:"PHP License 3.01";}s:5:"notes";s:774:"Bug Fixes
|
|
|
20 |
#17508 - whereAddIn used wrong method to quote strings
|
|
|
21 |
#6202 - better docs on getLinkArray - needs documentation as well really..
|
|
|
22 |
#17343 - tidy up padding code, - fix alignnment of comments in generated files (Original Patch
|
|
|
23 |
by madsliejensen)
|
|
|
24 |
#17289 - fix sequence_<table> = XXXXX (madsliejensen)
|
|
|
25 |
#17157 - use property_exists in newer versions of php.
|
|
|
26 |
|
|
|
27 |
|
|
|
28 |
|
|
|
29 |
New Features
|
|
|
30 |
#7590 - union support - thanks to Ian Carmichael
|
|
|
31 |
#----- - whereAdd in support for negative (prefix column with '!') and empty arrays forces 1=0 query.
|
|
|
32 |
#13798 - add hookpostvar for adding things like varchar len data etc.. as per req
|
|
|
33 |
#16267 - Linking Multiple foreign keys - supports links.ini id[] = table1:col1 id[] =...
|
|
|
34 |
#17049 - generate links.ini for postgres - by madsliejensen";}i:2;a:5:{s:4:"date";s:10:"2010-01-15";s:7:"version";a:2:{s:7:"release";s:5:"1.9.3";s:3:"api";s:5:"1.9.0";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:35:"http://www.php.net/license/3_01.txt";}s:8:"_content";s:16:"PHP License 3.01";}s:5:"notes";s:319:"Fix broken release (1.9.1 and 1.9.2)
|
|
|
35 |
|
|
|
36 |
fetchAll() / whereAddIn() Release version.
|
|
|
37 |
|
|
|
38 |
This version adds two new utility methods, that can speed up usage,
|
|
|
39 |
fetchAll() - does the $do->find() / while($do->fetch()) $ar[] = clone($do) loop, and more.
|
|
|
40 |
whereAddIn() - allows you to quickly build IN queries, with correct escaping.";}i:3;a:5:{s:4:"date";s:10:"2009-12-03";s:7:"version";a:2:{s:7:"release";s:5:"1.9.0";s:3:"api";s:5:"1.9.0";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:35:"http://www.php.net/license/3_01.txt";}s:8:"_content";s:16:"PHP License 3.01";}s:5:"notes";s:1066:"Modular Release version.
|
|
|
41 |
|
|
|
42 |
This version was designed to support multiple locations of DataObjects for use with
|
|
|
43 |
modular applications. - NOTE the change to ini_DATABASENAME may fixes the previous behaviour to
|
|
|
44 |
match the documented behaviour - however this may break existing installations.
|
|
|
45 |
|
|
|
46 |
New Features:
|
|
|
47 |
#------- class_location accepts multiple locations with PATH_SEPARATOR
|
|
|
48 |
#------- class_prefix accepts multiple prefixes with PATH_SEPARATOR
|
|
|
49 |
#------- ini_DATABASENAME merges all found ini files in paths (seperated by PATH_SEPARATOR)
|
|
|
50 |
previous behaviour was just to read the first. - this applies to matching links.ini files.
|
|
|
51 |
#12550 - disable_null_strings=full -- see the bug report for details - it is highly recommended not to use this feature,
|
|
|
52 |
as it may result in data being deleted from your database if not used carefully.
|
|
|
53 |
|
|
|
54 |
Notes:
|
|
|
55 |
#------- staticGet now marked depreciated.
|
|
|
56 |
#------- links_DATABASENAME does not support multiple paths
|
|
|
57 |
#------- staticAutoloadTable (depreciated) and staticGet (depreciated) do not support this feature";}i:4;a:5:{s:4:"date";s:10:"2009-08-12";s:7:"version";a:2:{s:7:"release";s:6:"1.8.12";s:3:"api";s:5:"1.8.6";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:35:"http://www.php.net/license/3_01.txt";}s:8:"_content";s:16:"PHP License 3.01";}s:5:"notes";s:100:"Licence upgrade Release
|
|
|
58 |
#----- - Changed Error and Cast Licence to 3.01 to keep Debian/Ubuntu happy.";}i:5;a:5:{s:4:"date";s:10:"2009-07-16";s:7:"version";a:2:{s:7:"release";s:6:"1.8.11";s:3:"api";s:5:"1.8.6";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:35:"http://www.php.net/license/3_01.txt";}s:8:"_content";s:16:"PHP License 3.01";}s:5:"notes";s:370:"Licence upgrade Release
|
|
|
59 |
#----- - Licence changed to 3.01 to keep Debian/Ubuntu happy.
|
|
|
60 |
#----- - Change order of preference for links in JoinAdd - prefer called table links over jointo table.
|
|
|
61 |
#----- - Retry support for connection failure on queries
|
|
|
62 |
#----- - Factory now uses '/' for database/table seperator (experimental)
|
|
|
63 |
#----- - Fix INSERT on Postresql with empty data.";}i:6;a:5:{s:4:"date";s:10:"2009-03-19";s:7:"version";a:2:{s:7:"release";s:6:"1.8.10";s:3:"api";s:5:"1.8.6";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:35:"http://www.php.net/license/3_01.txt";}s:8:"_content";s:16:"PHP License 3.01";}s:5:"notes";s:268:"Annual Release - Minor Bugfixs / Extra Features
|
|
|
64 |
|
|
|
65 |
#----- - Fix factory error with database name not found
|
|
|
66 |
#----- - Change factory multi-database call to use '/' rather than '.' so
|
|
|
67 |
that it can work with postgres (also syncs with what the original notes said)";}i:7;a:5:{s:4:"date";s:10:"2009-03-12";s:7:"version";a:2:{s:7:"release";s:5:"1.8.9";s:3:"api";s:5:"1.8.6";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:1213:"Annual Release - Minor Bugfixs / Extra Features
|
|
|
68 |
|
|
|
69 |
#15066 - limited support for POINT (at least generator creates something)
|
|
|
70 |
#14976 - add option generator_omit_database_var to prevent creation of
|
|
|
71 |
$database lines (Troy Anderson)
|
|
|
72 |
#13995 - incorrect test in sequence key for postgres
|
|
|
73 |
#14252 - doc comments on delete() corrected to say return value is no. of
|
|
|
74 |
rows affected on success
|
|
|
75 |
|
|
|
76 |
###### - ensure that tableinfo uses quote_identifiers_tableinfo
|
|
|
77 |
###### - add sqlite support to Cast blobs
|
|
|
78 |
###### - old skipEmpty check broke formating on setFrom
|
|
|
79 |
###### - remove previous checks on database dsn lookup - move it to factory.
|
|
|
80 |
###### - Fix count check for no keys. - By Jeffrey Pfau
|
|
|
81 |
###### - Add multidatabase factory() support - eg.
|
|
|
82 |
DB_DataObject::factory("mydatabase.mytable");
|
|
|
83 |
###### - Added checks to ensure that database names match requested ones.
|
|
|
84 |
#13773 - delete(true) honours join conditions
|
|
|
85 |
#13788 - test for error before re-writing definition table for MDB2 in Generator
|
|
|
86 |
#13789 - honour user specified MDB2 options in Generator
|
|
|
87 |
#13790 - support CLOB oracle
|
|
|
88 |
#12993 - add new option generator_secondary_key_match - set to false, to
|
|
|
89 |
disable key matching for secondary key types";}i:8;a:5:{s:4:"date";s:10:"2008-01-30";s:7:"version";a:2:{s:7:"release";s:5:"1.8.8";s:3:"api";s:5:"1.8.6";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:1240:"Minor Bugfix / Feature Release
|
|
|
90 |
|
|
|
91 |
Pre-chinese new year release (with lots of 8's...)
|
|
|
92 |
|
|
|
93 |
Bug Fixes
|
|
|
94 |
#12556 - Generator - pregmatch appears broken for replacing class name on updating files
|
|
|
95 |
#10112 - additional config option quote_identifiers_tableinfo for use with tableinfo on generator
|
|
|
96 |
Fixes issues with Oracle and quoting identifiers.
|
|
|
97 |
#11773 - problems with object->array[prop] setting on PHP5.2.3
|
|
|
98 |
** this may also have been fixed twice by fix for #11775
|
|
|
99 |
#12858 - MDB2 and postgres missing db_driver variable
|
|
|
100 |
#9902 - default portability options for MDB2 to not fix case.
|
|
|
101 |
#9658 - postgres DECIMAL using DB backend incorrectly
|
|
|
102 |
flagged as unknown - changed warning to suggest using MDB2
|
|
|
103 |
#11091 - count attempted to read quote identifiers before config was loaded
|
|
|
104 |
#11804 - insert with postgres/msql return wrong error message
|
|
|
105 |
#9364 - fix postgres native sequences with MDB
|
|
|
106 |
#11775 - unsetting of $this->_query causes overload setters/getters to
|
|
|
107 |
handle later uses of _query and break due to lack of array accessor support
|
|
|
108 |
#11634 - Windows fails to rename files if they exist - affecting Generator
|
|
|
109 |
(try and fix it so unix is still atomic)";}i:9;a:5:{s:4:"date";s:10:"2007-07-12";s:7:"version";a:2:{s:7:"release";s:5:"1.8.7";s:3:"api";s:5:"1.8.6";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:203:"Minor Bugfix Release
|
|
|
110 |
|
|
|
111 |
Bug Fixes:
|
|
|
112 |
#11586 - missing default value in Generator for class_prefix caused warning
|
|
|
113 |
#11584 - typo in Generator caused permissions to be incorrectly set on ini file.";}i:10;a:5:{s:4:"date";s:10:"2007-07-10";s:7:"version";a:2:{s:7:"release";s:5:"1.8.6";s:3:"api";s:5:"1.8.6";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:1461:"Minor Bugfix and Minor Feature addition release
|
|
|
114 |
|
|
|
115 |
Bug Fixes:
|
|
|
116 |
#11483 - show an error if pcre limits are not correctly set and generator tries to generate empty files
|
|
|
117 |
#11528 - sending like queries to escape does not escape % and _ - added additional parameter to
|
|
|
118 |
escape : [bool $likeEscape] is optional and can be used to force escaping of these characters
|
|
|
119 |
#10573 - fix permissions on generated files
|
|
|
120 |
#10573 - write Generated files to temp directory, then rename into place. - fixing locking issues
|
|
|
121 |
#10531 - correct fix for bug #9628 (support MDB2 for defaults())
|
|
|
122 |
#10454 - mssql uses wrong variable name for options.
|
|
|
123 |
#10175 - MDB2 does not return length value
|
|
|
124 |
#9573 - enable disable_null_strings to turn of "null"-> NULL replacements
|
|
|
125 |
#9625 - MDB2 support for MSSQL sequencies
|
|
|
126 |
#9644 - incorrect constant in foriegn key generation.
|
|
|
127 |
#9628 - support MDB2 for defaults()
|
|
|
128 |
#9839 - Invalid column names can not be supported, so warning is generated
|
|
|
129 |
#9834 - SQL2003 standards on Joins - adds brackets around ON()
|
|
|
130 |
#4266 - minor fix to appendJoin code
|
|
|
131 |
#9755 - generator showed php error if connection failed
|
|
|
132 |
#9730 - quote identifiers on composite joins
|
|
|
133 |
|
|
|
134 |
* feature request
|
|
|
135 |
#4266 - joins with multiple keys
|
|
|
136 |
#2216 - JOIN ON conversion of Where condition into ON arguments - patch by David Sanders
|
|
|
137 |
#---- add in docbook hooks to generator - as requested/coded by Vyacheslav Iutin";}i:11;a:5:{s:4:"date";s:10:"2006-12-15";s:7:"version";a:2:{s:7:"release";s:5:"1.8.5";s:3:"api";s:5:"1.8.5";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:2057:"Minor Bugfix and Minor Feature addition release
|
|
|
138 |
* #8876 - call free() after count - hopefully this will not break anything!
|
|
|
139 |
* #8736 - auto_increment check for MDB2 backend
|
|
|
140 |
* #8628 - tableInfo fix for MDB2
|
|
|
141 |
* #7792 - add integer[] and boolean[] support
|
|
|
142 |
* #7702 - memory leaks on getLinks() , free() is called
|
|
|
143 |
within getLinks(), - you still need to call free() after doing a
|
|
|
144 |
getLink() - as I suspect automagically doing that would cause
|
|
|
145 |
problems..
|
|
|
146 |
* #7409 - ibase support for filename based database names - not sure if this works, but
|
|
|
147 |
will ask reporter to test it..
|
|
|
148 |
* #7353 - postgres incorrect testing of t/f for booleans
|
|
|
149 |
* #7114 = generator of sequence keys and defaults using generator_no_ini
|
|
|
150 |
* #3773 - change last_value to currval - need to confirm this is the correct fix.
|
|
|
151 |
* #3152 - joinAdd requires join column to be in links.ini file
|
|
|
152 |
|
|
|
153 |
Feature Requests:
|
|
|
154 |
* Feature Request #4266 - Allow joins with multiple keys
|
|
|
155 |
|
|
|
156 |
Minor Changes:
|
|
|
157 |
* dont flush on debugging html output
|
|
|
158 |
* links.ini code generation based on schema (mysql[i] only) -
|
|
|
159 |
option:generate_links=true - thanks to Pacal Schoni
|
|
|
160 |
* add warning about unknown types in generator.
|
|
|
161 |
* only prefix database name, in joins when the two objects are of different databases
|
|
|
162 |
* nicer error message for !isreadable - thx to Euan Maxwell
|
|
|
163 |
* use class exists loader, so that relative test relative paths in
|
|
|
164 |
tests work, (also means that autoload may work...)
|
|
|
165 |
* remove pass by reference - why on earth that was there in the first place is totally beyond me...
|
|
|
166 |
* give derivedHookFunctions the ability to use the original input data
|
|
|
167 |
* add methods
|
|
|
168 |
getClassNameFromTableName(),
|
|
|
169 |
getFileNameFromTableName(),
|
|
|
170 |
getMethodNameFromColumnName(),
|
|
|
171 |
which allow you to set up your own mapping system by overriding them in
|
|
|
172 |
your extended generator.. it however needs some support in dataobjects so currently
|
|
|
173 |
flagged as EXPERIMENTAL";}i:12;a:5:{s:7:"version";a:2:{s:7:"release";s:5:"1.8.4";s:3:"api";s:5:"1.8.4";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2006-03-06";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:660:"Minor Bugfix and Minor Feature addition release
|
|
|
174 |
|
|
|
175 |
Bugs
|
|
|
176 |
----
|
|
|
177 |
#7006 - fix links due to removal of databaseStructure call in 1.8.3, added call
|
|
|
178 |
to connect();
|
|
|
179 |
#7012 - joinAdd fixed due to checking of wrong variable when buidling query on
|
|
|
180 |
mysql.
|
|
|
181 |
|
|
|
182 |
|
|
|
183 |
Features
|
|
|
184 |
--------
|
|
|
185 |
- Add support for defaults() generation in createTables/Generator,
|
|
|
186 |
when using the flag generator_add_defaults = yes or generator_no_ini = yes
|
|
|
187 |
a method defaults() is created in the table class, which contains
|
|
|
188 |
the default values for the table generated from the database.
|
|
|
189 |
Note: EXPERIMENTAL and only works with Mysql[i] at present.";}i:13;a:5:{s:7:"version";a:2:{s:7:"release";s:5:"1.8.3";s:3:"api";s:5:"1.8.3";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2006-03-03";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:1097:"Minor Bugfix and Minor Feature addition release
|
|
|
190 |
|
|
|
191 |
Bugs
|
|
|
192 |
----
|
|
|
193 |
- Remove Warning if class_prefix is not set, and allow it not to be set.
|
|
|
194 |
- joinAdd() support for DB_DataObject::cast() objects (Daniel Braga)
|
|
|
195 |
- MDB2 fixes for undefined constants (bate)
|
|
|
196 |
-
|
|
|
197 |
#6772 - Support for FLOAT4 type in postgres
|
|
|
198 |
#6953 - Changed memory allocation of stored column values for SQL return when
|
|
|
199 |
Fetching last item of an object. Fixing problem of missing columns on
|
|
|
200 |
Last fetch from Join being broken when used with toArray().
|
|
|
201 |
#6928 - Defaulting to prefixing database name in joins for Mysql and Mysqli
|
|
|
202 |
backends, so multiple joins across multiple databases work.
|
|
|
203 |
|
|
|
204 |
|
|
|
205 |
Features
|
|
|
206 |
--------
|
|
|
207 |
- Add support for option 'generator_no_ini => true', which generates class
|
|
|
208 |
files with schema defined inside the table(), keys() and sequenceKeys()
|
|
|
209 |
(based on work and suggestions by Didler Galland and Justin Patrin)
|
|
|
210 |
- SQL output for debugging now has line breaks to make it easier to read.
|
|
|
211 |
|
|
|
212 |
- SelectAs uses quote itendifiers for target format.";}i:14;a:5:{s:7:"version";a:2:{s:7:"release";s:5:"1.8.2";s:3:"api";s:5:"1.8.2";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2004-01-21";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:75:"Minor Bugfix release
|
|
|
213 |
|
|
|
214 |
Bugs
|
|
|
215 |
----
|
|
|
216 |
#6543 - Generator broke due to MDB changes.";}i:15;a:5:{s:7:"version";a:2:{s:7:"release";s:5:"1.8.1";s:3:"api";s:5:"1.8.1";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2006-01-20";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:435:"Bugs
|
|
|
217 |
----
|
|
|
218 |
#6153 - dont call autoload on PHP5 - kludgy wrapper around class_exists()
|
|
|
219 |
#6458 - clear staticGet cache when calling free()
|
|
|
220 |
#6442 - validation not working correctly on DB_DataObject_Cast Objects
|
|
|
221 |
Changes/New Features
|
|
|
222 |
--------------------
|
|
|
223 |
* fix warning if setFrom called with object..
|
|
|
224 |
* make createTables honour debug level in ini file.
|
|
|
225 |
* Added support in generator, for MDB2 backend to generate the class files (bate)";}i:16;a:5:{s:7:"version";a:2:{s:7:"release";s:5:"1.8.0";s:3:"api";s:5:"1.8.0";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2005-12-28";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:2352:"Major Bug Fix & Feature release.
|
|
|
226 |
|
|
|
227 |
Bugs:
|
|
|
228 |
|
|
|
229 |
#4871 - remove warning when value is not found in table
|
|
|
230 |
#4834 - case sensitive checks for db_dataobject_cast fail
|
|
|
231 |
#4894 - Validate methods can return PEAR Errors, or even
|
|
|
232 |
messages now.. - only true indicates success
|
|
|
233 |
#4938 - support MONEY type for MSSQL
|
|
|
234 |
#4968 - count() will not be affected by changing default
|
|
|
235 |
db fetchmode
|
|
|
236 |
#5036 - make sure DB is loaded before using it
|
|
|
237 |
#5264 - add optional dep on MDB
|
|
|
238 |
#5416 - use tablea AS tableb only for postgress/mysql -
|
|
|
239 |
oracle doesnt need the AS bit - and I guess a few others too..
|
|
|
240 |
available and first fetch fails
|
|
|
241 |
conditions
|
|
|
242 |
#5614 - joinAdd check to see if object being joined is
|
|
|
243 |
really a dataobject
|
|
|
244 |
#5065 - count returns number cast to an integer (even
|
|
|
245 |
though database may return a string)
|
|
|
246 |
#5800 - generator will continue creating other tables if we find one
|
|
|
247 |
that fails...
|
|
|
248 |
#5881 - wrap conditions with extra brackets
|
|
|
249 |
remaining checks in validate
|
|
|
250 |
#5393 - flag up unique only keys as "U", rather than "K"
|
|
|
251 |
(or "N" for native) to allow anything calling keys() to find more
|
|
|
252 |
detailed information - should have no effect on the dataobject
|
|
|
253 |
class, as only sequence keys looks for "K"
|
|
|
254 |
|
|
|
255 |
Feature Requests:
|
|
|
256 |
|
|
|
257 |
#5146 - option: generator_var_keyword,
|
|
|
258 |
to specify if you want to use var or public
|
|
|
259 |
|
|
|
260 |
Other Changes
|
|
|
261 |
|
|
|
262 |
default behaviour.. so it shouldnt really have affected anyone..
|
|
|
263 |
amazed no one picked this up before..
|
|
|
264 |
* make WHERE stripping better = well spotted Justin
|
|
|
265 |
* catch errors returned from nextID - like permission denied etc.,
|
|
|
266 |
add warnings in debug mode if we are using objects or arrays for
|
|
|
267 |
some reason, fix error messages
|
|
|
268 |
* correct the dependancy on packages
|
|
|
269 |
* the dont die here causes a recursive error and segfaults
|
|
|
270 |
everything if it doesnt return..
|
|
|
271 |
* use is_a, rather than PEAR, as one day we may remove that dep...
|
|
|
272 |
* fix PHP4.4* issues with returning by reference..
|
|
|
273 |
* make debugging schema loading errors a bit easier
|
|
|
274 |
* test for bug #5931 added to test 91
|
|
|
275 |
* update($dataobject), change check for changes to strict checking,
|
|
|
276 |
so that 0001 -> 00001 works, along with many other situations..,
|
|
|
277 |
remove extra ; from code
|
|
|
278 |
* fix null detection on postgres, - patch by Alistair MacDonald
|
|
|
279 |
* free result columns as well as results after fetching all rows.";}i:17;a:5:{s:7:"version";a:2:{s:7:"release";s:6:"1.7.15";s:3:"api";s:6:"1.7.15";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2005-07-07";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:86:"Minor Bugfix release
|
|
|
280 |
* fix bug #4760 - DB_DataObject_Cast blobs broke in last release";}i:18;a:5:{s:7:"version";a:2:{s:7:"release";s:6:"1.7.14";s:3:"api";s:6:"1.7.14";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2004-06-25";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:2028:"Bugfix release (Mostly)
|
|
|
281 |
Special thanks to Dan Rossi for the MDB Backend work on this release.
|
|
|
282 |
|
|
|
283 |
Key changes:
|
|
|
284 |
- SQLlite support for files.
|
|
|
285 |
- MDB Backend support (experimental) use:
|
|
|
286 |
db_driver = MDB
|
|
|
287 |
as a config option.
|
|
|
288 |
NOTE: the generator will probably not work.
|
|
|
289 |
|
|
|
290 |
- toArray() has an extra argument (bool)hideEmpty,
|
|
|
291 |
which prevents it returning key/value pair when the value is empty
|
|
|
292 |
- DB_DataObject_Cast object was redesigned to enable better quoting of
|
|
|
293 |
blobs
|
|
|
294 |
- PostgresSQL schema for tablenames can be removed with the
|
|
|
295 |
generator_strip_schema = 1
|
|
|
296 |
- Fetch return value and object->N are now "true", rather than 1
|
|
|
297 |
when numRows is not supported, (also document it on find())
|
|
|
298 |
|
|
|
299 |
|
|
|
300 |
Bugs Fixed.
|
|
|
301 |
* fix bug #4672 - query(COMMIT) relays return value from DB->commit()
|
|
|
302 |
* fix bug #4535 - fix update/select etc. for postgres with boolean values.
|
|
|
303 |
* fix bug #4601 - wrong method used to test if file for sqlite
|
|
|
304 |
* fix bug #4193 - sqlite names causing invalid .ini files
|
|
|
305 |
* fix bug #4518 - escape and transactions fixed for MDB backend
|
|
|
306 |
* fix bug #4431 - add hideEmpty to toArray() - not sure if I really
|
|
|
307 |
like this.. - adding args to methods, the root of all evil ;)
|
|
|
308 |
* fix bug #4383 - generator getListOf() call now expects pear errors
|
|
|
309 |
* fix bug #4235
|
|
|
310 |
#4203 - schema mess with postgres.
|
|
|
311 |
generator_strip_schema=1
|
|
|
312 |
will strip the schema part from the name of the table.
|
|
|
313 |
* fix bug #4168 - if connection test is sucessfull, dont try and
|
|
|
314 |
connect.. (performance improvement)
|
|
|
315 |
* fix bug #4040 - prevent toArray from calling getLink and getLinks
|
|
|
316 |
* fix bug #4019 - createTables uses sets up options for DB
|
|
|
317 |
compatibility mode
|
|
|
318 |
* fix bug #4000 - better checking for php 4.3.10
|
|
|
319 |
* fix bug #3944 - support for informix autoincrements
|
|
|
320 |
* fix bug #4182 - better string and blob support on mysql in cast
|
|
|
321 |
* fix bug #4135 - boolean values borked in condition building..";}i:19;a:5:{s:7:"version";a:2:{s:7:"release";s:6:"1.7.13";s:3:"api";s:6:"1.7.13";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2005-03-24";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:86:"Minor Bugfix release
|
|
|
322 |
#3943 - postgres booleans broke again due to last fix for mysqli.";}i:20;a:5:{s:7:"version";a:2:{s:7:"release";s:6:"1.7.12";s:3:"api";s:6:"1.7.12";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2004-03-23";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:150:"Daily Bugfix release. ;)
|
|
|
323 |
#3898 - mysqli quote bug fixed. (Greg Beaver)
|
|
|
324 |
#------ provisional support for mysql blobs in Cast object (Antony Jankelowitz)";}i:21;a:5:{s:7:"version";a:2:{s:7:"release";s:6:"1.7.11";s:3:"api";s:6:"1.7.11";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2005-03-22";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:185:"Minor Bugfix release.
|
|
|
325 |
#3898 - fix count , which got broken by previous distinct argument changes
|
|
|
326 |
#------ support $x IS NOT NULL using $obj->value = DB_DataObject_Cast::sql("NOT NULL");";}i:22;a:5:{s:7:"version";a:2:{s:7:"release";s:6:"1.7.10";s:3:"api";s:6:"1.7.10";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2005-03-16";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:77:"Minor Bugfix release.
|
|
|
327 |
#3829 - joinAdd fix for database prefixing (yet again)";}i:23;a:5:{s:7:"version";a:2:{s:7:"release";s:5:"1.7.9";s:3:"api";s:5:"1.7.9";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2005-03-12";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:115:"Minor Bugfix release.
|
|
|
328 |
#3764 - toValue(), and hence toArray() cast booleans to true|false. (previous fix was buggy)";}i:24;a:5:{s:7:"version";a:2:{s:7:"release";s:5:"1.7.8";s:3:"api";s:5:"1.7.8";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2005-03-12";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:439:"Minor Bugfix release.
|
|
|
329 |
#3764 - toValue(), and hence toArray() cast booleans to true|false.
|
|
|
330 |
#3763 - createTables.php defines NO_OVERLOAD to prevent warnings on PHP4.3.10.
|
|
|
331 |
|
|
|
332 |
#3768 - Hopefully last fix to joinAdd() / database prefixing and quoteIdentifiers
|
|
|
333 |
#3761 - Fixed DB_DataObject::datetime() bad code.
|
|
|
334 |
#3783 - count('distinct') builds the query distinct [primary_key], should help in some situations
|
|
|
335 |
using joinAdd + group By etc.";}i:25;a:5:{s:7:"version";a:2:{s:7:"release";s:5:"1.7.7";s:3:"api";s:5:"1.7.7";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2005-03-07";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:271:"Minor bug fix release - join add with table fixes broke for mysql with last release
|
|
|
336 |
Bug Fixes:
|
|
|
337 |
#---- - Joins incorrectly prefect database name for mysql/mysqli
|
|
|
338 |
(Thanks to Mark Mitchenall for spotting this)
|
|
|
339 |
#---- used wrong variable for checking prefixes.
|
|
|
340 |
(Stephane Gully)";}i:26;a:5:{s:7:"version";a:2:{s:7:"release";s:5:"1.7.6";s:3:"api";s:5:"1.7.6";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2005-03-05";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:349:"Nothing like a big release to create bugs..
|
|
|
341 |
|
|
|
342 |
Note: the last release also included method creation for setters and getters,
|
|
|
343 |
which got missed out from the changelog.
|
|
|
344 |
Bug Fixes:
|
|
|
345 |
#3708 - Generator did not clear last files contents when generating new files.
|
|
|
346 |
#3706 - Joins broke on everything except mysql (database prefix now only added to mysql)";}i:27;a:5:{s:7:"version";a:2:{s:7:"release";s:5:"1.7.5";s:3:"api";s:5:"1.7.5";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2005-03-02";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:1414:"A few releases where skipped, this should be the amalgamated upgrade!
|
|
|
347 |
|
|
|
348 |
Note: php4.3.10 will exit with an error if you dont define NO_OVERLOAD, rather
|
|
|
349 |
than segfaulting..
|
|
|
350 |
|
|
|
351 |
Generator is buggy with 5.0.3 - upgrade DB or PHP..
|
|
|
352 |
|
|
|
353 |
Bug Fixes:
|
|
|
354 |
#3584 - Cast now supports time and datetime, (theiron)
|
|
|
355 |
#3645 - PHP4 clone FC hack now calls $obj->__clone() in a similar way to PHP5
|
|
|
356 |
#2928 - lastError contains the last error when query bugs out now.
|
|
|
357 |
#2674 - column names null / true /false etc. now halt createtables
|
|
|
358 |
#2778 - more informative warning shown when postgres bug is found.
|
|
|
359 |
#---- - experimental multidatabase join support
|
|
|
360 |
#2739 - sleep is relayed into __call - bug in PHP5
|
|
|
361 |
#2565 - oci8 NUMBER type recoginzed
|
|
|
362 |
#---- - new option generate_add_validate_stubs = 1, creates validate stubs.
|
|
|
363 |
#---- - more comprehensive limit support (Lutz Thomas)
|
|
|
364 |
#---- - allow access to columns starting with _ eg. set_xxx() & get_xxx()
|
|
|
365 |
(Sandro)
|
|
|
366 |
#---- - Generator write E_STRICT code for PHP5 now
|
|
|
367 |
#2441 - Debugging code removed.
|
|
|
368 |
|
|
|
369 |
#---- - multiple HAVING calls now supported.
|
|
|
370 |
#2468 - remove warning hider.
|
|
|
371 |
#2318 - update($do) when no changes detected returns true.
|
|
|
372 |
#2319 - joinAdd does not use AS when table and target have same name.
|
|
|
373 |
#---- - Dia diagram generation tools available in CVS (build diagrams from dataobjects)
|
|
|
374 |
|
|
|
375 |
#2267 - additional debugging information available at connect time";}i:28;a:5:{s:7:"version";a:2:{s:7:"release";s:5:"1.7.2";s:3:"api";s:5:"1.7.2";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2004-08-28";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:560:"Minor bug fix / Minor feature addition release
|
|
|
376 |
|
|
|
377 |
|
|
|
378 |
Bug Fixes:
|
|
|
379 |
#1835 - more fixes to ensure that joinAdd works correctly.
|
|
|
380 |
#2106 - Update with old object having no changes does not raise an error
|
|
|
381 |
#---- - fixed problem of call() code producing parse error on PHP5.0.1
|
|
|
382 |
#2205 - fixed case sensitivity of PHP5 call()
|
|
|
383 |
#---- - fixed undefined index in delete after a fetch()
|
|
|
384 |
|
|
|
385 |
Features Added:
|
|
|
386 |
#2086 - Support for buliding dataobjects for Views (use option build_view=1)
|
|
|
387 |
#2240 - factory() called on a dataobject returns a new instance of that object.";}i:29;a:5:{s:7:"version";a:2:{s:7:"release";s:5:"1.7.1";s:3:"api";s:5:"1.7.1";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2004-08-09";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:219:"Minor bug fix release
|
|
|
388 |
|
|
|
389 |
|
|
|
390 |
Bug Fixes:
|
|
|
391 |
#2088 - class_prefix may be left out.
|
|
|
392 |
#------ php4.2 compatibility should work as advertised in last realease
|
|
|
393 |
#------ Generator didnt have DB loaded due to lazy load changes.";}i:30;a:5:{s:7:"version";a:2:{s:7:"release";s:5:"1.7.0";s:3:"api";s:5:"1.7.0";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2004-06-03";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:1618:"Major bug fix release, Minor features added.
|
|
|
394 |
|
|
|
395 |
|
|
|
396 |
Bug Fixes:
|
|
|
397 |
#1559 - __FUNCTION__ remove, so dependancy on php 4.2 may still be valid.
|
|
|
398 |
#1595 - regex include/exclude working correctly (Thanks to Stephane Gully)
|
|
|
399 |
#1664 - configuration line links_{databasename} now available
|
|
|
400 |
#1726 - enable orderby and limit can be used with delete()
|
|
|
401 |
#1697 - prevent generator from adding an extra line created after definition.
|
|
|
402 |
#1704 - update only adds null when the column is not marked 'not null'
|
|
|
403 |
#1778 - toArray() returns a merge of defined table and actual results
|
|
|
404 |
#1828 - Generator will die, if tableinfo is not supported.
|
|
|
405 |
#1833 - links() now returns an empty array (no links) or null (no links.ini)
|
|
|
406 |
so it can be used generically with : $ar = (array) $do->links();
|
|
|
407 |
#1835 - getLinks, getLink etc. now use ->links(), so you can define your
|
|
|
408 |
own links() to return table links, rather than use links.ini files.
|
|
|
409 |
#1923 - removed all @ silencers, and replace with empty/isset.
|
|
|
410 |
#1935 - selectAs() - removed double quoteIdentifiers
|
|
|
411 |
#2068 - workaround for DB bug, postgres nextval() being rawurlencoded
|
|
|
412 |
#1980 - logic error when using quoteIdentifiers
|
|
|
413 |
|
|
|
414 |
Changes:
|
|
|
415 |
* DebugLevel(1) now displays native errors from database when queries fail.
|
|
|
416 |
* Result Field names now stored seperately from Result Object
|
|
|
417 |
* free() method added, to clean up memory instantly, if you are doing alot of queries.
|
|
|
418 |
= Cleans Result Fields, Result Object, NumRows returned in Connection object.
|
|
|
419 |
* include path is used to do file hunting if factory fails to find file.
|
|
|
420 |
* DB is lazy loaded on connection.b";}i:31;a:5:{s:7:"version";a:2:{s:7:"release";s:5:"1.6.1";s:3:"api";s:5:"1.6.1";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2004-06-03";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:58:"Minor Bug Fix
|
|
|
421 |
|
|
|
422 |
* fixed count() breaks when countWhat used.";}i:32;a:5:{s:7:"version";a:2:{s:7:"release";s:5:"1.6.0";s:3:"api";s:5:"1.6.0";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2004-04-24";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:1823:"Minor Feature Release and many bug fixes..
|
|
|
423 |
|
|
|
424 |
* DB_DataObject_Error added to enable testing for dataobject errors
|
|
|
425 |
* Date fixes - needs latest date package.
|
|
|
426 |
* Generator fails with clear message if backend doesnt support tableInfo
|
|
|
427 |
* added cidr, inet, macaddr for postgres
|
|
|
428 |
* new options to filter generation of classes
|
|
|
429 |
generator_include_regex = /foo_.*/i
|
|
|
430 |
generator_exclude_regex = /tmp_.*/i
|
|
|
431 |
* result column list is now stored for all queries (in the result object)
|
|
|
432 |
so toArray() allways relates to the query.
|
|
|
433 |
* php version correted in package file.
|
|
|
434 |
* getLinks called before other database call fixed.
|
|
|
435 |
* Updating without changing things, no longer raises a pear error,
|
|
|
436 |
it just returns 0 (eg. no rows affected)
|
|
|
437 |
* now Depends on 1.4 DB - escapeSimple is now used
|
|
|
438 |
* extra option to disable assumtions to use pear db's nextID
|
|
|
439 |
dont_use_pear_sequences = true
|
|
|
440 |
* DebugLevel($val) if $val is not an integer - it is assumed to be a callback.
|
|
|
441 |
* fixed clearing of data results after last fetch (reduces memory consumption
|
|
|
442 |
when doing many queries)
|
|
|
443 |
* strtolower any class name tests.
|
|
|
444 |
* count accepts 1 or 2 arguments
|
|
|
445 |
$countWhat or $whereAddonly, or $countWhat and $whereAddonly
|
|
|
446 |
eg. $countWhat = "distinct id"
|
|
|
447 |
eg. $countWhat = true (means $whereAdd = true)
|
|
|
448 |
* selectAdd() returns existing value, so you can modify it.
|
|
|
449 |
* most debugging & raiseError calls are dynamic, so you can overload them.
|
|
|
450 |
* numbers allowed in tablenames.
|
|
|
451 |
* ini filename uses database_{projectname} => {projectname}.ini so
|
|
|
452 |
database names are portable, and multiple projects are theoretically feasible.
|
|
|
453 |
* __clone is replaced with clone() for PHP5 compaitiblity.
|
|
|
454 |
* use PEAR::getStaticProperty("DB","options") for oracle portablity settings.
|
|
|
455 |
* null checked against not null spec.
|
|
|
456 |
|
|
|
457 |
And probably a few more - as it's been quite a while since the last release..";}i:33;a:5:{s:7:"version";a:2:{s:7:"release";s:5:"1.5.3";s:3:"api";s:5:"1.5.3";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2004-01-29";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:500:"Bug fix release.
|
|
|
458 |
|
|
|
459 |
Changes:
|
|
|
460 |
- fixed toValue()
|
|
|
461 |
** previously did not work correclty..
|
|
|
462 |
** getXXX($format) correctly relays into toValue - see strftime / Data::format or sprintf
|
|
|
463 |
for formats, depending on column type.
|
|
|
464 |
|
|
|
465 |
Fixes
|
|
|
466 |
* fix bug #630 - correct handling of YEAR (it's an int)
|
|
|
467 |
* fix bug #630 - mysql timestamps are ingored for updated and insert (use query() if you want to change
|
|
|
468 |
them manually.
|
|
|
469 |
* fix bug #620 - limit accepts floats and doubles, as long as they are really integers..";}i:34;a:5:{s:7:"version";a:2:{s:7:"release";s:5:"1.5.2";s:3:"api";s:5:"1.5.2";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2004-01-24";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:963:"Bug fix release.
|
|
|
470 |
|
|
|
471 |
Changes:
|
|
|
472 |
- removed automatic strtotime() in setters and setFrom
|
|
|
473 |
** this is closer to the previous behaviour (it caused too many problems with strange dates
|
|
|
474 |
** if you set a date/time column with a number, it assumes it is a unixtimestamp
|
|
|
475 |
-- enables you to write setters like
|
|
|
476 |
function setSome_Date($value) { $this->fromValue('some_date',strtotime($value)); }
|
|
|
477 |
|
|
|
478 |
Fixes
|
|
|
479 |
* $DB_DataObject->getDatabaseConnection() will return a pear error if dont_die is set,
|
|
|
480 |
so it can be used to test connections.
|
|
|
481 |
* note changed on databaseStructure, it can be called statically and dynamically.
|
|
|
482 |
* fix bug #612 databaseStructure('databasename') will output the ini file structure array , with __keys
|
|
|
483 |
* fix bug #611 corrected comment about NO_OVERLOAD
|
|
|
484 |
* fix bug #603 to prevent clearing of queries after fetch, use the option keep_query_after_fetch = 1
|
|
|
485 |
* fix bug #359 (again) - _link_loaded array should only contain links that where sucessfully loaded";}i:35;a:5:{s:7:"version";a:2:{s:7:"release";s:5:"1.5.1";s:3:"api";s:5:"1.5.1";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2004-01-22";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:385:"Bug fix release.
|
|
|
486 |
Fixes
|
|
|
487 |
* fixed fromValue had problems with null and DataOBject_Cast objects
|
|
|
488 |
* NOT NULL checking enabled in fromValue (eg. setters)
|
|
|
489 |
* fix bug #605 - ability to specify sequence names
|
|
|
490 |
option sequence_{tablename} = {column} // default {tablename}_seq
|
|
|
491 |
option sequence_{tablename} = {column}:{sequence_name}
|
|
|
492 |
* Dependancy on Date added. (it is used by the setter/getters)";}i:36;a:5:{s:7:"version";a:2:{s:7:"release";s:3:"1.5";s:3:"api";s:3:"1.5";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2004-01-20";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:1559:"New Features / Fixes
|
|
|
493 |
* proxy and auto schema building
|
|
|
494 |
- you can use dataobjects wihout running create tables.
|
|
|
495 |
- schema is created on the fly if no schema file exists
|
|
|
496 |
- using config option proxy=full, a class is generated on the fly to
|
|
|
497 |
represent the tables.
|
|
|
498 |
* toValue and fromValue added as getter and setter providers
|
|
|
499 |
- they include date formating tools - eg.
|
|
|
500 |
$do->getBirthDay('%d/%m/%Y') will work with overload and PEAR::Date
|
|
|
501 |
to provide formated dates. (works with date/time and datetime)
|
|
|
502 |
- set*() will also call strtotime and PEAR::Date to try and read dates.\
|
|
|
503 |
setFrom will relay into fromValue() - hence auto fixing date entries
|
|
|
504 |
* make native key recognision a little better - changes ini file
|
|
|
505 |
format (key=N|K) - native or key. - BC protected... - ignores it
|
|
|
506 |
when it finds a number.. (Fixes bug #532)
|
|
|
507 |
* allow multiple updates on the same object - without adding lots
|
|
|
508 |
of id=.... on the end..
|
|
|
509 |
* transactions support works transparently by sending
|
|
|
510 |
$do->query('BEGIN'), $do->query('COMMIT'),$do->query('ROLLBACK')
|
|
|
511 |
will automatically relay into the DB methods.
|
|
|
512 |
* re-add support for sequence_{tablename} - prefered method is still
|
|
|
513 |
overriding sequenceKey, and returning correct values.
|
|
|
514 |
|
|
|
515 |
Bug Fixes
|
|
|
516 |
* fix bug #595 - replace non letters in class names with underscore..
|
|
|
517 |
* fix bug #532 - better recoginsion of sequence keys
|
|
|
518 |
* fix bug #528/#476 - typo fix (E_NOTICE error on $valu)
|
|
|
519 |
* fix bug #473 - query can return a DB_Error
|
|
|
520 |
* fix bug #501 - autoload/factory now uses full path (not require path)
|
|
|
521 |
* fix bug #507 - sequences broken";}i:37;a:5:{s:7:"version";a:2:{s:7:"release";s:3:"1.4";s:3:"api";s:3:"1.4";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2003-12-20";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:0:"";}i:38;a:5:{s:7:"version";a:2:{s:7:"release";s:3:"1.3";s:3:"api";s:3:"1.3";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2003-11-14";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:2182:"New Features
|
|
|
522 |
- Inserts and updates do not use keys in the data creation part of the query
|
|
|
523 |
(Markus Wolff)
|
|
|
524 |
|
|
|
525 |
- MsSQL native get_last_insert ID using SELECT @@IDENTITY
|
|
|
526 |
** you may want to consider using this with transactions eg.
|
|
|
527 |
$dataobject->query('BEGIN') and $dataobject->query('COMMIT')
|
|
|
528 |
to ensure thread safety. (Markus Wolff)
|
|
|
529 |
|
|
|
530 |
- DB_DataObject_Cast - a experimental generic casting feature for assigning variables
|
|
|
531 |
* Common usages:
|
|
|
532 |
// blobs
|
|
|
533 |
$dataObject->someblobfield = DB_DataObject_Cast::blob(file_get_contents('xxx.jpg'));
|
|
|
534 |
$dataObject->someblobfield = DB_DataObject_Cast::string('xxxxx');
|
|
|
535 |
|
|
|
536 |
|
|
|
537 |
// dates?
|
|
|
538 |
$dataObject->at_date = DB_DataObject_Cast::date('12/12/2000'); //Human
|
|
|
539 |
$dataObject->at_date = DB_DataObject_Cast::date('2000-12-12'); //ISO
|
|
|
540 |
$dataObject->at_date = DB_DataObject_Cast::date(2000,12,12); //YYYY,dd,mm
|
|
|
541 |
$d2 = DB_DataObject_Cast::date(); // today!
|
|
|
542 |
// some addition
|
|
|
543 |
$dataObject->expires = DB_DataObject_Cast::date($d1->year, $d1->month+30, $d1->day+30);
|
|
|
544 |
|
|
|
545 |
|
|
|
546 |
// raw sql????
|
|
|
547 |
$dataObject->maxids = DB_DataObject_Cast::sql('max(id) > 12');
|
|
|
548 |
$dataObject->emptyfield = DB_DataObject_Cast::sql('NULL');
|
|
|
549 |
|
|
|
550 |
You can extend this object to provide your own datatypes..
|
|
|
551 |
|
|
|
552 |
|
|
|
553 |
- PHP5 Compatibility
|
|
|
554 |
Return values should work with PHP5beta2
|
|
|
555 |
Overload (__call) should work with PHP5beta2
|
|
|
556 |
|
|
|
557 |
- table() and keys() Allow setting of data with a value
|
|
|
558 |
(so you can use dataobjects without extended instances.)
|
|
|
559 |
|
|
|
560 |
- factory/ getLinks and autoloading
|
|
|
561 |
Will use the full path location in config to check if the file exists,
|
|
|
562 |
after that it is included without warnings turned off..
|
|
|
563 |
(autoloading check to see if class exists first - should be faster)
|
|
|
564 |
|
|
|
565 |
Fixes:
|
|
|
566 |
- Validate is an optional dependency (Arnaud Limbourg)
|
|
|
567 |
- Bug #228, BOOL type on postgresql correctly quoted.
|
|
|
568 |
- Bug #133, No error is raised when calling fetch with no data returned,
|
|
|
569 |
just produces a debug warning now
|
|
|
570 |
- Bug #172,Turning of Overload
|
|
|
571 |
If you define DB_DATAOBJECT_NO_OVERLOAD to any value, then dataobjects will not be overloaded,
|
|
|
572 |
This is usefull when working with ZendOptimizer, that may segfault with certain optimization levels";}i:39;a:5:{s:7:"version";a:2:{s:7:"release";s:3:"1.2";s:3:"api";s:3:"1.2";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2003-08-07";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:575:"New Features:
|
|
|
573 |
- A Number of the private methods have been made Public,
|
|
|
574 |
changes:
|
|
|
575 |
- _get_table() = table()
|
|
|
576 |
- _get_keys() = keys()
|
|
|
577 |
additions
|
|
|
578 |
- tableName() = returns or assign the table name
|
|
|
579 |
- database() = returns or assign the database name
|
|
|
580 |
changes by Markus Wolff
|
|
|
581 |
POSSIBLE BC IMPLICATIONS: If you define _get_table or _get_keys manually (rather than using the ini file)
|
|
|
582 |
you should rename your methods table() and keys()
|
|
|
583 |
Fixes:
|
|
|
584 |
- Generator is now more tollerant of editors that alter the spaces before
|
|
|
585 |
the autocode markers ### (Andreas Ljunggren)";}i:40;a:5:{s:7:"version";a:2:{s:7:"release";s:3:"1.1";s:3:"api";s:3:"1.1";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2003-08-07";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:322:"Bug Fixes
|
|
|
586 |
- limit argument testing now accepts "10" (a string with an integer
|
|
|
587 |
in it, as a valid argument) (Demian Turner)
|
|
|
588 |
New Features
|
|
|
589 |
- JoinAdd has additional Argument $joinCol, so you can specify
|
|
|
590 |
multiple targets links of the same table, eg. user->friend,
|
|
|
591 |
user->parent both connect to the user table.. (Andy Crain)";}i:41;a:5:{s:7:"version";a:2:{s:7:"release";s:5:"1.0.2";s:3:"api";s:5:"1.0.2";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2003-07-31";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:70:"Minor Bugfix Release
|
|
|
592 |
- Fix static Get call, case sensitivity properly.";}i:42;a:5:{s:7:"version";a:2:{s:7:"release";s:5:"1.0.1";s:3:"api";s:5:"1.0.1";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2003-07-18";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:97:"Minor Bugfix Release
|
|
|
593 |
- Fix Select defaults back to * after an fetch
|
|
|
594 |
- Fix Update with NULL values";}i:43;a:5:{s:7:"version";a:2:{s:7:"release";s:3:"1.0";s:3:"api";s:3:"1.0";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2003-07-16";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:1231:"- Gold 1.0 Release.. - final stable release in this series. Future versions
|
|
|
595 |
(eg. 1.1.*(dev)->1.2.*(release)) series will be generally API compatible,
|
|
|
596 |
however is likely to use MDB rather than DB.
|
|
|
597 |
- fix bug #23983 - argument checking on whereAdd, orderBy, limit and a few others
|
|
|
598 |
(Mike Carter)
|
|
|
599 |
- fix bug with cache clearing not working with staticGet and update/insert
|
|
|
600 |
- null comparison for $object->var = 'null' will generate IS NULL query
|
|
|
601 |
- null insert/update works when using 'null' as a value.
|
|
|
602 |
- getLinks returns true on success
|
|
|
603 |
- getLinks now has a formatter eg. '_%s' is default to allow user to define the
|
|
|
604 |
format of variables to assign child objects to.
|
|
|
605 |
- generator uses UNIQUE only if no primary/autoincrement type field is found.
|
|
|
606 |
- added support for $object->having('sum(value) > 10');
|
|
|
607 |
- fetch will remove some query lines (so if you want to see how the query was built
|
|
|
608 |
you will have to print_r() the object after find(), and before fetch(), or just use
|
|
|
609 |
debugLevel(1)
|
|
|
610 |
- overload calls from setFrom and toArray do method checks, as overload is still proving to
|
|
|
611 |
be a little unstable especially with Zend Encoder. (Note: if DataObjects causes crashes
|
|
|
612 |
, remove the overload code at the bottom of DataObjects.php)";}i:44;a:5:{s:7:"version";a:2:{s:7:"release";s:4:"0.19";s:3:"api";s:4:"0.19";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2003-05-22";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:1661:"- fix bug #23712 - deleting (and probably updating as well) an object while
|
|
|
613 |
being fetched. (Michael McCarthy for spotting this)
|
|
|
614 |
- fix generator overwriting code when file was edited in a Windows editor
|
|
|
615 |
(Robert Janeczek)
|
|
|
616 |
- validation will not produce errors on empty numeric data by default.
|
|
|
617 |
- overload extension enabled to relay setFrom and toArray calls to get*, set*
|
|
|
618 |
methods, which are predefined as
|
|
|
619 |
getXXX = returns $object->XXX
|
|
|
620 |
setXXX($V) = returns true (or an error string if you create your own)
|
|
|
621 |
(only affects php-4.3.2RC2 or later..)
|
|
|
622 |
- selectAs($dataobject,'prefix_%s') to help control the way join queries return
|
|
|
623 |
their data * doing selectAs() - clears the select and sets it to table.id as id ... etc.
|
|
|
624 |
- joinAdd has 2 extra optional arguments
|
|
|
625 |
$dataObject->joinAdd($otherDataObject, $joinType, $joinAs)
|
|
|
626 |
existing behaviour (INNER Joins) is default (eg. no value)
|
|
|
627 |
$joinType can be:
|
|
|
628 |
INNER,LEFT,RIGHT = eg. INNER JOIN ... etc.
|
|
|
629 |
'' = just added with a , and the link conditions are added with a WHERE statement.
|
|
|
630 |
$joinAs can be used to name the table differently in the join eg.
|
|
|
631 |
SELECT .. FROM person INNER JOIN address as homeaddress ......
|
|
|
632 |
- setFrom has an extra optional parameter for formating: eg.
|
|
|
633 |
$object->setFrom($_POST,'prefix_%s') would map prefix_name to $object->name
|
|
|
634 |
the default is '%s' which is the same as the previous behaviour
|
|
|
635 |
- added option dont_die (default no) to ini file
|
|
|
636 |
default (no) means that DataObjects will emit a PEAR_ERROR_DIE on configuration and
|
|
|
637 |
programming errors
|
|
|
638 |
true or 1 means that you can write a PEAR::error handler to catch the errors and
|
|
|
639 |
display a nice it's not working message";}i:45;a:5:{s:7:"version";a:2:{s:7:"release";s:4:"0.18";s:3:"api";s:4:"0.18";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2003-05-17";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:645:"- add table prefix to autobuilt queries (assist in ambigous querys for joins)
|
|
|
640 |
(Daniel Von Fange)
|
|
|
641 |
- change update and delete to return the number of rows affected or false on failure
|
|
|
642 |
- various code tidy ups - standards etc. (Arnaud Limbourg)
|
|
|
643 |
- fix generator for postgres and mdb - use unique keys and look for 'nextval' as keys.
|
|
|
644 |
- fix no key insert bug (G Moxley Kempster)
|
|
|
645 |
- fix empty table bug in generator (Robert Janeczek)
|
|
|
646 |
- staticAutoloadTable(), now handles parse errors in included files alot cleaner
|
|
|
647 |
- added dependancies on PHP4.3, DB 1.3 and Validate (although Validate is optional)
|
|
|
648 |
- added table prefix to count query (Richard Wallace)";}i:46;a:5:{s:7:"version";a:2:{s:7:"release";s:4:"0.17";s:3:"api";s:4:"0.17";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2003-03-12";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:105:"- Usual post feature bug fix release
|
|
|
649 |
- fix loading of links.ini for joinAdd, getLinks etc. (Geoff Hopson)";}i:47;a:5:{s:7:"version";a:2:{s:7:"release";s:4:"0.16";s:3:"api";s:4:"0.16";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2003-03-06";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:752:"- replaced config storage - should improve performance
|
|
|
650 |
- removed production option (not required due to improved config storage)
|
|
|
651 |
- bugfix : added checks for is_array on ignore_sequence_keys (Hermen Heinen)
|
|
|
652 |
- add toArray($format) which supports sprintf to enable easy integration with
|
|
|
653 |
Quickforms etc. (Demian Turner)
|
|
|
654 |
- add optional dataobject as variable to update(), so you can update will
|
|
|
655 |
only create an update based on what has changed. (Geoff Hopson)
|
|
|
656 |
- add join condition to count() (Daniel Von Fange)
|
|
|
657 |
- modify limit() to work with postgresql and make it emit a fatal error if you
|
|
|
658 |
try this on databases that do not directly support limit queries. (Geoff Hopson)
|
|
|
659 |
* I'm open on better ideas for this - probably wrapping the find() select call";}i:48;a:5:{s:7:"version";a:2:{s:7:"release";s:4:"0.15";s:3:"api";s:4:"0.15";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2003-02-13";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:405:"- modified find(true), so that it calls fetch rather than fetchrow
|
|
|
660 |
so that overriding fetch will affect get() calls.
|
|
|
661 |
(probably depreciates fetchrow now .. shout if anyone is using it)
|
|
|
662 |
- added escape method as a quasi quote wrapper into pear::DB - useful for
|
|
|
663 |
building your own queries - eg. like requests.. (does not add quotes)
|
|
|
664 |
- fixed bug with delete not using primary key if it was set. (Ian Eure)";}i:49;a:5:{s:7:"version";a:2:{s:7:"release";s:4:"0.14";s:3:"api";s:4:"0.14";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2003-02-06";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:218:"- added get affected rows to update/insert/delete
|
|
|
665 |
they will return false if no data is affected and set
|
|
|
666 |
the Objects lastError value.
|
|
|
667 |
Note: databases that do not support affectedRows(), will always
|
|
|
668 |
return false.";}i:50;a:5:{s:7:"version";a:2:{s:7:"release";s:4:"0.13";s:3:"api";s:4:"0.13";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2003-01-23";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:80:"- bug fix release - debug_ignore_updates worked in reverse.. (Alexander Mazurov)";}i:51;a:5:{s:7:"version";a:2:{s:7:"release";s:4:"0.12";s:3:"api";s:4:"0.12";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2003-01-22";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:215:"- Usual post release bug fix.
|
|
|
669 |
- fixes *.links.ini incorrectly using *.links (Damian Turner)
|
|
|
670 |
- Adds the ability to get PEAR Connection and result objects
|
|
|
671 |
getDatabaseConnection() and getDatabaseResult() (jason rust)";}i:52;a:5:{s:7:"version";a:2:{s:7:"release";s:4:"0.11";s:3:"api";s:4:"0.11";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2003-01-21";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:476:"- changed connecition and result caching to use global private variable, rather
|
|
|
672 |
than getStaticProperty
|
|
|
673 |
- results objects are not stored on insert/update/delete (speed increase
|
|
|
674 |
on large inserts can be as much as 10x faster)
|
|
|
675 |
- bug fix - Checks that primary keys are integers (Anthony Juou)
|
|
|
676 |
- typo on No data returned warning
|
|
|
677 |
- unit tests in CVS
|
|
|
678 |
- new configuration option for whether to use insert id's and sequences.
|
|
|
679 |
- Generator no creates boolean bit (mitchell perilstein)";}i:53;a:5:{s:7:"version";a:2:{s:7:"release";s:4:"0.10";s:3:"api";s:4:"0.10";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2002-12-09";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:287:"- bug fix - Generator incorrectly set _database, causing generation of database.ini files to fail
|
|
|
680 |
- change addslashes to PEAR::DB::quote()
|
|
|
681 |
- generator now only replaces DB_DataObjects with extends variable if set,
|
|
|
682 |
you can use generator_rewrite_class to set what is a valid replacement.";}i:54;a:5:{s:7:"version";a:2:{s:7:"release";s:3:"0.9";s:3:"api";s:3:"0.9";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2002-12-06";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:45:"- bug fix release - dsn was not set correctly";}i:55;a:5:{s:7:"version";a:2:{s:7:"release";s:3:"0.8";s:3:"api";s:3:"0.8";}s:9:"stability";a:2:{s:7:"release";s:6:"stable";s:3:"api";s:6:"stable";}s:4:"date";s:10:"2002-09-21";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:835:"- changed to stable status as it appears to be pretty stable now.
|
|
|
683 |
- update and insert now return FALSE on error conditions (Peter Gebauer)
|
|
|
684 |
which can be checked using === FALSE, and the error obtained using $object->_lastError
|
|
|
685 |
- delete will only use primary keys if they are set, otherwise it will use all object
|
|
|
686 |
variables to build the condition. (Daniel Ferreira)
|
|
|
687 |
- Added derivedHookFunctions(), and derivedHookVar() to enable extensions to generator to
|
|
|
688 |
make user defined methods. (Michael Lund Rasmussen)
|
|
|
689 |
- support for INT4, BPCHAR, TIMESTAMPTZ and postres Primary keys (Xavier)
|
|
|
690 |
- better PEAR CS complience (tabs and TRUE -> true), removed short open tags in generator (Thomas Volkmar Worm)
|
|
|
691 |
- experimental addJoin method (Stijn de Reede)
|
|
|
692 |
- Allow active options array (eg. dynamic changing of database config) (Sergey Lipnevich)";}i:56;a:5:{s:7:"version";a:2:{s:7:"release";s:3:"0.6";s:3:"api";s:3:"0.6";}s:9:"stability";a:2:{s:7:"release";s:4:"beta";s:3:"api";s:4:"beta";}s:4:"date";s:10:"2002-09-10";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:62:"- bug fix release on insert (broke due to compatibility fixes)";}i:57;a:5:{s:7:"version";a:2:{s:7:"release";s:3:"0.5";s:3:"api";s:3:"0.5";}s:9:"stability";a:2:{s:7:"release";s:4:"beta";s:3:"api";s:4:"beta";}s:4:"date";s:10:"2002-09-07";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:196:"- fixed database.links.ini file loading in wrong location (Jens Fischer)
|
|
|
693 |
- fixed type on extends (Jens Fischer)
|
|
|
694 |
- added __clone() support to pre- php5 classes
|
|
|
695 |
- added multiple linked table support";}i:58;a:5:{s:7:"version";a:2:{s:7:"release";s:3:"0.4";s:3:"api";s:3:"0.4";}s:9:"stability";a:2:{s:7:"release";s:4:"beta";s:3:"api";s:4:"beta";}s:4:"date";s:10:"2002-08-21";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:48:"- Bug fix release - createTables used wrong argv";}i:59;a:5:{s:7:"version";a:2:{s:7:"release";s:3:"0.3";s:3:"api";s:3:"0.3";}s:9:"stability";a:2:{s:7:"release";s:4:"beta";s:3:"api";s:4:"beta";}s:4:"date";s:10:"2002-08-16";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:44:"- Fixed Globals requirement in createTables,";}i:60;a:5:{s:7:"version";a:2:{s:7:"release";s:3:"0.2";s:3:"api";s:3:"0.2";}s:9:"stability";a:2:{s:7:"release";s:4:"beta";s:3:"api";s:4:"beta";}s:4:"date";s:10:"2002-07-12";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:85:"Removed list method, First upload as pear package. - Documentation now in PEAR Manual";}i:61;a:5:{s:7:"version";a:2:{s:7:"release";s:3:"0.1";s:3:"api";s:3:"0.1";}s:9:"stability";a:2:{s:7:"release";s:4:"beta";s:3:"api";s:4:"beta";}s:4:"date";s:10:"2002-06-25";s:7:"license";a:2:{s:7:"attribs";a:1:{s:3:"uri";s:26:"http://www.php.net/license";}s:8:"_content";s:11:"PHP License";}s:5:"notes";s:9:"PEARified";}}}s:8:"filelist";a:7:{s:19:"DataObject/Cast.php";a:5:{s:14:"baseinstalldir";s:2:"DB";s:6:"md5sum";s:32:"b50c79d3a19d9e156c7bfd9a221fab55";s:4:"name";s:19:"DataObject/Cast.php";s:4:"role";s:3:"php";s:12:"installed_as";s:37:"/usr/share/php/DB/DataObject/Cast.php";}s:27:"DataObject/createTables.php";a:5:{s:14:"baseinstalldir";s:2:"DB";s:6:"md5sum";s:32:"8f7382a61580d5be68e31a7544d454d7";s:4:"name";s:27:"DataObject/createTables.php";s:4:"role";s:3:"php";s:12:"installed_as";s:45:"/usr/share/php/DB/DataObject/createTables.php";}s:20:"DataObject/Error.php";a:5:{s:14:"baseinstalldir";s:2:"DB";s:6:"md5sum";s:32:"06e890beb94da0cfd9782b220989f25f";s:4:"name";s:20:"DataObject/Error.php";s:4:"role";s:3:"php";s:12:"installed_as";s:38:"/usr/share/php/DB/DataObject/Error.php";}s:24:"DataObject/Generator.php";a:5:{s:14:"baseinstalldir";s:2:"DB";s:6:"md5sum";s:32:"3cdc2349086d9fd6bea4a8c09cc38186";s:4:"name";s:24:"DataObject/Generator.php";s:4:"role";s:3:"php";s:12:"installed_as";s:42:"/usr/share/php/DB/DataObject/Generator.php";}s:16:"docs/example.ini";a:5:{s:14:"baseinstalldir";s:2:"DB";s:6:"md5sum";s:32:"9d98e006265435a3e6e8a3e08a659c3b";s:4:"name";s:16:"docs/example.ini";s:4:"role";s:3:"doc";s:12:"installed_as";s:50:"/usr/share/php/docs/DB_DataObject/docs/example.ini";}s:38:"scripts/DB_DataObject_createTables.bat";a:5:{s:14:"baseinstalldir";s:2:"DB";s:6:"md5sum";s:32:"cdcc4ead8ef5e06df4381ca0976dcdad";s:4:"name";s:38:"scripts/DB_DataObject_createTables.bat";s:4:"role";s:6:"script";s:12:"installed_as";s:50:"/usr/bin/DB/scripts/DB_DataObject_createTables.bat";}s:14:"DataObject.php";a:5:{s:14:"baseinstalldir";s:2:"DB";s:6:"md5sum";s:32:"b035e6bcb1cbdc4cf4d6eb4bc88dbc41";s:4:"name";s:14:"DataObject.php";s:4:"role";s:3:"php";s:12:"installed_as";s:32:"/usr/share/php/DB/DataObject.php";}}s:12:"_lastversion";s:5:"1.9.5";s:7:"dirtree";a:6:{s:28:"/usr/share/php/DB/DataObject";b:1;s:17:"/usr/share/php/DB";b:1;s:38:"/usr/share/php/docs/DB_DataObject/docs";b:1;s:33:"/usr/share/php/docs/DB_DataObject";b:1;s:19:"/usr/bin/DB/scripts";b:1;s:11:"/usr/bin/DB";b:1;}s:3:"old";a:7:{s:7:"version";s:5:"1.9.6";s:12:"release_date";s:10:"2011-08-29";s:13:"release_state";s:6:"stable";s:15:"release_license";s:16:"PHP License 3.01";s:13:"release_notes";s:805:"Small fix release.
|
|
|
696 |
|
|
|
697 |
#18749 - Fix is_a() for 5.3.7+ due to php-core stupidity
|
|
|
698 |
#18602 - optimize fetch - thanks to shadesofgraylin
|
|
|
699 |
#18605 - optimize sprintf in toArray()
|
|
|
700 |
#18446 - use table() method rather than accessing static global.
|
|
|
701 |
#----- - toArray support for only returning returned columns use "0" as the second parameter
|
|
|
702 |
#----- - allow tableless dataobject connect() call to work
|
|
|
703 |
#----- - disable overload using DB_DATAOBJECT_NO_OVERLOAD on PHP5 - Im supprised no one ever noticed this - overload is EVIL ;)
|
|
|
704 |
#----- - Add autoJoin method, which will build a full join with all related tables.
|
|
|
705 |
#16867 - fix doc comments - change to public methods for the ones that are supposed to be overridden
|
|
|
706 |
#17637 - fix detection of non-existant links files resulting in defaulting to autolinks";s:12:"release_deps";a:6:{i:0;a:4:{s:4:"type";s:3:"php";s:3:"rel";s:2:"ge";s:7:"version";s:3:"4.3";s:8:"optional";s:2:"no";}i:1;a:6:{s:4:"type";s:3:"pkg";s:7:"channel";s:12:"pear.php.net";s:4:"name";s:4:"PEAR";s:3:"rel";s:2:"ge";s:7:"version";s:7:"1.4.0b1";s:8:"optional";s:2:"no";}i:2;a:6:{s:4:"type";s:3:"pkg";s:7:"channel";s:12:"pear.php.net";s:4:"name";s:2:"DB";s:3:"rel";s:2:"ge";s:7:"version";s:5:"1.7.0";s:8:"optional";s:2:"no";}i:3;a:6:{s:4:"type";s:3:"pkg";s:7:"channel";s:12:"pear.php.net";s:4:"name";s:4:"Date";s:3:"rel";s:2:"ge";s:7:"version";s:5:"1.4.3";s:8:"optional";s:2:"no";}i:4;a:6:{s:4:"type";s:3:"pkg";s:7:"channel";s:12:"pear.php.net";s:4:"name";s:4:"MDB2";s:3:"rel";s:2:"ge";s:7:"version";s:8:"2.0.0RC1";s:8:"optional";s:3:"yes";}i:5;a:6:{s:4:"type";s:3:"pkg";s:7:"channel";s:12:"pear.php.net";s:4:"name";s:8:"Validate";s:3:"rel";s:2:"ge";s:7:"version";s:5:"0.1.1";s:8:"optional";s:3:"yes";}}s:11:"maintainers";a:1:{i:0;a:5:{s:4:"name";s:12:"Alan Knowles";s:5:"email";s:17:"alan@akbkhome.com";s:6:"active";s:3:"yes";s:6:"handle";s:6:"alan_k";s:4:"role";s:4:"lead";}}}s:10:"xsdversion";s:3:"2.0";s:13:"_lastmodified";i:1314646605;}
|