/[notice-sender]/trunk/Nos.pm

This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!

Diff of /trunk/Nos.pm

Parent Directory | Revision Log | View Patch Patch

-revision 71 by dpavlin,
Mon Aug 22 19:25:24 2005 UTC
+revision 83 by dpavlin,
Mon Aug 29 14:53:53 2005 UTC
 Line 16 
 our @EXPORT_OK = ( @{ $EXPORT_TAGS{'all'
  our @EXPORT = qw(
  );
- our $VERSION = '0.6';
+ our $VERSION = '0.8';
  use Class::DBI::Loader;
  use Email::Valid;
 Line 27 
 use Email::Simple;
  use Email::Address;
  use Mail::DeliveryStatus::BounceParser;
  use Class::DBI::AbstractSearch;
+ use SQL::Abstract;
  use Mail::Alias;
  use Cwd qw(abs_path);
-Line 62 
 encoded) or anything else.
+Line 63 
 encoded) or anything else.
  It will just queue your e-mail message to particular list (sending it to
  possibly remote Notice Sender SOAP server just once), send it out at
  reasonable rate (so that it doesn't flood your e-mail infrastructure) and
- track replies.
+ keep track replies.
- It is best used to send smaller number of messages to more-or-less fixed
+ It is best used to send small number of messages to more-or-less fixed
  list of recipients while allowing individual responses to be examined.
  Tipical use include replacing php e-mail sending code with SOAP call to
  Notice Sender. It does support additional C<ext_id> field for each member
-Line 72 
 which can be used to track some unique i
+Line 73 
 which can be used to track some unique i
  particular user.
  It comes with command-line utility C<sender.pl> which can be used to perform
- all available operation from scripts (see C<perldoc sender.pl>).
+ all available operation from scripts (see C<sender.pl --man>).
  This command is also useful for debugging while writing client SOAP
  application.
-Line 120 
 sub new {
+Line 121 
 sub new {
  }
- =head2 new_list
+ =head2 create_list
  Create new list. Required arguments are name of C<list>, C<email> address
  and path to C<aliases> file.
-  $nos->new_list(
+  $nos->create_list(
          list => 'My list',
          from => 'Outgoing from comment',
          email => 'my-list@example.com',
-Line 139 
 Calls internally C<_add_list>, see detai
+Line 140 
 Calls internally C<_add_list>, see detai
  =cut
- sub new_list {
+ sub create_list {
          my $self = shift;
          my $arg = {@_};
-Line 158 
 sub new_list {
+Line 159 
 sub new_list {
  }
- =head2 delete_list
+ =head2 drop_list
  Delete list from database.
-  my $ok = delete_list(
+  my $ok = drop_list(
          list => 'My list'
          aliases => '/etc/mail/mylist',
   );
-Line 171 
 Returns false if list doesn't exist.
+Line 172 
 Returns false if list doesn't exist.
  =cut
- sub delete_list {
+ sub drop_list {
          my $self = shift;
          my $args = {@_};
-Line 267 
 List all members of some list.
+Line 268 
 List all members of some list.
          list => 'My list',
   );
- Returns array of hashes with user informations like this:
+ Returns array of hashes with user information like this:
   $member = {
          name => 'Dobrica Pavlinusic',
-Line 475 
 Send e-mail using SMTP server at 127.0.0
+Line 476 
 Send e-mail using SMTP server at 127.0.0
  =back
+ Any other driver name will try to use C<Email::Send::that_driver> module.
  Default sleep wait between two messages is 3 seconds.
+ This method will return number of succesfully sent messages.
  =cut
  sub send_queued_messages {
-Line 489 
 sub send_queued_messages {
+Line 494 
 sub send_queued_messages {
          my $sleep = $arg->{'sleep'};
          $sleep ||= 3 unless defined($sleep);
+         # number of messages sent o.k.
+         my $ok = 0;
          my $email_send_driver = 'Email::Send::IO';
          my @email_send_options;
          if (lc($driver) eq 'smtp') {
                  $email_send_driver = 'Email::Send::SMTP';
                  @email_send_options = ['127.0.0.1'];
+         } elsif ($driver && $driver ne '') {
+                 $email_send_driver = 'Email::Send::' . $driver;
          } else {
                  warn "dumping all messages to STDERR\n";
          }
-Line 564 
 sub send_queued_messages {
+Line 574 
 sub send_queued_messages {
                                  }
                                  croak "can't send e-mail: $sent_status\n\nOriginal e-mail follows:\n".$m_obj->as_string unless ($sent_status);
-                                 my @bad = @{ $sent_status->prop('bad') };
+                                 my @bad;
+                                 @bad = @{ $sent_status->prop('bad') } if (eval { $sent_status->can('prop') });
                                  croak "failed sending to ",join(",",@bad) if (@bad);
                                  if ($sent_status) {
-Line 578 
 sub send_queued_messages {
+Line 589 
 sub send_queued_messages {
                                          print " - $sent_status\n";
+                                         $ok++;
                                  } else {
                                          warn "ERROR: $sent_status\n";
                                  }
-Line 593 
 sub send_queued_messages {
+Line 605 
 sub send_queued_messages {
                  $m->dbi_commit;
          }
+         return $ok;
  }
  =head2 inbox_message
-Line 691 
 sub inbox_message {
+Line 705 
 sub inbox_message {
  #       print "message_id: ",($message_id || "not found")," -- $is_bounce\n";
  }
+ =head2 received_messages
+ Returns all received messages for given list or user.
+  my @received = $nos->received_messages(
+         list => 'My list',
+         email => "john.doe@example.com",
+         from_date => '2005-01-01 10:15:00',
+         to_date => '2005-01-01 12:00:00',
+         message => 0,
+  );
+ If don't specify C<list> or C<email> it will return all received messages.
+ Results will be sorted by received date, oldest first.
+ Other optional parametars include:
+ =over 10
+ =item from_date
+ Date (in ISO format) for lower limit of dates received
+ =item to_date
+ Return just messages older than this date
+ =item message
+ Include whole received message in result. This will probably make result
+ array very large. Use with care.
+ =back
+ Date ranges are inclusive, so results will include messages sent on
+ particular date specified with C<date_from> or C<date_to>.
+ Each element in returned array will have following structure:
+  my $row = {
+         id => 42,                       # unique ID of received message
+         list => 'My list',              # useful if filtering by email
+         ext_id => 9999,                 # ext_id from message sender
+         email => 'jdoe@example.com',    # e-mail of message sender
+         bounced => 0,                   # true if message is bounce
+         date => '2005-08-24 18:57:24',  # date of receival in ISO format
+  }
+ If you specified C<message> option, this hash will also have C<message> key
+ which will contain whole received message.
+ =cut
+ sub received_messages {
+         my $self = shift;
+         my $arg = {@_} if (@_);
+ #       croak "need list name or email" unless ($arg->{'list'} || $arg->{'email'});
+         my $sql = qq{
+                         select
+                                 received.id as id,
+                                 lists.name as list,
+                                 users.ext_id as ext_id,
+                                 users.email as email,
+         };
+         $sql .= qq{             message,} if ($arg->{'message'});
+         $sql .= qq{
+                                 bounced,received.date as date
+                         from received
+                         join lists on lists.id = list_id
+                         join users on users.id = user_id
+         };
+         my $order = qq{ order by date asc };
+         my $where;
+         $where->{'lists.name'} = lc($arg->{'list'}) if ($arg->{'list'});
+         $where->{'users.email'} = lc($arg->{'email'}) if ($arg->{'email'});
+         $where->{'received.date'} = { '>=', $arg->{'date_from'} } if ($arg->{'date_from'});
+         $where->{'received.date'} = { '<=', $arg->{'date_to'} } if ($arg->{'date_to'});
+         # hum, yammy one-liner
+         my($stmt, @bind)  = SQL::Abstract->new->where($where);
+         my $dbh = $self->{'loader'}->find_class('received')->db_Main;
+         my $sth = $dbh->prepare($sql . $stmt . $order);
+         $sth->execute(@bind);
+         return $sth->fetchall_hash;
+ }
  =head1 INTERNAL METHODS
-Line 758 
 sub _add_aliases {
+Line 866 
 sub _add_aliases {
          $self_path =~ s#/[^/]+$##;
          $self_path =~ s#/t/*$#/#;
-         $target .= qq#| cd $self_path && ./sender.pl --inbox="$list"#;
+         $target .= qq#"| cd $self_path && ./sender.pl --inbox='$list'"#;
+         # remove hostname from email to make Postfix's postalias happy
+         $email =~ s/@.+//;
          if ($a->exists($email)) {
                  $a->update($email, $target) or croak "can't update alias ".$a->error_check;
-Line 923 
 Create new SOAP object
+Line 1034 
 Create new SOAP object
          aliases => '/etc/aliases',
   );
+ If you are writing SOAP server (like C<soap.cgi> example), you will need to
+ call this method once to make new instance of Nos::SOAP and specify C<dsn>
+ and options for it.
  =cut
  sub new {
-Line 939 
 sub new {
+Line 1054 
 sub new {
  }
- =head2 NewList
+ =head2 CreateList
-  $message_id = NewList(
+  $message_id = CreateList(
          list => 'My list',
          from => 'Name of my list',
          email => 'my-list@example.com'
-Line 949 
 sub new {
+Line 1064 
 sub new {
  =cut
- sub NewList {
+ sub CreateList {
          my $self = shift;
          my $aliases = $nos->{'aliases'} || croak "need 'aliases' argument to new constructor";
          if ($_[0] !~ m/^HASH/) {
-                 return $nos->new_list(
+                 return $nos->create_list(
                          list => $_[0], from => $_[1], email => $_[2],
                          aliases => $aliases,
                  );
          } else {
-                 return $nos->new_list( %{ shift @_ }, aliases => $aliases );
+                 return $nos->create_list( %{ shift @_ }, aliases => $aliases );
          }
  }
- =head2 DeleteList
+ =head2 DropList
-  $ok = DeleteList(
+  $ok = DropList(
          list => 'My list',
   );
  =cut
- sub DeleteList {
+ sub DropList {
          my $self = shift;
          my $aliases = $nos->{'aliases'} || croak "need 'aliases' argument to new constructor";
          if ($_[0] !~ m/^HASH/) {
-                 return $nos->delete_list(
+                 return $nos->drop_list(
                          list => $_[0],
                          aliases => $aliases,
                  );
          } else {
-                 return $nos->delete_list( %{ shift @_ }, aliases => $aliases );
+                 return $nos->drop_list( %{ shift @_ }, aliases => $aliases );
          }
  }
-Line 1020 
 sub AddMemberToList {
+Line 1135 
 sub AddMemberToList {
  Returns array of hashes with user informations, see C<list_members>.
- Returning arrays from SOAP calls is somewhat fuzzy (at least to me). It
- seems that SOAP::Lite client thinks that it has array with one element which
- is array of hashes with data.
  =cut
  sub ListMembers {
-Line 1084 
 sub AddMessageToList {
+Line 1195 
 sub AddMessageToList {
          }
  }
+ =head2 MessagesReceived
+ Return statistics about received messages.
+  my @result = MessagesReceived(
+         list => 'My list',
+         email => 'jdoe@example.com',
+         from_date => '2005-01-01 10:15:00',
+         to_date => '2005-01-01 12:00:00',
+         message => 0,
+  );
+ You must specify C<list> or C<email> or any combination of those two. Other
+ parametars are optional.
+ For format of returned array element see C<received_messages>.
+ =cut
+ sub MessagesReceived {
+         my $self = shift;
+         if ($_[0] !~ m/^HASH/) {
+                 die "need at least list or email" unless (scalar @_ < 2);
+                 return $nos->received_messages(
+                         list => $_[0], email => $_[1],
+                         from_date => $_[2], to_date => $_[3],
+                         message => $_[4]
+                 );
+         } else {
+                 my $arg = shift;
+                 die "need list or email argument" unless ($arg->{'list'} || $arg->{'email'});
+                 return $nos->received_messages( %{ $arg } );
+         }
+ }
  ###
+ =head1 NOTE ON ARRAYS IN SOAP
+ Returning arrays from SOAP calls is somewhat fuzzy (at least to me). It
+ seems that SOAP::Lite client thinks that it has array with one element which
+ is array of hashes with data.
  =head1 EXPORT
  Nothing.

 Legend:



Removed from v.71
 


changed lines


 
Added in v.83
 Legend:



Removed from v.71
 


changed lines


 
Added in v.83
-Removed from v.71
+Added in v.83

	ViewVC Help
Powered by ViewVC 1.1.26