#!/bin/bash # Author: Benjamin Diaz # Licensed under GNU General Public License v2.0 # http://www.gnu.org/licenses/gpl.html # #Quick-and-dirty translator from mysqldump to an E-R diagram in Umbrello #No key/index translation implemented as of Nov. 23 2006 #Help if [ -z "$1" -o "$1" = "-h" -o "$1" = "--help" ] ; then cat <$XF umbrello uml modeller http://uml.sf.net 1.4.2 UnicodeUTF8 EOF function typenum() { #Based on UML:DataTypes case "$1" in int) return 2 ;; char) return 4 ;; bool) return 5 ;; float) return 6 ;; double) return 7 ;; short) return 8 ;; long) return 9 ;; uint) return 10 ;; ushort) return 11 ;; ulong) return 12 ;; string) return 13 ;; varchar) return 107 ;; date) return 116 ;; decimal) return 126 ;; mediumblob) return 133 ;; datetime) return 135 ;; text) return 144 ;; bigint) return 148 ;; esac } function sqltype() { case $1 in CREATE) echo "" >> $XF ((CONT_DB++)) ;; PRIMARY) #We have conveniently ignored key definitions #Insert code here return 0 ;; UNIQUE) return 0 ;; KEY) return 0 ;; \)) #End of table echo "" >> $XF ;; *) #It's a column, apparently NAME=$1 HASLENGTH=`echo $2 | grep '('` if [ -n "$HASLENGTH" ] ; then TYPE=`echo $2 | cut -d '(' -f 1` LENGTH=`echo $2 | cut -d '(' -f 2 | sed "s/\x29//"` else TYPE=$2 LENGTH="" fi if [ "$3" = "unsigned" ] ; then TYPE="u$TYPE" ATTRIBUTES=$3 other=4 else other=3 fi #What other features have we here? PARAMS=$# ALLOWNULL=1 AUTOINC=0 DEFAULT="" for ((i=other;i<=PARAMS;i++)) ; do if [ $i -lt $PARAMS ] ; then ((n=i+1)) NEXT=${!n} fi THIS=${!i} case $THIS in NOT) if [ $NEXT = "NULL" ] ; then ALLOWNULL=0 ((i++)) fi ;; auto_increment) AUTOINC=1 ;; default) DEFAULT="$NEXT" ((i++)) ;; esac done typenum $TYPE TYPENUM=$? echo "" >> $XF ((CONT_COL++)) ;; esac } for i in `grep -v "^--\|^\/\*\|^\$\|^DROP" "$SQL" | sed "s/\s/�/g"` ; do #Remove quotes, apostrophes, graves, and unneeded punctuation ii=`echo $i | sed "s/�/ /g;s/[\x60\x27]//g;s/\x2c\$//"` sqltype $ii done #Rest of document cat <> $XF

EOF