/** * method to intialize temporary upload table * @returns boolean */ protected function createTempUploadTable() { if (!I2CE_Util::runSQLScript('initialize_temp_upload.sql')) { I2CE::raiseError("Could not initialize tempoary upload table"); return false; } return true; }
/** * Method called when the module is enabled for the first time. * @param boolean -- returns true on success. false on error. */ public function action_initialize() { I2CE::raiseError("Initializing UUID Map Tables"); if (!I2CE_Util::runSQLScript('init_uuid_table.sql')) { I2CE::raiseError("Could not initialize uuid table"); return false; } return true; }
public function action_initialize() { I2CE::raiseError("Initializing Form Tables"); if (!I2CE_Util::runSQLScript('initialize_importexport.sql')) { I2CE::raiseError("Could not initialize I2CE import_export table"); return false; } return true; }
/** * Method called when the module is enabled for the first time. * @param boolean -- returns true on success. false on error. */ public function action_initialize() { I2CE::raiseError("Initializing Provider Cache Table"); if (!I2CE_Util::runSQLScript('initialize_csd_cache.sql')) { I2CE::raiseError("Could not initialize I2CE form tables"); return false; } return true; }
/** * Method called when the module is enabled for the first time. * @param boolean -- returns true on success. false on error. */ public function action_initialize() { //load the data right now because the site isn't ready to run background processes I2CE::raiseError("Loading Sample Data"); if (!I2CE_Util::runSQLScript('TrainSampleData.sql')) { I2CE::raiseError("Could not initialize Train Sample Data tables"); return false; } return true; }
private function addBlobValue() { $db = MDB2::singleton(); $rows = $db->queryAll("SHOW FULL COLUMNS FROM entry WHERE Field='blob_value'"); if (count($rows)) { I2CE::raiseError("entry table already has blob_value"); return true; } I2CE::raiseError("Adding blob_value to entry tables"); return I2CE_Util::runSQLScript('add_blob_fields.sql'); }
/** * Upgrade module method * @param string $old_vers * @param string $new_vers */ public function upgrade($old_vers, $new_vers) { if (I2CE_Validate::checkVersion($old_vers, '<', '4.0.11.1')) { if (!I2CE_Util::runSQLScript('initialize_form_store.sql')) { I2CE::raiseError("Could not initialize I2CE form history storage tables"); return false; } } if (I2CE_Validate::checkVersion($old_vers, '<', '4.1.4.1') && !$this->upgradeFormStore()) { I2CE::raiseError("Could not upgrade I2CE form history storage tables"); return false; } return true; }
/** *called from the command line as * --page=BackgroundPage/$script" * Or: * --page=BackgroundPage/$db/$script *Where $db is the database the script is to run on. Make sure $db is not backticked! * */ protected function actionCommandLine($args, $req) { $req = $this->request_remainder; if (count($req) == 1) { //the first (and only) request remaineder is the script I2CE_Util::runSQLScript($req[0]); } else { if (count($req) == 2) { //the first request remainder is the DB to use the second is the script I2CE_Util::runSQLScript($req[1], $req[0]); } else { I2CE::raiseError("Invalid request to run sql script"); } } }
/** * Method called when the module is enabled for the first time. * @param boolean -- returns true on success. false on error. */ public function action_initialize() { /* $site_module = ""; I2CE::getConfig()->setIfIsSet( $site_module, "config/site/module" ); $mod_factory = I2CE_ModuleFactory::instance(); if ( $mod_factory->isEnabled( $site_module ) ) { //launch background import of data. $this->launchBackgroundPage("/BackgroundProcess/SQL/ManageSampleData.sql"); } else { */ //load the data right now because the site isn't ready to run background processes I2CE::raiseError("Loading Sample Data"); if (!I2CE_Util::runSQLScript('ManageSampleData.sql')) { I2CE::raiseError("Could not initialize Manage Sample Data tables"); return false; } /* } */ return true; }
/** * Cache the user statistics pseudo report. * @param boolean $drop_first * @param boolean $force * @return boolean */ public function cacheUserStatistics($drop_first = false, $force = false) { if (!self::setupDB(false)) { return false; } $config = I2CE::getConfig()->modules->UserStatistics->cache; $config->volatile(true); $start = 0; $end = 0; $failed = 0; $config->setIfIsSet($start, "start"); $config->setIfIsSet($end, "end"); $config->setIfIsSet($failed, "failed"); if ($force || $start == 0 || $end != 0 && $end >= $start || $failed != 0 && $failed >= $start) { $config->start = time(); $res = self::$db->getOne("SHOW TABLES LIKE 'zebra__user_statistics'"); if (!$res) { if (!I2CE_Util::runSQLScript('initialize_user_statistics.sql')) { I2CE::raiseError("Could not initialize user statistics cache table."); return false; } } if ($drop_first) { $res = self::$db->query("truncate table zebra__user_statistics"); if (I2CE::pearError($res, "Unable to truncate user statistics cache table.")) { $cache->failed = time(); return false; } } $res = self::$db->query("INSERT INTO zebra__user_statistics SELECT entry.change_type AS `change_type`, entry.date AS `date`, (SELECT CONCAT(parent_form,'|',parent_id) FROM record WHERE id = entry.record) AS `parent_id`, entry.record AS `record`, (SELECT name FROM form WHERE id = (SELECT form FROM form_field WHERE id = entry.form_field)) AS `form`, (SELECT name FROM field WHERE id = (SELECT field FROM form_field WHERE id = entry.form_field)) AS `field`, entry.string_value, entry.integer_value, entry.date_value, entry.text_value, entry.blob_value, IF(entry.who = 0, 'I2CE Admin', (SELECT CONCAT_WS( ' ', user.firstname, user.lastname ) FROM user WHERE id = entry.who)) AS `user`, IF(entry.who = 0, 'i2ce_admin', (SELECT user.username FROM user WHERE id = entry.who)) AS `username` FROM entry WHERE date > IFNULL((SELECT MAX(date) FROM zebra__user_statistics ),'0000-00-00 00:00:00')"); if (I2CE::pearError($res, "Unable to populate user statistics cache table.")) { $cache->failed = time(); return false; } $config->end = time(); I2CE::raiseError("Updated User Statistics report at " . date('r', $config->end)); } return true; }
/** * Method called when the module is enabled for the first time. * @param boolean -- returns true on success. false on error. */ public function action_initialize() { if (!I2CE_Util::runSQLScript('CREATE_formfield_mult_map_componentize.sql', null, false)) { //don;t use a transaction I2CE::raiseError("Could not install remapping SQL function"); return false; } return true; }
/** * Upgrades the modules * @param string $old_vers * @param string $new_vers * @returns boolean */ public function upgrade($old_vers, $new_vers) { I2CE::raiseError("upgrade {$old_vers} -- {$new_vers}"); if (I2CE_Validate::checkVersion($old_vers, '<', '4.1.3.7')) { I2CE::raiseError("Initializing Form Task Logger"); if (!I2CE_Util::runSQLScript('initialize_form_task_log.sql')) { I2CE::raiseError("Could not initialize I2CE form tables"); return false; } } return true; }