my $query = 'select event.* from event where sid = 1 order by timestamp desc, event.sid desc, event.cid desc';

    	my $sth = MyClass::db_Main->prepare( $query );
        $sth->execute;

        my @events;
        #
        # Fetch and construct each object
        #
        while (my $row = $sth->fetchrow_hashref()) {
  
            push(@events, MyClass::Event->construct($row));

        }
        #
        # Process these objects 
        #
        foreach my $event (@events) {

            my $signature = $event->signature;
            print "Signature Name=".$signature->sig_name."\n";

            ## whatever ....

        }