/[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 19 by dpavlin, Sun May 15 17:04:18 2005 UTC revision 61 by dpavlin, Wed Jun 22 12:26:54 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 Email::Valid;  
 use Email::Send;  
7    
8  =head1 NAME  =head1 NAME
9    
# Line 12  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 --delete=mylist members.txt
17   sender.pl --list[=mylist]   sender.pl --list[=mylist]
18   sender.pl --queue[=mylist message.txt]   sender.pl --queue[=mylist message.txt]
19   sender.pl --send=mylist   sender.pl --send=mylist
20    
21    In C</etc/aliases> something like:
22    
23     mylist: "| cd /path/to && ./sender.pl --inbox=mylist"
24    
25  =head2 Command options  =head2 Command options
26    
27  =over 20  =over 20
# Line 25  sender.pl - command line notify sender u Line 30  sender.pl - command line notify sender u
30    
31  my $debug = 0;  my $debug = 0;
32  my $verbose = 0;  my $verbose = 0;
33  my $list_opt;  my $opt;
 my $add_opt;  
 my $queue_opt;  
 my $send_opt;  
 my $email_opt;  
34    
35  my $result = GetOptions(  my $result = GetOptions(
36          "list:s" => \$list_opt,          "new=s" => \$opt->{'new'},
37          "add=s" => \$add_opt,          "list:s" => \$opt->{'list'},
38          "queue:s" => \$queue_opt,          "add=s" => \$opt->{'add'},
39          "send:s" => \$send_opt,          "delete=s" => \$opt->{'delete'},
40            "queue:s" => \$opt->{'queue'},
41            "send:s" => \$opt->{'send'},
42            "inbox=s" => \$opt->{'inbox'},
43          "debug" => \$debug,          "debug" => \$debug,
44          "verbose" => \$verbose,          "verbose" => \$verbose,
45          "email=s" => \$email_opt,          "from=s" => \$opt->{'from'},
46            "driver=s" => \$opt->{'email_send_driver'},
47            "sleep=i" => \$opt->{'sleep'},
48  );  );
49    
50    my $nos = new Nos(
51  my $loader = Class::DBI::Loader::Pg->new(          dsn => 'dbi:Pg:dbname=notices',
52          debug           => $debug,          user => 'dpavlin',
53          dsn             => "dbi:Pg:dbname=notices",          passwd => '',
54          user            => "dpavlin",          debug => $debug,
55          password        => "",          verbose => $verbose,
         namespace       => "Noticer",  
 #       additional_classes      => qw/Class::DBI::AbstractSearch/,  
 #       additional_base_classes => qw/My::Stuff/,  
         relationships   => 1,  
56  );  );
57    
58    my $loader = $nos->{'loader'} || die "can't find loader?";
59    
60  my $lists = $loader->find_class('lists');  my $lists = $loader->find_class('lists');
61  my $users = $loader->find_class('users');  my $users = $loader->find_class('users');
62  my $user_list = $loader->find_class('user_list');  my $user_list = $loader->find_class('user_list');
# Line 67  $queue->set_sql( list_queue => qq{ Line 71  $queue->set_sql( list_queue => qq{
71          JOIN lists on list_id = lists.id          JOIN lists on list_id = lists.id
72  } );  } );
73    
74    my $list_name;
75    
76    
77    =item --new=list_name my-list@example.com
78    
79    Adds new list. You can also feed list name as first line to C<STDIN>.
80    
81    You can also add C<--from='Full name of list'> to specify full name (comment)
82    in outgoing e-mail.
83    
84    =cut
85    
86    if ($list_name = $opt->{'new'}) {
87    
88            my $email = shift @ARGV || <>;
89            chomp($email);
90    
91            die "need e-mail address for list (as argument or on STDIN)\n" unless ($email);
92    
93            my $id = $nos->new_list(
94                    list => $list_name,
95                    from => ($opt->{'from'} || ''),
96                    email => $email,
97            ) || die "can't add list $list_name\n";
98    
99            print "added list $list_name with ID $id\n";
100    
101    
102  =item --list[=list_name]  =item --list[=list_name]
103    
# Line 77  on that list. Line 108  on that list.
108    
109  =cut  =cut
110    
111  if (defined($list_opt)) {  } elsif (defined($list_name = $opt->{'list'})) {
112    
113          my @lists;          my @lists;
114          if ($list_opt ne '') {  
115                  @lists = $lists->search( name=> $list_opt )->first || die "can't find list $list_opt";          if ($list_name ne '') {
116                    @lists = $lists->search( name=> $list_name )->first || die "can't find list $list_name";
117          } else {          } else {
118                  @lists = $lists->retrieve_all;                  @lists = $lists->retrieve_all;
119          }          }
120    
121          foreach my $list (@lists) {          foreach my $list (@lists) {
122                  print $list->name," <",$list->email,">\n";                  print $list->name,": ",$list->from_addr," <",$list->email,">\n";
123                  foreach my $user_on_list ($user_list->search(list_id => $list->id)) {                  foreach my $u ($nos->list_members( list => $list->name )) {
124                          my $user = $users->retrieve( id => $user_on_list->user_id );                          print "\t",$u->{'name'}, " <", $u->{'email'}, ">",( $u->{'ext_id'} ? ' ['.$u->{'ext_id'}.']' : '' ),"\n";
                         print "\t",$user->full_name," <", $user->email, ">\n";  
125                  }                  }
126          }          }
127    
128    
129  =item --add=list_name  =item --add=list_name
130    
131  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 134  argument) or read from C<STDIN>. List sh
134   email@example.com      Optional full name of person   email@example.com      Optional full name of person
135   dpavlin@rot13.org      Dobrica Pavlinusic   dpavlin@rot13.org      Dobrica Pavlinusic
136    
 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>.  
   
137  =cut  =cut
138    
139  } elsif ($add_opt) {  } elsif ($list_name = $opt->{'add'}) {
140          #my $noticer = $loader->find_class('Noticer') || die "can't find my class!";  
141          my $list = $lists->find_or_create({          my $list = $nos->_get_list($list_name) || die "can't find list $list_name\n";
                 name => $add_opt,  
         }) || die "can't add list $add_opt\n";  
         if ($email_opt && $list->email ne $email_opt) {  
                 $list->email($email_opt);  
                 $list->update;  
                 $list->dbi_commit;  
         }  
142    
143          my $added = 0;          my $added = 0;
144    
# Line 123  B<This seems somewhat cludgy, and it wil Line 146  B<This seems somewhat cludgy, and it wil
146                  chomp;                  chomp;
147                  next if (/^#/ || /^\s*$/);                  next if (/^#/ || /^\s*$/);
148                  my ($email, $name) = split(/\s+/,$_, 2);                  my ($email, $name) = split(/\s+/,$_, 2);
149                  $name ||= '';                  $added++ if ($nos->add_member_to_list( email => $email, name => $name, list => $list_name ));
                 if (! Email::Valid->address($email)) {  
                         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++;  
150          }          }
151    
152          foreach my $c_name ($loader->tables) {          print "list ",$list->name," has $added users\n";
153                  my $c = $loader->find_class($c_name)|| die "can't find $c_name";  
154                  $c->dbi_commit();  
155    =item --delete=list_name
156    
157    Delete users from list. User e-mails can be stored in file (which can be
158    supplied as argument) or read from C<STDIN>.
159    
160    =cut
161    } elsif ($list_name = $opt->{'delete'}) {
162    
163            my $list = $nos->_get_list($list_name) || die "can't find list $list_name\n";
164    
165            my $deleted = 0;
166    
167            while(<>) {
168                    chomp;
169                    next if (/^#/ || /^\s*$/);
170                    my $email = $_;
171                    $deleted++ if ($nos->delete_member_from_list( email => $email, list => $list_name ));
172          }          }
173    
174          print "list ",$list->name," has $added users\n";          print "list ",$list->name," lost $deleted users\n";
175    
176    
177  =item --queue[=list_name]  =item --queue[=list_name]
178    
# Line 157  add C<--verbose> flag, it will display a Line 184  add C<--verbose> flag, it will display a
184    
185  =cut  =cut
186    
187  } elsif (defined($queue_opt)) {  } elsif (defined($list_name = $opt->{'queue'})) {
188    
189          if ($queue_opt ne '') {          if ($list_name ne '') {
190                  # add message to list queue                  # add message to list queue
191    
                 my $this_list = $lists->search(  
                         name => $queue_opt,  
                 )->first || die "can't find list $queue_opt";  
   
192                  my $message_text;                  my $message_text;
193                  while(<>) {                  while(<>) {
194                          $message_text .= $_;                          $message_text .= $_;
195                  }                  }
196    
197                  die "no message" unless ($message_text);                  my $id = $nos->add_message_to_list(
198                            list => $list_name,
199                  my $this_message = $messages->find_or_create({                          message => $message_text,
200                          message => $message_text                  ) || die "can't add message to list $list_name\n";
                 }) || die "can't insert message";  
   
                 $this_message->dbi_commit() || die "can't add message";  
   
                 $queue->find_or_create({  
                         message_id => $this_message->id,  
                         list_id => $this_list->id,  
                 }) || die "can't add message ",$this_message->id," to list ",$this_list->id, ": ",$this_list->name;  
   
                 $queue->dbi_commit || die "can't add message to list ",$this_list->name;  
201    
202                  print "added message ",$this_message->id, " to list ",$this_list->name,"\n";                  print "added message $id to list $list_name\n";
203    
204          } else {          } else {
205                  # list messages in queue                          # list messages in queue        
# Line 201  add C<--verbose> flag, it will display a Line 214  add C<--verbose> flag, it will display a
214                          my $msg = $m->message_id->message;                          my $msg = $m->message_id->message;
215                          $msg =~ s/\s+/ /gs;                          $msg =~ s/\s+/ /gs;
216    
217                          $l .= sprintf(" %-10s %15s : ", $m->list_id->name, $date);                          $l .= sprintf(" %-15s %15s : ", $m->list_id->name, $date);
218                          $l .= substr($msg, 0, 79 - length($l));                          $l .= substr($msg, 0, 79 - length($l));
219    
220                          print "$l\n";                          print "$l\n";
# Line 209  add C<--verbose> flag, it will display a Line 222  add C<--verbose> flag, it will display a
222    
223          }          }
224    
225    
226  =item --send[=list_name]  =item --send[=list_name]
227    
228  Send e-mails waiting in queue, or with optional argument, just send messages  Send e-mails waiting in queue, or with optional argument, just send messages
229  for single list.  for single list.
230    
231    Optional argument C<--driver=smtp> forces sending using SMTP server at
232    localhost (127.0.0.1).
233    
234    Optional argument C<--sleep=42> defines that sender will sleep 42 seconds
235    between sending e-mail.
236    
237  =cut  =cut
238    
239  } elsif (defined($send_opt)) {  } elsif (defined($list_name = $opt->{'send'})) {
240    
241          my $my_q;          unless ($opt->{'email_send_driver'}) {
242          if ($send_opt ne '') {                  print "WARNING: this will dump debugging output to STDERR\n";
243                  my $l_id = $lists->search_like( name => $send_opt )->first ||                  print "enter alternative driver (e.g. smtp): ";
244                          die "can't find list $send_opt";                  my $d = <STDIN>;
245                  $my_q = $queue->search_like( list_id => $l_id ) ||                  chomp($d);
246                          die "can't find list $send_opt";                  $opt->{'email_send_driver'} = $d;
         } else {  
                 $my_q = $queue->retrieve_all;  
247          }          }
248    
249          while (my $m = $my_q->next) {          $nos->send_queued_messages(
250                  next if ($m->all_sent);                  list => $list_name,
251                    driver => $opt->{'email_send_driver'},
252                    sleep => $opt->{'sleep'},
253            );
254    
                 print "sending message ",$m->message_id," enqueued on ",$m->date," to list ",$m->list_id->name,"\n";  
                 my $msg = $m->message_id->message;  
255    
256                  foreach my $u ($user_list->search(list_id => $m->list_id)) {  =item --inbox=list_name
257    
258                          if ($sent->search( message_id => $m->message_id, user_id => $u->user_id )) {  Feed incomming message back into notice sender.
259                                  print "SKIP ",$u->user_id->email," message allready sent\n";  
260                          } else {  =cut
261                                  print "\t",$u->user_id->email,"\n";  
262    } elsif ($list_name = $opt->{'inbox'}) {
263                                  my $hdr = "From: " . $u->list_id->name . " <" . $u->list_id->email . ">\n" .  
264                                          "To: " . $u->user_id->full_name . " <". $u->user_id->email. ">\n";          my $message;
265            while(<>) {
266                                  # FIXME do real sending :-)                  $message .= $_;
                                 send IO => "$hdr\n$msg";  
   
                                 $sent->create({  
                                         message_id => $m->message_id,  
                                         user_id => $u->user_id,  
                                 });  
                                 $sent->dbi_commit;  
                         }  
                 }  
                 $m->all_sent(1);  
                 $m->update;  
                 $m->dbi_commit;  
267          }          }
268    
269            $nos->inbox_message(
270                    list => $list_name,
271                    message => $message,
272            ) || die "can't receive message for list $list_name";
273    
274    
275  } else  {  } else  {
276          die "see perldoc $0 for help";          die "see perldoc $0 for help\n";
277  }  }
278    
279  =back  =back
# Line 279  Turn on debugging output from C<Class::D Line 292  Turn on debugging output from C<Class::D
292    
293  Dump more info on screen.  Dump more info on screen.
294    
 =item --email  
   
 Used to specify e-mail address where needed.  
   
295  =back  =back
296    
297    
Legend:
Removed from v.19  
changed lines
  Added in v.61
  ViewVC Help
Powered by ViewVC 1.1.26