blib/lib/Mail/SpamAssassin/Plugin/DBSCORE.pm untested

filter: Statementstmt 0.0% 0 / 47 Branchbran 0.0% 0 / 6 Conditioncond 0.0% 0 / 3 MC/DCmcdc 0.0% 0 / 2 Subroutinesub 0.0% 0 / 6 Podpod 0.0% 0 / 2 totaltotal 0.0% 0 / 66 CC 4 SCAR 23.0
CC
4
Cov
0%
DBSCORE
20.0
new
2.0
BEGIN
2.0
CRAP 10.0
1 package Mail::SpamAssassin::Plugin::DBSCORE;
2 # ABSTRACT: Spamassassin scores from database
3 $Mail::SpamAssassin::Plugin::DBSCORE::VERSION = '1.250650';
4 use strict;
5 use warnings;
6  
7 use Mail::SpamAssassin::Plugin;
8 use DBI;
9  
10 our @ISA = qw(Mail::SpamAssassin::Plugin);
11  
12 sub new {
13 my $class = shift;
14 my $mailsaobject = shift;
15 $class = ref($class) || $class;
16 my $self = $class->SUPER::new($mailsaobject);
17 bless ($self, $class);
18 $self->register_eval_rule("DBSCORE");
19  
20 $mailsaobject->{conf}->{parser}->register_commands( [
21 {
22 setting => 'dbscore_dsn',
23 type => $Mail::SpamAssassin::Conf::CONF_TYPE_STRING,
24 default => 'DBI:MariaDB:database=dbscore;host=127.0.0.1;port=3306',
25 }, {
26 setting => 'dbscore_db_user',
27 type => $Mail::SpamAssassin::Conf::CONF_TYPE_STRING,
28 default => 'dbscore',
29 }, {
30 setting => 'dbscore_db_pass',
31 type => $Mail::SpamAssassin::Conf::CONF_TYPE_STRING,
32 default => 'dbscore',
33 }
34 ] );
35  
36  
37 return $self;
38 }
39  
40  
41 sub DBSCORE{
42 my ($self, $pms, $fulltext) = @_;
43  
44 my $dbh = DBI->connect($pms->{conf}->{dbscore_dsn}, $pms->{conf}->{dbscore_db_user}, $pms->{conf}->{dbscore_db_pass});
45  
46 my $fromhost = $pms->get('From:addr:host');
47 my $from = $pms->get('From:addr:first');
48  
49 my $score = 0;
50 my $domainscore = 0;
51  
52 my $sth = $dbh->prepare('SELECT score FROM senders WHERE sender = ?');
53 $sth->execute($from);
54  
55 my $data = $sth->fetchrow_hashref;
56  
57 if($data->{score}){
58 $score = $data->{score};
59 }
60  
61 $sth = $dbh->prepare('SELECT score FROM domains WHERE domain = ?');
62 $sth->execute($fromhost);
63  
64 $data = $sth->fetchrow_hashref;
65  
66 if($data->{score}){
67 $domainscore = $data->{score};
68 }
69  
70 $score = $score + $domainscore;
71  
72 if($score) {
73 $pms->got_hit("DBSCORE", "HEADER: ", score => $score);
74 for my $set (0..3) {
75 $pms->{conf}->{scoreset}->[$set]->{"DBSCORE"} = sprintf("%0.3f", $score);
76 }
77 }
78  
79 $dbh->disconnect;
80  
81 return 0;
82 }
83  
84 __END__