Changeset 528 for trunk

Show
Ignore:
Timestamp:
07/03/11 20:25:17 (11 months ago)
Author:
AlexanderPico
Message:

updated qc call

Location:
trunk/dbbuilder/src/org/bridgedb/build/scripts
Files:
2 modified

Legend:

Unmodified
Added
Removed

  • trunk/dbbuilder/src/org/bridgedb/build/scripts/PathVisioMySQL_BUILD.sql.template

    r440 r528  
    9292FROM genmapp_XXXXXX_CS_YYYYYY.gene 
    9393WHERE genmapp_XXXXXX_CS_YYYYYY.gene.ID != ''  
    94 AND genmapp_XXXXXX_CS_YYYYYY.gene.Code IN ("EnXXXXXX","Mb","L","X","Il","Ag","Q","Om","U","Rf","S","Ip","T","Pd","H","M","R","D","Z","F","W","Gg","A","Ti","Ir","N","Uc","Pl","Gm","Bg","Ec","Wg","Gw","Kg","Bc","Tb"); 
     94AND genmapp_XXXXXX_CS_YYYYYY.gene.Code IN ("EnXXXXXX","Mb","L","X","Il","Ag","Q","Om","U","Rf","S","Ip","T","Pd","H","M","R","D","Z","F","W","Gg","A","Ti","Ir","N","Uc","Pl","Gm","Bg","Ec","Wg","Gw","Kg","Bc","Tb","Tp","Tm","Tc"); 
    9595 
    9696## Fill 'link' 
    … …  
    9999SELECT DISTINCT * 
    100100FROM genmapp_XXXXXX_CS_YYYYYY.link 
    101 WHERE genmapp_XXXXXX_CS_YYYYYY.link.Code_Right IN ("EnXXXXXX","Mb","L","X","Il","Ag","Q","Om","U","Rf","S","Ip","T","Pd","H","M","R","D","Z","F","W","Gg","A","Ti","Ir","N","Uc","Pl","Gm","Bg","Ec","Wg","Gw","Kg","Bc","Tb"); 
     101WHERE genmapp_XXXXXX_CS_YYYYYY.link.Code_Right IN ("EnXXXXXX","Mb","L","X","Il","Ag","Q","Om","U","Rf","S","Ip","T","Pd","H","M","R","D","Z","F","W","Gg","A","Ti","Ir","N","Uc","Pl","Gm","Bg","Ec","Wg","Gw","Kg","Bc","Tb","Tp","Tm","Tc"); 
    102102 
    103103##Add Ensembl IDs to right side of 'link' table 

  • trunk/dbbuilder/src/org/bridgedb/build/scripts/buildPathVisio.sh

    r469 r528  
    7777 
    7878#Run qc.sh 
    79 ./qc.sh ${DatabaseDb_prior}.bridge ${DatabaseDb}.bridge 
     79./qc.sh ${DatabaseSpecies} ${DatabaseDate} ${PriorDatabaseDate} >> temp.${DatabaseDb}.qc  
    8080 
    8181# report on products (check size > 1.9M)