/[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 47 by dpavlin, Tue May 24 14:02:05 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            "from=s" => \$opt->{'from'},
44            "driver=s" => \$opt->{'email_send_driver'},
45  );  );
46    
47    my $nos = new Nos(
48  my $loader = Class::DBI::Loader::Pg->new(          dsn => 'dbi:Pg:dbname=notices',
49          debug           => $debug,          user => 'dpavlin',
50          dsn             => "dbi:Pg:dbname=notices",          passwd => '',
51          user            => "dpavlin",          debug => $debug,
52          password        => "",          verbose => $verbose,
         namespace       => "Noticer",  
 #       additional_classes      => qw/Class::DBI::AbstractSearch/,  
 #       additional_base_classes => qw/My::Stuff/,  
         relationships   => 1,  
53  );  );
54    
55    my $loader = $nos->{'loader'} || die "can't find loader?";
56    
57  my $lists = $loader->find_class('lists');  my $lists = $loader->find_class('lists');
58  my $users = $loader->find_class('users');  my $users = $loader->find_class('users');
59  my $user_list = $loader->find_class('user_list');  my $user_list = $loader->find_class('user_list');
60  my $messages = $loader->find_class('messages');  my $messages = $loader->find_class('messages');
61  my $queue = $loader->find_class('queue');  my $queue = $loader->find_class('queue');
62    my $sent = $loader->find_class('sent');
63    
64  $queue->set_sql( list_queue => qq{  $queue->set_sql( list_queue => qq{
65          SELECT messages.message, messages.date AS message_date, lists.name AS list          SELECT messages.message, messages.date AS date, lists.name AS list
66          FROM queue          FROM queue
67          JOIN messages on message_id = messages.id          JOIN messages on message_id = messages.id
68          JOIN lists on list_id = lists.id          JOIN lists on list_id = lists.id
69  } );  } );
70    
71    my $list_name;
72    
73    
74    =item --new=list_name my-list@example.com
75    
76    Adds new list. You can also feed list name as first line to C<STDIN>.
77    
78    You can also add C<--from='Full name of list'> to specify full name (comment)
79    in outgoing e-mail.
80    
81    =cut
82    
83    if ($list_name = $opt->{'new'}) {
84    
85            my $email = shift @ARGV || <>;
86            chomp($email);
87    
88            die "need e-mail address for list (as argument or on STDIN)\n" unless ($email);
89    
90            my $id = $nos->new_list(
91                    list => $list_name,
92                    from => ($opt->{'from'} || ''),
93                    email => $email,
94            ) || die "can't add list $list_name\n";
95    
96            print "added list $list_name with ID $id\n";
97    
98    
99  =item --list[=list_name]  =item --list[=list_name]
100    
# Line 77  on that list. Line 105  on that list.
105    
106  =cut  =cut
107    
108  if (defined($list_opt)) {  } elsif (defined($list_name = $opt->{'list'})) {
109    
110          my @lists;          my @lists;
111          if ($list_opt ne '') {  
112                  @lists = $lists->search( name=> $list_opt )->first || die "can't find list $list_opt";          if ($list_name ne '') {
113                    @lists = $lists->search( name=> $list_name )->first || die "can't find list $list_name";
114          } else {          } else {
115                  @lists = $lists->retrieve_all;                  @lists = $lists->retrieve_all;
116          }          }
117    
118          foreach my $list (@lists) {          foreach my $list (@lists) {
119                  print $list->name,"\n";                  print $list->name," <",$list->email,">\n";
120                  foreach my $user_on_list ($user_list->search(list_id => $list->id)) {                  foreach my $u ($nos->list_members( list => $list->name )) {
121                          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";  
122                  }                  }
123          }          }
124    
125    
126  =item --add=list_name  =item --add=list_name
127    
128  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 133  argument) or read from C<STDIN>. List sh
133    
134  =cut  =cut
135    
136  } elsif ($add_opt) {  } elsif ($list_name = $opt->{'add'}) {
137          #my $noticer = $loader->find_class('Noticer') || die "can't find my class!";  
138          my $list = $lists->find_or_create({          my $list = $lists->find_or_create({
139                  name => $add_opt,                  name => $list_name,
140          }) || die "can't add list $add_opt\n";          }) || die "can't add list $list_name\n";
141    
142          my $added = 0;          my $added = 0;
143    
# Line 115  argument) or read from C<STDIN>. List sh Line 145  argument) or read from C<STDIN>. List sh
145                  chomp;                  chomp;
146                  next if (/^#/ || /^\s*$/);                  next if (/^#/ || /^\s*$/);
147                  my ($email, $name) = split(/\s+/,$_, 2);                  my ($email, $name) = split(/\s+/,$_, 2);
148                  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();  
149          }          }
150    
151          print "list ",$list->name," has $added users\n";          print "list ",$list->name," has $added users\n";
152    
153    
154  =item --queue[=list_name]  =item --queue[=list_name]
155    
156  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
157  argument) or read from C<STDIN>.  argument) or read from C<STDIN>.
158    
159  This options without optional parametars it will display current queue.  This option without optional parametar will display pending queue. If you
160    add C<--verbose> flag, it will display all messages in queue.
161    
162  =cut  =cut
163    
164  } elsif (defined($queue_opt)) {  } elsif (defined($list_name = $opt->{'queue'})) {
165    
166          if ($queue_opt ne '') {          if ($list_name ne '') {
167                  # add message to list queue                  # add message to list queue
168    
                 my $this_list = $lists->search(  
                         name => $queue_opt,  
                 )->first || die "can't find list $queue_opt";  
   
169                  my $message_text;                  my $message_text;
170                  while(<>) {                  while(<>) {
171                          $message_text .= $_;                          $message_text .= $_;
172                  }                  }
173    
174                  die "no message" unless ($message_text);                  my $id = $nos->add_message_to_list(
175                            list => $list_name,
176                            message => $message_text,
177                    ) || die "can't add message to list $list_name\n";
178    
179                  my $this_message = $messages->find_or_create({                  print "added message $id to list $list_name\n";
                         message => $message_text  
                 }) || die "can't insert message";  
180    
181                  $this_message->dbi_commit() || die "can't add message";          } else {
182                    # list messages in queue        
183    
184                  $queue->find_or_create({                  foreach my $m ($queue->retrieve_all) {
185                          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;  
186    
187                  $queue->dbi_commit || die "can't add message to list ",$this_list->name;                          my $l = $m->all_sent ? 'S' : 'Q';
188    
189                  print "added message ",$this_message->id, " to list ",$this_list->name,"\n";                          my $date = $m->message_id->date;
190                            $date =~ s/\..+$//;
191                            my $msg = $m->message_id->message;
192                            $msg =~ s/\s+/ /gs;
193    
194          } else {                          $l .= sprintf(" %-15s %15s : ", $m->list_id->name, $date);
195                  # list messages in queue                                  $l .= substr($msg, 0, 79 - length($l));
196    
                 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;  
197                          print "$l\n";                          print "$l\n";
198                  }                  }
199    
200          }          }
201    
202    
203  =item --send[=list_name]  =item --send[=list_name]
204    
205  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
206  just single list.  for single list.
207    
208    Optional argument C<--driver=smtp> forces sending using SMTP server at
209    localhost (127.0.0.1).
210    
211  =cut  =cut
212    
213  } elsif (defined($send_opt)) {  } elsif (defined($list_name = $opt->{'send'})) {
214    
215            $nos->send_queued_messages($list_name, $opt->{'email_send_driver'});
216    
         die "send option not yet implemented";  
217    
218          my @q;  =item --inbox=list_name
219          if ($send_opt ne '') {  
220  #               @q => $queue->search( name => 'foo' );  Feed incomming message back into notice sender.
221          }  
222          foreach my $q (@q) {  =cut
223                    
224    } elsif ($list_name = $opt->{'inbox'}) {
225    
226            my $message;
227            while(<>) {
228                    $message .= $_;
229          }          }
230    
231            $nos->inbox_message(
232                    list => $list_name,
233                    message => $message,
234            ) || die "can't receive message for list $list_name";
235    
236    
237  } else  {  } else  {
238          die "see perldoc $0 for help";          die "see perldoc $0 for help\n";
239  }  }
240    
241  =back  =back
242    
243    
244    
245    =head2 Helper options
246    
247    =over 20
248    
249    =item --debug
250    
251    Turn on debugging output from C<Class::DBI>
252    
253    =item --verbose
254    
255    Dump more info on screen.
256    
257    =back
258    
259    
260    
261  =head1 AUTHOR  =head1 AUTHOR
262    
263  Dobrica Pavlinusic <dpavlin@rot13.org>  Dobrica Pavlinusic <dpavlin@rot13.org>

Legend:
Removed from v.14  
changed lines
  Added in v.47

  ViewVC Help
Powered by ViewVC 1.1.26