[prev] [thread] [next] [lurker] [Date index for 2003/12/18]
Author: gabor
Date: 2003-12-18 16:28:41 +0200 (Thu, 18 Dec 2003)
New Revision: 125
Added:
yapcom/trunk/bin/upgrade.pl
Modified:
yapcom/trunk/MANIFEST
yapcom/trunk/README
yapcom/trunk/lib/YAPC/Organizer.pm
yapcom/trunk/t/lib/YAPC/Test.pm
yapcom/trunk/templates/header.tmpl
Log:
add upgrade script, revoke part of the change of Shlomi as it was breaking too many tests
Modified: yapcom/trunk/MANIFEST
===================================================================
--- yapcom/trunk/MANIFEST 2003-12-18 13:30:13 UTC (rev 124)
+++ yapcom/trunk/MANIFEST 2003-12-18 14:28:41 UTC (rev 125)
@@ -7,6 +7,7 @@
bin/setup.pl no
bin/install.pl no
bin/sqlite.pl no
+bin/upgrade.pl no
cgi/2004
files/style.css
files/yapsi.gif
Modified: yapcom/trunk/README
===================================================================
--- yapcom/trunk/README 2003-12-18 13:30:13 UTC (rev 124)
+++ yapcom/trunk/README 2003-12-18 14:28:41 UTC (rev 125)
@@ -10,14 +10,8 @@
see the bin/upgrade.pl file.
1) shut down the web server
-2) write
- > sqlite db/yapc.db .dump > out.txt
- > cp out.txt in.txt
- Edit the in.txt file to include the creatin of new
-
- > sqlite
+2) see bin/upgrade and use it
3) start the web server
-4) Hope that everything went well.
INSTALLATION
Added: yapcom/trunk/bin/upgrade.pl
===================================================================
--- yapcom/trunk/bin/upgrade.pl 2003-12-18 13:30:13 UTC (rev 124)
+++ yapcom/trunk/bin/upgrade.pl 2003-12-18 14:28:41 UTC (rev 125)
@@ -0,0 +1,23 @@
+
+my $insert = "(id, fname, lname, email, password, authcode, acked, company, country, state, city, street, zip, phone, pauseid, url, mongers, bio, photo, other)";
+
+
+system "/usr/bin/sqlite old.db .dump > old.txt";
+open my $in, "old.txt";
+open my $out, ">new.txt";
+while (my $line =<$in>) {
+ $line =~ s/^INSERT INTO people VALUE/INSERT INTO people $insert VALUE/;
+ print $out $line;
+}
+
+# manually add the new columns to the CREATE table command
+# fax cell hide
+
+# run:
+
+#system "/usr/bin/sqlite new.db < new.txt";
+
+
+
+
+
Modified: yapcom/trunk/lib/YAPC/Organizer.pm
===================================================================
--- yapcom/trunk/lib/YAPC/Organizer.pm 2003-12-18 13:30:13 UTC (rev 124)
+++ yapcom/trunk/lib/YAPC/Organizer.pm 2003-12-18 14:28:41 UTC (rev 125)
@@ -1,6 +1,6 @@
package YAPC::Organizer;
-our $VERSION = '0.10';
+our $VERSION = '0.11';
use strict;
use warnings;
Modified: yapcom/trunk/t/lib/YAPC/Test.pm
===================================================================
--- yapcom/trunk/t/lib/YAPC/Test.pm 2003-12-18 13:30:13 UTC (rev 124)
+++ yapcom/trunk/t/lib/YAPC/Test.pm 2003-12-18 14:28:41 UTC (rev 125)
@@ -12,6 +12,7 @@
);
@YAPC::Config::STORAGE = @{$dbs{$ENV{YAPC_TEST_DB} || 'sqlite'}};
@YAPC::Config::admins = (qw(gabor@xxx.xx.xx));
+ $YAPC::Config::enable_proposals = 1;
#$YAPC::Config::MESSAGES = 'messages';
#$YAPC::Config::ARCHIVE = 't/root/archive';
Modified: yapcom/trunk/templates/header.tmpl
===================================================================
--- yapcom/trunk/templates/header.tmpl 2003-12-18 13:30:13 UTC (rev 124)
+++ yapcom/trunk/templates/header.tmpl 2003-12-18 14:28:41 UTC (rev 125)
@@ -10,7 +10,7 @@
<title>YAPC::Israel::2004 - <TMPL_VAR NAME="title"></title>
</head>
<body>
-<h2 class="center"><TMPL_VAR NAME="title"></h2>
+<center><h2><TMPL_VAR NAME="title"></h2></center>
<table width="90%">
<tr>
<td valign="top">
Generated at 17:20 on 18 Dec 2003 by mariachi 0.52