flink定时器实现订单自动好评

正常开发环境数据流转为

数据库 --通过canal实时采集--> kafka --> flink实时计算 --> 数据库

本文为了测试方便，将数据流转更改为

数据库 --> flink实时计算 --> 数据库

1.测试数据

-- ----------------------------
-- Table structure for torder
-- ----------------------------
DROP TABLE IF EXISTS `torder`;
CREATE TABLE `torder`  (
  `orderid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ordertime` bigint(20) DEFAULT NULL,
  `orderreview` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `orderstate` int(8) DEFAULT NULL,
  PRIMARY KEY (`orderid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of torder
-- ----------------------------
INSERT INTO `torder` VALUES ('018ffeb2-7ebe-4dad-b29e-add4e79260ed', 1611626060628, '无', 0);
INSERT INTO `torder` VALUES ('02bd0f7c-4cac-4b91-be7e-6eb6f3fec969', 1611626074635, '无', 0);
INSERT INTO `torder` VALUES ('03011113-25a3-4956-acd9-1d3630c4777e', 1611626057627, '无', 0);
INSERT INTO `torder` VALUES ('0408d88f-3254-42c8-9079-f9dabfe98ca6', 1611626070632, '无', 0);
INSERT INTO `torder` VALUES ('05de50bf-12c2-4887-ae6b-bbde3085d0d9', 1611626113656, '无', 0);
INSERT INTO `torder` VALUES ('064b5cf7-6c7b-4822-8012-a653d3e5c79c', 1611626099649, '无', 0);
INSERT INTO `torder` VALUES ('09d9e8aa-276f-4ba1-aea3-fd80042f0b5a', 1611626103651, '无', 0);
INSERT INTO `torder` VALUES ('0a838c02-ba03-406a-9c40-d0d53895781b', 1611626058628, '无', 0);
INSERT INTO `torder` VALUES ('0be872f8-01fc-4d7c-9682-95e38fad0308', 1611626053624, '无', 0);
INSERT INTO `torder` VALUES ('0cb1f712-6691-4d16-89f8-dd3ba5d7ed4d', 1611626081639, '无', 0);
INSERT INTO `torder` VALUES ('10049263-1cb2-45d5-a887-6289aa9cd706', 1611626090643, '无', 0);
INSERT INTO `torder` VALUES ('10b6e6a0-eefb-492f-8e17-550d3623be0f', 1611626111655, '无', 0);
INSERT INTO `torder` VALUES ('1101393f-0000-476e-b875-de15c91e3c99', 1611626080638, '无', 0);
INSERT INTO `torder` VALUES ('114d15cf-75e5-4925-8c95-943ccf9f748c', 1611626115657, '无', 0);
INSERT INTO `torder` VALUES ('126eaaec-e49a-40a5-9755-3937ef45f3f9', 1611626094647, '无', 0);
INSERT INTO `torder` VALUES ('12e7bd68-d2d1-43a4-891b-70611d88bb68', 1611626062628, '无', 0);
INSERT INTO `torder` VALUES ('13df9483-e6d2-488f-9a4c-7b945723845f', 1611626111655, '无', 0);
INSERT INTO `torder` VALUES ('14435e3e-1b5d-43a3-8705-97304f2a8d80', 1611626058628, '无', 0);
INSERT INTO `torder` VALUES ('157c680c-40fc-4e9f-80a3-a7dc3864a387', 1611626072634, '无', 0);
INSERT INTO `torder` VALUES ('16782d32-7f48-44f6-9666-ab5316508d86', 1611626067631, '无', 0);
INSERT INTO `torder` VALUES ('1909c1c1-aac7-4b61-86c5-5cd4ed913ff9', 1611626081639, '无', 0);
INSERT INTO `torder` VALUES ('19283a3c-57c2-4dc9-91a1-33c0699a2db2', 1611626079638, '无', 0);
INSERT INTO `torder` VALUES ('1a2338a5-c014-497e-a6df-1470ae4c8b31', 1611626108653, '无', 0);
INSERT INTO `torder` VALUES ('1b1d9a8c-fe4b-4e61-a20c-5f16fd8fc404', 1611626077637, '无', 0);
INSERT INTO `torder` VALUES ('1b888529-ced3-44ec-9d02-fdd4ea7b08f2', 1611626095647, '无', 0);
INSERT INTO `torder` VALUES ('1ce74e17-b83f-478f-a476-7664aa262740', 1611626098648, '无', 0);
INSERT INTO `torder` VALUES ('1d111238-ec0d-486c-b8bc-e3329a2f17b7', 1611626106653, '无', 0);
INSERT INTO `torder` VALUES ('1f698c02-e463-4e4f-b4c0-6d837c110012', 1611626092645, '无', 0);
INSERT INTO `torder` VALUES ('2072424d-9a0c-4482-9ba9-35feaa6fef73', 1611626086642, '无', 0);
INSERT INTO `torder` VALUES ('20bc0e69-3209-472e-a963-9e367dd35207', 1611626080638, '无', 0);
INSERT INTO `torder` VALUES ('21510d73-410e-40bc-a335-294dad9cd475', 1611626092646, '无', 0);
INSERT INTO `torder` VALUES ('22768d54-a752-4171-acc5-71595955eb08', 1611626091644, '无', 0);
INSERT INTO `torder` VALUES ('22c2e658-e1f8-49ed-a43c-51857ef4a679', 1611626070632, '无', 0);
INSERT INTO `torder` VALUES ('24b96afa-c196-47f0-8e7c-07feeb7afeeb', 1611626108653, '无', 0);
INSERT INTO `torder` VALUES ('26888908-17c7-4b1b-8303-c3ade7ba40a9', 1611626097648, '无', 0);
INSERT INTO `torder` VALUES ('272f8beb-20e2-4227-8f4d-554325854972', 1611626054625, '无', 0);
INSERT INTO `torder` VALUES ('27546f7e-617f-4033-8e11-bfd955d889e9', 1611626099649, '无', 0);
INSERT INTO `torder` VALUES ('28e663d2-f230-4f0e-98da-ed9e0269b8f6', 1611626078637, '无', 0);
INSERT INTO `torder` VALUES ('2980bef1-b94b-43ef-a549-b4bb1084e742', 1611626072634, '无', 0);
INSERT INTO `torder` VALUES ('2a57c72f-124d-4c11-ac1b-1a0942285061', 1611626103651, '无', 0);
INSERT INTO `torder` VALUES ('2db33049-b012-4750-ad58-6dafb55e98ae', 1611626074635, '无', 0);
INSERT INTO `torder` VALUES ('2f5ceb8b-4323-4d38-a44e-6982480b8c45', 1611626091645, '无', 0);
INSERT INTO `torder` VALUES ('2fb4119c-735a-42c1-ae5f-09d65832a469', 1611626072634, '无', 0);
INSERT INTO `torder` VALUES ('321e8fb1-2435-4fc1-bbee-2937e89753d1', 1611626112655, '无', 0);
INSERT INTO `torder` VALUES ('336e16e8-f381-494a-993a-27ded5aa607c', 1611626060628, '无', 0);
INSERT INTO `torder` VALUES ('369618a4-5bb2-4770-aaff-b0df0baf3a52', 1611626112655, '无', 0);
INSERT INTO `torder` VALUES ('37f8c062-2d82-49af-9cfe-5e03de93191f', 1611626056626, '无', 0);
INSERT INTO `torder` VALUES ('3952a7a7-8eb5-48e6-9d9a-1a2c615ad8b0', 1611626050623, '无', 0);
INSERT INTO `torder` VALUES ('397e838