/[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 11 by dpavlin, Sat May 14 18:20:50 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 13  sender.pl - command line notify sender u Line 13  sender.pl - command line notify sender u
13    
14   sender.pl --add=mylist members.txt   sender.pl --add=mylist members.txt
15   sender.pl --list[=mylist]   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: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,
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{
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    
74  =item --list[=list_name]  =item --list[=list_name]
75    
76  List all available lists and users on them. Optional value is name of list  List all available lists and users on them.
77  and it will produce users just on that list.  
78    Optional value is name of list. With it, this option will produce just users
79    on that list.
80    
81  =cut  =cut
82    
# Line 71  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 86  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          my $this_message = $messages->find_or_create({  Send e-mails waiting in queue, or with optional argument, just send messages
185                  message => $message_text  for single list.
186          }) || die "can't insert message";  
187    =cut
188    
189          $this_message->dbi_commit();  } elsif (defined($send_opt)) {
190    
191          $queue->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 "see perldoc $0 for help";          die "see perldoc $0 for help";
# Line 157  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.11  
changed lines
  Added in v.29
  ViewVC Help
Powered by ViewVC 1.1.26