# -*- coding: latin-1 -*-
""" 
   Copyright (C) 2001-2003 PimenTech SARL (http://www.pimentech.net)

   This library is free software; you can redistribute it and/or
   modify it under the terms of the GNU Library General Public License as
   published by the Free Software Foundation; either version 2 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
   Library General Public License for more details.

   You should have received a copy of the GNU Library General Public
   License along with this library; see the file COPYING.LIB.  If not,
   write to the Free Software Foundation, Inc., 59 Temple Place - Suite 330,
   Boston, MA 02111-1307, USA.  
"""

__version__='$Revision: 1.7 $'[11:-2]

from Products.PimenTechLibCommon.coretable import *

from Globals import HTMLFile
from Globals import MessageDialog
from Products.ZSQLMethods.SQL import SQL

class Table(CoreTable):
	"handles tables"
	
	meta_type = 'Table'
	
	index_html = HTMLFile('dtml/tableIndex', globals())

	def __init__(self, id, title = '',
							 idSequence = None, usePostgreSqlIsa = None, useIndices = None):
		CoreTable.__init__(self, id, title, idSequence, usePostgreSqlIsa, useIndices)
		
	def compute_select_zsql(self): # PAS BON
		"compute the zsql performing select queries"
		zsql = "select"
		comma_tag = 0
		for field in self.get_fields():
			if comma_tag:
				zsql = "%s," % zsql
			else:
				comma_tag = 1
			zsql = "%s %s as %s_%s" % (zsql,field,self.getId(),field)
		zsql = "%s\nfrom %s\n<dtml-sqlgroup where>\n" % (zsql, self.getId())
		return zsql