More fun with GraphViz

svn path=/docs/rpki-db-schema.sql; revision=1015

1 files changed, 8 insertions, 5 deletions

diff --git a/scripts/graphviz-sql.sh b/scripts/graphviz-sql.sh
index a338404a..7ff0babd 100644
--- a/scripts/graphviz-sql.sh
+++ b/scripts/graphviz-sql.sh
@@ -12,13 +12,16 @@
 
 for i in *.sql
 do
-  sqlt-graph --db MySQL --output-type canon --show-datatypes $i |
+  sqlt-graph --db MySQL --output-type canon --show-datatypes --show-constraints $i |
   perl -0777 -pe '
     s/\\\n/ /g;
-    s/\\{//g;
-    s/\\\|-\\ /|{/g;
-    s/\\ *\\ *l *-\\ /|/g;
-    s/\\ *\\l\\}/}/g;
+    s/  +/ /g;
+    s/\\\|/|/g;
+    s/\\{([a-z0-9_]+)\|/${1}|{/gi;
+    s/-\\ +//g;
+    s/\\ \\l/|/g;
+    s/\|\\l \\}/}/g;
+    s/\|\\}/}/g;
     s/{\n/{\n\tedge [arrowtail=none, arrowhead=crow];\n/;
   ' |
   tee ${i%.sql}.dot |