Use the JoinColumn annotation on your ManyToOne relation:

    /**
     * @ORM\ManyToOne(targetEntity=&quot;Package&quot;, inversedBy=&quot;users&quot;)
     * @ORM\JoinColumn(name=&quot;package_id&quot;, referencedColumnName=&quot;id&quot;, nullable=false)
     */
    private $package;

The ManyToOne itself cannot be nullable, because it doesn&#39;t relate to a specific column. The JoinColumn on the other hand identifies the column in the database. Thus, you can use &quot;normal&quot; attributes like nullable or unique!

Only  

@ORM\JoinColumn(nullable=false) 

is required


How can I assign the maximum value for a long integer to a variable, similar, for example, to C++&#39;s `LONG_MAX`.

Maximum value for long integer

OMG, what I&#39;ve done? 

Couple of days ago, I tried using macport to install something, because I&#39;m using Xcode 4.3 and the command-line tool hadn&#39;t been installed by the time, macport wouldn&#39;t work. So I followed some guide to get command-line tool installed, then I used following command:

    sudo xcode-select -switch /Applications/Xcode.app/

which I think screwed everything except macport: now, in Xcode, even a simple single-view iOS project won&#39;t be compiled, it says &quot;UIKit/UIKit.h not found&quot;.

Does anyone know how to correct this? I don&#39;t want to re-install the gigantic Xcode again, gotta do some iOS project tonight, help!

Xcode stops working after set &quot;xcode-select -switch&quot;

An `User` has one `Package` associated with it. Many users can refer to the same package. `User` cannot exists without a `Package` defined. `User` should own the relation. Relation is bidirectional, so a `Package` has zero or more users in it. 

These requirements lead to `ManyToOne` relation for `User` and `OneToMany` relation of `Package` in Doctrine 2. However `package_id` in `user` table (that is foreign-key) allows `null` values. I&#39;ve tried setting `nullable=false` but command:

     php app/console doctrine:generate:entities DL --path=&quot;src&quot; --no-backup

Says that there is no attribute `nullable` for the relation `ManyToOne`. **What i&#39;m missing?**

    class User
    {
    
        /**
         * @ORM\Id
         * @ORM\Column(type=&quot;integer&quot;)
         * @ORM\GeneratedValue(strategy=&quot;AUTO&quot;)
         */
        private $id;
    
        /**
         * @ORM\ManyToOne(targetEntity=&quot;Package&quot;, inversedBy=&quot;users&quot;)
         */
        private $package;
    
    }

    class Package
    {
    
        /**
         * @ORM\Id
         * @ORM\Column(type=&quot;integer&quot;)
         * @ORM\GeneratedValue(strategy=&quot;AUTO&quot;)
         */
        private $id;
    
        /**
         * @ORM\OneToMany(targetEntity=&quot;User&quot;, mappedBy=&quot;package&quot;)
         */
        private $users;
    
    }

Doctrine 2 can&#39;t use nullable=false in manyToOne relation?

An <code>User</code> has one <code>Package</code> associated with it. Many users can refer to the same package. <code>User</code> cannot exists without a <code>Package</code> defined. <code>User</code> should own the relation. Relation is bidirectional, so a <code>Package</code> has zero or more users in it.
These requirements lead to <code>ManyToOne</code> relation for <code>User</code> and <code>OneToMany</code> relation of <code>Package</code> in Doctrine 2. However <code>package_id</code> in <code>user</code> table (that is foreign-key) allows <code>null</code> values. I've tried setting <code>nullable=false</code> but command:
<pre><code class="hljs language-ini"> php app/console doctrine:generate:entities DL --path="src" --no-backup
</code></pre>
Says that there is no attribute <code>nullable</code> for the relation <code>ManyToOne</code>. What i'm missing?
<pre><code class="hljs language-ini">class User
{

 /**
 * @ORM\Id
 * @ORM\Column(type="integer")
 * @ORM\GeneratedValue(strategy="AUTO")
 */
 private $id;

 /**
 * @ORM\ManyToOne(targetEntity="Package", inversedBy="users")
 */
 private $package;

}

class Package
{

 /**
 * @ORM\Id
 * @ORM\Column(type="integer")
 * @ORM\GeneratedValue(strategy="AUTO")
 */
 private $id;

 /**
 * @ORM\OneToMany(targetEntity="User", mappedBy="package")
 */
 private $users;

}
</code></pre>

I am very new to symfony. In other languages like java and others I can use `request.getParameter(&#39;parmeter name&#39;)` to get the value.

