debian man page for notedb::mysql

Query: notedb::mysql

OS: debian

Section: 3pm

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

NOTEDB::mysql(3pm)					User Contributed Perl Documentation					NOTEDB::mysql(3pm)

NAME
NOTEDB::mysql - module lib for accessing a notedb from perl
SYNOPSIS
# include the module use NOTEDB; # create a new NOTEDB object (the last 4 params are db table/field names) $db = new NOTEDB("mysql","note","localhost","username","password","note","number","note","date"); # get a single note ($note, $date) = $db->get_single(1); # search for a certain note %matching_notes = $db->get_search("somewhat"); # format of returned hash: #$matching_notes{$numberofnote}->{'note' => 'something', 'date' => '23.12.2000 10:33:02'} # get all existing notes %all_notes = $db->get_all(); # format of returnes hash like the one from get_search above # get the next noteid available $next_num = $db->get_nextnum(); # recount all noteids starting by 1 (useful after deleting one!) $db->set_recountnums(); # modify a certain note $db->set_edit(1, "any text", "23.12.2000 10:33:02"); # create a new note $db->set_new(5, "any new text", "23.12.2000 10:33:02"); # delete a certain note $db->set_del(5); # turn on encryption. CryptMethod must be IDEA, DES or BLOWFISH $db->use_crypt("passphrase", "CryptMethod"); # turn off encryption. This is the default. $db->no_crypt();
DESCRIPTION
You can use this module for accessing a note database. There are currently two versions of this module, one version for a SQL database and one for a binary file (note's own database-format). However, both versions provides identical interfaces, which means, you do not need to change your code, if you want to switch to another database format. Currently, NOTEDB module is only used by note itself. But feel free to use it within your own project! Perhaps someone want to implement a webinterface to note...
USAGE
please see the section SYNOPSIS, it says it all.
AUTHOR
Thomas Linden <tom@daemon.de>. perl v5.10.1 2011-02-12 NOTEDB::mysql(3pm)
Related Man Pages
mysql-schema-diff(1p) - debian
note(3pm) - hpux
notedb::dbm(3pm) - debian
notedb::general(3pm) - debian
notedb::mysql(3pm) - debian
Similar Topics in the Unix Linux Community
MYSQL command to take a backup of the database in Redhat linux 7.2
Convert database
command(s) to find size of mysql database?
Writing file name and date from LS command into a file to be imported into mysql
Php number array from max, min, step size mysql data