apply-sql-patch

   1 #!/bin/sh
   2
   3 # applies SQL patch to a database and inserts a revision control entry in the
   4 # database.
   5 # usage :
   6 # apply-sql-patch (without arguments)
   7 # prints sql statements to initialise the datbase
   8 # apply-sql-patch <patch-file>
   9 # applies the patch to the database
  10
  11 if [ $# -ne 2 ]
  12 then cat<<EOF
  13 --
  14 -- you have to apply manually this SQL patch to your database
  15 -- to create the needed ctrl_patch table
  16 --
  17 create table ctrl_patch (id integer auto_increment primary key, time timestamp, name varchar(128) unique);
  18 insert into ctrl_patch values (NULL,NULL, 'patch-create-ctrl_patch.sql');
  19 EOF
  20 exit
  21 fi
  22
  23 patch=$1
  24 db=$2
  25 db_user=root
  26
  27 ctrl_patch_query="insert into ctrl_patch values (NULL,NULL, '$patch')"
  28
  29 cat $patch
  30 mysql -u $db_user $db < $patch
  31 echo $ctrl_patch_query
  32 if [ $? ]
  33 then
  34 echo $ctrl_patch_query | mysql -u $db_user $db
  35 fi