# $Id: nodes.py 3572 2008-10-16 09:11:19Z hsaliak $
#
#   Copyright 2007 Platform Computing Inc
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of version 2 of the GNU General Public License as
# published by the Free Software Foundation.
# 	
# This program 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 General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA
#
#

from kusu.genconfig import Report
import sys

class thisReport(Report):
    
    def toolHelp(self):
        """toolHelp - This method provides the help screen for this particular
        plugin.  All plugins must implement this method."""
        print self.gettext("genconfig_Nodes_Help")


    def runPlugin(self, pluginargs):
        """runPlugin - This method provides the database report for this
        plugin.  All plugins must implement this method."""

        if pluginargs and pluginargs[0] != '':
            query = ('select nodes.name from nodes,nodegroups where '
                     'nodes.ngid=nodegroups.ngid and '
                     'nodegroups.ngname=\'%s\' order by nodes.name' % pluginargs[0])
        else:
            query = ('select nodes.name from nodes,nodegroups where '
                     'nodes.ngid=nodegroups.ngid and '
                     'nodegroups.ngname!=\'Unmanaged\' order by nodes.name')
        try:
            self.db.execute(query)

        except:
            sys.stderr.write(self.gettext("DB_Query_Error\n"))
            sys.exit(-1)

        else:            
            data = self.db.fetchall()
            if data:
                for row in data:
                    print "%s" % (row[0])