Java tutorial
/* * Licensed to CRATE Technology GmbH ("Crate") under one or more contributor * license agreements. See the NOTICE file distributed with this work for * additional information regarding copyright ownership. Crate 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. * * However, if you have executed another commercial license agreement * with Crate these terms will supersede the license and you may use the * software solely pursuant to the terms of the relevant commercial agreement. */ package io.crate.expression.scalar; import com.google.common.collect.ImmutableMap; import io.crate.expression.symbol.Literal; import io.crate.expression.symbol.Symbol; import io.crate.types.DataTypes; import org.apache.lucene.util.BytesRef; import org.junit.Test; import java.util.Locale; import java.util.Map; import static io.crate.testing.SymbolMatchers.isLiteral; public class DateFormatFunctionTest extends AbstractScalarFunctionsTest { @Test public void testNormalizeDefault() throws Exception { assertNormalize("date_format('1970-01-01T00:00:00')", isLiteral("1970-01-01T00:00:00.000000Z")); } @Test public void testNormalizeDefaultTimezone() throws Exception { assertNormalize("date_format('%d.%m.%Y', '1970-02-01')", isLiteral("01.02.1970")); } @Test public void testNormalizeWithTimezone() throws Exception { assertNormalize("date_format('%d.%m.%Y %T', 'Europe/Rome', '1970-01-01T00:00:00')", isLiteral("01.01.1970 01:00:00")); } @Test public void testEvaluateWithNullValues() throws Exception { assertEvaluate("date_format('%d.%m.%Y %H:%i:%S', timestamp)", null, Literal.of(DataTypes.TIMESTAMP, null)); assertEvaluate("date_format(name, 'Europe/Berlin', 0)", null, Literal.of(DataTypes.STRING, null)); } @Test public void testEvaluateDefault() throws Exception { assertEvaluate("date_format(timestamp)", new BytesRef("2015-06-10T07:03:00.004000Z"), Literal.of(DataTypes.TIMESTAMP, DataTypes.TIMESTAMP.value("2015-06-10T09:03:00.004+02"))); } @Test public void testEvaluateDefaultTimezone() throws Exception { assertEvaluate("date_format(time_format, timestamp)", new BytesRef("Fri Jan 1 1st 01 1 000000 00 12 12 00 001 0 12 January 01 AM 12:00:00 AM " + "00 00 00:00:00 00 00 52 53 Friday 5 2054 2054 2055 55"), Literal.of("%a %b %c %D %d %e %f %H %h %I %i %j %k %l %M %m %p %r " + "%S %s %T %U %u %V %v %W %w %X %x %Y %y"), Literal.of(DataTypes.TIMESTAMP, DataTypes.TIMESTAMP.value("2055-01-01"))); } @Test public void testEvaluateWithTimezone() throws Exception { assertEvaluate("date_format(time_format, timezone, timestamp)", new BytesRef("Sun Jan 1 1st 01 1 000000 04 04 04 00 001 4 4 January 01 AM 04:00:00 AM " + "00 00 04:00:00 01 00 01 52 Sunday 0 1871 1870 1871 71"), Literal.of("%a %b %c %D %d %e %f %H %h %I %i %j %k %l %M %m %p %r " + "%S %s %T %U %u %V %v %W %w %X %x %Y %y"), Literal.of("EST"), Literal.of(DataTypes.TIMESTAMP, DataTypes.TIMESTAMP.value("1871-01-01T09:00:00.000Z"))); } @Test public void testNullInputs() throws Exception { assertEvaluate("date_format(time_format, timezone, timestamp)", null, Literal.of("%d.%m.%Y %H:%i:%S"), Literal.of(DataTypes.STRING, null), Literal.of(DataTypes.TIMESTAMP, null)); assertEvaluate("date_format(time_format, timezone, timestamp)", null, Literal.of(DataTypes.STRING, null), Literal.of("Europe/Berlin"), Literal.of(DataTypes.TIMESTAMP, 0L)); } @Test public void testInvalidTimeZone() throws Exception { expectedException.expect(IllegalArgumentException.class); expectedException.expectMessage("invalid time zone value 'wrong timezone'"); assertEvaluate("date_format('%d.%m.%Y', 'wrong timezone', 0)", null); } @Test public void testInvalidTimestamp() throws Exception { expectedException.expect(IllegalArgumentException.class); expectedException.expectMessage("Invalid format: \"NO TIMESTAMP\""); assertEvaluate("date_format('%d.%m.%Y', 'NO TIMESTAMP')", null); } @Test public void testMySQLCompatibilityForWeeks() throws Exception { Map<String, Map<String, String>> dateToInputOutputMap = ImmutableMap.<String, Map<String, String>>builder() .put("1970-01-30", ImmutableMap.<String, String>builder().put("%u", "05").put("%U", "04").put("%v", "05") .put("%V", "04").put("%x", "1970").put("%X", "1970").build()) .put("1996-01-01", ImmutableMap.of("%X %V", "1995 53", "%x %v", "1996 01", "%u", "01", "%U", "00")) .put("2000-01-01", ImmutableMap.<String, String>builder().put("%u", "00").put("%U", "00").put("%v", "52") .put("%V", "52").put("%x", "1999").put("%X", "1999").build()) .put("2004-01-01", ImmutableMap.<String, String>builder().put("%u", "01").put("%U", "00").put("%v", "01") .put("%V", "52").put("%x", "2004").put("%X", "2003").build()) .put("2008-02-20", ImmutableMap.<String, String>builder().put("%u", "08").put("%U", "07").put("%v", "08") .put("%V", "07").put("%x", "2008").put("%X", "2008").build()) .put("2008-12-31", ImmutableMap.<String, String>builder().put("%u", "53").put("%U", "52").put("%v", "01") .put("%V", "52").put("%x", "2009").put("%X", "2008").build()) .put("2009-01-01", ImmutableMap.<String, String>builder().put("%u", "01").put("%U", "00") .put("%v", "01").put("%V", "52").put("%x", "2009").put("%X", "2008").build()) .build(); for (Map.Entry<String, Map<String, String>> entry : dateToInputOutputMap.entrySet()) { for (Map.Entry<String, String> ioEntry : entry.getValue().entrySet()) { Symbol result = sqlExpressions.normalize(sqlExpressions.asSymbol(String.format(Locale.ENGLISH, "date_format('%s', '%s')", ioEntry.getKey(), entry.getKey()))); assertThat(String.format(Locale.ENGLISH, "Format String '%s' returned wrong result for date '%s'", ioEntry.getKey(), entry.getKey()), result, isLiteral(ioEntry.getValue())); } } } @Test public void testEvaluateUTF8Support() throws Exception { assertEvaluate("date_format(time_format, timestamp)", "200001\uD834\uDD1E01 00:00:00", Literal.of("%Y%m\uD834\uDD1E%d %H:%i:%S"), Literal.of(DataTypes.TIMESTAMP, DataTypes.TIMESTAMP.value("2000-01-01"))); } @Test public void testInvalidFormats() throws Exception { assertEvaluate("date_format(time_format, timestamp)", "t%Z", Literal.of("%t%%%Z"), Literal.of(DataTypes.TIMESTAMP, DataTypes.TIMESTAMP.value("2000-01-01"))); } }