Re: [CakePHP : The Rapid Development Framework for PHP] #5815: [PATCH]DboSource::calculate() should make use of $model param and should support 'SUM'
#5815: [PATCH]DboSource::calculate() should make use of $model param and should support 'SUM' +--- Reporter: rafaelbandeira3 | Owner: nate Type: Enhancement |Status: assigned Priority: Medium | Milestone: 1.3.x.x Component: Model| Version: Severity: Normal |Resolution: Keywords: dbosource calculate sum sql | Php_version: n/a Cake_version: | +--- Changes (by nate): * component: Core Libs = Model -- Ticket URL: https://trac.cakephp.org/ticket/5815#comment:7 CakePHP : The Rapid Development Framework for PHP https://trac.cakephp.org/ Cake is a rapid development framework for PHP which uses commonly known design patterns like ActiveRecord, Association Data Mapping, Front Controller and MVC. Our primary goal is to provide a structured framework that enables PHP users at all levels to rapidly develop robust web applications, without any loss to flexibility. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups tickets cakephp group. To post to this group, send email to tickets-cakephp@googlegroups.com To unsubscribe from this group, send email to tickets-cakephp+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/tickets-cakephp?hl=en -~--~~~~--~~--~--~---
Re: [CakePHP : The Rapid Development Framework for PHP] #5815: [PATCH]DboSource::calculate() should make use of $model param and should support 'SUM'
#5815: [PATCH]DboSource::calculate() should make use of $model param and should support 'SUM' +--- Reporter: rafaelbandeira3 | Owner: nate Type: Enhancement |Status: closed Priority: Medium | Milestone: 1.3.x.x Component: Model| Version: Severity: Normal |Resolution: fixed Keywords: dbosource calculate sum sql | Php_version: n/a Cake_version: | +--- Changes (by nate): * status: assigned = closed * resolution: = fixed Comment: The syntax provided in the second patch is invalid for some databases. Fixed in http://thechaw.com/cakephp/commits/view/24fd17428ec1aaa3a94e6c08905cffec0cfc349e#numbers -- Ticket URL: https://trac.cakephp.org/ticket/5815#comment:8 CakePHP : The Rapid Development Framework for PHP https://trac.cakephp.org/ Cake is a rapid development framework for PHP which uses commonly known design patterns like ActiveRecord, Association Data Mapping, Front Controller and MVC. Our primary goal is to provide a structured framework that enables PHP users at all levels to rapidly develop robust web applications, without any loss to flexibility. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups tickets cakephp group. To post to this group, send email to tickets-cakephp@googlegroups.com To unsubscribe from this group, send email to tickets-cakephp+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/tickets-cakephp?hl=en -~--~~~~--~~--~--~---
Re: [CakePHP : The Rapid Development Framework for PHP] #5815: [PATCH]DboSource::calculate() should make use of $model param and should support 'SUM'
#5815: [PATCH]DboSource::calculate() should make use of $model param and should support 'SUM' +--- Reporter: rafaelbandeira3 | Owner: nate Type: Enhancement |Status: assigned Priority: Medium | Milestone: 1.3.x.x Component: Core Libs| Version: Severity: Normal |Resolution: Keywords: dbosource calculate sum sql | Php_version: n/a Cake_version: | +--- Changes (by nate): * owner: = nate * status: new = assigned -- Ticket URL: https://trac.cakephp.org/ticket/5815#comment:6 CakePHP : The Rapid Development Framework for PHP https://trac.cakephp.org/ Cake is a rapid development framework for PHP which uses commonly known design patterns like ActiveRecord, Association Data Mapping, Front Controller and MVC. Our primary goal is to provide a structured framework that enables PHP users at all levels to rapidly develop robust web applications, without any loss to flexibility. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups tickets cakephp group. To post to this group, send email to tickets-cakephp@googlegroups.com To unsubscribe from this group, send email to tickets-cakephp+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/tickets-cakephp?hl=en -~--~~~~--~~--~--~---
[CakePHP : The Rapid Development Framework for PHP] #5815: [PATCH]DboSource::calculate() should make use of $model param and should support 'SUM'
#5815: [PATCH]DboSource::calculate() should make use of $model param and should
support 'SUM'
+---
Reporter: rafaelbandeira3 | Type: Bug
Status: new | Priority: Medium
Milestone: 1.2.x.x | Component: Core Libs
Version: RC3 | Severity: Normal
Keywords: dbosource calculate sum sql | Php_version: n/a
Cake_version: |
+---
- The current implementation must receive a Object reference, but it has
no use on the method.[[BR]]
I propose that the model should be used as the default holder of fields to
calculate:
{{{
$db-calculate($this-Task, 'count'); // COUNT(Task.*)
$db-calculate($this-Project, 'max', array('revision')); //
MAX(Project.revision)
}}}
- SUM is currently not supported, I'm not sure it's supported by all db
drivers, but if it is, it should be accepted too.
--
Ticket URL: https://trac.cakephp.org/ticket/5815
CakePHP : The Rapid Development Framework for PHP https://trac.cakephp.org/
Cake is a rapid development framework for PHP which uses commonly known design
patterns like ActiveRecord, Association Data Mapping, Front Controller and MVC.
Our primary goal is to provide a structured framework that enables PHP users at
all levels to rapidly develop robust web applications, without any loss to
flexibility.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
tickets cakephp group.
To post to this group, send email to tickets-cakephp@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/tickets-cakephp?hl=en
-~--~~~~--~~--~--~---
Re: [CakePHP : The Rapid Development Framework for PHP] #5815: [PATCH]DboSource::calculate() should make use of $model param and should support 'SUM'
#5815: [PATCH]DboSource::calculate() should make use of $model param and should support 'SUM' +--- Reporter: rafaelbandeira3 | Owner: Type: Bug |Status: new Priority: Medium | Milestone: 1.2.x.x Component: Core Libs| Version: RC3 Severity: Normal |Resolution: Keywords: dbosource calculate sum sql | Php_version: n/a Cake_version: | +--- Comment (by rafaelbandeira3): I think that DboSource::calculate() should also return an expression with DboSource::expression(), or it should force the usage only for table field names and return an identifier with DboSource::identifier() Not sure whether should I open a new ticket for this issue or no. -- Ticket URL: https://trac.cakephp.org/ticket/5815#comment:1 CakePHP : The Rapid Development Framework for PHP https://trac.cakephp.org/ Cake is a rapid development framework for PHP which uses commonly known design patterns like ActiveRecord, Association Data Mapping, Front Controller and MVC. Our primary goal is to provide a structured framework that enables PHP users at all levels to rapidly develop robust web applications, without any loss to flexibility. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups tickets cakephp group. To post to this group, send email to tickets-cakephp@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/tickets-cakephp?hl=en -~--~~~~--~~--~--~---
Re: [CakePHP : The Rapid Development Framework for PHP] #5815: [PATCH]DboSource::calculate() should make use of $model param and should support 'SUM'
#5815: [PATCH]DboSource::calculate() should make use of $model param and should support 'SUM' +--- Reporter: rafaelbandeira3 | Owner: Type: Enhancement |Status: new Priority: Medium | Milestone: 1.2.x.x Component: Core Libs| Version: RC3 Severity: Normal |Resolution: Keywords: dbosource calculate sum sql | Php_version: n/a Cake_version: | +--- Changes (by mark_story): * type: Bug = Enhancement Comment: Moved to enhancement. -- Ticket URL: https://trac.cakephp.org/ticket/5815#comment:3 CakePHP : The Rapid Development Framework for PHP https://trac.cakephp.org/ Cake is a rapid development framework for PHP which uses commonly known design patterns like ActiveRecord, Association Data Mapping, Front Controller and MVC. Our primary goal is to provide a structured framework that enables PHP users at all levels to rapidly develop robust web applications, without any loss to flexibility. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups tickets cakephp group. To post to this group, send email to tickets-cakephp@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/tickets-cakephp?hl=en -~--~~~~--~~--~--~---
