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() );
"SELECT * FROM interwiki",
$sql);
}
-
+
function testFillPreparedQuestion() {
$sql = $this->db->fillPrepared(
'SELECT * FROM cur WHERE cur_namespace=? AND cur_title=?',
"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=?',