自学教程：C++ sqlSigned函数代码示例

struct cartDb *cartDbLoad(char **row)/* Load a cartDb from row fetched with select * from cartDb * from database.  Dispose of this with cartDbFree(). */{struct cartDb *ret;AllocVar(ret);ret->id = sqlUnsigned(row[0]);ret->contents = cloneString(row[1]);ret->reserved = sqlSigned(row[2]);ret->firstUse = cloneString(row[3]);ret->lastUse = cloneString(row[4]);ret->useCount = sqlSigned(row[5]);if (cartDbUseSessionKey())    ret->sessionKey = cloneString(row[6]);return ret;}

void fbRefStaticLoad(char **row, struct fbRef *ret)/* Load a row from fbRef table into ret.  The contents of ret will * be replaced at the next call to this function. */{    ret->id = sqlSigned(row[0]);    ret->text = row[1];}

void wgEncodeGencodeTranscriptionSupportLevelStaticLoad(char **row, struct wgEncodeGencodeTranscriptionSupportLevel *ret)/* Load a row from wgEncodeGencodeTranscriptionSupportLevel table into ret.  The contents of ret will * be replaced at the next call to this function. */{ret->transcriptId = row[0];ret->level = sqlSigned(row[1]);}

void fbAlleleStaticLoad(char **row, struct fbAllele *ret)/* Load a row from fbAllele table into ret.  The contents of ret will * be replaced at the next call to this function. */{    ret->id = sqlSigned(row[0]);    ret->geneId = row[1];    ret->name = row[2];}

void symTestStaticLoad(char **row, struct symTest *ret)/* Load a row from symTest table into ret.  The contents of ret will * be replaced at the next call to this function. */{ret->id = sqlSigned(row[0]);ret->sex = sqlEnumParse(row[1], values_sex, &valhash_sex);ret->skills = sqlSetParse(row[2], values_skills, &valhash_skills);}

void snpExtFileStaticLoad(char **row, struct snpExtFile *ret)/* Load a row from snpExtFile table into ret.  The contents of ret will * be replaced at the next call to this function. */{ret->chrom = row[0];ret->path = row[1];ret->size = sqlSigned(row[2]);}

void cdsPickStaticLoad(char **row, struct cdsPick *ret)/* Load a row from cdsPick table into ret.  The contents of ret will * be replaced at the next call to this function. */{ret->name = row[0];ret->start = sqlSigned(row[1]);ret->end = sqlSigned(row[2]);ret->source = row[3];ret->score = sqlDouble(row[4]);ret->startComplete = sqlUnsigned(row[5]);ret->endComplete = sqlUnsigned(row[6]);ret->swissProt = row[7];ret->uniProt = row[8];ret->refProt = row[9];ret->refSeq = row[10];ret->ccds = row[11];}

struct bdgpExprLink *bdgpExprLinkLoad(char **row)/* Load a bdgpExprLink from row fetched with select * from bdgpExprLink * from database.  Dispose of this with bdgpExprLinkFree(). */{struct bdgpExprLink *ret;AllocVar(ret);ret->symbol = cloneString(row[0]);ret->bdgpName = cloneString(row[1]);ret->flyBaseId = cloneString(row[2]);ret->est = cloneString(row[3]);ret->imageCount = sqlSigned(row[4]);ret->bodyPartCount = sqlSigned(row[5]);ret->plate = cloneString(row[6]);ret->platePos = sqlSigned(row[7]);ret->newRelease = row[8][0];return ret;}

static struct refSeqVerInfo *refSeqVerInfoNewDb(char **row)/* construct a refSeqVerInfo object from a database query */{struct refSeqVerInfo *rsvi;AllocVar(rsvi);rsvi->acc = cloneString(row[0]);rsvi->ver = sqlSigned(row[1]);return rsvi;}

