db/00015/TomatoGenomePageProp.pm

   1 package TomatoGenomePageProp;
   2 use Moose;
   3
   4 extends 'CXGN::Metadata::Dbpatch';
   5
   6 has '+description' => ( default => <<'');
   7 Adds an organismprop to the tomato organism turning on its genome page.
   8
   9 has '+sql' => ( default => <<EOS );
  10
  11 INSERT INTO dbxref
  12            ( db_id, accession,                 version )
  13     VALUES ( 71,    'autocreated:genome_page', 1       );
  14
  15
  16 INSERT INTO cvterm
  17         (cv_id, name, definition, dbxref_id )
  18  VALUES (  2733
  19           ,'genome_page'
  20           ,'attribute for an organism indicating whether an SGN genome page should be displayed for it'
  21           ,
  22           ( SELECT dbxref_id FROM dbxref WHERE accession = 'autocreated:genome_page' )
  23         );
  24
  25 INSERT INTO organismprop
  26           (organism_id,type_id,value)
  27    VALUES (1,(select cvterm_id from cvterm where name = 'genome_page'),1);
  28
  29 EOS
  30
  31
  32
  33 1;