/[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 6 by dpavlin, Sat May 14 12:31:27 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 Data::Dumper;  
7    
8  =head1 NAME  =head1 NAME
9    
10  sender.pl - command line notify sender utility  sender.pl - command line notify sender utility
11    
12    =head1 SYNOPSYS
13    
14     sender.pl --add=mylist members.txt
15     sender.pl --list[=mylist]
16     sender.pl --queue[=mylist message.txt]
17     sender.pl --send=mylist
18    
19    In C</etc/aliases> something like:
20    
21     mylist: "| /path/to/sender.pl --inbox=mylist"
22    
23    =head2 Command options
24    
25    =over 20
26    
27  =cut  =cut
28    
29  my ($list_opt,$debug) = (0,0);  my $debug = 0;
30    my $verbose = 0;
31    my $list_opt;
32  my $add_opt;  my $add_opt;
33  my $queue_opt;  my $queue_opt;
34    my $send_opt;
35    my $email_opt;
36    my $inbox_opt;
37    
38  my $result = GetOptions(  my $result = GetOptions(
39          "list"  => \$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,
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 $message_list = $loader->find_class('message_list');  my $queue = $loader->find_class('queue');
64    my $sent = $loader->find_class('sent');
65    
66    $queue->set_sql( list_queue => qq{
67            SELECT messages.message, messages.date AS date, lists.name AS list
68            FROM queue
69            JOIN messages on message_id = messages.id
70            JOIN lists on list_id = lists.id
71    } );
72    
73  if ($list_opt) {  
74          foreach my $list ($lists->retrieve_all) {  =item --list[=list_name]
75                  print $list->name,"\n";  
76    List all available lists and users on them.
77    
78    Optional value is name of list. With it, this option will produce just users
79    on that list.
80    
81    =cut
82    
83    if (defined($list_opt)) {
84            my @lists;
85            if ($list_opt ne '') {
86                    @lists = $lists->search( name=> $list_opt )->first || die "can't find list $list_opt";
87            } else {
88                    @lists = $lists->retrieve_all;
89            }
90    
91            foreach my $list (@lists) {
92                    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";
96                  }                  }
97          }          }
98    
99    =item --add=list_name
100    
101    Add users to list. Users are stored in file (which can be supplied as
102    argument) or read from C<STDIN>. List should be in following format:
103    
104     email@example.com      Optional full name of person
105     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
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                  print "# $name <$email>\n";                  $added++ if ($nos->add_member_to_list( email => $email, name => $name, list => $add_opt ));
                 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";
133    
134  } elsif ($queue_opt) {  =item --queue[=list_name]
135          my $this_list = $lists->search(  
136                  name => $queue_opt,  Queue message for later delivery. Message can be read from file (specified as
137          )->first || die "can't find list $queue_opt";  argument) or read from C<STDIN>.
138    
139    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
143    
144    } elsif (defined($queue_opt)) {
145    
146            if ($queue_opt ne '') {
147                    # add message to list queue
148    
149                    my $message_text;
150                    while(<>) {
151                            $message_text .= $_;
152                    }
153    
154                    my $id = $nos->add_message_to_list(
155                            list => $queue_opt,
156                            message => $message_text,
157                    );
158    
159                    print "added message $id to list $queue_opt\n";
160    
161            } else {
162                    # list messages in queue        
163    
164                    foreach my $m ($queue->retrieve_all) {
165                            next if ($m->all_sent && ! $verbose);
166    
167                            my $l = $m->all_sent ? 'S' : 'Q';
168    
169                            my $date = $m->message_id->date;
170                            $date =~ s/\..+$//;
171                            my $msg = $m->message_id->message;
172                            $msg =~ s/\s+/ /gs;
173    
174                            $l .= sprintf(" %-10s %15s : ", $m->list_id->name, $date);
175                            $l .= substr($msg, 0, 79 - length($l));
176    
177                            print "$l\n";
178                    }
179    
         my $message_text;  
         while(<>) {  
                 $message_text .= $_;  
180          }          }
181    
182          die "no message" unless ($message_text);  =item --send[=list_name]
183    
184    Send e-mails waiting in queue, or with optional argument, just send messages
185    for single list.
186    
187          my $this_message = $messages->find_or_create({  =cut
                 message => $message_text  
         }) || die "can't insert message";  
188    
189          $this_message->dbi_commit();  } elsif (defined($send_opt)) {
190    
191          $message_list->find_or_create({          $nos->send_queued_messages($send_opt);
                 message_id => $this_message->id,  
                 list_id => $this_list->id,  
         }) || die "can't add message ",$this_message->id," to list ",$this_list->id, ": ",$this_list->name;  
192    
193          print "added message ",$this_message->id, " to list ",$this_list->name,"\n";  =item --inbox=list_name
194    
195    Feed incomming message back into notice sender.
196    
197    =cut
198    
199    } elsif ($inbox_opt) {
200    
201            warn "inbox option is not implemented";
202    
203  } else  {  } else  {
204          die $0.'          die "see perldoc $0 for help";
         --list                          show all lists and users  
         --add=name_of_list < users.txt  add users (email@example.com full name)  
         --queue=name_of_list < message  queue message for sending to list  
         --debug  
 ';  
205  }  }
206    
207    =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
232    
233    Dobrica Pavlinusic <dpavlin@rot13.org>
234    
235    =cut
236    
Legend:
Removed from v.6  
changed lines
  Added in v.29
  ViewVC Help
Powered by ViewVC 1.1.26