FishEye: history xpdo/trunk/xpdo/om/mysql/xpdoquery.class.php

225 annotated / raw | Diffs: previous, other | Lines: 314 ( +1, -1 )

Created: 2008-08-28 11:31:55 -0500 (10 days ago) | Author: opengeek | Changeset: 225

* Changed calls from _log() to log(). (merged from branches/1.0 -r223:224)

209 annotated / raw | Diffs: previous, other | Lines: 314 ( +19, -3 )

Created: 2008-08-11 13:47:19 -0500 (27 days ago) | Author: opengeek | Changeset: 209

* Merging revisions 206:208 from branches/1.0

204 annotated / raw | Diffs: previous, other | Lines: 298 ( +2, -2 )

Created: 2008-04-25 14:42:35 -0500 (4 months 13 days ago) | Author: opengeek | Changeset: 204

* [#XPDO-16] xPDO::getCacheManager() always returns an instance of xPDOCacheManager.
* [#XPDO-15] update to warning message in xPDOObject::addOne()
* Licensing updates
[merged from branches/1.0 revs 201:203]

77 annotated / raw | Diffs: previous, other | Lines: 298 ( +4, -2 )

Created: 2007-10-25 12:03:40 -0500 (10 months ago) | Author: opengeek | Changeset: 77

* Modified @package statements for documentation purposes.

Branch point for: 1.0

74 annotated / raw | Diffs: previous, other | Lines: 296 ( +41, -30 )

Created: 2007-10-10 18:22:53 -0500 (10 months ago) | Author: opengeek | Changeset: 74

* Significant improvement to xPDOQuery::parseConditions() algorithm
        - This functionality was failing, especially in situations where users attempt to mix binding expressions (key => value)|(key => (value, type, length)) with raw SQL expressions, nested in an array; should now detect and handle these mixed expressions properly, regardless of how the expressions are nested in various array structures.
        - e.g. these two expressions, which did not work previously, should now:

array(
   'modUserGroupMember.member = modUser.id',
   'modUserGroupMember.user_group' => $_REQUEST['group'],
);
array(
   'modUserGroupMember.member = modUser.id',
   array ('modUserGroupMember.user_group' => $_REQUEST['group']),
);

73 annotated / raw | Diffs: previous, other | Lines: 285 ( +0, -0 )

Created: 2007-10-10 01:09:06 -0500 (10 months ago) | Author: opengeek | Changeset: 73

* Just tidying up some silly windows line endings that slipped in

71 annotated / raw | Diffs: previous, other | Lines: 285 ( +3, -19 )

Created: 2007-09-24 14:32:33 -0500 (11 months ago) | Author: opengeek | Changeset: 71

* Modified xPDOCriteria constructor to delay the prepare() unless cacheFlag is false (or less than 0), allowing cached xPDOCriteria statements to avoid requiring a database connection.
* Lots more documentation updates, changed license headers, etc.

46 annotated / raw | Diffs: previous, other | Lines: 301 ( +0, -1 )

Created: 2007-05-29 18:49:34 -0500 (15 months ago) | Author: opengeek | Changeset: 46

- Fix the handling of xPDO timestamp fields when dbtype is numeric (i.e. stored as unix timestamp).
- Remove unnecessary get() and set() in db specific xPDOObject implementations.
- Add more tokens for identifying conditional clauses in xPDOQuery::isConditionalClause().
- Minor path and require/include changes.

40 annotated / raw | Diffs: previous, other | Lines: 302 ( +1, -0 )

Created: 2007-04-23 02:24:00 -0500 (16 months ago) | Author: opengeek | Changeset: 40

- xPDOObject->getOne was assigning to _relatedObjects as reference and causing problems
- Corrected a few warnings in xPDOQuery
- Corrected an incorrect path in xPDOGenerator
- MakeForm needs additional refactoring and probably needs to be moved to the modx project at some point

36 annotated / raw | Diffs: previous, other | Lines: 301 ( +51, -301 )

Created: 2007-03-26 12:35:43 -0500 (17 months ago) | Author: opengeek | Changeset: 36

- Initial commit of 1.0 beta (potentially unstable)
- New aggregate and composite schema/map definitions
- simpler definitions are faster and easier to process
- refer to distinct relationships to another class by an alias rather than class name + key
- new owner attribute to indicate if the local or foreign object owns the foreign key value used to define the relationship
- to migrate:
   - modify schema:
     - add an alias attribute for each aggregate/composite relation (key attribute can be removed)
     - add an owner attribute for each aggregate/composite relation (value will be local or foreign)
   - Public API changes requiring code modifications (migration guide will be released with additional details):
     - xPDO class:
       - getObjectGraph()
       - getCollectionGraph()
       - getFKDefinition()
     - xPDOObject class and derivatives (i.e. all generated classes):
       - getOne()
       - getMany()
       - addOne()
       - addMany()
       - getFKDefinition()
     - xPDOQuery class
       - join()
       - innerJoin()
       - leftJoin()
       - rightJoin()
       - from()
       - bindGraph()
- New physical class/map structure to better support for platform-specific optimizations
- packages now require both a class file in the package root, as well as classes for each driver implementation in the appropriate subdirectory
- to migrate, move your existing classes to the package root, and regenerate from the schema to create the new driver specific class stubs

35 annotated / raw | Diffs: previous, other | Lines: 551 ( +53, -48 )

Created: 2007-02-25 15:48:53 -0600 (18 months ago) | Author: opengeek | Changeset: 35

- xPDOQuery::bindGraph() fixes to prevent rebinding the same graph or wiping out existing graphs.
- xPDOQuery::buildConditionalClause() and condition() fixes to better support grouping and conjunctions; still needs work.

34 annotated / raw | Diffs: previous, other | Lines: 546 ( +1, -1 )

Created: 2007-02-23 13:16:40 -0600 (18 months ago) | Author: opengeek | Changeset: 34

* PHP 4 fixes (use of stripos and PHP 4 constructor for PDO_ class was wrong)

32 annotated / raw | Diffs: previous, other | Lines: 546 ( +28, -9 )

Created: 2007-02-20 22:27:21 -0600 (18 months ago) | Author: opengeek | Changeset: 32

* API change in xPDOQuery::join(), innerJoin(), leftJoin(), and rightJoin(); inserted second parameter for a relation key to specify the specific relationship with a class.
* Added xPDOQuery->_alias to represent an alias for the base class of an xPDOQuery.

31 annotated / raw | Diffs: previous, other | Lines: 527 ( +9, -6 )

Created: 2007-02-17 13:07:41 -0600 (18 months ago) | Author: opengeek | Changeset: 31

* Fix for xPDOQuery :: join(); was overwriting existing join definitions rather than creating new ones on subsequent calls.
* Fix for xPDOObject :: addOne(); was adding a reference to a reference, which did not work with hydrate_rel_obj_vars configuration option.
* Added cacheFlag parameter xPDO :: newQuery() call in xPDO :: getCollectionGraph().
* Made default $key parameter on xPDO :: getFKDefinition() default to empty string.

27 new annotated / raw | Lines: 524 ( +524, -0 )

Created: 2007-02-15 00:08:22 -0600 (18 months ago) | Author: opengeek | Changeset: 27

* Introducing xPDOQuery, an extension to xPDOCriteria that provides an API for building a variety of common queries without the need for SQL:
-- methods include, command(), select(), from(), where(), groupby(), having(), limit(), join(), leftJoin(), rightJoin(), innerJoin(), and more
-- also provides support for automating queries to populate related object graphs in a single query
-- various refactoring of method implementations to make use of xPDOQuery
* Introduced simply FILE logging target to write error logs to the cache directory
* Added new methods to xPDO, including getCount(), getObjectGraph(), and getCollectionGraph()
* Added xPDOObject :: encode() to allow custom encoding of properties using various methods; provides md5 by default
* Bug fixes and additional features to xPDOObject :: remove() to prevent nasty loops with circular composite references; needs more work

FishEye

jump to detailed chart Line History

View Mode

Show Arbitrary Diff

Watches and RSS

History

latest revision trunk