/[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 29 by dpavlin, Mon May 16 20:58:44 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 18  sender.pl - command line notify sender u Line 16  sender.pl - command line notify sender u
16   sender.pl --queue[=mylist message.txt]   sender.pl --queue[=mylist message.txt]
17   sender.pl --send=mylist   sender.pl --send=mylist
18    
19  =head2 All options  In C</etc/aliases> something like:
20    
21  =over 20   mylist: "| /path/to/sender.pl --inbox=mylist"
22    
23  =item --debug  =head2 Command options
24    
25  Turn on debugging output from C<Class::DBI>  =over 20
26    
27  =cut  =cut
28    
29  my $debug = 0;  my $debug = 0;
30    my $verbose = 0;
31  my $list_opt;  my $list_opt;
32  my $add_opt;  my $add_opt;
33  my $queue_opt;  my $queue_opt;
34  my $send_opt;  my $send_opt;
35    my $email_opt;
36    my $inbox_opt;
37    
38  my $result = GetOptions(  my $result = GetOptions(
39          "list:s" => \$list_opt,          "list:s" => \$list_opt,
40          "add=s" => \$add_opt,          "add=s" => \$add_opt,
41          "queue:s" => \$queue_opt,          "queue:s" => \$queue_opt,
42          "send:s" => \$send_opt,          "send:s" => \$send_opt,
43            "inbox=s" => \$inbox_opt,
44          "debug" => \$debug,          "debug" => \$debug,
45            "verbose" => \$verbose,
46            "email=s" => \$email_opt,
47  );  );
48    
49    my $nos = new Nos(
50  my $loader = Class::DBI::Loader::Pg->new(          dsn => 'dbi:Pg:dbname=notices',
51          debug           => $debug,          user => 'dpavlin',
52          dsn             => "dbi:Pg:dbname=notices",          passwd => '',
53          user            => "dpavlin",          debug => $debug,
54          password        => "",          verbose => $verbose,
         namespace       => "Noticer",  
 #       additional_classes      => qw/Class::DBI::AbstractSearch/,  
 #       additional_base_classes => qw/My::Stuff/,  
         relationships   => 1,  
55  );  );
56    
57    my $loader = $nos->{'loader'} || die "can't find loader?";
58    
59  my $lists = $loader->find_class('lists');  my $lists = $loader->find_class('lists');
60  my $users = $loader->find_class('users');  my $users = $loader->find_class('users');
61  my $user_list = $loader->find_class('user_list');  my $user_list = $loader->find_class('user_list');
62  my $messages = $loader->find_class('messages');  my $messages = $loader->find_class('messages');
63  my $queue = $loader->find_class('queue');  my $queue = $loader->find_class('queue');
64    my $sent = $loader->find_class('sent');
65    
66  $queue->set_sql( list_queue => qq{  $queue->set_sql( list_queue => qq{
67          SELECT messages.message, messages.date AS message_date, lists.name AS list          SELECT messages.message, messages.date AS date, lists.name AS list
68          FROM queue          FROM queue
69          JOIN messages on message_id = messages.id          JOIN messages on message_id = messages.id
70          JOIN lists on list_id = lists.id          JOIN lists on list_id = lists.id
# Line 86  if (defined($list_opt)) { Line 89  if (defined($list_opt)) {
89          }          }
90    
91          foreach my $list (@lists) {          foreach my $list (@lists) {
92                  print $list->name,"\n";                  print $list->name," <",$list->email,">\n";
93                  foreach my $user_on_list ($user_list->search(list_id => $list->id)) {                  foreach my $user_on_list ($user_list->search(list_id => $list->id)) {
94                          my $user = $users->retrieve( id => $user_on_list->user_id );                          my $user = $users->retrieve( id => $user_on_list->user_id );
95                          print "\t",$user->full_name," <", $user->email, ">\n";                          print "\t",$user->full_name," <", $user->email, ">\n";
# Line 101  argument) or read from C<STDIN>. List sh Line 104  argument) or read from C<STDIN>. List sh
104   email@example.com      Optional full name of person   email@example.com      Optional full name of person
105   dpavlin@rot13.org      Dobrica Pavlinusic   dpavlin@rot13.org      Dobrica Pavlinusic
106    
107    You may use C<--email> parametar at any time to set From: e-mail address for list.
108    B<This seems somewhat cludgy, and it will probably change in future>.
109    
110  =cut  =cut
111    
112  } elsif ($add_opt) {  } elsif ($add_opt) {
         #my $noticer = $loader->find_class('Noticer') || die "can't find my class!";  
113          my $list = $lists->find_or_create({          my $list = $lists->find_or_create({
114                  name => $add_opt,                  name => $add_opt,
115          }) || die "can't add list $add_opt\n";          }) || die "can't add list $add_opt\n";
116    
117            if ($email_opt && $list->email ne $email_opt) {
118                    $list->email($email_opt);
119                    $list->update;
120                    $list->dbi_commit;
121            }
122    
123          my $added = 0;          my $added = 0;
124    
125          while(<>) {          while(<>) {
126                  chomp;                  chomp;
127                  next if (/^#/ || /^\s*$/);                  next if (/^#/ || /^\s*$/);
128                  my ($email, $name) = split(/\s+/,$_, 2);                  my ($email, $name) = split(/\s+/,$_, 2);
129                  if (! Email::Valid->address($email)) {                  $added++ if ($nos->add_member_to_list( email => $email, name => $name, list => $add_opt ));
                         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();  
130          }          }
131    
132          print "list ",$list->name," has $added users\n";          print "list ",$list->name," has $added users\n";
# Line 143  argument) or read from C<STDIN>. List sh Line 136  argument) or read from C<STDIN>. List sh
136  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
137  argument) or read from C<STDIN>.  argument) or read from C<STDIN>.
138    
139  This options without optional parametars it will display current queue.  This option without optional parametar will display pending queue. If you
140    add C<--verbose> flag, it will display all messages in queue.
141    
142  =cut  =cut
143    
# Line 152  This options without optional parametars Line 146  This options without optional parametars
146          if ($queue_opt ne '') {          if ($queue_opt ne '') {
147                  # add message to list queue                  # add message to list queue
148    
                 my $this_list = $lists->search(  
                         name => $queue_opt,  
                 )->first || die "can't find list $queue_opt";  
   
149                  my $message_text;                  my $message_text;
150                  while(<>) {                  while(<>) {
151                          $message_text .= $_;                          $message_text .= $_;
152                  }                  }
153    
154                  die "no message" unless ($message_text);                  my $id = $nos->add_message_to_list(
155                            list => $queue_opt,
156                            message => $message_text,
157                    );
158    
159                  my $this_message = $messages->find_or_create({                  print "added message $id to list $queue_opt\n";
                         message => $message_text  
                 }) || die "can't insert message";  
160    
161                  $this_message->dbi_commit() || die "can't add message";          } else {
162                    # list messages in queue        
163    
164                  $queue->find_or_create({                  foreach my $m ($queue->retrieve_all) {
165                          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;  
166    
167                  $queue->dbi_commit || die "can't add message to list ",$this_list->name;                          my $l = $m->all_sent ? 'S' : 'Q';
168    
169                  print "added message ",$this_message->id, " to list ",$this_list->name,"\n";                          my $date = $m->message_id->date;
170                            $date =~ s/\..+$//;
171                            my $msg = $m->message_id->message;
172                            $msg =~ s/\s+/ /gs;
173    
174          } else {                          $l .= sprintf(" %-10s %15s : ", $m->list_id->name, $date);
175                  # list messages in queue                                  $l .= substr($msg, 0, 79 - length($l));
176    
                 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;  
177                          print "$l\n";                          print "$l\n";
178                  }                  }
179    
# Line 192  This options without optional parametars Line 181  This options without optional parametars
181    
182  =item --send[=list_name]  =item --send[=list_name]
183    
184  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
185  just single list.  for single list.
186    
187  =cut  =cut
188    
189  } elsif (defined($send_opt)) {  } elsif (defined($send_opt)) {
190    
191            $nos->send_queued_messages($send_opt);
192    
193          die "send option not yet implemented";  =item --inbox=list_name
194    
195          my @q;  Feed incomming message back into notice sender.
196          if ($send_opt ne '') {  
197  #               @q => $queue->search( name => 'foo' );  =cut
198          }  
199          foreach my $q (@q) {  } elsif ($inbox_opt) {
200                    
201          }          warn "inbox option is not implemented";
202    
203  } else  {  } else  {
204          die "see perldoc $0 for help";          die "see perldoc $0 for help";
# Line 216  just single list. Line 206  just single list.
206    
207  =back  =back
208    
209    
210    
211    =head2 Helper options
212    
213    =over 20
214    
215    =item --debug
216    
217    Turn on debugging output from C<Class::DBI>
218    
219    =item --verbose
220    
221    Dump more info on screen.
222    
223    =item --email
224    
225    Used to specify e-mail address where needed.
226    
227    =back
228    
229    
230    
231  =head1 AUTHOR  =head1 AUTHOR
232    
233  Dobrica Pavlinusic <dpavlin@rot13.org>  Dobrica Pavlinusic <dpavlin@rot13.org>
Legend:
Removed from v.14  
changed lines
  Added in v.29
  ViewVC Help
Powered by ViewVC 1.1.26