/[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 14 - (hide annotations)
Sun May 15 14:20:08 2005 UTC (18 years, 10 months ago) by dpavlin
File MIME type: text/plain
File size: 4912 byte(s)
--queue without parametar lists queue, documented (but not implemented) send

1 dpavlin 1 #!/usr/bin/perl -w
2    
3     use strict;
4     use Class::DBI::Loader::Pg;
5     use Getopt::Long;
6 dpavlin 13 use Mail::CheckUser qw(check_email);
7     use Email::Valid;
8 dpavlin 14 use Email::Send;
9 dpavlin 1
10 dpavlin 6 =head1 NAME
11    
12     sender.pl - command line notify sender utility
13    
14 dpavlin 8 =head1 SYNOPSYS
15    
16     sender.pl --add=mylist members.txt
17 dpavlin 9 sender.pl --list[=mylist]
18 dpavlin 14 sender.pl --queue[=mylist message.txt]
19 dpavlin 8 sender.pl --send=mylist
20    
21     =head2 All options
22    
23     =over 20
24    
25     =item --debug
26    
27     Turn on debugging output from C<Class::DBI>
28    
29 dpavlin 6 =cut
30    
31 dpavlin 12 my $debug = 0;
32     my $list_opt;
33 dpavlin 2 my $add_opt;
34 dpavlin 6 my $queue_opt;
35 dpavlin 14 my $send_opt;
36 dpavlin 1
37     my $result = GetOptions(
38 dpavlin 9 "list:s" => \$list_opt,
39 dpavlin 2 "add=s" => \$add_opt,
40 dpavlin 14 "queue:s" => \$queue_opt,
41     "send:s" => \$send_opt,
42 dpavlin 1 "debug" => \$debug,
43     );
44    
45    
46     my $loader = Class::DBI::Loader::Pg->new(
47     debug => $debug,
48     dsn => "dbi:Pg:dbname=notices",
49     user => "dpavlin",
50     password => "",
51     namespace => "Noticer",
52     # additional_classes => qw/Class::DBI::AbstractSearch/,
53     # additional_base_classes => qw/My::Stuff/,
54 dpavlin 3 relationships => 1,
55 dpavlin 1 );
56    
57 dpavlin 2 my $lists = $loader->find_class('lists');
58     my $users = $loader->find_class('users');
59     my $user_list = $loader->find_class('user_list');
60 dpavlin 6 my $messages = $loader->find_class('messages');
61 dpavlin 11 my $queue = $loader->find_class('queue');
62 dpavlin 2
63 dpavlin 14 $queue->set_sql( list_queue => qq{
64     SELECT messages.message, messages.date AS message_date, lists.name AS list
65     FROM queue
66     JOIN messages on message_id = messages.id
67     JOIN lists on list_id = lists.id
68     } );
69    
70    
71 dpavlin 9 =item --list[=list_name]
72 dpavlin 8
73 dpavlin 14 List all available lists and users on them.
74 dpavlin 8
75 dpavlin 14 Optional value is name of list. With it, this option will produce just users
76     on that list.
77    
78 dpavlin 8 =cut
79    
80 dpavlin 9 if (defined($list_opt)) {
81     my @lists;
82     if ($list_opt ne '') {
83     @lists = $lists->search( name=> $list_opt )->first || die "can't find list $list_opt";
84     } else {
85     @lists = $lists->retrieve_all;
86     }
87    
88     foreach my $list (@lists) {
89 dpavlin 1 print $list->name,"\n";
90     foreach my $user_on_list ($user_list->search(list_id => $list->id)) {
91     my $user = $users->retrieve( id => $user_on_list->user_id );
92     print "\t",$user->full_name," <", $user->email, ">\n";
93     }
94     }
95 dpavlin 8
96     =item --add=list_name
97    
98     Add users to list. Users are stored in file (which can be supplied as
99     argument) or read from C<STDIN>. List should be in following format:
100    
101     email@example.com Optional full name of person
102     dpavlin@rot13.org Dobrica Pavlinusic
103    
104     =cut
105    
106 dpavlin 2 } elsif ($add_opt) {
107     #my $noticer = $loader->find_class('Noticer') || die "can't find my class!";
108     my $list = $lists->find_or_create({
109     name => $add_opt,
110     }) || die "can't add list $add_opt\n";
111 dpavlin 6
112     my $added = 0;
113    
114 dpavlin 2 while(<>) {
115     chomp;
116     next if (/^#/ || /^\s*$/);
117     my ($email, $name) = split(/\s+/,$_, 2);
118 dpavlin 13 if (! Email::Valid->address($email)) {
119     print "SKIPPING $name <$email>\n";
120     next;
121     }
122 dpavlin 2 print "# $name <$email>\n";
123     my $this_user = $users->find_or_create({
124     email => $email,
125     full_name => $name,
126     }) || die "can't find or create member\n";
127     my $user_on_list = $user_list->find_or_create({
128     user_id => $this_user->id,
129     list_id => $list->id,
130     }) || die "can't add user to list";
131 dpavlin 6 $added++;
132 dpavlin 2 }
133 dpavlin 3
134     foreach my $c_name ($loader->tables) {
135     my $c = $loader->find_class($c_name)|| die "can't find $c_name";
136     $c->dbi_commit();
137     }
138    
139 dpavlin 6 print "list ",$list->name," has $added users\n";
140    
141 dpavlin 14 =item --queue[=list_name]
142 dpavlin 8
143     Queue message for later delivery. Message can be read from file (specified as
144     argument) or read from C<STDIN>.
145    
146 dpavlin 14 This options without optional parametars it will display current queue.
147    
148 dpavlin 8 =cut
149    
150 dpavlin 14 } elsif (defined($queue_opt)) {
151 dpavlin 6
152 dpavlin 14 if ($queue_opt ne '') {
153     # add message to list queue
154    
155     my $this_list = $lists->search(
156     name => $queue_opt,
157     )->first || die "can't find list $queue_opt";
158    
159     my $message_text;
160     while(<>) {
161     $message_text .= $_;
162     }
163    
164     die "no message" unless ($message_text);
165    
166     my $this_message = $messages->find_or_create({
167     message => $message_text
168     }) || die "can't insert message";
169    
170     $this_message->dbi_commit() || die "can't add message";
171    
172     $queue->find_or_create({
173     message_id => $this_message->id,
174     list_id => $this_list->id,
175     }) || die "can't add message ",$this_message->id," to list ",$this_list->id, ": ",$this_list->name;
176    
177     $queue->dbi_commit || die "can't add message to list ",$this_list->name;
178    
179     print "added message ",$this_message->id, " to list ",$this_list->name,"\n";
180    
181     } else {
182     # list messages in queue
183    
184     foreach my $m ($queue->retrieve_all) {
185     my $l = sprintf("%-10s %15s : ", $m->list_id->name, $m->message_id->date);
186     $l .= substr($m->message_id->message, 0, 79 - length($l));
187     $l =~ s/[\n\r]/ /gs;
188     print "$l\n";
189     }
190    
191 dpavlin 6 }
192    
193 dpavlin 14 =item --send[=list_name]
194 dpavlin 6
195 dpavlin 14 Send e-mail waiting in queue for all lists, or with optional argument for
196     just single list.
197 dpavlin 6
198 dpavlin 14 =cut
199 dpavlin 6
200 dpavlin 14 } elsif (defined($send_opt)) {
201 dpavlin 6
202    
203 dpavlin 14 die "send option not yet implemented";
204    
205     my @q;
206     if ($send_opt ne '') {
207     # @q => $queue->search( name => 'foo' );
208     }
209     foreach my $q (@q) {
210    
211     }
212    
213 dpavlin 1 } else {
214 dpavlin 8 die "see perldoc $0 for help";
215 dpavlin 1 }
216    
217 dpavlin 8 =back
218    
219     =head1 AUTHOR
220    
221     Dobrica Pavlinusic <dpavlin@rot13.org>
222    
223     =cut
224    

Properties

Name Value
svn:executable

  ViewVC Help
Powered by ViewVC 1.1.26