DQL & The Query Builder

Hey HudyWeas,

> Project doesn't see QuestionRepository.php as a part of project

Hm, what do you mean? Please, make sure you have the correct namespace for that class first.

About advanced autcompletion - make sure you installed and enabled Symfony Plugin in PhpStorm for your project. Most of the cool autocompletion comes from there. If still not work - try to restart PhpStorm. Also, you can easily teach your PhpStorm what is object exactly is set to a variable with inlined "/** @var ClassName $varName" above the variable on which you don't have autorompleteion.

I hope this helps!

Cheers!

thats what php storm said to me when i wanted to edit this file. There opened a window asking me if i want to edit file that isnt a part of a project

Hey HudyWeas,

Oh, wait, you're probably talking about editing vendor files, you should not do this 😅 Better, create a new variable in *your* repository and add that var annotation - this should help :)

Cheers!

im not talking about files in vendor directory. Im talking about files created like Question.php and QuestionRepository. There is set namespace but still its not seen. When i set use statement manually in QuestionController.php
use App\Repository\QuestionRepository;

it's yellow and says "Undefinied namespace Repository"

QuestionRepository.php
namespace App\Repository;

Hey HudyWeas,

Ah, ok... Hm, something is not right probably. Fairly speaking, I've never seen this error myself. I'd recommend you to close your PhpStorm and then remove the project completely with running "rm -rf .idea/" command in the project folder. It will remove the PhpStorm's project config files. Then run the PhpStorm again and try to open a directory with your project, i.e. click on "File" -> "Open" -> and choose the folder with your project if you have Mac. This will open your Symfony project and creates a new PhpStorm project for it. If you have troubles with using PhpStorm - I'd recommend you to watch this free course about it: https://symfonycasts.com/sc...

I hope this helps!

Cheers!

Hey @Aaron!

Ah, I think it's just a tiny typo in your method name :). You have an extra "By" in there - it should just be findAllAskedOrderedByNewest. You're getting this weird error because the entity repository class has some "magic" in it: if you call an undefined method on it that starts with "findBy" it tries to parse it and create a query from it. So Doctrine basically tries to make a query to find by "orderedByNewest = the argument", which makes no sense of course :p. Without that magic, you would just get a "method not found error" and it would be easier to debug.

Cheers!

LOL the number of times a typo has caused me grief is insane. Symfony is like 20 - 0 in the battle of who's the problem with me. Not enough coffee I guess.

haha, when I close my eyes I only see typos everywhere! :p

Hi Janik S.!

After looking at the linked tutorial regarding Raw SQL Queries Link I saw that he's not getting an Object returned from the Raw SQL. It just returns him an Array If I am correct.

Yes, that is correct. You can absolutely write raw SQL queries. But what is returned from the database is a "raw array of data". And that's usually fine - because usually if you are choosing to write very complex queries, then returning an entity object doesn't make sense. For example, you might have a raw query that selects a AVG or SUM of some fields. It only makes sense to return that as an array (your return set doesn't have the same data as your entity object).

However, there are 2 ways to use raw SQL and get an objec:

1) Do it yourself! Suppose you're writing some complex SQL query that returns 3 columns - a SUM, AVG and count of something. If you would like to put this into an object, you could create a class (in any directory, this is not managed by Doctrine) that looks like this:

class SalesStatistics
{
    public $totalSales;

    public $averageSales;

    public $totalCustomers;
}

I'm using public properties for simplicity - you could also make them private with getters/setters. The point is, after making your SQL query (and getting an array back), you would create this object manually, set the data on it (from the array) and then return this object. This is a really nice solution.

2) Doctrine has a way to do a raw SQL query but then have it convert that to an object. I've not used it much, but it's called result set mapping https://www.doctrine-project.org/projects/doctrine-orm/en/2.7/reference/native-sql.html#examples

Let me know if that helps :).

Cheers!