SQLite CVSTrac

*** 99,107 ****
  
      #!/bin/sh
  
!     mysqldump --compact --compatible=ansi --default-character-set=binary mydbname |
      grep -v '  KEY "' |
      grep -v '  UNIQUE KEY "' |
      perl -e 'local $/;$_=<>;s/,\n\)/\n\)/gs;print "begin;\n";print;print "commit;\n"' |
      perl -pe '
          if (/^(INSERT.+?)\(/) {
--- 99,132 ----
  
    #!/bin/sh
  
!   if [ "x$1" == "x" ]; then
!      echo "Usage: $0 <dbname>"
!      exit
!   fi
! 
!   if [ -e "$1.db" ]; then
!      echo "$1.db already exists.  I will overwrite it in 15 seconds if you do not press CTRL-C."
!      COUNT=15
!      while [ $COUNT -gt 0 ]; do
!         echo "$COUNT"
!         sleep 1
!         COUNT=$((COUNT - 1))
!      done
!      rm $1.db
!   fi
! 
!   /opt/lampp/bin/mysqldump -u root -p --compact --compatible=ansi --default-character-set=binary $1 |
    grep -v ' KEY "' |
    grep -v ' UNIQUE KEY "' |
+   grep -v ' PRIMARY KEY ' |
+   sed 's/ unsigned / /g' |
+   sed 's/ auto_increment/ primary key autoincrement/gi' |
+   sed 's/ smallint([0-9]*) / integer /gi' |
+   sed 's/ tinyint([0-9]*) / integer /gi' |
+   sed 's/ int([0-9]*) / integer /gi' |
+   sed 's/ character set [^ ]* / /gi' |
+   sed 's/ enum([^)]*) / varchar(255) /gi' |
+   sed 's/ on update [^,]*//gi' |
    perl -e 'local $/;$_=<>;s/,\n\)/\n\)/gs;print "begin;\n";print;print "commit;\n"' |
    perl -pe '
    if (/^(INSERT.+?)\(/) {
***************
*** 110,117 ****
                  s/\\n/\n/g;
                  s/\),\(/\);\n$a\(/g;
          }
!     ' |
!     sqlite3 output.db
  
  *: {link: http://www.pobox.com/~berend/xplain2sql/index.html#downloadbeta xplain2sql, Xplain to SQL converter}
  
--- 135,150 ----
       s/\\n/\n/g;
       s/\),\(/\);\n$a\(/g;
    }
!   ' > $1.sql
!   cat $1.sql | sqlite3 $1.db > sqlerrors.txt
!   ERRORS=`cat sqlerrors.txt | wc -l`
!   if [ "$ERRORS" == "0" ]; then
!      echo "Conversion completed without error."
!      rm $1.sql
!      rm sqlerrors.txt
!   else
!      echo "There were errors during conversion.  Please review sqlerrors.txt and $1.sql for details."
!   fi
  
  *: {link: http://www.pobox.com/~berend/xplain2sql/index.html#downloadbeta xplain2sql, Xplain to SQL converter}

sqlite - Converter Tools