Is there anything similar that we can do with symfony2.   
I have seen some examples but none is working for me. Suppose I have a form field with the name **username**. In the form action I tried to use something like this:

    $request = $this-&gt;getRequest();
    $username= $request-&gt;request-&gt;get(&#39;username&#39;); 

I have also tried 


`$username = $request-&gt;getParameter(&#39;username&#39;);` 

and

    $username=$request-&gt;request-&gt;getParameter(&#39;username&#39;);

But none of the options is working.However following worked fine:

    foreach($request-&gt;request-&gt;all() as $req){
   	    print_r($req[&#39;username&#39;]);
    }

Where am I doing wrong in using `getParameter()` method. Any help will be appreciated.

How to get the request parameters in Symfony 2?

i&#39;m building a mobile app talking to my symfony2 app via webservices
I can&#39;t find a way to disable csrf protection on a specific controller/action

i want to post registration data to this action and use sf2 form validation. I do not call the form in my mobile app

Can&#39;t change container parameters in action, throw an exception because it is a frozen parameter...

I do not want to disable form protection for whole my application

any clue ?

thanks !


**update: with symfony 2.1.x**

    /**
     * {@inheritdoc}
     */
    public function setDefaultOptions(OptionsResolverInterface $resolver)
    {
        $resolver-&gt;setDefaults(array(
            &#39;csrf_protection&#39;   =&gt; false,
        ));
    }





Disable symfony 2 csrf token protection on ajax submit

I&#39;m aware of questions like [this][1], where people tend to discuss the general Symfony 2 concept of bundle.

The thing is, in a specific application, like, for instance, a twitter-like application, should everything really be inside a generic bundle, like the [official docs][2] say? 

The reason I&#39;m asking this is because when we develop applications, in general, we don&#39;t want to highly couple our code to some full-stack glue framework.

If I develop a Symfony 2 based application and, at some point, I decide Symfony 2 is not really the best choice to *keep the development going*, will that be a problem for me?

So the general question is: why is everything being a bundle a good thing? 

**EDIT#1**

Almost a year now since I asked this question I wrote an [article][3] to share my knowledge on this topic.

  [1]: https://stackoverflow.com/questions/7958346/an-exact-description-of-a-symfony-bundle-in-a-complex-web-application
  [2]: http://symfony.com/doc/2.7/page_creation.html#bundles-configuration
  [3]: https://medium.com/@drgomesp/yes-you-can-have-low-coupling-in-a-symfony-standard-edition-application-41c5a34aaf94

Should everything really be a bundle in Symfony 2.x?

Is there any convenience method that allows me to concatenate two Doctrine `ArrayCollection()`? something like:

    $collection1 = new ArrayCollection();
    $collection2 = new ArrayCollection();

    $collection1-&gt;add($obj1);
    $collection1-&gt;add($obj2);
    $collection1-&gt;add($obj3);

    $collection2-&gt;add($obj4);
    $collection2-&gt;add($obj5);
    $collection2-&gt;add($obj6);

    $collection1-&gt;concat($collection2);

    // $collection1 now contains {$obj1, $obj2, $obj3, $obj4, $obj5, $obj6 }

I just want to know if I can save me iterating over the 2nd collection and adding each element one by one to the 1st collection.

Thanks!

How to merge two php Doctrine 2 ArrayCollection()

I have a form that combines two entities (User and Profile).

Validation seems to work on the first part of the form that comes form the User Entity and is the basis of the form.

The ProfileType is included inside the UserType. The form renders correctly and displays the correct information, so it seems it is properly connected to the Profile entity. It&#39;s just the validation that is broken on the ProfileType.

Any idea as to why one part would validate and the other wouldn&#39;t?

Code below:

Validation.yml

    DEMO\DemoBundle\Entity\User\Profile:
        properties:
            address1:
                - NotBlank: { groups: [profile] }
            name:
                - NotBlank: { groups: [profile] }
            companyName:
                - NotBlank: { groups: [profile] }
    
    DEMO\DemoBundle\Entity\User\User:
        properties:
            username:
                - NotBlank:
                    groups: profile
                    message: Username cannot be left blank.
            email:
                - NotBlank:
                    groups: profile
                    message: Email cannot be left blank
                - Email:
                    groups: profile
                    message: The email &quot;{{ value }}&quot; is not a valid email.
                    checkMX: true
            password:
                - MaxLength: { limit: 20, message: &quot;Your password must not exceed {{ limit }} characters.&quot; }
                - MinLength: { limit: 4, message: &quot;Your password must have at least {{ limit }} characters.&quot; }
                - NotBlank: ~

UserType.php

    namespace DEMO\DemoBundle\Form\Type\User;
    
    use Symfony\Component\Form\AbstractType;
    use Symfony\Component\Form\CallbackValidator;
    use Symfony\Component\Form\FormBuilder;
    use Symfony\Component\Form\FormError;
    
    use DEMO\DemoBundle\Form\Type\User\ProfileType;
    
    class UserType extends AbstractType
    {
        public function buildForm(FormBuilder $builder, array $options)
        {
            $builder-&gt;add(&#39;username&#39;);
            $builder-&gt;add(&#39;email&#39;);
            $builder-&gt;add(&#39;profile&#39;, new ProfileType());
        }
        
        public function getDefaultOptions(array $options)
        {
            return array(
                &#39;data_class&#39; =&gt; &#39;DEMO\DemoBundle\Entity\User\User&#39;,
                &#39;validation_groups&#39; =&gt; array(&#39;profile&#39;)
            );
        }
        
        public function getName()
        {
            return &#39;user&#39;;
        }
    }

ProfileType.php

    namespace DEMO\DemoBundle\Form\Type\User;
    
    use Symfony\Component\Form\AbstractType;
    use Symfony\Component\Form\CallbackValidator;
    use Symfony\Component\Form\FormBuilder;
    use Symfony\Component\Form\FormError;
    
    class ProfileType extends AbstractType
    {
        public function buildForm(FormBuilder $builder, array $options)
        {
            $builder-&gt;add(&#39;name&#39;);
            $builder-&gt;add(&#39;companyName&#39;, null, array(&#39;label&#39; =&gt; &#39;Company Name&#39;));
            $builder-&gt;add(&#39;address1&#39;, null, array(&#39;label&#39; =&gt; &#39;Address 1&#39;));
            $builder-&gt;add(&#39;address2&#39;, null, array(&#39;label&#39; =&gt; &#39;Address 2&#39;));
            $builder-&gt;add(&#39;city&#39;);
            $builder-&gt;add(&#39;county&#39;);
            $builder-&gt;add(&#39;postcode&#39;);
            $builder-&gt;add(&#39;telephone&#39;);
        }
    
        public function getDefaultOptions(array $options)
        {
            return array(
                &#39;data_class&#39; =&gt; &#39;DEMO\DemoBundle\Entity\User\Profile&#39;,
            );
        }
    
        public function getName()
        {
            return &#39;profile&#39;;
        }
    }

Controller

    $user = $this-&gt;get(&#39;security.context&#39;)-&gt;getToken()-&gt;getUser();
    
            $form = $this-&gt;createForm(new UserType(), $user);
    
            if ($request-&gt;getMethod() == &#39;POST&#39;) {
                $form-&gt;bindRequest($request);
    
                if ($form-&gt;isValid()) {
                    // Get $_POST data and submit to DB
                    $em = $this-&gt;getDoctrine()-&gt;getEntityManager();
                    $em-&gt;persist($user);
                    $em-&gt;flush();
    
                    // Set &quot;success&quot; flash notification
                    $this-&gt;get(&#39;session&#39;)-&gt;setFlash(&#39;success&#39;, &#39;Profile saved.&#39;);
                }
    
            }
    
            return $this-&gt;render(&#39;DEMODemoBundle:User\Dashboard:profile.html.twig&#39;, array(&#39;form&#39; =&gt; $form-&gt;createView()));

Symfony2 - Validation not working for embedded Form Type

What&#39;s the difference between `Doctrine\Common\Persistence\ObjectManager` and `Doctrine\ORM\EntityManager` when using it in a custom form type?

I can get the respository using both `$this-&gt;em-&gt;getRepository()` and `$this-&gt;om-&gt;getRepository()`.

    class MyFormType extends \Symfony\Component\Form\AbstractType
    {

        /**
         * @var Doctrine\ORM\EntityManager
         */
        protected $em;
    
        public function __construct(Doctrine\ORM\EntityManager $em)
        {
            $this-&gt;em = $em;
        }

     }

Instead of:

    class MyFormType extends \Symfony\Component\Form\AbstractType
    {

        /**
         * @var Doctrine\Common\Persistence\ObjectManager
         */
        protected $om;
    
        public function __construct(Doctrine\Common\Persistence\ObjectManager $om)
        {
            $this-&gt;om = $om;
        }

     }

Difference between ObjectManager and EntityManager in Symfony2?

Is it possible to generate a single entity from database using the Symfony2 console tool?

In the middle of coding I had to add a table and there are modifications made to the existing entity classes. So I don&#39;t want all my entities regenerated. 

Any suggestions will be appreciated!

Generating a single Entity from existing database using symfony2 and doctrine

I need to order data by two columns (when the rows have different values for column number 1, order by it; otherwise, order by column number 2)

I&#39;m using a `QueryBuilder` to create the query.

If I call the `orderBy` method a second time, it replaces any previously specified orderings.

I can pass two columns as the first parameter:

    -&gt;orderBy(&#39;r.firstColumn, r.secondColumn&#39;, &#39;DESC&#39;);

But I cannot pass two ordering directions for the second parameter, so when I execute this query the first column is ordered in an ascending direction and the second one, descending. I would like to use descending for both of them.

Is there a way to do this using `QueryBuilder`? Do I need to use DQL?

Order by multiple columns with Doctrine

My first symfony2 project is a list of guests (invited in an event) stored in a database. I have 

 - created the entity class Guest with all variables for them (id, name, address, phone number etc.) 
 - created the schema in the mysql db
 - created a route for &quot;adding a guest&quot; to a twig template
 - created a formType 

and finally a &quot;createGuest&quot; method in the Controller and everything works fine. 

I can&#39;t manage to remove a guest from the database. I have read every tutorial in the web, including the official Symfony2 book; all that it says is :

**Deleting an Object**

*Deleting an object is very similar, but requires a call to the remove() method of the entity manager:*

&lt;!-- language: lang-php --&gt;

    $em-&gt;remove($product);
    $em-&gt;flush();

It does not say anything more than that (even the &quot;Update an object&quot; section is missing documentation) on how to connect the controller deleteAction($id) with the twig template. What I want to do is to list all guests with a viewGuests action and a viewGuests twig template, having a delete icon next to every row, which you should click to delete an entry. Simple, but I cannot find any documentation and do not know where to start from. 

&lt;!-- language: lang-php --&gt;

    public function deleteGuestAction($id)
        {
            $em = $this-&gt;getDoctrine()-&gt;getEntityManager();
    	    $guest = $em-&gt;getRepository(&#39;GuestBundle:Guest&#39;)-&gt;find($id);
    	
    	    if (!$guest) {
    	        throw $this-&gt;createNotFoundException(&#39;No guest found for id &#39;.$id);
    	    }
    	
    	    $em-&gt;remove($guest);
    	    $em-&gt;flush();
    	
    	    return $this-&gt;redirect($this-&gt;generateUrl(&#39;GuestBundle:Page:viewGuests.html.twig&#39;));
        }





How do I delete an entity from symfony2

I have a WebTestCase that executes some basic routes in my application.

I want to, on the `setUp` method of PHPUnit, create a test database identical to my main database, and load fixtures into it.

I&#39;m currently doing some workaround and executing some console commands, something like this:

    class FixturesWebTestCase extends WebTestCase
    {
        protected static $application;
    
        protected function setUp()
        {
            self::runCommand(&#39;doctrine:database:create&#39;);
            self::runCommand(&#39;doctrine:schema:update --force&#39;);
            self::runCommand(&#39;doctrine:fixtures:load --purge-with-truncate&#39;);
        }
    
        protected static function runCommand($command)
        {
            $command = sprintf(&#39;%s --quiet&#39;, $command);
    
            return self::getApplication()-&gt;run(new StringInput($command));
        }
    
        protected static function getApplication()
        {
            if (null === self::$application) {
                $client = static::createClient();
    
                self::$application = new Application($client-&gt;getKernel());
                self::$application-&gt;setAutoExit(false);
            }
    
            return self::$application;
        }
    }

But I&#39;m quite sure this is not the best approach, especially because the `doctrine:fixtures:load` expects the user to hit a `Y` char to confirm the action.

How can I solve that?

Best way to create a test database and load fixtures on Symfony 2 WebTestCase?

Is there a way to auto quote reserved words with Doctrine 2 when using `$entityManager-&gt;find(&#39;entity&#39;, id)` ?

When using the query builder this can be done but there should be a global configuration setting that does this? I don&#39;t want to have to specify it in the annotations for the reserved words.

Auto quote reserved words with Doctrine 2

I am developing an application using Symfony2 and doctrine 2. I would like to know how can I get the currently logged in user&#39;s Id. 

Symfony getting logged in user&#39;s id

I&#39;m working in the Symfony2 framework and wondering when would one use a Doctrine subscriber versus a listener.  Doctrine&#39;s [documentation][1] for listeners is very clear, however subscribers are rather glossed over.  Symfony&#39;s [cookbook entry][2] is similar.


  [1]: http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/reference/events.html
  [2]: http://symfony.com/doc/current/cookbook/doctrine/event_listeners_subscribers.html

Content Type	Original Author	Original Content on Stackoverflow
Question	gremo	View Question on Stackoverflow
Solution 1 - Symfony	Sgoettschkes	View Answer on Stackoverflow
Solution 2 - Symfony	MauroB	View Answer on Stackoverflow

Doctrine 2 can't use nullable=false in manyToOne relation?

Symfony Problem Overview

Symfony Solutions

Solution 1 - Symfony

Solution 2 - Symfony

Xcode stops working after set "xcode-select -switch"

Maximum value for long integer

Attributions