schemacheck.in 2.76 KB
Newer Older
1
#!/usr/bin/perl -w
Leigh Stoller's avatar
Leigh Stoller committed
2 3

#
4
# Copyright (c) 2000-2017 University of Utah and the Flux Group.
5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
# 
# {{{EMULAB-LICENSE
# 
# This file is part of the Emulab network testbed software.
# 
# This file is free software: you can redistribute it and/or modify it
# under the terms of the GNU Affero General Public License as published by
# the Free Software Foundation, either version 3 of the License, or (at
# your option) any later version.
# 
# This file is distributed in the hope that it will be useful, but WITHOUT
# ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
# FITNESS FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public
# License for more details.
# 
# You should have received a copy of the GNU Affero General Public License
# along with this file.  If not, see <http://www.gnu.org/licenses/>.
# 
# }}}
Leigh Stoller's avatar
Leigh Stoller committed
24
#
25 26 27 28 29 30 31 32 33 34
use strict;

#
# schemacheck - Make sure that the scehma in the currently-running database
# matches the one in the checked-out source. Exits with value 1 if the two
# differ, 0 if they do not, and -1 if some error (such as the mysql server is
# not running, or the database does not exist) prevents us from telling if
# they differ or not
#

35 36 37 38 39
#
# Function prototypes
#
sub fatal(@);

40 41 42 43 44 45 46 47
#
# Configure variables
#
my $testbed_srcdir = "@top_srcdir@";
my $DBNAME         = "@TBDBNAME@";

my $master_schema = "$testbed_srcdir/sql/database-create.sql";
my $schemadiff = "$testbed_srcdir/utils/schemadiff";
48
my $extraopts  = "";
49

50 51 52 53 54 55 56 57 58 59 60 61 62
my $mysqlvers = `mysql -V`;
if ($mysqlvers =~ /Distrib (\d\.\d)/) {
    my $vers = $1 + 0.0;
    if ($vers >= 5.0) {
	$extraopts .= "--skip-quote-names ";
    }
    if ($vers >= 5.7) {
	$extraopts .= "--set-gtid-purged=off ";
    }
}
else {
    fatal("Could not determine mysql version");
}
63

64 65 66 67
#
# XXX: Requires that mysqldump be in caller's $PATH - probably an OK
# assumption, but maybe not always
#
68
my $mysqldump = "mysqldump -d $extraopts $DBNAME";
69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85

#
# Make sure we can write the temporary file
#
my $db_schema = "/tmp/schemacheck.$$";
open(SCHEMAFILE,">$db_schema") or
    fatal("Unable to write to temporary file $db_schema: $!\n");
close(SCHEMAFILE);

#
# Stick the output of mysqldump into a file
#
system "$mysqldump 2> /dev/null > $db_schema";

#
# ... and compare it to the schema from the source
#
86
my $diff = (system("$schemadiff $db_schema $master_schema") >> 8);
87 88 89
unlink($db_schema);

if ($diff) {
90 91 92
    print "*** Your DB schema are out of date with $master_schema\n";
    print "    As a safety measure, you will not be able to install until\n";
    print "    this is resolved.\n";
93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109
    exit(1);
} else {
    exit(0);
}

sub fatal(@) {

    # Offset the text with a few blank lines, so it doesn't get lost in the
    # make messages
    warn "\n\n";
    warn "*** schemacheck - Unable to check database schema:\n";
    warn @_;
    warn "\n\n";

    exit(-1);

}