I don&#39;t believe there&#39;s a default way of doing this. What you could do is to write your own service that adds a `Filter` to your `Doctrine` DQL queries.

For more info, see:
- https://www.doctrine-project.org/projects/doctrine-orm/en/2.7/reference/filters.html
- https://www.doctrine-project.org/projects/doctrine-orm/en/2.7/cookbook/dql-custom-walkers.html

Hope this helps!

From a content script, is it possible to access that tab&#39;s `id`? 

I want to send a message to the background page from the content script that tells my extension to &quot;do something with this tab&quot; using the `chrome.tabs.*` API. 

A `tabID` is needed, and there is no point in doing a bunch of logic in the background page to hunt for a `tabID` when my content script can simply tell it the `tabID` in the message contents.

Obtaining &quot;this&quot; tab ID from content script in Chrome extension?

I have a model `Coupon`, and a model `Photo` with a `ForeignKey` to it:

    class Photo(models.Model):
        coupon = models.ForeignKey(Coupon,
                                   related_name=&#39;description_photos&#39;)
        title = models.CharField(max_length=100)
        image = models.ImageField(upload_to=&#39;images&#39;)

I set up inlines in the admin so now I&#39;m able to add photos to a coupon from the admin.

I attempt to add one, and upload is successful, but then I get Django&#39;s debug page with this error:

    IntegrityError at /admin/coupon/coupon/321/
    (1452, &#39;Cannot add or update a child row: a foreign key constraint fails (`my_project`.`coupon_photo`, CONSTRAINT `coupon_id_refs_id_90d7f06` FOREIGN KEY (`coupon_id`) REFERENCES `coupon_coupon` (`id`))&#39;)

What is this and how can I solve this problem?

(If it matters, this is a MySQL database.)

**EDIT:** I tried it on an Sqlite3 database that has a slightly different dataset, and it worked, so perhaps there&#39;s loose data in my current DB? How can I find it and delete it?

Django &quot;Cannot add or update a child row: a foreign key constraint fails&quot;

Can someone tell me how to get all entities of one type which are marked with &quot;EDIT&quot; ACL permission?

I would like to build a query with the Doctrine EntityManager.

Symfony2: how to get all entities of one type which are marked with &quot;EDIT&quot; ACL permission?

<p>Can someone tell me how to get all entities of one type which are marked with "EDIT" ACL permission?</p>
<p>I would like to build a query with the Doctrine EntityManager.</p>


The problem reduces to counting `\n` characters, so is there a function that can do it on a huge strings, since explode() wastes too much memory.

how to count new lines in a very big string?

I have this json data:

    { 
        userID: &#39;a7664093-502e-4d2b-bf30-25a2b26d6021&#39;,
        itemKind: 0,
        value: 1,
        description: &#39;Saude&#39;,
        itemID: &#39;03e76d0a-8bab-11e0-8250-000c29b481aa&#39;
    }

and I need to post into json url:
http://domain/OnLeagueRest/resources/onleague/Account/CreditAccount

using php how can I send this post request?


Send json post using php

How to calculate how many items in a foreach?

I want to count total rows.


    foreach ($Contents as $item) {
        $item[number];// if there are 15 $item[number] in this foreach, I want get the value : 15
    }


Count number of iterations in a foreach loop

I am looking for a php script or class that can minify my php page html output like google page speed does.

How can I do this?

How to minify php page html output?

If I have a PHP string in the format of `mm-dd-YYYY` (for example, 10-16-2003), how do I properly convert that to a `Date` and then a `DateTime` in the format of `YYYY-mm-dd`? The only reason I ask for both `Date` and `DateTime` is because I need one in one spot, and the other in a different spot.

Converting string to Date and DateTime

I&#39;m trying to make a simple example in order to learn how to delete a row from a parent table and automatically delete the matching rows in the child table using Doctrine2.

Here are the two entities I&#39;m using:

Child.php:

    &lt;?php

    namespace Acme\CascadeBundle\Entity;

    use Doctrine\ORM\Mapping as ORM;

    /**
     * @ORM\Entity
     * @ORM\Table(name=&quot;child&quot;)
     */
    class Child {

        /**
         * @ORM\Id
         * @ORM\Column(type=&quot;integer&quot;)
         * @ORM\GeneratedValue(strategy=&quot;AUTO&quot;)
         */
        private $id;
        /**
         * @ORM\ManyToOne(targetEntity=&quot;Father&quot;, cascade={&quot;remove&quot;})
         *
         * @ORM\JoinColumns({
         *   @ORM\JoinColumn(name=&quot;father_id&quot;, referencedColumnName=&quot;id&quot;)
         * })
         *
         * @var father
         */
        private $father;
    }

Father.php

    &lt;?php
    namespace Acme\CascadeBundle\Entity;

    use Doctrine\ORM\Mapping as ORM;
 
    /**
     * @ORM\Entity
     * @ORM\Table(name=&quot;father&quot;)
     */
    class Father
    {
        /**
         * @ORM\Id
         * @ORM\Column(type=&quot;integer&quot;)
         * @ORM\GeneratedValue(strategy=&quot;AUTO&quot;)
         */
        private $id;
    }

The tables are correctly created on the database, but the On Delete Cascade option it&#39;s not created. What am I doing wrong?

On delete cascade with doctrine2

I am quite new to SF2 and I was wondering how I could manage connections to severals databases into ONE bundle.
For the moment I have this solution - which works fine - but I don&#39;t know if it is the right way to do it....

in myBundle\Ressource\config\config.yml :

    doctrine:
    dbal:
        default_connection:       default
        connections:
            default:
                dbname:           SERVER
                user:             root
                password:         null
                host:             localhost
            client:
                dbname:           CLIENT_134
                user:             root
                password:         null
                host:             localhost
    orm:
        default_entity_manager:   default
        entity_managers:
            default:
                connection:       default
                mappings:
                    MyBundle: ~
            client:
                connection:       client
                mappings:
                    MyBundle: ~
	
   
And then, in order to switch to one of the BD or the other, I do : 

    $O_ressource=  $this-&gt;get(&#39;doctrine&#39;)-&gt;getEntityManager(&#39;client&#39;);
    $O_ressource=  $this-&gt;get(&#39;doctrine&#39;)-&gt;getEntityManager(&#39;default&#39;);


So guys, do you think it is a good way to manage this?


And my second question is :

how to set up dynamic database connection?
I mean I have 100 databases in my system and I can&#39;t set all them in my config.yml file.
So I would like to be able to change database on the fly.

Thanks for the help!

Symfony 2 : multiple and dynamic database connection

I&#39;m developing game app and using Symfony 2.0. I have many AJAX requests to the backend. And more responses is converting entity to JSON. For example: 

    class DefaultController extends Controller
    {           
        public function launchAction()
        {   
            $user = $this-&gt;getDoctrine()
                         -&gt;getRepository(&#39;UserBundle:User&#39;)                
                         -&gt;find($id);
     
            // encode user to json format
            $userDataAsJson = $this-&gt;encodeUserDataToJson($user);
            return array(
                &#39;userDataAsJson&#39; =&gt; $userDataAsJson
            );            
        }
       
        private function encodeUserDataToJson(User $user)
        {
            $userData = array(
                &#39;id&#39; =&gt; $user-&gt;getId(),
                &#39;profile&#39; =&gt; array(
                    &#39;nickname&#39; =&gt; $user-&gt;getProfile()-&gt;getNickname()
                )
            );
            
            $jsonEncoder = new JsonEncoder();        
            return $jsonEncoder-&gt;encode($userData, $format = &#39;json&#39;);
        }
    }

And all my controllers do the same thing: get an entity and encode some of its fields to JSON. I know that I can use normalizers and encode all entitities. But what if an entity has cycled links to other entity? Or the entities graph is very big? Do you have any suggestions? 

I think about some encoding schema for entities... or using `NormalizableInterface` to avoid cycling..,

How to encode Doctrine entities to JSON in Symfony 2.0 AJAX application?

How can I set the `HTML` `class` attribute to a form `&lt;input&gt;` using the `FormBuilder` in `Symfony2` ?

Something like this:

    -&gt;add(&#39;birthdate&#39;, &#39;date&#39;,array(
          &#39;input&#39; =&gt; &#39;datetime&#39;,
          &#39;widget&#39; =&gt; &#39;single_text&#39;,
          &#39;attr&#39; =&gt; array(
              &#39;class&#39; =&gt; &#39;calendar&#39;
          )
     ))

     {{ form_widget(form.birthdate) }}

I want this `input`field with the attribute `class` set to ***calendar***

How to set a class attribute to a Symfony2 form input

I have a Symfony2 Twig template. I want to output the value of a config parameter in this twig template (a version number). Therefore I defined the config parameter like this:

    parameters:
        app.version: 0.1.0

I&#39;m able to use this config parameter in Controllers but I have no clue how to get it in my Twig template. 

How to get config parameters in Symfony2 Twig Templates

How do I use Doctrine in a service container?

The Code just causes an error message &quot;Fatal error: Call to undefined method ...::get()&quot;.

    &lt;?php
        
    namespace ...\Service;

    use Doctrine\ORM\EntityManager;
    use ...\Entity\Header;

    class dsdsf
    { 
        protected $em;

        public function __construct(EntityManager $em)
        {
            $this-&gt;em = $em;
        }
	
        public function create()
        {
            $id = 10;
            $em = $this-&gt;get(&#39;doctrine&#39;)-&gt;getEntityManager();
            $em-&gt;getRepository(&#39;...&#39;)-&gt;find($id);
        }
    }

services.yml

    service:
        site:
            class: ...\Service\Site

Symfony2 Use Doctrine in Service Container

# The error
Cannot delete or update a parent row: a foreign key constraint fails.

# The classes

    class Teacher {

        /**
         *@ORM\OneToMany(targetEntity=&quot;publication&quot;, mappedBy=&quot;teacher&quot;)
         */
        protected $publications;
    }

    class Publication {

        /**
         * @ORM\ManyToOne(targetEntity=&quot;Teacher&quot;, inversedBy=&quot;publications&quot;)
         * @ORM\JoinColumn(name=&quot;teacher_id&quot;, referencedColumnName=&quot;id&quot;)
         */
        protected $teacher;
    }

# I want

What I want is to make it that when you delete a teacher, the id_teacher is modified to NULL. I want to keep the publication but without reference to Professor.

I don&#39;t know how do that in Doctrine, Is it possible? Or always the relationship has to be with a teacher?

Doctrine 2 OneToMany Cascade SET NULL

Let&#39;s suppose I retrieve an entity `$e` and modify its state with setters:

    $e-&gt;setFoo(&#39;a&#39;);
    $e-&gt;setBar(&#39;b&#39;);

Is there any possibility to retrieve an array of fields that have been changed?

In case of my example I&#39;d like to retrieve `foo =&gt; a, bar =&gt; b` as a result

PS: yes, I know I can modify all the accessors and implement this feature manually, but I&#39;m looking for some handy way of doing this

Is there a built-in way to get all of the changed/updated fields in a Doctrine 2 entity

Let&#39;s say I have entity `$e`. Is there any generic way to store it as another row, which would have the same entity data but another primary key?

Why I need this: I&#39;m implementing some sort of [Temporal Database][1] schema and instead of updating the row I just need to create another one.


  [1]: http://en.wikipedia.org/wiki/Temporal_database

How to re-save the entity as another row in Doctrine 2

Been searching for this issue for a while to no avail now:

How to determine fragment is being restored from backstack?
I&#39;m using the compatibility library and a ListFragment inside a FragmentActivity. When an item inside ListFragment is selected, a new Fragment is started to replace the ListFragment.


I noticed that when the FragmentActivity gets paused, the Fragment&#39;s onSaveInstanceState is called. But when the Fragment is put into the back stack via FragmentTransaction, onSaveInstanceState doesn&#39;t get called, then the lifecycle methods onCreateView and onActivityCreated gets called with null savedInstanceState Bundle.

I&#39;m asking this because I want to load some data when the Fragment is created or restored, but not so when user comes back via. backstack.


I&#39;ve looked at https://stackoverflow.com/questions/7659516/how-to-check-if-fragment-was-restored-from-a-backstack
but want to add more details in hopes this would incite an answer.


Edit:
just noticed http://developer.android.com/reference/android/app/Fragment.html#onSaveInstanceState(android.os.Bundle)
says
&gt;Note however: this method may be called at any time before onDestroy(). There are many situations where a fragment may be mostly torn down (such as when placed on the back stack with no UI showing), but its state will not be saved until its owning activity actually needs to save its state.

So onSaveInstanceState is definitely out of the question...

How to determine fragment restored from backstack

How do you make an AWS S3 public folder private again?

I was testing out some staging data, so I made the entire folder public within a bucket.  I&#39;d like to restrict its access again.  So how do I make the folder private again?

S3: make a public folder private again?

I have a few contributors in my github project. I want to allow only one of them to &quot;push&quot; to master. And this guy is not me (the owner of the repository). Is it possible to do?

How to protect &quot;master&quot; in github?

I&#39;m developing a web application and I currently have the following ACL assigned to the AWS account it uses to access its data:

&lt;!-- language: lang-js --&gt;

    {
      &quot;Statement&quot;: [
        {
          &quot;Sid&quot;: &quot;xxxxxxxxx&quot;, // don&#39;t know if this is supposed to be confidential
          &quot;Action&quot;: [
            &quot;s3:*&quot;
          ],
          &quot;Effect&quot;: &quot;Allow&quot;,
          &quot;Resource&quot;: [
            &quot;arn:aws:s3:::cdn.crayze.com/*&quot;
          ]
        }
      ]
    }

However I&#39;d like to make this a bit more restrictive so that if our AWS credentials were ever compromised, an attacker could not destroy any data.

From the documentation, it looks like I want to allow just the following actions: `s3:GetObject` and `s3:PutObject`, but I specifically want the account to only be able to create objects that don&#39;t exist already - i.e. a PUT request on an existing object should be denied. Is this possible?

Amazon S3 ACL for read-only and write-once access

So far, my preference has been to always use EntityManager&#39;s `merge()` take care of both insert and update. But I have also noticed that merge performs an additional select queries before update/insert to ensure record does not already exists in the database.

Now that I am working on a project requiring extensive (bulk) inserts to the database. From a performance point of view does it make sense to use persist instead of merge in a scenario where I absolutely know that I am always creating a new instance of objects to be persisted?

JPA merge vs. persist

    [Doctrine\ORM\ORMException]   
    The EntityManager is closed.  


After I get a DBAL exception when inserting data, EntityManager closes and I&#39;m not able to reconnect it. 

I tried like this but it didn&#39;t get a connection.

    $this-&gt;em-&gt;close();
    $this-&gt;set(&#39;doctrine.orm.entity_manager&#39;, null);
    $this-&gt;set(&#39;doctrine.orm.default_entity_manager&#39;, null);
    $this-&gt;get(&#39;doctrine&#39;)-&gt;resetEntityManager();
    $this-&gt;em = $this-&gt;get(&#39;doctrine&#39;)-&gt;getEntityManager();



Anyone an idea how to reconnect?

The EntityManager is closed

I have a java EE project using JPA (transaction-type=&quot;JTA&quot;), hibernate as provider. I write my beans to handle the CRUD things. The program running in JBOSS 7 AS.

I have an EntityManagerDAO :

    @Stateful
    public class EntityManagerDao implements Serializable {
    
    	@PersistenceContext(unitName = &quot;dtdJpa&quot;)
    	private EntityManager entityManager;
    
    	@TransactionAttribute(TransactionAttributeType.REQUIRED)
    	public Object updateObject(Object object) {
    		object = entityManager.merge(object);
    		return object;
    	}
    
    	@TransactionAttribute(TransactionAttributeType.REQUIRED)
    	public void createObject(Object object) {
    		entityManager.persist(object);
    	}
    
    	public void refresh(Object object) {
    		entityManager.refresh(object);
    	}
    
    	public &lt;T&gt; T find(Class&lt;T&gt; clazz, Long id) {
    		return entityManager.find(clazz, id);
    	}
    
    	@TransactionAttribute(TransactionAttributeType.REQUIRED)
    	public void deleteObject(Object object) {
    		entityManager.remove(object);
    	}
    }

but when I invoke `deleteObject`, this exception comes out.

&gt; java.lang.IllegalArgumentException: Removing a detached instance com.test.User#5

How is this caused and how can I solve it?

java.lang.IllegalArgumentException: Removing a detached instance com.test.User#5

I have an EJB where I am saving an object to the database.  In an example I have seen, once this data is saved (EntityManager.persist) there is a call to EntityManager.flush();  Why do I need to do this?  The object I am saving is not attached and not used later in the method.  In fact, once saved the method returns and I would expect the resources to be released.  (The example code does this on a remove call as well.)

    if (somecondition) {
        entityManager.persist(unAttachedEntity);
    } else {
        attachedEntityObject.setId(unAttachedEntity.getId());
    }
    entityManager.flush();



What does EntityManager.flush do and why do I need to use it?

In few project I have been successfully using 

    @PersistenceUnit(unitName = &quot;MiddlewareJPA&quot;)
    EntityManagerFactory emf;
    ...
    EntityManager entityManager = emf.createEntityManager();

to obtain `EntityManager` for Database connection, but some days ago I was trying to move my project to `Jboss EAP 6.2` and it couldn&#39;t create `EntityManager`. I was googling it and I found that I should try change `@PersistenceUnit` to

    @PersistenceContext(unitName = &quot;MiddlewareJPA&quot;)
    private EntityManager entityManager;
 
to obtain *EntityManager*. It worked but I don&#39;t know why. What is the difference bettween `PersistenceUnit` and `PersistenceContext`? What are pros and cons of each one? Where should we be using one of them? 


     

Content Type	Original Author	Original Content on Stackoverflow
Question	stoefln	View Question on Stackoverflow
Solution 1 - Php	Daniel Gelling	View Answer on Stackoverflow

Symfony2: how to get all entities of one type which are marked with "EDIT" ACL permission?

Php Problem Overview

Php Solutions

Solution 1 - Php

Django "Cannot add or update a child row: a foreign key constraint fails"

Obtaining "this" tab ID from content script in Chrome extension?

Attributions