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