View on
MetaCPAN is shutting down
For details read Perl NOC. After June 25th this page will redirect to
Jim Schueler > NoSQL-PL2SQL > NoSQL::PL2SQL::Perldata



Annotate this POD


New  1
Open  1
View/Report Bugs
Module Version: 0.03   Source  


NoSQL::PL2SQL::Perldata - Private Perl extension for NoSQL::PL2SQL


The NoSQL::PL2SQL::Perldata package is private. None of its functions are part of the public interface.

  use NoSQL::PL2SQL::Perldata ;

  $perldata = $db->perldata( $SQL_SELECT_STATEMENT ) ;
  ## $perldata == $tied->{perldata} 
  ## where $tied is any NoSQL::PL2SQL::Object

  %children = fetchextract( $tied, $refto, 'textkey' )
  %children = fetchextract( $tied, $refto, 'intkey' ) ;

An object that implements NoSQL::PL2SQL is always represented as a tree. All of PL2SQL's operations consider a object member as a tree node. In most cases, the nodes are NoSQL::PL2SQL::Object's. Before being written to the RDB, the nodes are NoSQL::PL2SQL::Node's. Perldata is yet another way of representing the data as a tree of nodes.

"perldata" specifically refers to a member of an Object instantiation. This member is a hash reference containing copies of the underlying RDB records. By using Perldata functions, Object nodes can access the entire tree framework.

For example, when container Object nodes are loaded, fetchextract() is used to create the child nodes. The $tied argument is a NoSQL::PL2SQL::Object that represents a container node. $refto is the pointer to the child list. 'textkey' is used for hash containers and 'intkey' is used for array containers. The 'intkey' and 'textkey' values are embedded within the Perldata and returned as the keys in the output; empty NoSQL::PL2SQL::Object objects are returned as the values.

  $recno = lastitem( $perldata, $refto ) ;

The lastitem() function is used to maintain linked lists. The record number identifying the list head is passed, and the record number of the final element is returned.

  @recnos = descendants( $perldata, $recno, $nosiblings = 1 ) ;
  pop @recnos ;
  @recnos = descendants( $perldata, $refto ) ;

The descendants() function is used to anticipate orphaned records when the overloaded CLEAR function is called on a NoSQL::PL2SQL::Object node. $recno is always returned as the last element. The first approach should be used if $recno refers to a parent container, the second if $refto refers to a child node.

  $array = item( $perldata, $recno ) ;
  $array = item( $perldata, $perldata->{$recno} ) ;

$perldata->{$recno} refers to a set of nvp's that contain the RDB table record. The item() function returns two elements that represent the underlying value of that record: The first refers to the datatype determined by XML::Dumper::pl2xml: 'hashref', 'arrayref', 'item', 'scalarref', or 'scalar'. 'hashref' and 'arrayref' are container type nodes, and the others are scalars. The second returned element is the actual value, which is meaningless for container types.


The NoSQL::PL2SQL::Perldata object is the raw data from the RDB table.

An object that implements NoSQL::PL2SQL starts out as a set of related records in an RDB table. When the object is loaded, these records are read into a NoSQL::PL2SQL::Perldata data structure; and the top node is returned as a tied NoSQL::PL2SQL::Object. Gradually, a tree of NoSQL::PL2SQL::Objects is built up as elements of the object are accessed; using data from the underlying NoSQL::PL2SQL::Perldata object.

As of v1.0, all of the RDB table records are slurped at once, and stored in this NoSQL::PL2SQL::Perldata object. The name perldata refers to the reftype that XML::Dumper::pl2xml assigns to the top node. Since the resulting object is always maintained in this tree structure accessible through the top node, the name perldata has poetic significance.

Each NoSQL::PL2SQL::Object element contains a reference to a common Perldata member to access the RDB table data. Many NoSQL::PL2SQL::Object methods are applied by traversing the child and/or sibling nodes in this data set instead of relying on the NoSQL::PL2SQL::Object tree.

As of v1.0, the data set is never actually blessed, based on a decision that now seems rather silly.


None by default.



Original version; created by h2xs 1.23 with options


Cleaned perldoc formatting issues


lastitem() returns an nvp




Jim Schueler, <>


Copyright (C) 2012 by Jim Schueler

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.8.9 or, at your option, any later version of Perl 5 you may have available.

syntax highlighting: