Persistence::Database::SQLObject Persistence in SQL Databases. | |
Download |
Persistence::Database::SQL Ranking & Summary
Advertisement
- License:
- Perl Artistic License
- Price:
- FREE
- Publisher Name:
- Ashish Gulhati
- Publisher web site:
- http://search.cpan.org/~agul/
Persistence::Database::SQL Tags
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