Provided by: note_1.3.26-3_all bug

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 returns 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 web interface to note...

USAGE

       please see the section SYNOPSIS, it says it all.

AUTHOR

       Thomas Linden <tom@daemon.de>.