+require 'common/domain'
require 'common/plugin'
+require 'common/user'
require 'pg'
module PostfixadminPlugin
end
- def describe_user(user)
- # There's no other unique identifier in PostfixAdmin
- return user
- end
-
-
- def describe_domain(domain)
- # There's no other unique identifier in PostfixAdmin
- return domain
- end
-
-
def list_domains()
domains = []
raise DatabaseError.new(e)
end
- return domains
+ return domains.map{ |d| Domain.new(d) }
end
+
def list_users()
users = []
@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|
users = result.field_values('username')
raise DatabaseError.new(e)
end
- return users
+ return users.map{ |u| User.new(u) }
end
sql_query = 'SELECT username FROM mailbox WHERE domain IN $1;'
- connection.query(sql_query, [domains]) do |result|
+ connection.query(sql_query, domains.map{|d| d.to_s()}) do |result|
usernames = result.field_values('username')
end
raise DatabaseError.new(e)
end
- return usernames
+ return usernames.map{ |u| User.new(u) }
+ 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