private function deleteTable($tableName) { Pap3Compatibility_Migration_OutputWriter::logOnce(" Deleting data from table ".$tableName."....."); $sql = new Gpf_SqlBuilder_DeleteBuilder(); $sql->from->add($tableName); $sql->execute(); Pap3Compatibility_Migration_OutputWriter::log("DONE<br/>"); }
public function execute() { Pap3Compatibility_Migration_OutputWriter::logOnce("Migrating transactions<br/>"); $time1 = microtime(); $this->migrateCommissions(); $this->migrateClicks(); $this->migrateImpressions(); $time2 = microtime(); Pap3Compatibility_Migration_OutputWriter::logDone($time1, $time2); }
public function run() { Pap3Compatibility_Migration_OutputWriter::logOnce("Migrating campaigns<br/>"); $time1 = microtime(); try { $this->loadCampaignSettings(); $this->migrateCampaigns(); $this->insertReferralCommissionType(); $this->migrateGroupsTypesCommissions(); $this->createDefaultCommissionTypes(); $this->migrateUsersInCampaigns(); } catch(Exception $e) { Pap3Compatibility_Migration_OutputWriter::log(" Errror: ".$e->getMessage()."<br/>"); } $time2 = microtime(); Pap3Compatibility_Migration_OutputWriter::logDone($time1, $time2); }
protected function execute() { if($this->isPending('initOutput')) { Pap3Compatibility_Migration_OutputWriter::reset(); Pap3Compatibility_Migration_OutputWriter::logOnce("Starting migration<br/>"); $this->setDone(); } else { Pap3Compatibility_Migration_OutputWriter::initialize(); } if($this->isPending('deleteFromTables')) { $this->deleteFromTables(); $this->setDone(); } if($this->isPending('migrateCampaigns')) { $this->migrateCampaigns(); $this->setDone(); } if($this->isPending('migrateBanners')) { $this->migrateBanners(); $this->setDone(); } if($this->isPending('migratePayouts')) { $this->migratePayouts(); $this->setDone(); } if($this->isPending('migrateAffiliates')) { $this->migrateAffiliates(); $this->setDone(); } if($this->isPending('migrateSettings')) { $this->migrateSettings(); $this->setDone(); } if($this->isPending('migrateTransactions')) { $this->migrateTransactions(); $this->setDone(); } }
private function deleteAffiliates() { Pap3Compatibility_Migration_OutputWriter::logOnce(" Deleting affiliates ....."); // pap users $sql = new Gpf_SqlBuilder_DeleteBuilder(); $sql->from->add(Pap_Db_Table_Users::getName()); $sql->where->add('rtype', '=', 'A'); $sql->execute(); // g_users $inSelect = new Gpf_SqlBuilder_SelectBuilder(); $inSelect->select->add(Pap_Db_Table_Users::ACCOUNTUSERID); $inSelect->from->add(Pap_Db_Table_Users::getName()); $sql = new Gpf_SqlBuilder_DeleteBuilder(); $sql->from->add(Gpf_Db_Table_Users::getName()); $sql->where->add('accountuserid', 'NOT IN', $inSelect, 'AND', false); $sql->execute(); // g_authusers $inSelect = new Gpf_SqlBuilder_SelectBuilder(); $inSelect->select->add(Gpf_Db_Table_Users::AUTHID); $inSelect->from->add(Gpf_Db_Table_Users::getName()); $sql = new Gpf_SqlBuilder_DeleteBuilder(); $sql->from->add(Gpf_Db_Table_AuthUsers::getName()); $sql->where->add('authid', 'NOT IN', $inSelect, 'AND', false); $sql->execute(); // g_userattributes $inSelect = new Gpf_SqlBuilder_SelectBuilder(); $inSelect->select->add(Gpf_Db_Table_Users::ID); $inSelect->from->add(Gpf_Db_Table_Users::getName()); $sql = new Gpf_SqlBuilder_DeleteBuilder(); $sql->from->add(Gpf_Db_Table_UserAttributes::getName()); $sql->where->add('accountuserid', 'NOT IN', $inSelect, 'AND', false); $sql->execute(); // g_gadgets $inSelect = new Gpf_SqlBuilder_SelectBuilder(); $inSelect->select->add(Gpf_Db_Table_Users::ID); $inSelect->from->add(Gpf_Db_Table_Users::getName()); $sql = new Gpf_SqlBuilder_DeleteBuilder(); $sql->from->add(Gpf_Db_Table_Gadgets::getName()); $sql->where->add('accountuserid', 'NOT IN', $inSelect, 'AND', false); $sql->execute(); Pap3Compatibility_Migration_OutputWriter::log("DONE<br/>"); }
public function logOnce($message){ Pap3Compatibility_Migration_OutputWriter::logOnce($message); }