package RPS::ArtistRoyalty::Fast::Static::ProductTrack;

use strict;
use warnings;

use lib '/app/tools/common/lib';
use lib '/app/tools/rps/lib';
use lib '/app/tools/raptor/lib';
use Common::RSApp;

use Common::Log;

# We do not need to use Berkeley DB here since we are not going to change the content.
# Let's just cache all existing product track records.

sub GetProductTrackData {
    my $class = shift;

    my $dbo = Common::RSApp::GetClientDB();

    my $sql = qq/
        SELECT
            product_id,
            track_id
        FROM product_track
    /;
    my $sth = $dbo->DoCmd($sql);

    my %productTrackMap;
    while ( my @data = $sth->fetchrow_array() ) {
        $productTrackMap{ "$data[0]|$data[1]" } = undef;
    }

    return \%productTrackMap;
}


1;