struct txEdgeBed *txEdgeBedLoad(char **row)/* Load a txEdgeBed from row fetched with select * from txEdgeBed * from database.  Dispose of this with txEdgeBedFree(). */{struct txEdgeBed *ret;AllocVar(ret);ret->chrom = cloneString(row[0]);ret->chromStart = sqlSigned(row[1]);ret->chromEnd = sqlSigned(row[2]);ret->name = cloneString(row[3]);ret->score = sqlSigned(row[4]);safecpy(ret->strand, sizeof(ret->strand), row[5]);safecpy(ret->startType, sizeof(ret->startType), row[6]);ret->type = sqlEnumParse(row[7], values_type, &valhash_type);safecpy(ret->endType, sizeof(ret->endType), row[8]);return ret;}

static void brokenRefPepGetSeqScan(struct sqlConnection *conn,                                   struct extFileTbl* extFileTbl,                                   struct brokenRefPepTbl *brpTbl)/* load refSeq peps that have seq or extFile problems, including * checking fasta file contents*/{static char *query = NOSQLINJ "select id, acc, version, size, gbExtFile, file_offset, file_size "    "from gbSeq where (acc like /"NP__%/") or (acc like /"YP__%/")";struct sqlResult *sr = sqlGetResult(conn, query);char **row;while ((row = sqlNextRow(sr)) != NULL)    brokenRefPepSeqCheck(conn, extFileTbl, brpTbl,                         sqlSigned(row[0]), row[1], sqlSigned(row[2]),                         sqlUnsigned(row[3]), sqlUnsigned(row[4]),                         sqlLongLong(row[5]), sqlUnsigned(row[6]));sqlFreeResult(&sr);}

struct estOrientInfo *estOrientInfoLoad(char **row)/* Load a estOrientInfo from row fetched with select * from estOrientInfo * from database.  Dispose of this with estOrientInfoFree(). */{struct estOrientInfo *ret;AllocVar(ret);ret->chrom = cloneString(row[0]);ret->chromStart = sqlUnsigned(row[1]);ret->chromEnd = sqlUnsigned(row[2]);ret->name = cloneString(row[3]);ret->intronOrientation = sqlSigned(row[4]);ret->sizePolyA = sqlSigned(row[5]);ret->revSizePolyA = sqlSigned(row[6]);ret->signalPos = sqlSigned(row[7]);ret->revSignalPos = sqlSigned(row[8]);return ret;}

void gtexDonorStaticLoad(char **row, struct gtexDonor *ret)/* Load a row from gtexDonor table into ret.  The contents of ret will * be replaced at the next call to this function. */{ret->name = row[0];ret->gender = row[1];ret->age = sqlUnsigned(row[2]);ret->deathClass = sqlSigned(row[3]);}

struct vntr *vntrLoad(char **row)/* Load a vntr from row fetched with select * from vntr * from database.  Dispose of this with vntrFree(). */{struct vntr *ret;AllocVar(ret);ret->chrom = cloneString(row[0]);ret->chromStart = sqlUnsigned(row[1]);ret->chromEnd = sqlUnsigned(row[2]);ret->name = cloneString(row[3]);ret->repeatCount = atof(row[4]);ret->distanceToLast = sqlSigned(row[5]);ret->distanceToNext = sqlSigned(row[6]);ret->forwardPrimer = cloneString(row[7]);ret->reversePrimer = cloneString(row[8]);ret->pcrLength = cloneString(row[9]);return ret;}

void geneScoreStaticLoad(char **row, struct geneScore *ret)/* Load a row from geneScore table into ret.  The contents of ret will * be replaced at the next call to this function. */{ret->name = row[0];ret->chrom = row[1];ret->txStart = sqlSigned(row[2]);ret->score = atof(row[3]);}

struct docIdSub *docIdSubLoad(char **row)/* Load a docIdSub from row fetched with select * from docIdSub * from database.  Dispose of this with docIdSubFree(). */{struct docIdSub *ret;AllocVar(ret);ret->ix = sqlSigned(row[0]);ret->status = sqlSigned(row[1]);ret->assembly = cloneString(row[2]);ret->submitDate = cloneString(row[3]);ret->md5sum = cloneString(row[4]);ret->valReport = cloneString(row[5]);ret->valVersion = cloneString(row[6]);ret->metaData = cloneString(row[7]);ret->submitPath = cloneString(row[8]);ret->submitter = cloneString(row[9]);return ret;}

