[platal.git] / upgrade / 1.0.1 / tokenize_job_terms.php

#!/usr/bin/php5
<?php
require_once 'connect.db.inc.php';

$globals->debug = 0; //do not store backtraces

$terms = XDB::iterator('SELECT `jtid`, `name` FROM `profile_job_term_enum`');
while ($term = $terms->next()) {
    $tokens = array_unique(JobTerms::tokenize($term['name']));
    if (!count($tokens)) {
        continue;
    }
    $values = array();
    foreach ($tokens as $t) {
        $values[] = '('.XDB::escape($t).','.XDB::escape($term['jtid']).')';
    }
    XDB::execute('INSERT IGNORE INTO `profile_job_term_search` (`search`,`jtid`) VALUES '.implode(',',$values));
}

/* vim:set et sw=4 sts=4 ts=4: */
?>
Commit	Line	Data
468c1813 PC	1	#!/usr/bin/php5
	2	<?php
	3	require_once 'connect.db.inc.php';
468c1813 PC	4
	5	$globals->debug = 0; //do not store backtraces
	6
	7	$terms = XDB::iterator('SELECT `jtid`, `name` FROM `profile_job_term_enum`');
	8	while ($term = $terms->next()) {
3ac45f10	9	$tokens = array_unique(JobTerms::tokenize($term['name']));
468c1813 PC	10	if (!count($tokens)) {
	11	continue;
	12	}
	13	$values = array();
	14	foreach ($tokens as $t) {
	15	$values[] = '('.XDB::escape($t).','.XDB::escape($term['jtid']).')';
	16	}
	17	XDB::execute('INSERT IGNORE INTO `profile_job_term_search` (`search`,`jtid`) VALUES '.implode(',',$values));
	18	}
	19
	20	/* vim:set et sw=4 sts=4 ts=4: */
	21	?>