back to notes

mysql import test for symfony

public function executeTest(sfWebRequest $request)
{
$connexion = Doctrine_Manager::getInstance()->getCurrentConnection();
$csv_file = sfConfig::get('sf_upload_dir').'/import.csv';
$query = "LOAD DATA INFILE '$csv_file' INTO TABLE des_service CHARACTER SET utf8
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"'
LINES TERMINATED BY '\n';";
$statement = $connexion->prepare($query);
$statement->execute(array());

$this->setTemplate('index');
}