public function test_insert_and_update_and_delete()
{
$term1 = EE_Term::new_instance(array('name' => 'monkey1', 'slug' => 'monkey1'));
$term2 = EE_Term::new_instance(array('name' => 'monkey2', 'slug' => 'monkey2'));
$term1->save();
$term2->save();
$tt_1 = EE_Term_Taxonomy::new_instance(array('taxonomy' => 'whatever', 'term_id' => $term1->ID()));
$tt_1->save();
$tt_2 = EE_Term_Taxonomy::new_instance(array('taxonomy' => 'whatever', 'term_id' => $term2->ID()));
$tt_2->save();
$e = EE_Event::new_instance(array('EVT_name' => 'for_term_1'));
$e->save();
//ok done setup
//test INSERT
$this->assertEquals(0, $tt_1->count());
$new_tr_id = EEM_Term_Relationship::instance()->insert(array('term_taxonomy_id' => $tt_1->ID(), 'object_id' => $e->ID()));
$this->assertNotNull($new_tr_id);
//refresh out term_taxonomy objects, as the database has changed
$tt_1 = EEM_Term_Taxonomy::reset()->get_one_by_ID($tt_1->ID());
$tt_2 = EEM_Term_Taxonomy::instance()->get_one_by_ID($tt_2->ID());
$this->assertEquals(1, $tt_1->count());
$this->assertEquals(0, $tt_2->count());
//test UPDATE... except we can't update term_relationship because there's no Primary Key
//on it. This should be fixed at some point
//@todo: fix this test
// $updated = EEM_Term_Relationship::instance()->update_by_ID(array('term_taxonomy_id'=>$tt_2->ID() ), $new_tr_id );
// //refresh out term_taxonomy objects, as the database has changed
// $tt_1 = EEM_Term_Taxonomy::reset()->get_one_by_ID( $tt_1->ID() );
// $tt_2 = EEM_Term_Taxonomy::instance()->get_one_by_ID($tt_2->ID() );
// $this->assertEquals( 0, $tt_1->count() );
// $this->assertEquals(1,$tt_2->count() );
//test DELETE
//@todo: fix this test too. see above
// $count_deleted = EEM_Term_Relationship::instance()->delete_by_ID($new_tr_id);
// $this->assertNotEmpty( $count_deleted );
// //refresh out term_taxonomy objects, as the database has changed
// $tt_1 = EEM_Term_Taxonomy::reset()->get_one_by_ID( $tt_1->ID() );
// $tt_2 = EEM_Term_Taxonomy::instance()->get_one_by_ID($tt_2->ID() );
// $this->assertEquals( 0, $tt_1->count() );
// $this->assertEquals(0,$tt_2->count() );
}
/**
* test that term relationships are migrated ok if they would conflict with something already in the db
*/
function test_save_data_array_to_db__from_other_site__no_duplicate_term_relationships()
{
$event_id_from_other_db = 122;
$term_tax_from_other_db = 32;
$old_term_r_order = 3;
$new_term_r_order = 123;
$old_term_r_data = array('object_id' => $event_id_from_other_db, 'term_taxonomy_id' => $term_tax_from_other_db, 'term_order' => $old_term_r_order);
$a_real_event = $this->new_model_obj_with_dependencies('Event');
$a_real_term_taxonomy = $this->new_model_obj_with_dependencies('Term_Taxonomy');
$a_real_term_r = $this->new_model_obj_with_dependencies('Term_Relationship', array('object_id' => $a_real_event->ID(), 'term_taxonomy_id' => $a_real_term_taxonomy->ID(), 'term_order' => $new_term_r_order));
$csv_data = array('Term_Relationship' => array($old_term_r_data));
$mapping_data = array('Event' => array($event_id_from_other_db => $a_real_event->ID()), 'Term_Taxonomy' => array($term_tax_from_other_db => $a_real_term_taxonomy->ID()));
$old_term_r_count = EEM_Term_Relationship::instance()->count();
$new_mapping = EE_Import::instance()->save_data_rows_to_db($csv_data, true, $mapping_data);
$this->_assertNoImportErrors();
//there should be NO new term relationships. it should have just been updated
$this->assertEquals($old_term_r_count, EEM_Term_Relationship::instance()->count());
$this->assertEquals(1, count($new_mapping['Term_Relationship']));
$old_term_r_id = EEM_Term_Relationship::instance()->get_index_primary_key_string($old_term_r_data);
$new_term_r_id = $new_mapping['Term_Relationship'][$old_term_r_id];
$new_term_r = EEM_Term_Relationship::instance()->get_one_by_ID($new_term_r_id);
$this->assertInstanceOf('EE_Term_Relationship', $new_term_r);
$this->assertEquals($old_term_r_order, $new_term_r->get('term_order'));
}
public function test_get_all__caps__delete__with_assign_event_category()
{
//log the user in
global $current_user;
$current_user = $this->user;
$current_user->add_cap('ee_edit_events');
$current_user->add_cap('ee_assign_event_category');
//now check they can only see the term relationship for their own event
$term_rs = EEM_Term_Relationship::instance()->get_all(array(array('object_id' => array('IN', array($this->my_event->ID(), $this->others_event->ID()))), 'order_by' => array('object_id' => 'ASC'), 'caps' => EEM_Base::caps_delete));
$this->assertEEModelObjectsEquals($this->term_r_for_my_event, reset($term_rs));
$this->assertEquals(1, count($term_rs));
}