PageRenderTime 42ms CodeModel.GetById 14ms RepoModel.GetById 0ms app.codeStats 0ms

/hphp/test/zend/bad/ext/pdo_mysql/tests/pdo_mysql_types.php

http://github.com/facebook/hiphop-php
PHP | 172 lines | 126 code | 38 blank | 8 comment | 21 complexity | 3bc934f342d113985d3d5df470944d7c MD5 | raw file
Possible License(s): LGPL-2.1, BSD-2-Clause, BSD-3-Clause, MPL-2.0-no-copyleft-exception, MIT, LGPL-2.0, Apache-2.0 
    

  1. <?php
    2. 

  2. 	require_once(dirname(__FILE__) . DIRECTORY_SEPARATOR . 'mysql_pdo_test.inc');
    3. 

  3. 

  4. 	function test_type(&$db, $offset, $sql_type, $value, $ret_value = NULL, $pattern = NULL, $alternative_type = NULL) {
    5. 

  5. 

  6. 		$db->exec('DROP TABLE IF EXISTS test');
    7. 

  7. 		$sql = sprintf('CREATE TABLE test(id INT, label %s) ENGINE=%s', $sql_type, MySQLPDOTest::getTableEngine());
    8. 

  8. 		@$db->exec($sql);
    9. 

  9. 		if ($db->errorCode() != 0) {
    10. 

  10. 			// not all MySQL Server versions and/or engines might support the type
    11. 

  11. 			return true;
    12. 

  12. 		}
    13. 

  13. 

  14. 		$stmt = $db->prepare('INSERT INTO test(id, label) VALUES (?, ?)');
    15. 

  15. 		$stmt->bindValue(1, $offset);
    16. 

  16. 		$stmt->bindValue(2, $value);
    17. 

  17. 		if (!$stmt->execute()) {
    18. 

  18. 			printf("[%03d + 1] INSERT failed, %s\n", $offset, var_export($stmt->errorInfo(), true));
    19. 

  19. 			return false;
    20. 

  20. 		}
    21. 

  21. 		$db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false);
    22. 

  22. 		$stmt = $db->query('SELECT  id, label FROM test');
    23. 

  23. 		$row = $stmt->fetch(PDO::FETCH_ASSOC);
    24. 

  24. 		$stmt->closeCursor();
    25. 

  25. 

  26. 		if (!isset($row['id']) || !isset($row['label'])) {
    27. 

  27. 			printf("[%03d + 2] Fetched result seems wrong, dumping result: %s\n", $offset, var_export($row, true));
    28. 

  28. 			return false;
    29. 

  29. 		}
    30. 

  30. 

  31. 		if ($row['id'] != $offset) {
    32. 

  32. 			printf("[%03d + 3] Expecting %s got %s\n", $offset, $row['id']);
    33. 

  33. 			return false;
    34. 

  34. 		}
    35. 

  35. 

  36. 		if (!is_null($pattern)) {
    37. 

  37. 			if (!preg_match($pattern, $row['label'])) {
    38. 

  38. 				printf("[%03d + 5] Value seems wrong, accepting pattern %s got %s, check manually\n",
    39. 

  39. 					$offset, $pattern, var_export($row['label'], true));
    40. 

  40. 				return false;
    41. 

  41. 			}
    42. 

  42. 

  43. 		} else {
    44. 

  44. 

  45. 			$exp = $value;
    46. 

  46. 			if (!is_null($ret_value)) {
    47. 

  47. 				// we expect a different return value than our input value
    48. 

  48. 				// typically the difference is only the type
    49. 

  49. 				$exp = $ret_value;
    50. 

  50. 			}
    51. 

  51. 			if ($row['label'] !== $exp && !is_null($alternative_type) && gettype($row['label']) != $alternative_type) {
    52. 

  52. 				printf("[%03d + 4] %s - input = %s/%s, output = %s/%s (alternative type: %s)\n", $offset,
    53. 

  53. 					$sql_type, var_export($exp, true), gettype($exp),
    54. 

  54. 					var_export($row['label'], true), gettype($row['label']),
    55. 

  55. 					$alternative_type);
    56. 

  56. 				return false;
    57. 

  57. 			}
    58. 

  58. 

  59. 		}
    60. 

  60. 

  61. 		$db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
    62. 

  62. 		$stmt = $db->query('SELECT id, label FROM test');
    63. 

  63. 		$row_string = $stmt->fetch(PDO::FETCH_ASSOC);
    64. 

  64. 		$stmt->closeCursor();
    65. 

  65. 		if (is_null($pattern) && ($row['label'] != $row_string['label'])) {
    66. 

  66. 			printf("%s - STRINGIGY = %s, NATIVE = %s\n", $sql_type, var_export($row_string['label'], true), var_export($row['label'], true));
    67. 

  67. 			return false;
    68. 

  68. 		} else if (!is_null($pattern) && !preg_match($pattern, $row_string['label'])) {
    69. 

  69. 			printf("%s - STRINGIGY = %s, NATIVE = %s, pattern '%s'\n", $sql_type, var_export($row_string['label'], true), var_export($row['label'], true), $pattern);
    70. 

  70. 			return false;
    71. 

  71. 		}
    72. 

  72. 

  73. 

  74. 		return true;
    75. 

  75. 	}
    76. 

  76. 

  77. 	$db = MySQLPDOTest::factory();
    78. 

  78. 	$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    79. 

  79. 	$db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
    80. 

  80. 	$db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false);
    81. 

  81. 

  82. /*
    83. 

  83. 	test_type($db, 20, 'BIT(8)', 1);
    84. 

  84. */
    85. 

  85. 	$is_mysqlnd = MySQLPDOTest::isPDOMySQLnd();
    86. 

  86. 

  87. 	test_type($db, 30, 'TINYINT', -127, ($is_mysqlnd) ? -127: '-127');
    88. 

  88. 	test_type($db, 40, 'TINYINT UNSIGNED', 255, ($is_mysqlnd) ? 255 : '255');
    89. 

  89. 	test_type($db, 50, 'BOOLEAN', 1, ($is_mysqlnd) ? 1 : '1');
    90. 

  90. 

  91. 	test_type($db, 60, 'SMALLINT', -32768, ($is_mysqlnd) ? -32768 : '-32768');
    92. 

  92. 	test_type($db, 70, 'SMALLINT UNSIGNED', 65535, ($is_mysqlnd) ? 65535 : '65535');
    93. 

  93. 

  94. 	test_type($db, 80, 'MEDIUMINT', -8388608, ($is_mysqlnd) ? -8388608 : '-8388608');
    95. 

  95. 	test_type($db, 90, 'MEDIUMINT UNSIGNED', 16777215, ($is_mysqlnd) ? 16777215 : '16777215');
    96. 

  96. 

  97. 	test_type($db, 100, 'INT', -2147483648,
    98. 

  98. 		($is_mysqlnd) ? ((PHP_INT_SIZE > 4) ? (int)-2147483648 : (double)-2147483648) : '-2147483648',
    99. 

  99. 		NULL, ($is_mysqlnd) ? 'integer' : NULL);
    100. 

  100. 

  101. 	test_type($db, 110, 'INT UNSIGNED', 4294967295, ($is_mysqlnd) ? ((PHP_INT_SIZE > 4) ? 4294967295 : '4294967295') : '4294967295');
    102. 

  102. 

  103. 	// no chance to return int with the current PDO version - we are forced to return strings
    104. 

  104. 	test_type($db, 120, 'BIGINT', 1, ($is_mysqlnd) ? 1 : '1');
    105. 

  105. 	// to avoid trouble with  numeric ranges, lets pass the numbers as a string
    106. 

  106. 	test_type($db, 130, 'BIGINT', '-9223372036854775808', NULL, '/^\-9[\.]*22/');
    107. 

  107. 	test_type($db, 140, 'BIGINT UNSIGNED', '18446744073709551615', NULL, '/^1[\.]*844/');
    108. 

  108. 

  109. 	test_type($db, 150, 'REAL', -1.01, ($is_mysqlnd) ? -1.01 : '-1.01');
    110. 

  110. 	test_type($db, 160, 'REAL UNSIGNED', 1.01, ($is_mysqlnd) ? 1.01 : '1.01');
    111. 

  111. 

  112. 	test_type($db, 170, 'DOUBLE', -1.01, ($is_mysqlnd) ? -1.01 : '-1.01');
    113. 

  113. 	test_type($db, 180, 'DOUBLE UNSIGNED', 1.01, ($is_mysqlnd) ? 1.01 : '1.01');
    114. 

  114. 

  115. 	test_type($db, 210, 'FLOAT', -1.01, NULL, '/^\-1.0\d+/');
    116. 

  116. 	test_type($db, 220, 'FLOAT UNSIGNED', 1.01, NULL, '/^1.0\d+/');
    117. 

  117. 

  118. 	test_type($db, 250, 'DECIMAL', -1.01, '-1');
    119. 

  119. 	test_type($db, 260, 'DECIMAL UNSIGNED', 1.01, '1');
    120. 

  120. 

  121. 

  122. 	test_type($db, 290, 'NUMERIC', -1.01, '-1');
    123. 

  123. 	test_type($db, 300, 'NUMERIC UNSIGNED', 1.01, '1');
    124. 

  124. 

  125. 	test_type($db, 330, 'DATE', '2008-04-23');
    126. 

  126. 	test_type($db, 340, 'TIME', '14:37:00');
    127. 

  127. 	test_type($db, 350, 'TIMESTAMP', '2008-05-06 21:09:00');
    128. 

  128. 	test_type($db, 360, 'DATETIME', '2008-03-23 14:38:00');
    129. 

  129. 	test_type($db, 370, 'YEAR', 2008, ($is_mysqlnd) ? 2008 : '2008');
    130. 

  130. 

  131. 	test_type($db, 380, 'CHAR(1)', 'a');
    132. 

  132. 	test_type($db, 390, 'CHAR(10)', '0123456789');
    133. 

  133. 	test_type($db, 400, 'CHAR(255)', str_repeat('z', 255));
    134. 

  134. 	test_type($db, 410, 'VARCHAR(1)', 'a');
    135. 

  135. 	test_type($db, 420, 'VARCHAR(10)', '0123456789');
    136. 

  136. 	test_type($db, 430, 'VARCHAR(255)', str_repeat('z', 255));
    137. 

  137. 

  138. 	test_type($db, 440, 'BINARY(1)', str_repeat('a', 1));
    139. 

  139. 	test_type($db, 450, 'BINARY(255)', str_repeat('b', 255));
    140. 

  140. 	test_type($db, 460, 'VARBINARY(1)', str_repeat('a', 1));
    141. 

  141. 	test_type($db, 470, 'VARBINARY(255)', str_repeat('b', 255));
    142. 

  142. 

  143. 	test_type($db, 480, 'TINYBLOB', str_repeat('b', 255));
    144. 

  144. 	test_type($db, 490, 'BLOB', str_repeat('b', 256));
    145. 

  145. 	test_type($db, 500, 'MEDIUMBLOB', str_repeat('b', 256));
    146. 

  146. 	test_type($db, 510, 'LONGBLOB', str_repeat('b', 256));
    147. 

  147. 

  148. 	test_type($db, 520, 'TINYTEXT', str_repeat('b', 255));
    149. 

  149. 	test_type($db, 530, 'TINYTEXT BINARY', str_repeat('b', 255));
    150. 

  150. 

  151. 	test_type($db, 560, 'TEXT', str_repeat('b', 256));
    152. 

  152. 	test_type($db, 570, 'TEXT BINARY', str_repeat('b', 256));
    153. 

  153. 

  154. 	test_type($db, 580, 'MEDIUMTEXT', str_repeat('b', 256));
    155. 

  155. 	test_type($db, 590, 'MEDIUMTEXT BINARY', str_repeat('b', 256));
    156. 

  156. 

  157. 	test_type($db, 600, 'LONGTEXT', str_repeat('b', 256));
    158. 

  158. 	test_type($db, 610, 'LONGTEXT BINARY', str_repeat('b', 256));
    159. 

  159. 

  160. 	test_type($db, 620, "ENUM('yes', 'no') DEFAULT 'yes'", 'no');
    161. 

  161. 	test_type($db, 630, "SET('yes', 'no') DEFAULT 'yes'", 'no');
    162. 

  162. 

  163. 	test_type($db, 640, 'DECIMAL(3,2)', -1.01, '-1.01');
    164. 

  164. 

  165. 

  166. 	echo "done!\n";
    167. 

  167. ?>
    168. 

  168. <?php
    169. 

  169. require dirname(__FILE__) . '/mysql_pdo_test.inc';
    170. 

  170. $db = MySQLPDOTest::factory();
    171. 

  171. $db->exec('DROP TABLE IF EXISTS test');
    172. 

  172. ?>
    173.