diff options
| author | Andreas Fischer <bantu@phpbb.com> | 2012-05-09 12:50:13 +0200 |
|---|---|---|
| committer | Andreas Fischer <bantu@phpbb.com> | 2012-05-09 12:50:13 +0200 |
| commit | 12dbcc7f1e13f71b96a5aa31ece4632fb1eb4139 (patch) | |
| tree | dad98e4d4eeb68c795a3776614173f26daa5ef62 /tests | |
| parent | c0718fae96a991182f3941dee02599077b5b447d (diff) | |
| parent | 09d49fb7b2be51a29f5a03c0a1a3816d7e55a466 (diff) | |
| download | forums-12dbcc7f1e13f71b96a5aa31ece4632fb1eb4139.tar forums-12dbcc7f1e13f71b96a5aa31ece4632fb1eb4139.tar.gz forums-12dbcc7f1e13f71b96a5aa31ece4632fb1eb4139.tar.bz2 forums-12dbcc7f1e13f71b96a5aa31ece4632fb1eb4139.tar.xz forums-12dbcc7f1e13f71b96a5aa31ece4632fb1eb4139.zip | |
Merge remote-tracking branch 'Noxwizard/ticket/10858' into develop-olympus
* Noxwizard/ticket/10858:
[ticket/10858] Move generic row seeking to DBAL
[ticket/10858] Tests for row seeking with fetchfield()
[ticket/10858] Fix MSSQL Native's row seeking behavior
Diffstat (limited to 'tests')
| -rw-r--r-- | tests/dbal/select_test.php | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/tests/dbal/select_test.php b/tests/dbal/select_test.php index 21b12777dc..1b04450fcd 100644 --- a/tests/dbal/select_test.php +++ b/tests/dbal/select_test.php @@ -125,6 +125,32 @@ class phpbb_dbal_select_test extends phpbb_database_test_case $this->assertEquals($expected, $ary); } + public static function fetchfield_seek_data() + { + return array( + array(1, 'foobar'), + array(0, 'barfoo'), + array(2, 'bertie'), + ); + } + + /** + * @dataProvider fetchfield_seek_data + */ + public function test_fetchfield_seek($rownum, $expected) + { + $db = $this->new_dbal(); + + $result = $db->sql_query('SELECT username_clean + FROM phpbb_users + ORDER BY user_id ASC'); + + $field = $db->sql_fetchfield('username_clean', $rownum, $result); + $db->sql_freeresult($result); + + $this->assertEquals($expected, $field); + } + public static function query_limit_data() { return array( |