Login or Register to Ask a Question and Join Our Community


Software Releases - RSS News

DbWrench 1.5.2 (Default branch)

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Special Forums News, Links, Events and Announcements Software Releases - RSS News DbWrench 1.5.2 (Default branch)
# 1  
Old 11-18-2008
DbWrench 1.5.2 (Default branch)
ImageDbWrench is multi-vendor, multi-platform database design and synchronization software. Features include a syntax highlighting SQL query editor, support for many of today's most popular databases, a graphic entity relation diagram (ERD) designer, and the ability to forward and reverse engineer databases. Its multi-vendor and multi-platform functionality makes it ideal for heterogeneous database environments.License: Other/Proprietary License with Free TrialChanges:
This release did not focus on any one or two largeitems, but instead addressed several smalleroutstanding items. These included improved fontrendering on LCDs, improved SQL code generation,and bugfixes for PostgreSQL 8.3 support. Therewere several other improvements to usability andappearance, along with several significantbugfixes.Image

Image

More...
Login or Register to Ask a Question

Previous Thread | Next Thread
Login or Register to Ask a Question

LEARN ABOUT DEBIAN

class::dbi::abstractsearch

Class::DBI::AbstractSearch(3pm) 			User Contributed Perl Documentation			   Class::DBI::AbstractSearch(3pm)

NAME

       Class::DBI::AbstractSearch - Abstract Class::DBI's SQL with SQL::Abstract::Limit

SYNOPSIS

	 package CD::Music;
	 use Class::DBI::AbstractSearch;

	 package main;
	 my @music = CD::Music->search_where(
	     artist => [ 'Ozzy', 'Kelly' ],
	     status => { '!=', 'outdated' },
	 );

	 my @misc = CD::Music->search_where(
	     { artist => [ 'Ozzy', 'Kelly' ],
	       status => { '!=', 'outdated' } },
	     { order_by      => "reldate DESC",
	       limit_dialect => 'LimitOffset',
	       limit	     => 1
	       offset	     => 2 });

DESCRIPTION

       Class::DBI::AbstractSearch is a Class::DBI plugin to glue SQL::Abstract::Limit into Class::DBI.

METHODS

       Using this module adds following methods into your data class.

       search_where
	     $class->search_where(%where);

	   Takes a hash to specify WHERE clause. See SQL::Abstract for hash options.

	     $class->search_where(\%where,\%attrs);

	   Takes hash reference to specify WHERE clause. See SQL::Abstract for hash options. Takes a hash reference to specify additional query
	   attributes. Class::DBI::AbstractSearch uses these attributes:

	   o   order_by

	       Array reference of fields that will be used to order the results of your query.

	   o   limit_dialect

	       Scalar, DBI handle, object class, etc. that describes the syntax model for a LIMIT/OFFSET SQL clause.  Please see
	       SQL::Abstract::Limit for more information.

	   o   limit

	       Scalar value that will be used for LIMIT argument in a query.

	   o   offset

	       Scalar value that will be used for OFFSET argument in a query.

	   Any other attributes are passed to the SQL::Abstract::Limit constructor, and can be used to control how queries are created.  For
	   example, to use 'AND' instead of 'OR' by default, use:

	       $class->search_where(\%where, { logic => 'AND' });

AUTHOR

       Tatsuhiko Miyagawa <miyagawa@bulknews.net> with some help from cdbi-talk mailing list, especially:

	 Tim Bunce
	 Simon Wilcox
	 Tony Bowden

       This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

SEE ALSO

       Class::DBI, SQL::Abstract, SQL::Abstract::Limit

perl v5.10.0							    2009-07-21					   Class::DBI::AbstractSearch(3pm)