Log of /trunk/webwork2/lib/WeBWorK/DBv3.pm

---

Revision 3030 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Thu Dec 16 02:30:42 2004 UTC (8 years, 5 months ago) by sh002i
File length: 27729 byte(s)
Diff to previous 3028

ordered has_many, creation date setting.

* has_explicit_order() adds a wrapper for a has_many() accessor that
sorts the returned records as per a comma-separated list field.
* creation dates are now set properly using a before_create trigger.
* also there is the beginnings of an assign_to_participants() routine.

---

Revision 3028 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Fri Dec 10 16:39:00 2004 UTC (8 years, 5 months ago) by sh002i
File length: 24547 byte(s)
Diff to previous 3026

commit test

---

Revision 3026 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Fri Dec 10 16:16:38 2004 UTC (8 years, 5 months ago) by sh002i
File length: 24480 byte(s)
Diff to previous 3024

added note (really just a commit test)

---

Revision 3024 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Fri Dec 10 16:07:57 2004 UTC (8 years, 5 months ago) by sh002i
File length: 24230 byte(s)
Diff to previous 3022

fixed name of _bool_normalizer, removed old student_id constraint

---

Revision 3022 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Thu Dec 9 23:28:35 2004 UTC (8 years, 5 months ago) by sh002i
File length: 24363 byte(s)
Diff to previous 3017

fixes, uniqueness constraints, CSV list handling

* internal subroutines now have `_' prefix.
* added uniqneness constraints (has_unique_columns)
* added has_cs_list() to declare that a column is a comma-sep. list

---

Revision 3017 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Tue Dec 7 02:42:59 2004 UTC (8 years, 5 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, 5 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.