Persistence::Database::SQL Object Persistence in SQL Databases.
Download

Persistence::Database::SQL Ranking & Summary

Persistence::Database::SQL Tags

SQL Perl module object persistence SQL database object persistence

Persistence::Database::SQL Description

Object Persistence in SQL Databases. Persistence::Database::SQL is a Perl module that can be used as an object persistence in SQL databases.SYNOPSIS use Persistence::Database::SQL; my $db = new Persistence::Database::SQL ( Engine => 'Postgres', Database => $database_name, Table => $table_name, Template => $template_hashref ); my (@objects) = $db->search ( Key => $key, Regex => $regex ); for $obj (@objects) { $db->table('expired'); $obj->commit(); $db->table($table_name); $obj->expire(); } my $dbhandle = $db->dbhandle(); my $query = "SELECT oid,* FROM $table_name WHERE $field=$value"; my $sth = $dbhandle->prepare($query); $sth->execute(); while (@row = $sth->fetchrow()) { my $obj = new Persistence::Object::Postgres ( __Dope => $db, __Oid => $row ); $obj->expire(); }This module provides a store of persistent objects using various DBMS engines. It works in association with a lower level persistent object implementation, such as Persistence::Object::Postgres.Using a template mapping object properties to PostgreSQL class fields, it is possible to automatically generate DBMS fields out of the object data, which allows you to use SQL indexing and querying facilities on your database of persistent objects. Requirements: · Perl

Persistence::Database::SQL Related Software