src/hg/qaPushQ/pushQ.h 1.13

1.13 2009/12/02 21:42:05 galt
oops get lockuser
Index: src/hg/qaPushQ/pushQ.h
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/qaPushQ/pushQ.h,v
retrieving revision 1.12
retrieving revision 1.13
diff -b -B -U 1000000 -r1.12 -r1.13
--- src/hg/qaPushQ/pushQ.h	18 Nov 2009 19:38:56 -0000	1.12
+++ src/hg/qaPushQ/pushQ.h	2 Dec 2009 21:42:05 -0000	1.13
@@ -1,196 +1,196 @@
 /* pushQ.h was originally generated by the autoSql program, which also 
  * generated pushQ.c and pushQ.sql.  This header links the database and
  * the RAM representation of objects. */
 
 #ifndef PUSHQ_H
 #define PUSHQ_H
 
 #include "jksql.h"
 #define PUSHQ_NUM_COLS 32
 
 struct pushQ
 /* Push Queue */
     {
     struct pushQ *next;  /* Next in singly linked list. */
     char qid[7];	/* Queue Id */
     char pqid[7];	/* Parent Queue Id if split off another */
     char priority[2];	/* Priority */
     unsigned rank;	/* Rank for display sort */
     char qadate[11];	/* QA (re)-submission date */
     char newYN[2];	/* new (track)? */
     char *track;	/* Track */
     char *dbs;	/* Databases */
     char *tbls;	/* Tables */
     char *cgis;	/* CGI(s) */
     char *files;	/* File(s) */
     unsigned sizeMB;	/* Size MB */
     char currLoc[21];	/* Current Location */
     char makeDocYN[2];	/* MakeDoc verified? */
     char onlineHelp[51];	/* Online Help */
     char ndxYN[2];	/* Index verified? */
     char joinerYN[2];	/* all.joiner verified? */
     char *stat;	/* Status */
     char sponsor[51];	/* Sponsor */
     char reviewer[51];	/* QA Reviewer */
     char extSource[129];	/* External Source */
     char *openIssues;	/* Open issues */
     char *notes;	/* Notes */
     char pushState[2];	/* Push State = NYD = No, Yes, Done */
     char initdate[11];	/* Initial Submission Date */
     char lastdate[11];	/* Last QA Date */
     unsigned bounces;	/* Bounce-count (num times bounced back to developer) */
-    char lockUser[9];	/* User who has locked record, or empty string */
+    char lockUser[17];	/* User who has locked record, or empty string */
     char lockDateTime[17];	/* When user placed lock, or empty string */
     char *releaseLog;	/* Release Log entry */
     char *featureBits;	/* Feature Bits results */
     char *releaseLogUrl;	/* Release Log URL */
     };
 
 void pushQStaticLoad(char **row, struct pushQ *ret);
 /* Load a row from pushQ table into ret.  The contents of ret will
  * be replaced at the next call to this function. */
 
 struct pushQ *pushQLoad(char **row);
 /* Load a pushQ from row fetched with select * from pushQ
  * from database.  Dispose of this with pushQFree(). */
 
 struct pushQ *pushQLoadAll(char *fileName);
 /* Load all pushQ from whitespace-separated file.
  * Dispose of this with pushQFreeList(). */
 
 struct pushQ *pushQLoadAllByChar(char *fileName, char chopper);
 /* Load all pushQ from chopper separated file.
  * Dispose of this with pushQFreeList(). */
 
 #define pushQLoadAllByTab(a) pushQLoadAllByChar(a, '\t');
 /* Load all pushQ from tab separated file.
  * Dispose of this with pushQFreeList(). */
 
 struct pushQ *pushQLoadByQuery(struct sqlConnection *conn, char *query);
 /* Load all pushQ 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 pushQFreeList(). */
 
 void pushQSaveToDb(struct sqlConnection *conn, struct pushQ *el, char *tableName, int updateSize);
 /* Save pushQ 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. Note that strings must be escaped to allow insertion into the database.
  * For example "autosql's features include" --> "autosql\'s features include" 
  * If worried about this use pushQSaveToDbEscaped() */
 
 void pushQSaveToDbEscaped(struct sqlConnection *conn, struct pushQ *el, char *tableName, int updateSize);
 /* Save pushQ 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. Automatically 
  * escapes all simple strings (not arrays of string) but may be slower than pushQSaveToDb().
  * For example automatically copies and converts: 
  * "autosql's features include" --> "autosql\'s features include" 
  * before inserting into database. */ 
 
 struct pushQ *pushQCommaIn(char **pS, struct pushQ *ret);
 /* Create a pushQ out of a comma separated string. 
  * This will fill in ret if non-null, otherwise will
  * return a new pushQ */
 
 void pushQFree(struct pushQ **pEl);
 /* Free a single dynamically allocated pushQ such as created
  * with pushQLoad(). */
 
 void pushQFreeList(struct pushQ **pList);
 /* Free a list of dynamically allocated pushQ's */
 
 void pushQOutput(struct pushQ *el, FILE *f, char sep, char lastSep);
 /* Print out pushQ.  Separate fields with sep. Follow last field with lastSep. */
 
 #define pushQTabOut(el,f) pushQOutput(el,f,'\t','\n');
 /* Print out pushQ as a line in a tab-separated file. */
 
 #define pushQCommaOut(el,f) pushQOutput(el,f,',',',');
 /* Print out pushQ as a comma separated list including final comma. */
 
 #define USERS_NUM_COLS 4
 
 struct users
 /* PushQ Users */
     {
     struct users *next;  /* Next in singly linked list. */
     char user[17];	/* User */
     char password[35];	/* Password */
     char role[9];	/* Role=admin,dev,qa */
     char *contents;	/* pushq-cart contents */
     };
 
 void usersStaticLoad(char **row, struct users *ret);
 /* Load a row from users table into ret.  The contents of ret will
  * be replaced at the next call to this function. */
 
 struct users *usersLoad(char **row);
 /* Load a users from row fetched with select * from users
  * from database.  Dispose of this with usersFree(). */
 
 struct users *usersLoadAll(char *fileName);
 /* Load all users from whitespace-separated file.
  * Dispose of this with usersFreeList(). */
 
 struct users *usersLoadAllByChar(char *fileName, char chopper);
 /* Load all users from chopper separated file.
  * Dispose of this with usersFreeList(). */
 
 #define usersLoadAllByTab(a) usersLoadAllByChar(a, '\t');
 /* Load all users from tab separated file.
  * Dispose of this with usersFreeList(). */
 
 struct users *usersLoadByQuery(struct sqlConnection *conn, char *query);
 /* Load all users 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 usersFreeList(). */
 
 void usersSaveToDb(struct sqlConnection *conn, struct users *el, char *tableName, int updateSize);
 /* Save users 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. Note that strings must be escaped to allow insertion into the database.
  * For example "autosql's features include" --> "autosql\'s features include" 
  * If worried about this use usersSaveToDbEscaped() */
 
 void usersSaveToDbEscaped(struct sqlConnection *conn, struct users *el, char *tableName, int updateSize);
 /* Save users 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. Automatically 
  * escapes all simple strings (not arrays of string) but may be slower than usersSaveToDb().
  * For example automatically copies and converts: 
  * "autosql's features include" --> "autosql\'s features include" 
  * before inserting into database. */ 
 
 struct users *usersCommaIn(char **pS, struct users *ret);
 /* Create a users out of a comma separated string. 
  * This will fill in ret if non-null, otherwise will
  * return a new users */
 
 void usersFree(struct users **pEl);
 /* Free a single dynamically allocated users such as created
  * with usersLoad(). */
 
 void usersFreeList(struct users **pList);
 /* Free a list of dynamically allocated users's */
 
 void usersOutput(struct users *el, FILE *f, char sep, char lastSep);
 /* Print out users.  Separate fields with sep. Follow last field with lastSep. */
 
 #define usersTabOut(el,f) usersOutput(el,f,'\t','\n');
 /* Print out users as a line in a tab-separated file. */
 
 #define usersCommaOut(el,f) usersOutput(el,f,',',',');
 /* Print out users as a comma separated list including final comma. */
 
 /* -------------------------------- End autoSql Generated Code -------------------------------- */
 
 #endif /* PUSHQ_H */