--- trunk/sender.pl	2005/05/13 21:17:58	1
+++ trunk/sender.pl	2005/05/16 21:54:41	30
@@ -1,42 +1,257 @@
 #!/usr/bin/perl -w
 
 use strict;
-use Class::DBI::Loader::Pg;
+use blib;
+use Nos;
 use Getopt::Long;
-use Data::Dumper;
 
-my ($lists,$debug) = (0,0);
+=head1 NAME
+
+sender.pl - command line notify sender utility
+
+=head1 SYNOPSYS
+
+ sender.pl --new=mylist
+ sender.pl --add=mylist members.txt
+ sender.pl --list[=mylist]
+ sender.pl --queue[=mylist message.txt]
+ sender.pl --send=mylist
+
+In C</etc/aliases> something like:
+
+ mylist: "| /path/to/sender.pl --inbox=mylist"
+
+=head2 Command options
+
+=over 20
+
+=cut
+
+my $debug = 0;
+my $verbose = 0;
+my $opt;
 
 my $result = GetOptions(
-	"lists"	=> \$lists,
+	"new=s" => \$opt->{'new'},
+	"list:s" => \$opt->{'list'},
+	"add=s" => \$opt->{'add'},
+	"queue:s" => \$opt->{'queue'},
+	"send:s" => \$opt->{'send'},
+	"inbox=s" => \$opt->{'inbox'},
 	"debug"	=> \$debug,
+	"verbose" => \$verbose,
+	"email=s" => \$opt->{'email'},
 );
 
-
-my $loader = Class::DBI::Loader::Pg->new(
-	debug		=> $debug,
-	dsn		=> "dbi:Pg:dbname=notices",
-	user		=> "dpavlin",
-	password	=> "",
-	namespace	=> "Noticer",
-#	additional_classes      => qw/Class::DBI::AbstractSearch/,
-#	additional_base_classes => qw/My::Stuff/,
-	relationships	=> 1
+my $nos = new Nos(
+	dsn => 'dbi:Pg:dbname=notices',
+	user => 'dpavlin',
+	passwd => '',
+	debug => $debug,
+	verbose => $verbose,
 );
 
-if ($lists) {
-	my $lists = $loader->find_class('lists');
-	my $users = $loader->find_class('users');
-	my $user_list = $loader->find_class('user_list');
-	foreach my $list ($lists->retrieve_all) {
-		print $list->name,"\n";
+my $loader = $nos->{'loader'} || die "can't find loader?";
+
+my $lists = $loader->find_class('lists');
+my $users = $loader->find_class('users');
+my $user_list = $loader->find_class('user_list');
+my $messages = $loader->find_class('messages');
+my $queue = $loader->find_class('queue');
+my $sent = $loader->find_class('sent');
+
+$queue->set_sql( list_queue => qq{
+	SELECT messages.message, messages.date AS date, lists.name AS list
+	FROM queue
+	JOIN messages on message_id = messages.id
+	JOIN lists on list_id = lists.id
+} );
+
+my $list_name;
+
+
+=item --new=list_name my-list@example.com
+
+Adds new list. You can also feed list name as first line to C<STDIN>.
+
+=cut
+
+if ($list_name = $opt->{'new'}) {
+
+	my $email = shift @ARGV || <>;
+	chomp($email);
+
+	die "need e-mail address for list (as argument or on STDIN)\n" unless ($email);
+
+	my $l = $nos->_get_list($list_name) || $nos->_add_list(
+		list => $list_name,
+		email => $email,
+	) || die "can't add list $list_name\n";
+
+	print "added list $list_name with ID ",$l->id,"\n";
+
+
+=item --list[=list_name]
+
+List all available lists and users on them.
+
+Optional value is name of list. With it, this option will produce just users
+on that list.
+
+=cut
+
+} elsif (defined($list_name = $opt->{'list'})) {
+
+	my @lists;
+
+	if ($list_name ne '') {
+		@lists = $lists->search( name=> $list_name )->first || die "can't find list $list_name";
+	} else {
+		@lists = $lists->retrieve_all;
+	}
+
+	foreach my $list (@lists) {
+		print $list->name," <",$list->email,">\n";
 		foreach my $user_on_list ($user_list->search(list_id => $list->id)) {
 			my $user = $users->retrieve( id => $user_on_list->user_id );
 			print "\t",$user->full_name," <", $user->email, ">\n";
 		}
 	}
+
+
+=item --add=list_name
+
+Add users to list. Users are stored in file (which can be supplied as
+argument) or read from C<STDIN>. List should be in following format:
+
+ email@example.com	Optional full name of person
+ dpavlin@rot13.org	Dobrica Pavlinusic
+
+You may use C<--email> parametar at any time to set From: e-mail address for list.
+B<This seems somewhat cludgy, and it will probably change in future>.
+
+=cut
+
+} elsif ($list_name = $opt->{'add'}) {
+
+	my $list = $lists->find_or_create({
+		name => $list_name,
+	}) || die "can't add list $list_name\n";
+
+	my $added = 0;
+
+	while(<>) {
+		chomp;
+		next if (/^#/ || /^\s*$/);
+		my ($email, $name) = split(/\s+/,$_, 2);
+		$added++ if ($nos->add_member_to_list( email => $email, name => $name, list => $list_name ));
+	}
+
+	print "list ",$list->name," has $added users\n";
+
+
+=item --queue[=list_name]
+
+Queue message for later delivery. Message can be read from file (specified as
+argument) or read from C<STDIN>.
+
+This option without optional parametar will display pending queue. If you
+add C<--verbose> flag, it will display all messages in queue.
+
+=cut
+
+} elsif (defined($list_name = $opt->{'queue'})) {
+
+	if ($list_name ne '') {
+		# add message to list queue
+
+		my $message_text;
+		while(<>) {
+			$message_text .= $_;
+		}
+
+		my $id = $nos->add_message_to_list(
+			list => $list_name,
+			message => $message_text,
+		);
+
+		print "added message $id to list $list_name\n";
+
+	} else {
+		# list messages in queue	
+
+		foreach my $m ($queue->retrieve_all) {
+			next if ($m->all_sent && ! $verbose);
+
+			my $l = $m->all_sent ? 'S' : 'Q';
+
+			my $date = $m->message_id->date;
+			$date =~ s/\..+$//;
+			my $msg = $m->message_id->message;
+			$msg =~ s/\s+/ /gs;
+
+			$l .= sprintf(" %-10s %15s : ", $m->list_id->name, $date);
+			$l .= substr($msg, 0, 79 - length($l));
+
+			print "$l\n";
+		}
+
+	}
+
+
+=item --send[=list_name]
+
+Send e-mails waiting in queue, or with optional argument, just send messages
+for single list.
+
+=cut
+
+} elsif (defined($list_name = $opt->{'send'})) {
+
+	$nos->send_queued_messages($list_name);
+
+
+=item --inbox=list_name
+
+Feed incomming message back into notice sender.
+
+=cut
+
+} elsif ($opt->{'inbox'}) {
+
+	warn "inbox option is not implemented";
+
 } else  {
-	die "$0: unknown command";
+	die "see perldoc $0 for help\n";
 }
 
+=back
+
+
+
+=head2 Helper options
+
+=over 20
+
+=item --debug
+
+Turn on debugging output from C<Class::DBI>
+
+=item --verbose
+
+Dump more info on screen.
+
+=item --email
+
+Used to specify e-mail address where needed.
+
+=back
+
+
+
+=head1 AUTHOR
+
+Dobrica Pavlinusic <dpavlin@rot13.org>
+
+=cut