QueryFormattingTestCase.php
0a62f13464b8stable

QueryFormattingTestCase.php
View Options

			<?php

			final class QueryFormattingTestCase extends PhabricatorTestCase {

			public function testQueryFormatting() {
			$conn_r = id(new PhabricatorUser())->establishConnection('r');

			$this->assertEqual(
			'NULL',
			qsprintf($conn_r, '%nd', null));

			$this->assertEqual(
			'0',
			qsprintf($conn_r, '%nd', 0));

			$this->assertEqual(
			'0',
			qsprintf($conn_r, '%d', 0));

			$raised = null;
			try {
			qsprintf($conn_r, '%d', 'derp');
			} catch (Exception $ex) {
			$raised = $ex;
			}
			$this->assertTrue(
			(bool)$raised,
			'qsprintf should raise exception for invalid %d conversion.');

			$this->assertEqual(
			"'<S>'",
			qsprintf($conn_r, '%s', null));

			$this->assertEqual(
			'NULL',
			qsprintf($conn_r, '%ns', null));

			$this->assertEqual(
			"'<S>', '<S>'",
			qsprintf($conn_r, '%Ls', array('x', 'y')));

			$this->assertEqual(
			"'<B>'",
			qsprintf($conn_r, '%B', null));

			$this->assertEqual(
			'NULL',
			qsprintf($conn_r, '%nB', null));

			$this->assertEqual(
			"'<B>', '<B>'",
			qsprintf($conn_r, '%LB', array('x', 'y')));
			}


			}