C语言创建规则集脚本

INSERT INTO cp_ruleset
    (ruleset_id, ruleset_name, ruleset_order, ruleset_desc, compiler_code)
VALUES
    (51239, 'C_CQB_ruleset', 0, '包括内存泄漏7种,质量规则39种,安全规则28种', 5111);

INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 4 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 12 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 37 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 39 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 47 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 48 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 4281 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 10003 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 10005 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 11918 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 11920 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 11921 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 11923 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 11924 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 11927 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 11929 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 11932 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 11943 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 11944 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 11945 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 11948 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 11949 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 11951 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 11952 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 11954 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 11955 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 11956 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 11957 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 11958 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 11959 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 11960 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 11961 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 11962 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 11963 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 11964 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 11965 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 11966 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 11967 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 11968 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 51000023 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 51000036 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 51000078 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 51000080 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 51000089 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 51000090 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 51000099 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 51000190 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 51000209 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 51000247 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 51000256 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 51000259 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 51000285 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 51000321 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 51000327 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 51000330 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 51000367 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 51000390 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 51000404 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 51000434 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 51000489 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 51000497 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 51000674 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 51000732 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 51000759 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 51000807 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 51009302 );
INSERT INTO CP_RULESET_RULE_MAP VALUES(51239, 51009310 );

commit;
原文地址:https://www.cnblogs.com/actioning/p/4287677.html