Examples with Time java.sql.Time used on opensource projects

Example 11 with Time

use of java.sql.Time in project hibernate-orm by hibernate.

the class TimeAndTimestampTest method test.

@Test
public void test() {
    doInHibernate(this::sessionFactory, session -> {
        Event event = new Event();
        event.id = 1L;
        event.timeValue = new Time(123);
        event.timestampValue = new Timestamp(456);
        session.persist(event);
    });
    doInHibernate(this::sessionFactory, session -> {
        Event event = session.find(Event.class, 1L);
        assertEquals(123, event.timeValue.getTime() % TimeUnit.DAYS.toMillis(1));
        assertEquals(456, event.timestampValue.getTime() % TimeUnit.DAYS.toMillis(1));
    });
}

Example 12 with Time

use of java.sql.Time in project databus by linkedin.

the class ORListener method orToAvroType.

/**
   * Given a OR Column, it returns a corresponding Java object that can be inserted into
   * AVRO record
 * @param avroField 
   */
private Object orToAvroType(Column s, Field avroField) throws DatabusException {
    if (s instanceof BitColumn) {
        // This is in  byte order
        BitColumn bc = (BitColumn) s;
        byte[] ba = bc.getValue();
        ByteBuffer b = ByteBuffer.wrap(ba);
        return b;
    } else if (s instanceof StringColumn) {
        StringColumn sc = (StringColumn) s;
        String str = new String(sc.getValue(), StringUtils.DEFAULT_CHARSET);
        return str;
    } else if (s instanceof BlobColumn) {
        BlobColumn bc = (BlobColumn) s;
        byte[] ba = bc.getValue();
        //distinguish between blobs and clobs
        try {
            return new String(ba, StringUtils.DEFAULT_CHARSET);
        } catch (Exception e) {
            return ByteBuffer.wrap(ba);
        }
    } else if (s instanceof DateColumn) {
        DateColumn dc = (DateColumn) s;
        Date d = dc.getValue();
        Long l = d.getTime();
        return l;
    } else if (s instanceof DatetimeColumn) {
        DatetimeColumn dc = (DatetimeColumn) s;
        Date d = dc.getValue();
        //Bug in OR for DateTIme and Time data-types. MilliSeconds is not available for these columns but is set with currentMillis() wrongly.
        Long t1 = (d.getTime() / 1000) * 1000;
        return t1;
    } else if (s instanceof DecimalColumn) {
        DecimalColumn dc = (DecimalColumn) s;
        Object val = Double.valueOf(dc.getValue().doubleValue());
        return val;
    } else if (s instanceof DoubleColumn) {
        DoubleColumn dc = (DoubleColumn) s;
        Double d = dc.getValue();
        return d;
    } else if (s instanceof EnumColumn) {
        EnumColumn ec = (EnumColumn) s;
        Integer i = ec.getValue();
        return i;
    } else if (s instanceof FloatColumn) {
        FloatColumn fc = (FloatColumn) s;
        Float f = fc.getValue();
        return f;
    } else if (s instanceof Int24Column) {
        Int24Column ic = (Int24Column) s;
        Integer i = ic.getValue();
        if (i < 0 && SchemaHelper.getMetaField(avroField, "dbFieldType").contains("UNSIGNED")) {
            i += ORListener.MEDIUMINT_MAX_VALUE;
        }
        return i;
    } else if (s instanceof LongColumn) {
        LongColumn lc = (LongColumn) s;
        Long l = lc.getValue().longValue();
        if (l < 0 && SchemaHelper.getMetaField(avroField, "dbFieldType").contains("UNSIGNED")) {
            l += ORListener.INTEGER_MAX_VALUE;
        }
        return l;
    } else if (s instanceof LongLongColumn) {
        LongLongColumn llc = (LongLongColumn) s;
        BigInteger b = new BigInteger(llc.getValue() + "");
        if (b.compareTo(BigInteger.ZERO) < 0 && SchemaHelper.getMetaField(avroField, "dbFieldType").contains("UNSIGNED")) {
            b = b.add(ORListener.BIGINT_MAX_VALUE);
        }
        return b;
    } else if (s instanceof NullColumn) {
        return null;
    } else if (s instanceof SetColumn) {
        SetColumn sc = (SetColumn) s;
        Long l = sc.getValue();
        return l;
    } else if (s instanceof ShortColumn) {
        ShortColumn sc = (ShortColumn) s;
        Integer i = sc.getValue();
        if (i < 0 && SchemaHelper.getMetaField(avroField, "dbFieldType").contains("UNSIGNED")) {
            i = i + ORListener.SMALLINT_MAX_VALUE;
        }
        return i;
    } else if (s instanceof TimeColumn) {
        TimeColumn tc = (TimeColumn) s;
        Time t = tc.getValue();
        /**
       * There is a bug in OR where instead of using the default year as 1970, it is using 0070.
       * This is a temporary measure to resolve it by working around at this layer. The value obtained from OR is subtracted from "0070-00-01 00:00:00"
       */
        Calendar c = Calendar.getInstance();
        c.set(70, 0, 1, 0, 0, 0);
        // round off the milli-seconds as TimeColumn type has only seconds granularity but Calendar implementation
        // includes milli-second (System.currentTimeMillis() at the time of instantiation)
        long rawVal = (c.getTimeInMillis() / 1000) * 1000;
        long val2 = (t.getTime() / 1000) * 1000;
        long offset = val2 - rawVal;
        return offset;
    } else if (s instanceof TimestampColumn) {
        TimestampColumn tsc = (TimestampColumn) s;
        Timestamp ts = tsc.getValue();
        Long t = ts.getTime();
        return t;
    } else if (s instanceof DatetimeColumn) {
        DatetimeColumn tsc = (DatetimeColumn) s;
        Long t = tsc.getValue().getTime();
        return t;
    } else if (s instanceof Datetime2Column) {
        Datetime2Column tsc = (Datetime2Column) s;
        Long t = tsc.getValue().getTime();
        return t;
    } else if (s instanceof TinyColumn) {
        TinyColumn tc = (TinyColumn) s;
        Integer i = tc.getValue();
        if (i < 0 && SchemaHelper.getMetaField(avroField, "dbFieldType").contains("UNSIGNED")) {
            i = i + ORListener.TINYINT_MAX_VALUE;
        }
        return i;
    } else if (s instanceof YearColumn) {
        YearColumn yc = (YearColumn) s;
        Integer i = yc.getValue();
        return i;
    } else {
        throw new DatabusRuntimeException("Unknown MySQL type in the event" + s.getClass() + " Object = " + s);
    }
}

