X-Git-Url: http://gitweb.michael.orlitzky.com/?p=mailshears.git;a=blobdiff_plain;f=lib%2Fcommon%2Fpostfixadmin_plugin.rb;h=b14f295031e4ff1178ec114ca483562604d394d4;hp=7a1985202cc343af0301518dc9a9e94abf03c799;hb=35dffd876681d82cb87d54c6a28b8cbdfcc28925;hpb=365d681f1ef45bd3f5f2c9dded07108bdd75a1ff diff --git a/lib/common/postfixadmin_plugin.rb b/lib/common/postfixadmin_plugin.rb index 7a19852..b14f295 100644 --- a/lib/common/postfixadmin_plugin.rb +++ b/lib/common/postfixadmin_plugin.rb @@ -17,9 +17,9 @@ module PostfixadminPlugin end - def describe_account(account) + def describe_user(user) # There's no other unique identifier in PostfixAdmin - return account + return user end @@ -58,7 +58,7 @@ module PostfixadminPlugin def list_users() - accounts = [] + users = [] # Just assume PostgreSQL for now. begin @@ -70,11 +70,9 @@ module PostfixadminPlugin @db_user, @db_pass) - # If address = goto, then the alias basically says, "really - # deliver to that address; it's not an alias." sql_query = 'SELECT username FROM mailbox;' connection.query(sql_query) do |result| - accounts = result.field_values('username') + users = result.field_values('username') end connection.close() rescue PGError => e @@ -82,7 +80,7 @@ module PostfixadminPlugin raise DatabaseError.new(e) end - return accounts + return users end @@ -114,4 +112,35 @@ module PostfixadminPlugin return usernames end + + def list_aliases() + # + # Get a list of all aliases, useful for testing. + # + aliases = [] + + # 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 address,goto FROM alias;' + results = connection.query(sql_query) + results.each do |row| + aliases << row # row should be a hash + end + connection.close() + rescue PGError => e + # But pretend like we're database-agnostic in case we ever are. + raise DatabaseError.new(e) + end + + return aliases + end + end