import sys
import os
sys.path.insert(0, os.path.dirname(os.path.abspath(__file__)))
from common.pool_wrapper import get_pooled_connection_compat

conn = get_pooled_connection_compat()
cur = conn.cursor()
cur.execute("SELECT anchor_category FROM chatbot_fashion_rules WHERE anchor_category LIKE '%Chân váy%'")
print("LIKE:", cur.fetchall())
cur.execute("SELECT anchor_category FROM chatbot_fashion_rules WHERE UPPER(anchor_category) = UPPER('Chân váy')")
print("UPPER:", cur.fetchall())
cur.execute("SELECT anchor_category FROM chatbot_fashion_rules WHERE LOWER(anchor_category) = LOWER('Chân váy')")
print("LOWER:", cur.fetchall())
