3 require_once 'connect.db.inc.php';
5 $globals->debug
= 0; //do not store backtraces
7 $data = implode('', file('arbo-UTF8.xml'));
8 $parser = xml_parser_create();
9 xml_parser_set_option($parser, XML_OPTION_CASE_FOLDING
, 0);
10 xml_parser_set_option($parser, XML_OPTION_SKIP_WHITE
, 1);
11 xml_parse_into_struct($parser, $data, $values, $tags);
12 xml_parser_free($parser);
14 // loop through the structures
15 foreach ($values as $val) {
16 if ($val['tag'] == 'grand-domaine' && $val['type'] == 'open') {
17 $res = XDB
::execute('INSERT INTO profile_job_sector_enum (name)
19 ucfirst(mb_strtolower($val['attributes']['intitule'])));
20 $sectorid = XDB
::insertId();
22 if ($val['tag'] == 'domaine' && $val['type'] == 'open') {
23 $res = XDB
::execute('INSERT INTO profile_job_subsector_enum (sectorid, name)
25 $sectorid, $val['attributes']['intitule']);
26 $subsectorid = XDB
::insertId();
28 if ($val['tag'] == 'domaine-intermediaire' && $val['type'] == 'open') {
29 $res = XDB
::execute('INSERT INTO profile_job_subsector_enum (sectorid, name, flags)
30 VALUES ({?}, {?}, \'optgroup\')',
31 $sectorid, $val['attributes']['intitule']);
33 if ($val['tag'] == 'fiche' && $val['type'] == 'open') {
34 $res = XDB
::execute('INSERT INTO profile_job_subsubsector_enum (sectorid, subsectorid, name)
35 VALUES ({?}, {?}, {?})',
36 $sectorid, $subsectorid, $val['attributes']['intitule']);
37 $subsubsectorid = XDB
::insertId();
40 if ($val['tag'] == 'appellation' && $val['type'] == 'complete') {
41 $res = XDB
::execute('INSERT INTO profile_job_alternates (id, subsubsectorid, name)
42 VALUES ({?}, {?}, {?})',
43 $id, $subsubsectorid, $val['attributes']['intitule']);
48 /* vim:set et sw=4 sts=4 ts=4: */