# 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: TupleDefList.pm,v 1.3 2006/10/26 12:35:51 nagler Exp $
package Bivio::Biz::Model::TupleDefList;
use strict;
use base 'Bivio::Biz::Model::AscendingAuthList';

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

sub AUTH_ID_FIELD {
    return 'TupleDef.realm_id';
}

sub find_row_by_label {
    return shift->find_row_by('TupleDef.label', shift);
}

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

sub label_to_id {
    return shift->find_row_by_label(@_)->get('TupleDef.tuple_def_id');
}

1;