| // +----------------------------------------------------------------------+ // // $Id: MDB2_function_testcase.php,v 1.20 2006/08/07 20:15:57 lsmith Exp $ class MDB2_Function_TestCase extends MDB2_TestCase { function setUp() { parent::setUp(); $this->db->loadModule('Function', null, true); } /** * Test functionTable() */ function testFunctionTable() { if (!$this->methodExists($this->db->function, 'functionTable')) { return; } $functionTable_clause = $this->db->function->functionTable(); $query = 'SELECT 1 '.$functionTable_clause; $result = $this->db->queryOne($query); if (PEAR::isError($result)) { $this->assertFalse(true, 'Error fetching from function table'); } else { $this->assertEquals('1', $result, 'Error fetching value from function table'); } } /** * Test now() */ function testNow() { if (!$this->methodExists($this->db->function, 'now')) { return; } $tests = array( 'timestamp' => '/^\d{4}-\d{2}-\d{2} \d{2}:\d{2}:\d{2}$/', 'date' => '/^\d{4}-\d{2}-\d{2}$/', 'time' => '/^\d{2}:\d{2}:\d{2}$/', ); foreach ($tests as $type => $regexp) { $functionTable_clause = $this->db->function->functionTable(); $now_clause = $this->db->function->now($type); $query = 'SELECT '.$now_clause . $functionTable_clause; $result = $this->db->queryOne($query, $type); if (PEAR::isError($result)) { $this->assertFalse(true, 'Error getting '.$type); } else { $this->assertRegExp($regexp, $result, 'Error: not a proper '.$type); } } } /** * Test substring() */ function testSubstring() { if (!$this->methodExists($this->db->function, 'substring')) { return; } $data = $this->getSampleData(1234); $query = 'INSERT INTO users (' . implode(', ', array_keys($this->fields)) . ') VALUES ('.implode(', ', array_fill(0, count($this->fields), '?')).')'; $stmt = $this->db->prepare($query, array_values($this->fields), MDB2_PREPARE_MANIP); $result = $stmt->execute(array_values($data)); $stmt->free(); if (PEAR::isError($result)) { $this->assertTrue(false, 'Error executing prepared query'.$result->getMessage()); } $substring_clause = $this->db->function->substring('user_name', 1, 4); $query = 'SELECT '.$substring_clause .' FROM users'; $result = $this->db->queryOne($query); if (PEAR::isError($result)) { $this->assertFalse(true, 'Error getting substring'); } else { $this->assertEquals('user', $result, 'Error: substrings not equals'); } $substring_clause = $this->db->function->substring('user_name', 5, 1); $query = 'SELECT '.$substring_clause .' FROM users'; $result = $this->db->queryOne($query); if (PEAR::isError($result)) { $this->assertFalse(true, 'Error getting substring'); } else { $this->assertEquals('_', $result, 'Error: substrings not equals'); } //test NULL 2nd parameter $substring_clause = $this->db->function->substring('user_name', 6); $query = 'SELECT '.$substring_clause .' FROM users'; $result = $this->db->queryOne($query); if (PEAR::isError($result)) { $this->assertFalse(true, 'Error getting substring'); } else { $this->assertEquals('1234', $result, 'Error: substrings not equals'); } } /** * Test concat() */ function testConcat() { if (!$this->methodExists($this->db->function, 'concat')) { return; } $functionTable_clause = $this->db->function->functionTable(); $concat_clause = $this->db->function->concat($this->db->quote('time', 'text'), $this->db->quote('stamp', 'text')); $query = 'SELECT '.$concat_clause . $functionTable_clause; $result = $this->db->queryOne($query); if (PEAR::isError($result)) { $this->assertFalse(true, 'Error getting concat'); } else { $this->assertEquals('timestamp', $result, 'Error: could not concatenate "time+stamp"'); } } /** * Test random() */ function testRandom() { if (!$this->methodExists($this->db->function, 'random')) { return; } $rand_clause = $this->db->function->random(); $functionTable_clause = $this->db->function->functionTable(); $query = 'SELECT '.$rand_clause . $functionTable_clause; $result = $this->db->queryOne($query, 'float'); if (PEAR::isError($result)) { $this->assertFalse(true, 'Error getting random value:'. $result->getMessage()); } else { $this->assertTrue(($result >= 0 && $result <= 1), 'Error: could not get random value between 0 and 1: '.$result); } } /** * Test lower() */ function testLower() { if (!$this->methodExists($this->db->function, 'lower')) { return; } $string = $this->db->quote('FoO'); $lower_clause = $this->db->function->lower($string); $functionTable_clause = $this->db->function->functionTable(); $query = 'SELECT '.$lower_clause . $functionTable_clause; $result = $this->db->queryOne($query, 'text'); if (PEAR::isError($result)) { $this->assertFalse(true, 'Error getting lower case value:'. $result->getMessage()); } else { $this->assertTrue(($result === 'foo'), 'Error: could not lower case "FoO": '.$result); } } /** * Test upper() */ function testUpper() { if (!$this->methodExists($this->db->function, 'upper')) { return; } $string = $this->db->quote('FoO'); $upper_clause = $this->db->function->upper($string); $functionTable_clause = $this->db->function->functionTable(); $query = 'SELECT '.$upper_clause . $functionTable_clause; $result = $this->db->queryOne($query, 'text'); if (PEAR::isError($result)) { $this->assertFalse(true, 'Error getting upper case value:'. $result->getMessage()); } else { $this->assertTrue(($result === 'FOO'), 'Error: could not upper case "FoO": '.$result); } } } ?>