How to Programming with Doctrine

symfony2,doctrine2,doctrine

Thanks for all the help guys. The answer ended up being, in the orm.xml files for doctrine, the generatedvalue would never change, I manually removed the generatedvalue, in the xml document. After this, the insert DML statement worked correctly, and I see the row in my DB. The orm.xml file...

Doctrine doesn't find the rows just flushed

Maybe something like this will work: //In your Question entity add this public function __clone() { $this->id = null; } And modify your code like this: foreach ( $subject->getQuestions() as $question ) { $new_question = clone $question; $this->getEntityManager()->detach($new_question); $new_question->setUser( $user ); $new_question->setAnswers( new ArrayCollection() ); $new_question->setQuestionStatuses( new ArrayCollection() ); $new_question->setOptions(...

How to fetch related objects from second many-to-many relation?

php,symfony2,orm,doctrine

I guess best way would be running a single DQL instead of looping each class and getting topics $DM = $this->getDoctrine()->getManager(); $query = $DM->createQueryBuilder('t') ->select('t') ->from('NamespaceYourBundle:Topic', 't') ->innerJoin('t.class','c') ->innerJoin('c.student','s') ->where('s.id = :id') ->setParameter(':id',$student_id) ->getQuery(); $topics= $query->getResult(); ...

Symfony 2 - Entity has to be managed or scheduled for removal for single computation

php,zend-framework2,doctrine

You need to persist your entity to let the EntityManager knows that it exists. $em->persist($item); $em->flush($item); ...

Fieldset zf2 - populate 2 entities

I did manually and work..but if has any other automatically, can post. thank you. ... $localizacao->setBairro($form->get('pessoajuridica')->get('localizacao')->get('bairro')->getValue()); $localizacao->setCep($form->get('pessoajuridica')->get('localizacao')->get('cep')->getValue()); $localizacao->setCidade($form->get('pessoajuridica')->get('localizacao')->get('cidade')->getValue());...

Symfony2 / Doctrine2 : How to override DebugStack class used in doctrine DataCollector?

php,symfony2,doctrine2,doctrine,override

All DoctrineBundle classes are configured here: https://github.com/doctrine/DoctrineBundle/blob/master/Resources/config/dbal.xml You could probably override "doctrine.dbal.logger.profiling.class" with your own implementation like this: # app/config/config.yml parameters: doctrine.dbal.logger.profiling.class: Acme\HelloBundle\Logging\MyDebugStack And in your class: namespace Acme\HelloBundle\Logging; use Doctrine\DBAL\Logging\DebugStack; class MyDebugStack extends DebugStack { //... } Also, read this section about bundle overriding:...

Doctrine connection with db

php,sql-server,symfony2,doctrine2,doctrine

I develop a multi-database sf2 app with doctrine2 orm mapping. We use intellectsoft-uk/MssqlBundle Our configuration is: config.yml # Doctrine Configuration doctrine: dbal: default_connection: acme_mysql connections: acme_mysql: host: %acme_mysql_database_host% port: %acme_mysql_database_port% dbname: %acme_mysql_database_name% user: %acme_mysql_database_user% password: %acme_mysql_database_password% charset: UTF8 acme_slqsrv: driver: sqlsrv driver_class: \Realestate\MssqlBundle\Driver\PDODblib\Driver host: %acme_slqsrv% port: %acme_slqsrv%...

Symfony2 & Doctrine: Optimizing Query (Fetching EAGER)

php,symfony2,doctrine,dql

That's almost correct. I would change: remove an extra addSelect() - put everything in a single select() change the leftJoin to utilize @ManyToMany relation So, something like this: $customers = $em->createQueryBuilder() ->select('c', 'ph') ->from('AppBundle:Customer', 'c') ->leftJoin('c.phoneNumbers', 'ph') ->orderBy('c.id', 'ASC') ->setFirstResult($offset) ->setMaxResults($max) ->getQuery() ->getResult(); Hope this helps......

Symfony 2 - best approach for summing results of values in related entities

php,validation,symfony2,doctrine,custom-validators