void tomRoughStaticLoad(char **row, struct tomRough *ret)/* Load a row from tomRough table into ret.  The contents of ret will * be replaced at the next call to this function. */{ret->omimId = sqlSigned(row[0]);ret->chromosome = row[1];ret->startBand = row[2];ret->endBand = row[3];ret->description = row[4];}

struct splignAlign *splignAlignLoad(char **row)/* Load a splignAlign from row fetched with select * from splignAlign * from database.  Dispose of this with splignAlignFree(). */{struct splignAlign *ret;AllocVar(ret);ret->query = cloneString(row[0]);ret->target = cloneString(row[1]);ret->perId = atof(row[2]);ret->match = sqlSigned(row[3]);ret->qStart = sqlSigned(row[4]);ret->qEnd = sqlSigned(row[5]);ret->tStart = sqlSigned(row[6]);ret->tEnd = sqlSigned(row[7]);ret->type = cloneString(row[8]);ret->anotation = cloneString(row[9]);return ret;}

struct hash *readCsizeHash(char *filename)/* read in a chrom sizes file */{    struct lineFile *lf = lineFileOpen(filename, TRUE);    struct hash *cHash = hashNew(10);    char *words[2];    while (lineFileRowTab(lf, words))	hashAddInt(cHash, words[0], sqlSigned(words[1]));    lineFileClose(&lf);    return cHash;}

struct wgEncodeGencodeTranscriptionSupportLevel *wgEncodeGencodeTranscriptionSupportLevelLoad(char **row)/* Load a wgEncodeGencodeTranscriptionSupportLevel from row fetched with select * from wgEncodeGencodeTranscriptionSupportLevel * from database.  Dispose of this with wgEncodeGencodeTranscriptionSupportLevelFree(). */{struct wgEncodeGencodeTranscriptionSupportLevel *ret;AllocVar(ret);ret->transcriptId = cloneString(row[0]);ret->level = sqlSigned(row[1]);return ret;}

void mouseSynStaticLoad(char **row, struct mouseSyn *ret)/* Load a row from mouseSyn table into ret.  The contents of ret will * be replaced at the next call to this function. */{ret->chrom = row[0];ret->chromStart = sqlUnsigned(row[1]);ret->chromEnd = sqlUnsigned(row[2]);ret->name = row[3];ret->segment = sqlSigned(row[4]);}

struct wgEncodeGencodePubMed *wgEncodeGencodePubMedLoad(char **row)/* Load a wgEncodeGencodePubMed from row fetched with select * from wgEncodeGencodePubMed * from database.  Dispose of this with wgEncodeGencodePubMedFree(). */{struct wgEncodeGencodePubMed *ret;AllocVar(ret);ret->transcriptId = cloneString(row[0]);ret->pubMedId = sqlSigned(row[1]);return ret;}

static struct hash *loadSizes(char *szFile)/* load sizes into a hash */{struct hash *sizes = hashNew(0);struct lineFile *lf = lineFileOpen(szFile, TRUE);char *row[2];while (lineFileNextRowTab(lf, row, 2))    hashAddInt(sizes, row[0], sqlSigned(row[1]));return sizes;}

