C++ (Cpp) ObExprObj::set_precise_datetime 예제들

예제 #1

파일: ob_obj_cast.cpp 프로젝트: b-xiang/sql_parser-1

 static int bool_pdatetime(const ObObjCastParams &params, const ObExprObj &in, ObExprObj &out)
 {
     UNUSED(params);
     OB_ASSERT(in.get_type() == ObBoolType);
     out.set_precise_datetime(static_cast<ObPreciseDateTime> (in.get_bool()));
     return OB_SUCCESS;
 }

예제 #2

파일: ob_obj_cast_test.cpp 프로젝트: sharpglasses/oceanbase

TEST_F(ObObjCastTest, precise_datetime_to_xxx)
{
    ObExprObj in;
    const char* cases_str[] = {"1970-1-1 8:0:0", "1970-1-1 0:0:0", "2012-9-24 16:59:60"};
    int64_t cases[ARRAYSIZEOF(cases_str)];
    const char *varchar_expected[] = {"1970-01-01 08:00:00.000000", "1970-01-01 00:00:00.000000", "2012-09-24 17:00:00.000000"};
    const char *dec_expected[] = {"0", "-28800000000", "1348477200000000"};
    for (int64_t i = 0; i < static_cast<int64_t>(ARRAYSIZEOF(cases)); ++i)
    {
        struct tm tm;
        memset(&tm, 0, sizeof(tm));
        strptime(cases_str[i], "%Y-%m-%d %H:%M:%S", &tm);
        cases[i] = mktime(&tm) * 1000000L;
        int64_t v = cases[i];
        int64_t pv = v / 1000000L;
        in.set_precise_datetime(v);

        MY_EXPECT(ObPreciseDateTimeType, in, ObNullType, v, varchar_expected[i]);
        MY_EXPECT(ObPreciseDateTimeType, in, ObIntType, v, varchar_expected[i]);
        MY_EXPECT(ObPreciseDateTimeType, in, ObFloatType, v, varchar_expected[i]);
        MY_EXPECT(ObPreciseDateTimeType, in, ObDoubleType, v, varchar_expected[i]);
        MY_EXPECT(ObPreciseDateTimeType, in, ObDateTimeType, pv, varchar_expected[i]);
        MY_EXPECT(ObPreciseDateTimeType, in, ObPreciseDateTimeType, v, varchar_expected[i]);
        MY_EXPECT(ObPreciseDateTimeType, in, ObVarcharType, v, varchar_expected[i]);
        MY_EXPECT(ObPreciseDateTimeType, in, ObSeqType, v, varchar_expected[i]);
        MY_EXPECT(ObPreciseDateTimeType, in, ObCreateTimeType, v, varchar_expected[i]);
        MY_EXPECT(ObPreciseDateTimeType, in, ObModifyTimeType, v, varchar_expected[i]);
        MY_EXPECT(ObPreciseDateTimeType, in, ObExtendType, v, varchar_expected[i]);
        MY_EXPECT(ObPreciseDateTimeType, in, ObBoolType, v, varchar_expected[i]);
        MY_EXPECT(ObPreciseDateTimeType, in, ObDecimalType, v, dec_expected[i]);
    }
}

예제 #3

파일: ob_obj_cast.cpp 프로젝트: b-xiang/sql_parser-1

 static int varchar_pdatetime(const ObObjCastParams &params, const ObExprObj &in, ObExprObj &out)
 {
     int ret = OB_SUCCESS;
     UNUSED(params);
     OB_ASSERT(in.get_type() == ObVarcharType);
     int64_t timestamp = 0;
     ret = varchar_timestamp(in, timestamp);
     if (OB_SUCCESS == ret)
     {
         out.set_precise_datetime(static_cast<ObPreciseDateTime> (timestamp));
     }
     else
     {
         const string& varchar = in.get_varchar();
         jlog(WARNING, "failed to convert string `%.*s' to precise_datetime type",
                 varchar.length(), varchar.data());
         out.set_precise_datetime(static_cast<ObPreciseDateTime> (0));
         ret = OB_SUCCESS;
     }
     return ret;
 }

예제 #4

파일: ob_obj_cast.cpp 프로젝트: b-xiang/sql_parser-1

 static int decimal_pdatetime(const ObObjCastParams &params, const ObExprObj &in, ObExprObj &out)
 {
     int ret = OB_SUCCESS;
     UNUSED(params);
     OB_ASSERT(in.get_type() == ObDecimalType);
     int64_t i64 = 0;
     if (OB_SUCCESS != (ret = in.get_decimal().cast_to_int64(i64)))
     {
         jlog(WARNING, "failed to cast to int64, err=%d", ret);
     }
     else
     {
         out.set_precise_datetime(static_cast<ObPreciseDateTime> (i64));
     }
     return ret;
 }