Bugzilla – Attachment 32173 Details for
Bug 13068
New feature for DB update and sandbox
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 13068, updatedatabase improvement for developer process
Bug-13068-updatedatabase-improvement-for-developer.patch (text/plain), 2.02 KB, created by
Paul Poulain
on 2014-10-10 15:31:41 UTC
(
hide
)
Description:
Bug 13068, updatedatabase improvement for developer process
Filename:
MIME Type:
Creator:
Paul Poulain
Created:
2014-10-10 15:31:41 UTC
Size:
2.02 KB
patch
obsolete
>From 7075772409240a582a03efada1473f41a20e4750 Mon Sep 17 00:00:00 2001 >From: Paul Poulain <paul.poulain@biblibre.com> >Date: Fri, 10 Oct 2014 17:30:22 +0200 >Subject: [PATCH] Bug 13068, updatedatabase improvement for developer process > >with this patch, the updatedatabase now checks info the db_update directory. If there is something here, it's executed. >Note that there is no version update, so if you run the updatedatabase script twice, you'll get an sql error probably. > >This patch will be very useful for sandbox testing process. > >When the RM pushes a patch with something in db_update, he will have to copy it into updatedatabase.pl, give it a number, and remove the file in db_update > > >Test plan: > * apply the patch > * create a files with a .sql extension in the db_update directory > * run updatedatabase.pl > * look at your database, what was in the .sql file must have been run >--- > installer/data/mysql/updatedatabase.pl | 21 +++++++++++++++++++++ > 1 file changed, 21 insertions(+) > >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index 6ea5911..e2c89e6 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -8781,6 +8781,27 @@ if ( CheckVersion($DBversion) ) { > SetVersion($DBversion); > } > >+# DEVELOPER PROCESS, search for anything to execute in the db_update directory >+# SEE bug 13068 >+# if there is anything in the db_update, read and execute it. >+ >+opendir( my $dirh, C4::Context->config('intranetdir') . '/installer/data/mysql/db_update' ); >+my $old_delimiter = $/; >+$/ = ';'; >+while (readdir $dirh) { >+ next unless $_ =~ /\.sql$/; # skip non SQL files >+ # open and read file; >+ open FILE, "<", C4::Context->config('intranetdir') . '/installer/data/mysql/db_update/'.$_ or die "ERROR, impossible to open $_"; >+ my $sql_to_execute; >+ while ( <FILE> ) { >+ my $line = $_; >+ $line =~ s/\n//g; >+ $dbh->do($line) if $line; >+ $sql_to_execute .= $line; >+ } >+} >+ >+ > =head1 FUNCTIONS > > =head2 TableExists($table) >-- >1.9.1
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 13068
:
32173
|
32174
|
32175
|
32177
|
32178
|
32179
|
32180
|
32185
|
32294
|
32300
|
32398
|
32399
|
32525
|
32526
|
32658
|
32659
|
32784
|
32785
|
32839
|
32840
|
32841
|
32842
|
32843
|
32919
|
32921
|
33859
|
34070
|
34071
|
34072
|
34949
|
34950
|
34951
|
34960
|
34998
|
35000
|
35001
|
35002
|
35003
|
35366
|
35367
|
35368
|
35370
|
36716
|
36717
|
36718
|
36719
|
36779
|
36780
|
36781
|
36792
|
37061
|
37062
|
37063
|
37064
|
37065
|
37066
|
37075
|
37076
|
37491