From 55221dca1c1adb6559957262cac21b023dfa11e7 Mon Sep 17 00:00:00 2001
From: zsloan
Date: Tue, 14 Jul 2020 12:12:21 -0500
Subject: Added binary casting to phenotype trait info query to fix unicode
 issue

---
 wqflask/base/trait.py | 14 +++++++-------
 1 file changed, 7 insertions(+), 7 deletions(-)

diff --git a/wqflask/base/trait.py b/wqflask/base/trait.py
index ecb9dcd9..f9da7b87 100644
--- a/wqflask/base/trait.py
+++ b/wqflask/base/trait.py
@@ -395,11 +395,14 @@ def retrieve_trait_info(trait, dataset, get_qtl_info=False):
             query = """
                     SELECT
                             PublishXRef.Id, InbredSet.InbredSetCode, Publication.PubMed_ID,
-                            Phenotype.Pre_publication_description, Phenotype.Post_publication_description, Phenotype.Original_description,
-                            Phenotype.Pre_publication_abbreviation, Phenotype.Post_publication_abbreviation, PublishXRef.mean,
+                            CAST(Phenotype.Pre_publication_description AS BINARY),
+                            CAST(Phenotype.Post_publication_description AS BINARY),
+                            CAST(Phenotype.Original_description AS BINARY),
+                            CAST(Phenotype.Pre_publication_abbreviation AS BINARY),
+                            CAST(Phenotype.Post_publication_abbreviation AS BINARY), PublishXRef.mean,
                             Phenotype.Lab_code, Phenotype.Submitter, Phenotype.Owner, Phenotype.Authorized_Users,
-                            Publication.Authors, Publication.Title, Publication.Abstract,
-                            Publication.Journal, Publication.Volume, Publication.Pages,
+                            CAST(Publication.Authors AS BINARY), CAST(Publication.Title AS BINARY), CAST(Publication.Abstract AS BINARY),
+                            CAST(Publication.Journal AS BINARY), Publication.Volume, Publication.Pages,
                             Publication.Month, Publication.Year, PublishXRef.Sequence,
                             Phenotype.Units, PublishXRef.comments
                     FROM
@@ -462,9 +465,6 @@ def retrieve_trait_info(trait, dataset, get_qtl_info=False):
         trait.haveinfo = True
         for i, field in enumerate(dataset.display_fields):
             holder =  trait_info[i]
-            # if isinstance(trait_info[i], basestring):
-            #     holder = unicode(holder.strip(codecs.BOM_UTF8), 'utf-8', "ignore")
-
             setattr(trait, field, holder)
 
         if dataset.type == 'Publish':
-- 
cgit v1.2.3