Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
LibTest.php	3.37 KB	-rw-r--r--	2023-01-22 09:53
benchmark.php	2.41 KB	-rw-r--r--	2023-01-22 09:53
pdo.php	2.4 KB	-rw-r--r--	2023-01-22 09:53
test-active-record.php	5.23 KB	-rw-r--r--	2023-01-22 09:53
test-active-recs2.php	2.12 KB	-rw-r--r--	2023-01-22 09:53
test-active-relations.php	3.67 KB	-rw-r--r--	2023-01-22 09:53
test-active-relationsx.php	25.16 KB	-rw-r--r--	2023-01-22 09:53
test-datadict.php	7.84 KB	-rw-r--r--	2023-01-22 09:53
test-perf.php	1.58 KB	-rw-r--r--	2023-01-22 09:53
test-pgblob.php	2.69 KB	-rw-r--r--	2023-01-22 09:53
test-php5.php	2.91 KB	-rw-r--r--	2023-01-22 09:53
test-xmlschema.php	1.96 KB	-rw-r--r--	2023-01-22 09:53
test.php	54.87 KB	-rw-r--r--	2023-01-22 09:53
test2.php	1.26 KB	-rw-r--r--	2023-01-22 09:53
test3.php	1.3 KB	-rw-r--r--	2023-01-22 09:53
test4.php	4.84 KB	-rw-r--r--	2023-01-22 09:53
test5.php	1.7 KB	-rw-r--r--	2023-01-22 09:53
test_mssqlnative.php	5.33 KB	-rw-r--r--	2023-01-22 09:53
test_rs_array.php	1.37 KB	-rw-r--r--	2023-01-22 09:53
testcache.php	1.14 KB	-rw-r--r--	2023-01-22 09:53
testdatabases.inc.php	17.55 KB	-rw-r--r--	2023-01-22 09:53
testgenid.php	1.41 KB	-rw-r--r--	2023-01-22 09:53
testmssql.php	2.3 KB	-rw-r--r--	2023-01-22 09:53
testoci8.php	2.67 KB	-rw-r--r--	2023-01-22 09:53
testoci8cursor.php	3.21 KB	-rw-r--r--	2023-01-22 09:53
testpaging.php	2.62 KB	-rw-r--r--	2023-01-22 09:53
testpear.php	1.21 KB	-rw-r--r--	2023-01-22 09:53
testsessions.php	2.83 KB	-rw-r--r--	2023-01-22 09:53
time.php	1.21 KB	-rw-r--r--	2023-01-22 09:53
tmssql.php	2.54 KB	-rw-r--r--	2023-01-22 09:53
xmlschema-mssql.xml	832 B	-rw-r--r--	2023-01-22 09:53
xmlschema.xml	961 B	-rw-r--r--	2023-01-22 09:53

Rename

<?php
/**
 * Tests cases for adodb-lib.inc.php
 *
 * This file is part of ADOdb, a Database Abstraction Layer library for PHP.
 *
 * @package ADOdb
 * @link https://adodb.org Project's web site and documentation
 * @link https://github.com/ADOdb/ADOdb Source code and issue tracker
 *
 * The ADOdb Library is dual-licensed, released under both the BSD 3-Clause
 * and the GNU Lesser General Public Licence (LGPL) v2.1 or, at your option,
 * any later version. This means you can use it in proprietary products.
 * See the LICENSE.md file distributed with this source code for details.
 * @license BSD-3-Clause
 * @license LGPL-2.1-or-later
 *
 * @copyright 2000-2013 John Lim
 * @copyright 2014 Damien Regad, Mark Newnham and the ADOdb community
 */

use PHPUnit\Framework\TestCase;

require_once dirname(__FILE__) . '/../adodb.inc.php';
require_once dirname(__FILE__) . '/../adodb-lib.inc.php';

/**
 * Class LibTest.
 *
 * Test cases for adodb-lib.inc.php
 */
class LibTest extends TestCase
{
	/** @var ADOConnection Database connection for tests */
	private $db;

public function setUp(): void
	{
		$this->db = ADONewConnection('mysqli');
	}

/**
	 * Test for {@see adodb_strip_order_by()}
	 *
	 * @dataProvider providerStripOrderBy
	 */
	public function testStripOrderBy($sql, $stripped): void
	{
		$this->assertSame($stripped, adodb_strip_order_by($sql));
	}

/**
	 * Data provider for {@see testStripOrderBy()}
	 *
	 * @return array [SQL statement, SQL with ORDER BY clause stripped]
	 */
	public function providerStripOrderBy(): array
	{
		return [
			'No order by clause' => [
				"SELECT name FROM table",
				"SELECT name FROM table"
			],
			'Simple order by clause' => [
				"SELECT name FROM table ORDER BY name",
				"SELECT name FROM table"
			],
			'Order by clause descending' => [
				"SELECT name FROM table ORDER BY name DESC",
				"SELECT name FROM table"
			],
			'Order by clause with limit' => [
				"SELECT name FROM table ORDER BY name LIMIT 5",
				"SELECT name FROM table LIMIT 5"
			],
			'Ordered Subquery with outer order by' => [
				"SELECT * FROM table WHERE name IN (SELECT TOP 5 name FROM table_b ORDER by name) ORDER BY name DESC",
				"SELECT * FROM table WHERE name IN (SELECT TOP 5 name FROM table_b ORDER by name)"
			],
			'Ordered Subquery without outer order by' => [
				"SELECT * FROM table WHERE name IN (SELECT TOP 5 name FROM table_b ORDER by name)",
				"SELECT * FROM table WHERE name IN (SELECT TOP 5 name FROM table_b ORDER by name)"
			],
		];
	}

/**
	 * Test for {@see _adodb_quote_fieldname()}
	 *
	 * @dataProvider quoteProvider
	 */
	public function testQuoteFieldNames($method, $field, $expected)
	{
		global $ADODB_QUOTE_FIELDNAMES;
		$ADODB_QUOTE_FIELDNAMES = $method;
		$this->assertSame($expected, _adodb_quote_fieldname($this->db, $field));
	}

/**
	 * Data provider for {@see testQuoteFieldNames()}
	 * @return array
	 */
	public function quoteProvider()
	{
		return [
			'No quoting, single-word field name' => [false, 'Field', 'FIELD'],
			'No quoting, field name with space' => [false, 'Field Name', '`FIELD NAME`'],
			'Quoting `true`' => [true, 'Field', '`FIELD`'],
			'Quoting `UPPER`' => ['UPPER', 'Field', '`FIELD`'],
			'Quoting `LOWER`' => ['LOWER', 'Field', '`field`'],
			'Quoting `NATIVE`' => ['NATIVE', 'Field', '`Field`'],
			'Quoting `BRACKETS`' => ['BRACKETS', 'Field', '[FIELD]'],
			'Unknown value defaults to UPPER' => ['XXX', 'Field', '`FIELD`'],
		];
	}

}