Commit | Line | Data |
---|---|---|
761f1bcb SJ |
1 | #!/usr/bin/php5 |
2 | <?php | |
3 | require_once 'connect.db.inc.php'; | |
4 | ||
5 | $globals->debug = 0; //do not store backtraces | |
6 | ||
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); | |
13 | ||
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) | |
18 | VALUES ({?})', | |
53390175 | 19 | ucfirst(mb_strtolower($val['attributes']['intitule']))); |
761f1bcb SJ |
20 | $sectorid = XDB::insertId(); |
21 | } | |
22 | if ($val['tag'] == 'domaine' && $val['type'] == 'open') { | |
23 | $res = XDB::execute('INSERT INTO profile_job_subsector_enum (sectorid, name) | |
24 | VALUES ({?}, {?})', | |
25 | $sectorid, $val['attributes']['intitule']); | |
26 | $subsectorid = XDB::insertId(); | |
27 | } | |
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']); | |
32 | } | |
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(); | |
38 | $id = 0; | |
39 | } | |
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']); | |
44 | ++$id; | |
45 | } | |
46 | } | |
47 | ||
48 | /* vim:set et sw=4 sts=4 ts=4: */ | |
49 | ?> |