PHP WordPress\Tabulate\DB ChangeTracker Examples

Example #1

File: ChangeTrackerTest.php Project: gitter-badger/tabulate-1

 /**
  * @testdox A record can be deleted, and it's history along with it.
  */
 public function delete()
 {
     // Create two, to make sure only one is deleted.
     $test_types = $this->db->get_table('test_types');
     $test_types->save_record(array('title' => 'First Type'));
     $test_types->save_record(array('title' => 'Second Type'));
     $this->assertEquals(2, $test_types->count_records());
     $test_types->delete_record(2);
     $this->assertEquals(1, $test_types->count_records());
     $changesets = $this->db->get_table(ChangeTracker::changesets_name());
     $this->assertEquals(1, $changesets->count_records());
 }

Example #2

File: uninstall.php Project: gitter-badger/tabulate-1

<?php

if (!defined('ABSPATH') || !defined('WP_UNINSTALL_PLUGIN')) {
    return false;
}
// Clear Grants' option.
$grants = new \WordPress\Tabulate\DB\Grants();
$grants->delete();
// Drop the ChangeTracker's and Reports' tables.
global $wpdb;
$wpdb->query('SET FOREIGN_KEY_CHECKS = 0');
foreach (\WordPress\Tabulate\DB\ChangeTracker::table_names() as $tbl) {
    $wpdb->query("DROP TABLE IF EXISTS `{$tbl}`;");
}
$wpdb->query("DROP TABLE IF EXISTS `" . \WordPress\Tabulate\DB\Reports::reports_table_name() . "`;");
$wpdb->query("DROP TABLE IF EXISTS `" . \WordPress\Tabulate\DB\Reports::report_sources_table_name() . "`;");
$wpdb->query('SET FOREIGN_KEY_CHECKS = 1');