markpasc (owner)

Revisions

  • 8e0dda Thu Dec 18 11:05:33 -0800 2008
  • 814126 Thu Dec 18 11:05:16 -0800 2008
gist: 37599 Download_button fork
public
Public Clone URL: git://gist.github.com/37599.git
Embed All Files: show embed
tools/count-entries.pl #
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
#!/usr/bin/perl -w
 
package CountEntries;
use strict;
 
use lib qw( extlib lib );
use base qw( MT::Tool );
 
sub help { q{} }
sub usage { q{} }
 
sub main {
    my $class = shift;
    my ($verbose) = $class->SUPER::main(@_);
 
    print count(MT->model('entry'), {}, {}), "\n";
}
 
sub count {
    my ($class, $terms, $args) = @_;
    my $driver = $class->driver;
    my $stmt = $driver->prepare_statement($class, $terms, $args);
 
    # Replace what search() would select with a COUNT(*).
    $stmt->select([]);
    $stmt->select_map({});
    $stmt->select_map_reverse({});
    $stmt->add_select('COUNT(*)');
 
    return $driver->select_one( $stmt->as_sql() );
}
 
__PACKAGE__->main() unless caller;
 
1;