/[cvs]/nfo/perl/libs/Data/Storage/Handler/Tangram.pm
ViewVC logotype

Contents of /nfo/perl/libs/Data/Storage/Handler/Tangram.pm

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.19 - (show annotations)
Mon Dec 16 06:46:09 2002 UTC (21 years, 6 months ago) by joko
Branch: MAIN
Changes since 1.18: +22 -1 lines
+ attempt to introduce a generic '_patchSchema' - cancelled!

1 ############################################
2 #
3 # $Id: Tangram.pm,v 1.18 2002/12/13 21:48:07 joko Exp $
4 #
5 # $Log: Tangram.pm,v $
6 # Revision 1.18 2002/12/13 21:48:07 joko
7 # + fix to 'sub sendQuery'
8 #
9 # Revision 1.17 2002/12/12 02:51:09 joko
10 # + cosmetics
11 #
12 # Revision 1.16 2002/12/11 06:54:10 joko
13 # + fix: encapsulated object-loading inside an 'eval'
14 #
15 # Revision 1.15 2002/12/05 13:55:21 joko
16 # + now utilizing 'object2hash' instead of 'var_deref'
17 # + played around with having fresh-objects - no progress....
18 #
19 # Revision 1.14 2002/12/05 09:40:30 jonen
20 # + added option->{destroy} at getObject for unloading all instance
21 #
22 # Revision 1.13 2002/12/05 07:59:04 joko
23 # + now using Tie::SecureHash as a base for the COREHANDLE
24 # + former public COREHANDLE becomes private _COREHANDLE now
25 # + sub getCOREHANDLE
26 #
27 # Revision 1.12 2002/12/04 11:34:49 joko
28 # - $schema_tangram doesn't have to be in class?
29 #
30 # Revision 1.11 2002/12/04 08:54:08 jonen
31 # + untested bugfix: undef($object) after transform to hash at getObjectAsHash
32 #
33 # Revision 1.10 2002/12/03 15:53:23 joko
34 # + small bugfix regarding object hierarchy
35 #
36 # Revision 1.9 2002/12/03 05:29:40 joko
37 # + sub getObject
38 # + sub getObjectAsHash
39 #
40 # Revision 1.8 2002/12/01 22:25:51 joko
41 # + now utilizing metadata from storage locator when connecting to DBI in "raw"-mode
42 #
43 # Revision 1.7 2002/12/01 04:46:19 joko
44 # + sub eraseAll
45 #
46 # Revision 1.6 2002/11/29 05:02:30 joko
47 # - sub getNewPerlObjectByPkgName (moved to libp.pm)
48 # + sub getMetaInfo
49 # - sub existsChildNode (moved to Abstract.pm)
50 # + sub getListUnfiltered
51 # + sub getListFiltered
52 # + sub createCursor
53 # + sub createSet
54 # + sub sendQuery
55 #
56 # Revision 1.5 2002/11/17 06:35:18 joko
57 # + locator metadata can now be reached via ->{locator}
58 # - getChildNodes is now wrapped via COREHANDLE
59 #
60 # Revision 1.4 2002/10/25 11:44:44 joko
61 # + sub _initSchema
62 # + sub existsChildNode
63 # + sub testIntegrity
64 # + sub rebuildDbAndSchema
65 #
66 # Revision 1.3 2002/10/17 03:56:55 joko
67 # + bugfix: trapped eval error
68 #
69 # Revision 1.2 2002/10/17 00:10:05 joko
70 # + removed dependency from tsobj.pm, schema is now independent
71 # + sub getNewPerlObjectByPkgName
72 # + sub deploySchema
73 # + sub retreatSchema
74 #
75 # Revision 1.1 2002/10/10 03:44:07 cvsjoko
76 # + new
77 #
78 ############################################
79
80
81 package Data::Storage::Handler::Tangram;
82
83 use strict;
84 use warnings;
85
86 use base ("Data::Storage::Handler");
87 use base ("Data::Storage::Handler::Abstract");
88
89 use Tangram;
90 use Data::Dumper;
91 use libp qw( getNewPerlObjectByPkgName );
92 use Data::Storage::Result::Tangram;
93 use Data::Compare::Struct qw( isEmpty );
94 use Data::Transform::Deep qw( object2hash );
95 use Data::Transform::Encode qw( var2utf8 );
96
97
98 # get logger instance
99 my $logger = Log::Dispatch::Config->instance;
100
101
102 # this holds the complete instantiated schema from tangram
103 my $schema_tangram;
104
105 sub getMetaInfo {
106 my $self = shift;
107 $logger->debug( __PACKAGE__ . "->getMetaInfo()" );
108 return {
109 'disconnectMethod' => 'disconnect',
110 };
111 }
112
113 sub _initSchema {
114 my $self = shift;
115 $logger->debug( __PACKAGE__ . "->_initSchema()" );
116 #if (!$schema_tangram) {
117 my $obj = getNewPerlObjectByPkgName($self->{locator}->{schema}, { EXPORT_OBJECTS => $self->{locator}->{classnames}, want_transactions => $self->{locator}->{want_transactions} } );
118 $schema_tangram = $obj->getSchema();
119 #}
120 if (!$schema_tangram) {
121 $logger->error( __PACKAGE__ . "->_initSchema: No Schema available for $self->{schema}" );
122 return 0;
123 }
124 #$self->_patchSchema();
125 return 1;
126 }
127
128 sub _patchSchema {
129 my $self = shift;
130 foreach (keys %{$schema_tangram->{classes}}) {
131 next if $schema_tangram->{classes}->{$_}->{abstract};
132 #next if ($_ ne 'TsBankAccount');
133 #$_ ne 'AbstractAccount' &&
134 print "class: $_", "\n";
135 #print Dumper($schema_tangram->{classes}->{$_});
136 # create new string property named 'guid'
137 my $tstring = Tangram::String->new();
138 $tstring->{name} = $tstring->{col} = 'guid';
139 # inject property into schema
140 #$schema_tangram->{classes}->{$_}->{root}->{SPECS}->[0]->{fields}->{string}->{$tstring->{name}} = $tstring;
141 print Dumper($schema_tangram->{classes}->{$_}->{root}->{SPECS}->[0]->{fields});
142 }
143 }
144
145 sub connect {
146
147 my $self = shift;
148
149 my $dsn = shift;
150 $dsn ||= $self->{locator}->{dbi}->{dsn};
151
152 $logger->debug( __PACKAGE__ . "->connect( dsn $dsn )" );
153
154 #my $storage = Tangram::Relational->connect( $schema, $dsn );
155 #my $storage = Tangram::mysql->connect( $schema, $dsn );
156 #$storage = Tangram::Relational->connect( Project->schema, $dsn );
157
158 # if (!testDsn($dsn)) {
159 # croak("Database at \"$dsn\" is not available");
160 # return;
161 # }
162
163 return unless $self->_initSchema();
164
165 # create the main tangram storage object
166 #$self->{COREHANDLE} = Tangram::Relational->connect( $schema, $dsn );
167 $self->{_COREHANDLE} = Tangram::Relational->connect( $schema_tangram, $dsn );
168
169 #print "connect", "\n";
170 #my $core = $self->{_COREHANDLE};
171 #print Dumper($core);
172
173 # some attempts for configuring the wrapped underlying dbi.....
174 #$self->{STORAGEHANDLE_UNDERLYING} = $self->getUnderlyingStorage();
175 #$self->{STORAGEHANDLE_UNDERLYING}->_configureCOREHANDLE();
176 #$self->_configureUnderlyingStorage;
177
178 # ..... encapsulation wins!
179 $self->configureCOREHANDLE();
180
181 $self->{locator}->{status}->{connected} = 1;
182
183 return 1;
184
185 }
186
187 sub getChildNodes {
188
189 my $self = shift;
190 my @nodes;
191
192 $logger->debug( __PACKAGE__ . "->getChildNodes()" );
193
194 # create new DBI - Data::Storage - object from already connected DBI::db - handle inside the current COREHANDLE
195 #my $loc = new Data::Storage::Locator( type => "DBI", dbi => { db => $self->{COREHANDLE}->{db} });
196 #my $loc = new Data::Storage::Locator( type => "DBI", COREHANDLE => $self->{COREHANDLE}->{db} );
197
198 # todo: should we retrieve information from the schema here
199 # rather than poorly getting table names from underlying dbi?
200 my $storage = $self->_getSubLayerHandle();
201 @nodes = @{$storage->getChildNodes()};
202 #$storage->_configureCOREHANDLE();
203 #print "getchildnodes\n";
204 #print Dumper($self);
205 #if (my $result = $self->sendCommand( 'SHOW TABLES;' ) ) {
206
207 # TODO: REVIEW
208 #$storage->disconnect();
209
210 $self->{meta}->{childnodes} = \@nodes;
211
212 return \@nodes;
213
214 }
215
216
217 sub testIntegrity {
218
219 my $self = shift;
220
221 $logger->debug( __PACKAGE__ . "->testIntegrity()" );
222
223 # 1st test: are there tables?
224 if (!$self->getChildNodes()) {
225 $logger->warning( __PACKAGE__ . "->testIntegrity no childnodes exist" );
226 return;
227 }
228
229 # 2nd test: is there a table named "Tangram"?
230 if (!$self->existsChildNode("Tangram")) {
231 $logger->warning( __PACKAGE__ . "->testIntegrity childnode \"Tangram\" doesn't exist" );
232 return;
233 }
234
235 $self->{locator}->{status}->{integrity} = 1;
236 return 1;
237
238 }
239
240
241 sub _getSubLayerHandle {
242
243 my $self = shift;
244
245 $logger->debug( __PACKAGE__ . "->_getSubLayerHandle()" );
246
247 #print Dumper($self);
248
249 # hack, make more generic!
250 if (!$self->{dataStorageLayer}) {
251 $logger->debug( __PACKAGE__ . "->_getSubLayerHandle() creating new dataStorageLayer" );
252 #my $loc = Data::Storage::Locator->new( type => "DBI", dbi => $self->{dbi}, COREHANDLE => $self->{COREHANDLE}->{db} );
253 my $loc = Data::Storage::Locator->new( { type => "DBI", dbi => $self->{locator}->{dbi} } );
254 $self->{dataStorageLayer} = Data::Storage->new( $loc, { protected => 1 } );
255 #$self->{STORAGE_UNDER_THE_HOOD}->{STORAGEHANDLE}->_configureCOREHANDLE();
256 #$self->{STORAGE_UNDER_THE_HOOD}->_configureCOREHANDLE();
257 }
258
259 #print Dumper($self->{STORAGE_UNDER_THE_HOOD});
260
261 return $self->{dataStorageLayer};
262
263 }
264
265 sub _configureUnderlyingStorage {
266
267 my $self = shift;
268
269 $logger->debug( __PACKAGE__ . "->_configureUnderlyingStorage" );
270
271 $self->_configureCOREHANDLE_DBI();
272 return;
273
274 foreach my $key (keys %{$self->{dbi}}) {
275 my $val = $self->{dbi}->{$key};
276 print "entry: $key; $val", "\n";
277 $self->{_COREHANDLE}->{db}->{$key} = $val;
278 }
279 #print Dumper($self->{COREHANDLE}->{db});
280 }
281
282
283 sub configureCOREHANDLE {
284
285 my $self = shift;
286
287 $logger->debug( __PACKAGE__ . "->configureCOREHANDLE" );
288
289 #my $subLayer = $self->_getSubLayerHandle();
290
291 # apply configured modifications
292 if (exists $self->{dbi}->{trace_level} && exists $self->{dbi}->{trace_file}) {
293 $self->{_COREHANDLE}->{db}->trace($self->{dbi}->{trace_level}, $self->{dbi}->{trace_file});
294 }
295 if (exists $self->{dbi}->{RaiseError}) {
296 $self->{_COREHANDLE}->{db}->{RaiseError} = $self->{dbi}->{RaiseError};
297 }
298 if (exists $self->{dbi}->{PrintError}) {
299 $self->{_COREHANDLE}->{db}->{PrintError} = $self->{dbi}->{PrintError};
300 }
301 if (exists $self->{dbi}->{HandleError}) {
302 $self->{_COREHANDLE}->{db}->{HandleError} = $self->{dbi}->{HandleError};
303 }
304
305 }
306
307 sub deploySchema {
308 my $self = shift;
309 my $args = shift;
310
311 my $dsn = $self->{locator}->{dbi}->{dsn};
312
313 $logger->debug( __PACKAGE__ . "->deploySchema( dsn $dsn )" );
314
315 my $ok;
316 if ( my $dbh = DBI->connect($dsn, '', '', $self->{locator}->{dbi} ) ) {
317 return unless $self->_initSchema();
318 $ok = Tangram::Relational->deploy($schema_tangram, $dbh );
319 $dbh->disconnect();
320 }
321 return $ok;
322 }
323
324 sub retreatSchema {
325
326 my $self = shift;
327 my $dsn = $self->{locator}->{dbi}->{dsn};
328
329 $logger->debug( __PACKAGE__ . "->retreatSchema( dsn $dsn )" );
330
331 my $ok;
332 if ( my $dbh = DBI->connect($dsn, '', '', $self->{locator}->{dbi} ) ) {
333
334 return unless $self->_initSchema();
335
336 #use Data::Dumper; print Dumper($self);
337 $self->{dataStorageLayer}->removeLogDispatchHandler("Tangram11");
338
339 $ok = Tangram::Relational->retreat($schema_tangram, $dbh );
340
341 # answer "$ok=2" means "maybe" for now - we have to patch this to a constant here because...
342 # - ... Tangram::Relational->retreat doesn't seem to return a valid status
343 # - possible improvement:
344 # - test this by checking for count of tables in database
345 # - problem with this: there may be some left not having been included to the schema
346 # - maybe better: use "->getChildNodes"?
347 $ok = 2;
348
349 $dbh->disconnect();
350
351 }
352 return $ok;
353 }
354
355 sub rebuildDbAndSchema {
356 my $self = shift;
357 $logger->info( __PACKAGE__ . "->rebuildDbAndSchema()" );
358 my @results;
359
360 # sum up results (bool (0/1)) in array
361 push @results, $self->retreatSchema();
362 push @results, $self->{dataStorageLayer}->dropDb();
363 push @results, $self->{dataStorageLayer}->createDb();
364 push @results, $self->deploySchema();
365
366 # scan array for "bad ones"
367 my $res = 1;
368 map {
369 $res = 0 if (!$_);
370 } @results;
371
372 return $res;
373 }
374
375 sub getListUnfiltered {
376 my $self = shift;
377 my $nodename = shift;
378 my @results;
379 $logger->debug( __PACKAGE__ . "->getListUnfiltered( nodename => '" . $nodename . "' )" );
380 # get set of objects from odbms by object name
381 my $object_set = $self->{_COREHANDLE}->remote($nodename);
382 @results = $self->{_COREHANDLE}->select($object_set);
383 return \@results;
384 }
385
386 sub getListFiltered {
387 my $self = shift;
388
389 # redirect to unfiltered mode
390 #return $self->getListUnfiltered(@_);
391
392 my $nodename = shift;
393 my $filters = shift;
394 my @results;
395 $logger->debug( __PACKAGE__ . "->getListFiltered( nodename => '" . $nodename . "' )" );
396
397 #print Dumper($filters);
398
399 my @tfilters;
400
401 foreach my $filter (@$filters) {
402
403 # get filter - TODO: for each filter
404 #my $filter = $filters->[0];
405
406 # build filter
407 my $lexpr = $filter->{key};
408 #my $op = $filter->{op};
409 my $op = '=';
410 my $rexpr = $filter->{val};
411 my $tight = 100;
412
413 # my $tfilter = Tangram::Filter->new(
414 # expr => "t1.$lexpr $op '$rexpr'",
415 # tight => $tight,
416 # objects => $objects,
417 # );
418
419 # HACK: build eval-string (sorry) to get filtered list - please give advice here
420 push @tfilters, '$remote->{' . $filter->{key} . '}' . " $filter->{op} '$filter->{val}'";
421
422 }
423
424 my $tfilter = join(' & ', @tfilters);
425
426 # get set of objects from odbms by object name
427 my $remote = $self->{_COREHANDLE}->remote($nodename);
428
429 # was:
430 #@results = $self->{COREHANDLE}->select($object_set, $tfilter);
431
432 # is:
433 # HACK: build eval-string (sorry) to get filtered list - please give advice here
434 my $evalstring = 'return $self->{_COREHANDLE}->select($remote, ' . $tfilter . ');';
435
436 # get filtered list/set
437 @results = eval($evalstring);
438 die $@ if $@;
439
440 return \@results;
441 }
442
443 sub createCursor {
444 my $self = shift;
445 my $node = shift;
446 my $cmdHandle = $self->{_COREHANDLE}->cursor($node);
447 my $result = Data::Storage::Result::Tangram->new( RESULTHANDLE => $cmdHandle );
448 return $result;
449 }
450
451 sub createSet {
452 my $self = shift;
453 #print "-" x 80, "\n";
454 #print Dumper(@_);
455 my @objects = @_;
456 my $rh = Set::Object->new();
457 foreach (@objects) {
458 if (!isEmpty($_)) {
459 #print Dumper($_);
460 $rh->insert($_);
461 }
462 }
463 #print Dumper($rh->members());
464 my $result = Data::Storage::Result::Tangram->new( RESULTHANDLE => $rh );
465 return $result;
466 }
467
468 sub sendQuery {
469 my $self = shift;
470 my $query = shift;
471 #my $sql = "SELECT cs FROM $self->{metainfo}->{$descent}->{node} WHERE $self->{metainfo}->{$descent}->{IdentProvider}->{arg}='$self->{entry}->{source}->{ident}';";
472 #my $result = $self->{metainfo}->{$descent}->{storage}->sendCommand($sql);
473
474 #print Dumper($query);
475
476 # HACK: special case: querying by id does not translate into a common tangram query
477 # just load the object by given id(ent)
478 if ($query->{criterias}->[0]->{key} eq 'id' && $query->{criterias}->[0]->{op} eq 'eq') {
479 #print "LOAD!!!", "\n";
480 #exit;
481 #return Set::Object->new( $self->{COREHANDLE}->load($query->{criterias}->[0]->{val}) );
482 my $ident = $query->{criterias}->[0]->{val};
483 #print "load obj", "\n";
484 #return $self->createSet() if $ident == 5;
485 $self->{_COREHANDLE}->unload($ident);
486 my $object = $self->{_COREHANDLE}->load($ident);
487 #print "get id", "\n";
488 my $oid = $self->{_COREHANDLE}->id($object);
489 #print Dumper($object);
490 #print "oid: $oid", "\n";
491 return $self->createSet($object);
492 #return $self->createSet( $self->{COREHANDLE}->load('300090018') );
493 }
494
495 die("This should not be reached for now - redirect to \$self->getListFiltered() here!");
496
497 # TODO: do a common tangram query here
498
499 my @crits;
500 foreach (@{$query->{criterias}}) {
501 my $op = '';
502 $op = '=' if lc $_->{op} eq 'eq';
503 push @crits, "$_->{key}$op'$_->{val}'";
504 }
505 my $subnodes = {};
506 map { $subnodes->{$_}++ } @{$query->{subnodes}};
507 # HACK: this is hardcoded ;( expand possibilities!
508 #my $crit = join(' AND ', @crits);
509 #my $sql = hash2Sql($query->{node}, $subnodes, 'SELECT', $crit);
510 #return $self->sendCommand($sql);
511 #my $h = $self->{COREHANDLE}->remote($query->{node});
512 #my $res = $self->{COREHANDLE}->select($h, $h->{);
513 return $self->createCursor($query->{node});
514 }
515
516 sub eraseAll {
517 my $self = shift;
518 my $classname = shift;
519 my $remote = $self->{_COREHANDLE}->remote($classname);
520 my @objs = $self->{_COREHANDLE}->select($remote);
521 $self->{_COREHANDLE}->erase(@objs);
522 }
523
524 sub createDb {
525 my $self = shift;
526 my $storage = $self->_getSubLayerHandle();
527 return $storage->createDb();
528 }
529
530 sub getObject {
531 my $self = shift;
532 my $oid = shift;
533 my $options = shift;
534
535 # TODO: create a deep_unload method (currently _all_ objects are unloaded)
536 # unload($oid) will only unload object, not deep object hashes
537 $self->{_COREHANDLE}->unload() if ($options->{destroy});
538
539 # TODO: review this
540 #if (!$self->{COREHANDLE}) { return; }
541
542 # TODO: review this
543 my $object = eval('$self->{_COREHANDLE}->load($oid);');
544 print $@, "\n" if $@;
545
546 return $object if $object;
547 }
548
549 sub getObjectAsHash {
550 my $self = shift;
551 my $oid = shift;
552 my $options = shift;
553 my $obj = $self->getObject($oid, $options);
554
555 # build options (a callback to unload autovivified objects) for 'expand'
556 # TODO: use $logger to write to debug here!
557 my $cb; # = sub {};
558 =pod
559 if ($options->{destroy}) {
560 $options->{cb}->{destroy} = sub {
561 print "================ DESTROY", "\n";
562 my $object = shift;
563 #print Dumper($object);
564 $self->{_COREHANDLE}->unload($object);
565 #undef($object);
566 };
567 }
568 =cut
569
570 my $hash = object2hash($obj, $options);
571 #$options->{cb}->{destroy}->($obj);
572 #$self->{_COREHANDLE}->unload($obj);
573
574 # convert values in hash to utf8 to be ready for (e.g.) encapsulation in XML
575 # now done in object2hash
576 #var2utf8($hash) if ($options->{utf8});
577
578 # old (wrong) attempts to get rid of used instances, if requested
579 #$obj->clear_refs;
580 #$self->{COREHANDLE}->unload($obj) if($options->{destroy});
581 #$obj->DESTROY;
582 #undef($obj) if($options->{destroy});
583
584 return $hash;
585 }
586
587 sub getSchema {
588 return $schema_tangram;
589 }
590
591 sub getCOREHANDLE {
592 my $self = shift;
593 return $self->{_COREHANDLE};
594 }
595
596 1;

MailToCvsAdmin">MailToCvsAdmin
ViewVC Help
Powered by ViewVC 1.1.26 RSS 2.0 feed