/**
  * Tests for PMA_getEntries() method.
  *
  * @return void
  * @test
  */
 public function testPMAGetEntries()
 {
     $_REQUEST['logtype'] = 'schema';
     $data = array('tracking' => 'tracking', 'ddlog' => array(array('statement' => 'statement1', 'date' => 'date2', 'username' => 'username3')), 'dmlog' => array(array('statement' => 'statement1', 'date' => 'date2', 'username' => 'username3')));
     $filter_users = array("*");
     $filter_ts_to = 9999999999;
     $filter_ts_from = 0;
     $entries = PMA_getEntries($data, $filter_ts_from, $filter_ts_to, $filter_users);
     $this->assertEquals('username3', $entries[0]['username']);
     $this->assertEquals('statement1', $entries[0]['statement']);
 }
Example #2
0
        $_REQUEST['date_from'] = $data['date_from'];
    }
    if (! isset($_REQUEST['date_to'])) {
        $_REQUEST['date_to'] = $data['date_to'];
    }
    if (! isset($_REQUEST['users'])) {
        $_REQUEST['users'] = '*';
    }
    $filter_ts_from = strtotime($_REQUEST['date_from']);
    $filter_ts_to   = strtotime($_REQUEST['date_to']);
    $filter_users   = array_map('trim', explode(',', $_REQUEST['users']));
}

// Prepare export
if (isset($_REQUEST['report_export'])) {
    $entries = PMA_getEntries($data, $filter_ts_from, $filter_ts_to, $filter_users);
}

// Export as file download
if (isset($_REQUEST['report_export'])
    && $_REQUEST['export_type'] == 'sqldumpfile'
) {
    PMA_exportAsFileDownload($entries);
}

$html = '<br />';

/**
 * Actions
 */
if (isset($_REQUEST['submit_mult'])) {