StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
14398834
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-01-18T12:20:05.193
FavoriteCount
0
LastActivityDate
2013-01-18T12:20:05.193
LastEditDate
LastEditorUserId
0
OwnerUserId
330978
ParentId
14341531
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
There has been a problem with ORM JOINS. id to role_id I've changed the mapping from One-To-One Bidirectional to One-To-One, Unidirectional with Join Table. Full code: Users.php <pre><code><?php namespace Trucking\MainBundle\Entity; use Doctrine\ORM\Mapping as ORM; use Symfony\Component\Security\Core\User\UserInterface; /** * Trucking\MainBundle\Entity\Users * * @ORM\Table(name="Users") * @ORM\Entity */ class Users implements UserInterface { /** * @var integer $id * * @ORM\Column(name="id", type="integer") * @ORM\Id * @ORM\GeneratedValue(strategy="IDENTITY") */ protected $id; /** * @var string $password * * @ORM\Column(name="password", type="string", length=15) */ protected $password; /** * @var string $username * * @ORM\Column(name="username", type="string", length=30) */ protected $username; /** * @var string $description * * @ORM\Column(name="description", type="string", length=20) */ protected $description; /** * @var string $permissions * * @ORM\Column(name="permissions", type="string", length=300) */ protected $permissions; /** * @var integer $company_id * * @ORM\Column(name="company_id", type="integer") */ protected $company_id; /** * @var integer $role_id * * @ORM\Column(name="role_id", type="integer") */ protected $role_id; /** * @ORM\OneToOne(targetEntity="Company") * @ORM\JoinColumn( name="company_id", referencedColumnName="id" ) */ protected $companies; /** * @ORM\OneToOne(targetEntity="UsersRole") * @ORM\JoinColumn( name="role_id", referencedColumnName="id" ) */ protected $listRoles; public function __construct() { } /** * Get id * * @return integer */ public function getId() { return $this->id; } /** * Set password * * @param string $password * @return Users */ public function setPassword($password) { $this->password = sha1($password); return $this; } /** * Get password * * @return string */ public function getPassword() { return $this->password; } /** * Set username * * @param string $username * @return Users */ public function setUsername($username) { $this->username = $username; return $this; } /** * Get username * * @return string */ public function getUsername() { return $this->username; } /** * Set description * * @param string $description * @return Users */ public function setDescription($description) { $this->description = $description; return $this; } /** * Get description * * @return string */ public function getDescription() { return $this->description; } /** * Set permissions * * @param string $permissions * @return Users */ public function setPermissions($permissions) { $this->permissions = $permissions; return $this; } /** * Get permissions * * @return string */ public function getPermissions() { return $this->permissions; } /** * Set company_id * * @param Company $company_id * @return Users */ public function setCompanyId($company_id) { $this->company_id = $company_id; return $this; } /** * Get company_id * * @return integer */ public function getCompanyId() { return $this->company_id; } public function equals(UserInterface $user) { return $this->getUsername() == $user->getUsername(); } public function eraseCredentials() { } /** * Get roles * * @return String */ public function getRoles() { $roles = $this->getListRoles(); return (array)$roles->getName(); } /** * Get roles * * @return \UsersRole */ public function getListRoles() { return $this->listRoles; } /** * Set roles * * @param \UsersRole * @return Users */ public function setListRoles($roles) { $this->listRoles = $roles; return $this; } /** * Set role_id * * @param integer * @return Users */ public function setRoleID($roleId) { $this->role_id = $roleId; return $this; } public function getSalt() { } /** * Get company * * @return Company */ public function getCompanies() { return $this->companies; } /** * Set company * * @param Company $company * @return Users */ public function setCompanies($company) { $this->companies = $company; return $this; } } </code></pre> UsersRole.php <pre><code><?php namespace Trucking\MainBundle\Entity; use Doctrine\ORM\Mapping as ORM; /** * USERS_ROLE * * @ORM\Table(name="USERS_ROLE") * @ORM\Entity */ class UsersRole { /** * @var integer * * @ORM\Column(name="id", type="integer") * @ORM\Id * @ORM\GeneratedValue(strategy="AUTO") */ protected $id; /** * @var string * * @ORM\Column(name="name", type="string", length=30) */ protected $name; /** * @var string * * @ORM\Column(name="description", type="string", length=200) */ protected $description; /** * Get id * * @return integer */ public function getId() { return $this->id; } /** * Set name * * @param string $name * @return USERS_ROLE */ public function setName($name) { $this->name = $name; return $this; } /** * Get name * * @return string */ public function getName() { return $this->name; } /** * Set description * * @param string $description * @return USERS_ROLE */ public function setDescription($description) { $this->description = $description; return $this; } /** * Get description * * @return string */ public function getDescription() { return $this->description; } } </code></pre> The controller hasn't been changed <pre><code>public function editAction($id) { $user = $this->getDoctrine() ->getEntityManager() ->getRepository('TruckingMainBundle:Users') ->find($id); if (!$user) { throw $this->createNotFoundException('Unable to find user id.'); } $form = $this->createForm(new \Trucking\AdminBundle\Form\UserType(), $user); $request = $this->getRequest(); //save data if ($request->getMethod() == 'POST') { $form->bindRequest($request); if ($form->isValid()) { $em = $this->getDoctrine()->getEntityManager(); $em->persist($user); $em->flush(); return $this->redirect($this->generateUrl('tracking_admin_users')); } } return $this->render('TruckingAdminBundle:user:edit.html.twig', array( 'id' => $id, 'form' => $form->createView() ) ); } </code></pre> UserType.php <pre><code><?php namespace Trucking\AdminBundle\Form; use Symfony\Component\Form\AbstractType; use Symfony\Component\Form\FormBuilderInterface; use Symfony\Component\Validator\Constraints; class UserType extends AbstractType { public function buildForm(FormBuilderInterface $builder, array $options) { $builder ->add("username","text",array( "label" => "Name", 'attr' => array( 'class' => 'input-xlarge', ), 'constraints' => new Constraints\Length(array('min' => 3)) )) ->add("password","password",array( "label" => "Password", 'attr' => array( 'class' => 'input-xlarge', ), 'constraints' => new Constraints\Length(array('min' => 3)) )) ->add("listRoles","entity",array( 'label' => 'Roles', 'class' => 'TruckingMainBundle:UsersRole' , 'property' => 'name' )) ->add("companies","entity",array( 'label' => 'Companies', 'class' => 'TruckingMainBundle:Company' , 'property' => 'name' )) ->add("description","text",array( "label" => "Description", 'attr' => array( 'class' => 'input-xlarge' ), 'constraints' => new Constraints\NotBlank() )); } public function getName() { return 'trucking_adminbundle_usertype'; } } </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POsymfony2 selected option
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USDezigo
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POsymfony2 selected option
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.