datetime

简介

校验参数值是否为日期时间格式

示例

数据字典

hrm.sys_tasks 人力资源系统 - 系统任务表

列名	数据类型	非空	自增	键	描述
id	int(11)	是	是	主键	-
title	varchar(255)	是	-	-	任务标题
completed	tinyint(1)	-	-	-	任务是否完成
start_time	datetime	-	-	-	任务开始时间
end_time	datetime	-	-	-	任务结束时间

• 创建 hrm.sys_tasks 任务表

  DROP TABLE IF EXISTS hrm.sys_tasks;
  CREATE TABLE hrm.sys_tasks
  (
      id         INT PRIMARY KEY AUTO_INCREMENT,
      title      VARCHAR(255) NOT NULL,
      completed  BOOLEAN COMMENT '0未完成 1完成 data_type=bool',
      start_time DATETIME,
      end_time   DATETIME
  );

表中，start_time和end_time 字段是日期时间类型，需要遵守日期时间类型规范。

请求

POST http://127.0.0.1:21000
Content-Type: application/json;charset=utf-8

{
  "jsonrpc": "2.0",
  "method": "hrm.sysTasks.add",
  "params": {
    "title": "testing datatime type",
    "completed": 1,
    "startTime": "2023-11-41 08:00",
    "endTime": "2023-11-41 08:00"
  },
  "id": "client-unique-request-id"
}

响应

从响应结果可见，luwak报错提示上述startTime和endTime字段的值不符合日期类型格式规范，拒绝操作。

HTTP/1.1 400 Bad Request
Content-Type: application/json; charset=utf-8

{
  "jsonrpc": "2.0",
  "error": {
    "code": -32602,
    "message": "validating data type: endTime: 2023-11-41 08:00 does not validate as datetime;startTime: 2023-11-41 08:00 does not validate as datetime",
    "data": {
      "errorCode": "EU.Validator.DataTypeError",
      "errorDetails": [
        {
          "field": "startTime",
          "fieldValue": "2023-11-41 08:00",
          "location": "hrm.sys_tasks",
          "message": "startTime: 2023-11-41 08:00 does not validate as datetime",
          "validator": "datetime"
        },
        {
          "field": "endTime",
          "fieldValue": "2023-11-41 08:00",
          "location": "hrm.sys_tasks",
          "message": "endTime: 2023-11-41 08:00 does not validate as datetime",
          "validator": "datetime"
        }
      ],
      "errorMessage": "endTime: 2023-11-41 08:00 does not validate as datetime;startTime: 2023-11-41 08:00 does not validate as datetime"
    }
  },
  "id": "client-unique-request-id"
}

备注: 以上示例在Luwak 1.12.9测试通过。