533112afe2a2005e80cdb1f82904ea65032d4302 braney Sat Oct 2 11:37:34 2021 -0700 split hg/lib into two separate libaries, one only used by the cgis diff --git src/hg/cgilib/affy120KDetails.c src/hg/cgilib/affy120KDetails.c new file mode 100644 index 0000000..e762e0a --- /dev/null +++ src/hg/cgilib/affy120KDetails.c @@ -0,0 +1,587 @@ +/* affy120KDetails.c was originally generated by the autoSql program, which also + * generated affy120KDetails.h and affy120KDetails.sql. This module links the database and + * the RAM representation of objects. */ + +/* Copyright (C) 2014 The Regents of the University of California + * See README in this or parent directory for licensing information. */ + +#include "common.h" +#include "linefile.h" +#include "dystring.h" +#include "jksql.h" +#include "affy120KDetails.h" + + +void affy120KDetailsStaticLoad(char **row, struct affy120KDetails *ret) +/* Load a row from affy120KDetails table into ret. The contents of ret will + * be replaced at the next call to this function. */ +{ +ret->affyId = sqlSigned(row[0]); +ret->rsId = row[1]; +strcpy(ret->baseA, row[2]); +strcpy(ret->baseB, row[3]); +strcpy(ret->sequenceA, row[4]); +strcpy(ret->sequenceB, row[5]); +strcpy(ret->enzyme, row[6]); +ret->minFreq = atof(row[7]); +ret->hetzyg = atof(row[8]); +ret->avHetSE = atof(row[9]); +strcpy(ret->NA04477, row[10]); +strcpy(ret->NA04479, row[11]); +strcpy(ret->NA04846, row[12]); +strcpy(ret->NA11036, row[13]); +strcpy(ret->NA11038, row[14]); +strcpy(ret->NA13056, row[15]); +strcpy(ret->NA17011, row[16]); +strcpy(ret->NA17012, row[17]); +strcpy(ret->NA17013, row[18]); +strcpy(ret->NA17014, row[19]); +strcpy(ret->NA17015, row[20]); +strcpy(ret->NA17016, row[21]); +strcpy(ret->NA17101, row[22]); +strcpy(ret->NA17102, row[23]); +strcpy(ret->NA17103, row[24]); +strcpy(ret->NA17104, row[25]); +strcpy(ret->NA17105, row[26]); +strcpy(ret->NA17106, row[27]); +strcpy(ret->NA17201, row[28]); +strcpy(ret->NA17202, row[29]); +strcpy(ret->NA17203, row[30]); +strcpy(ret->NA17204, row[31]); +strcpy(ret->NA17205, row[32]); +strcpy(ret->NA17206, row[33]); +strcpy(ret->NA17207, row[34]); +strcpy(ret->NA17208, row[35]); +strcpy(ret->NA17210, row[36]); +strcpy(ret->NA17211, row[37]); +strcpy(ret->NA17212, row[38]); +strcpy(ret->NA17213, row[39]); +strcpy(ret->PD01, row[40]); +strcpy(ret->PD02, row[41]); +strcpy(ret->PD03, row[42]); +strcpy(ret->PD04, row[43]); +strcpy(ret->PD05, row[44]); +strcpy(ret->PD06, row[45]); +strcpy(ret->PD07, row[46]); +strcpy(ret->PD08, row[47]); +strcpy(ret->PD09, row[48]); +strcpy(ret->PD10, row[49]); +strcpy(ret->PD11, row[50]); +strcpy(ret->PD12, row[51]); +strcpy(ret->PD13, row[52]); +strcpy(ret->PD14, row[53]); +strcpy(ret->PD15, row[54]); +strcpy(ret->PD16, row[55]); +strcpy(ret->PD17, row[56]); +strcpy(ret->PD18, row[57]); +strcpy(ret->PD19, row[58]); +strcpy(ret->PD20, row[59]); +strcpy(ret->PD21, row[60]); +strcpy(ret->PD22, row[61]); +strcpy(ret->PD23, row[62]); +strcpy(ret->PD24, row[63]); +} + +struct affy120KDetails *affy120KDetailsLoad(char **row) +/* Load a affy120KDetails from row fetched with select * from affy120KDetails + * from database. Dispose of this with affy120KDetailsFree(). */ +{ +struct affy120KDetails *ret; + +AllocVar(ret); +ret->affyId = sqlSigned(row[0]); +ret->rsId = cloneString(row[1]); +strcpy(ret->baseA, row[2]); +strcpy(ret->baseB, row[3]); +strcpy(ret->sequenceA, row[4]); +strcpy(ret->sequenceB, row[5]); +strcpy(ret->enzyme, row[6]); +ret->minFreq = atof(row[7]); +ret->hetzyg = atof(row[8]); +ret->avHetSE = atof(row[9]); +strcpy(ret->NA04477, row[10]); +strcpy(ret->NA04479, row[11]); +strcpy(ret->NA04846, row[12]); +strcpy(ret->NA11036, row[13]); +strcpy(ret->NA11038, row[14]); +strcpy(ret->NA13056, row[15]); +strcpy(ret->NA17011, row[16]); +strcpy(ret->NA17012, row[17]); +strcpy(ret->NA17013, row[18]); +strcpy(ret->NA17014, row[19]); +strcpy(ret->NA17015, row[20]); +strcpy(ret->NA17016, row[21]); +strcpy(ret->NA17101, row[22]); +strcpy(ret->NA17102, row[23]); +strcpy(ret->NA17103, row[24]); +strcpy(ret->NA17104, row[25]); +strcpy(ret->NA17105, row[26]); +strcpy(ret->NA17106, row[27]); +strcpy(ret->NA17201, row[28]); +strcpy(ret->NA17202, row[29]); +strcpy(ret->NA17203, row[30]); +strcpy(ret->NA17204, row[31]); +strcpy(ret->NA17205, row[32]); +strcpy(ret->NA17206, row[33]); +strcpy(ret->NA17207, row[34]); +strcpy(ret->NA17208, row[35]); +strcpy(ret->NA17210, row[36]); +strcpy(ret->NA17211, row[37]); +strcpy(ret->NA17212, row[38]); +strcpy(ret->NA17213, row[39]); +strcpy(ret->PD01, row[40]); +strcpy(ret->PD02, row[41]); +strcpy(ret->PD03, row[42]); +strcpy(ret->PD04, row[43]); +strcpy(ret->PD05, row[44]); +strcpy(ret->PD06, row[45]); +strcpy(ret->PD07, row[46]); +strcpy(ret->PD08, row[47]); +strcpy(ret->PD09, row[48]); +strcpy(ret->PD10, row[49]); +strcpy(ret->PD11, row[50]); +strcpy(ret->PD12, row[51]); +strcpy(ret->PD13, row[52]); +strcpy(ret->PD14, row[53]); +strcpy(ret->PD15, row[54]); +strcpy(ret->PD16, row[55]); +strcpy(ret->PD17, row[56]); +strcpy(ret->PD18, row[57]); +strcpy(ret->PD19, row[58]); +strcpy(ret->PD20, row[59]); +strcpy(ret->PD21, row[60]); +strcpy(ret->PD22, row[61]); +strcpy(ret->PD23, row[62]); +strcpy(ret->PD24, row[63]); +return ret; +} + +struct affy120KDetails *affy120KDetailsLoadAll(char *fileName) +/* Load all affy120KDetails from a whitespace-separated file. + * Dispose of this with affy120KDetailsFreeList(). */ +{ +struct affy120KDetails *list = NULL, *el; +struct lineFile *lf = lineFileOpen(fileName, TRUE); +char *row[64]; + +while (lineFileRow(lf, row)) + { + el = affy120KDetailsLoad(row); + slAddHead(&list, el); + } +lineFileClose(&lf); +slReverse(&list); +return list; +} + +struct affy120KDetails *affy120KDetailsLoadAllByChar(char *fileName, char chopper) +/* Load all affy120KDetails from a chopper separated file. + * Dispose of this with affy120KDetailsFreeList(). */ +{ +struct affy120KDetails *list = NULL, *el; +struct lineFile *lf = lineFileOpen(fileName, TRUE); +char *row[64]; + +while (lineFileNextCharRow(lf, chopper, row, ArraySize(row))) + { + el = affy120KDetailsLoad(row); + slAddHead(&list, el); + } +lineFileClose(&lf); +slReverse(&list); +return list; +} + +struct affy120KDetails *affy120KDetailsLoadByQuery(struct sqlConnection *conn, char *query) +/* Load all affy120KDetails from table that satisfy the query given. + * Where query is of the form 'select * from example where something=something' + * or 'select example.* from example, anotherTable where example.something = + * anotherTable.something'. + * Dispose of this with affy120KDetailsFreeList(). */ +{ +struct affy120KDetails *list = NULL, *el; +struct sqlResult *sr; +char **row; + +sr = sqlGetResult(conn, query); +while ((row = sqlNextRow(sr)) != NULL) + { + el = affy120KDetailsLoad(row); + slAddHead(&list, el); + } +slReverse(&list); +sqlFreeResult(&sr); +return list; +} + +void affy120KDetailsSaveToDb(struct sqlConnection *conn, struct affy120KDetails *el, char *tableName, int updateSize) +/* Save affy120KDetails as a row to the table specified by tableName. + * As blob fields may be arbitrary size updateSize specifies the approx size + * of a string that would contain the entire query. Arrays of native types are + * converted to comma separated strings and loaded as such, User defined types are + * inserted as NULL. Strings are automatically escaped to allow insertion into the database. */ +{ +struct dyString *update = newDyString(updateSize); +sqlDyStringPrintf(update, "insert into %s values ( %d,'%s','%s','%s','%s','%s','%s',%f,%f,%f,'%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')", + tableName, el->affyId, el->rsId, el->baseA, el->baseB, el->sequenceA, el->sequenceB, el->enzyme, el->minFreq, el->hetzyg, el->avHetSE, el->NA04477, el->NA04479, el->NA04846, el->NA11036, el->NA11038, el->NA13056, el->NA17011, el->NA17012, el->NA17013, el->NA17014, el->NA17015, el->NA17016, el->NA17101, el->NA17102, el->NA17103, el->NA17104, el->NA17105, el->NA17106, el->NA17201, el->NA17202, el->NA17203, el->NA17204, el->NA17205, el->NA17206, el->NA17207, el->NA17208, el->NA17210, el->NA17211, el->NA17212, el->NA17213, el->PD01, el->PD02, el->PD03, el->PD04, el->PD05, el->PD06, el->PD07, el->PD08, el->PD09, el->PD10, el->PD11, el->PD12, el->PD13, el->PD14, el->PD15, el->PD16, el->PD17, el->PD18, el->PD19, el->PD20, el->PD21, el->PD22, el->PD23, el->PD24); +sqlUpdate(conn, update->string); +freeDyString(&update); +} + + +struct affy120KDetails *affy120KDetailsCommaIn(char **pS, struct affy120KDetails *ret) +/* Create a affy120KDetails out of a comma separated string. + * This will fill in ret if non-null, otherwise will + * return a new affy120KDetails */ +{ +char *s = *pS; + +if (ret == NULL) + AllocVar(ret); +ret->affyId = sqlSignedComma(&s); +ret->rsId = sqlStringComma(&s); +sqlFixedStringComma(&s, ret->baseA, sizeof(ret->baseA)); +sqlFixedStringComma(&s, ret->baseB, sizeof(ret->baseB)); +sqlFixedStringComma(&s, ret->sequenceA, sizeof(ret->sequenceA)); +sqlFixedStringComma(&s, ret->sequenceB, sizeof(ret->sequenceB)); +sqlFixedStringComma(&s, ret->enzyme, sizeof(ret->enzyme)); +ret->minFreq = sqlFloatComma(&s); +ret->hetzyg = sqlFloatComma(&s); +ret->avHetSE = sqlFloatComma(&s); +sqlFixedStringComma(&s, ret->NA04477, sizeof(ret->NA04477)); +sqlFixedStringComma(&s, ret->NA04479, sizeof(ret->NA04479)); +sqlFixedStringComma(&s, ret->NA04846, sizeof(ret->NA04846)); +sqlFixedStringComma(&s, ret->NA11036, sizeof(ret->NA11036)); +sqlFixedStringComma(&s, ret->NA11038, sizeof(ret->NA11038)); +sqlFixedStringComma(&s, ret->NA13056, sizeof(ret->NA13056)); +sqlFixedStringComma(&s, ret->NA17011, sizeof(ret->NA17011)); +sqlFixedStringComma(&s, ret->NA17012, sizeof(ret->NA17012)); +sqlFixedStringComma(&s, ret->NA17013, sizeof(ret->NA17013)); +sqlFixedStringComma(&s, ret->NA17014, sizeof(ret->NA17014)); +sqlFixedStringComma(&s, ret->NA17015, sizeof(ret->NA17015)); +sqlFixedStringComma(&s, ret->NA17016, sizeof(ret->NA17016)); +sqlFixedStringComma(&s, ret->NA17101, sizeof(ret->NA17101)); +sqlFixedStringComma(&s, ret->NA17102, sizeof(ret->NA17102)); +sqlFixedStringComma(&s, ret->NA17103, sizeof(ret->NA17103)); +sqlFixedStringComma(&s, ret->NA17104, sizeof(ret->NA17104)); +sqlFixedStringComma(&s, ret->NA17105, sizeof(ret->NA17105)); +sqlFixedStringComma(&s, ret->NA17106, sizeof(ret->NA17106)); +sqlFixedStringComma(&s, ret->NA17201, sizeof(ret->NA17201)); +sqlFixedStringComma(&s, ret->NA17202, sizeof(ret->NA17202)); +sqlFixedStringComma(&s, ret->NA17203, sizeof(ret->NA17203)); +sqlFixedStringComma(&s, ret->NA17204, sizeof(ret->NA17204)); +sqlFixedStringComma(&s, ret->NA17205, sizeof(ret->NA17205)); +sqlFixedStringComma(&s, ret->NA17206, sizeof(ret->NA17206)); +sqlFixedStringComma(&s, ret->NA17207, sizeof(ret->NA17207)); +sqlFixedStringComma(&s, ret->NA17208, sizeof(ret->NA17208)); +sqlFixedStringComma(&s, ret->NA17210, sizeof(ret->NA17210)); +sqlFixedStringComma(&s, ret->NA17211, sizeof(ret->NA17211)); +sqlFixedStringComma(&s, ret->NA17212, sizeof(ret->NA17212)); +sqlFixedStringComma(&s, ret->NA17213, sizeof(ret->NA17213)); +sqlFixedStringComma(&s, ret->PD01, sizeof(ret->PD01)); +sqlFixedStringComma(&s, ret->PD02, sizeof(ret->PD02)); +sqlFixedStringComma(&s, ret->PD03, sizeof(ret->PD03)); +sqlFixedStringComma(&s, ret->PD04, sizeof(ret->PD04)); +sqlFixedStringComma(&s, ret->PD05, sizeof(ret->PD05)); +sqlFixedStringComma(&s, ret->PD06, sizeof(ret->PD06)); +sqlFixedStringComma(&s, ret->PD07, sizeof(ret->PD07)); +sqlFixedStringComma(&s, ret->PD08, sizeof(ret->PD08)); +sqlFixedStringComma(&s, ret->PD09, sizeof(ret->PD09)); +sqlFixedStringComma(&s, ret->PD10, sizeof(ret->PD10)); +sqlFixedStringComma(&s, ret->PD11, sizeof(ret->PD11)); +sqlFixedStringComma(&s, ret->PD12, sizeof(ret->PD12)); +sqlFixedStringComma(&s, ret->PD13, sizeof(ret->PD13)); +sqlFixedStringComma(&s, ret->PD14, sizeof(ret->PD14)); +sqlFixedStringComma(&s, ret->PD15, sizeof(ret->PD15)); +sqlFixedStringComma(&s, ret->PD16, sizeof(ret->PD16)); +sqlFixedStringComma(&s, ret->PD17, sizeof(ret->PD17)); +sqlFixedStringComma(&s, ret->PD18, sizeof(ret->PD18)); +sqlFixedStringComma(&s, ret->PD19, sizeof(ret->PD19)); +sqlFixedStringComma(&s, ret->PD20, sizeof(ret->PD20)); +sqlFixedStringComma(&s, ret->PD21, sizeof(ret->PD21)); +sqlFixedStringComma(&s, ret->PD22, sizeof(ret->PD22)); +sqlFixedStringComma(&s, ret->PD23, sizeof(ret->PD23)); +sqlFixedStringComma(&s, ret->PD24, sizeof(ret->PD24)); +*pS = s; +return ret; +} + +void affy120KDetailsFree(struct affy120KDetails **pEl) +/* Free a single dynamically allocated affy120KDetails such as created + * with affy120KDetailsLoad(). */ +{ +struct affy120KDetails *el; + +if ((el = *pEl) == NULL) return; +freeMem(el->rsId); +freez(pEl); +} + +void affy120KDetailsFreeList(struct affy120KDetails **pList) +/* Free a list of dynamically allocated affy120KDetails's */ +{ +struct affy120KDetails *el, *next; + +for (el = *pList; el != NULL; el = next) + { + next = el->next; + affy120KDetailsFree(&el); + } +*pList = NULL; +} + +void affy120KDetailsOutput(struct affy120KDetails *el, FILE *f, char sep, char lastSep) +/* Print out affy120KDetails. Separate fields with sep. Follow last field with lastSep. */ +{ +fprintf(f, "%d", el->affyId); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->rsId); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->baseA); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->baseB); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->sequenceA); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->sequenceB); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->enzyme); +if (sep == ',') fputc('"',f); +fputc(sep,f); +fprintf(f, "%f", el->minFreq); +fputc(sep,f); +fprintf(f, "%f", el->hetzyg); +fputc(sep,f); +fprintf(f, "%f", el->avHetSE); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->NA04477); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->NA04479); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->NA04846); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->NA11036); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->NA11038); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->NA13056); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->NA17011); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->NA17012); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->NA17013); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->NA17014); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->NA17015); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->NA17016); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->NA17101); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->NA17102); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->NA17103); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->NA17104); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->NA17105); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->NA17106); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->NA17201); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->NA17202); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->NA17203); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->NA17204); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->NA17205); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->NA17206); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->NA17207); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->NA17208); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->NA17210); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->NA17211); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->NA17212); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->NA17213); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->PD01); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->PD02); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->PD03); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->PD04); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->PD05); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->PD06); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->PD07); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->PD08); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->PD09); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->PD10); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->PD11); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->PD12); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->PD13); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->PD14); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->PD15); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->PD16); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->PD17); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->PD18); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->PD19); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->PD20); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->PD21); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->PD22); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->PD23); +if (sep == ',') fputc('"',f); +fputc(sep,f); +if (sep == ',') fputc('"',f); +fprintf(f, "%s", el->PD24); +if (sep == ',') fputc('"',f); +fputc(lastSep,f); +} + +/* -------------------------------- End autoSql Generated Code -------------------------------- */ +