-require 'postgres'
+require 'pg'
class PostfixadminDb
end
+ def get_domains_from_db()
+ domains = []
+
+ # Just assume PostgreSQL for now.
+ begin
+ connection = PGconn.connect(@db_host,
+ @db_port,
+ @db_opts,
+ @db_tty,
+ @db_name,
+ @db_user,
+ @db_pass)
+
+ # 'ALL' is a magic domain, and we don't want it.
+ sql_query = "SELECT domain FROM domain WHERE domain <> 'ALL';"
+ connection.query(sql_query) do |result|
+ domains = result.field_values('domain')
+ end
+ connection.close()
+ rescue PGError => e
+ # But pretend like we're database-agnostic in case we ever are.
+ raise DatabaseError.new(e)
+ end
+
+ return domains
+ end
+
+
def get_accounts_from_db()
+ accounts = []
+
# Just assume PostgreSQL for now.
begin
connection = PGconn.connect(@db_host,
# If address = goto, then the alias basically says, "really
# deliver to that address; it's not an alias."
- sql_query = 'SELECT address FROM alias WHERE address = goto;'
- result = connection.query(sql_query)
+ sql_query = 'SELECT username FROM mailbox;'
+ connection.query(sql_query) do |result|
+ accounts = result.field_values('username')
+ end
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 (address), we can flatten the result into an
- # array of addresses.
- return result.flatten
+ return accounts
end
-
+
end