1 files changed, 56 insertions, 7 deletions

diff --git a/test/BridgeTest.php b/test/BridgeTest.php
index 3036f2b..b9f8e0d 100644
--- a/test/BridgeTest.php
+++ b/test/BridgeTest.php
@@ -5,18 +5,68 @@ require_once('src/Bridge.php');
 
 class BridgeTest extends PHPUnit_Framework_TestCase {
 
+  protected $db;
+
+  protected function setUp() {
+    $this->db = new PDO('mysql:host=localhost;dbname=test');
+    $this->db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
+
+    $this->db->exec('DROP TABLE IF EXISTS posts');
+
+    $this->db->exec(
+      'CREATE TABLE posts (' .
+      'post_id MEDIUMINT UNSIGNED NOT NULL, ' .
+      'message_id VARCHAR(255) NOT NULL, ' .
+      'in_reply_to VARCHAR(255), ' .
+      'refs BLOB, ' .
+      'PRIMARY KEY (post_id), ' .
+      'UNIQUE KEY (message_id))'
+    );
+
+    $this->db->exec(
+      'INSERT INTO posts (post_id, message_id, in_reply_to, refs) ' .
+      'VALUES (' .
+        '1, ' .
+        '"<20100302094228.33F0310091@charybdis.ellipsis.cx>", ' .
+        '"<1267473003.m2f.17543@www.vassalengine.org>", ' .
+        '"<1267171317.m2f.17507@www.vassalengine.org> <1267473003.m2f.17543@www.vassalengine.org>"' .
+      ')'
+    );
+  }
+
+  protected function tearDown() {
+    $this->db = null;
+  }
+
   /**
    * @dataProvider providerGetPostId
    */
   public function testGetPostId($message_id, $expected, $ex) {
-    $bridge = new Bridge();
     if ($ex) $this->setExpectedException($ex);
+    $bridge = new Bridge($this->db);
     $this->assertEquals($expected, $bridge->getPostId($message_id));
   }
 
   public function providerGetPostId() {
     return array(
       array('bogus', null, 'PHPUnit_Framework_Error'), 
+      array('<20100302094228.33F0310091@charybdis.ellipsis.cx>', 1, null),
+    );
+  }
+
+  /**
+   * @dataProvider providerGetMessageId
+   */
+  public function testGetMessageId($post_id, $expected, $ex) {
+    if ($ex) $this->setExpectedException($ex);
+    $bridge = new Bridge($this->db);
+    $this->assertEquals($expected, $bridge->getMessageId($post_id));
+  }
+
+  public function providerGetMessageId() {
+    return array(
+      array('bogus', null, 'PHPUnit_Framework_Error'), 
+      array(1, '<20100302094228.33F0310091@charybdis.ellipsis.cx>', null),
     );
   }
 
@@ -25,7 +75,7 @@ class BridgeTest extends PHPUnit_Framework_TestCase {
    */
   public function testRegisterMessage($msg, $expected, $ex) {
     $this->markTestIncomplete();
-#    $bridge = new Bridge();
+#    $bridge = new Bridge($this->db);
 #    if ($ex) $this->setExpectedException($ex);
 #    $this->assertEquals($expected, $bridge->registerMessage($msg));
   }
@@ -39,9 +89,10 @@ class BridgeTest extends PHPUnit_Framework_TestCase {
    * @dataProvider providerGetDefaultForumId
    */
   public function testGetDefaultForumId($list, $expected, $ex) {
-    $bridge = new Bridge();
-    if ($ex) $this->setExpectedException($ex);
-    $this->assertEquals($expected, $bridge->getDefaultForumId($list));
+    $this->markTestIncomplete();
+#    if ($ex) $this->setExpectedException($ex);
+#    $bridge = new Bridge($this->db);
+#    $this->assertEquals($expected, $bridge->getDefaultForumId($list));
   }
 
   public function providerGetDefaultForumId() {
@@ -50,8 +101,6 @@ class BridgeTest extends PHPUnit_Framework_TestCase {
 #      array('messages@forums.vassalengine.org', 2, null),
     );
   }
-
-
 }
 
 ?>