[CRON] INSERT ON DUPLICATE KEY UPDATE

<?php
interface Mode {
	const PROD = 0;
	const DEV = 1;
	const DEBUG_ONE = 2;
	const DEBUG_ALL = 3;
}
class SegmenterRequete {

	private $debut;
	private $fin;

	private $requete;
	private $n;

	public $separateur = ', ';
	public $guillemet = "'";
	public $mode = Mode::PROD;
	public $pause = 2;
	public $max = 200;


	public function __construct($debut, $fin){
		$this->debut = $debut;
		$this->fin = $fin;

		$this->initialiser_requete();
	}
	public function __destruct(){
		// si les enregistrements n'ont pas tous ete faits
		if (0 < $this->n) {
			// nettoyer la requete : supprimer son dernier separateur
			$this->requete = substr($this->requete, 0, -strlen($this->separateur));
			$this->executer();
		}
	}
	private function initialiser_requete(){
		// ecrire une nouvelle requete
		$this->requete = $this->debut;
		$this->n = 0;
	}
	private function executer(){
		$this->requete .= $this->fin;
		switch ($this->mode) {
		case Mode::PROD:
			mysql_query($this->requete);
			sleep($this->pause);
			break;
		case Mode::DEV:
			mysql_query($this->requete);
			// pas de break, on "passe" au cas suivant
		case Mode::DEBUG_ONE:
			die($this->requete);
			break;
		case Mode::DEBUG_ALL:
			print($this->requete) . "\n<br/>";
			break;
		}
	}

	public function ajouter(){
		return $this->ajouter_tableau(func_get_args());
	}
	public function ajouter_tableau($data){
		$data = array_map('mysql_real_escape_string', $data);
		$chaine = '(' . $this->guillemet . implode($this->guillemet . ', ' . $this->guillemet, $data) . 

$this->guillemet . ')';
		return $this->concatener($chaine);
	}
	public function concatener($ch){
		$this->requete .= $ch;
		if (++$this->n < $this->max) {
			$this->requete .= $this->separateur;
		}
		else {
			$this->executer();
			$this->initialiser_requete();
		}
		return $this;
	}
}
/** un exemple fictif

$Q = new SegmenterRequete('INSERT INTO T (pop, top) VALUES ', ' ON DUPLICATE KEY UPDATE SET pop = VALUES(pop);');
$Q->mode = Mode::DEBUG_ALL;
$Q->max = 2;

$Q->ajouter('lol', 'mom');
$Q->ajouter('lol', 'mom');
$Q->concatener("('lol','')");
 */