Login or Register to Ask a Question and Join Our Community

Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

tangram::relational(3pm) [debian man page]

Tangram::Relational(3pm)				User Contributed Perl Documentation				  Tangram::Relational(3pm)

NAME

       Tangram::Relational - Orthogonal Object Persistence in Relational Databases

SYNOPSIS

	  use Tangram;

	  $schema = Tangram::Relational->schema( $hashref );

	  Tangram::Relational->deploy($schema, $dbh);

	  $storage = Tangram::Relational->connect( $schema,
	     $data_source, $username, $password );

	  $storage->disconnect();

	  Tangram::Relational->retreat($schema, $dbh);

DESCRIPTION

       This is the entry point in the vanilla object-relational persistence backend. Vendor-specific backends should be used when they exist. Cur-
       rently Mysql, Sybase and Oracle have such backends; see Tangram::mysql, Tangram::Sybase and Tangram::Oracle.

       More backends could be added in the future; they might implement persistence in XML documents, pure object databases, using C database
       libraries to bypass the need for an RDBMS, etc.

CLASS METHODS

       schema

	  $schema = Tangram::Relational->schema( $hashref );

       Returns a new Schema object. See Tangram::Schema.

       deploy

	  Tangram::Relational->deploy($schema);
	  Tangram::Relational->deploy($schema, HANDLE);
	  Tangram::Relational->deploy($schema, @dbi_args);

       Writes SQL statements for preparing a database for use with the given $schema.

       Called with a single argument, writes SQL statements to STDOUT.

       Called with two arguments, writes SQL statements to HANDLE. HANDLE may be a DBI connection handle or a file handle.

       Called with more than two arguments, passes all but the first to DBI::connect() and writes statements to the resulting DBI handle, which is
       automatically closed.

       The SQL code is only guaranteed to work on newly created databases.

       connect

	  $storage = Tangram::Relational->connect( $schema,
	     $data_source, $user, $password, \%options )

       Connects to a storage and return a handle object. Dies in case of failure.

       $schema is a Schema object describing the system of classes stored in the database.

       $data_source, $user and $password are passed directly to DBI::connect().

       \%options is a reference to a hash containing connection options. See Tangram::Storage for a description of available options.

       retreat

	  Tangram::Relational->retreat($schema);
	  Tangram::Relational->retreat($schema, HANDLE);
	  Tangram::Relational->retreat($schema, @dbi_args);

       Remove the tables created by deploy(). Only guaranteed to work against a database that was deployed using exactly the same schema.

       For an explanation of the possible argument lists, see deploy.

WRITING A VENDOR DRIVER

       Like Charles Moore (inventor of Forth) used to say, "standards are great, everybody should have one!".

       Tangram can take advantage of extensions available in some SQL dialects.

       To create a vendor-specific driver, call it "Tangram::Foo" (where "Foo" is the name of the DBI driver, as would be selected with the DBI
       connection string "dbi:Foo:"), and derive "Tangram::Relational".

       For now, the existing back-ends should be used as examples of how to extend Tangram to support different databases or utilise some of their
       more exotic features.

perl v5.8.8							    2006-03-29						  Tangram::Relational(3pm)

Check Out this Related Man Page

Tangram::Type::Hash::Scalar(3pm)			User Contributed Perl Documentation			  Tangram::Type::Hash::Scalar(3pm)

NAME

       Tangram::Type/Hash/Scalar - map Perl hash of scalar keys and values

SYNOPSIS

	  use Tangram::Core;
	  use Tangram::Type/Hash/Scalar; # always

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

	     flat_hash =>
	     {
		opinions =>
		{
		   table => 'NP_ops',
		   key_sql => 'VARCHAR(10)',
		   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 "flat_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::Type::Hash::FromMany and Tangram::Type::Hash::FromOne.

       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 "key_type" and "type" specify the key and value types of the hash. If the type is "string" Tangram quotes the values as
       they are passed to the database. Not specifying a "type" is exactly equivalent to specifying "string".

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

       The optional fields "key_sql" and "sql" 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 "type" field: if "type" is "string" (or is absent)
       VARCHAR(255) is used; otherwise, the "type" field is interpreted as a SQL type.

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

AUTHOR

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

perl v5.8.8							    2006-03-29					  Tangram::Type::Hash::Scalar(3pm)
Man Page