a2ad2a8f3e71fe90a3c335f967ff3fcec9d37296 kate Thu Apr 23 10:38:28 2020 -0700 Initial work for GTEx V8 gene expression track: parse files and load gene expression and metadata tables. refs #25130 diff --git src/hg/makeDb/outside/hgGtex/hgGtex.c src/hg/makeDb/outside/hgGtex/hgGtex.c index 31e1eb2..f8c4fbe 100644 --- src/hg/makeDb/outside/hgGtex/hgGtex.c +++ src/hg/makeDb/outside/hgGtex/hgGtex.c @@ -727,46 +727,51 @@ safef(donorTable, sizeof(donorTable), "%sDonor", tableRoot); FILE *donorFile = hgCreateTabFile(tabDir, donorTable); for (donor = donors; donor != NULL; donor = donor->next) { gtexDonorOutput(donor, donorFile, '\t', '\n'); hashAdd(donorHash, donor->name, donor); } if (doLoad) { struct sqlConnection *conn = sqlConnect(database); /* Load sample table */ verbose(2, "Creating sample table\n"); gtexSampleCreateTable(conn, sampleTable); + verbose(3, "Load table %s from %s/%s\n", sampleTable, tabDir, sampleTable); hgLoadTabFile(conn, tabDir, sampleTable, &f); hgRemoveTabFile(tabDir, sampleTable); /* Load tissue table */ char tissueTable[64]; verbose(2, "Creating tissue table\n"); safef(tissueTable, sizeof(tissueTable), "%sTissue", tableRoot); gtexTissueCreateTable(conn, tissueTable); char dir[128]; char fileName[64]; splitPath(tissuesFile, dir, fileName, NULL); + if (dir[0] == 0) + dir[0]= '.'; + verbose(3, "Load table %s from %s/%s\n", tissueTable, dir, fileName); hgLoadNamedTabFile(conn, dir, tissueTable, fileName, NULL); /* Load donor table */ verbose(2, "Creating donor table\n"); gtexDonorCreateTable(conn, donorTable); + verbose(3, "Load table %s from %s/%s\n", donorTable, dir, donorTable); hgLoadTabFile(conn, tabDir, donorTable, &donorFile); hgRemoveTabFile(tabDir, donorTable); sqlDisconnect(&conn); } else { carefulClose(&f); carefulClose(&donorFile); } } if (!doData) return; /* Ready to process data items */