Fry-Lib-CDBI-Basic

 view release on metacpan or  search on metacpan

README  view on Meta::CPAN

Description
	These are Class::DBI libraries that plug into Fry::Shell.
Features
	- Contains functions that search with &Class::DBI::search* and
		Class::DBI::AbstractSearch:search_where, delete, search and replace in records with a perl regexp, update
		records via a text editor and insert. Also has a few functions used to manipulate DBI::Profile's
		logging.
	- Can customize output format via a subhook for a view sub.
	- Most functions can have their actions confined to certain columns via the 'c' option.
	- Menu mode allows one to alias several Class::DBI objects with numbers making mundane administration easier.
	- Could work with any database working under Class::DBI but mainly works with
	  Mysql,Postgres and Sqlite.
	- Also comes bundled with Fry::Lib::CDBI::Tags and Fry::Lib::CDBI::Outline.

To Do
	-port old TESTS!
	-defining relations between tables with has_*
	-provide direct SQL queries
	-support shell-like parsing of quotes to allow spaces in queries
	-specify sorting and limit of queries

lib/Fry/Lib/CDBI/Basic.pm  view on Meta::CPAN

		*search_abstract
		*cdbi_search
		*cdbi_search_like
		*cdbi_search_regex
	Search based
		cdbi_delete
		*cdbi_update
		*verify_no_delim
		*replace
		cdbi_find_or_create
	Menu based
		cdbi_delete_obj
		cdbi_update_obj
		verify_no_delim_obj
	Debugging via DBI::Profile
		set_dbi_log_level	
		print_dbi_log
		clear_dbi_log
	Other
		cdbi_create
		cdbi_multi_insert

lib/Fry/Lib/CDBI/Basic.pm  view on Meta::CPAN

		note: Since $operation is distinguished from @search_terms by a
		white space, $operation can't contain any white space.

	verify_no_delim(@search_term): Verifies that result objects do not contain the display
		delimiter.  Since this delimiter can be used to separate fields in a
		file, having them in the data could result in incorrect parsing. The
		delimiter is specified by the variable field_delimiter

	cdbi_find_or_create(@search_term): If no result objects found then one is created

=head2 Menu based Commands

 cdbi_delete_obj(@cdbi): same functionality as cdbi_delete
 cdbi_update_obj(@cdbi): same functionality as cdbi_update
 verify_no_delim_obj(@cdbi): same functionality as verify_no_delim

The three menu commands take Class::DBI row objects as input. The only way to
currently enter objects as input is via the menu option. To use these
commands, first execute a search command with the -m option 

	`-m search_abstract tags=goofy` 

lib/Fry/Lib/CDBI/Tags.pm  view on Meta::CPAN

			'dbi,magazine,sites', this function would return a result as follows:

				dbi
					#results containing tags dbi and perl
				magazine	
					#results containing tags magazine and perl
				sites
					#results containing tags sites and perl
		sorted_tag_list(@search_term): returns list of sorted tags
					
	Menu based
		tagname_obj(@cdbi): returns &tagname output
		tagcount_obj(@cdbi): returns &tagcount output

=head1 SEE ALSO

L<Fry::Shell>,L<Fry::Lib::CDBI::Outline>

http://del.icio.us is a community bookmarking site which uses tags heavily.

L<Rubric> is a CPAN implementation similar to it.