Example 13 with Time

use of java.sql.Time in project generator by mybatis.

the class MyTimeTypeHandler method setParameter.

public void setParameter(PreparedStatement ps, int i, MyTime parameter, JdbcType jdbcType) throws SQLException {
    if (parameter == null) {
        ps.setNull(i, jdbcType.TYPE_CODE);
    } else {
        Calendar c = Calendar.getInstance();
        c.set(Calendar.HOUR_OF_DAY, parameter.getHours());
        c.set(Calendar.MINUTE, parameter.getMinutes());
        c.set(Calendar.SECOND, parameter.getSeconds());
        Time time = new Time(c.getTime().getTime());
        ps.setTime(i, time);
    }
}

Example 14 with Time

use of java.sql.Time in project generator by mybatis.

the class MyTimeTypeHandler method getResult.

public MyTime getResult(ResultSet rs, String columnName) throws SQLException {
    MyTime answer = null;
    Time time = rs.getTime(columnName);
    if (time != null) {
        answer = new MyTime();
        Calendar c = Calendar.getInstance();
        c.setTime(time);
        answer.setHours(c.get(Calendar.HOUR_OF_DAY));
        answer.setMinutes(c.get(Calendar.MINUTE));
        answer.setSeconds(c.get(Calendar.SECOND));
    }
    return answer;
}

Example 15 with Time

use of java.sql.Time in project generator by mybatis.

the class MyTimeTypeHandler method setParameter.

public void setParameter(ParameterSetter parameterSetter, Object value) throws SQLException {
    if (value == null) {
        parameterSetter.setNull(Types.TIME);
    } else {
        MyTime myTime = (MyTime) value;
        Calendar c = Calendar.getInstance();
        c.set(Calendar.HOUR_OF_DAY, myTime.getHours());
        c.set(Calendar.MINUTE, myTime.getMinutes());
        c.set(Calendar.SECOND, myTime.getSeconds());
        Time time = new Time(c.getTime().getTime());
        parameterSetter.setTime(time);
    }
}