TSG-16235 策略验证支持统计策略v3.0.14-20230724

1 files changed, 101 insertions, 69 deletions

diff --git a/resource/table_info.conf b/resource/table_info.conf
index 77f197f..0088049 100644
--- a/resource/table_info.conf
+++ b/resource/table_info.conf
@@ -159,8 +159,40 @@
             "clause_index":6
         }
     },
-    {
+	{
         "table_id":10,
+        "table_name":"STATISTICS_COMPILE",
+        "table_type":"compile",
+		"user_region_encoded":"escape",
+        "valid_column":8,
+        "custom": {
+            "compile_id":1,
+            "service_id":2,
+            "action":3,
+            "do_blacklist":4,
+            "do_log":5,
+            "tags":6,
+            "user_region":7,
+            "clause_num":9,
+            "evaluation_order":10
+        }
+    },
+    {
+        "table_id":11,
+        "table_name":"GROUP_STATISTICS_COMPILE_RELATION",
+        "table_type":"group2compile",
+        "associated_compile_table_id":10,
+        "valid_column":3,
+        "custom": {
+            "group_id":1,
+            "compile_id":2,
+            "not_flag":4,
+            "virtual_table_name":5,
+            "clause_index":6
+        }
+    },
+    {
+        "table_id":12,
         "table_name":"GROUP_GROUP_RELATION",
         "table_type":"group2group",
         "valid_column":4,
@@ -171,7 +203,7 @@
         }
     },
     {
-        "table_id":11,
+        "table_id":13,
 		"table_name":"TSG_OBJ_IP",
         "db_tables":["TSG_OBJ_IP_ADDR","TSG_OBJ_IP_LEARNING_ADDR"],
         "table_type":"ip_plus",
@@ -190,7 +222,7 @@
         }
     },
 	{
-        "table_id":12,
+        "table_id":14,
         "table_name":"TSG_OBJ_SUBSCRIBER_ID",
         "table_type":"expr",
         "valid_column":7,
@@ -204,7 +236,7 @@
         }
     }, 
 	{
-        "table_id":13,
+        "table_id":15,
         "table_name":"TSG_OBJ_ACCOUNT",
         "table_type":"expr",
         "valid_column":7,
@@ -218,7 +250,7 @@
         }
     }, 
 	{
-        "table_id":14,
+        "table_id":16,
         "table_name":"TSG_OBJ_URL",
         "table_type":"expr",
         "valid_column":7,
@@ -232,7 +264,7 @@
         }
     }, 
 	{
-        "table_id":15,
+        "table_id":17,
         "table_name":"TSG_OBJ_FQDN",
         "table_type":"expr",
         "valid_column":7,
@@ -246,7 +278,7 @@
         }
     }, 
 	{
-        "table_id":16,
+        "table_id":18,
         "table_name":"TSG_OBJ_FQDN_CAT",
         "table_type":"intval",
         "valid_column":5,
@@ -258,7 +290,7 @@
         }
     },
 	{
-        "table_id":17,
+        "table_id":19,
         "table_name":"TSG_OBJ_KEYWORDS",
         "table_type":"expr",
         "valid_column":7,
@@ -272,7 +304,7 @@
         }
     },
 	{
-        "table_id":18,
+        "table_id":20,
         "table_name":"TSG_OBJ_APP_ID",
         "table_type":"intval",
         "valid_column":5,
@@ -284,7 +316,7 @@
         }
     },
 	{
-        "table_id":19,
+        "table_id":21,
         "table_name":"TSG_OBJ_HTTP_SIGNATURE",
         "table_type":"expr_plus",
         "valid_column":8,
@@ -299,175 +331,175 @@
         }
     },
 	{
-        "table_id":20,
+        "table_id":22,
         "table_name":"TSG_FIELD_HTTP_HOST",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_FQDN"
     },
 	{
-        "table_id":21,
+        "table_id":23,
         "table_name":"TSG_FIELD_HTTP_HOST_CAT",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_FQDN_CAT"
     },		
 	{
-        "table_id":22,
+        "table_id":24,
         "table_name":"TSG_FIELD_HTTP_URL",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_URL"
     },
 	{
-        "table_id":23,
+        "table_id":25,
         "table_name":"TSG_FIELD_HTTP_REQ_HDR",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_HTTP_SIGNATURE"
     },
 	{
-        "table_id":24,
+        "table_id":26,
         "table_name":"TSG_FIELD_HTTP_RES_HDR",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_HTTP_SIGNATURE"
     },
 	{
-        "table_id":25,
+        "table_id":27,
         "table_name":"TSG_FIELD_HTTP_REQ_BODY",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_KEYWORDS"
     },
 	{
-        "table_id":26,
+        "table_id":28,
         "table_name":"TSG_FIELD_HTTP_RES_BODY",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_KEYWORDS"
     },
 	{
-        "table_id":27,
+        "table_id":29,
         "table_name":"TSG_FIELD_SSL_SNI",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_FQDN"
     },
 	{
-        "table_id":28,
+        "table_id":30,
         "table_name":"TSG_FIELD_SSL_SNI_CAT",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_FQDN_CAT"
     },
 	{
-        "table_id":29,
+        "table_id":31,
         "table_name":"TSG_FIELD_SSL_CN",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_FQDN"
     },
 	{
-        "table_id":30,
+        "table_id":32,
         "table_name":"TSG_FIELD_SSL_CN_CAT",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_FQDN_CAT"
     },
 	{
-        "table_id":31,
+        "table_id":33,
         "table_name":"TSG_FIELD_SSL_SAN",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_FQDN"
     },
 	{
-        "table_id":32,
+        "table_id":34,
         "table_name":"TSG_FIELD_SSL_SAN_CAT",
         "table_type":"virtual",
         "physical_table":"TSG_OBJ_FQDN_CAT"
     },
 	{
-        "table_id":33,
+        "table_id":35,
         "table_name":"TSG_FIELD_DNS_QNAME",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_FQDN"
     },
 	{
-        "table_id":34,
+        "table_id":36,
         "table_name":"TSG_FIELD_QUIC_SNI",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_FQDN"
     },
 	{
-        "table_id":35,
+        "table_id":37,
         "table_name":"TSG_FIELD_QUIC_SNI_CAT",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_FQDN_CAT"
     },
 	{
-        "table_id":36,
+        "table_id":38,
         "table_name":"TSG_FIELD_MAIL_ACCOUNT",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_ACCOUNT"
     },
 	{
-        "table_id":37,
+        "table_id":39,
         "table_name":"TSG_FIELD_MAIL_FROM",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_ACCOUNT"
     },
 	{
-        "table_id":38,
+        "table_id":40,
         "table_name":"TSG_FIELD_MAIL_TO",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_ACCOUNT"
     },
 	{
-        "table_id":39,
+        "table_id":41,
         "table_name":"TSG_FIELD_MAIL_SUBJECT",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_KEYWORDS"
     },
 	{
-        "table_id":40,
+        "table_id":42,
         "table_name":"TSG_FIELD_MAIL_CONTENT",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_KEYWORDS"
     },
 	{
-        "table_id":41,
+        "table_id":43,
         "table_name":"TSG_FIELD_MAIL_ATT_NAME",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_KEYWORDS"
     },
 	{
-        "table_id":42,
+        "table_id":44,
         "table_name":"TSG_FIELD_MAIL_ATT_CONTENT",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_KEYWORDS"
     },
 	{
-        "table_id":43,
+        "table_id":45,
         "table_name":"TSG_FIELD_FTP_URI",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_URL"
     },
 	{
-        "table_id":44,
+        "table_id":46,
         "table_name":"TSG_FIELD_FTP_CONTENT",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_KEYWORDS"
     },
 	{
-        "table_id":45,
+        "table_id":47,
         "table_name":"TSG_FIELD_FTP_ACCOUNT",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_ACCOUNT"
     },
 	{
-        "table_id":46,
+        "table_id":48,
         "table_name":"TSG_SECURITY_SOURCE_ADDR",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_IP"
     },
 	{
-        "table_id":47,
+        "table_id":49,
         "table_name":"TSG_SECURITY_DESTINATION_ADDR",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_IP"
     },
 	{
-        "table_id":48,
+        "table_id":50,
         "table_name":"TSG_IP_ASN_BUILT_IN",
         "table_type":"ip_plugin",
 		"valid_column":19,
@@ -480,7 +512,7 @@
         }
     },
 	{
-        "table_id":49,
+        "table_id":51,
         "table_name":"TSG_IP_ASN_USER_DEFINED",
         "table_type":"ip_plugin",
 		"valid_column":19,
@@ -493,7 +525,7 @@
         }
     },
 	{
-        "table_id":50,
+        "table_id":52,
         "table_name":"TSG_IP_LOCATION_BUILT_IN",
         "table_type":"ip_plugin",
 		"valid_column":19,
@@ -506,7 +538,7 @@
         }
     },
 	{
-        "table_id":51,
+        "table_id":53,
         "table_name":"TSG_IP_LOCATION_USER_DEFINED",
         "table_type":"ip_plugin",
 		"valid_column":19,
@@ -519,7 +551,7 @@
         }
     },
 	{
-        "table_id":52,
+        "table_id":54,
         "table_name":"TSG_OBJ_AS_NUMBER",
         "table_type":"expr",
         "valid_column":7,
@@ -533,19 +565,19 @@
         }
     },
 	{
-        "table_id":53,
+        "table_id":55,
         "table_name":"TSG_SECURITY_SOURCE_ASN",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_AS_NUMBER"
     },
 	{
-        "table_id":54,
+        "table_id":56,
         "table_name":"TSG_SECURITY_DESTINATION_ASN",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_AS_NUMBER"
     },
 	{
-        "table_id":55,
+        "table_id":57,
         "table_name":"TSG_OBJ_GEO_LOCATION",
         "table_type":"expr",
         "valid_column":7,
@@ -559,19 +591,19 @@
         }
     },
 	{
-        "table_id":56,
+        "table_id":58,
         "table_name":"TSG_SECURITY_SOURCE_LOCATION",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_GEO_LOCATION"
     },
 	{
-        "table_id":57,
+        "table_id":59,
         "table_name":"TSG_SECURITY_DESTINATION_LOCATION",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_GEO_LOCATION"
     },
 	{
-        "table_id":58,
+        "table_id":60,
         "table_name":"TSG_FQDN_CATEGORY_BUILT_IN",
         "table_type":"fqdn_plugin",
         "valid_column":5,
@@ -582,7 +614,7 @@
         }
     },
 	{
-        "table_id":59,
+        "table_id":61,
         "table_name":"TSG_FQDN_CATEGORY_USER_DEFINED",
         "table_type":"fqdn_plugin",
         "valid_column":5,
@@ -593,19 +625,19 @@
         }
     },
 	{
-        "table_id":60,
+        "table_id":62,
         "table_name":"TSG_FIELD_SIP_ORIGINATOR_DESCRIPTION",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_ACCOUNT"
     },
 	{
-        "table_id":61,
+        "table_id":63,
         "table_name":"TSG_FIELD_SIP_RESPONDER_DESCRIPTION",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_ACCOUNT"
     },
 	{
-        "table_id":62,
+        "table_id":64,
         "table_name":"TSG_OBJ_IMSI",
         "table_type":"expr",
         "valid_column":7,
@@ -619,7 +651,7 @@
         }
     },
 	{
-        "table_id":63,
+        "table_id":65,
         "table_name":"TSG_OBJ_PHONE_NUMBER",
         "table_type":"expr",
         "valid_column":7,
@@ -633,7 +665,7 @@
         }
     },
 	{
-        "table_id":64,
+        "table_id":66,
         "table_name":"TSG_OBJ_APN",
         "table_type":"expr",
         "valid_column":7,
@@ -647,31 +679,31 @@
         }
     },
 	{
-        "table_id":65,
+        "table_id":67,
         "table_name":"TSG_FILED_GTP_IMSI",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_IMSI"
     },
 	{
-        "table_id":66,
+        "table_id":68,
         "table_name":"TSG_FILED_GTP_PHONE_NUMBER",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_PHONE_NUMBER"
     },
 	{
-        "table_id":67,
+        "table_id":69,
         "table_name":"TSG_FILED_GTP_APN",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_APN"
     },
 	{
-        "table_id":68,
+        "table_id":70,
         "table_name":"TSG_DECYPTION_EXCLUSION_SSL_SNI",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_FQDN"
     },
 	{
-        "table_id":69,
+        "table_id":71,
         "table_name":"TSG_OBJ_TUNNEL_ID",
         "table_type":"intval",
         "valid_column":5,
@@ -683,7 +715,7 @@
         }
     },
 	{
-        "table_id":70,
+        "table_id":72,
         "table_name":"TSG_TUNNEL_CATALOG",
         "table_type":"bool_plugin",
         "valid_column":5,
@@ -693,7 +725,7 @@
         }
     },	
 	{
-        "table_id":71,
+        "table_id":73,
         "table_name":"TSG_TUNNEL_ENDPOINT",
         "table_type":"ip_plugin",
 		"valid_column":6,
@@ -706,7 +738,7 @@
         }
     },
 	{
-        "table_id":72,
+        "table_id":74,
         "table_name":"TSG_TUNNEL_LABEL",
         "table_type":"plugin",
         "valid_column":4,
@@ -717,13 +749,13 @@
         }
     },
 	{
-        "table_id":73,
+        "table_id":75,
         "table_name":"TSG_SECURITY_TUNNEL",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_TUNNEL_ID"
     },
 	{
-        "table_id":74,
+        "table_id":76,
         "table_name":"TSG_OBJ_FLAG",
         "table_type":"flag",
         "valid_column":5,
@@ -735,25 +767,25 @@
         }
     },
 	{
-        "table_id":75,
+        "table_id":77,
         "table_name":"TSG_SECURITY_FLAG",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_FLAG"
     },
     {
-        "table_id":76,
+        "table_id":78,
         "table_name":"TSG_FIELD_DOH_QNAME",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_FQDN"
     },
 	{
-        "table_id":77,
+        "table_id":79,
         "table_name":"TSG_FIELD_DOH_HOST",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_FQDN"
     },
 	{
-        "table_id":78,
+        "table_id":80,
         "table_name":"TSG_FIELD_DOH_HOST_CAT",
         "table_type":"virtual",
         "physical_table": "TSG_OBJ_FQDN_CAT"