/** * Load saved search sql files into the DB. */ public function loadSavedSearches() { $dsn = CRM_Core_Config::singleton()->dsn; foreach (glob(dirname(__FILE__) . "/SavedSearchDataSets/*.sql") as $file) { CRM_Utils_File::sourceSQLFile($dsn, $file); } }
function civicrm_api3_speakcivi_update_stats($params) { $config = CRM_Core_Config::singleton(); $sql = file_get_contents(dirname(__FILE__) . '/../../sql/update.sql', true); CRM_Utils_File::sourceSQLFile($config->dsn, $sql, NULL, true); return civicrm_api3_create_success(array("query" => $sql), $params); }
/** * Implements hook_civicrm_install(). * * @link http://wiki.civicrm.org/confluence/display/CRMDOC/hook_civicrm_install */ function offlinerecurringcontributions_civicrm_install() { $extensionDir = dirname(__FILE__) . DIRECTORY_SEPARATOR; $sqlName = $extensionDir . 'sql' . DIRECTORY_SEPARATOR . 'update.sql'; CRM_Utils_File::sourceSQLFile(CIVICRM_DSN, $sqlName); _offlinerecurringcontributions_civix_civicrm_install(); }
/** * @dataProvider dataProvider */ public function testReportOutput($reportClass, $inputParams, $dataSet, $expectedOutputCsvFile) { $config = CRM_Core_Config::singleton(); CRM_Utils_File::sourceSQLFile($config->dsn, dirname(__FILE__) . "/{$dataSet}"); $reportCsvFile = $this->getReportOutputAsCsv($reportClass, $inputParams); $reportCsvArray = $this->getArrayFromCsv($reportCsvFile); $expectedOutputCsvArray = $this->getArrayFromCsv(dirname(__FILE__) . "/{$expectedOutputCsvFile}"); $this->assertCsvArraysEqual($expectedOutputCsvArray, $reportCsvArray); }
/** * Implementation of hook_civicrm_uninstall */ function eventcalendar_civicrm_uninstall() { $cividiscountRoot = dirname(__FILE__) . DIRECTORY_SEPARATOR; $cividiscountSQL = $cividiscountRoot . DIRECTORY_SEPARATOR . 'uninstall.sql'; CRM_Utils_File::sourceSQLFile(CIVICRM_DSN, $cividiscountSQL); // rebuild the menu so our path is picked up CRM_Core_Invoke::rebuildMenuAndCaches(); //return _eventcalendar_civix_civicrm_uninstall(); }
/** * Implementation of hook_civicrm_enable */ function banking_civicrm_enable() { //add the required option groups banking_civicrm_install_options(_banking_options()); // run the update script $config = CRM_Core_Config::singleton(); $sql = file_get_contents(dirname(__FILE__) . '/sql/upgrade.sql', true); CRM_Utils_File::sourceSQLFile($config->dsn, $sql, NULL, true); return _banking_civix_civicrm_enable(); }
function postProcess() { $config = CRM_Core_Config::singleton(); $extenDr = $config->extensionsDir; $sDbScriptsDir = $extenDr . DIRECTORY_SEPARATOR . 'uk.co.vedaconsulting.recurdatafix' . DIRECTORY_SEPARATOR . 'sql' . DIRECTORY_SEPARATOR; CRM_Utils_File::sourceSQLFile(CIVICRM_DSN, sprintf("%supdate.sql", $sDbScriptsDir)); //CRM_Core_Session::setStatus('Updated table civicrm_recur table with membership id', 'Success', 'info'); CRM_Utils_System::redirect(CRM_Utils_System::url('civicrm/recurdatafix/create', 'reset=1')); CRM_Utils_System::civiExit(); }
/** * Load the navigation sql for the domain with the given name. * * @param string $domainName * @param int $domainID */ function _civicrm_load_navigation($domainName, $domainID) { global $civicrm_root; $sqlPath = $civicrm_root . DIRECTORY_SEPARATOR . 'sql'; $config = CRM_Core_Config::singleton(); $generatedFile = $config->uploadDir . DIRECTORY_SEPARATOR . str_replace(' ', '_', $domainName) . uniqid() . 'nav.mysql'; //read the entire string $str = file_get_contents($sqlPath . DIRECTORY_SEPARATOR . 'civicrm_navigation.mysql'); $str = str_replace('SELECT @domainID := id FROM civicrm_domain where name = \'Default Domain Name\'', "SELECT @domainID := {$domainID}", $str); file_put_contents($generatedFile, $str); CRM_Utils_File::sourceSQLFile($config->dsn, $generatedFile, NULL, FALSE); CRM_Core_DAO::executeQuery("UPDATE civicrm_navigation SET label = name WHERE label = ''"); }
/** * Ensure that the required SQL table exists * * @return bool TRUE if table now exists */ static function findCreateTable() { $checkTableSql = "show tables like 'civicrm_queue_item'"; $foundName = CRM_Core_DAO::singleValueQuery($checkTableSql); if ($foundName == 'civicrm_queue_item') { return TRUE; } // civicrm/sql/civicrm_queue_item.mysql $fileName = dirname(__FILE__) . '/../../../sql/civicrm_queue_item.mysql'; $config = CRM_Core_Config::singleton(); CRM_Utils_File::sourceSQLFile($config->dsn, $fileName); // Make sure it succeeded $foundName = CRM_Core_DAO::singleValueQuery($checkTableSql); return $foundName == 'civicrm_queue_item'; }
public function onUninstall() { if (is_callable(array($this, 'uninstall'))) { $this->uninstall(); } $files = glob($this->extensionDir . '/sql/*_uninstall.sql'); if (is_array($files)) { foreach ($files as $file) { CRM_Utils_File::sourceSQLFile(CIVICRM_DSN, $file); } } $this->setCurrentRevision(NULL); }
function source($fileName, $isQueryString = false) { require_once 'CRM/Utils/File.php'; CRM_Utils_File::sourceSQLFile($this->_config->dsn, $fileName, null, $isQueryString); }
public static function dropAllTables() { // first drop all the custom tables we've created CRM_Core_BAO_CustomGroup::dropAllTables(); // drop all multilingual views CRM_Core_I18n_Schema::dropAllViews(); CRM_Utils_File::sourceSQLFile(CIVICRM_DSN, dirname(__FILE__) . DIRECTORY_SEPARATOR . '..' . DIRECTORY_SEPARATOR . '..' . DIRECTORY_SEPARATOR . 'sql' . DIRECTORY_SEPARATOR . 'civicrm_drop.mysql'); }
static function dropAllTables() { // first drop all the custom tables we've created require_once 'CRM/Core/BAO/CustomGroup.php'; CRM_Core_BAO_CustomGroup::dropAllTables(); // drop all multilingual views require_once 'CRM/Core/I18n/Schema.php'; CRM_Core_I18n_Schema::dropAllViews(); require_once 'CRM/Utils/File.php'; CRM_Utils_File::sourceSQLFile(CIVICRM_DSN, dirname(__FILE__) . DIRECTORY_SEPARATOR . '..' . DIRECTORY_SEPARATOR . '..' . DIRECTORY_SEPARATOR . 'sql' . DIRECTORY_SEPARATOR . 'civicrm_drop.mysql'); }
/** * Implementation of hook_civicrm_install */ function sepa_civicrm_install() { $config = CRM_Core_Config::singleton(); //create the tables $sql = file_get_contents(dirname(__FILE__) . '/sql/sepa.sql', true); CRM_Utils_File::sourceSQLFile($config->dsn, $sql, NULL, true); return _sepa_civix_civicrm_install(); }
/** * @param string $fileName * @param bool $isQueryString */ public function source($fileName, $isQueryString = FALSE) { CRM_Utils_File::sourceSQLFile($this->_config->dsn, $fileName, NULL, $isQueryString); }
/** * Load saved search sql files into the DB. */ public function loadSavedSearches() { foreach (glob(dirname(__FILE__) . "/SavedSearchDataSets/*.sql") as $file) { CRM_Utils_File::sourceSQLFile(NULL, $file); } }
/** * Implementation of hook_civicrm_disable */ function olarkchat_civicrm_disable() { foreach (glob(__DIR__ . '/sql/*_disable.sql') as $file) { CRM_Utils_File::sourceSQLFile(CIVICRM_DSN, $file); } return _olarkchat_civix_civicrm_disable(); }