diff options
Diffstat (limited to 'velocity-engine-core/src/test/java/org/apache/velocity/test/sql/DataSourceResourceLoaderTestCase.java')
| -rw-r--r-- | velocity-engine-core/src/test/java/org/apache/velocity/test/sql/DataSourceResourceLoaderTestCase.java | 229 |
1 files changed, 229 insertions, 0 deletions
diff --git a/velocity-engine-core/src/test/java/org/apache/velocity/test/sql/DataSourceResourceLoaderTestCase.java b/velocity-engine-core/src/test/java/org/apache/velocity/test/sql/DataSourceResourceLoaderTestCase.java new file mode 100644 index 00000000..757b6e84 --- /dev/null +++ b/velocity-engine-core/src/test/java/org/apache/velocity/test/sql/DataSourceResourceLoaderTestCase.java @@ -0,0 +1,229 @@ +package org.apache.velocity.test.sql; + +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, + * software distributed under the License is distributed on an + * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY + * KIND, either express or implied. See the License for the + * specific language governing permissions and limitations + * under the License. + */ + +import junit.framework.Test; +import junit.framework.TestSuite; +import org.apache.velocity.Template; +import org.apache.velocity.VelocityContext; +import org.apache.velocity.app.Velocity; +import org.apache.velocity.runtime.RuntimeInstance; +import org.apache.velocity.runtime.resource.loader.DataSourceResourceLoader; +import org.apache.velocity.test.misc.TestLogger; +import org.apache.velocity.util.ExtProperties; + +import javax.sql.DataSource; +import java.io.BufferedWriter; +import java.io.FileOutputStream; +import java.io.OutputStreamWriter; +import java.io.StringWriter; +import java.io.Writer; + + +public class DataSourceResourceLoaderTestCase + extends BaseSQLTest +{ + /** + * Comparison file extension. + */ + private static final String CMP_FILE_EXT = "cmp"; + + /** + * Comparison file extension. + */ + private static final String RESULT_FILE_EXT = "res"; + + /** + * Path to template file. This will get combined with the + * application directory to form an absolute path + */ + private final static String DATA_PATH = TEST_COMPARE_DIR + "/ds"; + + /** + * Results relative to the build directory. + */ + private static final String RESULTS_DIR = TEST_RESULT_DIR + "/ds"; + + /** + * Results relative to the build directory. + */ + private static final String COMPARE_DIR = TEST_COMPARE_DIR + "/ds/templates"; + + /* engine with VARCHAR templates data source */ + private RuntimeInstance varcharTemplatesEngine = null; + + /* engine with CLOB templates data source */ + private RuntimeInstance clobTemplatesEngine = null; + + public DataSourceResourceLoaderTestCase(final String name) + throws Exception + { + super(name, DATA_PATH); + } + + public static Test suite() + { + return new TestSuite(DataSourceResourceLoaderTestCase.class); + } + + @Override + public void setUp() + throws Exception + { + + assureResultsDirectoryExists(RESULTS_DIR); + + DataSource ds1 = new TestDataSource(TEST_JDBC_DRIVER_CLASS, TEST_JDBC_URI, TEST_JDBC_LOGIN, TEST_JDBC_PASSWORD); + DataSourceResourceLoader rl1 = new DataSourceResourceLoader(); + rl1.setDataSource(ds1); + + DataSource ds2 = new TestDataSource(TEST_JDBC_DRIVER_CLASS, TEST_JDBC_URI, TEST_JDBC_LOGIN, TEST_JDBC_PASSWORD); + DataSourceResourceLoader rl2 = new DataSourceResourceLoader(); + rl2.setDataSource(ds2); + + ExtProperties props = new ExtProperties(); + props.addProperty( "resource.loader", "ds" ); + props.setProperty( "ds.resource.loader.instance", rl1); + props.setProperty( "ds.resource.loader.resource.table", "velocity_template_varchar"); + props.setProperty( "ds.resource.loader.resource.keycolumn", "vt_id"); + props.setProperty( "ds.resource.loader.resource.templatecolumn", "vt_def"); + props.setProperty( "ds.resource.loader.resource.timestampcolumn", "vt_timestamp"); + props.setProperty(Velocity.RUNTIME_LOG_INSTANCE, new TestLogger(false, false)); + + varcharTemplatesEngine = new RuntimeInstance(); + varcharTemplatesEngine.setConfiguration(props); + varcharTemplatesEngine.init(); + + ExtProperties props2 = (ExtProperties)props.clone(); + props2.setProperty( "ds.resource.loader.instance", rl2); + props2.setProperty( "ds.resource.loader.resource.table", "velocity_template_clob"); + clobTemplatesEngine = new RuntimeInstance(); + clobTemplatesEngine.setConfiguration(props2); + clobTemplatesEngine.init(); + } + + /** + * Tests loading and rendering of a simple template. If that works, we are able to get data + * from the database. + */ + public void testSimpleTemplate() + throws Exception + { + Template t = executeTest("testTemplate1", varcharTemplatesEngine); + assertFalse("Timestamp is 0", 0 == t.getLastModified()); + t = executeTest("testTemplate1", clobTemplatesEngine); + assertFalse("Timestamp is 0", 0 == t.getLastModified()); } + + public void testUnicode(RuntimeInstance engine) + throws Exception + { + Template template = engine.getTemplate(UNICODE_TEMPLATE_NAME); + + Writer writer = new StringWriter(); + VelocityContext context = new VelocityContext(); + template.merge(context, writer); + writer.flush(); + writer.close(); + + String outputText = writer.toString(); + + if (!normalizeNewlines(UNICODE_TEMPLATE).equals( + normalizeNewlines( outputText ) )) + { + fail("Output incorrect for Template: " + UNICODE_TEMPLATE_NAME); + } + } + + /** + * Now we have a more complex example. Run a very simple tool. + * from the database. + */ + public void testRenderTool() + throws Exception + { + Template t = executeTest("testTemplate2", varcharTemplatesEngine); + assertFalse("Timestamp is 0", 0 == t.getLastModified()); + t = executeTest("testTemplate2", clobTemplatesEngine); + assertFalse("Timestamp is 0", 0 == t.getLastModified()); + } + + /** + * Will a NULL timestamp choke the loader? + */ + public void testNullTimestamp() + throws Exception + { + Template t = executeTest("testTemplate3", varcharTemplatesEngine); + assertEquals("Timestamp is not 0", 0, t.getLastModified()); + t = executeTest("testTemplate3", clobTemplatesEngine); + assertEquals("Timestamp is not 0", 0, t.getLastModified()); } + + /** + * Does it load the global Macros from the DB? + */ + public void testMacroInvocation() + throws Exception + { + Template t = executeTest("testTemplate4", varcharTemplatesEngine); + assertFalse("Timestamp is 0", 0 == t.getLastModified()); + t = executeTest("testTemplate4", clobTemplatesEngine); + assertFalse("Timestamp is 0", 0 == t.getLastModified()); + } + + protected Template executeTest(final String templateName, RuntimeInstance engine) + throws Exception + { + Template template = engine.getTemplate(templateName); + + FileOutputStream fos = + new FileOutputStream ( + getFileName(RESULTS_DIR, templateName, RESULT_FILE_EXT)); + + Writer writer = new BufferedWriter(new OutputStreamWriter(fos)); + + VelocityContext context = new VelocityContext(); + context.put("tool", new DSRLTCTool()); + + template.merge(context, writer); + writer.flush(); + writer.close(); + + if (!isMatch(RESULTS_DIR, COMPARE_DIR, templateName, + RESULT_FILE_EXT, CMP_FILE_EXT)) + { + fail("Output incorrect for Template: " + templateName); + } + + return template; + } + + public static final class DSRLTCTool + { + public int add(final int a, final int b) + { + return a + b; + } + + public String getMessage() + { + return "And the result is:"; + } + } +} |