You can solve it in many ways but i like to make an parent entity eg ItemsCollection that holds an arrayCollection of Items. Then i give the new entity some extra functionality e.g. public function countItemValues() { $total = 0; foreach($this->items as $item) { $total += $item->getValue(); } return $total;...

Create small page to display content of the table with Symfony and Doctrine

php,mysql,symfony2,doctrine2,doctrine

You have several issues with your code: Two return statements Creating a form from an array of customers rather than a single entity Not using variable names that you have set in the template Here is what your view might look like: <table> {% for c in customers %} <tr>...

I am getting this error while debugging [duplicate]

php,doctrine

Actually the problem is in line 26. Please change $qb->orderBy('f.dateTime', 'ASC');->setFirstResult($page); to $qb->orderBy('f.dateTime', 'ASC')->setFirstResult($page); Note:- line 25 seems correct.May be the problem due to line 26 only. please try to do like above and check once. thanks....

Do you have to register your custom validators in symfony

Your custom validator must be in the same folder than your constraint. According to your namespaces, it's not the case. If you want to separate them, you can override the validatedBy() method of your Constraint class : public function validatedBy() { return get_class($this).'Validator'; } ...

doctrine does not hydration when select custom fields

doctrine2,doctrine,doctrine-query

You want to use Doctrine's Partial Object Syntax $queryBuilder->select('partial au.{id, firstName}') As to why it's not returning an object, this is from the same documentation linked above: By default when you run a DQL query in Doctrine and select only a subset of the fields for a given entity, you...

In Symfony is there a way to access the app_dev information with REST

php,symfony2,doctrine,deserialization,jmsserializerbundle

When you using development enviorment (app_dev.php) profiler works independend of the fact of displaying toolbar unless you force to disable it via config. You can view all the profile data after successfull or failed request via http://your.app.address/_profiler/ If it is not enough there is a way to Change profile storage...

Symfony 2 - Class “Mingle\StandardBundle\Entity\Product” is not a valid entity or mapped superclass

php,symfony2,doctrine,entity,bundle

Annotations have to be placed inside /** */ comment block, otherwise they are not recognized.

JMSSerializerBundle, Deserialize doesn't Relationship After Persist

I solved the same problem with merge() function : $entity = $em->merge($data); $em->persist($entity); $em->flush(); ...

Doctrine fetching indirectly associated objects

database,symfony2,doctrine,one-to-many,dql

That's correct behavior. A collection is returned by $user->getClients(), not a single object. Doctrine's collections do not proxy method calls to their members. There are two ways to solve your problem: The simpler one. Rely on Doctrine's lazy load. Let's say you use data like this: foreach ($client as $user->getClients())...

Gedmo translatable / default locale and sonata admin bundle

symfony2,doctrine,sonata-admin,symfony-sonata

Ok, I solved it by adding the following options to the StoDoctrineExtensions-Bundle: stof_doctrine_extensions: translation_fallback: false persist_default_translation: true ...

Symfony 2.6, pull in other bundle repository, container aware to fixtures

php,symfony2,doctrine,symfony-2.6

replace the line $em = $this->container()->get('doctrine')->getEntityManager(); with $em = $this->container->get('doctrine')->getEntityManager(); ...

Doctrine2 Can't update owning side in a Many-to-one bidirectional relationship

symfony2,doctrine2,doctrine

You need to persist the task object before flush like this: $em->persist($task); then you'll be able to flush. Read how to work with doctrine associations....

DoctrineODM Priming of Multi-Level References

mongodb,symfony2,doctrine,doctrine-odm

Alright it seems that in the current state doctrine-odm does not support multi-level priming. This is a known issue on GitHub. I found a solution in the GitHub Issue that passes a closure to the prime method to allow at least two level priming. Hope this helps someone. $myPrimer =...

Doctrine column id does not exist on PostgreSQL

sql,database,postgresql,doctrine

user is a reserved word. It's an alias for current_user. regress=> SELECT * FROM user; current_user -------------- myusername (1 row) If you want to use user as a table name, since it's a reserved word you must quote the identifier, e.g.: SELECT id FROM "user"; Your ORM should be quoting...

MySQL Error on Persisting to Database Symfony2

php,mysql,symfony2,doctrine

RELEASE is a reserved word in MySQL. If you really want to have your table be named release, you must set the table name in the entity and qoute it, like this: <?php /** * @ORM\Enity * @ORM\Table(name="`release`") */ class Release; … However, if you still have the option to...

Command line Doctrine ORM with Silex: You are missing a “cli-config.php” or “config/cli-config.php” file in your project

php,symfony2,doctrine,silex

You need to move bin/cli-config.php in config/cli-config.php. Unfortunately I have not found documentation about it. I opened doctrine/dbal/bin/doctrine-dbal.php and checked how it worked....

Remove automaticaly entity in BD when choice value not selected (or null selected)

php,forms,symfony2,doctrine

You could use a doctrine entity listener: https://symfony.com/doc/current/bundles/DoctrineBundle/entity-listeners.html http://doctrine-orm.readthedocs.org/en/latest/reference/events.html#entity-listeners And have something like this in it: public function postUpdateHandler(Vote $vote, LifecycleEventArgs $event) { if (null === $vote->getValue()) { // Following two lines could be avoided with a onDelete: "SET NULL" in Picture orm mapping $picture = $vote->getPicture(); $picture->removeVote($vote); $this->em->remove($vote);...

Unique Entity Error message

api,symfony2,exception-handling,doctrine

The Symfony validator service can be used directly to validate any object for which validation constraints are defined. For example in a controller: $validator = $this->get('validator'); $errors = $validator->validate($test); To perform validation within a service you can pass the validator service into your service....

Mapping Nested Tree With Doctrine 2 and YAML

doctrine2,tree,doctrine,yaml

We found that in the Tree mapping file, we had to name the left: and right: columns as lft: and rgt:, identically to the examples on the github repository for the yaml mappings. fields: lft: <---- type: integer nullable: false options: unsigned: false gedmo: - treeLeft rgt: <----- type: integer...

Getting a list of Doctrine Entities (UI population, access rights, etc.)

php,inheritance,orm,doctrine2,doctrine

I would recommend you to define all possible values in a configuration file. With that you don't have to implement a sophisticated auto-discovery that will fail as soon as requirements change and you can even supply additional information. Consider this example: boxes.yml boxes: text: class: "My\FQCN\To\TextBox" displayName: "Text Box" editableBy:...

Symfony ManyToMany delete record

php,symfony2,doctrine,many-to-many

You are simply removing Tag if count($tag->getBooks()) == 0: $this->em->remove($tag); and persisting it again: $this->em->persist($tag); else is required: if(count($tag->getBooks()) == 0) { $this->em->remove($tag); } else { $this->em->persist($tag); } ...

Symfony Doctrine fails to create foreign key

mysql,symfony2,doctrine,foreign-keys

Add to Ordertaxi this code @JoinColumn(name="customOrder_id", referencedColumnName="id") ...

Query Builder with join and condition in Many to many relation

php,symfony2,doctrine2,doctrine,symfony-2.3

You need to add a JoinTable for your ManyToMany association and set the owning and inverse sides: /** * @ORM\ManyToMany(targetEntity="PFE\EmployeesBundle\Entity\MembreFamille", * cascade={"persist"}, mapped="employees") */ private $membreFamilles; ................................. /** * @ORM\ManyToMany(targetEntity="PFE\UserBundle\Entity\Employee", cascade={"persist"}, inversedBy="membreFamilles") * @ORM\JoinTable(name="membre_familles_employees") */ private $employees; ...

Symfony2 - Entity Collection Choice Restriction

php,symfony2,doctrine,entity,twig

You can filter a collection in a form by restricting the query results. E.g. something like: $accountData = $this->getEntityManager() ->createQueryBuilder()->select('a, c') ->from('YourAccountBundle:Account', 'a') ->join('a.customers', 'c') // assuming there is a relationship like this ->where('a = :yourAccountManager') ->setParameter('yourAccountManager', $accountEntity) ->getQuery()->getResult(); Then use $accountData in your parent form. This will restrict the...

doctrine - get next and prev record

mysql,symfony2,doctrine,next

Alexandr's response is close. When you query for id < 2 LIMIT 1 it will return 1, but if you query for id < 5 LIMIT 1 this will also return 1. That is because it returns 1, 2, 3, 4 and takes the first element, which is 1 rather...

Symfony2 Undefined method. The method name must start with either findBy or findOneBy

php,class,symfony2,model-view-controller,doctrine

Check out this: $posts = $em->getRepository('BlogBundle:Post') ->getLatestPosts(); It must be $posts = $em->getRepository('BlogBlogBundle:Post') ->getLatestPosts(); Look up your namespace....

Doctrine PHPCR @Children & @Child

doctrine,symfony-cmf,doctrine-phpcr

PHPCR is a tree, every node is located under its parent. For the parent, that is a child node. When using @Child, you adress one specific child with a field. Using @Children, you map all child documents and the member variable having this mapping contains a collection. note that there...

Attempted to call method “getDoctrine” on class (Symfony)

php,mysql,symfony2,doctrine2,doctrine

You need to extend Symfony's Controller class to be able to use getDoctrine() method. So: use Symfony\Bundle\FrameworkBundle\Controller\Controller; class CustomerController extends Controller { public function indexAction($id) { $customer = $this->getDoctrine()->getRepository('GSOrderBundle:Customer')->find($id); return new Response( '<html><body>Number: '.$id.'</body></html>' ); } } (you can also define controller as a service but this is more complex...

How to select all rows that don't have one-to-many entity with certain value using Doctrine

php,mysql,orm,doctrine2,doctrine

This is the idea, adapt table and column names as necessary: SELECT * FROM cages WHERE cage_id NOT IN (SELECT cage_id FROM birds WHERE name='eagle'); So, using doctrine: $qb = $this->createQueryBuilder(); $cagesWithEagles = $qb->select('b.cage_id') ->from('birds', 'b') ->where("b.name = :name") ->setParameter("name", 'eagle') ->getQuery() ->getResult(); $cagesWithoutEagles = $qb->select('c.cage_id') ->from('cages', 'c') ->where($qb->expr()->notIn('c.cage_id', $cagesWithEagles))...

Laravel (Eloquent) Table || Peer equivalent

php,laravel,doctrine,eloquent,propel

As mentioned earlier, there is more than one way to accomplish the task, but here's a quick example using Commands. Controller namespace App\Http\Controllers; //... use App\Http\Requests\UpdateUserRequest; use App\Commands\UpdateUser; use App\User; //... class UserController extends Controller { /** * Update the specified resource in storage. * * @param int $id *...

Doctrine query condition doesn't work

symfony2,doctrine,twig

Calling createQueryBuilder('p') will add the select statement on p which symbolize the entity the repo is linked to. If you want to select anything which is out of your entity's scope, then you need to use addSelect('yourentity.attribute') to make the selection explicit....

Installing Sylius with eZ Publish 5

symfony2,doctrine,composer-php,sylius,ezpublish

You have to configure doctrine to enable ORM like this: (example taken from the Symfony Standard Edition) # Doctrine Configuration doctrine: dbal: driver: pdo_mysql host: "%database_host%" port: "%database_port%" dbname: "%database_name%" user: "%database_user%" password: "%database_password%" charset: UTF8 # if using pdo_sqlite as your database driver: # 1. add the path in...

Configure symfony form label in doctrine config

For those who don't know it, turned out that the automatic labels are already translation keys, you simply need to specify the translation_domain in your form, so i have now a messages.fr.yml: First Name: Prénom And it's enough! No need to generate / specify a translation label. Plus it is...

A reference to the object element Symfony2

symfony2,doctrine,entity

For what you've currently shown, you got an array result. Currently your Message instance is being stored in $messages[0]. So you either have to iterate over your result (if you expect more than one record) or replace your findBy with findOneBy if you expect one record.

Symfony Doctrine findBy and then map

php,doctrine2,zend-framework2,doctrine

You'll need to use a QueryBuilder for that, but that would still be quite a "pretty Doctrine code" and would still look quite like your pseudo-code. Something like this should work: $queryBuilder = $em->createQueryBuilder(); $query = queryBuilder ->select('u') ->distinct() ->from('AppBundle:User', 'u') ->join('AppBundle:WorkHour', 'wh') ->where('u.workHour = wh') ->andWhere('wh.project = :project') ->getQuery();...

The class 'Doctrine\ORM\EntityManager' was not found in the chain configured namespaces XXX

The error you are getting relates to Doctrine not being able to find an Entity called Doctrine\ORM\EntityManager, which is clearly wrong. My guess is that somewhere (perhaps in the getEntityManager() method) you are passing an instance of the entity manager to the entity manager. For example $entityManager = new EntityManager();...

A kind of pivot table using Symfony2 and Doctrine

php,mysql,symfony2,doctrine,data-modeling

Here is an approach I used to create a series of crosstab reports for a client. Doing so required abstracting at least some of the formatting of a pivot table. Hope it helps. First, an example of a report: In this report, the county entity (linked to the address of...

doctrine/migrations incompatible with symfony 2.2.*

There is list of releases of migration bundle. Here is your working config(i tested it on my pc): "require": { "php": ">=5.3.3", "symfony/symfony": "2.2.*", "symfony/debug": "2.3.*", "doctrine/orm": "~2.2,>=2.2.3", "doctrine/doctrine-bundle": "1.2.*", "twig/extensions": "1.0.*", "symfony/assetic-bundle": "2.1.*", "symfony/swiftmailer-bundle": "2.2.*", "symfony/monolog-bundle": "2.2.*", "sensio/distribution-bundle": "2.2.*", "sensio/framework-extra-bundle": "2.2.*", "sensio/generator-bundle": "2.2.*", "jms/security-extra-bundle":...

Doctrine migrations table collation

Well, thats kind of ugly, but the only way I have found is to generate after all tables another set of migrations that altered the table and converted the encoding. the migration up() and down() functions looked like: ...... /** * @param Schema $schema */ public function up(Schema $schema) {...

Doctrine isn't saving my entities?

symfony2,doctrine2,annotations,doctrine,opcache

Flush statement should be execute after persist. So Code should be: getEntityManager()->persist($user); getEntityManager()->flush(); ...

Symfony2 AnnotationException You have to enable OPCache or ZendOptimizer

Problem is solved! It was caused by webhosting provider and server configuration. Opcache or Zend Optimizer was not configured properly

Trigger Slug with symfony

symfony2,doctrine,slug

From the sluggable readme: https://github.com/Atlantic18/DoctrineExtensions/blob/master/doc/sluggable.md Update 2013-08-19 allow empty slug #807 regenerate slug only if set to null so: Fetch your entities Set their slug to null Flush And you are done !...

symfony1 doctrine form submit - where to inject logic

php,forms,doctrine,symfony1,symfony-1.4

You should put these kind of logics into a custom validator: class myValidatorMoney extends sfValidatorNumber { protected function doClean($value) { $clean = $this->processNumber($value); // your logic in this function if($clean === false) { // if not possible to process throw new sfValidatorError($this, 'invalid', array('value' => $value)); } return parent::doClean($clean); }...

ZF2 Doctrine Query With Multiple OR Conditions

symfony2,doctrine2,doctrine,mariadb

In haven't ever been able to get orWhere to function the way I think it should. It might be that you need a Where in your opening definition before you can add an orWhere later. You might have to use the nested orX statement like this instead: $query3->andWhere($query3->expr()->orX( $query3->expr()->like('t.languageIso', $query3->expr()->literal('en-US')),...

Error: Call to a member function on array

symfony2,merge,doctrine,persist

findBy returns an array of entities that satisfy the condition. If you are sure there is only one, you can just use findOneBy instead and you will get a single entity. Check out http://doctrine-orm.readthedocs.org/en/latest/reference/working-with-objects.html#by-simple-conditions ...

Symfony2 and Doctrine $em->persist VS $em->merge

no, you can't remove The difference is what you do with entity after. Persist takes an entity instance, adds it to persistance context and makes it managed, so all other updates will be managed by entity manager. Merge will create new instance of entity, copies state form provided entity, and...

ID not saved in OneToMany relationship

symfony2,doctrine,one-to-many

You need to persist your TypePurchase entity before you persist your Purchase Entity. The following example is an extension to the User-Comment example of this chapter. Suppose in our application a user is created whenever he writes his first comment. In this case we would use the following code: <?php...

How do I complete this andWhere Doctrine query?

php,doctrine2,doctrine

This is somewhat of a guess since I don't know your schema. DQL queries use properties and not database column names. I suspect that category has a property called parent? So something like: Doctrine_Query::create() ->select('p,c,i') // Eager load ->from('Product p') ->leftJoin('p.Category c' ) ->leftJoin('c.Image i') ->leftJoin('c.Parent parentCategory') // Join the...

Automatically filter out rows that don't meet a condition in Doctrine

php,symfony2,doctrine2,doctrine,doctrine-1.2

you probably can use doctrine filters: http://doctrine-orm.readthedocs.org/en/latest/reference/filters.html http://www.michaelperrin.fr/2014/07/25/doctrine-filters/ to disable: http://doctrine-orm.readthedocs.org/en/latest/reference/filters.html#disabling-enabling-filters-and-setting-parameters...

Can and Should I cache symfony2 getUser()

symfony2,doctrine,fosuserbundle

To start with, sql databases do a good job of automatically caching queries. So while there is some overhead in composing and sending the query to the server, the server itself will respond very quickly. You won't save much be adding another cache. Should you still try and optimize? In...

The file could not be found while using LifecycleCallbacks

php,symfony2,orm,doctrine,assert

I have found out what is the problem. I have marked "link" column as a file and thus the validator was failing as link was text and not a file. My link code was: /** * @ORM\Column(type="string", length=220) * @Assert\File(maxSize="6000000") */ protected $link; and the line: * @Assert\File(maxSize="6000000") should not...

Doctrine behavioral extensions: Loggable with Timestampable

symfony2,doctrine,doctrine-extensions

https://github.com/l3pp4rd/DoctrineExtensions/blob/master/lib/Gedmo/Loggable/Entity/MappedSuperclass/AbstractLogEntry.php#L35 Is loggedAt property an answer for your question?...

Doctrine batch inserting uses 2GB of Ram

php,symfony2,doctrine2,doctrine,batch-insert

If it is a command, try running it with the option --no-debug. Or, you can disable the logger by calling $manager->getConnection()->getConfiguration()->setSQLLogger(null); at the beginning of your loadfunction. Either way disabling the logger saves quite a lot of memory during Doctrine batch tasks....

Fosuserbundle register validation not work

php,symfony2,doctrine,fosuserbundle

You should use the validation to add an UniqueEntity constraint on the email field, you can add it directly to your Entity file (or use yml file, as you whish) : http://symfony.com/doc/current/reference/constraints/UniqueEntity.html With the validation, the field will be checked when the $form->isValid() is called and will return an error...

query builder gives exeption

symfony2,doctrine,query-builder

You can use the getDql() method (but i think it fail when the subquery have a parameter) : $querym = $querym->select('DISTINCT(a.id)') ->where ('a.doctorid =' . (int) $u); $query = $query->select('DISTINCT(d.id),d.name,d.dob,d.mobile')->...->where($query->expr()->In('d.id', $querym->getDql())); You can also use 2 queries (as Derick F say), something like that : $ids = array(); $querym =...

Composer - Install github fork/branch

php,symfony2,doctrine,composer-php,doctrine-migrations

Try this "repositories": [ { "source": { "url": "https://github.com/wimvds/DoctrineMigrationsBundle", "type": "git", } } } ], "require": { (...) "doctrine/migrations": "1.0.*@dev", "doctrine/doctrine-migrations-bundle": "dev-feature/multiple-em-support", (...) } ...

Search from comma separated values in column

sql,postgresql,doctrine2,doctrine

With this query you will obtain all id, all pets, ordered by pet: SELECT id, unnest(string_to_array(pets, ',')) AS mypet FROM favpets ORDER BY mypet; Using it as subquery it will became easy to group and count: SELECT mypet, COUNT(*) FROM ( SELECT id, unnest(string_to_array(pets, ',')) AS mypet FROM favpets ORDER...

Symfony 2 and Doctrine. Delete parent on table inheritance

symfony2,doctrine2,doctrine

Finally I solved using a EventListener with a PreRemove action: public function preRemove(LifecycleEventArgs $args) { $entity = $args->getEntity(); $em = $args->getEntityManager(); if (get_class($entity) == 'Intranet\WebBundle\Entity\Notice') { $notificationRepository = $em->getRepository('IntranetNotificationsBundle:UserNoticeNotification'); $notifications = $notificationRepository->findByNotice($entity); foreach ($notifications as $notification) { $em->remove($notification); } $em->flush(); } } and defining the entity...

Implement complex calculations with SQL or rather use ETL?

php,sql,doctrine,business-intelligence,domain-model

I'm not sure if this question is asking for an opinion. This answer is intended to give you things to think about in making the choice. The choice between "external" ETL or "internal" ETL depends on several factors: The skill set of the developers. The requirements for the ETL. Specific...

[Symfony 2]Use Doctrine into a service

xml,symfony2,doctrine2,doctrine

Your implementation is confused in a few different ways. The object returned by a factory-method must be of the same type defined in the class attribute - so something that inherits from Doctrine\ORM\EntityRepository (this is where your "strange error" is coming from) It doesn't make sense to define a service...

Set methods between relationships in Symfony2

php,symfony2,doctrine2,doctrine,migration

In this case you can just give Doctrine (the default ORM of Symfony) the Object itself instead its id. Doctrine will figure out that it only has to save the id to the database. So it would be: $user = $this->getUser($user_id); $entity->setAuthor($user); You don't need to set it on the...

why is Doctrine creating one big migration?

Firstly, the migration tool is just a tool. It is not meant as a bulletproof way to generate paths from versions. Generally, it is used as a template to which you will manually modify. To answer your question specifically, because the tool is designed to compare the overall schema. Considering...

Doctrine mapped field is not working

php,doctrine

I was despairing of finding a solution when I remembered that Doctrine have its proper cache, independent from Symfony (I tried tens of cache:clear without any change). I thought that my problem could be a Doctrine cache issue, so I tried to clear the cache: app/console doctrine:cache:clear-metadata (If you are...

Should I clear/warm symfony2 cache after doctrine migrations?

symfony2,caching,doctrine,capifony

Migrations are responsible for persistence layer only. It has nothing to do with EntityProxies, it only makes Database in sync with Model - that's all. In production, during deployment, you probably run git pull and composer install, which clears the cache, so migrations shoud run just after that. Reason -...

what is wrong in this statement php doctrine

php,doctrine2,doctrine,php-5.3

You forgot quotes surrounding the value. $query = $em->createQuery('SELECT u FROM Usuario u WHERE u.usuario_email ="'. $usuario->getUsuario_email(). '"'); If you have a problem with SQL statements best thing to do is copy the query you got paste it to your SQL editor and see normally you would have spotted the...

How to join many to many in createQuery()

symfony2,join,doctrine,many-to-many,createquery

Try this public function rechercherProjets($lang, $cat) { $qb = $this->createQueryBuilder('p') ->innerJoin ('p.description', 'pi') ->innerJoin('p.categories', 'pc') ->andWhere('pc.tag = :cat') ->andWhere('pi.langue = :lang') ->setParameters(array('lang'=>$lang,'cat'=>$cat)); return $qb->getQuery()->getResult() } ...

how to implement join to more than one table on same column in doctrine

doctrine2,doctrine,doctrine-query

$queryBuilder ->select('u', 'i.item_name', 't.otherColumns2') ->from('user_lp_requirement', 'u') ->innerJoin('u', 'item_master', 'i', 'u.item_id = i.item_id') ->innerJoin('u', 'training_program', 't', 'u.item_id = t.item_id'); This assumes that you want the user table mapped to the item table AND the user table mapped to the training table rather than the user table mapped to a join of...

silex loop one sql statement over another one

mysql,symfony2,doctrine,twig,silex

Oh yeah twig is really nice... I thought I have to link the objects in the controller, but now I simply wrote: {% for teamGroup in teamGroups %} <div class="row row-centered"> <h3 class="text-center">{{ teamGroup.name }}</h3> {% for teamMember in teamMembers %} {% if teamMember.team_group_id is same as(teamGroup.id) %} <div class="col-xs-6...

how to create virtual column on Doctrine Symfony2

symfony2,inheritance,doctrine

You need to specify the Entities relationship in their Entity classes. http://doctrine-orm.readthedocs.org/en/latest/reference/association-mapping.html and http://symfony.com/doc/current/book/doctrine.html#entity-relationships-associations When you have done that and updated your schema, you can do this in Twig: {{ company.ships|length }} To get a count. You can also do any type of operatios like All you need to do...

Database/Code solutions for model with dynamic data, using Symfony 2 with Doctrine

database,symfony2,model,doctrine,nosql

So i kept searching and i found this: Mix of MySQL and Mongodb in an application The hstore field got my interest. Looking further i have discovered an extension to add hstore support on Doctrine and Symfony https://github.com/intaro/hstore-extension and it looks like it's exactly what i need. In alternative i...

Inheritance in Symfony2

If you want to use single table for 3 classes, you should use DiscriminatorMap Example: We have a class Product, and two child classes Coupon and CustomProduct that inherited from Product /** * MyApp\ProductBundle\Entity\Product * * @ORM\Table(name="product") * @ORM\Entity(repositoryClass="MyApp\ProductBundle\Repository\ProductRepository") * @ORM\InheritanceType("SINGLE_TABLE") * @ORM\DiscriminatorColumn(name="productType", type="string") * @ORM\DiscriminatorMap({ * "Product" = "Product",...

Symfony time field not using the same date as the corresponding entity property

php,symfony2,datetime,doctrine2,doctrine

The solution lies in the setDuration() setter, as both Doctrine and Symfony use it to set the duration. Just don't update the whole DateTime object, only its time part: public function setDuration(\DateTime $duration) { $this->duration->setTime( $duration->format('G'), $duration->format('i'), $duration->format('s') ); return $this; } ...

override translation fallback symfony 2

php,validation,symfony2,doctrine

Well I found it http://blog.lazycloud.net/symfony2-doctrine2-extentions-translatable/ Apparently I should add to my entity a $locale attribute and set above it the annotation * @Gedmo\Locale . and then I can use that to override the default fallback of the entity by seting the locale to whatever language I wish then calling $em->refresh($entity)...

Validate Doctrine entities with Symfony Validator

As you are not using symfony fullstack, you should manually create a validator servie to use it. See Usage Section of Validator component readme use Symfony\Component\Validator\Validation; use Symfony\Component\Validator\Constraints as Assert; class User { /** * @Assert\Length(min = 3) * @Assert\NotBlank */ private $name; /** * @Assert\Email * @Assert\NotBlank */ private...

Doctrine “A new entity was found through the relationship” error

You're right: Doctrine looks only for changes into owning side but you're wrong: owning side of your relationship is Step, not Channel. Why is step the owning side? Because is the entity that has foreign key. Even Doctrine documentation says to you The owning side has to use the inversedBy...

Symfony2 Inserting Error “Warning: spl_object_hash() expects parameter…”

Looking at the annotations, my guess is that User::setParentId() is expecting a User object, not an integer: /** * @ORM\ManyToOne(targetEntity="User", inversedBy="children") * @ORM\JoinColumn(name="parent_id", referencedColumnName="id", nullable=true) * */ So instead of passing $new_user->setParentId($currentuser->getId()); try: $new_user->setParentId($currentuser); If that works, the field name should be changed appropriately to something like parent instead of...

Error running doctrine:fixtures:load in heroku

symfony2,heroku,doctrine

I solved adding this to my AppKernel: if (in_array($this->getEnvironment(), array('prod'))) { $bundles[] = new Doctrine\Bundle\FixturesBundle\DoctrineFixturesBundle(); } Thanks anyways....

Symfony, security.yml “Unknown Entity namespace alias”

symfony2,doctrine,entity-relationship

Try to set the entity manager to providers, I think it should help: providers: administrators: entity: class: FinanceCmsBundle:AuthUser property: username ussers: entity: class: FinanceCzBundle:SystemAuthMailCentrum property: username manager_name: admin ...

How to detect if entity exist in database

Found solution: its fetch: EAGER set to problematic mapping in doctrine. By default doctrine uses LAZY fetching what results in using Proxy classes generated by doctrine for related entity. That class is almost same as real entity class. Difference is inside getter methods that before returning value performs fetching entity...

How to save additional entity while persisting another in Doctrine?

symfony2,orm,doctrine2,doctrine

You need to create listener and listen for persisting on Distance entity. While it persists you can create new Distance with reverse route.

Symfony2 persist not working from my controller

symfony2,doctrine,entities,persist

Ok i managed to fix this somehow by regenerating my User entity with php app/console doctrine:generate:entities BeArtsUserBundle ...

Unique Index when data already exists

php,symfony2,doctrine,migration,unique

I think the problem could be from your NOT NULL constraint on the settings_id column. You have to: Add you foreign key (settings_id) without the NOT NULL constraint Update all your foreign fields (settings_id) with values ALTER your foreign key (settings_id) with NOT NULL constraint ...

Sorting a collection in doctrine2

php,mongodb,doctrine2,doctrine,odm

Pretty sure sort takes an array argument. Try ->sort(['r' => 'desc]); I looked it up... http://apigen.juzna.cz/doc/doctrine/mongodb/source-class-Doctrine.MongoDB.Cursor.html#564-585...

Infinite loop in Doctrine event listener when trying to save additional entity

php,symfony2,orm,doctrine2,doctrine

You should not use $em->flush() inside prePersist, it is restricted by Doctrine: http://doctrine-orm.readthedocs.org/en/latest/reference/events.html#reference-events-implementing-listeners There is information about preUpdate, but same situation (loop) is applied for prePesist call 9.6.6. preUpdate PreUpdate is the most restrictive to use event, since it is called right before an update statement is called for an...

Is there a detailed comparison between Propel 2 and Doctrine 2

performance,orm,doctrine,comparison,propel

I'm also during making my decision which PHP ORM to choose and recently I found the following comparison of the main features of Doctrine2 and Propel 2: Side by side: Doctrine2 and Propel 2. The comparison is very precise and comprehensive, so surely it can come in handy when making...

What kind of symfony relationship would be most appropriate?