/**
* Index Page for this controller.
*
* Maps to the following URL
* http://example.com/index.php/welcome
* - or -
* http://example.com/index.php/welcome/index
* - or -
* Since this controller is set as the default controller in
* config/routes.php, it's displayed at http://example.com/
*
* So any other public methods not prefixed with an underscore will
* map to /index.php/welcome/<method_name>
* @see http://codeigniter.com/user_guide/general/urls.html
*/
public function index()
{
$this->load->library('doctrine');
$group = new Entity\UserGroup();
$group->setName('Users');
$user = new Entity\User();
$user->setUsername('wildlyinaccurate');
$user->setPassword('Passw0rd');
$user->setEmail('*****@*****.**');
$user->setGroup($group);
// When you have set up your database, you can persist these entities:
// $em = $this->doctrine->em;
// $em->persist($group);
// $em->persist($user);
// $em->flush();
$this->load->view('welcome_message', array('user' => $user, 'group' => $group));
}
protected function execute(InputInterface $input, OutputInterface $output)
{
$username = $input->getArgument('username');
$password = $input->getArgument('password');
$email = $input->getArgument('email');
$user = new \Entity\User();
$user->setUsername($username);
$user->setEmail($email);
$user->setIsActive(true);
if ($roles = $input->getOption('roles')) {
$user->setRoles($roles);
}
// encode the password
$this->getHelper('users')->getUserProvider()->setUserPassword($user, $password);
$this->getHelper('em')->getEntityManager()->persist($user);
$this->getHelper('em')->getEntityManager()->flush();
$output->writeln(sprintf('<info>Added %s user with password %s</info>', $username, $password));
}
public function test()
{
$this->load->library('doctrine');
$em = $this->doctrine->em;
/** @var $userGroup Entity\UserGroup */
$userGroup = $em->getRepository('Entity\\UserGroup')->find(1);
$name = '111';
$email = '*****@*****.**';
/** @var $userInfo Entity\User */
$userInfo = $em->getRepository('Entity\\User')->findOneBy(['username' => $name]);
if ($userInfo) {
throw Doctrine\DBAL\Exception\NotNullConstraintViolationException::unknownColumnType("{$name} 已存在");
}
$user = new Entity\User();
$user->setUsername($name);
$user->setPassword($name);
$user->setEmail($email);
$user->setGroup($userGroup);
$em->persist($user);
$em->flush();
}
