Log of /trunk/webwork2/bin/wwdb_upgrade
Parent Directory
Revision
5151 -
(
view)
(
download)
(
annotate)
-
[select for diffs]
Modified
Thu Jul 12 00:52:51 2007 UTC (5 years, 10 months ago) by
sh002i
File length: 28479 byte(s)
Diff to
previous 5129
,
to
selected 4530
second pass -- now working. this script doesn't support upgrading
courses that were archived before per-course version tracking was
implemented, so you'll have to upgrade to the current version (24)
before archiving/unarchiving courses.
Revision
5129 -
(
view)
(
download)
(
annotate)
-
[select for diffs]
Modified
Fri Jul 6 23:36:59 2007 UTC (5 years, 10 months ago) by
sh002i
File length: 25109 byte(s)
Diff to
previous 4923
,
to
selected 4530
steps to adding per-course database upgrades -- doesn't work yet, don't use.
i just wanted to get it in the cvs repo before the weekend.
Revision
4923 -
(
view)
(
download)
(
annotate)
-
[select for diffs]
Modified
Wed Apr 4 15:06:01 2007 UTC (6 years, 1 month ago) by
glarose
File length: 19100 byte(s)
Diff to
previous 4918
,
to
selected 4530
Add set-level proctor login password for proctored gateway/quiz
assignments, improve handling of proctor keys and permissions for
proctored assignments, bug fixes for recently added features.
This commit
- adds the ability to specify a set-level proctor for proctored
gateway/quiz assignments. this is done by adding a proctor with
a username "set_id:setName", where "setName" is the name of the
set, adding a "restricted_login_proctor" field to the set tables
in the database, and allowing Authen::Proctor and
ContentGenerator::LoginProctor to appropriately deal with this
possibility.
- updates proctor permissions and status in global.conf.dist,
changing the old "proctor_quiz" permission level (3) into two
levels, "proctor_quiz_login" and "proctor_quiz_grade".
wwdb_upgrade includes a stanza to make this change to proctors
that already exist in courses.
- adds a "Proctor" status in %statuses in global.conf, with no
valid behaviors. this allows the creation of proctor users
in a course who have the permissionLevel to login (and thus
proctor), but not to access the course.
- improves GatewayQuiz explanatory messages when scores or work
are hidden.
- improves GatewayQuiz proctor key management, especially for
tests with more than one allowed attempt. this includes
adding a deleteAllProctorKeys() method to DB.pm.
- updates Instructor Tools, UserList.pm and ProblemSetDetail
to deal with set-level proctoring. c.f. the note below about
the ramifications of these changes.
- updates ProblemSetList to deal with new problem set fields
set_locations and set-level proctors that are located in a
different database table than the set data.
- fixes bugs in UserList and ProblemSetDetail dealing with the
setting of hide_score, hide_score_by_problem, and
time_limit_cap.
This update hides set-level proctor users from the classlist
editor (UserList.pm) and instructor tools (Index.pm) interfaces.
They can be created, modified, and deleted at the homework sets
editor page (ProblemSetDetail.pm) only, and there only implicitly:
we never indicate that a user is being created or modified behind
the screen.
Revision
4918 -
(
view)
(
download)
(
annotate)
-
[select for diffs]
Modified
Fri Mar 30 19:07:55 2007 UTC (6 years, 1 month ago) by
glarose
File length: 18421 byte(s)
Diff to
previous 4904
,
to
selected 4530
Some bugfixes, preliminary commit of relax_restrict_ip function. this
commit
- adds relax_restrict_ip and hide_score_by_problem columns to the set
and set_user tables
- adds the corresponding fields to the Set and UserSet DB Records
- patches 'no location' handling in the location management routine
in CourseAdmin.pm
- improves Authz->checkSet's handling of the case of location
restriction when no addresses exist for a location, makes it
use any cached set that may be available, and makes it honor
relax_restrict_ip
- corrects a typo and some comments in DB.pm
- allows ip restriction fields in ProblemSetList when importing from
or exporting to set definition files
- updates ProblemSetDetail.pm to handle the relax_restrict_ip field
The relax_restrict_ip function has not been well tested.
hide_score_by_problem isn't yet used.
Revision
4904 -
(
view)
(
download)
(
annotate)
-
[select for diffs]
Modified
Tue Mar 27 17:04:02 2007 UTC (6 years, 1 month ago) by
glarose
File length: 17666 byte(s)
Diff to
previous 4869
,
to
selected 4530
Preliminary commit of code to restrict access to assignments by client
IP address. This commit adds the database tables for IP address
restriction, updates check_modules.pl to require Net::IP for address
matching, adds database calls in DB.pm for manipulating locations and
addresses, and adds location restriction to the set editing in
ProblemSetDetail.
This commit does not add actual restriction to sets, nor the ability
to create locations to which to restrict access.
Revision
4869 -
(
view)
(
download)
(
annotate)
-
[select for diffs]
Modified
Tue Mar 13 15:38:23 2007 UTC (6 years, 2 months ago) by
glarose
File length: 16010 byte(s)
Diff to
previous 4863
,
to
selected 4530
Update stanzas for modifying hide_score and hide_work columns in set
and set_user to have more intelligible names, and add a default value.
Revision
4543 -
(
view)
(
download)
(
annotate)
-
[select for diffs]
Modified
Mon Oct 2 16:32:51 2006 UTC (6 years, 7 months ago) by
sh002i
File length: 13546 byte(s)
Diff to
previous 4542
,
to
selected 4530
fixes to index structure.
* the prefix lengths on keyfield indexes is now 255, the length of the field.
* the index that contains all three keyfields is now a UNIQUE KEY
* psvn is no longer the PRIMARY KEY, now a UNIQUE KEY (and it's the
second UNIQUE KEY, after the user_id/set_id one)
also, made wwdb_upgrade a little easier to maintain by not hardcoding
version numbers into the @DB_VERSIONS structure.
Revision
4542 -
(
view)
(
download)
(
annotate)
-
[select for diffs]
Modified
Mon Oct 2 15:05:14 2006 UTC (6 years, 7 months ago) by
sh002i
File length: 9761 byte(s)
Diff to
previous 4530
alphanumeric keyfields TINYBLOB NOT NULL instead of BLOB for UNIQUE indexing.
check for table existence before doing something with that table.
Revision
4530 -
(
view)
(
download)
(
annotate)
-
[selected]
Modified
Thu Sep 28 23:42:32 2006 UTC (6 years, 7 months ago) by
sh002i
File length: 7874 byte(s)
Diff to
previous 4529
incorrectly set type of set_user.status column to INT; should be FLOAT.
if you ran wwdb_upgrade after the last commit, you lost the decimal
portions of any status values. thanks to gavin for noticing.
Revision
4370 -
(
view)
(
download)
(
annotate)
-
[select for diffs]
Modified
Sat Aug 12 15:44:03 2006 UTC (6 years, 9 months ago) by
sh002i
File length: 7347 byte(s)
Diff to
previous 4365
,
to
selected 4530
don't need separate code for initilization -- we can just set db_version
to 0 and run through all the upgrade steps normally. since there are no
courses, only the global updates will run, which is fine.
Revision
4365 -
(
view)
(
download)
(
annotate)
-
[select for diffs]
Added
Fri Aug 11 18:47:21 2006 UTC (6 years, 9 months ago) by
sh002i
File length: 7761 byte(s)
Diff
to
selected 4530
this script uses a db_version value to run upgrade code to incrementally
bring the database up-to-date with the current version of webwork. it
can also detect and empty database and initialize it with any system
(non-course) tables (like the depths table) and initilize an up-to-date
db_version value.
This form allows you to request diffs between any two revisions of this file.
For each of the two "sides" of the diff,
enter a numeric revision.
