public function testInsert() { $users = new Application_Model_DbTable_Users(); $newUser = $users->fetchNew(); $newUser->username = '******'; $newUser->password = '******'; $newUser->role = 'administrator'; $newUser->date_created = new Zend_Db_Expr('NOW()'); $id = $newUser->save(); $nick = $users->find($id)->current(); $this->assertSame(2, (int) $nick->id); // check that the date_created has been filled in $this->assertNotNull($nick->date_created); }
public function addAction() { $form = new Application_Form_User(); $form->envoyer->setLabel('Ajouter'); $this->view->form = $form; if ($this->getRequest()->isPost()) { $formData = $this->getRequest()->getPost(); if ($form->isValid($formData)) { $users = new Application_Model_DbTable_Users(); /* * Test supplémentaire */ $erreur = false; /* Vérification que le username n'existe pas */ $where = "username = '******'username') . "'"; $sel = $users->fetchAll($where); if ($sel->count() > 1) { /* Erreur le login existe déjà */ $this->_flashMessage('Login existe déjà'); $erreur = TRUE; } /* Vérification de la zone role */ $role = $form->getValue('role'); if ($role == '') { $role == 'user'; } else { if (strpos('admistrator,user', $role) === FALSE) { $this->_flashMessage('pb role'); $erreur = TRUE; } } if ($erreur) { $form->populate($formData); } else { $newUser = $users->fetchNew(); $newUser->username = $form->getValue('username'); $newUser->password = $form->getValue('password'); $newUser->role = $form->getValue('role'); $newUser->token = $form->getValue('token'); $newUser->date_created = new Zend_Db_Expr('NOW()'); Zend_Debug::dump($newUser); $id = $newUser->save(); $this->_helper->redirector('index'); } } else { $form->populate($formData); } } }