Basset::DB::Table 1.03 review
DownloadBasset::DB::Table is used to define database tables, ways to load that data into memory and build queries based upon the table inform
|
|
Basset::DB::Table is used to define database tables, ways to load that data into memory and build queries based upon the table information.
SYNOPSIS
For example,
my $table = Basset::DB::Table->new(
'name' => 'user',
'primary_column' => 'id',
'autogenerated' => 1,
'definition' => {
'id' => 'SQL_INTEGER',
'username' => 'SQL_VARCHAR',
'password' => 'SQL_VARCHAR',
'name' => 'SQL_VARCHAR'
}
);
print $table->insert_query, "n"; print $table->update_query, "n"; print $table->delete_query, "n";
Basset::DB::Table provides an abstract and consistent location for defining database tables, building queries based upon them, and so on. It is rarely (if ever) used directly in code, but is used extensively in packages which subclass from Basset::Object::Persistent.
Any queries returned by the query methods are simply strings that must be prepared by DBI in order bo be used.
Requirements:
Perl
Basset::DB::Table 1.03 keywords