import os

# Check remaining gaps
w_paths = [
    r'E:\workspace\dan\cfc\cfc-frontend\pages\wisdom\cognitive-report.vue',
    r'E:\workspace\dan\cfc\cfc-frontend\pages\wisdom\articles.vue',
    r'E:\workspace\dan\cfc\cfc-frontend\pages\wisdom\article-detail.vue',
]
for p in w_paths:
    exists = os.path.exists(p)
    print(os.path.basename(p) + ': ' + ('EXISTS' if exists else 'MISSING'))

# DanAssessmentResult
path = r'E:\workspace\dan\cfc\cfc-backend\src\main\java\com\etotem\cfc\entity\DanAssessmentResult.java'
with open(path, 'r', encoding='utf-8') as f:
    content = f.read()
for kw in ['emotion', 'resilience', 'stress', 'selfAwareness', 'subScores', 'EMI']:
    if kw in content:
        print('DanAssessmentResult has: ' + kw)

# Schema
schema = r'E:\workspace\dan\cfc\cfc-backend\src\main\resources\schema.sql'
if os.path.exists(schema):
    print('schema.sql: EXISTS')
else:
    print('schema.sql: MISSING')

# family_member_attributes table
for root, dirs, files in os.walk(r'E:\workspace\dan\cfc\cfc-backend\src\main\resources'):
    for f in files:
        if f.endswith('.sql'):
            fpath = os.path.join(root, f)
            with open(fpath, 'r', encoding='utf-8') as fh:
                content = fh.read()
            if 'family_member_attribute' in content:
                print(f + ' contains family_member_attribute')
            if 'zodiac_config' in content:
                print(f + ' contains zodiac_config')

# user-edit
uedit = r'E:\workspace\dan\cfc\cfc-frontend\pages\user-edit\user-edit.vue'
if os.path.exists(uedit):
    with open(uedit, 'r', encoding='utf-8') as f:
        content = f.read()
    for kw in ['birth_date', 'birth_hour', 'birth', 'blood_type']:
        if kw in content:
            print('user-edit.vue has: ' + kw)
    if 'birth_date' not in content and 'birth' not in content:
        print('user-edit.vue: MISSING birth fields')