get_results($wpdb->prepare(”
SELECT * FROM wp_ennu_assessment_questions
WHERE assessment_type = %s
ORDER BY sort_order
“, $assessment_type), ARRAY_A);
echo ” Found ” . count($questions) . ” questions locally\n”;
if (empty($questions)) {
echo ” ⚠️ No questions found for $assessment_type\n”;
continue;
}
$success = 0;
$errors = 0;
foreach ($questions as $question) {
// Check if question already exists
$exists = $wpdb->get_var($wpdb->prepare(”
SELECT id FROM wp_ennu_assessment_questions
WHERE assessment_type = %s AND question_key = %s
“, $assessment_type, $question[‘question_key’]));
if ($exists) {
// Update existing
$result = $wpdb->update(
‘wp_ennu_assessment_questions’,
[
‘question_text’ => $question[‘question_text’],
‘question_type’ => $question[‘question_type’],
‘options’ => $question[‘options’],
‘is_required’ => $question[‘is_required’],
‘scoring_config’ => $question[‘scoring_config’],
‘sort_order’ => $question[‘sort_order’],
‘is_active’ => $question[‘is_active’],
‘updated_at’ => current_time(‘mysql’)
],
[‘id’ => $exists],
[‘%s’, ‘%s’, ‘%s’, ‘%d’, ‘%s’, ‘%d’, ‘%d’, ‘%s’],
[‘%d’]
);
if ($result !== false) {
$success++;
} else {
$errors++;
echo ” ❌ Update failed: {$question[‘question_key’]}\n”;
}
} else {
// Insert new
$result = $wpdb->insert(
‘wp_ennu_assessment_questions’,
[
‘assessment_type’ => $question[‘assessment_type’],
‘question_key’ => $question[‘question_key’],
‘question_text’ => $question[‘question_text’],
‘question_type’ => $question[‘question_type’],
‘options’ => $question[‘options’],
‘is_required’ => $question[‘is_required’],
‘scoring_config’ => $question[‘scoring_config’],
‘sort_order’ => $question[‘sort_order’],
‘is_active’ => $question[‘is_active’],
‘created_at’ => current_time(‘mysql’),
‘updated_at’ => current_time(‘mysql’)
],
[‘%s’, ‘%s’, ‘%s’, ‘%s’, ‘%s’, ‘%d’, ‘%s’, ‘%d’, ‘%d’, ‘%s’, ‘%s’]
);
if ($result) {
$success++;
} else {
$errors++;
echo ” ❌ Insert failed: {$question[‘question_key’]}\n”;
}
}
}
echo ” ✅ $assessment_type: $success success, $errors errors\n”;
// Verify final count
$final_count = $wpdb->get_var($wpdb->prepare(”
SELECT COUNT(*) FROM wp_ennu_assessment_questions
WHERE assessment_type = %s
“, $assessment_type));
echo ” ???? Final count: $final_count questions\n”;
$total_success += $success;
$total_errors += $errors;
}
echo “\n???? FINAL SUMMARY:\n”;
echo ” ✅ Total Success: $total_success\n”;
echo ” ❌ Total Errors: $total_errors\n”;
if ($total_errors == 0) {
echo “\n???? ALL ASSESSMENTS QUESTIONS IMPORTED SUCCESSFULLY!\n”;
} else {
echo “\n⚠️ Some errors occurred during import\n”;
}
?>
