From cb0a28a4e77c41e149efddce5c79ff6dd6c4ab63 Mon Sep 17 00:00:00 2001
From: uckelman <uckelman@nomic.net>
Date: Sun, 11 Apr 2010 20:46:49 +0000
Subject: Added getLists().

git-svn-id: https://vassalengine.svn.sourceforge.net/svnroot/vassalengine/site-src/trunk@6683 67b53d14-2c14-4ace-a08f-0dab2b34000c
---
 src/Bridge.php      | 13 +++++++++++++
 test/BridgeTest.php | 17 +++++++++++++++++
 2 files changed, 30 insertions(+)

diff --git a/src/Bridge.php b/src/Bridge.php
index 3884154..54f9880 100644
--- a/src/Bridge.php
+++ b/src/Bridge.php
@@ -58,6 +58,19 @@ class Bridge {
     return $row ? $row['forum_id'] : false;
   }
 
+  public function getLists($forumId) {
+    throw_if_null($forumId);
+
+    $sql = 'SELECT list_name FROM forums ' .
+           'WHERE forum_id = ' . $forumId;
+
+    $result = $this->db->query($sql);
+
+    $rows = $result->fetchAll(PDO::FETCH_COLUMN);
+    $result->closeCursor();
+    return $rows;
+  }
+
   public function registerMessage($messageId, $inReplyTo, $references) {
     throw_if_null($messageId);
 
diff --git a/test/BridgeTest.php b/test/BridgeTest.php
index 1c78866..d31f37d 100644
--- a/test/BridgeTest.php
+++ b/test/BridgeTest.php
@@ -163,6 +163,23 @@ class BridgeTest extends PHPUnit_Framework_TestCase {
     );
   }
 
+  /**
+   * @dataProvider providerGetLists
+   */
+  public function testGetLists($forumId, $expected, $ex) {
+    if ($ex) $this->setExpectedException($ex);
+    $bridge = new Bridge($this->db);
+    $this->assertEquals($expected, $bridge->getLists($forumId));
+  }
+
+  public function providerGetLists() {
+    return array(
+      array(null, null, 'Exception'),
+      array('bogus', false, null),
+      array(2, array('messages@forums.vassalengine.org'), null)
+    );
+  }
+
   /**
    * @dataProvider providerSetPostId
    */
-- 
cgit v1.2.3