Log of /trunk/webwork-modperl/bin/sql2sql_single

---

Revision 2955 - (view) (download) (annotate) - [select for diffs]
Modified Fri Oct 22 22:59:53 2004 UTC (8 years, 7 months ago) by sh002i
File length: 4682 byte(s)
Diff to previous 2836

POD fixes

---

Revision 2836 - (view) (download) (annotate) - [select for diffs]
Added Mon Sep 27 19:28:36 2004 UTC (8 years, 8 months ago) by sh002i
File length: 4676 byte(s)

added script to convert a course from sql to sql_single. moves sql
tables from the course's database to the database used by the sql_single
loyout. also gives instructions on how to modify the course's
course.conf file to complete the transition.

Call sql2sql_single like this, in the common case:

./sql2sql_single <course-name> webwork root <sql-root-pw>

You can easily bash script this to do mass conversions of courses:

cd /webwork/shared-courses
for course in *; do
	sql2sql_single $course webwork root <sql-root-pw>
	cd /webwork/shared-courses/$course
	sed 's/sql/sql_single/' < course.conf > course.conf.new
	mv course.conf course.conf.old
	mv course.conf.new course.conf
done

to do a subset of all courses, change the `for' line to:

for course in course1 course2 course3; do