cvs: pearweb /tests/site/get test_opt.setup.php.inc test_opt.setup2.php.inc test_opt.setup3.php.inc test_opt.setup4.php.inc test_opt.setup5.php.inc
test_opt1.phpt test_opt10.phpt test_opt11.phpt test_opt2.phpt test_opt3.phpt test_opt4.phpt test_opt5.phpt test_opt6.phpt test_opt7.phpt
test_opt8.phpt test_opt9.phpt

From: Date: Sun, 10 Feb 2008 23:35:54 +0000
Subject: cvs: pearweb /tests/site/get test_opt.setup.php.inc test_opt.setup2.php.inc test_opt.setup3.php.inc test_opt.setup4.php.inc test_opt.setup5.php.inc
test_opt1.phpt test_opt10.phpt test_opt11.phpt test_opt2.phpt test_opt3.phpt test_opt4.phpt test_opt5.phpt test_opt6.phpt test_opt7.phpt
test_opt8.phpt test_opt9.phpt
Groups: php.pear.cvs php.pear.core 
Request: Send a blank email to pear-cvs+get-50977@lists.php.net to get a copy of this message
dufuz Sun Feb 10 23:35:54 2008 UTC Modified files: /pearweb/tests/site/get test_opt.setup.php.inc test_opt.setup2.php.inc test_opt.setup3.php.inc test_opt.setup4.php.inc test_opt.setup5.php.inc test_opt1.phpt test_opt10.phpt test_opt11.phpt test_opt2.phpt test_opt3.phpt test_opt4.phpt test_opt5.phpt test_opt6.phpt test_opt7.phpt test_opt8.phpt test_opt9.phpt Log: update a SQL query

