/[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 8 by dpavlin, Sat May 14 13:12:00 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    
# Line 12  sender.pl - command line notify sender u Line 12  sender.pl - command line notify sender u
12  =head1 SYNOPSYS  =head1 SYNOPSYS
13    
14   sender.pl --add=mylist members.txt   sender.pl --add=mylist members.txt
15   sender.pl --list   sender.pl --list[=mylist]
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 ($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    
 =item --list  
73    
74  List all available lists and users on them  =item --list[=list_name]
75    
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  =cut
82    
83  if ($list_opt) {  if (defined($list_opt)) {
84          foreach my $list ($lists->retrieve_all) {          my @lists;
85                  print $list->name,"\n";          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";
# Line 78  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                  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  =item --queue=list_name  =item --queue[=list_name]
135    
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 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    
144  } elsif ($queue_opt) {  } elsif (defined($queue_opt)) {
145          my $this_list = $lists->search(  
146                  name => $queue_opt,          if ($queue_opt ne '') {
147          )->first || die "can't find list $queue_opt";                  # 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    =cut
188    
189    } elsif (defined($send_opt)) {
190    
191          my $this_message = $messages->find_or_create({          $nos->send_queued_messages($send_opt);
                 message => $message_text  
         }) || die "can't insert message";  
192    
193          $this_message->dbi_commit();  =item --inbox=list_name
194    
195          $message_list->find_or_create({  Feed incomming message back into notice sender.
                 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;  
196    
197          print "added message ",$this_message->id, " to list ",$this_list->name,"\n";  =cut
198    
199    } 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 149  argument) or read from C<STDIN>. Line 206  argument) or read from C<STDIN>.
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.8  
changed lines
  Added in v.29
  ViewVC Help
Powered by ViewVC 1.1.26