/[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 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 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 $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 103  argument) or read from C<STDIN>. List sh Line 127  argument) or read from C<STDIN>. List sh
127    
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";
135    
136          my $added = 0;          my $added = 0;
137    
# Line 115  argument) or read from C<STDIN>. List sh Line 139  argument) or read from C<STDIN>. List sh
139                  chomp;                  chomp;
140                  next if (/^#/ || /^\s*$/);                  next if (/^#/ || /^\s*$/);
141                  my ($email, $name) = split(/\s+/,$_, 2);                  my ($email, $name) = split(/\s+/,$_, 2);
142                  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();  
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
151  argument) or read from C<STDIN>.  argument) or read from C<STDIN>.
152    
153  This options without optional parametars it will display current queue.  This option without optional parametar will display pending queue. If you
154    add C<--verbose> flag, it will display all messages in queue.
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                            message => $message_text,
171                    ) || die "can't add message to list $list_name\n";
172    
173                  my $this_message = $messages->find_or_create({                  print "added message $id to list $list_name\n";
                         message => $message_text  
                 }) || die "can't insert message";  
174    
175                  $this_message->dbi_commit() || die "can't add message";          } else {
176                    # list messages in queue        
177    
178                  $queue->find_or_create({                  foreach my $m ($queue->retrieve_all) {
179                          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;  
180    
181                  $queue->dbi_commit || die "can't add message to list ",$this_list->name;                          my $l = $m->all_sent ? 'S' : 'Q';
182    
183                  print "added message ",$this_message->id, " to list ",$this_list->name,"\n";                          my $date = $m->message_id->date;
184                            $date =~ s/\..+$//;
185                            my $msg = $m->message_id->message;
186                            $msg =~ s/\s+/ /gs;
187    
188          } else {                          $l .= sprintf(" %-15s %15s : ", $m->list_id->name, $date);
189                  # list messages in queue                                  $l .= substr($msg, 0, 79 - length($l));
190    
                 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;  
191                          print "$l\n";                          print "$l\n";
192                  }                  }
193    
194          }          }
195    
196    
197  =item --send[=list_name]  =item --send[=list_name]
198    
199  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
200  just single list.  for single list.
201    
202  =cut  =cut
203    
204  } elsif (defined($send_opt)) {  } elsif (defined($list_name = $opt->{'send'})) {
205    
206            $nos->send_queued_messages($list_name);
207    
         die "send option not yet implemented";  
208    
209          my @q;  =item --inbox=list_name
210          if ($send_opt ne '') {  
211  #               @q => $queue->search( name => 'foo' );  Feed incomming message back into notice sender.
212          }  
213          foreach my $q (@q) {  =cut
214                    
215    } elsif ($list_name = $opt->{'inbox'}) {
216    
217            my $message;
218            while(<>) {
219                    $message .= $_;
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
233    
234    
235    
236    =head2 Helper options
237    
238    =over 20
239    
240    =item --debug
241    
242    Turn on debugging output from C<Class::DBI>
243    
244    =item --verbose
245    
246    Dump more info on screen.
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.45
  ViewVC Help
Powered by ViewVC 1.1.26