\Slim\Slim::registerAutoloader();
$app = new \Slim\Slim();
$app = \Slim\Slim::getInstance();
$db = new dbHelper();
/**
* Database Helper Function templates
*/
/*
select(table name, where clause as associative array)
insert(table name, data as associative array, mandatory column names as array)
update(table name, column names as associative array, where clause as associative array, required columns as array)
delete(table name, where clause as array)
*/
$app->get('/agendas', function () {
global $db;
$rows = $db->selectEquals("agenda", "idAgenda, libAgenda, mail, nbJourOuverture, nbJourLimite,nbJourReins, inscriptionMax,cacheNom,autoIns,commentaire", array());
echoResponse(200, $rows);
});
$app->get('/gestionnaires/:idAgenda', function ($idAgenda) {
global $db;
$rows = $db->selectEquals("gestionnaire_agendas", "mail,idAgenda", array('idAgenda' => $idAgenda));
echoResponse(200, $rows);
});
$app->get('/gestionAg/:mail', function ($mail) {
global $db;
$rows = $db->selectEquals("gestionnaire_agendas", "mail,idAgenda", array('mail' => $mail));
echoResponse(200, $rows);
});
$app->get('/personnes/:mail', function ($mail) {
global $db;
$rows = $db->selectEquals("personne", "mail, nom, prenom, grade, createurAg, admin", array('mail' => $mail));
