diff options
author | Dries Buytaert <dries@buytaert.net> | 2008-11-08 22:52:24 +0000 |
---|---|---|
committer | Dries Buytaert <dries@buytaert.net> | 2008-11-08 22:52:24 +0000 |
commit | a7f6efc8a14efb0a553aae313cb63ea404618add (patch) | |
tree | 2b58334bfbd5a08315217e3f01512a56695b78c9 /modules/simpletest/tests/database_test.test | |
parent | 50b3072f5577849a37cfe8e38f49d839fd15eaf0 (diff) | |
download | brdo-a7f6efc8a14efb0a553aae313cb63ea404618add.tar.gz brdo-a7f6efc8a14efb0a553aae313cb63ea404618add.tar.bz2 |
- Patch #329080 by chx, Damien Tournoud, pwolanin: statics in objects are not per-instance.
Diffstat (limited to 'modules/simpletest/tests/database_test.test')
-rw-r--r-- | modules/simpletest/tests/database_test.test | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/modules/simpletest/tests/database_test.test b/modules/simpletest/tests/database_test.test index 5656dc740..118e19448 100644 --- a/modules/simpletest/tests/database_test.test +++ b/modules/simpletest/tests/database_test.test @@ -1044,6 +1044,28 @@ class DatabaseSelectTestCase extends DatabaseTestCase { } /** + * Test SELECT statements with multiple expressions. + */ + function testSimpleSelectExpressionMultiple() { + $query = db_select('test'); + $name_field = $query->addField('test', 'name'); + $age_double_field = $query->addExpression("age*2"); + $age_triple_field = $query->addExpression("age*3"); + $query->condition('age', 27); + $result = $query->execute(); + + // Check that the aliases are being created the way we want. + $this->assertEqual($age_double_field, 'expression', t('Double age field alias is correct.')); + $this->assertEqual($age_triple_field, 'expression_2', t('Triple age field alias is correct.')); + + // Ensure that we got the right record. + $record = $result->fetch(); + $this->assertEqual($record->$name_field, 'George', t('Fetched name is correct.')); + $this->assertEqual($record->$age_double_field, 27*2, t('Fetched double age expression is correct.')); + $this->assertEqual($record->$age_triple_field, 27*3, t('Fetched triple age expression is correct.')); + } + + /** * Test adding multiple fields to a select statement at the same time. */ function testSimpleSelectMultipleFields() { |