create(['uniquename' => 'octopus_core_test_name']); // Test 1. Pass a single filter. $selector = array( 'stock_id' => $stock->stock_id, 'uniquename' => array( 'op' => 'LIKE', 'data' => 'octopus%', ), ); $object = chado_generate_var('stock', $selector); $this->assertNotNull($object->stock_id); $this->assertEquals($stock->stock_id, $object->stock_id); // Test 2 Pass an array of filters with a single item. $selector = array( 'stock_id' => $stock->stock_id, 'uniquename' => array( array( 'op' => 'LIKE', 'data' => 'octopus%', ), ), ); $object = chado_generate_var('stock', $selector); $this->assertNotNull($object->stock_id); $this->assertEquals($stock->stock_id, $object->stock_id); // Test 3 Pass an array of filters with multiple items. $selector = array( 'type_id' => array( array( 'op' => '>', 'data' => ($stock->type_id - 1), ), array( 'op' => '<', 'data' => ($stock->type_id + 1), ), ), ); $object = chado_generate_var('stock', $selector); $this->assertNotNull($object->stock_id); $this->assertEquals($stock->stock_id, $object->stock_id); } /** * @group api * @group failing * @group chado * */ public function test_chado_db_select() { $analysis_record = factory('chado.analysis')->create(); $id = $analysis_record->analysis_id; $query = chado_db_select('{analysis}', 't'); $analysis = $query->fields('t') ->condition('analysis_id', $id) ->execute() ->fetchObject(); $querytwo = db_select('chado.analysis', 't'); $traditional_analysis = $querytwo ->condition('analysis_id', $id) ->fields('t') ->execute() ->fetchObject(); $this->assertNotFalse($analysis); $this->assertNotFalse($traditional_analysis); } }