Personalizar la clase de usuario

Where are all these files coming from in the AppFixtures? Did you just create them? I can't find where they are coming from following your tutorials.. they just exist.

use App\Entity\Answer;
use App\Entity\Question;
use App\Entity\Tag;
use App\Factory\AnswerFactory;
use App\Factory\QuestionFactory;
use App\Factory\QuestionTagFactory;
use App\Factory\TagFactory;
use App\Factory\UserFactory;

Hey Ramon,

Yes, those files are already exist in this course. They come from past tutorials from the fundamental section: https://symfonycasts.com/tracks/symfony5#the-fundamentals - we base every new tutorial on the previous one.

Cheers!

Ah I see! Thanks a lot for the info! :)

Hi, the symfony console make:factroy command is not defined, I'm with symfony 6.3.x what can I replace it with ? Thanks

I must install this bundle -> composer require zenstruck/foundry --dev

Hey @pasquale_pellicani ,

Yep, you need to install that bundle - that's how MakerBundle works, it does not have all possible dependencies and suggests you install specific ones on the go when you're trying to use more features. Good catch!

Cheers!

Hey,
Maybe silly question but I can't figure out how to display symfony console doctrine:query:sql 'SELECT * FROM user'<br /> in the same array format like in video? :)))

Hey Szymon,

It seems you can't anymore :) They output is displayed in a table now instead of a raw dump as it was before.

Cheers!

For some reason, the "doctrine:fixtures:load" command fails with my PostgresSQL container. I get the error

SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near "user"  LINE 1: INSERT INTO user (id, name, email, roles, created_at, update...`
LINE 1: INSERT INTO user (id, name, email, roles, created_at, update...

Question: Is there a way I can tell Doctrine to use "user" instead of user for that Entity?
Or do I need to rename the Entity to something else?

I've tried to apply the quotes via an annotation #[ORM\Table(name: '"user"')] but that caused a different error

SQLSTATE[42602]: Invalid name: 7 ERROR:  invalid name syntax  
LINE 1: SELECT NEXTVAL('"user"_id_seq')

Hey Philipp,

Yeah, most probably that's because of that table name, user is a reserved word in PostgreSql. You need to rename that table to something, like app_user.

Another trick, you might try to use ticks around the table name, i.e. use `, instead of ":

#[ORM\Table(name: '`user`')]

It might also work, though I've never tried it in PostgreSql, though in MySQL it worked. But safer would be not use reserved words at all, better use a unique name :)

Cheers!

Thanks for the clarification, Victor!
As you suggested, I could solve the issue by renaming the DB table via an annotation + recreating the DB schema

#[ORM\Table(name: 'app_user')]
class User implements UserInterface { ...

Hey Philipp,

Awesome, thanks for confirming it works for you!

Cheers!

hey ! I have a error
***********
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual
that corresponds to your MariaDB server version for the right syntax to use near 'INDEX idx_9474526c1e27f6bf
TO IDX_DADD4A251E27F6BF' at line 1

********
Column Already exist 'status'

Hey Anass,

It looks like you already have that "status" column. Please, try to validate your DB schema with:
$ symfony console doctrine:schema:validate

If it's not OK - try to apply the required changes, to know what queries you need to execute - see:

$ symfony console doctrine:schema:update --dump-sql

Of if you're working locally and don't worry about losing your data in the DB - instead you can run:

$ symfony console doctrine:schema:update --force

Cheers!

In case anyone else runs into an error trying to run the simple query at the end try using double quotes around the SQL statement instead of single quotes.

Hey Aaron,

Thanks for this tip! Are you talking about "symfony console doctrine:query:sql 'SELECT * FROM user'" command? It somehow does not work for you with single quotes around the SQL query? I wonder what OS do you use and what terminal?

Cheers!

Yes that's the command I'm talking about. When running it on the DOS console on Windows 10 using single quotes it throws an error but with double quotes it does not.

Ha! Windows likes to complicate things. Thanks for sharing your problem + solution with others