schema/spacewalk/spacewalk-schema-upgrade | 34 +++++++++++++++--------------- 1 file changed, 17 insertions(+), 17 deletions(-)
New commits: commit 76b6d1795db289cef576341e9f9486b70d888fe5 Author: Milan Zazrivec mzazrivec@redhat.com Date: Thu Sep 24 18:25:45 2009 +0200
Don't indent sql upgrade code in resulting script
diff --git a/schema/spacewalk/spacewalk-schema-upgrade b/schema/spacewalk/spacewalk-schema-upgrade index 7208387..b25fddf 100755 --- a/schema/spacewalk/spacewalk-schema-upgrade +++ b/schema/spacewalk/spacewalk-schema-upgrade @@ -144,14 +144,14 @@ my $stamp = sprintf "%04d%02d%02d-%02d%02d%02d", $year + 1900, $mon + 1, $mday,
my $start = $start_schema_norm; my $in = <<EOF; - spool $SCHEMA_UPGRADE_LOGDIR/$stamp-begin.log append - whenever sqlerror exit sql.sqlcode - - update rhnVersionInfo - set label = 'schema-from-' || to_char(created, 'YYYYMMDD-HH24MISS'), - modified = sysdate - where label = 'schema'; - commit; +spool $SCHEMA_UPGRADE_LOGDIR/$stamp-begin.log append +whenever sqlerror exit sql.sqlcode + +update rhnVersionInfo + set label = 'schema-from-' || to_char(created, 'YYYYMMDD-HH24MISS'), + modified = sysdate + where label = 'schema'; +commit; EOF
while (@path) { @@ -212,15 +212,15 @@ EOF }
$in .= <<EOF; - spool $SCHEMA_UPGRADE_LOGDIR/$stamp-end.log append - whenever sqlerror exit sql.sqlcode - - insert into rhnVersionInfo - ( label, name_id, evr_id, created, modified ) - values ('schema', lookup_package_name('$my_schema_name'), - lookup_evr(null, '$my_schema_version' , '$my_schema_release' ), - sysdate, sysdate ); - commit; +spool $SCHEMA_UPGRADE_LOGDIR/$stamp-end.log append +whenever sqlerror exit sql.sqlcode + +insert into rhnVersionInfo + ( label, name_id, evr_id, created, modified ) + values ('schema', lookup_package_name('$my_schema_name'), + lookup_evr(null, '$my_schema_version' , '$my_schema_release' ), + sysdate, sysdate ); +commit; EOF
$in .= "quit;\n";
spacewalk-commits@lists.fedorahosted.org