* (bug 5767) Fix date formats in Vietnamese locale
[lhc/web/wiklou.git] / tests / DatabaseTest.php
index e62194f..a721c98 100644 (file)
@@ -7,19 +7,52 @@ require_once( '../includes/GlobalFunctions.php' );
 
 class DatabaseTest extends PHPUnit_TestCase {
        var $db;
-       
+
        function DatabaseTest( $name ) {
                $this->PHPUnit_TestCase( $name );
        }
-       
+
        function setUp() {
                $this->db =& new Database();
        }
-       
+
        function tearDown() {
                unset( $this->db );
        }
-       
+
+       function testAddQuotesNull() {
+               $this->assertEquals(
+                       'NULL',
+                       $this->db->addQuotes( NULL ) );
+       }
+
+       function testAddQuotesInt() {
+               # returning just "1234" should be ok too, though...
+               # maybe
+               $this->assertEquals(
+                       "'1234'",
+                       $this->db->addQuotes( 1234 ) );
+       }
+
+       function testAddQuotesFloat() {
+               # returning just "1234.5678" would be ok too, though
+               $this->assertEquals(
+                       "'1234.5678'",
+                       $this->db->addQuotes( 1234.5678 ) );
+       }
+
+       function testAddQuotesString() {
+               $this->assertEquals(
+                       "'string'",
+                       $this->db->addQuotes( 'string' ) );
+       }
+
+       function testAddQuotesStringQuote() {
+               $this->assertEquals(
+                       "'string\'s cause trouble'",
+                       $this->db->addQuotes( "string's cause trouble" ) );
+       }
+
        function testFillPreparedEmpty() {
                $sql = $this->db->fillPrepared(
                        'SELECT * FROM interwiki', array() );
@@ -27,7 +60,7 @@ class DatabaseTest extends PHPUnit_TestCase {
                        "SELECT * FROM interwiki",
                        $sql);
        }
-       
+
        function testFillPreparedQuestion() {
                $sql = $this->db->fillPrepared(
                        'SELECT * FROM cur WHERE cur_namespace=? AND cur_title=?',
@@ -36,7 +69,7 @@ class DatabaseTest extends PHPUnit_TestCase {
                        "SELECT * FROM cur WHERE cur_namespace='4' AND cur_title='Snicker\'s_paradox'",
                        $sql);
        }
-       
+
        function testFillPreparedBang() {
                $sql = $this->db->fillPrepared(
                        'SELECT user_id FROM ! WHERE user_name=?',