Alien Tech for Fixtures: Foundry & Faker

Hey @Mahmut-A,

Factory relations is what you're looking for. There are a couple ways to achieve but using your code above, it could be something like this:

$user = UserFactory::createOne([
    'userName' => 'Ömer İlk',
    'email' => 'omer.ilk@netsys.com.tr',
    'plainPassword' => 'ömer123'
]);

LablistFactory::createOne([
    'user' => $user,
])

I hope this helps!

--Kevin

Hi Kevin,

Maybe I explained wrong. There are two tables. one is user, second is lablist. I want to load their data to tables. As far as I understand, I can use only AppFixtures to load data. However, if I use UserFactory and LablistFactory in AppFixtures, then if I load by using fixtures:load command, both tables will be refreshed at each run.

I want to only load lablist, since user is alread loaded , I do not want to refresh it.

I want to add something. I created two Fixtures. AppFixtures and LablistFixtures by using command "symfony console make:fixtures LablistFixtures."

then, I am applying "php bin/console doctrine:fixtures:load --group=LablistFixtures" command to load data to lablist table. however, when I apply this, user table is being deleted.
if I use "php bin/console doctrine:fixtures:load --group=LablistFixtures --group=AppFixtures, all tables are refreshed and IDs are regenerated.

I want to only load to spesific tables not all of them.

Ok, I understand. You can have multiple fixture files: perhaps in your case, a UserFixtures and LablistFixtures. By default, both will by loaded, but you can group them so they can be loaded
independently. Check the "Splitting Fixtures into Separate Files" documentation to see your options.

Hi,

Actually,splitting also refreshing. But I fixed my problem as below:

php bin/console doctrine:fixtures:load --group=LablistFixtures --append

with this command, User tables is not refreshing.

However, we should be careful to not duplicate data in Lablist since we used --append. To prevent this, I added below lines in LabList.php class.

so now everything is perfect. thank you

`use Symfony\Bridge\Doctrine\Validator\Constraints\UniqueEntity;
#[UniqueEntity('labname')]

`

Glad to hear you have it working!

I think adjusting the purging behaviour could be used as an alternative to --append.

Hey Mahmut,

Then you did it right :) Did you try to reload your fixtures? It will create a mahmut.aydin@netsys.com.tr user and 10 more random users.

Or are you trying to add only that mahmut.aydin@netsys.com.tr without resetting your DB? Well, if so, that's a bit trickier. First of all, in theory, you should not care too much about the data locally, so you can just reload your fixtures that will do the trick eventually, but yeah, it will reset the DB so for example all your additional data you add to the DB after loaded the fixtures will gone. Alternative solution in your specific case - just register a new user with that email on the registration page if you have it 🤷‍♂️ That's the easiest way when you need to add just one more specific user. And finally, if you still need to do it with fixtures - run the same bin/console doctrine:fixtures:load command but with --append option:

bin/console doctrine:fixtures:load --append

It will try to append new data w/o clearing the DB before. But it may cause some duplicated constraints fails, depends on how good your randomness is :) I would recommend you to comment out everything you don't need before running that command, e.g. comment out that // UserFactory::createMany(10);.

I hope that helps :)

Cheers!

thank you Victor. Actually, randomness is not important. I only wanted to learn how to add new data to existing table. I see need to use --append parameter to command.

thank you

Hey Mahmut,

Great! About randomness - it depends on your unique constraints in the DB. When you append data but if somehow during it the same email that already exists in your DB will be generated - the whole data load command will fail, that's just something you should keep in mind.

Cheers!