e70152e44cc66cc599ff6b699eb8adc07f3e656a
kent
  Sat May 24 21:09:34 2014 -0700
Adding Copyright NNNN Regents of the University of California to all files I believe with reasonable certainty were developed under UCSC employ or as part of Genome Browser copyright assignment.
diff --git src/hg/lib/ec.c src/hg/lib/ec.c
index 448a31a..ce3564d 100644
--- src/hg/lib/ec.c
+++ src/hg/lib/ec.c
@@ -1,54 +1,57 @@
+/* Copyright (C) 2014 The Regents of the University of California 
+ * See README in this or parent directory for licensing information. */
+
 #include "common.h"
 #include "jksql.h"
 #include "hdb.h"
 #include "ecCode.h"
 #include "ecAttribute.h"
 #include "ecAttributeCode.h"
 
 void getEcHtml(char *ecNumber)
 /* fetch ec codes and descriptions and output html */
 {
 char query[1024];
 struct sqlConnection *conn = hAllocConn("ec");
 char *level1 = NULL;
 char *level2 = NULL;
 char *level3 = NULL;
 //char *level4 = NULL;
 struct ecAttribute attr;
 char **row = NULL;
 struct sqlResult *sr = NULL;
 
 if (ecNumber == NULL)
     return;
 if (conn == NULL)
     return;
 sqlSafef(query,sizeof(query), "select distinct e.description from ecAttribute a , ecCode e where a.ec = \"%s\" and a.level1 = e.level1 and e.level2 = 0 ",ecNumber);
 level1 = sqlQuickString(conn, query);
 sqlSafef(query,sizeof(query), "select distinct e.description from ecAttribute a , ecCode e where a.ec = \"%s\" and a.level1 = e.level1 and a.level2 = e.level2 and e.level3 = 0 ",ecNumber);
 level2 = sqlQuickString(conn, query);
 sqlSafef(query,sizeof(query), "select distinct e.description from ecAttribute a , ecCode e where a.ec = \"%s\" and a.level1 = e.level1 and a.level2 = e.level2 and a.level3 = e.level3 and e.level4 = 0 ",ecNumber);
 level3 = sqlQuickString(conn, query);
 //sqlSafef(query,sizeof(query), "select distinct description from ecAttribute a where a.ec = \"%s\" ",ecNumber);
 //level4 = sqlQuickString(conn, query);
 
 printf("[ %s / %s / %s ] <BR>",
         (level1 != NULL) ? level1 :"n/a", 
         (level2 != NULL) ? level2 :"n/a", 
         (level3 != NULL) ? level3 :"n/a"
 //        (level4 != NULL) ? level4 :"n/a"
         );
 sqlSafef(query,sizeof(query), "select * from ecAttribute a where a.ec = \"%s\"",ecNumber);
 sr = sqlGetResult(conn, query);
 while ((row = sqlNextRow(sr)) != NULL)
     {
     char *attrDesc = NULL;
     struct sqlConnection *conn2 = hAllocConn("ec");
     ecAttributeStaticLoad(row, &attr);
     sqlSafef(query,sizeof(query), "select description from ecAttributeCode where type = \"%s\" ",attr.type);
     attrDesc = sqlQuickString(conn2, query);
     if (differentString(attr.type, "DR"))
         printf("<B>EC %s:</B> %s<BR>", attrDesc != NULL ? attrDesc : "n/a",attr.description);
     hFreeConn(&conn2);
     }
 hFreeConn(&conn);
 }