package org.korsakow.services.tdg; import javax.xml.xpath.XPathException; import javax.xml.xpath.XPathExpressionException; import org.korsakow.ide.DataRegistry; import org.korsakow.ide.XPathHelper; import org.w3c.dom.Element; import org.w3c.dom.NodeList; public class ImageTDG { public static final String NODE_NAME = "Image"; public static int insert(long version, String name, String filename, Long duration) throws XPathException{ return insert(DataRegistry.getMaxId(), version, name, filename, duration); } public static int insert(long id, long version, String name, String filename, Long duration) throws XPathExpressionException{ Element element = DataRegistry.getHelper().appendElement("/korsakow/images", NODE_NAME); DataRegistry.getHelper().setLong(element, "id", id); DataRegistry.getHelper().setLong(element, "version", version); return update(id, version, name, filename, duration); } public static int delete(long id, long version) throws XPathExpressionException { NodeList list = DataRegistry.getHelper().removeNodes(XPathHelper.formatQuery("/korsakow/images/Image[id=? and version=?]", id, version)); return list.getLength(); } public static int update(long id, long version, String name, String filename, Long duration) throws XPathExpressionException{ Element element = DataRegistry.getHelper().findElementByIdTag(id); // Element element = DataRegistry.getHelper().xpathAsElement(XPathHelper.formatQuery("/korsakow/images/Image[id=? and version=?]", id, version)); if (element == null) return 0; DataRegistry.getHelper().setLong(element, "id", id); DataRegistry.getHelper().setLong(element, "version", version+1); DataRegistry.getHelper().setString(element, "name", name); DataRegistry.getHelper().setString(element, "filename", filename); DataRegistry.getHelper().setLong(element, "duration", duration); return 1; } public static void createImageTable() throws XPathExpressionException { if (DataRegistry.getHelper().xpathAsElement("/korsakow/images") == null) { DataRegistry.getHelper().appendElement("/korsakow", "images"); } } public static void dropTable () throws XPathExpressionException{ DataRegistry.getHelper().removeNodes(XPathHelper.formatQuery("/korsakow/images")); } }