genenetwork3/sql, branch technical-specification GeneNetwork3 REST API for data science and machine learning http://git.genenetwork.org/genenetwork3/atom?h=technical-specification 2022-02-11T06:29:24+00:00 sql: Remove database mapping code. 2022-02-11T06:29:24+00:00 Arun Isaac 2022-02-11T06:25:14+00:00 urn:sha1:d0c7631276223aae6954f7643abac262aa080e50 These tools have been greatly improved and moved to a new home at https://git.genenetwork.org/arunisaac/dump-genenetwork-database * sql/map-database.sh, sql/schema-from-in-db-documentation.org, sql/schema-original.sql, sql/schema.png, sql/schema.sql, sql/schema.svg: New files. Quote shell variables to prevent globbing 2022-02-11T02:52:36+00:00 Frederick Muriuki Muriithi 2022-02-11T02:45:24+00:00 urn:sha1:651c8ad9ae20ab52e7ab694c0caa9d92774b49b5 Quote the shell variables to prevent globbing and word splitting. Deactivate this check for the specific lines that require intentional word splitting Add SQL statement to update json_diff 2021-11-29T09:05:16+00:00 BonfaceKilz 2021-11-24T08:46:42+00:00 urn:sha1:9ab166a0d60b4a95c52599ab51ec97c19a2fff5b sql: Add documentation extracted from within the database. 2021-08-04T06:43:30+00:00 Arun Isaac 2021-08-04T06:43:30+00:00 urn:sha1:487e50e8f8304a65e7af3759c13256f921efb8be It turns out there is documentation of the database within the database itself. I have dumped that it into an org file. * sql/schema-from-in-db-documentation.org: New file. sql: Document the table Strain. 2021-08-02T11:36:50+00:00 Arun Isaac 2021-08-02T11:36:50+00:00 urn:sha1:c3fe5b77b4977c7ffe142852879fa1af9a32a929 * sql/schema.org (Strain): New section. sql: Add schema description. 2021-07-31T12:45:30+00:00 Arun Isaac 2021-07-31T12:45:30+00:00 urn:sha1:234dafc293b2a4a0f85c83cdd2253a9b9e57a74e * sql/schema.org: New file. sql: metadata_audit: Make char-set encoding explicit(utf8mb4) 2021-07-23T10:00:37+00:00 BonfaceKilz 2021-07-23T10:00:37+00:00 urn:sha1:13c4e1bbe6f30454c06235698efad146d99116dd See: https://www.eversql.com/mysql-utf8-vs-utf8mb4-whats-the-difference-between-utf8-and-utf8mb4/ Move sql updates into dir 2021-07-22T09:47:15+00:00 Pjotr Prins 2021-07-22T09:47:15+00:00 urn:sha1:086b7151295ede3aed32f29fb537bb5c6172393d sql: Add schema and schema map. 2021-07-22T08:44:55+00:00 Arun Isaac 2021-07-22T07:56:25+00:00 urn:sha1:0f8a4bb658bbea15c75dc30d590cb3818dd182eb * sql/map-database.sh, sql/schema-original.sql, sql/schema.png, sql/schema.sql, sql/schema.svg: New files. Rename json_data column to json_diff_data 2021-06-07T16:58:44+00:00 BonfaceKilz 2021-06-07T16:44:00+00:00 urn:sha1:a364496e9884e46080844bd3eddb2b52d6ed9164