Symfony 1.4: use relations in fixtures with propel

Posted by iggnition on Stack Overflow See other posts from Stack Overflow or by iggnition
Published on 2010-04-26T08:32:29Z Indexed on 2010/04/26 8:33 UTC
Read the original article Hit count: 325

Filed under:

symfony-1.4

|

yaml

|

foreign-key-relationship

|

propel

Hello,

I just started to use the PHP symfony framework. Currently I'm trying to create fixture files in YAML to easily insert data into my MySQL database.

Now my database has a couple of relations, I have the tables Organisation and Location.

Organisation
 org_id (PK)
 org_name

Location
 loc_id (PK)
 org_id (FK)
 loc_name

Now I'm trying too link these tables in my fixture file, but for the life of me I cannot figure out how. Since the org_id is auto-incremented I can't simply use

org_id: 1

In the location fixture.

How can I fix this?

© Stack Overflow or respective owner

Related posts about symfony-1.4

Symfony/Doctrine/SfGuardPlugin: Redirect to requested page (route), and not referrer

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to be able to take the user to the requested page after login, but this does not happen with sfGuard. ** My Register action requires SignIn ;) ** On the listing page [http://cim/frontend_dev.php/] - user clicks the 'Register' link [@register = register/index] - user is taken to 'Signin' page… >>> More
Symfony and doctrine searchable sfDoctrinePager (symfony 1.4)

as seen on Stack Overflow - Search for 'Stack Overflow'
Can someone help me on paginating results with sfDoctrinePager? $articlesResults = Doctrine::getTable('Article') ->getTemplate('Doctrine_Template_I18n') ->getPlugin() … >>> More
Seems doctrine listener is not fired

as seen on Stack Overflow - Search for 'Stack Overflow'
Got a service which should be executed the moment an object is persisted. Though, I think the code looks like it should work, it doesn't. I configured the service like the following yml. services: bla_orm.listener: class: Bla\OrmBundle\EventListener\UserManager arguments:… >>> More
Ubuntu 13.10 Symfony installation date time issue

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm installing Symfony on my Ubuntu system, everything was going fine until the very last moment when I was met with a screen that said: ContextErrorException: Warning: date_default_timezone_get(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone… >>> More
Propel-load-data is causing an error

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to load fixtures but myproject is erroring at the CLI and starting the indexer process. I have tried: Rebuilding the schema and model Emptying the database and starting again Clearing the cache Validating the YML file and trying much simpler data-dumps My platform is Symfony 1.0… >>> More

Related posts about yaml

Trying to parse OpenCV YAML ouput with yaml-cpp

as seen on Stack Overflow - Search for 'Stack Overflow'
I've got a series of OpenCv generated YAML files and would like to parse them with yaml-cpp I'm doing okay on simple stuff, but the matrix representation is proving difficult. # Center of table tableCenter: !!opencv-matrix rows: 1 cols: 2 dt: f data: [ 240, 240] This should map… >>> More
How do I install PyYAML into local install of Python?

as seen on Server Fault - Search for 'Server Fault'
I've installed Python 2.6.4 into (a subdirectory in) my home directory on a Linux machine with Python 2.3.4 pre-installed, because I need to run some code that I've decided would require too much work to make it run on 2.3.4. (I'm not on the sudoers list for that machine.) I was hoping I could run… >>> More
Issue Parsing File with YAML-CPP

as seen on Stack Overflow - Search for 'Stack Overflow'
In the following code, I'm having some sort of issue getting my .yaml file parsed using parser.GetNextDocument(doc);. After much gross debugging, I've found that the (main) issue here is that my for loop is not running, due to doc.size() == 0; What am I doing wrong? void BookView::load() { aBook… >>> More
How is it that json serialization is so much faster than yaml serialization in python?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have code that relies heavily on yaml for cross-language serialization and while working on speeding some stuff up I noticed that yaml was insanely slow compared to other serialization methods (e.g., pickle, json). So what really blows my mind is that json is so much faster that yaml when the output… >>> More
Changelog file: YAML vs JSON vs CSV

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello everybody. I am creating a simple Changelog lib in CodeIgniter that will basically log a message everytime someone adds, deletes, changes or publish a blog post. I will log messages in files by batches of 300. So every 301st message will go in a new file. At first I wanted to write the logs… >>> More