public function test_migrateVisits() { $visit = array('idvisit' => 123, 'idsite' => 2, 'visit_exit_idaction_url' => 4, 'visit_exit_idaction_name' => 6, 'visit_entry_idaction_url' => 8, 'visit_entry_idaction_name' => 10); $batchProvider = new \ArrayIterator(array($visit)); $this->toDbHelper->expects($this->once())->method('executeInsert')->with('log_visit', $this->anything()); $this->toDbHelper->expects($this->once())->method('lastInsertId')->will($this->returnValue(321)); $this->siteMigrator->expects($this->once())->method('getNewId')->with(2)->will($this->returnValue(3)); $this->actionMigrator->expects($this->exactly(4))->method('getNewId')->will($this->onConsecutiveCalls(5, 7, 9, 11)); $this->visitMigrator->migrate($batchProvider); $this->assertEquals(321, $this->visitMigrator->getNewId(123)); }
private function migrateLogVisits() { Log::info('Migrating log data - visits'); $query = 'SELECT * FROM ' . $this->sourceDbHelper->prefixTable('log_visit') . ' WHERE idsite = ' . $this->settings->idSite; if ($this->settings->dateFrom) { $query .= ' AND `visit_last_action_time` >= \'' . $this->settings->dateFrom->format('Y-m-d') . '\''; } if ($this->settings->dateTo) { $query .= ' AND `visit_last_action_time` < \'' . $this->settings->dateTo->format('Y-m-d') . '\''; } $this->visitMigrator->migrate($this->getBatchProvider($query)); }