# Copyright (c) 2006 bivio Software, Inc.  All Rights Reserved.
#
# Visit http://www.bivio.biz for more info.
# 
# This library is free software; you can redistribute it and/or modify
# it under the terms of the GNU Lesser General Public License as
# published by the Free Software Foundation; either version 2.1 of the
# License, or (at your option) any later version.
# 
# This library is distributed in the hope that it will be useful, but
# WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
# Lesser General Public License for more details.
# 
# You should have received a copy of the GNU Lesser General Public
# License along with this library;  If not, you may get a copy from:
# http://www.opensource.org/licenses/lgpl-license.html
# 
# $Id: TupleUseList.pm,v 1.5 2006/11/13 22:38:51 nagler Exp $
package Bivio::Biz::Model::TupleUseList;
use strict;
use base 'Bivio::Biz::ListModel';

our($VERSION) = sprintf('%d.%02d', q$Revision: 1.5 $ =~ /\d+/g);

sub find_row_by_id {
    return shift->find_row_by('TupleUse.tuple_def_id', shift);
}

sub find_row_by_moniker {
    return shift->find_row_by('TupleUse.moniker', shift);
}

sub internal_initialize {
    my($self) = @_;
    return $self->merge_initialize_info($self->SUPER::internal_initialize, {
        version => 1,
	can_iterate => 1,
	primary_key => [[qw(TupleUse.tuple_def_id TupleDef.tuple_def_id)]],
        order_by => [qw(
	    TupleUse.label
	    TupleUse.moniker
	    TupleDef.label
	)],
	other => [
	    {
		name => 'tuple_count',
		type => 'Integer',
		constraint => 'NOT_NULL',
		in_select => 1,
		select_value => '(SELECT COUNT(*)
                    FROM tuple_t
                    WHERE tuple_use_t.tuple_def_id = tuple_t.tuple_def_id
                    AND tuple_use_t.realm_id = tuple_t.realm_id)
                    AS tuple_count',
	    },
	],
	auth_id => 'TupleUse.realm_id',
    });
}

sub moniker_to_id {
    return shift->find_row_by_moniker(@_)->get('TupleUse.tuple_def_id');
}

sub monikers {
    return shift->map_rows(sub {shift->get('TupleUse.moniker')});
}

1;