public function MigrateBack()
{
global $wpdb;
$_wpdb = $this->getConnection();
// Load data Occurrences from External DB
$occurrence = new WSAL_Adapters_MySQL_Occurrence($_wpdb);
if (!$occurrence->IsInstalled()) {
die("No alerts to import");
}
$sql = 'SELECT * FROM ' . $occurrence->GetTable();
$occurrences = $_wpdb->get_results($sql, ARRAY_A);
// Insert data to WP
$occurrenceWP = new WSAL_Adapters_MySQL_Occurrence($wpdb);
$sql = 'INSERT INTO ' . $occurrenceWP->GetWPTable() . ' (site_id, alert_id, created_on, is_read, is_migrated) VALUES ';
foreach ($occurrences as $entry) {
$sql .= '(' . $entry['site_id'] . ', ' . $entry['alert_id'] . ', ' . $entry['created_on'] . ', ' . $entry['is_read'] . ', 1), ';
}
$sql = rtrim($sql, ", ");
$wpdb->query($sql);
// Load data Meta from External DB
$meta = new WSAL_Adapters_MySQL_Meta($_wpdb);
if (!$meta->IsInstalled()) {
die("No alerts to import");
}
$sql = 'SELECT * FROM ' . $meta->GetTable();
$metadata = $_wpdb->get_results($sql, ARRAY_A);
// Insert data to WP
$metaWP = new WSAL_Adapters_MySQL_Meta($wpdb);
$sql = 'INSERT INTO ' . $metaWP->GetWPTable() . ' (occurrence_id, name, value) VALUES ';
foreach ($metadata as $entry) {
$sql .= '(' . $entry['occurrence_id'] . ', \'' . $entry['name'] . '\', \'' . $entry['value'] . '\'), ';
}
$sql = rtrim($sql, ", ");
$wpdb->query($sql);
}
