/[notice-sender]/trunk/sender.pl
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /trunk/sender.pl

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 14 by dpavlin, Sun May 15 14:20:08 2005 UTC revision 32 by dpavlin, Mon May 16 22:32:58 2005 UTC
# Line 1  Line 1 
1  #!/usr/bin/perl -w  #!/usr/bin/perl -w
2    
3  use strict;  use strict;
4  use Class::DBI::Loader::Pg;  use blib;
5    use Nos;
6  use Getopt::Long;  use Getopt::Long;
 use Mail::CheckUser qw(check_email);  
 use Email::Valid;  
 use Email::Send;  
7    
8  =head1 NAME  =head1 NAME
9    
# Line 13  sender.pl - command line notify sender u Line 11  sender.pl - command line notify sender u
11    
12  =head1 SYNOPSYS  =head1 SYNOPSYS
13    
14     sender.pl --new=mylist
15   sender.pl --add=mylist members.txt   sender.pl --add=mylist members.txt
16   sender.pl --list[=mylist]   sender.pl --list[=mylist]
17   sender.pl --queue[=mylist message.txt]   sender.pl --queue[=mylist message.txt]
18   sender.pl --send=mylist   sender.pl --send=mylist
19    
20  =head2 All options  In C</etc/aliases> something like:
21    
22  =over 20   mylist: "| /path/to/sender.pl --inbox=mylist"
23    
24  =item --debug  =head2 Command options
25    
26  Turn on debugging output from C<Class::DBI>  =over 20
27    
28  =cut  =cut
29    
30  my $debug = 0;  my $debug = 0;
31  my $list_opt;  my $verbose = 0;
32  my $add_opt;  my $opt;
 my $queue_opt;  
 my $send_opt;  
