/[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

Annotation of /trunk/sender.pl

Parent Directory Parent Directory | Revision Log Revision Log


Revision 21 - (hide annotations)
Sun May 15 21:35:15 2005 UTC (18 years, 10 months ago) by dpavlin
File MIME type: text/plain
File size: 6426 byte(s)
more cleanup and restructuring

1 dpavlin 1 #!/usr/bin/perl -w
2    
3     use strict;
4 dpavlin 20 use blib;
5     use Nos;
6 dpavlin 1 use Getopt::Long;
7    
8 dpavlin 6 =head1 NAME
9    
10     sender.pl - command line notify sender utility
11    
12 dpavlin 8 =head1 SYNOPSYS
13    
14     sender.pl --add=mylist members.txt
15 dpavlin 9 sender.pl --list[=mylist]
16 dpavlin 14 sender.pl --queue[=mylist message.txt]
17 dpavlin 8 sender.pl --send=mylist
18    
19 dpavlin 15 =head2 Command options
20 dpavlin 8
21     =over 20
22    
23 dpavlin 6 =cut
24    
25 dpavlin 12 my $debug = 0;
26 dpavlin 15 my $verbose = 0;
27 dpavlin 12 my $list_opt;
28 dpavlin 2 my $add_opt;
29 dpavlin 6 my $queue_opt;
30 dpavlin 14 my $send_opt;
31 dpavlin 18 my $email_opt;
32 dpavlin 1
33     my $result = GetOptions(
34 dpavlin 9 "list:s" => \$list_opt,
35 dpavlin 2 "add=s" => \$add_opt,
36 dpavlin 14 "queue:s" => \$queue_opt,
37     "send:s" => \$send_opt,
38 dpavlin 1 "debug" => \$debug,
39 dpavlin 15 "verbose" => \$verbose,
40 dpavlin 18 "email=s" => \$email_opt,
41 dpavlin 1 );
42    
43 dpavlin 20 my $nos = new Nos(
44     dsn => 'dbi:Pg:dbname=notices',
45     user => 'dpavlin',
46     passwd => '',
47     debug => $debug,
48     verbose => $verbose,
49 dpavlin 1 );
50    
51 dpavlin 20 my $loader = $nos->{'loader'} || die "can't find loader?";
52    
53 dpavlin 2 my $lists = $loader->find_class('lists');
54     my $users = $loader->find_class('users');
55     my $user_list = $loader->find_class('user_list');
56 dpavlin 6 my $messages = $loader->find_class('messages');
57 dpavlin 11 my $queue = $loader->find_class('queue');
58 dpavlin 15 my $sent = $loader->find_class('sent');
59 dpavlin 2
60 dpavlin 14 $queue->set_sql( list_queue => qq{
61 dpavlin 15 SELECT messages.message, messages.date AS date, lists.name AS list
62 dpavlin 14 FROM queue
63     JOIN messages on message_id = messages.id
64     JOIN lists on list_id = lists.id
65     } );
66    
67    
68 dpavlin 9 =item --list[=list_name]
69 dpavlin 8
70 dpavlin 14 List all available lists and users on them.
71 dpavlin 8
72 dpavlin 14 Optional value is name of list. With it, this option will produce just users
73     on that list.
74    
75 dpavlin 8 =cut
76    
77 dpavlin 9 if (defined($list_opt)) {
78     my @lists;
79     if ($list_opt ne '') {
80     @lists = $lists->search( name=> $list_opt )->first || die "can't find list $list_opt";
81     } else {
82     @lists = $lists->retrieve_all;
83     }
84    
85     foreach my $list (@lists) {
86 dpavlin 17 print $list->name," <",$list->email,">\n";
87 dpavlin 1 foreach my $user_on_list ($user_list->search(list_id => $list->id)) {
88     my $user = $users->retrieve( id => $user_on_list->user_id );
89     print "\t",$user->full_name," <", $user->email, ">\n";
90     }
91     }
92 dpavlin 8
93     =item --add=list_name
94    
95     Add users to list. Users are stored in file (which can be supplied as
96     argument) or read from C<STDIN>. List should be in following format:
97    
98     email@example.com Optional full name of person
99     dpavlin@rot13.org Dobrica Pavlinusic
100    
101 dpavlin 18 You may use C<--email> parametar at any time to set From: e-mail address for list.
102     B<This seems somewhat cludgy, and it will probably change in future>.
103    
104 dpavlin 8 =cut
105    
106 dpavlin 2 } elsif ($add_opt) {
107     my $list = $lists->find_or_create({
108     name => $add_opt,
109     }) || die "can't add list $add_opt\n";
110 dpavlin 21
111 dpavlin 18 if ($email_opt && $list->email ne $email_opt) {
112     $list->email($email_opt);
113     $list->update;
114     $list->dbi_commit;
115     }
116 dpavlin 6
117     my $added = 0;
118    
119 dpavlin 2 while(<>) {
120     chomp;
121     next if (/^#/ || /^\s*$/);
122     my ($email, $name) = split(/\s+/,$_, 2);
123 dpavlin 15 $name ||= '';
124 dpavlin 13 if (! Email::Valid->address($email)) {
125     print "SKIPPING $name <$email>\n";
126     next;
127     }
128 dpavlin 2 print "# $name <$email>\n";
129     my $this_user = $users->find_or_create({
130     email => $email,
131     full_name => $name,
132     }) || die "can't find or create member\n";
133     my $user_on_list = $user_list->find_or_create({
134     user_id => $this_user->id,
135     list_id => $list->id,
136     }) || die "can't add user to list";
137 dpavlin 6 $added++;
138 dpavlin 2 }
139 dpavlin 3
140     foreach my $c_name ($loader->tables) {
141     my $c = $loader->find_class($c_name)|| die "can't find $c_name";
142     $c->dbi_commit();
143     }
144    
145 dpavlin 6 print "list ",$list->name," has $added users\n";
146    
147 dpavlin 14 =item --queue[=list_name]
148 dpavlin 8
149     Queue message for later delivery. Message can be read from file (specified as
150     argument) or read from C<STDIN>.
151    
152 dpavlin 16 This option without optional parametar will display pending queue. If you
153     add C<--verbose> flag, it will display all messages in queue.
154 dpavlin 14
155 dpavlin 8 =cut
156    
157 dpavlin 14 } elsif (defined($queue_opt)) {
158 dpavlin 6
159 dpavlin 14 if ($queue_opt ne '') {
160     # add message to list queue
161    
162     my $this_list = $lists->search(
163     name => $queue_opt,
164     )->first || die "can't find list $queue_opt";
165    
166     my $message_text;
167     while(<>) {
168     $message_text .= $_;
169     }
170    
171     die "no message" unless ($message_text);
172    
173     my $this_message = $messages->find_or_create({
174     message => $message_text
175     }) || die "can't insert message";
176    
177     $this_message->dbi_commit() || die "can't add message";
178    
179     $queue->find_or_create({
180     message_id => $this_message->id,
181     list_id => $this_list->id,
182     }) || die "can't add message ",$this_message->id," to list ",$this_list->id, ": ",$this_list->name;
183    
184     $queue->dbi_commit || die "can't add message to list ",$this_list->name;
185    
186     print "added message ",$this_message->id, " to list ",$this_list->name,"\n";
187    
188     } else {
189     # list messages in queue
190    
191     foreach my $m ($queue->retrieve_all) {
192 dpavlin 15 next if ($m->all_sent && ! $verbose);
193    
194     my $l = $m->all_sent ? 'S' : 'Q';
195    
196     my $date = $m->message_id->date;
197     $date =~ s/\..+$//;
198     my $msg = $m->message_id->message;
199     $msg =~ s/\s+/ /gs;
200    
201     $l .= sprintf(" %-10s %15s : ", $m->list_id->name, $date);
202     $l .= substr($msg, 0, 79 - length($l));
203    
204 dpavlin 14 print "$l\n";
205     }
206    
207 dpavlin 6 }
208    
209 dpavlin 14 =item --send[=list_name]
210 dpavlin 6
211 dpavlin 16 Send e-mails waiting in queue, or with optional argument, just send messages
212     for single list.
213 dpavlin 6
214 dpavlin 14 =cut
215 dpavlin 6
216 dpavlin 14 } elsif (defined($send_opt)) {
217 dpavlin 6
218 dpavlin 15 my $my_q;
219     if ($send_opt ne '') {
220     my $l_id = $lists->search_like( name => $send_opt )->first ||
221     die "can't find list $send_opt";
222     $my_q = $queue->search_like( list_id => $l_id ) ||
223     die "can't find list $send_opt";
224     } else {
225     $my_q = $queue->retrieve_all;
226     }
227 dpavlin 6
228 dpavlin 15 while (my $m = $my_q->next) {
229     next if ($m->all_sent);
230 dpavlin 14
231 dpavlin 15 print "sending message ",$m->message_id," enqueued on ",$m->date," to list ",$m->list_id->name,"\n";
232     my $msg = $m->message_id->message;
233    
234     foreach my $u ($user_list->search(list_id => $m->list_id)) {
235    
236     if ($sent->search( message_id => $m->message_id, user_id => $u->user_id )) {
237     print "SKIP ",$u->user_id->email," message allready sent\n";
238     } else {
239     print "\t",$u->user_id->email,"\n";
240 dpavlin 18
241 dpavlin 19 my $hdr = "From: " . $u->list_id->name . " <" . $u->list_id->email . ">\n" .
242     "To: " . $u->user_id->full_name . " <". $u->user_id->email. ">\n";
243    
244 dpavlin 18 # FIXME do real sending :-)
245 dpavlin 20 $nos->send_email("$hdr\n$msg");
246 dpavlin 18
247 dpavlin 15 $sent->create({
248     message_id => $m->message_id,
249     user_id => $u->user_id,
250     });
251     $sent->dbi_commit;
252     }
253     }
254     $m->all_sent(1);
255     $m->update;
256     $m->dbi_commit;
257 dpavlin 14 }
258    
259 dpavlin 1 } else {
260 dpavlin 8 die "see perldoc $0 for help";
261 dpavlin 1 }
262    
263 dpavlin 8 =back
264    
265 dpavlin 15
266    
267     =head2 Helper options
268    
269     =over 20
270    
271     =item --debug
272    
273     Turn on debugging output from C<Class::DBI>
274    
275     =item --verbose
276    
277     Dump more info on screen.
278    
279 dpavlin 18 =item --email
280    
281     Used to specify e-mail address where needed.
282    
283 dpavlin 15 =back
284    
285    
286    
287 dpavlin 8 =head1 AUTHOR
288    
289     Dobrica Pavlinusic <dpavlin@rot13.org>
290    
291     =cut
292    

Properties

Name Value
svn:executable

  ViewVC Help
Powered by ViewVC 1.1.26