/[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 18 by dpavlin, Sun May 15 17:01:19 2005 UTC revision 45 by dpavlin, Wed May 18 13:12: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 --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    In C</etc/aliases> something like:
21    
22     mylist: "| /path/to/sender.pl --inbox=mylist"
23    
24  =head2 Command options  =head2 Command options
25    
26  =over 20  =over 20
# Line 25  sender.pl - command line notify sender u Line 29  sender.pl - command line notify sender u
29    
30  my $debug = 0;  my $debug = 0;
31  my $verbose = 0;  my $verbose = 0;
32  my $list_opt;  my $opt;
 my $add_opt;  
 my $queue_opt;  
 my $send_opt;  
 my $email_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,          "verbose" => \$verbose,
         "email=s" => \$email_opt,  
43  );  );
44    
45    my $nos = new Nos(
46  my $loader = Class::DBI::Loader::Pg->new(          dsn => 'dbi:Pg:dbname=notices',
47          debug           => $debug,          user => 'dpavlin',
48          dsn             => "dbi:Pg:dbname=notices",          passwd => '',
49          user            => "dpavlin",          debug => $debug,
50          password        => "",          verbose => $verbose,
         namespace       => "Noticer",  
 #       additional_classes      => qw/Class::DBI::AbstractSearch/,  
 #       additional_base_classes => qw/My::Stuff/,  
         relationships   => 1,  
51  );  );
52    
53    my $loader = $nos->{'loader'} || die "can't find loader?";
54    
55  my $lists = $loader->find_class('lists');  my $lists = $loader->find_class('lists');
56  my $users = $loader->find_class('users');  my $users = $loader->find_class('users');
57  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 66  $queue->set_sql( list_queue => qq{
66          JOIN lists on list_id = lists.id          JOIN lists on list_id = lists.id
67  } );  } );
68    
69    my $list_name;
70    
71    
72    =item --new=list_name my-list@example.com
73    
74    Adds new list. You can also feed list name as first line to C<STDIN>.
75    
76    =cut
77    
78    if ($list_name = $opt->{'new'}) {
79    
80            my $email = shift @ARGV || <>;
81            chomp($email);
82    
83            die "need e-mail address for list (as argument or on STDIN)\n" unless ($email);
84    
85            my $id = $nos->new_list(
86                    list => $list_name,
87                    email => $email,
88            ) || die "can't add list $list_name\n";
89    
90            print "added list $list_name with ID $id\n";
91    
92    
93  =item --list[=list_name]  =item --list[=list_name]
94    
# Line 77  on that list. Line 99  on that list.
99    
100  =cut  =cut
101    
102  if (defined($list_opt)) {  } elsif (defined($list_name = $opt->{'list'})) {
103    
104          my @lists;          my @lists;
105          if ($list_opt ne '') {  
106                  @lists = $lists->search( name=> $list_opt )->first || die "can't find list $list_opt";          if ($list_name ne '') {
107                    @lists = $lists->search( name=> $list_name )->first || die "can't find list $list_name";
108          } else {          } else {
109                  @lists = $lists->retrieve_all;                  @lists = $lists->retrieve_all;
110          }          }
111    
112          foreach my $list (@lists) {          foreach my $list (@lists) {
113                  print $list->name," <",$list->email,">\n";                  print $list->name," <",$list->email,">\n";
114                  foreach my $user_on_list ($user_list->search(list_id => $list->id)) {                  foreach my $u ($nos->list_members( list => $list->name )) {
115                          my $user = $users->retrieve( id => $user_on_list->user_id );                          print "\t",$u->{'name'}, " <", $u->{'email'}, ">\n";
                         print "\t",$user->full_name," <", $user->email, ">\n";  
116                  }                  }
117          }          }
118    
119    
120  =item --add=list_name  =item --add=list_name
121    
122  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 125  argument) or read from C<STDIN>. List sh
125   email@example.com      Optional full name of person   email@example.com      Optional full name of person
126   dpavlin@rot13.org      Dobrica Pavlinusic   dpavlin@rot13.org      Dobrica Pavlinusic
127    
 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>.  
   
128  =cut  =cut
129    
130  } elsif ($add_opt) {  } elsif ($list_name = $opt->{'add'}) {
131          #my $noticer = $loader->find_class('Noticer') || die "can't find my class!";  
132          my $list = $lists->find_or_create({          my $list = $lists->find_or_create({
133                  name => $add_opt,                  name => $list_name,
134          }) || die "can't add list $add_opt\n";          }) || die "can't add list $list_name\n";
         if ($email_opt && $list->email ne $email_opt) {  
                 $list->email($email_opt);  
                 $list->update;  
                 $list->dbi_commit;  
         }  
135    
136          my $added = 0;          my $added = 0;
137    
# Line 123  B<This seems somewhat cludgy, and it wil Line 139  B<This seems somewhat cludgy, and it wil
139                  chomp;                  chomp;
140                  next if (/^#/ || /^\s*$/);                  next if (/^#/ || /^\s*$/);
141                  my ($email, $name) = split(/\s+/,$_, 2);                  my ($email, $name) = split(/\s+/,$_, 2);
142                  $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++;  
         }  
   
         foreach my $c_name ($loader->tables) {  
                 my $c = $loader->find_class($c_name)|| die "can't find $c_name";  
                 $c->dbi_commit();  
143          }          }
144    
145          print "list ",$list->name," has $added users\n";          print "list ",$list->name," has $added users\n";
146    
147    
148  =item --queue[=list_name]  =item --queue[=list_name]
149    
150  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
# Line 157  add C<--verbose> flag, it will display a Line 155  add C<--verbose> flag, it will display a
155    
156  =cut  =cut
157    
158  } elsif (defined($queue_opt)) {  } elsif (defined($list_name = $opt->{'queue'})) {
159    
160          if ($queue_opt ne '') {          if ($list_name ne '') {
161                  # add message to list queue                  # add message to list queue
162    
                 my $this_list = $lists->search(  
                         name => $queue_opt,  
                 )->first || die "can't find list $queue_opt";  
   
163                  my $message_text;                  my $message_text;
164                  while(<>) {                  while(<>) {
165                          $message_text .= $_;                          $message_text .= $_;
166                  }                  }
167    
168                  die "no message" unless ($message_text);                  my $id = $nos->add_message_to_list(
169                            list => $list_name,
170                  my $this_message = $messages->find_or_create({                          message => $message_text,
171                          message => $message_text                  ) || die "can't add message to list $list_name\n";
                 }) || die "can't insert message";  
172    
173                  $this_message->dbi_commit() || die "can't add message";                  print "added message $id to list $list_name\n";
   
                 $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;  
   
                 print "added message ",$this_message->id, " to list ",$this_list->name,"\n";  
174    
175          } else {          } else {
176                  # list messages in queue                          # list messages in queue        
# Line 201  add C<--verbose> flag, it will display a Line 185  add C<--verbose> flag, it will display a
185                          my $msg = $m->message_id->message;                          my $msg = $m->message_id->message;
186                          $msg =~ s/\s+/ /gs;                          $msg =~ s/\s+/ /gs;
187    
188                          $l .= sprintf(" %-10s %15s : ", $m->list_id->name, $date);                          $l .= sprintf(" %-15s %15s : ", $m->list_id->name, $date);
189                          $l .= substr($msg, 0, 79 - length($l));                          $l .= substr($msg, 0, 79 - length($l));
190    
191                          print "$l\n";                          print "$l\n";
# Line 209  add C<--verbose> flag, it will display a Line 193  add C<--verbose> flag, it will display a
193    
194          }          }
195    
196    
197  =item --send[=list_name]  =item --send[=list_name]
198    
199  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
# Line 216  for single list. Line 201  for single list.
201    
202  =cut  =cut
203    
204  } elsif (defined($send_opt)) {  } elsif (defined($list_name = $opt->{'send'})) {
205    
206          my $my_q;          $nos->send_queued_messages($list_name);
         if ($send_opt ne '') {  
                 my $l_id = $lists->search_like( name => $send_opt )->first ||  
                         die "can't find list $send_opt";  
                 $my_q = $queue->search_like( list_id => $l_id ) ||  
                         die "can't find list $send_opt";  
         } else {  
                 $my_q = $queue->retrieve_all;  
         }  
207    
         while (my $m = $my_q->next) {  
                 next if ($m->all_sent);  
208    
209                  print "sending message ",$m->message_id," enqueued on ",$m->date," to list ",$m->list_id->name,"\n";  =item --inbox=list_name
                 my $msg = $m->message_id->message;  
210    
211                  foreach my $u ($user_list->search(list_id => $m->list_id)) {  Feed incomming message back into notice sender.
212    
213                          my $hdr = "To: ".$u->user_id->full_name." <". $u->user_id->email. ">\n";  =cut
214    
215                          if ($sent->search( message_id => $m->message_id, user_id => $u->user_id )) {  } elsif ($list_name = $opt->{'inbox'}) {
216                                  print "SKIP ",$u->user_id->email," message allready sent\n";  
217                          } else {          my $message;
218                                  print "\t",$u->user_id->email,"\n";          while(<>) {
219                    $message .= $_;
                                 # FIXME do real sending :-)  
                                 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;  
220          }          }
221    
222            $nos->inbox_message(
223                    list => $list_name,
224                    message => $message,
225            ) || die "can't receive message for list $list_name";
226    
227    
228  } else  {  } else  {
229          die "see perldoc $0 for help";          die "see perldoc $0 for help\n";
230  }  }
231    
232  =back  =back
# Line 278  Turn on debugging output from C<Class::D Line 245  Turn on debugging output from C<Class::D
245    
246  Dump more info on screen.  Dump more info on screen.
247    
 =item --email  
   
 Used to specify e-mail address where needed.  
   
248  =back  =back
249    
250    
Legend:
Removed from v.18  
changed lines
  Added in v.45
  ViewVC Help
Powered by ViewVC 1.1.26