#------------------------------------------------------------
# Copyright (C) 2006 RoyaltyShare, Inc.   All Rights Reserved
#------------------------------------------------------------
package Raptor::DB::Item::ProductInputMap;

use strict;
use warnings;

use lib '/app/tools/common/lib';
use Common::Util qw(escape_mysql_regexp escape_mysql_like);
use Common::DB::ItemCollection;

use constant kTable => 'product_input_map';
use constant kDB    => Common::DB::Item::kClientDB();

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

sub GetTableStatus {
    my ($class) = @_;
    my $dbo = Common::RSApp::GetClientDB();

    my $sql = "SHOW TABLE STATUS LIKE '" . kTable . "'";

    my $sth = $dbo->DoCmd($sql);

    my $result;
    my @results;
    while ( $result = $sth->fetchrow_arrayref ) {
        push @results, @{$result};
    }
    return @results;
}

sub Delete {
    my $class   = shift;
    my $productID = shift;

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

    $dbo->DoCmd( "DELETE FROM " . kTable . " WHERE product_id = " . $dbo->DBQuote($productID) );
}

1;