From 9079d78481c6148b9aca36f90e8bf34ffb01f03d Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Fri, 5 Jun 2009 16:55:45 +0000 Subject: - Patch #481288 by Berdir: add support for INSERT INTO ... SELECT FROM ... queries. --- modules/simpletest/tests/database_test.test | 15 +++++++++++++++ 1 file changed, 15 insertions(+) (limited to 'modules/simpletest/tests/database_test.test') diff --git a/modules/simpletest/tests/database_test.test b/modules/simpletest/tests/database_test.test index 7084ccf7e..6256ff22c 100644 --- a/modules/simpletest/tests/database_test.test +++ b/modules/simpletest/tests/database_test.test @@ -513,6 +513,21 @@ class DatabaseInsertTestCase extends DatabaseTestCase { $this->assertIdentical($id, '5', t('Auto-increment ID returned successfully.')); } + + /** + * Test that the INSERT INTO ... SELECT ... syntax works. + */ + function testInsertSelect() { + $query = db_select('test_people', 'tp')->fields('tp', array('name', 'age', 'job')); + + db_insert('test') + ->fields(array('name', 'age', 'job')) + ->from($query) + ->execute(); + + $saved_age = db_query('SELECT age FROM {test} WHERE name = :name', array(':name' => 'Meredith'))->fetchField(); + $this->assertIdentical($saved_age, '30', t('Can retrieve after inserting.')); + } } /** -- cgit v1.2.3