Metadata::DB::Base
argument is hash ref you must pass DBH, database handle, to the object. This is a database handle you opened before instancing the object If you wanted to change the name of the table..
my $m = Metadata::DB::Base({ DBH => $dbh });
$m->table_metadata_name('other_metadata_table'); # default is 'metadata'
$m->table_metadata_check; # make sure the table is there, if you wanted to setup
returns database handle The DBI handle is passed to the CONSTRUCTOR You will need LEOCHARRE::Database
does the metadata table exist or not? returns boolean.
creates metadata table, does not check for existance
optional argument is limit returns debug string with a pseudo metadata table dump, suitable for printing to STDERR for debug purposes.
returns what the metadata table is expected to look according to current params could be useful if you're having a hard time with all of this. If you turn DEBUG to on, this is printed to STDERR .
create table if not exists
drops metadata table erases all records
drops and rebuilds metadata table erases all records
creates an index for id col
args are table name and column name
arg is id deletes all metadata entries for this record from metadata table (does not commit, etc)
arg is id, returns number of record entries in metadata table
arg is id, key, val
arg is id and hashref the hash ref is the metadata key value pairs this is mostly used for indexing
$self->_table_metadata_insert_mutiple(
5,
{
name_first => 'jim',
name_middle => 'raynor',
name_last => 'waltzman',
phone_number => '208-479-1515',
},
);
arg is id returns hashref
This is to VASTLY improve the speeds of searches
use method create_index_id() after running an indexing run for example
Metadata::DB Metadata::DB::Indexer Metadata::DB::WUI Metadata::Base LEOCHARRE::Database
Leo Charre leocharre at cpan dot org
Still in development Make sure you have the latest versions of DBI and DBD::mysql
Send to AUTHOR
