/[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 38 by dpavlin, Tue May 17 21:37:06 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  );  );
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');
58  my $messages = $loader->find_class('messages');  my $messages = $loader->find_class('messages');
59  my $queue = $loader->find_class('queue');  my $queue = $loader->find_class('queue');
60    my $sent = $loader->find_class('sent');
61    
62  $queue->set_sql( list_queue => qq{  $queue->set_sql( list_queue => qq{
63          SELECT messages.message, messages.date AS message_date, lists.name AS list          SELECT messages.message, messages.date AS date, lists.name AS list
64          FROM queue          FROM queue
65          JOIN messages on message_id = messages.id          JOIN messages on message_id = messages.id
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,"\n";                  print $list->name," <",$list->email,">\n";
114                  foreach my $user_on_list ($user_list->search(list_id => $list->id)) {                  foreach my $user_on_list ($user_list->search(list_id => $list->id)) {
115                          my $user = $users->retrieve( id => $user_on_list->user_id );                          my $user = $users->retrieve( id => $user_on_list->user_id );
116                          print "\t",$user->full_name," <", $user->email, ">\n";                          print "\t",$user->full_name," <", $user->email, ">\n";
117                  }                  }
118          }          }
119    
120    
121  =item --add=list_name  =item --add=list_name
122    
123  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 103  argument) or read from C<STDIN>. List sh Line 128  argument) or read from C<STDIN>. List sh
128    
129  =cut  =cut
130    
131  } elsif ($add_opt) {  } elsif ($list_name = $opt->{'add'}) {
132          #my $noticer = $loader->find_class('Noticer') || die "can't find my class!";  
133          my $list = $lists->find_or_create({          my $list = $lists->find_or_create({
134                  name => $add_opt,                  name => $list_name,
135          }) || die "can't add list $add_opt\n";          }) || die "can't add list $list_name\n";
136    
137          my $added = 0;          my $added = 0;
138    
# Line 115  argument) or read from C<STDIN>. List sh Line 140  argument) or read from C<STDIN>. List sh
140                  chomp;                  chomp;
141                  next if (/^#/ || /^\s*$/);                  next if (/^#/ || /^\s*$/);
142                  my ($email, $name) = split(/\s+/,$_, 2);                  my ($email, $name) = split(/\s+/,$_, 2);
143                  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();  
144          }          }
145    
146          print "list ",$list->name," has $added users\n";          print "list ",$list->name," has $added users\n";
147    
148    
149  =item --queue[=list_name]  =item --queue[=list_name]
150    
151  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
152  argument) or read from C<STDIN>.  argument) or read from C<STDIN>.
153    
154  This options without optional parametars it will display current queue.  This option without optional parametar will display pending queue. If you
155    add C<--verbose> flag, it will display all messages in queue.
156    
157  =cut  =cut
158    
159  } elsif (defined($queue_opt)) {  } elsif (defined($list_name = $opt->{'queue'})) {
160    
161          if ($queue_opt ne '') {          if ($list_name ne '') {
162                  # add message to list queue                  # add message to list queue
163    
                 my $this_list = $lists->search(  
                         name => $queue_opt,  
                 )->first || die "can't find list $queue_opt";  
   
164                  my $message_text;                  my $message_text;
165                  while(<>) {                  while(<>) {
166                          $message_text .= $_;                          $message_text .= $_;
167                  }                  }
168    
169                  die "no message" unless ($message_text);                  my $id = $nos->add_message_to_list(
170                            list => $list_name,
171                            message => $message_text,
172                    ) || die "can't add message to list $list_name\n";
173    
174                  my $this_message = $messages->find_or_create({                  print "added message $id to list $list_name\n";
                         message => $message_text  
                 }) || die "can't insert message";  
175    
176                  $this_message->dbi_commit() || die "can't add message";          } else {
177                    # list messages in queue        
178    
179                  $queue->find_or_create({                  foreach my $m ($queue->retrieve_all) {
180                          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;  
181    
182                  $queue->dbi_commit || die "can't add message to list ",$this_list->name;                          my $l = $m->all_sent ? 'S' : 'Q';
183    
184                  print "added message ",$this_message->id, " to list ",$this_list->name,"\n";                          my $date = $m->message_id->date;
185                            $date =~ s/\..+$//;
186                            my $msg = $m->message_id->message;
187                            $msg =~ s/\s+/ /gs;
188    
189          } else {                          $l .= sprintf(" %-15s %15s : ", $m->list_id->name, $date);
190                  # list messages in queue                                  $l .= substr($msg, 0, 79 - length($l));
191    
                 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;  
192                          print "$l\n";                          print "$l\n";
193                  }                  }
194    
195          }          }
196    
197    
198  =item --send[=list_name]  =item --send[=list_name]
199    
200  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
201  just single list.  for single list.
202    
203  =cut  =cut
204    
205  } elsif (defined($send_opt)) {  } elsif (defined($list_name = $opt->{'send'})) {
206    
207            $nos->send_queued_messages($list_name);
208    
         die "send option not yet implemented";  
209    
210          my @q;  =item --inbox=list_name
211          if ($send_opt ne '') {  
212  #               @q => $queue->search( name => 'foo' );  Feed incomming message back into notice sender.
213          }  
214          foreach my $q (@q) {  =cut
215                    
216    } elsif ($list_name = $opt->{'inbox'}) {
217    
218            my $message;
219            while(<>) {
220                    $message .= $_;
221          }          }
222    
223            $nos->inbox_message(
224                    list => $list_name,
225                    message => $message,
226            ) || die "can't receive message for list $list_name";
227    
228    
229  } else  {  } else  {
230          die "see perldoc $0 for help";          die "see perldoc $0 for help\n";
231  }  }
232    
233  =back  =back
234    
235    
236    
237    =head2 Helper options
238    
239    =over 20
240    
241    =item --debug
242    
243    Turn on debugging output from C<Class::DBI>
244    
245    =item --verbose
246    
247    Dump more info on screen.
248    
249    =back
250    
251    
252    
253  =head1 AUTHOR  =head1 AUTHOR
254    
255  Dobrica Pavlinusic <dpavlin@rot13.org>  Dobrica Pavlinusic <dpavlin@rot13.org>
Legend:
Removed from v.14  
changed lines
  Added in v.38
  ViewVC Help
Powered by ViewVC 1.1.26