[system] / branches / rel-2-0-patches / webwork-modperl / lib / WeBWorK / DB / Driver / SQL.pm Repository:
ViewVC logotype

Log of /branches/rel-2-0-patches/webwork-modperl/lib/WeBWorK/DB/Driver/SQL.pm

Parent Directory Parent Directory


Links to HEAD: (view) (download) (as text) (annotate)
Sticky Revision:

Revision 2721 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Thu Sep 2 21:27:59 2004 UTC (8 years, 9 months ago) by sh002i
File length: 2873 byte(s)
Diff to previous 2523
HEAD merge: docs

Revision 2523 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Fri Jul 16 18:34:48 2004 UTC (8 years, 11 months ago) by
File length: 2456 byte(s)
Diff to previous 1663
This commit was manufactured by cvs2svn to create branch 'rel-2-0-patches'.

Revision 1663 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Tue Dec 9 01:12:32 2003 UTC (9 years, 6 months ago) by sh002i
Original Path: trunk/webwork-modperl/lib/WeBWorK/DB/Driver/SQL.pm
File length: 2456 byte(s)
Diff to previous 1167
Normalized headers. All files now contain the text below as a header.
This is important since all files now (a) use the full name of the
package, (b) assign copyright to "The WeBWorK Project", (c) give the
full path of the file (relative to CVSROOT) instead of simply the file
name, and (d) include license and warranty information.

Here is the new header:

################################################################################
# WeBWorK Online Homework Delivery System
# Copyright © 2000-2003 The WeBWorK Projcct, http://openwebwork.sf.net/
# $CVSHeader$
#
# This program is free software; you can redistribute it and/or modify it under
# the terms of either: (a) the GNU General Public License as published by the
# Free Software Foundation; either version 2, or (at your option) any later
# version, or (b) the "Artistic License" which comes with this package.
#
# This program is distributed in the hope that it will be useful, but WITHOUT
# ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
# FOR A PARTICULAR PURPOSE.  See either the GNU General Public License or the
# Artistic License for more details.
################################################################################

Revision 1167 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Fri Jun 13 23:35:54 2003 UTC (10 years ago) by sh002i
Original Path: trunk/webwork-modperl/lib/WeBWorK/DB/Driver/SQL.pm
File length: 1799 byte(s)
Diff to previous 931
Several changes to the DB system:

Made all schemas subclasses of WeBWorK::DB::Schema, factored common
constructor code out into Schema.pm. Made all drivers subclasses of
WeBWorK::DB::Schema, factored common constructor code out into
Driver.pm.

Removed superfluous style() and tables() functions from schemas and
drivers. (You can treat the constants in which these are defined as
functions, and call them like $object->STYLE or $object->STYLE().)

WeBWorK::DB now tries to build all tables defined in %dbLayout, instead
of using its own internal list. (TODO: add warnings if known tables are
not built or unknown tables are built.)

Made the error messages given during DB instantiation a little more
intelligent.

Changed the behavior of the exists() and delete() schema methods in all
schemas (and updated the docs) s.t. not all elements of @keyparts have
to be defined.

Changed WeBWorK::DB to allow undefined values to be passed instead of
IDs in delete* method calls, but only if the call was made from
WeBWorK::DB itself (to protect you from accidentally passing an
undefined value and clobbering your whole database).

Changed delete functions to be more efficient. For example,
deleteGlobalSet no longer has to say:

	$self->deleteUserSet($_, $setID)
		foreach $self->listSetUsers($setID);
	$self->deleteGlobalProblem($setID, $_)
		foreach $self->listGlobalProblems($setID);

Instead it says:

	$self->deleteUserSet(undef, $setID);
	$self->deleteGlobalProblem($setID, undef);

This is somewhat more efficient with hash-style schemas, and MUCH more
efficient with the SQL schema.

As usual, be wary of lingering bugs. w00t!
-sam

Revision 931 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Wed May 28 19:21:04 2003 UTC (10 years ago) by sh002i
Original Path: trunk/webwork-modperl/lib/WeBWorK/DB/Driver/SQL.pm
File length: 2004 byte(s)
Diff to previous 904
changed the Schema interface (to include a reference to $db) and changed
DBI connect to connect_cached.
-sam

Revision 904 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Mon May 26 22:13:34 2003 UTC (10 years ago) by sh002i
Original Path: trunk/webwork-modperl/lib/WeBWorK/DB/Driver/SQL.pm
File length: 1990 byte(s)
Diff to previous 874
More SQL work. Appears to be working, after very limited testing. See
forthcoming email for details.
-sam

Revision 874 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Tue May 20 23:08:03 2003 UTC (10 years, 1 month ago) by sh002i
Original Path: trunk/webwork-modperl/lib/WeBWorK/DB/Driver/SQL.pm
File length: 1980 byte(s)
Diff to previous 841
initial work on SQL backend. untested.
-sam

Revision 841 - (view) (download) (as text) (annotate) - [select for diffs]
Added Thu May 15 00:56:27 2003 UTC (10 years, 1 month ago) by sh002i
Original Path: trunk/webwork-modperl/lib/WeBWorK/DB/Driver/SQL.pm
File length: 1748 byte(s)
added SQL.pm driver module.
-sam

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.

  Diffs between and
  Type of Diff should be a

Sort log by:

aubreyja at gmail dot com
ViewVC Help
Powered by ViewVC 1.0.9