| Line 0
          
      
      
        Link Here | 
          
            
              | 0 | -  | 1 | #!/usr/bin/perl | 
            
              |  |  | 2 |  | 
            
              | 3 | # This file is part of Koha. | 
            
              | 4 | # | 
            
              | 5 | # Koha is free software; you can redistribute it and/or modify it | 
            
              | 6 | # under the terms of the GNU General Public License as published by | 
            
              | 7 | # the Free Software Foundation; either version 3 of the License, or | 
            
              | 8 | # (at your option) any later version. | 
            
              | 9 | # | 
            
              | 10 | # Koha is distributed in the hope that it will be useful, but | 
            
              | 11 | # WITHOUT ANY WARRANTY; without even the implied warranty of | 
            
              | 12 | # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the | 
            
              | 13 | # GNU General Public License for more details. | 
            
              | 14 | # | 
            
              | 15 | # You should have received a copy of the GNU General Public License | 
            
              | 16 | # along with Koha; if not, see <http://www.gnu.org/licenses>. | 
            
              | 17 |  | 
            
              | 18 | use Modern::Perl; | 
            
              | 19 | use Test::More tests => 1; | 
            
              | 20 | use File::Slurp; | 
            
              | 21 | use C4::Context; | 
            
              | 22 | my $content = read_file( C4::Context->config("intranetdir") | 
            
              | 23 |       . '/installer/data/mysql/kohastructure.sql' ); | 
            
              | 24 | my @drop_stmt_missing; | 
            
              | 25 | my $ccc = $content; | 
            
              | 26 | while ( $content =~ m|CREATE TABLE `?([^`\n ]*)`?\s?\(\s*\n|g ) { | 
            
              | 27 |     my $match = $1; | 
            
              | 28 |     next if $match =~ m|^IF NOT EXISTS |; | 
            
              | 29 |     push @drop_stmt_missing, $match unless $ccc =~ m|DROP TABLE [^\n]*$match|; | 
            
              | 30 | } | 
            
              | 31 | is( | 
            
              | 32 |     @drop_stmt_missing, | 
            
              | 33 |     0, | 
            
              | 34 |     'DROP TABLE statements should exist for all tables' | 
            
              | 35 |       . ( | 
            
              | 36 |         @drop_stmt_missing | 
            
              | 37 |         ? ' but missing for ' . join( ',', @drop_stmt_missing ) | 
            
              | 38 |         : '' | 
            
              | 39 |       ) | 
            
              | 40 | ); |