diff options
| author | Arun Isaac | 2022-02-11 11:55:14 +0530 |
|---|---|---|
| committer | Arun Isaac | 2022-02-11 11:59:24 +0530 |
| commit | d0c7631276223aae6954f7643abac262aa080e50 (patch) | |
| tree | 34144f317def70a028feb753d7583d1e837b27b3 /sql/map-database.sh | |
| parent | 5c5df8148fcaaed33a49a29cd303d739855ea251 (diff) | |
| download | genenetwork3-d0c7631276223aae6954f7643abac262aa080e50.tar.gz | |
sql: Remove database mapping code.
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.
Diffstat (limited to 'sql/map-database.sh')
| -rwxr-xr-x | sql/map-database.sh | 17 |
1 files changed, 0 insertions, 17 deletions
diff --git a/sql/map-database.sh b/sql/map-database.sh deleted file mode 100755 index 35a435f..0000000 --- a/sql/map-database.sh +++ /dev/null @@ -1,17 +0,0 @@ -#! /bin/sh -e - -# This scripts visualizes schema.sql into schema.png and schema.svg. It uses -# sqlt-graph from the perl-sql-transform package. Sadly, perl-sql-transform is -# not packaged for Guix yet. We will likely deprecate this script in favor of -# a custom scheme script that does not depend on perl-sql-transform. - -skip_tables=AvgMethod,CeleraINFO_mm6,Chr_Length,DatasetMapInvestigator,DatasetStatus,Dataset_mbat,EnsemblProbe,EnsemblProbeLocation,GORef,GeneCategory,GeneIDXRef,GeneList_rn3,GeneList_rn33,GeneMap_cuiyan,GeneRIFXRef,GenoCode,GenoFile,GenoSE,H2,InfoFiles,InfoFilesUser_md5,LCorrRamin3,RatSnpPattern,Sample,SampleXRef,SnpAllRat,SnpAllele_to_be_deleted,SnpPattern,SnpSource,Vlookup,metadata_audit,pubmedsearch,temporary - -clusters="Others=AccessLog,Docs,Investigators,MachineAccessLog,News,Organizations,TableComments,TableFieldAnnotation,User,UserPrivilege,login,role,roles_users,user,user_collection,user_openids" - -flags="--db MySQL --skip-tables $skip_tables --cluster $clusters" - -# shellcheck disable=SC2086 # Intentional splitting of `flags` -sqlt-graph $flags --output-type png --output schema.png schema.sql -# shellcheck disable=SC2086 # Intentional splitting of `flags` -sqlt-graph $flags --output-type svg --output schema.svg schema.sql |