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

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