Search moodle.org's
Developer Documentation

See Release Notes
Long Term Support Release

  • Bug fixes for general core bugs in 4.1.x will end 13 November 2023 (12 months).
  • Bug fixes for security issues in 4.1.x will end 10 November 2025 (36 months).
  • PHP version: minimum PHP 7.4.0 Note: minimum PHP version has increased since Moodle 4.0. PHP 8.0.x is supported too.
/lib/dml/tests/ -> pgsql_native_recordset_test.php (source)

[Source view]

Differences Between: [Versions 310 and 401] [Versions 311 and 401] [Versions 39 and 401]

Test specific features of the Postgres dml support relating to recordsets.

Copyright: 2017 The Open University
License: http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
File Size: 433 lines (15 kb)
Included or required:0 times
Referenced: 0 times
Includes or requires: 0 files

Defines 1 class

pgsql_native_recordset_test:: (13 methods):
  setUp()
  init_db()
  tearDown()
  test_recordset_cursors()
  test_recordset_cursors_overlapping()
  test_recordset_cursors_transaction_inside()
  test_recordset_cursors_transaction_outside()
  test_recordset_cursors_transaction_overlapping_before()
  test_recordset_cursors_transaction_overlapping_after()
  test_recordset_cursors_transaction_rollback()
  test_recordset_no_cursors_limit()
  test_recordset_no_cursors_config()
  assert_query_regexps()


Class: pgsql_native_recordset_test  - X-Ref

Test specific features of the Postgres dml support relating to recordsets.

setUp()   X-Ref
Creates a second db connection and a temp table with values in for testing.


init_db($fetchbuffersize)   X-Ref
Initialises database connection with given fetch buffer size

param: int $fetchbuffersize Size of fetch buffer

tearDown()   X-Ref
Gets rid of the second db connection.


test_recordset_cursors()   X-Ref
Tests that get_recordset_sql works when using cursors, which it does when no limit is
specified.


test_recordset_cursors_overlapping()   X-Ref
Tests that get_recordset_sql works when using cursors and when there are two overlapping
recordsets being used.


test_recordset_cursors_transaction_inside()   X-Ref
Tests that get_recordset_sql works when using cursors and transactions inside.


test_recordset_cursors_transaction_outside()   X-Ref
Tests that get_recordset_sql works when using cursors and a transaction outside.


test_recordset_cursors_transaction_overlapping_before()   X-Ref
Tests that get_recordset_sql works when using cursors and a transaction overlapping.


test_recordset_cursors_transaction_overlapping_after()   X-Ref
Tests that get_recordset_sql works when using cursors and a transaction overlapping.


test_recordset_cursors_transaction_rollback()   X-Ref
Tests that get_recordset_sql works when using cursors and a transaction that 'fails' and gets
rolled back.


test_recordset_no_cursors_limit()   X-Ref
Tests that get_recordset_sql works when not using cursors, because a limit is specified.


test_recordset_no_cursors_config()   X-Ref
Tests that get_recordset_sql works when not using cursors, because the config setting turns
them off.


assert_query_regexps(array $expected, $debugging)   X-Ref
Asserts that database debugging output matches the expected list of SQL queries, specified
as an array of regular expressions.

param: string[] $expected Expected regular expressions
param: string $debugging Debugging text from the database