diff options
| author | Nils Adermann <naderman@naderman.de> | 2011-06-02 06:09:21 +0200 |
|---|---|---|
| committer | Nils Adermann <naderman@naderman.de> | 2011-06-02 06:09:21 +0200 |
| commit | f0287f7e57919619e7b8085a7e7071975e18da93 (patch) | |
| tree | d5d27f8f1279fe74f1e38bd4ee9dc3b6b2ce69ee /tests/dbal/select_test.php | |
| parent | ebe83769e6efff249f94e5337dcd8fd16593a290 (diff) | |
| download | forums-f0287f7e57919619e7b8085a7e7071975e18da93.tar forums-f0287f7e57919619e7b8085a7e7071975e18da93.tar.gz forums-f0287f7e57919619e7b8085a7e7071975e18da93.tar.bz2 forums-f0287f7e57919619e7b8085a7e7071975e18da93.tar.xz forums-f0287f7e57919619e7b8085a7e7071975e18da93.zip | |
[ticket/9685] Test for databases that are able to nest transactions
If a database is unable to nest transactions the dbal should implement
sql_buffer_nested_transactions to signal that buffering of the outer
results and closing of the outer transaction is required to open the
inner transaction.
PHPBB3-9685
Diffstat (limited to 'tests/dbal/select_test.php')
| -rw-r--r-- | tests/dbal/select_test.php | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/tests/dbal/select_test.php b/tests/dbal/select_test.php index 533416f14b..e0d08d9306 100644 --- a/tests/dbal/select_test.php +++ b/tests/dbal/select_test.php @@ -8,6 +8,7 @@ */ require_once dirname(__FILE__) . '/../../phpBB/includes/functions.php'; +require_once dirname(__FILE__) . '/../../phpBB/includes/utf/utf_tools.php'; class phpbb_dbal_select_test extends phpbb_database_test_case { @@ -317,4 +318,27 @@ class phpbb_dbal_select_test extends phpbb_database_test_case $db->sql_freeresult($result); } + + function test_nested_transactions() + { + $db = $this->new_dbal(); + + // nested transactions should work on systems that do not require + // buffering of nested transactions, so ignore the ones that need + // buffering + if ($db->sql_buffer_nested_transactions()) + { + return; + } + + $sql = 'SELECT user_id FROM phpbb_users ORDER BY user_id ASC'; + $result1 = $db->sql_query($sql); + + $db->sql_transaction('begin'); + $result2 = $db->sql_query($sql); + $row = $db->sql_fetchrow($result2); + $db->sql_transaction('commit'); + + $this->assertEquals('1', $row['user_id']); + } } |