Corpus Aging

Trace:

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision		Previous revision
corpusaging [2007/01/24 09:32] – mannicorpusaging [2007/03/02 13:45] (current) – external edit 127.0.0.1
Line 4: Line 4:
  
 1. Add the following trigger to the matrix by using the SQLite commandline utility 1. Add the following trigger to the matrix by using the SQLite commandline utility
-<code> +<code sql> 
 create trigger insert_matrix after insert on matrix create trigger insert_matrix after insert on matrix
 begin begin
-<code>  update matrix set lastseen = date('now') where id = new.id;</code>+  update matrix set lastseen = date('now') where id = new.id;
 end; end;
 </code> </code>
 +
 2. Modify Bayes.pm version 1.289 by inserting the following code at line 1791 2. Modify Bayes.pm version 1.289 by inserting the following code at line 1791
-<code> <code>+<code perl>
    #    #
    # Mark words lastseen unless we are in message view mode    # Mark words lastseen unless we are in message view mode
-   # </code>+   # 
    
-<code>   unless (defined($ui)) { +   unless (defined($ui)) { 
-       $self->{db%%__%%}->begin_work; +       $self->{db__}->begin_work; 
-       my $bucketid = $self->{db_bucketid%%__%%}{$userid}{$class}{id}; +       my $bucketid = $self->{db_bucketid__}{$userid}{$class}{id}; 
-       my $seeninbucket = $self->{db%%__%%}->do( "update matrix+       my $seeninbucket = $self->{db__}->do( "update matrix
                                   set lastseen = date('now')                                   set lastseen = date('now')
                                   where  wordid in ( $ids) and                                   where  wordid in ( $ids) and
                                   bucketid = $bucketid ;" );                                   bucketid = $bucketid ;" );
-       $self->{db%%__%%}->commit;+       $self->{db__}->commit;
    }    }
- </code></code>+</code>
  
 With the above changes, POPFile will start tracking the 'lastseen' date for any word inserted into the matrix or seen in an email being classified. Words are marked for the bucket that the message is classified into during the classification process. With the above changes, POPFile will start tracking the 'lastseen' date for any word inserted into the matrix or seen in an email being classified. Words are marked for the bucket that the message is classified into during the classification process.
Line 33: Line 34:
 <code>  <code> 
 Corpus Aging Prepared Sat 20-Mar-2004 Corpus Aging Prepared Sat 20-Mar-2004
-<code>            Under                               Over    No</code>+            Under                               Over    No
 Bucket        15   15-29 30-44 45-59 60-74 75-89  90    Date Bucket        15   15-29 30-44 45-59 60-74 75-89  90    Date
 ------------ ----- ----- ----- ----- ----- ----- ----- ------- ------------ ----- ----- ----- ----- ----- ----- ----- -------
Line 42: Line 43:
 ------------ ----- ----- ----- ----- ----- ----- ----- ------- ------------ ----- ----- ----- ----- ----- ----- ----- -------
 Totals       15404  2050   959   481   333   576   684    6590 Totals       15404  2050   959   481   333   576   684    6590
-<code>             56.9   7.6   3.5   1.8   1.2   2.1   2.5    24.3 +             56.9   7.6   3.5   1.8   1.2   2.1   2.5    24.3 
- </code></code>+</code>
  
 The above report was produced with the script CorpusAge .   The above report was produced with the script CorpusAge .  
Line 50: Line 51:
 <code>  <code> 
 Corpus Aging Prepared Wed 16-Jun-2004 Corpus Aging Prepared Wed 16-Jun-2004
-<code>            Under                               Over    No</code>+            Under                               Over    No
 Bucket        15   15-29 30-44 45-59 60-74 75-89  90    Date Bucket        15   15-29 30-44 45-59 60-74 75-89  90    Date
 ------------ ----- ----- ----- ----- ----- ----- ----- ------- ------------ ----- ----- ----- ----- ----- ----- ----- -------
Line 59: Line 60:
 ------------ ----- ----- ----- ----- ----- ----- ----- ------- ------------ ----- ----- ----- ----- ----- ----- ----- -------
 Totals       16447  2015  1370  1259   673   551  2278    5201 Totals       16447  2015  1370  1259   673   551  2278    5201
-<code>             55.2   6.8   4.6   4.2   2.3   1.8   7.6    17.5</code>+             55.2   6.8   4.6   4.2   2.3   1.8   7.6    17.5
 </code> </code>
  
 
corpusaging.1169631172.txt.gz · Last modified: 2008/02/08 19:49 (external edit)
Old revisions

Should you find anything in the documentation that is incomplete, unclear, outdated or just plain wrong, please let us know and leave a note in the Documentation Forum.

Recent changes RSS feed Donate Driven by DokuWiki
The content of this wiki is protected by the GNU Fee Documentation License