unitime-cvs Mailing List for University Timetabling (Page 13)

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Update of /cvsroot/unitime/UniTime/JavaSource/org/unitime/commons/ant
In directory sfp-cvsdas-2.v30.ch3.sourceforge.com:/tmp/cvs-serv16691/JavaSource/org/unitime/commons/ant

Added Files:
      Tag: dev_curriculum
	DoubleVarcharSizes.java 
Log Message:
Simple class that goes through all .hbm.xml files and generates (Oracle) SQL script that doubles the size of all the varchar2 columns. This is helpful when the application is used with non-english languages as special (non-latin) characters may take two characters in Oracle database. This is not needed for MySQL as it counts characters correctly.

--- NEW FILE: DoubleVarcharSizes.java ---
/*
 * UniTime 3.2 (University Timetabling Application)
 * Copyright (C) 2010, UniTime LLC, and individual contributors
 * as indicated by the @authors tag.
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 3 of the License, or
 * (at your option) any later version.
 * 
 * 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, see <http://www.gnu.org/licenses/>.
 * 
*/
package org.unitime.commons.ant;

import java.io.File;
import java.io.IOException;
import java.util.Iterator;

import org.apache.tools.ant.BuildException;
import org.apache.tools.ant.Project;
import org.apache.tools.ant.Task;
import org.dom4j.Document;
import org.dom4j.DocumentException;
import org.dom4j.Element;
import org.dom4j.io.SAXReader;
import org.xml.sax.SAXException;

/**
 * The following class will go through all hbm.xml files and generate (Oracle) SQL commands
 * that will double the size of all varchars2. This is needed for Oracle when non-english characters
 * are used as these may take up to two spaces each.
 * 
 * @author Tomas Muller
 *
 */
public class DoubleVarcharSizes extends Task {
	private SAXReader iSAXReader = null;
	private String iSource = null;
	private String iConfig = "hibernate.cfg.xml";
	
	public DoubleVarcharSizes() throws DocumentException, SAXException {
		iSAXReader = new SAXReader();
		iSAXReader.setFeature("http://apache.org/xml/features/nonvalidating/load-external-dtd", false);
	}
	
	public void setSource(String source) {
		iSource = source;
	}
	
	public void setConfig(String config) {
		iConfig = config;
	}

	protected Document read(String resource) throws IOException, DocumentException {
		if (iSource == null) {
			return iSAXReader.read(getClass().getClassLoader().getResourceAsStream(resource));
		} else {
			return iSAXReader.read(new File(iSource + File.separator + resource));
		}
	}
	
	protected void pretty(File f) {
	}
	
	public void execute() throws BuildException {
		try {
			generate();
		} catch (Exception e) {
			throw new BuildException(e);
		}
	}
	
	public void info(String message) {
		try {
			log(message);
		} catch (Exception e) {
			System.out.println(message);
		}
	}
	
	public void warn(String message) {
		try {
			log(message, Project.MSG_WARN);
		} catch (Exception e) {
			System.out.println(message);
		}
	}

	public void generate() throws IOException, DocumentException {
		Document document = read(iConfig);
		Element root = document.getRootElement();
		Element sessionFactoryElement = root.element("session-factory");
		for (Iterator<Element> i = sessionFactoryElement.elementIterator("mapping"); i.hasNext(); ) {
			Element m = i.next();
			String resource = m.attributeValue("resource");
			if (resource == null) continue;
			generate(read(resource).getRootElement(), null);
		}
	}
	
	private void generate(Element element, String table) {
		table = element.attributeValue("table", table);
		if (table != null && "property".equals(element.getName())) {
			String column = element.attributeValue("column");
			String type = element.attributeValue("type");
			String length = element.attributeValue("length");
			if (("String".equals(type) || "java.lang.String".equals(type)) && length != null && !length.isEmpty() && column != null && !column.isEmpty()) {
				int size = Integer.parseInt(length);
				info("alter table " + table + " modify " + column + " varchar2(" + Math.min(4000, 2 * size) + ");");
			}
		}
		for (Iterator<Element> i = element.elementIterator(); i.hasNext(); ) {
			generate(i.next(), table);
		}
	}

	public static void main(String[] args) {
		try {
			DoubleVarcharSizes dvs = new DoubleVarcharSizes();
			dvs.generate();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}

2007	Jan	Feb	Mar	Apr	May	Jun (275)	Jul (81)	Aug (19)	Sep (26)	Oct (190)	Nov (118)	Dec (16)
2008	Jan (9)	Feb (318)	Mar (251)	Apr (354)	May (209)	Jun (261)	Jul (226)	Aug (136)	Sep (156)	Oct (30)	Nov (5)	Dec (13)
2009	Jan (26)	Feb (35)	Mar (63)	Apr (21)	May (26)	Jun (33)	Jul (55)	Aug (71)	Sep (23)	Oct (40)	Nov (18)	Dec (13)
2010	Jan (17)	Feb (98)	Mar (39)	Apr (25)	May (107)	Jun (257)	Jul (270)	Aug (206)	Sep (237)	Oct (187)	Nov (302)	Dec (187)
2011	Jan (63)	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec

unitime-cvs Mailing List for University Timetabling (Page 13)

unitime-cvs — CVS changes