33    
34  my $result = GetOptions(  my $result = GetOptions(
35          "list:s" => \$list_opt,          "new=s" => \$opt->{'new'},
36          "add=s" => \$add_opt,          "list:s" => \$opt->{'list'},
37          "queue:s" => \$queue_opt,          "add=s" => \$opt->{'add'},
38          "send:s" => \$send_opt,          "queue:s" => \$opt->{'queue'},
39            "send:s" => \$opt->{'send'},
40            "inbox=s" => \$opt->{'inbox'},
41          "debug" => \$debug,          "debug" => \$debug,
42            "verbose" => \$verbose,
43            "email=s" => \$opt->{'email'},
44  );  );
45    
46    my $nos = new Nos(
47  my $loader = Class::DBI::Loader::Pg->new(          dsn => 'dbi:Pg:dbname=notices',
48          debug           => $debug,          user => 'dpavlin',
49          dsn             => "dbi:Pg:dbname=notices",          passwd => '',
50          user            => "dpavlin",          debug => $debug,
51          password        => "",          verbose => $verbose,
         namespace       => "Noticer",  
 #       additional_classes      => qw/Class::DBI::AbstractSearch/,  
 #       additional_base_classes => qw/My::Stuff/,  
         relationships   => 1,  
52  );  );
53    
54    my $loader = $nos->{'loader'} || die "can't find loader?";
55    
56  my $lists = $loader->find_class('lists');  my $lists = $loader->find_class('lists');
57  my $users = $loader->find_class('users');  my $users = $loader->find_class('users');
58  my $user_list = $loader->find_class('user_list');  my $user_list = $loader->find_class('user_list');
59  my $messages = $loader->find_class('messages');  my $messages = $loader->find_class('messages');
60  my $queue = $loader->find_class('queue');  my $queue = $loader->find_class('queue');
61    my $sent = $loader->find_class('sent');
62    
63  $queue->set_sql( list_queue => qq{  $queue->set_sql( list_queue => qq{
64          SELECT messages.message, messages.date AS message_date, lists.name AS list          SELECT messages.message, messages.date AS date, lists.name AS list
65          FROM queue          FROM queue
66          JOIN messages on message_id = messages.id          JOIN messages on message_id = messages.id
67          JOIN lists on list_id = lists.id          JOIN lists on list_id = lists.id
68  } );  } );
69    
70    my $list_name;
71    
72    
73    =item --new=list_name my-list@example.com
74    
75    Adds new list. You can also feed list name as first line to C<STDIN>.
76    
77    =cut
78    
79    if ($list_name = $opt->{'new'}) {
80    
81            my $email = shift @ARGV || <>;
82            chomp($email);
83    
84            die "need e-mail address for list (as argument or on STDIN)\n" unless ($email);
85    
86            my $l = $nos->_get_list($list_name) || $nos->_add_list(
87                    list => $list_name,
88                    email => $email,
89            ) || die "can't add list $list_name\n";
90    
91            print "added list $list_name with ID ",$l->id,"\n";
92    
93    
94  =item --list[=list_name]  =item --list[=list_name]
95    
# Line 77  on that list. Line 100  on that list.
100    
101  =cut  =cut
102    
103  if (defined($list_opt)) {  } elsif (defined($list_name = $opt->{'list'})) {
104    
105          my @lists;          my @lists;
106          if ($list_opt ne '') {  
107                  @lists = $lists->search( name=> $list_opt )->first || die "can't find list $list_opt";          if ($list_name ne '') {
108                    @lists = $lists->search( name=> $list_name )->first || die "can't find list $list_name";
109          } else {          } else {
110                  @lists = $lists->retrieve_all;                  @lists = $lists->retrieve_all;
111          }          }
112    
113          foreach my $list (@lists) {          foreach my $list (@lists) {
114                  print $list->name,"\n";                  print $list->name," <",$list->email,">\n";
115                  foreach my $user_on_list ($user_list->search(list_id => $list->id)) {                  foreach my $user_on_list ($user_list->search(list_id => $list->id)) {
116                          my $user = $users->retrieve( id => $user_on_list->user_id );                          my $user = $users->retrieve( id => $user_on_list->user_id );
117                          print "\t",$user->full_name," <", $user->email, ">\n";                          print "\t",$user->full_name," <", $user->email, ">\n";
118                  }                  }
119          }          }
120    
121    
122  =item --add=list_name  =item --add=list_name
123    
124  Add users to list. Users are stored in file (which can be supplied as  Add users to list. Users are stored in file (which can be supplied as
# Line 101  argument) or read from C<STDIN>. List sh Line 127  argument) or read from C<STDIN>. List sh
127   email@example.com      Optional full name of person   email@example.com      Optional full name of person
128   dpavlin@rot13.org      Dobrica Pavlinusic   dpavlin@rot13.org      Dobrica Pavlinusic
129    
130    You may use C<--email> parametar at any time to set From: e-mail address for list.
131    B<This seems somewhat cludgy, and it will probably change in future>.
132    
133  =cut  =cut
134    
135  } elsif ($add_opt) {  } elsif ($list_name = $opt->{'add'}) {
136          #my $noticer = $loader->find_class('Noticer') || die "can't find my class!";  
137          my $list = $lists->find_or_create({          my $list = $lists->find_or_create({
138                  name => $add_opt,                  name => $list_name,
139          }) || die "can't add list $add_opt\n";          }) || die "can't add list $list_name\n";
140    
141          my $added = 0;          my $added = 0;
142    
# Line 115  argument) or read from C<STDIN>. List sh Line 144  argument) or read from C<STDIN>. List sh
144                  chomp;                  chomp;
145                  next if (/^#/ || /^\s*$/);                  next if (/^#/ || /^\s*$/);
146                  my ($email, $name) = split(/\s+/,$_, 2);                  my ($email, $name) = split(/\s+/,$_, 2);
147                  if (! Email::Valid->address($email)) {                  $added++ if ($nos->add_member_to_list( email => $email, name => $name, list => $list_name ));
                         print "SKIPPING $name <$email>\n";  
                         next;  
                 }  
                 print "# $name <$email>\n";  
                 my $this_user = $users->find_or_create({  
                         email => $email,  
                         full_name => $name,  
                 }) || die "can't find or create member\n";  
                 my $user_on_list = $user_list->find_or_create({  
                         user_id => $this_user->id,  
                         list_id => $list->id,  
                 }) || die "can't add user to list";  
                 $added++;  
         }  
   
         foreach my $c_name ($loader->tables) {  
                 my $c = $loader->find_class($c_name)|| die "can't find $c_name";  
                 $c->dbi_commit();  
148          }          }
149    
150          print "list ",$list->name," has $added users\n";          print "list ",$list->name," has $added users\n";
151    
152    
153  =item --queue[=list_name]  =item --queue[=list_name]
154    
155  Queue message for later delivery. Message can be read from file (specified as  Queue message for later delivery. Message can be read from file (specified as
156  argument) or read from C<STDIN>.  argument) or read from C<STDIN>.
157    
158  This options without optional parametars it will display current queue.  This option without optional parametar will display pending queue. If you
159    add C<--verbose> flag, it will display all messages in queue.
160    
161  =cut  =cut
162    
163  } elsif (defined($queue_opt)) {  } elsif (defined($list_name = $opt->{'queue'})) {
164    
165          if ($queue_opt ne '') {          if ($list_name ne '') {
166                  # add message to list queue                  # add message to list queue
167    
                 my $this_list = $lists->search(  
                         name => $queue_opt,  
                 )->first || die "can't find list $queue_opt";  
   
168                  my $message_text;                  my $message_text;
169                  while(<>) {                  while(<>) {
170                          $message_text .= $_;                          $message_text .= $_;
171                  }                  }
172    
173                  die "no message" unless ($message_text);                  my $id = $nos->add_message_to_list(
174                            list => $list_name,
175                            message => $message_text,
176                    ) || die "can't add message to list $list_name\n";
177    
178                  my $this_message = $messages->find_or_create({                  print "added message $id to list $list_name\n";
                         message => $message_text  
                 }) || die "can't insert message";  
179    
180                  $this_message->dbi_commit() || die "can't add message";          } else {
181                    # list messages in queue        
182    
183                  $queue->find_or_create({                  foreach my $m ($queue->retrieve_all) {
184                          message_id => $this_message->id,                          next if ($m->all_sent && ! $verbose);
                         list_id => $this_list->id,  
                 }) || die "can't add message ",$this_message->id," to list ",$this_list->id, ": ",$this_list->name;  
185    
186                  $queue->dbi_commit || die "can't add message to list ",$this_list->name;                          my $l = $m->all_sent ? 'S' : 'Q';
187    
188                  print "added message ",$this_message->id, " to list ",$this_list->name,"\n";                          my $date = $m->message_id->date;
189                            $date =~ s/\..+$//;
190                            my $msg = $m->message_id->message;
191                            $msg =~ s/\s+/ /gs;
192    
193          } else {                          $l .= sprintf(" %-10s %15s : ", $m->list_id->name, $date);
194                  # list messages in queue                                  $l .= substr($msg, 0, 79 - length($l));
195    
                 foreach my $m ($queue->retrieve_all) {  
                         my $l = sprintf("%-10s %15s : ", $m->list_id->name, $m->message_id->date);  
                         $l .= substr($m->message_id->message, 0, 79 - length($l));  
                         $l =~ s/[\n\r]/ /gs;  
196                          print "$l\n";                          print "$l\n";
197                  }                  }
198    
199          }          }
200    
201    
202  =item --send[=list_name]  =item --send[=list_name]
203    
204  Send e-mail waiting in queue for all lists, or with optional argument for  Send e-mails waiting in queue, or with optional argument, just send messages
205  just single list.  for single list.
206    
207  =cut  =cut
208    
209  } elsif (defined($send_opt)) {  } elsif (defined($list_name = $opt->{'send'})) {
210    
211            $nos->send_queued_messages($list_name);
212    
         die "send option not yet implemented";  
213    
214          my @q;  =item --inbox=list_name
215          if ($send_opt ne '') {  
216  #               @q => $queue->search( name => 'foo' );  Feed incomming message back into notice sender.
217          }  
218          foreach my $q (@q) {  =cut
219                    
220          }  } elsif ($opt->{'inbox'}) {
221    
222            warn "inbox option is not implemented";
223    
224  } else  {  } else  {
225          die "see perldoc $0 for help";          die "see perldoc $0 for help\n";
226  }  }
227    
228  =back  =back
229    
230    
231    
232    =head2 Helper options
233    
234    =over 20
235    
236    =item --debug
237    
238    Turn on debugging output from C<Class::DBI>
239    
240    =item --verbose
241    
242    Dump more info on screen.
243    
244    =item --email
245    
246    Used to specify e-mail address where needed.
247    
248    =back
249    
250    
251    
252  =head1 AUTHOR  =head1 AUTHOR
253    
254  Dobrica Pavlinusic <dpavlin@rot13.org>  Dobrica Pavlinusic <dpavlin@rot13.org>
Legend:
Removed from v.14  
changed lines
  Added in v.32
  ViewVC Help
Powered by ViewVC 1.1.26