Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
NOTEDB::mysql(3)      User Contributed Perl Documentation     NOTEDB::mysql(3)

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 (usefull 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.32.0			  2012-02-10		      NOTEDB::mysql(3)

NAME | SYNOPSIS | DESCRIPTION | USAGE | AUTHOR

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=NOTEDB::mysql&sektion=3&manpath=FreeBSD+12.2-RELEASE+and+Ports>

home | help