Log of /trunk/webwork-modperl/lib/WeBWorK/DBv3.pm

---

Revision 3017 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Tue Dec 7 02:42:59 2004 UTC (8 years, 6 months ago) by sh002i
File length: 20075 byte(s)
Diff to previous 3011

ordering, normalizers, booleans, documentation. details:

* changed order of table classes so that the has_a() part of a
  relationship occurs before the has_many() part.
* added WeBWorK::DBv3::NormalizerMixin, simiar to Class::Trigger, to
  manage normalizer subroutines for per-column normalization.
* overloaded normalize_column_values to all normalizers for changed
  fields.
* implemented predefined has_a_boolean() normalizer definition.
* defined boolean fields in tables using has_a_boolean().
* added/clarified docs.

still to do:

* add inflators/deflators for durations
* add triggers for setting creation dates

---

Revision 3011 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Thu Nov 25 05:50:01 2004 UTC (8 years, 6 months ago) by sh002i
File length: 14029 byte(s)
Diff to previous 3010

a few things.

* added lock/unlock tables
* stopped using Class::DBI::MySQL and Class::DBI::AutoLoader
* init() routine allows runtime settings
* LOCK/UNLOCK TABLES wrapper
* inflation/deflation for role.privs (done manually with &priv_list
since you have to associate a column with a class to use has_a, and I
just want it to be a damn list!)
* a tiny bit more testing

---

Revision 3010 - (view) (download) (as text) (annotate) - [select for diffs]
Added Tue Nov 23 02:50:13 2004 UTC (8 years, 6 months ago) by sh002i
File length: 8190 byte(s)

preliminary WWDBv3 support.

Features:

* automatic schema updating (see WeBWorK::DBv3::Utils).
* basic table structure constructed by set_up_table().
* has_a/has_many relationships declared explicitly.
* works!

Limitations:

* uses Class::DBI::mysql explicitly. Needs to use BaseDSN instead.
* connection information is currently hardcoded into DBv3.pm. It needs
to be brought in at compile time, so there are constraints on how this
can be done.
* no wrappers for LOCK/UNLOCK TABLES yet.
* no inflating/deflating for dates, comma separated lists, etc. yet.
* basically no testing.