19,48 → 19,52 |
class Lion1906 extends EfloreScript { |
|
public function executer() { |
$this->initialiserProjet('lion1906'); |
try { |
$this->initialiserProjet('lion1906'); |
|
// Lancement de l'action demandée |
$cmd = $this->getParametre('a'); |
switch ($cmd) { |
case 'chargerTous' : |
$this->chargerStructureSql(); |
$this->chargerMetaDonnees(); |
$this->chargerLion1906(); |
$this->preparerTable(); |
$this->convertirRadianEnDegre(); |
break; |
case 'convertir' : |
$this->preparerTable(); |
$this->convertirRadianEnDegre(); |
break; |
case 'supprimerTous' : |
$this->supprimerTous(); |
break; |
default : |
$this->traiterErreur('Erreur : la commande "%s" n\'existe pas!', array($cmd)); |
// Lancement de l'action demandée |
$cmd = $this->getParametre('a'); |
switch ($cmd) { |
case 'chargerTous' : |
$this->chargerStructureSql(); |
$this->chargerMetaDonnees(); |
$this->chargerLion1906(); |
$this->preparerTable(); |
$this->convertirRadianEnDegre(); |
break; |
case 'convertir' : |
$this->preparerTable(); |
$this->convertirRadianEnDegre(); |
break; |
case 'supprimerTous' : |
$this->supprimerTous(); |
break; |
default : |
throw new Exception("Erreur : la commande '$cmd' n'existe pas!"); |
} |
} catch (Exception $e) { |
$this->traiterErreur($e->getMessage()); |
} |
} |
} |
|
protected function chargerMetaDonnees() { |
$contenuSql = $this->recupererContenu(Config::get('chemins.lion1906Meta')); |
$this->executerScripSql($contenuSql); |
} |
protected function chargerMetaDonnees() { |
$contenuSql = $this->recupererContenu(Config::get('chemins.lion1906Meta')); |
$this->executerScripSql($contenuSql); |
} |
|
private function chargerLion1906() { |
$chemin = Config::get('chemins.lion1906'); |
$table = Config::get('tables.lion1906'); |
$requete = "LOAD DATA INFILE '$chemin' ". |
"REPLACE INTO TABLE $table ". |
'CHARACTER SET latin1 '. |
'FIELDS '. |
" TERMINATED BY ';' ". |
" ENCLOSED BY '' ". |
" ESCAPED BY '\\\' ". |
'IGNORE 1 LINES'; |
$this->getBdd()->requeter($requete); |
} |
private function chargerLion1906() { |
$chemin = Config::get('chemins.lion1906'); |
$table = Config::get('tables.lion1906'); |
$requete = "LOAD DATA INFILE '$chemin' ". |
"REPLACE INTO TABLE $table ". |
'CHARACTER SET latin1 '. |
'FIELDS '. |
" TERMINATED BY ';' ". |
" ENCLOSED BY '' ". |
" ESCAPED BY '\\\' ". |
'IGNORE 1 LINES'; |
$this->getBdd()->requeter($requete); |
} |
|
private function convertirRadianEnDegre() { |
$table = Config::get('tables.lion1906'); |
82,10 → 86,10 |
private function preparerTable() { |
$table = Config::get('tables.lion1906'); |
$requete = "ALTER TABLE $table ". |
'DROP latitude_degre, '. |
'DROP longitude_degre, '. |
'DROP centroide, '. |
'DROP INDEX insee '; |
'DROP latitude_degre, '. |
'DROP longitude_degre, '. |
'DROP centroide, '. |
'DROP INDEX insee '; |
$this->getBdd()->requeter($requete); |
|
$requete = "ALTER TABLE $table ". |
104,8 → 108,8 |
$table = Config::get('tables.lion1906'); |
$requete = "UPDATE $table ". |
"SET latitude_degre = '$latitude_degre', longitude_degre = '$longitude_degre', ". |
" centroide = POINTFROMTEXT('POINT($centre)') ". |
"WHERE insee = '$insee' "; |
" centroide = POINTFROMTEXT('POINT($centre)') ". |
"WHERE insee = '$insee' "; |
$this->getBdd()->requeter($requete); |
} |
|