Refine search
private static Object convertDateValue(final Object value, final Class<?> convertType) { Date date = (Date) value; switch (convertType.getName()) { case "java.sql.Date": return new java.sql.Date(date.getTime()); case "java.sql.Time": return new Time(date.getTime()); case "java.sql.Timestamp": return new Timestamp(date.getTime()); default: throw new ShardingException("Unsupported Date type:%s", convertType); } } }
@Test public void testSetParameterValueWithTimeAndUtilDate() throws SQLException { java.util.Date date = new java.util.Date(1000); StatementCreatorUtils.setParameterValue(preparedStatement, 1, Types.TIME, null, date); verify(preparedStatement).setTime(1, new java.sql.Time(1000)); }
exprs.addAll(projections.date($(entity.getDate()), $(entity.getDate()), new java.sql.Date(0))); exprs.addAll(matchers.date($(entity.getDate()), $(entity.getDate()), new java.sql.Date(0))); exprs.addAll(filters.date($(entity.getDate()), $(entity.getDate()), new java.sql.Date(0))); exprs.addAll(projections.dateTime($(entity.getDateTime()), $(entity.getDateTime()), new java.util.Date(0))); exprs.addAll(matchers.dateTime($(entity.getDateTime()), $(entity.getDateTime()), new java.util.Date(0))); exprs.addAll(filters.dateTime($(entity.getDateTime()), $(entity.getDateTime()), new java.util.Date(0))); exprs.addAll(projections.time($(entity.getTime()), $(entity.getTime()), new java.sql.Time(0))); exprs.addAll(matchers.time($(entity.getTime()), $(entity.getTime()), new java.sql.Time(0))); exprs.addAll(filters.time($(entity.getTime()), $(entity.getTime()), new java.sql.Time(0)));
try { if (java.sql.Date.class.equals(type)) { return new java.sql.Date(convertTimestamp2TimeMillis(value.toString())); } else if (java.sql.Time.class.equals(type)) { return new java.sql.Time(convertTimestamp2TimeMillis(value.toString())); } else if (Timestamp.class.equals(type)) { return new Timestamp(convertTimestamp2TimeMillis(value.toString())); } else { return new Timestamp(convertTimestamp2TimeMillis(value.toString()));
public static void main(String[] args) { java.sql.Time time = new java.sql.Time(System.currentTimeMillis()); java.sql.Timestamp ts = new java.sql.Timestamp(System.currentTimeMillis()); System.out.println(String.format("%tc", time)); System.out.println(String.format("%tc", ts)); System.out.println(String.format("%Tc", time)); System.out.println(String.format("%Tc", ts)); }
@SuppressWarnings({ "unchecked" }) public <X> X unwrap(Calendar value, Class<X> type, WrapperOptions options) { if ( value == null ) { return null; } if ( Calendar.class.isAssignableFrom( type ) ) { return (X) value; } if ( java.sql.Date.class.isAssignableFrom( type ) ) { return (X) new java.sql.Date( value.getTimeInMillis() ); } if ( java.sql.Time.class.isAssignableFrom( type ) ) { return (X) new java.sql.Time( value.getTimeInMillis() ); } if ( java.sql.Timestamp.class.isAssignableFrom( type ) ) { return (X) new java.sql.Timestamp( value.getTimeInMillis() ); } if ( Date.class.isAssignableFrom( type ) ) { return (X) new Date( value.getTimeInMillis() ); } throw unknownUnwrap( type ); }
@Test public void testTime() throws Exception { AccumuloRowSerializer serializer = serializerClass.getConstructor().newInstance(); Type type = TIME; Time expected = new Time(new java.util.Date().getTime()); byte[] data = serializer.encode(type, expected); Time actual = new Time(serializer.decode(type, data)); assertEquals(actual, expected); deserializeData(serializer, data); actual = serializer.getTime(COLUMN_NAME); assertEquals(actual, expected); }
/** {@inheritDoc} */ @Override protected void beforeTestsStarted() throws Exception { startGridsMultiThreaded(3); IgniteCache<Integer, TestObject> cache = grid(0).cache(DEFAULT_CACHE_NAME); assert cache != null; TestObject o = new TestObject(1); o.boolVal = true; o.byteVal = 1; o.shortVal = 1; o.intVal = 1; o.longVal = 1L; o.floatVal = 1.0f; o.doubleVal = 1.0d; o.bigVal = new BigDecimal(1); o.strVal = "str"; o.arrVal = new byte[] {1}; o.dateVal = new Date(1); o.timeVal = new Time(1); o.tsVal = new Timestamp(1); o.urlVal = new URL("http://abc.com/"); cache.put(1, o); cache.put(2, new TestObject(2)); }
protected void addCriterionForJDBCTime(String condition, Date value1, Date value2, String property) { if (value1 == null || value2 == null) { throw new RuntimeException("Between values for " + property + " cannot be null"); } addCriterion(condition, new java.sql.Time(value1.getTime()), new java.sql.Time(value2.getTime()), property); }
@Test public void testArraysOfTimes() throws Exception { Session s = openSession(); s.beginTransaction(); Baz baz = new Baz() ; s.save(baz); baz.setDefaults(); s.getTransaction().commit(); s.close(); s = openSession(); s.beginTransaction(); baz.getTimeArray()[2] = new Date(123); baz.getTimeArray()[3] = new java.sql.Time(1234); s.getTransaction().commit(); s.close(); s = openSession(); s.beginTransaction(); baz = (Baz) s.load( Baz.class, baz.getCode() ); s.delete( baz ); s.getTransaction().commit(); s.close(); }
@Test public void test() { doInHibernate( this::sessionFactory, session -> { Event event = new Event(); event.id = 1L; event.timeValue = new Time( 1000 ); event.timestampValue = new Timestamp( 45678 ); session.persist( event ); } ); doInHibernate( this::sessionFactory, session -> { Event event = session.find( Event.class, 1L ); assertEquals(1000, event.timeValue.getTime() % TimeUnit.DAYS.toMillis( 1 )); assertEquals(45678, event.timestampValue.getTime() % TimeUnit.DAYS.toMillis( 1 )); } ); }
@SuppressWarnings({ "unchecked" }) public <X> X unwrap(Calendar value, Class<X> type, WrapperOptions options) { if ( value == null ) { return null; } if ( Calendar.class.isAssignableFrom( type ) ) { return (X) value; } if ( java.sql.Date.class.isAssignableFrom( type ) ) { return (X) new java.sql.Date( value.getTimeInMillis() ); } if ( java.sql.Time.class.isAssignableFrom( type ) ) { return (X) new java.sql.Time( value.getTimeInMillis() ); } if ( java.sql.Timestamp.class.isAssignableFrom( type ) ) { return (X) new java.sql.Timestamp( value.getTimeInMillis() ); } if ( Date.class.isAssignableFrom( type ) ) { return (X) new Date( value.getTimeInMillis() ); } throw unknownUnwrap( type ); }
@Test public void writeWithDateFieldWithTimeWithTimezoneTypeFromMetaData() throws Exception { String fieldName = "fieldName"; Date fieldValue = new Date(); Object expectedValueWritten = new java.sql.Time(fieldValue.getTime()); int dataType = Types.TIME_WITH_TIMEZONE; when(tableMetaDataView.getColumnDataType(fieldName)).thenReturn(dataType); when(regionMapping.getColumnNameForField(eq(fieldName), any())).thenReturn(fieldName); when(value.getFieldNames()).thenReturn(Arrays.asList(fieldName)); when(value.getField(fieldName)).thenReturn(fieldValue); when(statement.executeUpdate()).thenReturn(1); Object createKey = "createKey"; handler.write(region, Operation.CREATE, createKey, value); verify(statement).setObject(1, expectedValueWritten); verify(statement).setObject(2, createKey); verify(statement).close(); }
/** {@inheritDoc} */ @Override protected void beforeTestsStarted() throws Exception { startGridsMultiThreaded(3); IgniteCache<Integer, TestObject> cache = grid(0).cache(DEFAULT_CACHE_NAME); assert cache != null; TestObject o = new TestObject(1); o.boolVal = true; o.byteVal = 1; o.shortVal = 1; o.intVal = 1; o.longVal = 1L; o.floatVal = 1.0f; o.doubleVal = 1.0d; o.bigVal = new BigDecimal(1); o.strVal = "str"; o.arrVal = new byte[] {1}; o.blobVal = new byte[] {1}; o.dateVal = new Date(1); o.timeVal = new Time(1); o.tsVal = new Timestamp(1); o.urlVal = new URL("http://abc.com/"); cache.put(1, o); cache.put(2, new TestObject(2)); }
@Override void deserialize(AbstractHessianInput in, Object obj) throws IOException { java.sql.Time value = null; try { java.util.Date date = (java.util.Date) in.readObject(); if (date != null) value = new java.sql.Time(date.getTime()); _field.set(obj, value); } catch (Exception e) { logDeserializeError(_field, obj, value, e); } } }