def _transalte_100_63_22_14_1(self):
rules = [
"(SELLER_CONSUMER_SEG != 'Y') & (IS_ULP_TRANS_T_F >= 0.5) & (dc_string != '<missing>') & (amt2 == 'a-1k') & (SELLER_CONSUMER_SEG == 'C')",
"(SELLER_CONSUMER_SEG == 'Y') & (IS_ULP_TRANS_T_F >= 0.5) & (dc_string == '10008') & (amt2 != 'c-1h') & (amt2 != 'e-<50')",
]
result = instance.translate_hyperloop_rules_to_sql(rules)
print(result)
def _transalte_1_1_1_1_1(self):
rules = [
"(SELLER_CONSUMER_SEG != 'Y') & (RCVR_CNTRY_CODE == 'C2 ') & (FLOW_FAMILY == 'MS FF Website Payments Standard') & (IS_ULP_TRANS_T_F >= 0.5)",
"(SELLER_CONSUMER_SEG != 'Y') & (RCVR_CNTRY_CODE == 'C2 ') & (FLOW_FAMILY == 'MS FF Website Payments Standard') & (IS_ULP_TRANS_T_F < 0.5) & (SNDR_CNTRY_CODE != 'FR ') & (SUB_FLOW != 'MS Subscription') & (SNDR_CNTRY_CODE != 'ES ') & (SNDR_CNTRY_CODE == 'US ') & (SUB_FLOW != 'MS PayPal Cart') & (SUB_FLOW != 'MS Mobile Shopping Cart Upload') & (dof_bin == 'e->1y') & (amt2 != 'a-1k') & (SUB_FLOW == 'MS Single Line Payment') & (SELLER_CONSUMER_SEG == 'C')",
]
result = instance.translate_hyperloop_rules_to_sql(rules)
print(result)
def _transalte_mix(self):
rules = [
"(dof_bin != 'e->1y') & (SNDR_CNTRY_CODE != 'VE ') & (SNDR_CNTRY_CODE == 'CL ') & (SUB_FLOW == 'MS Send Money Internal') & (amt2 != 'a-1k') & (SELLER_SEG == '04 YS') & (RCVR_CNTRY_CODE != 'PE ') & (RCVR_CNTRY_CODE != 'VE ') & (dof_bin != 'c-90')",
"(dof_bin != 'e->1y') & (SNDR_CNTRY_CODE == 'VE ') & (amt2 != 'b-5h') & (SELLER_SEG == '04 YS') & (RCVR_CNTRY_CODE != 'MX ') & (RCVR_CNTRY_CODE != 'CO ') & (RCVR_CNTRY_CODE == 'CL ')",
]
result = instance.translate_hyperloop_rules_to_sql(rules)
print(result)
def _transalte_637_64_22_14_1(self):
rules = [
"(SUB_FLOW != 'MS MassPay') & (SNDR_CNTRY_CODE == 'US ') & (FLOW_FAMILY == 'MS FF Website Payments Standard') & (amt2 == 'b-5h') & (RCVR_CNTRY_CODE != 'TH ') & (RCVR_CNTRY_CODE != 'JP ') & (IS_ULP_TRANS_T_F >= 0.5)",
"(SUB_FLOW != 'MS MassPay') & (SNDR_CNTRY_CODE != 'US ') & (RCVR_CNTRY_CODE == 'C2 ') & (IS_ULP_TRANS_T_F >= 0.5) & (SNDR_CNTRY_CODE != 'ES ') & (amt2 != 'e-<50')",
]
result = instance.translate_hyperloop_rules_to_sql(rules)
print(result)
def _transalte_tpv2(self):
rules = [
"(dof_bin != 'e->1y') & (SNDR_CNTRY_CODE != 'VE ') & (SNDR_CNTRY_CODE == 'CL ') & (amt2 != 'b-5h') & (RCVR_CNTRY_CODE != 'DO ') & (RCVR_CNTRY_CODE != 'BR ') & (RCVR_CNTRY_CODE != 'MX ') & (SELLER_CONSUMER_SEG != 'T') & (amt2 != 'a-1k') & (SELLER_SEG == '04 YS') & (RCVR_CNTRY_CODE != 'PE ') & (RCVR_CNTRY_CODE != 'CR ') & (amt2 != 'c-1h') & (RCVR_CNTRY_CODE == 'CL ') & (dof_bin != 'c-90')",
"(dof_bin != 'e->1y') & (SNDR_CNTRY_CODE == 'VE ') & (SELLER_SEG == '04 YS') & (amt2 != 'b-5h') & (RCVR_CNTRY_CODE != 'CO ') & (RCVR_CNTRY_CODE != 'MX ') & (RCVR_CNTRY_CODE == 'CL ') & (amt2 != 'c-1h') & (SUB_FLOW != 'MS Mobile Cons App Send Money - Commercial')",
]
result = instance.translate_hyperloop_rules_to_sql(rules)
print(result)
def _transalte_7_4_5_3_6(self):
rules = [
"(dof_bin == 'a-7') & (SNDR_CNTRY_CODE != 'VE ') & (SNDR_CNTRY_CODE == 'CL ') & (SUB_FLOW == 'MS Send Money Internal') & (IS_ULP_TRANS_T_F < 0.5) & (RCVR_CNTRY_CODE == 'CL ')",
"(dof_bin == 'a-7') & (SNDR_CNTRY_CODE == 'VE ') & (SUB_FLOW == 'MS Send Money Internal') & (IS_ULP_TRANS_T_F < 0.5) & (RCVR_CNTRY_CODE != 'AR ') & (amt2 != 'c-1h') & (RCVR_CNTRY_CODE != 'CO ') & (RCVR_CNTRY_CODE != 'PE ') & (RCVR_CNTRY_CODE != 'MX ') & (RCVR_CNTRY_CODE != 'CL ')",
]
result = instance.translate_hyperloop_rules_to_sql(rules)
print(result)
def _transalte_1_1_1_1_1(self):
rules = [
"(SELLER_CONSUMER_SEG != 'Y') & (SELLER_SEG == '04 YS') & (amt2 != 'e-<50') & (IS_ULP_TRANS_T_F >= 0.5) & (dc_string != '<missing>') & (amt2 != 'd-50')",
"(SELLER_CONSUMER_SEG == 'Y') & (SELLER_SEG == '04 YS') & (amt2 != 'e-<50') & (SUB_FLOW == 'MS Send Money Internal') & (IS_ULP_TRANS_T_F >= 0.5) & (RCVR_CNTRY_CODE != 'CA ') & (dc_string == '10008')",
"(SELLER_CONSUMER_SEG != 'Y') & (SELLER_SEG != '04 YS') & (amt2 != 'e-<50') & (SUB_FLOW != 'MS Mobile Cons App Send Money - Commercial') & (amt2 == 'a-1k') & (IS_ULP_TRANS_T_F >= 0.5) & (dc_string != '<missing>')",
"(SELLER_CONSUMER_SEG == 'Y') & (SELLER_SEG != '04 YS') & (SUB_FLOW != 'MS Send Money Internal') & (SUB_FLOW == 'MS Mobile Money Request - Invoicing API')",
]
result = instance.translate_hyperloop_rules_to_sql(rules)
print(result)
def _transalte_46_27_5_5_1(self):
rules = [
"(dof_bin != 'e->1y') & (SNDR_CNTRY_CODE != 'VE ') & (SNDR_CNTRY_CODE != 'CL ') & (dof_bin == 'a-7') & (RCVR_CNTRY_CODE != 'VE ') & (SNDR_CNTRY_CODE != 'BR ') & (SNDR_CNTRY_CODE != 'DO ') & (SNDR_CNTRY_CODE != 'HN ') & (SNDR_CNTRY_CODE == 'UY ') & (amt2 == 'e-<50')",
"(dof_bin != 'e->1y') & (SNDR_CNTRY_CODE != 'VE ') & (SNDR_CNTRY_CODE == 'CL ') & (amt2 != 'b-5h') & (RCVR_CNTRY_CODE == 'CL ') & (amt2 != 'a-1k') & (SELLER_CONSUMER_SEG != 'T') & (SUB_FLOW == 'MS Send Money Internal') & (amt2 == 'd-50') & (dof_bin != 'b-30')",
"(dof_bin != 'e->1y') & (SNDR_CNTRY_CODE != 'VE ') & (SNDR_CNTRY_CODE == 'CL ') & (amt2 != 'b-5h') & (RCVR_CNTRY_CODE == 'CL ') & (amt2 != 'a-1k') & (SELLER_CONSUMER_SEG != 'T') & (SUB_FLOW == 'MS Send Money Internal') & (amt2 != 'd-50') & (SELLER_SEG == '04 YS') & (dof_bin != 'd-1y') & (SELLER_CONSUMER_SEG == 'Y')",
"(dof_bin != 'e->1y') & (SNDR_CNTRY_CODE == 'VE ') & (SELLER_SEG == '04 YS') & (SUB_FLOW == 'MS Send Money Internal') & (RCVR_CNTRY_CODE == 'CL ') & (amt2 != 'b-5h')",
]
result = instance.translate_hyperloop_rules_to_sql(rules)
print(result)
def _transalte_tpv(self):
rules = [
"(dof_bin != 'e->1y') & (SNDR_CNTRY_CODE != 'VE ') & (SNDR_CNTRY_CODE != 'CL ') & (dof_bin == 'd-1y') & (RCVR_CNTRY_CODE != 'PE ') & (SNDR_CNTRY_CODE != 'IL ') & (SNDR_CNTRY_CODE != 'US ') & (RCVR_CNTRY_CODE != 'AR ') & (RCVR_CNTRY_CODE != 'BR ') & (SUB_FLOW != 'MS Money Request') & (SNDR_CNTRY_CODE == 'MX ') & (SUB_FLOW == 'MS Mobile Cons App Send Money - Commercial') & (RCVR_CNTRY_CODE == 'GT ')",
"(dof_bin != 'e->1y') & (SNDR_CNTRY_CODE != 'VE ') & (SNDR_CNTRY_CODE == 'CL ') & (SUB_FLOW == 'MS Send Money Internal') & (amt2 != 'a-1k') & (SELLER_SEG == '04 YS') & (RCVR_CNTRY_CODE != 'PE ') & (amt2 != 'c-1h') & (RCVR_CNTRY_CODE == 'CL ') & (dof_bin != 'c-90') & (dof_bin == 'a-7') & (IS_ULP_TRANS_T_F < 0.5)",
"(dof_bin != 'e->1y') & (SNDR_CNTRY_CODE == 'VE ') & (SELLER_SEG == '04 YS') & (amt2 != 'b-5h') & (SUB_FLOW == 'MS Send Money Internal') & (RCVR_CNTRY_CODE == 'CL ') & (amt2 == 'c-1h') & (SELLER_CONSUMER_SEG == 'Y') & (dof_bin == 'd-1y')",
"(dof_bin != 'e->1y') & (SNDR_CNTRY_CODE == 'VE ') & (SELLER_SEG == '04 YS') & (amt2 != 'b-5h') & (SUB_FLOW == 'MS Send Money Internal') & (RCVR_CNTRY_CODE != 'CL ') & (dof_bin == 'a-7') & (amt2 != 'c-1h') & (RCVR_CNTRY_CODE != 'AR ') & (amt2 != 'a-1k') & (IS_ULP_TRANS_T_F < 0.5)",
]
result = instance.translate_hyperloop_rules_to_sql(rules)
print(result)
def _transalte_30_20_3_4_1(self):
rules = [
"(SELLER_CONSUMER_SEG != 'Y') & (IS_ULP_TRANS_T_F >= 0.5) & (dc_string != '<missing>') & (amt2 == 'a-1k') & (SELLER_CONSUMER_SEG == 'C')",
"(SELLER_CONSUMER_SEG == 'Y') & (dc_string == '10008') & (amt2 == 'a-1k') & (SUB_FLOW != 'MS Money Request - Invoicing') & (SUB_FLOW == 'MS Mobile Cons App Send Money - Commercial') & (IS_ULP_TRANS_T_F >= 0.5)",
"(SELLER_CONSUMER_SEG == 'Y') & (dc_string == '10008') & (amt2 == 'a-1k') & (SUB_FLOW != 'MS Money Request - Invoicing') & (SUB_FLOW == 'MS Mobile Cons App Send Money - Commercial') & (IS_ULP_TRANS_T_F < 0.5)",
"(SELLER_CONSUMER_SEG == 'Y') & (dc_string == '10008') & (amt2 == 'a-1k') & (SUB_FLOW != 'MS Money Request - Invoicing') & (SUB_FLOW != 'MS Mobile Cons App Send Money - Commercial')",
]
result = instance.translate_hyperloop_rules_to_sql(rules)
print(result)
def _transalte_mix(self):
rules = [
"(SELLER_CONSUMER_SEG != 'Y') & (IS_ULP_TRANS_T_F >= 0.5) & (dc_string != '<missing>') & (dc_string != '10005') & (amt2 == 'a-1k') & (SELLER_CONSUMER_SEG == 'C') & (SELLER_SEG == '04 YS') & (dc_string == '10008') & (SUB_FLOW == 'MS Send Money Internal')",
"(SELLER_CONSUMER_SEG != 'Y') & (IS_ULP_TRANS_T_F >= 0.5) & (dc_string != '<missing>') & (dc_string != '10005') & (amt2 == 'a-1k') & (SELLER_CONSUMER_SEG == 'C') & (SELLER_SEG == '04 YS') & (dc_string == '10008') & (SUB_FLOW != 'MS Send Money Internal')",
"(SELLER_CONSUMER_SEG != 'Y') & (IS_ULP_TRANS_T_F >= 0.5) & (dc_string != '<missing>') & (dc_string != '10005') & (amt2 == 'a-1k') & (SELLER_CONSUMER_SEG == 'C') & (SELLER_SEG != '04 YS')",
"(SELLER_CONSUMER_SEG != 'Y') & (IS_ULP_TRANS_T_F >= 0.5) & (dc_string != '<missing>') & (dc_string != '10005') & (amt2 == 'a-1k') & (SELLER_CONSUMER_SEG == 'C') & (SELLER_SEG == '04 YS') & (dc_string != '10008')",
"(SELLER_CONSUMER_SEG == 'Y') & (dc_string == '10008') & (IS_ULP_TRANS_T_F >= 0.5) & (amt2 != 'c-1h') & (amt2 != 'e-<50')",
]
result = instance.translate_hyperloop_rules_to_sql(rules)
print(result)
def _transalte_100_63_22_14_1_v2(self):
rules = [
"(dof_bin == 'a-7') & (SNDR_CNTRY_CODE != 'VE ') & (SNDR_CNTRY_CODE != 'CL ') & (RCVR_CNTRY_CODE != 'VE ') & (SNDR_CNTRY_CODE != 'UY ') & (SUB_FLOW == 'MS Mobile Money Request - Invoicing') & (RCVR_CNTRY_CODE == 'PE ')",
"(dof_bin == 'a-7') & (SNDR_CNTRY_CODE != 'VE ') & (SNDR_CNTRY_CODE == 'CL ') & (IS_ULP_TRANS_T_F < 0.5) & (RCVR_CNTRY_CODE == 'CL ') & (SUB_FLOW == 'MS Send Money Internal') & (amt2 != 'c-1h')",
"(dof_bin == 'a-7') & (SNDR_CNTRY_CODE != 'VE ') & (SNDR_CNTRY_CODE != 'CL ') & (RCVR_CNTRY_CODE != 'VE ') & (SNDR_CNTRY_CODE == 'UY ') & (RCVR_CNTRY_CODE == 'UY ') & (amt2 == 'e-<50') & (SUB_FLOW == 'MS Send Money Internal')",
"(dof_bin != 'a-7') & (RCVR_CNTRY_CODE == 'CL ') & (SELLER_SEG == '04 YS') & (dof_bin != 'e->1y') & (SNDR_CNTRY_CODE == 'VE ') & (SUB_FLOW == 'MS Send Money Internal') & (dof_bin == 'b-30')",
"(dof_bin != 'a-7') & (RCVR_CNTRY_CODE != 'CL ') & (dof_bin != 'b-30') & (dof_bin != 'e->1y') & (RCVR_CNTRY_CODE != 'VE ') & (RCVR_CNTRY_CODE != 'PA ') & (SNDR_CNTRY_CODE != 'CO ') & (RCVR_CNTRY_CODE != 'JM ') & (RCVR_CNTRY_CODE == 'UY ') & (amt2 != 'e-<50') & (SELLER_SEG == '04 YS') & (SNDR_CNTRY_CODE != 'PE ') & (SNDR_CNTRY_CODE != 'UY ') & (SNDR_CNTRY_CODE == 'BR ')",
"(dof_bin == 'a-7') & (SNDR_CNTRY_CODE == 'VE ') & (SUB_FLOW == 'MS Send Money Internal') & (IS_ULP_TRANS_T_F < 0.5) & (amt2 != 'c-1h') & (RCVR_CNTRY_CODE != 'AR ') & (RCVR_CNTRY_CODE != 'CO ') & (RCVR_CNTRY_CODE != 'MX ') & (amt2 == 'e-<50')",
]
result = instance.translate_hyperloop_rules_to_sql(rules)
print(result)
def _transalte_tpv2(self):
rules = [
"(SELLER_CONSUMER_SEG != 'Y') & (IS_ULP_TRANS_T_F >= 0.5) & (dc_string != '<missing>') & (amt2 != 'c-1h') & (dc_string != '10005') & (amt2 != 'd-50') & (amt2 != 'e-<50') & (SELLER_CONSUMER_SEG == 'C') & (dc_string != '12123') & (amt2 == 'a-1k') & (SELLER_SEG == '04 YS') & (SUB_FLOW == 'MS Send Money Internal') & (dc_string == '10008')",
"(SELLER_CONSUMER_SEG != 'Y') & (IS_ULP_TRANS_T_F >= 0.5) & (dc_string != '<missing>') & (amt2 != 'c-1h') & (dc_string != '10005') & (amt2 != 'd-50') & (amt2 != 'e-<50') & (SELLER_CONSUMER_SEG == 'C') & (dc_string != '12123') & (amt2 == 'a-1k') & (SELLER_SEG == '04 YS') & (SUB_FLOW != 'MS Send Money Internal')",
"(SELLER_CONSUMER_SEG != 'Y') & (IS_ULP_TRANS_T_F >= 0.5) & (dc_string != '<missing>') & (amt2 != 'c-1h') & (dc_string != '10005') & (amt2 != 'd-50') & (amt2 != 'e-<50') & (SELLER_CONSUMER_SEG == 'C') & (dc_string != '12123') & (amt2 == 'a-1k') & (SELLER_SEG != '04 YS')",
"(SELLER_CONSUMER_SEG == 'Y') & (dc_string != '10008') & (SUB_FLOW != 'MS Mobile Money Request') & (SUB_FLOW != 'MS Money Request') & (IS_ULP_TRANS_T_F >= 0.5) & (dc_string == '10002') & (amt2 != 'c-1h')",
"(SELLER_CONSUMER_SEG == 'Y') & (dc_string != '10008') & (SUB_FLOW != 'MS Mobile Money Request') & (SUB_FLOW != 'MS Money Request') & (IS_ULP_TRANS_T_F >= 0.5) & (dc_string != '10002') & (amt2 != 'c-1h') & (SUB_FLOW == 'MS Send Money Internal') & (RCVR_CNTRY_CODE != 'CA ') & (dc_string != '12122') & (dc_string != '10010') & (SELLER_SEG != '04 YS') & (amt2 != 'e-<50')",
"(SELLER_CONSUMER_SEG == 'Y') & (dc_string == '10008') & (amt2 == 'a-1k') & (IS_ULP_TRANS_T_F >= 0.5)"
]
result = instance.translate_hyperloop_rules_to_sql(rules)
print(result)
def _transalte_100_63_22_14_1(self):
rules = [
"(dof_bin != 'e->1y') & (SNDR_CNTRY_CODE != 'VE ') & (SNDR_CNTRY_CODE == 'CL ') & (RCVR_CNTRY_CODE == 'CL ') & (amt2 != 'b-5h') & (amt2 != 'a-1k') & (SELLER_CONSUMER_SEG != 'T') & (SUB_FLOW == 'MS Send Money Internal') & (SELLER_CONSUMER_SEG == 'Y') & (SELLER_SEG == '04 YS') & (dof_bin != 'b-30') & (amt2 == 'd-50') & (dof_bin != 'd-1y')",
"(dof_bin != 'e->1y') & (SNDR_CNTRY_CODE != 'VE ') & (SNDR_CNTRY_CODE != 'CL ') & (dof_bin == 'a-7') & (RCVR_CNTRY_CODE != 'VE ') & (SNDR_CNTRY_CODE != 'BR ') & (SNDR_CNTRY_CODE != 'DO ') & (RCVR_CNTRY_CODE != 'HN ') & (RCVR_CNTRY_CODE != 'EC ') & (SNDR_CNTRY_CODE != 'MX ') & (RCVR_CNTRY_CODE == 'UY ') & (SUB_FLOW != 'MS Mobile Cons App Send Money - Commercial') & (amt2 == 'e-<50') & (SNDR_CNTRY_CODE == 'UY ')",
"(dof_bin != 'e->1y') & (SNDR_CNTRY_CODE != 'VE ') & (SNDR_CNTRY_CODE != 'CL ') & (dof_bin != 'a-7') & (SNDR_CNTRY_CODE != 'PE ') & (SNDR_CNTRY_CODE != 'JM ') & (SNDR_CNTRY_CODE != 'CO ') & (SNDR_CNTRY_CODE == 'US ') & (SUB_FLOW == 'MS Mobile Money Request - Invoicing') & (RCVR_CNTRY_CODE == 'PE ')",
"(dof_bin != 'e->1y') & (SNDR_CNTRY_CODE != 'VE ') & (SNDR_CNTRY_CODE != 'CL ') & (dof_bin != 'a-7') & (SNDR_CNTRY_CODE != 'PE ') & (SNDR_CNTRY_CODE != 'JM ') & (SNDR_CNTRY_CODE == 'CO ') & (SELLER_SEG == '04 YS') & (amt2 != 'a-1k') & (SUB_FLOW == 'MS Send Money Internal') & (amt2 == 'c-1h') & (RCVR_CNTRY_CODE != 'EC ') & (RCVR_CNTRY_CODE == 'PE ') & (dof_bin != 'b-30')",
"(dof_bin != 'e->1y') & (SNDR_CNTRY_CODE == 'VE ') & (SELLER_SEG == '04 YS') & (SUB_FLOW == 'MS Send Money Internal') & (RCVR_CNTRY_CODE == 'CL ') & (amt2 != 'b-5h') & (dof_bin != 'a-7')",
"(dof_bin != 'e->1y') & (SNDR_CNTRY_CODE != 'VE ') & (SNDR_CNTRY_CODE == 'CL ') & (RCVR_CNTRY_CODE == 'CL ') & (amt2 != 'b-5h') & (amt2 != 'a-1k') & (SELLER_CONSUMER_SEG != 'T') & (SUB_FLOW == 'MS Send Money Internal') & (SELLER_CONSUMER_SEG == 'Y') & (SELLER_SEG == '04 YS') & (dof_bin != 'b-30') & (amt2 != 'd-50')",
]
result = instance.translate_hyperloop_rules_to_sql(rules)
print(result)
def _transalte_1_1_1_1_1(self):
rules = [
"(dof_bin != 'e->1y') & (SNDR_CNTRY_CODE == 'VE ') & (SELLER_SEG == '04 YS') & (dof_bin != 'a-7') & (RCVR_CNTRY_CODE == 'CL ') & (SUB_FLOW == 'MS Send Money Internal')",
"(dof_bin != 'e->1y') & (SNDR_CNTRY_CODE != 'VE ') & (SNDR_CNTRY_CODE != 'CL ') & (dof_bin != 'd-1y') & (RCVR_CNTRY_CODE != 'PA ') & (dof_bin == 'c-90') & (SNDR_CNTRY_CODE == 'CO ') & (RCVR_CNTRY_CODE != 'MX ') & (RCVR_CNTRY_CODE == 'EC ')",
"(dof_bin == 'e->1y') & (SNDR_CNTRY_CODE != 'CL ') & (RCVR_CNTRY_CODE != 'VE ') & (SNDR_CNTRY_CODE == 'PE ') & (amt2 == 'a-1k') & (RCVR_CNTRY_CODE == 'PE ')",
"(dof_bin != 'e->1y') & (SNDR_CNTRY_CODE == 'VE ') & (SELLER_SEG == '04 YS') & (dof_bin == 'a-7') & (IS_ULP_TRANS_T_F < 0.5) & (SUB_FLOW != 'MS Send Money Internal') & (RCVR_CNTRY_CODE != 'VE ')",
"(dof_bin != 'e->1y') & (SNDR_CNTRY_CODE != 'VE ') & (SNDR_CNTRY_CODE != 'CL ') & (dof_bin == 'd-1y') & (RCVR_CNTRY_CODE != 'UY ') & (RCVR_CNTRY_CODE != 'JM ') & (SNDR_CNTRY_CODE != 'US ') & (amt2 != 'b-5h') & (SELLER_CONSUMER_SEG == 'T') & (RCVR_CNTRY_CODE == 'MX ') & (SNDR_CNTRY_CODE == 'MX ') & (SUB_FLOW == 'MS Send Money Internal') & (amt2 != 'e-<50')",
"(dof_bin != 'e->1y') & (SNDR_CNTRY_CODE != 'VE ') & (SNDR_CNTRY_CODE == 'CL ') & (RCVR_CNTRY_CODE == 'CL ') & (amt2 != 'b-5h') & (SELLER_CONSUMER_SEG != 'T') & (SUB_FLOW != 'MS Send Money Internal') & (amt2 == 'e-<50') & (SELLER_SEG == '04 YS') & (dof_bin != 'a-7')",
"(dof_bin != 'e->1y') & (SNDR_CNTRY_CODE == 'VE ') & (SELLER_SEG == '04 YS') & (dof_bin != 'a-7') & (RCVR_CNTRY_CODE == 'CL ') & (SUB_FLOW != 'MS Send Money Internal')",
]
result = instance.translate_hyperloop_rules_to_sql(rules)
print(result)
def _transalte_74_16_5_4_1(self):
rules = [
"(FLOW_FAMILY == 'MS FF Website Payments Standard') & (IS_ULP_TRANS_T_F >= 0.5) & (amt2 != 'a-1k') & (RCVR_CNTRY_CODE != 'VN ') & (SNDR_CNTRY_CODE != 'AU ') & (amt2 != 'e-<50') & (RCVR_CNTRY_CODE != 'NZ ') & (dof_bin != 'b-30') & (RCVR_CNTRY_CODE != 'MY ') & (SNDR_CNTRY_CODE != 'ES ')",
]
result = instance.translate_hyperloop_rules_to_sql(rules)
print(result)
def _transalte_100_63_22_14_1(self):
rules = [
"(SUB_FLOW != 'MS MassPay') & (IS_ULP_TRANS_T_F >= 0.5) & (SNDR_CNTRY_CODE != 'AU ') & (amt2 != 'a-1k') & (SNDR_CNTRY_CODE != 'VN ') & (RCVR_CNTRY_CODE != 'NZ ') & (RCVR_CNTRY_CODE != 'JP ') & (SNDR_CNTRY_CODE != 'C2 ') & (RCVR_CNTRY_CODE != 'SG ') & (amt2 != 'e-<50') & (SNDR_CNTRY_CODE != 'HK ') & (dof_bin != 'b-30') & (SUB_FLOW != 'MS Shopping Cart Upload') & (SNDR_CNTRY_CODE != 'ES ') & (SUB_FLOW != 'MS Mobile Shopping Cart Upload')",
]
result = instance.translate_hyperloop_rules_to_sql(rules)
print(result)
def _transalte_1_1_1_1_1_one_1_on_1(self):
rules = [
"(dof_bin != 'e->1y') & (SELLER_SEG == '04 YS') & (SNDR_CNTRY_CODE != 'VE ') & (SNDR_CNTRY_CODE == 'CL ') & (RCVR_CNTRY_CODE == 'CL ')"
]
result = instance.translate_hyperloop_rules_to_sql(rules)
print(result)
def _transalte_tpv2(self):
rules = [
"(SUB_FLOW != 'MS MassPay') & (IS_ULP_TRANS_T_F >= 0.5) & (amt2 != 'a-1k') & (SNDR_CNTRY_CODE != 'AU ') & (RCVR_CNTRY_CODE != 'VN ') & (RCVR_CNTRY_CODE != 'NZ ') & (RCVR_CNTRY_CODE != 'JP ') & (RCVR_CNTRY_CODE != 'SG ') & (amt2 != 'e-<50') & (SNDR_CNTRY_CODE != 'C2 ') & (dof_bin != 'b-30') & (SNDR_CNTRY_CODE != 'HK ') & (amt2 == 'b-5h')"
]
result = instance.translate_hyperloop_rules_to_sql(rules)
print(result)
def _transalte_1_85_7_4_5(self):
rules = [
"(IS_ULP_TRANS_T_F >= 0.5) & (amt2 == 'b-5h') & (FLOW_FAMILY == 'MS FF Website Payments Standard')",
]
result = instance.translate_hyperloop_rules_to_sql(rules)
print(result)
def _transalte_100_64_22_14_1(self):
rules = [
"(FLOW_FAMILY == 'MS FF Website Payments Standard') & (IS_ULP_TRANS_T_F >= 0.5) & (amt2 != 'a-1k') & (SNDR_CNTRY_CODE != 'VN ') & (amt2 == 'b-5h')"
]
result = instance.translate_hyperloop_rules_to_sql(rules)
print(result)