void bwtool_shift(struct hash *options, char *favorites, char *regions, unsigned decimals, enum wigOutType wot,		  boolean condense, char *val_s, char *bigfile, char *tmp_dir, char *outputfile)/* bwtool_shift - main for shifting program */{    const double na = NANUM;    int shft = sqlSigned(val_s);    int abs_shft = abs(shft);    struct metaBig *mb = metaBigOpen_check(bigfile, tmp_dir, regions);    if (!mb)	errAbort("problem opening %s", bigfile);    char wigfile[512];    safef(wigfile, sizeof(wigfile), "%s.tmp.wig", outputfile);    FILE *out = mustOpen(wigfile, "w");    struct bed *section;    boolean up = TRUE;    if (shft > 0)	up = FALSE;    if (shft == 0)	errAbort("it doesn't make sense to shift by zero.");    for (section = mb->sections; section != NULL; section = section->next)    {	struct perBaseWig *pbw = perBaseWigLoadSingleContinue(mb, section->chrom, section->chromStart,							      section->chromEnd, FALSE, na);	int i;	/* if the shift size is bigger than the section, NA the entire thing */	int size = pbw->len;	if (abs_shft >= size)	    for (i = 0; i < size; i++)		pbw->data[i] = na;	else	{	    if (!up)	    {		for (i = size-1; i >= abs_shft; i--)		    pbw->data[i] = pbw->data[i - abs_shft];		for (; i >= 0; i--)		    pbw->data[i] = na;	    }	    else	    {		for (i = 0; i < size - abs_shft; i++)		    pbw->data[i] = pbw->data[i + abs_shft];		for (; i < size; i++)		    pbw->data[i] = na;	    }	}	perBaseWigOutputNASkip(pbw, out, wot, decimals, NULL, FALSE, condense);	perBaseWigFree(&pbw);    }    carefulClose(&out);    writeBw(wigfile, outputfile, mb->chromSizeHash);    remove(wigfile);    metaBigClose(&mb);}

struct fbRef *fbRefLoad(char **row)/* Load a fbRef from row fetched with select * from fbRef * from database.  Dispose of this with fbRefFree(). */{    struct fbRef *ret;    AllocVar(ret);    ret->id = sqlSigned(row[0]);    ret->text = cloneString(row[1]);    return ret;}

static struct hash *loadChromSizes(char *chromSizesFile)/* read the chromosome sizes file. */{struct lineFile *lf = lineFileOpen(chromSizesFile, TRUE);struct hash *sizes = newHash(12);char *words[2];while (lineFileRow(lf, words))    hashAddInt(sizes, words[0], sqlSigned(words[1]));lineFileClose(&lf);return sizes;}

void tilingPathStaticLoad(char **row, struct tilingPath *ret)/* Load a row from tilingPath table into ret.  The contents of ret will * be replaced at the next call to this function. */{    ret->chrom = row[0];    ret->accession = row[1];    ret->clone = row[2];    ret->contig = row[3];    ret->chromIx = sqlSigned(row[4]);}

void rgdQtlStaticLoad(char **row, struct rgdQtl *ret)/* Load a row from rgdQtl table into ret.  The contents of ret will * be replaced at the next call to this function. */{ret->bin = sqlSigned(row[0]);ret->chrom = row[1];ret->chromStart = sqlUnsigned(row[2]);ret->chromEnd = sqlUnsigned(row[3]);ret->name = row[4];}

struct bed6* readBed6SoftAndSize(char* file, int* orig_size)/* read from a file.  If it's missing fields, fill the bed */{    char* words[6];    if (!fileExists(file))        errAbort("Can't find file: %s", file);    struct lineFile* lf = lineFileOpen(file, TRUE);    struct bed6* list = NULL;    int num_words = 0;    int size = 0;    while ((num_words = lineFileChopTab(lf, words)) > 0) {        if (num_words < 3)            errAbort("Expecting BED-3 formatted file (%s) but there are only %d columns on line %d", file, num_words, lf->lineIx);        struct bed6* newb;        AllocVar(newb);        if (size < num_words)            size = num_words;        newb->chrom = cloneString(words[0]);        newb->chromStart = sqlSigned(words[1]);        newb->chromEnd = sqlSigned(words[2]);        if (num_words < 4)            newb->name = cloneString(".");        else            newb->name = cloneString(words[3]);        if (num_words < 5)            newb->score = 0;        else            newb->score = sqlSigned(words[4]);        if (num_words < 6)            newb->strand[0] = '+';        else            newb->strand[0] = words[5][0];        newb->strand[1] = '/0';        slAddHead(&list, newb);    }    slReverse(&list);    lineFileClose(&lf);    if (orig_size)        *orig_size = size;    return list;}