Changes between Version 5 and Version 6 of DespoinaLog/2010/12/09


Ignore:
Timestamp:
2010-12-09T12:38:01+01:00 (14 years ago)
Author:
antonak
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • DespoinaLog/2010/12/09

    v5 v6  
    66 * create new table biobank from pheno project as follows:
    77
    8   mysql> create  table biobank_new select Acronym, Category, Type, Size, !LastUpdate  , Description, id from biobank ;
     8  mysql> create  table biobank_new select Acronym, Category, Type, Size, !LastUpdate   , Description, id from biobank ;
    99
    1010  (only fields that exist in biobank in gcc project)
    … …  
    1717
    1818== select query retrieving records in molgenis form ==
    19 === We need data inside INNER JOIN tables ===
    20 select count(*) as num_rows  FROM Biobank  INNER JOIN 
     19=== We need data inside INNER/LEFT JOIN tables ===
     20select count(*) as num_rows  FROM Biobank  INNER JOIN
    2121
    22 Panel ON (Biobank.id = Panel.id) INNER JOIN 
     22'''Panel''' ON (Biobank.id = Panel.id) INNER JOIN
    2323
    24 !ObservationTarget ON (Biobank.id = !ObservationTarget.id) INNER JOIN 
     24'''!ObservationTarget''' ON (Biobank.id = !ObservationTarget.id) INNER JOIN
    2525
    26 !ObservationElement ON (Biobank.id = !ObservationElement.id) LEFT JOIN Investigation AS xref_Investigation  ON xref_Investigation.id = !ObservationElement.Investigation LEFT JOIN !OntologyTerm AS xref_ontologyReference  ON xref_ontologyReference.id = !ObservationElement.ontologyReference LEFT JOIN !OntologyTerm AS xref_Species  ON xref_Species.id = Panel.Species LEFT JOIN !OntologyTerm AS xref_PanelType  ON xref_PanelType.id = Panel.!PanelType LEFT JOIN !OntologyTerm AS xref_Category  ON xref_Category.id = Biobank.Category WHERE !ObservationElement.!__Type = 'Biobank'
     26'''!ObservationElement''' ON (Biobank.id = !ObservationElement.id) LEFT JOIN
     27
     28 '''Investigation''' AS xref_Investigation  ON xref_Investigation.id = !ObservationElement.Investigation LEFT JOIN 
     29
     30'''!OntologyTerm''' AS xref_ontologyReference  ON xref_ontologyReference.id = !ObservationElement.ontologyReference LEFT JOIN 
     31
     32'''!OntologyTerm''' AS xref_Species  ON xref_Species.id = Panel.Species LEFT JOIN 
     33
     34'''!OntologyTerm''' AS xref_PanelType  ON xref_PanelType.id = Panel.!PanelType LEFT JOIN 
     35
     36'''!OntologyTerm''' AS xref_Category  ON xref_Category.id = Biobank.Category WHERE !ObservationElement.!__Type = 'Biobank'