#------------------------------------------------------------
# Copyright (C) 2011 RoyaltyShare, Inc.   All Rights Reserved
#------------------------------------------------------------
package BookPub::DB::Item::SaleFeed;

use strict;
use warnings;

use lib '/app/tools/common/lib';
use Common::Assert;

use Common::DB::Item;
use base 'Common::DB::Item';

use constant kTable => 'sale_feed';
use constant kDB    => Common::DB::Item::kClientDB;

sub GetAllBySaleFeedServiceID {
    my $class = shift;
    my $saleFeedServiceID = shift || die;

    my $sql =
        "SELECT * FROM "
      . kTable
      . " INNER JOIN sale_feed_service USING (sale_feed_service_id) "
      . " WHERE sale_feed_service_id = "
      . $class->quote($saleFeedServiceID);

    return $class->SUPER::GetAll($sql);
}

sub GetAllBySaleFeedService {
    my $class = shift;
    my $saleFeedServiceID = shift || die;

    my $sql = "SELECT * FROM " . kTable .

      #   " INNER JOIN sale_feed_service USING (sale_feed_service_id) " .
      " WHERE sale_feed_service_id = " . $class->quote($saleFeedServiceID);

    return $class->SUPER::GetAll($sql);
}

1;