static void loadCytoBandsIdeo(struct track *tg)
/* Load up cytoBandIdeo from database table to track items. */
{
if (tg->isBigBed)
{
struct lm *lm = lmInit(0);
int start = 0;
int end = hChromSize(database, chromName);
struct bigBedInterval *bb, *bbList = bigBedSelectRange(tg, chromName, start, end, lm);
char *bedRow[32];
char startBuf[16], endBuf[16];
for (bb = bbList; bb != NULL; bb = bb->next)
{
bigBedIntervalToRow(bb, chromName, startBuf, endBuf, bedRow, ArraySize(bedRow));
struct cytoBand *bed = cytoBandLoad(bedRow);
slAddHead(&tg->items, bed);
}
slReverse(&tg->items);
lmCleanup(&lm);
return;
}
char query[256];
sqlSafef(query, sizeof(query),
"select * from cytoBandIdeo where chrom like '%s'", chromName);
if(hTableExists(database, "cytoBandIdeo"))
bedLoadItemByQuery(tg, "cytoBandIdeo", query, (ItemLoader)cytoBandLoad);
if(slCount(tg->items) == 0)
{
tg->limitedVisSet = TRUE;
tg->limitedVis = tvHide;
}
}
struct cytoBand *loadAllBands(char *database)
/* Load up all bands from database. */
{
struct cytoBand *list = NULL, *el;
struct sqlConnection *conn = sqlConnect(database);
struct sqlResult *sr = NULL;
char **row;
sr = sqlGetResult(conn, "NOSQLINJ select * from cytoBand");
while ((row = sqlNextRow(sr)) != NULL)
{
el = cytoBandLoad(row);
slAddHead(&list, el);
}
sqlFreeResult(&sr);
slReverse(&list);
sqlDisconnect(&conn);
printf("Loaded %d bands\n", slCount(list));
return list;
}
