产品信息扩展表数据更新及缓存清除

INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('diamond_changx_vip_monthly', 'AppId', 'C10000019615', 10); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('diamond_changx_vip_monthly', 'PayCode', 'P5000000000627', 11); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('diamond_changx_vip_1month', 'AppId', 'C10000019615', 8); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('diamond_changx_vip_1month', 'PayCode', 'P5000000000626', 9); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('gold_changx_vip_6month', 'AppId', 'C10000019615', 8); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('gold_changx_vip_6month', 'PayCode', 'P5000000000625', 9); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('gold_changx_vip_monthly', 'AppId', 'C10000019615', 10); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('gold_changx_vip_monthly', 'PayCode', 'P5000000000624', 11); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('gold_changx_vip_1month', 'AppId', 'C10000019615', 8); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('gold_changx_vip_1month', 'PayCode', 'P5000000000623', 9); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('silver_changx_vip_6month', 'AppId', 'C10000019615', 8); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('silver_changx_vip_6month', 'PayCode', 'P5000000000622', 9); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('silver_changx_vip_monthly', 'AppId', 'C10000019615', 10); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('silver_changx_vip_monthly', 'PayCode', 'P5000000000621', 11); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('silver_changx_vip_1month', 'AppId', 'C10000019615', 8); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('silver_changx_vip_1month', 'PayCode', 'P5000000000620', 9); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('changying_svip_1month', 'AppId', 'C10000019619', 7); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('changying_svip_1month', 'PayCode', 'P5000000000661', 8); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('changying_vip_5_monthly', 'AppId', 'C10000019619', 9); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('changying_vip_5_monthly', 'PayCode', 'P5000000000663', 10); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('changying_vip_8_monthly', 'AppId', 'C10000019619', 9); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('changying_vip_8_monthly', 'PayCode', 'P5000000000680', 10); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('changying_vip_1month', 'AppId', 'C10000019619', 7); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('changying_vip_1month', 'PayCode', 'P5000000000660', 8); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('changying_vip_3_monthly', 'AppId', 'C10000019619', 9); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('changying_vip_3_monthly', 'PayCode', 'P5000000000662', 10); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('changying_vip_10_monthly', 'AppId', 'C10000019619', 9); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('changying_vip_10_monthly', 'PayCode', 'P5000000000664', 10); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('pp_park_vip_10_monthly', 'AppId', 'C10000019621', 8); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('pp_park_vip_10_monthly', 'PayCode', 'P5000000000683', 9); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('one_park_vip_8_monthly', 'AppId', 'C10000019622', 8); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('one_park_vip_8_monthly', 'PayCode', 'P5000000000687', 9); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('one_park_vip_20_monthly', 'AppId', 'C10000019622', 8); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('one_park_vip_20_monthly', 'PayCode', 'P5000000000689', 9); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('jie_park_vip_8_monthly', 'AppId', 'C10000019620', 8); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('jie_park_vip_8_monthly', 'PayCode', 'P5000000000665', 9); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('jie_park_vip_15_monthly', 'AppId', 'C10000019620', 8); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('jie_park_vip_15_monthly', 'PayCode', 'P5000000000681', 9); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('jie_park_vip_20_monthly', 'AppId', 'C10000019620', 8); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('jie_park_vip_20_monthly', 'PayCode', 'P5000000000682', 9); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('jie_park_vip_10_monthly', 'AppId', 'C10000019620', 8); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('jie_park_vip_10_monthly', 'PayCode', 'P5000000000666', 9); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('pp_park_vip_8_monthly', 'AppId', 'C10000019621', 8); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('pp_park_vip_8_monthly', 'PayCode', 'P5000000000684', 9); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('pp_park_vip_15_monthly', 'AppId', 'C10000019621', 8); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('pp_park_vip_15_monthly', 'PayCode', 'P5000000000685', 9); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('pp_park_vip_20_monthly', 'AppId', 'C10000019621', 8); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('pp_park_vip_20_monthly', 'PayCode', 'P5000000000686', 9); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('one_park_vip_10_monthly', 'AppId', 'C10000019622', 8); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('one_park_vip_10_monthly', 'PayCode', 'P5000000000688', 9); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('one_park_vip_15_monthly', 'AppId', 'C10000019622', 8); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('one_park_vip_15_monthly', 'PayCode', 'P5000000000667', 9); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('question001', 'AppId', 'C10000019610', 4); INSERT INTO PRODB.PRO_T_PRODUCTINFOEXT (PRODUCTID, KEYNAME, KEYVALUE, KEYINDEX) VALUES('question001', 'PayCode', 'P5000000000560', 5);

-- 查询值是否正确 SELECT * FROM PRODB.PRO_T_PRODUCTINFOEXT WHERE PRODUCTID in('diamond_changx_vip_monthly','diamond_changx_vip_1month','gold_changx_vip_6month','gold_changx_vip_monthly','gold_changx_vip_1month','silver_changx_vip_6month','silver_changx_vip_monthly','silver_changx_vip_1month','changying_vip_10_monthly','changying_vip_8_monthly','changying_vip_5_monthly','changying_vip_3_monthly','changying_svip_1month','changying_vip_1month','pp_park_vip_20_monthly','pp_park_vip_15_monthly','pp_park_vip_10_monthly','pp_park_vip_8_monthly','one_park_vip_20_monthly','one_park_vip_15_monthly','one_park_vip_10_monthly','one_park_vip_8_monthly','jie_park_vip_20_monthly','jie_park_vip_15_monthly','jie_park_vip_10_monthly','jie_park_vip_8_monthly','question001');

--清缓存 delete product:core.api.domain.ProductInfo:silver_changx_vip_1month

delete product:core.api.domain.ProductInfo:silver_changx_vip_6month

delete product:core.api.domain.ProductInfo:silver_changx_vip_monthly

delete product:core.api.domain.ProductInfo:gold_changx_vip_1month

delete product:core.api.domain.ProductInfo:gold_changx_vip_6month

delete product:core.api.domain.ProductInfo:gold_changx_vip_monthly

delete product:core.api.domain.ProductInfo:diamond_changx_vip_1month

delete product:core.api.domain.ProductInfo:diamond_changx_vip_monthly

delete product:core.api.domain.ProductInfo:jie_park_vip_8_monthly

delete product:core.api.domain.ProductInfo:jie_park_vip_10_monthly

delete product:core.api.domain.ProductInfo:jie_park_vip_15_monthly

delete product:core.api.domain.ProductInfo:jie_park_vip_20_monthly

delete product:core.api.domain.ProductInfo:pp_park_vip_8_monthly

delete product:core.api.domain.ProductInfo:pp_park_vip_10_monthly

delete product:core.api.domain.ProductInfo:pp_park_vip_15_monthly

delete product:core.api.domain.ProductInfo:pp_park_vip_20_monthly

delete product:core.api.domain.ProductInfo:one_park_vip_8_monthly

delete product:core.api.domain.ProductInfo:one_park_vip_10_monthly

delete product:core.api.domain.ProductInfo:one_park_vip_15_monthly

delete product:core.api.domain.ProductInfo:one_park_vip_20_monthly

delete product:core.api.domain.ProductInfo:question001