http://cvs.php.net/viewvc.cgi/pearweb/tests/site/get/test_opt.setup.php.inc?r1=1.1&r2=1.2&diff_format=u Index: pearweb/tests/site/get/test_opt.setup.php.inc diff -u pearweb/tests/site/get/test_opt.setup.php.inc:1.1 pearweb/tests/site/get/test_opt.setup.php.inc:1.2 --- pearweb/tests/site/get/test_opt.setup.php.inc:1.1 Tue Jun 19 03:37:22 2007 +++ pearweb/tests/site/get/test_opt.setup.php.inc Sun Feb 10 23:35:54 2008 @@ -1,5 +1,5 @@ <?php -$mock->addDataQuery("SELECT id FROM packages p WHERE ((p.package_type = 'pear' AND p.approved = 1) OR p.package_type = 'pecl') AND p.name = 'Archive_Tar'", +$mock->addDataQuery("SELECT id FROM packages p WHERE ((p.package_type = 'pear' AND p.approved = 1) OR p.package_type = 'pecl') AND p.name = 'Archive_Tar'", array(array('id' => 1)), array('id')); $mock->addDataQuery("SELECT fullpath, `release`, id FROM files WHERE UPPER(basename) = 'ARCHIVE_TAR-1.3.2.TGZ'", array( http://cvs.php.net/viewvc.cgi/pearweb/tests/site/get/test_opt.setup2.php.inc?r1=1.1&r2=1.2&diff_format=u Index: pearweb/tests/site/get/test_opt.setup2.php.inc diff -u pearweb/tests/site/get/test_opt.setup2.php.inc:1.1 pearweb/tests/site/get/test_opt.setup2.php.inc:1.2 --- pearweb/tests/site/get/test_opt.setup2.php.inc:1.1 Tue Jun 19 03:37:22 2007 +++ pearweb/tests/site/get/test_opt.setup2.php.inc Sun Feb 10 23:35:54 2008 @@ -1,5 +1,5 @@ <?php -$mock->addDataQuery("SELECT id FROM packages p WHERE ((p.package_type = 'pear' AND p.approved = 1) OR p.package_type = 'pecl') AND p.name = 'Archive_Tar'", +$mock->addDataQuery("SELECT id FROM packages p WHERE ((p.package_type = 'pear' AND p.approved = 1) OR p.package_type = 'pecl') AND p.name = 'Archive_Tar'", array(array('id' => 1)), array('id')); $mock->addDataQuery("SELECT fullpath, `release`, id FROM files WHERE UPPER(basename) = 'ARCHIVE_TAR-1.3.2.TGZ'", array( http://cvs.php.net/viewvc.cgi/pearweb/tests/site/get/test_opt.setup3.php.inc?r1=1.1&r2=1.2&diff_format=u Index: pearweb/tests/site/get/test_opt.setup3.php.inc diff -u pearweb/tests/site/get/test_opt.setup3.php.inc:1.1 pearweb/tests/site/get/test_opt.setup3.php.inc:1.2 --- pearweb/tests/site/get/test_opt.setup3.php.inc:1.1 Tue Jun 19 03:37:22 2007 +++ pearweb/tests/site/get/test_opt.setup3.php.inc Sun Feb 10 23:35:54 2008 @@ -1,6 +1,6 @@ <?php $mock->addDataQuery("SELECT id FROM releases WHERE package = 1 AND state = 'stable' ORDER BY releasedate DESC", array(array('id' => 1)), array('id')); -$mock->addDataQuery("SELECT id FROM packages p WHERE ((p.package_type = 'pear' AND p.approved = 1) OR p.package_type = 'pecl') AND p.name = 'Archive_Tar'", +$mock->addDataQuery("SELECT id FROM packages p WHERE ((p.package_type = 'pear' AND p.approved = 1) OR p.package_type = 'pecl') AND p.name = 'Archive_Tar'", array(array('id' => 1)), array('id')); $mock->addDataQuery("SELECT fullpath, basename, id FROM files WHERE release = 1", array( http://cvs.php.net/viewvc.cgi/pearweb/tests/site/get/test_opt.setup4.php.inc?r1=1.1&r2=1.2&diff_format=u Index: pearweb/tests/site/get/test_opt.setup4.php.inc diff -u pearweb/tests/site/get/test_opt.setup4.php.inc:1.1 pearweb/tests/site/get/test_opt.setup4.php.inc:1.2 --- pearweb/tests/site/get/test_opt.setup4.php.inc:1.1 Tue Jun 19 03:37:22 2007 +++ pearweb/tests/site/get/test_opt.setup4.php.inc Sun Feb 10 23:35:54 2008 @@ -1,6 +1,6 @@ <?php $mock->addDataQuery("SELECT id FROM releases WHERE package = 1 AND version = '1.3.2'", array(array('id' => 1)), array('id')); -$mock->addDataQuery("SELECT id FROM packages p WHERE ((p.package_type = 'pear' AND p.approved = 1) OR p.package_type = 'pecl') AND p.name = 'Archive_Tar'", +$mock->addDataQuery("SELECT id FROM packages p WHERE ((p.package_type = 'pear' AND p.approved = 1) OR p.package_type = 'pecl') AND p.name = 'Archive_Tar'", array(array('id' => 1)), array('id')); $mock->addDataQuery("SELECT fullpath, basename, id FROM files WHERE release = 1", array( http://cvs.php.net/viewvc.cgi/pearweb/tests/site/get/test_opt.setup5.php.inc?r1=1.1&r2=1.2&diff_format=u Index: pearweb/tests/site/get/test_opt.setup5.php.inc diff -u pearweb/tests/site/get/test_opt.setup5.php.inc:1.1 pearweb/tests/site/get/test_opt.setup5.php.inc:1.2 --- pearweb/tests/site/get/test_opt.setup5.php.inc:1.1 Tue Jun 19 03:37:22 2007 +++ pearweb/tests/site/get/test_opt.setup5.php.inc Sun Feb 10 23:35:54 2008 @@ -1,6 +1,6 @@ <?php $mock->addDataQuery("SELECT id FROM releases WHERE package = 1 ORDER BY releasedate DESC", array(array('id' => 1)), array('id')); -$mock->addDataQuery("SELECT id FROM packages p WHERE ((p.package_type = 'pear' AND p.approved = 1) OR p.package_type = 'pecl') AND p.name = 'Archive_Tar'", +$mock->addDataQuery("SELECT id FROM packages p WHERE ((p.package_type = 'pear' AND p.approved = 1) OR p.package_type = 'pecl') AND p.name = 'Archive_Tar'", array(array('id' => 1)), array('id')); $mock->addDataQuery("SELECT fullpath, basename, id FROM files WHERE release = 1", array( http://cvs.php.net/viewvc.cgi/pearweb/tests/site/get/test_opt1.phpt?r1=1.1&r2=1.2&diff_format=u Index: pearweb/tests/site/get/test_opt1.phpt diff -u pearweb/tests/site/get/test_opt1.phpt:1.1 pearweb/tests/site/get/test_opt1.phpt:1.2 --- pearweb/tests/site/get/test_opt1.phpt:1.1 Tue Jun 19 03:37:22 2007 +++ pearweb/tests/site/get/test_opt1.phpt Sun Feb 10 23:35:54 2008 @@ -13,7 +13,7 @@ require dirname(__FILE__) . '/test_opt.setup.php.inc'; include dirname(dirname(dirname(dirname(__FILE__)))) . '/public_html/get'; $phpt->assertEquals(array ( - 0 => 'SELECT id FROM packages p WHERE ((p.package_type = \'pear\' AND p.approved = 1) OR p.package_type = \'pecl\') AND p.name = \'Archive_Tar\'', + 0 => 'SELECT id FROM packages p WHERE ((p.package_type = \'pear\' AND p.approved = 1) OR p.package_type = \'pecl\') AND p.name = \'Archive_Tar\'', 1 => 'SELECT fullpath, `release`, id FROM files WHERE UPPER(basename) = \'ARCHIVE_TAR-1.3.2.TGZ\'', 2 => 'UPDATE aggregated_package_stats SET downloads=downloads+1 http://cvs.php.net/viewvc.cgi/pearweb/tests/site/get/test_opt10.phpt?r1=1.1&r2=1.2&diff_format=u Index: pearweb/tests/site/get/test_opt10.phpt diff -u pearweb/tests/site/get/test_opt10.phpt:1.1 pearweb/tests/site/get/test_opt10.phpt:1.2 --- pearweb/tests/site/get/test_opt10.phpt:1.1 Tue Jun 19 03:37:22 2007 +++ pearweb/tests/site/get/test_opt10.phpt Sun Feb 10 23:35:54 2008 @@ -14,7 +14,7 @@ require dirname(__FILE__) . '/test_opt.setup.php.inc'; include dirname(dirname(dirname(dirname(__FILE__)))) . '/public_html/get'; $phpt->assertEquals(array ( - 0 => 'SELECT id FROM packages p WHERE ((p.package_type = \'pear\' AND p.approved = 1) OR p.package_type = \'pecl\') AND p.name = \'Archive_Tar\'', + 0 => 'SELECT id FROM packages p WHERE ((p.package_type = \'pear\' AND p.approved = 1) OR p.package_type = \'pecl\') AND p.name = \'Archive_Tar\'', 1 => 'SELECT fullpath, `release`, id FROM files WHERE UPPER(basename) = \'ARCHIVE_TAR-1.3.2.TGZ\'', 2 => 'UPDATE aggregated_package_stats SET downloads=downloads+1 http://cvs.php.net/viewvc.cgi/pearweb/tests/site/get/test_opt11.phpt?r1=1.1&r2=1.2&diff_format=u Index: pearweb/tests/site/get/test_opt11.phpt diff -u pearweb/tests/site/get/test_opt11.phpt:1.1 pearweb/tests/site/get/test_opt11.phpt:1.2 --- pearweb/tests/site/get/test_opt11.phpt:1.1 Tue Jun 19 03:37:22 2007 +++ pearweb/tests/site/get/test_opt11.phpt Sun Feb 10 23:35:54 2008 @@ -14,7 +14,7 @@ require dirname(__FILE__) . '/test_opt.setup.php.inc'; include dirname(dirname(dirname(dirname(__FILE__)))) . '/public_html/get'; $phpt->assertEquals(array ( - 0 => 'SELECT id FROM packages p WHERE ((p.package_type = \'pear\' AND p.approved = 1) OR p.package_type = \'pecl\') AND p.name = \'Archive_Tar\'', + 0 => 'SELECT id FROM packages p WHERE ((p.package_type = \'pear\' AND p.approved = 1) OR p.package_type = \'pecl\') AND p.name = \'Archive_Tar\'', 1 => 'SELECT fullpath, `release`, id FROM files WHERE UPPER(basename) = \'ARCHIVE_TAR-1.3.2.TGZ\'', 2 => 'UPDATE aggregated_package_stats SET downloads=downloads+1 http://cvs.php.net/viewvc.cgi/pearweb/tests/site/get/test_opt2.phpt?r1=1.1&r2=1.2&diff_format=u Index: pearweb/tests/site/get/test_opt2.phpt diff -u pearweb/tests/site/get/test_opt2.phpt:1.1 pearweb/tests/site/get/test_opt2.phpt:1.2 --- pearweb/tests/site/get/test_opt2.phpt:1.1 Tue Jun 19 03:37:22 2007 +++ pearweb/tests/site/get/test_opt2.phpt Sun Feb 10 23:35:54 2008 @@ -13,7 +13,7 @@ require dirname(__FILE__) . '/test_opt.setup2.php.inc'; include dirname(dirname(dirname(dirname(__FILE__)))) . '/public_html/get'; $phpt->assertEquals(array ( - 0 => 'SELECT id FROM packages p WHERE ((p.package_type = \'pear\' AND p.approved = 1) OR p.package_type = \'pecl\') AND p.name = \'Archive_Tar\'', + 0 => 'SELECT id FROM packages p WHERE ((p.package_type = \'pear\' AND p.approved = 1) OR p.package_type = \'pecl\') AND p.name = \'Archive_Tar\'', 1 => 'SELECT fullpath, `release`, id FROM files WHERE UPPER(basename) = \'ARCHIVE_TAR-1.3.2.TGZ\'', 2 => 'UPDATE aggregated_package_stats SET downloads=downloads+1 http://cvs.php.net/viewvc.cgi/pearweb/tests/site/get/test_opt3.phpt?r1=1.1&r2=1.2&diff_format=u Index: pearweb/tests/site/get/test_opt3.phpt diff -u pearweb/tests/site/get/test_opt3.phpt:1.1 pearweb/tests/site/get/test_opt3.phpt:1.2 --- pearweb/tests/site/get/test_opt3.phpt:1.1 Tue Jun 19 03:37:22 2007 +++ pearweb/tests/site/get/test_opt3.phpt Sun Feb 10 23:35:54 2008 @@ -13,7 +13,7 @@ require dirname(__FILE__) . '/test_opt.setup3.php.inc'; include dirname(dirname(dirname(dirname(__FILE__)))) . '/public_html/get'; $phpt->assertEquals(array ( - 0 => 'SELECT id FROM packages p WHERE ((p.package_type = \'pear\' AND p.approved = 1) OR p.package_type = \'pecl\') AND p.name = \'Archive_Tar\'', + 0 => 'SELECT id FROM packages p WHERE ((p.package_type = \'pear\' AND p.approved = 1) OR p.package_type = \'pecl\') AND p.name = \'Archive_Tar\'', 1 => 'SELECT id FROM releases WHERE package = 1 AND state = \'stable\' ORDER BY releasedate DESC', 2 => 'SELECT fullpath, basename, id FROM files WHERE release = 1', 3 => 'UPDATE aggregated_package_stats http://cvs.php.net/viewvc.cgi/pearweb/tests/site/get/test_opt4.phpt?r1=1.1&r2=1.2&diff_format=u Index: pearweb/tests/site/get/test_opt4.phpt diff -u pearweb/tests/site/get/test_opt4.phpt:1.1 pearweb/tests/site/get/test_opt4.phpt:1.2 --- pearweb/tests/site/get/test_opt4.phpt:1.1 Tue Jun 19 03:37:22 2007 +++ pearweb/tests/site/get/test_opt4.phpt Sun Feb 10 23:35:54 2008 @@ -13,7 +13,7 @@ require dirname(__FILE__) . '/test_opt.setup4.php.inc'; include dirname(dirname(dirname(dirname(__FILE__)))) . '/public_html/get'; $phpt->assertEquals(array ( - 0 => 'SELECT id FROM packages p WHERE ((p.package_type = \'pear\' AND p.approved = 1) OR p.package_type = \'pecl\') AND p.name = \'Archive_Tar\'', + 0 => 'SELECT id FROM packages p WHERE ((p.package_type = \'pear\' AND p.approved = 1) OR p.package_type = \'pecl\') AND p.name = \'Archive_Tar\'', 1 => 'SELECT id FROM releases WHERE package = 1 AND version = \'1.3.2\'', 2 => 'SELECT fullpath, basename, id FROM files WHERE release = 1', 3 => 'UPDATE aggregated_package_stats http://cvs.php.net/viewvc.cgi/pearweb/tests/site/get/test_opt5.phpt?r1=1.1&r2=1.2&diff_format=u Index: pearweb/tests/site/get/test_opt5.phpt diff -u pearweb/tests/site/get/test_opt5.phpt:1.1 pearweb/tests/site/get/test_opt5.phpt:1.2 --- pearweb/tests/site/get/test_opt5.phpt:1.1 Tue Jun 19 03:37:22 2007 +++ pearweb/tests/site/get/test_opt5.phpt Sun Feb 10 23:35:54 2008 @@ -13,7 +13,7 @@ require dirname(__FILE__) . '/test_opt.setup5.php.inc'; include dirname(dirname(dirname(dirname(__FILE__)))) . '/public_html/get'; $phpt->assertEquals(array ( - 0 => 'SELECT id FROM packages p WHERE ((p.package_type = \'pear\' AND p.approved = 1) OR p.package_type = \'pecl\') AND p.name = \'Archive_Tar\'', + 0 => 'SELECT id FROM packages p WHERE ((p.package_type = \'pear\' AND p.approved = 1) OR p.package_type = \'pecl\') AND p.name = \'Archive_Tar\'', 1 => 'SELECT id FROM releases WHERE package = 1 ORDER BY releasedate DESC', 2 => 'SELECT fullpath, basename, id FROM files WHERE release = 1', 3 => 'UPDATE aggregated_package_stats http://cvs.php.net/viewvc.cgi/pearweb/tests/site/get/test_opt6.phpt?r1=1.1&r2=1.2&diff_format=u Index: pearweb/tests/site/get/test_opt6.phpt diff -u pearweb/tests/site/get/test_opt6.phpt:1.1 pearweb/tests/site/get/test_opt6.phpt:1.2 --- pearweb/tests/site/get/test_opt6.phpt:1.1 Tue Jun 19 03:37:22 2007 +++ pearweb/tests/site/get/test_opt6.phpt Sun Feb 10 23:35:54 2008 @@ -13,7 +13,7 @@ require dirname(__FILE__) . '/test_opt.setup4.php.inc'; include dirname(dirname(dirname(dirname(__FILE__)))) . '/public_html/get'; $phpt->assertEquals(array ( - 0 => 'SELECT id FROM packages p WHERE ((p.package_type = \'pear\' AND p.approved = 1) OR p.package_type = \'pecl\') AND p.name = \'Archive_Tar\'', + 0 => 'SELECT id FROM packages p WHERE ((p.package_type = \'pear\' AND p.approved = 1) OR p.package_type = \'pecl\') AND p.name = \'Archive_Tar\'', 1 => 'SELECT id FROM releases WHERE package = 1 AND version = \'1.3.2\'', 2 => 'SELECT fullpath, basename, id FROM files WHERE release = 1', 3 => 'UPDATE aggregated_package_stats http://cvs.php.net/viewvc.cgi/pearweb/tests/site/get/test_opt7.phpt?r1=1.1&r2=1.2&diff_format=u Index: pearweb/tests/site/get/test_opt7.phpt diff -u pearweb/tests/site/get/test_opt7.phpt:1.1 pearweb/tests/site/get/test_opt7.phpt:1.2 --- pearweb/tests/site/get/test_opt7.phpt:1.1 Tue Jun 19 03:37:22 2007 +++ pearweb/tests/site/get/test_opt7.phpt Sun Feb 10 23:35:54 2008 @@ -13,7 +13,7 @@ require dirname(__FILE__) . '/test_opt.setup.php.inc'; include dirname(dirname(dirname(dirname(__FILE__)))) . '/public_html/get'; $phpt->assertEquals(array ( - 0 => 'SELECT id FROM packages p WHERE ((p.package_type = \'pear\' AND p.approved = 1) OR p.package_type = \'pecl\') AND p.name = \'Archive_Tar\'', + 0 => 'SELECT id FROM packages p WHERE ((p.package_type = \'pear\' AND p.approved = 1) OR p.package_type = \'pecl\') AND p.name = \'Archive_Tar\'', 1 => 'SELECT fullpath, `release`, id FROM files WHERE UPPER(basename) = \'ARCHIVE_TAR-1.3.2.TGZ\'', 2 => 'UPDATE aggregated_package_stats SET downloads=downloads+1 http://cvs.php.net/viewvc.cgi/pearweb/tests/site/get/test_opt8.phpt?r1=1.1&r2=1.2&diff_format=u Index: pearweb/tests/site/get/test_opt8.phpt diff -u pearweb/tests/site/get/test_opt8.phpt:1.1 pearweb/tests/site/get/test_opt8.phpt:1.2 --- pearweb/tests/site/get/test_opt8.phpt:1.1 Tue Jun 19 03:37:22 2007 +++ pearweb/tests/site/get/test_opt8.phpt Sun Feb 10 23:35:54 2008 @@ -14,7 +14,7 @@ require dirname(__FILE__) . '/test_opt.setup.php.inc'; include dirname(dirname(dirname(dirname(__FILE__)))) . '/public_html/get'; $phpt->assertEquals(array ( - 0 => 'SELECT id FROM packages p WHERE ((p.package_type = \'pear\' AND p.approved = 1) OR p.package_type = \'pecl\') AND p.name = \'Archive_Tar\'', + 0 => 'SELECT id FROM packages p WHERE ((p.package_type = \'pear\' AND p.approved = 1) OR p.package_type = \'pecl\') AND p.name = \'Archive_Tar\'', 1 => 'SELECT fullpath, `release`, id FROM files WHERE UPPER(basename) = \'ARCHIVE_TAR-1.3.2.TGZ\'', 2 => 'UPDATE aggregated_package_stats SET downloads=downloads+1 http://cvs.php.net/viewvc.cgi/pearweb/tests/site/get/test_opt9.phpt?r1=1.1&r2=1.2&diff_format=u Index: pearweb/tests/site/get/test_opt9.phpt diff -u pearweb/tests/site/get/test_opt9.phpt:1.1 pearweb/tests/site/get/test_opt9.phpt:1.2 --- pearweb/tests/site/get/test_opt9.phpt:1.1 Tue Jun 19 03:37:22 2007 +++ pearweb/tests/site/get/test_opt9.phpt Sun Feb 10 23:35:54 2008 @@ -14,7 +14,7 @@ require dirname(__FILE__) . '/test_opt.setup.php.inc'; include dirname(dirname(dirname(dirname(__FILE__)))) . '/public_html/get'; $phpt->assertEquals(array ( - 0 => 'SELECT id FROM packages p WHERE ((p.package_type = \'pear\' AND p.approved = 1) OR p.package_type = \'pecl\') AND p.name = \'Archive_Tar\'', + 0 => 'SELECT id FROM packages p WHERE ((p.package_type = \'pear\' AND p.approved = 1) OR p.package_type = \'pecl\') AND p.name = \'Archive_Tar\'', 1 => 'SELECT fullpath, `release`, id FROM files WHERE UPPER(basename) = \'ARCHIVE_TAR-1.3.2.TGZ\'', 2 => 'UPDATE aggregated_package_stats SET downloads=downloads+1
« previous php.pear.cvs (#50977) next »