man Tangram::FlatHash () - map Perl hash of scalar keys and values

NAME

Tangram::FlatHash - map Perl hash of scalar keys and values

SYNOPSIS

   use Tangram::Core;
   use Tangram::FlatHash; # always


   $schema = Tangram::Schema->new(
      classes => { NaturalPerson => { fields => {


      flat_hash =>
      {
         opinions =>
         {
            table => 'NP_ops',
            key_sql => 'VARCHAR(1)',
            type => 'int',
            sql => 'NUMERIC(1)',
         },


         lucky_numbers => 'int', # use defaults
      }

DESCRIPTION

Maps references to a Perl hash. The persistent fields are grouped in a hash under the CWflat_hash key in the field hash.

The hash may contain as keys and values only 'simple' scalars like integers, strings or real numbers. It may not contain references. For hashs of objects, see Tangram::Hash and Tangram::IntrHash.

Tangram uses a table to save the state of the collection. The table has three columns, which contain

* the id of the container object
* the key of the element in the hash
* the value of the element

The field names are passed in a hash that associates a field name with a field descriptor. The field descriptor may be either a hash or a string. The hash uses the following fields:

* key_type
* key_sql
* type
* sql
* table

The optional fields CWkey_type and CWtype specify the key and value types of the hash. If the type is CWstring Tangram quotes the values as they are passed to the database. Not specifying a CWtype is exactly equivalent to specifying CWstring.

Optional field CWtable sets the name of the table that contains the elements. This defaults to 'C_F', where C is the class of the containing object and F is the field name.

The optional fields CWkey_sql and CWsql specify the type that deploy() (see Tangram::Deploy) should use for the column containing the key and value of the hash. If this field is not present, the SQL type is derived from the CWtype field: if CWtype is CWstring (or is absent) VARCHAR(2) is used; otherwise, the CWtype field is interpreted as a SQL type.

If the descriptor is a string, it is interpreted as the value of the CWtype field and all the other fields take the default value.

AUTHOR

This mapping was contributed by Gabor Herr <herr@iti.informatik.tu-darmstadt.de>