From 234dafc293b2a4a0f85c83cdd2253a9b9e57a74e Mon Sep 17 00:00:00 2001
From: Arun Isaac
Date: Sat, 31 Jul 2021 18:15:30 +0530
Subject: sql: Add schema description.

* sql/schema.org: New file.
---
 sql/schema.org | 26 ++++++++++++++++++++++++++
 1 file changed, 26 insertions(+)
 create mode 100644 sql/schema.org

diff --git a/sql/schema.org b/sql/schema.org
new file mode 100644
index 0000000..0d0646f
--- /dev/null
+++ b/sql/schema.org
@@ -0,0 +1,26 @@
+#+TITLE: GeneNetwork Database Schema
+
+This is an attempt to reverse engineer and understand the schema of the
+GeneNetwork database. The goal is to prune redundant tables, fields, etc. and
+arrive at a simplified schema. This simplified schema will be useful when
+migrating the database.
+
+* Species
+** Id
+   Primary key
+** SpeciesId
+   Looks like a redundant key referred to as a foreign key from many other
+   tables. This field should be replaced by Id.
+** SpeciesName
+   Common name of the species. This field can be replaced by MenuName.
+** Name
+   Downcased common name used as key for the species in dictionaries
+** MenuName
+   Name in the Species dropdown menu. This is the SpeciesName, but sometimes
+   with the reference genome identifier mentioned in brackets.
+** FullName
+   Binomial name of the species
+** TaxonomyId
+   Foreign keys?
+** OrderId
+   Foreign keys?
-- 
cgit v1.2.3


From c3fe5b77b4977c7ffe142852879fa1af9a32a929 Mon Sep 17 00:00:00 2001
From: Arun Isaac
Date: Mon, 2 Aug 2021 17:06:50 +0530
Subject: sql: Document the table Strain.

* sql/schema.org (Strain): New section.
---
 sql/schema.org | 13 +++++++++++++
 1 file changed, 13 insertions(+)

diff --git a/sql/schema.org b/sql/schema.org
index 0d0646f..2db8a27 100644
--- a/sql/schema.org
+++ b/sql/schema.org
@@ -24,3 +24,16 @@ migrating the database.
    Foreign keys?
 ** OrderId
    Foreign keys?
+
+* Strain
+** Id
+   Primary key
+** Name
+   Name of the strain
+** Name2
+   A second name. For most rows, this is the same as Name. Why is this
+   necessary?
+** SpeciesId
+   Foreign key into the Species table
+** Symbol
+** Alias
-- 
cgit v1.2.3


From 32cfe15f056c0c2958d7da79d7a25e585d9cc13a Mon Sep 17 00:00:00 2001
From: BonfaceKilz
Date: Tue, 3 Aug 2021 15:26:18 +0300
Subject: guix.scm: Add csvdiff as a propagated input

---
 guix.scm | 15 ++++++---------
 1 file changed, 6 insertions(+), 9 deletions(-)

diff --git a/guix.scm b/guix.scm
index f20d62a..efef9c1 100644
--- a/guix.scm
+++ b/guix.scm
@@ -31,6 +31,7 @@
  (gnu packages databases)
  (gnu packages statistics)
  (gnu packages bioconductor)
+ (gn packages golang)
  (gnu packages python)
  (gnu packages python-check)
  (gnu packages python-crypto)
@@ -70,8 +71,8 @@
                       #:recursive? #t
                       #:select? git-file?))
   (propagated-inputs `(("coreutils" ,coreutils)
-                       ("diffutils" ,diffutils)
                        ("gemma-wrapper" ,gemma-wrapper)
+                       ("csvdiff" ,go-github-com-aswinkarthik-csvdiff)
                        ("python" ,python-wrapper)
                        ("python-bcrypt" ,python-bcrypt)
                        ("python-flask" ,python-flask)
@@ -84,15 +85,11 @@
                        ("python-redis" ,python-redis)
                        ("python-requests" ,python-requests)
                        ("python-scipy" ,python-scipy)
-                       ("python-sqlalchemy-stubs" ,python-sqlalchemy-stubs)
-                       ("r" ,r)
-                       ("r-qtl" ,r-qtl)
+                       ("python-sqlalchemy-stubs"
+                        ,python-sqlalchemy-stubs)
                        ("r-optparse" ,r-optparse)
-                       ("r-stringi" ,r-stringi)
-                       ("r-stringr" ,r-stringr)
-                       ("r-testthat" ,r-testthat)
-                       ("r-wgcna" ,r-wgcna)
-                       ))
+                       ("r-qtl" ,r-qtl)
+                       ("r-stringi" ,r-stringi)))
   (build-system python-build-system)
   (home-page "https://github.com/genenetwork/genenetwork3")
   (synopsis "GeneNetwork3 API for data science and machine learning.")
-- 
cgit v1.2.3