ClickHouse

1
#include <Core/Field.h>
2
#include <DataTypes/DataTypeDate.h>
3
#include <Functions/FunctionFactory.h>
4
#include <Functions/IFunction.h>
5
#include <Common/DateLUT.h>
6
#include <Common/DateLUTImpl.h>
7

8

9
namespace DB
10
{
11

12
class ExecutableFunctionYesterday : public IExecutableFunction
13
{
14
public:
15
    explicit ExecutableFunctionYesterday(time_t time_) : day_value(time_) {}
16

17
    String getName() const override { return "yesterday"; }
18

19
    ColumnPtr executeImpl(const ColumnsWithTypeAndName &, const DataTypePtr &, size_t input_rows_count) const override
20
    {
21
        return DataTypeDate().createColumnConst(input_rows_count, day_value);
22
    }
23

24
private:
25
    DayNum day_value;
26
};
27

28
class FunctionBaseYesterday : public IFunctionBase
29
{
30
public:
31
    explicit FunctionBaseYesterday(DayNum day_value_) : day_value(day_value_), return_type(std::make_shared<DataTypeDate>()) {}
32

33
    String getName() const override { return "yesterday"; }
34

35
    const DataTypes & getArgumentTypes() const override
36
    {
37
        static const DataTypes argument_types;
38
        return argument_types;
39
    }
40

41
    const DataTypePtr & getResultType() const override
42
    {
43
        return return_type;
44
    }
45

46
    ExecutableFunctionPtr prepare(const ColumnsWithTypeAndName &) const override
47
    {
48
        return std::make_unique<ExecutableFunctionYesterday>(day_value);
49
    }
50

51
    bool isDeterministic() const override { return false; }
52
    bool isSuitableForShortCircuitArgumentsExecution(const DataTypesWithConstInfo & /*arguments*/) const override { return false; }
53

54
private:
55
    DayNum day_value;
56
    DataTypePtr return_type;
57
};
58

59
class YesterdayOverloadResolver : public IFunctionOverloadResolver
60
{
61
public:
62
    static constexpr auto name = "yesterday";
63

64
    String getName() const override { return name; }
65

66
    bool isDeterministic() const override { return false; }
67

68
    size_t getNumberOfArguments() const override { return 0; }
69

70
    static FunctionOverloadResolverPtr create(ContextPtr) { return std::make_unique<YesterdayOverloadResolver>(); }
71

72
    DataTypePtr getReturnTypeImpl(const DataTypes &) const override { return std::make_shared<DataTypeDate>(); }
73

74
    FunctionBasePtr buildImpl(const ColumnsWithTypeAndName &, const DataTypePtr &) const override
75
    {
76
        auto day_num = DateLUT::instance().toDayNum(time(nullptr)) - 1;
77
        return std::make_unique<FunctionBaseYesterday>(static_cast<DayNum>(day_num));
78
    }
79
};
80

81
REGISTER_FUNCTION(Yesterday)
82
{
83
    factory.registerFunction<YesterdayOverloadResolver>();
84
}
85

86
}
87