Re: [Bodington-developers] access log

[Matthew B. <mat...@ou...>]

Antony Corfield wrote:
> On 16 Jun 2006, at 11:14, Matthew Buckett wrote:
> 
>> Naomi Miles wrote:
>>> Is the event_code coupled with resource_id or something to give
>>> specific events?  All Event subclasses have own event(s) and they all
>>> start at 1.  I presume this is what ends up in Events table as
>>> event_code?  Or am I missing something?
>> Yep they will.
>>
>> The event_code relates to the class. Because the Bodington database
>> layer will give you back a AssessmentEvent or LogBookEvent the
>> enumeration of event_codes is local to the event subclass.
 >
> True, so public static Event findEvent( String where ) etc. will return 
> Events for that sub class and casting will identify event_codes for 
> that type. But what if we use JDBC to query events table - we don't 
> have object info?

You have to join to the objects and classes table then you can find out.

Using JDBC with prepareQuery/ResultSet is what PersistentObject was 
designed to hide, why are you wanting to go around it?

-- 
  -- Matthew Buckett, VLE Developer
  -- Learning Technologies Group, Oxford University Computing Services
  -- Tel: +44 (0)1865 283660 http://www.oucs.ox.ac.uk/ltg/