FuelPHP Forums

I am struggling to work out how to get the ORM to create data in all the required tables (2 of). I could of course create the address, get its ID and use that in the Organisation model, create that and then update the address entry with the new organisations ID (Needed as orgs can have several addresses and we need to know who the address owner is). That, however, seems very inefficient - can the ORM save() method do this? Here is my code (i am aware there is no addresses property, it's just copied from where I have been playing):

$add = new Model_Organisation();
   $add->user_id = self::$user_id;
   $add->type = 'O'; // Organisation, churches added elsewhere
   $add->name = Input::post('name');
   $add->addresses[] = new Model_Address();
   $add->addresses->user_id = $add->user_id;
   $add->addresses->org_id = $add->id;
   $add->addresses->post_code = Input::post('post_code');
   $add->addresses->address_1 = Input::post('address_1');
   $add->addresses->address_2 = Input::post('address_2');
   $add->addresses->town = Input::post('town');
   $add->addresses->county = Input::post('county');
   $add->addresses->email = Input::post('email');
   $add->addresses->phone = Input::post('phone');
   $add->addresses->mobile = Input::post('mobile');
   $add->addresses->website_uri = Input::post('website_uri');
   $add->addresses->facebook_uri = Input::post('facebook_uri');
   $add->addresses->twitter_uri = Input::post('twitter_uri');
   $add->address_id = $add->addresses->id;
   $add->description = Input::post('description');
   $add->save();

Here is my Organisation_Model:

protected static $_properties = array(
  'id',
  'user_id',
  'type',
  'name',
  'slug',
  'address_id',
  'description',
 );
 
 // Set relationships
 protected static $_belongs_to = array(
     'user' => array(
   'key_from' => 'user_id',
   'model_to' => 'Model_User',
   'key_to' => 'id',
   'cascade_save' => true,
   'cascade_delete' => false,
     )
 );
 
 protected static $_has_one = array(
     'address' => array(
   'key_from' => 'address_id',
   'model_to' => 'Model_Address',
   'key_to' => 'id',
   'cascade_save' => true,
   'cascade_delete' => false,
     )
 );
 
 protected static $_has_many = array(
     'event' => array(
   'key_from' => 'id',
   'model_to' => 'Model_Event',
   'key_to' => 'org_id',
   'cascade_save' => true,
   'cascade_delete' => false,
     ),
  'addresses' => array(
   'key_from' => 'id',
   'model_to' => 'Model_Address',
   'key_to' => 'org_id',
   'cascade_save' => true,
   'cascade_delete' => false,
     ),
 );

Here is my Address_Model:

protected static $_properties = array(
  'id',
  'user_id',
  'org_id',
  'post_code',
  'address_1',
  'address_2',
  'town',
  'county',
  'email',
  'phone',
  'mobile',
  'website_uri',
  'facebook_uri',
  'twitter_uri',
 );
 
 // Set any relationships
 protected static $_belongs_to = array(
     'users' => array(
   'key_from' => 'user_id',
   'model_to' => 'Model_User',
   'key_to' => 'id',
   'cascade_save' => true,
   'cascade_delete' => false,
     ),
  'organisations' => array(
   'key_from' => 'org_id',
   'model_to' => 'Model_Organisation',
   'key_to' => 'id',
   'cascade_save' => true,
   'cascade_delete' => false,
     ),
  'organisation' => array(
   'key_from' => 'id',
   'model_to' => 'Model_Organisation',
   'key_to' => 'address_id',
   'cascade_save' => true,
   'cascade_delete' => false,
     ),
  'event' => array(
   'key_from' => 'id',
   'model_to' => 'Model_Event',
   'key_to' => 'address_id',
   'cascade_save' => true,
   'cascade_delete' => false,
     )
 );

What I basically want to do when creating an organisation for the first time is to store the address ID of the (only) address in the organisation table and in the address table store the user ID and organisation ID of the address owner. Even if I had a separate table with user ID, org ID and address ID I would still have this problem if using one save method because at some point there will be an unknown org or address ID. Is this bad data structure design or is there a way to achieve it using one save so I can rollback/cascade if necessary? If the former, how should I go about it? Help is greatly appreciated as I've bee kicking around with this for ages now.