X-Git-Url: http://gitweb.michael.orlitzky.com/?p=mailshears.git;a=blobdiff_plain;f=lib%2Fpostfixadmin_db.rb;fp=lib%2Fpostfixadmin_db.rb;h=0000000000000000000000000000000000000000;hp=0249ea07949b384a5438f34c9c5f7c27e582d7e0;hb=314f5670531dfda9b3d708fce8b0161a098cf134;hpb=fd60e4e45d24c7efe5bc2710ae23f60bbb6b7be1 diff --git a/lib/postfixadmin_db.rb b/lib/postfixadmin_db.rb deleted file mode 100644 index 0249ea0..0000000 --- a/lib/postfixadmin_db.rb +++ /dev/null @@ -1,79 +0,0 @@ -require 'pg' - -class PostfixadminDb - - def initialize(db_host, - db_port, - db_opts, - db_tty, - db_name, - db_user, - db_pass) - - @db_host = db_host - @db_port = db_port - @db_opts = db_opts - @db_tty = db_tty - @db_name = db_name - @db_user = db_user - @db_pass = db_pass - 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, - @db_port, - @db_opts, - @db_tty, - @db_name, - @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') - end - connection.close() - rescue PGError => e - # But pretend like we're database-agnostic in case we ever are. - raise DatabaseError.new(e) - end - - return accounts - end - -end