From 1fe2e9e56eaa02ce4301545d9998c7f36dd64d2e Mon Sep 17 00:00:00 2001
From: Michael Orlitzky <michael@orlitzky.com>
Date: Sun, 13 Jun 2010 11:39:19 -0400
Subject: [PATCH] Added the get_domains_from_db() function to the
 PostfixadminDb class.

---
 src/postfixadmin_db.rb | 28 +++++++++++++++++++++++++++-
 1 file changed, 27 insertions(+), 1 deletion(-)

diff --git a/src/postfixadmin_db.rb b/src/postfixadmin_db.rb
index 5291a53..f4e6feb 100644
--- a/src/postfixadmin_db.rb
+++ b/src/postfixadmin_db.rb
@@ -20,6 +20,32 @@ class PostfixadminDb
   end
 
 
+  def get_domains_from_db()
+    # Just assume PostgreSQL for now.
+    begin
+      connection = PGconn.connect(@db_host,
+                                  @db_port,
+                                  @db_opts,
+                                  @db_tty,
+                                  @db_name,
+                                  @db_user,
+                                  @db_pass)
+
+      sql_query = 'SELECT domain FROM domain;'
+      result = connection.query(sql_query)
+      connection.close()
+    rescue PGError => e
+      # But pretend like we're database-agnostic in case we ever are.
+      raise DatabaseError.new(e)
+    end
+
+    # The database query returns an array of rows. Since we only asked
+    # for one column (domain), we can flatten the result into an
+    # array of domains.
+    return result.flatten
+  end
+
+
   def get_accounts_from_db()
     # Just assume PostgreSQL for now.
     begin
@@ -46,5 +72,5 @@ class PostfixadminDb
     # array of addresses.
     return result.flatten
   end
-  
+
 end
-- 
2.44.2