SQL Construction Kit 2009-01-23 (Default branch)


 
Thread Tools Search this Thread
Special Forums News, Links, Events and Announcements Software Releases - RSS News SQL Construction Kit 2009-01-23 (Default branch)
# 1  
Old 01-23-2009
SQL Construction Kit 2009-01-23 (Default branch)

SQL Construction Kit aims to provide a simplebuilder/factory pattern based approach togenerating DML SQL for all popular RDBMS systems.Included builders are SelectBuilder,InsertBuilder, UpdateBuilder, and DeleteBuilder.It is much lighter weight than any of the ORMtools available, and is 100% Java. It is a complete re-factoring of code that has been inproduction use since 2001 (updated to use features of Java 6). Also included is aFacade patterned Database object that wraps aDatasource object. This provides an executionframework for the results of the Builder objects,which includes simplified transaction and batchmanagement as well as the ability to transparentlyhandle SQL exceptions in a default manner. TheDatabase object also provides a simpleobject-oriented approach via wrappers around thedatabase metadata.License: MIT/X Consortium LicenseChanges:
This release fixes a bug in the AbstractDeleteBuilder object where it did not override the toString() method correctly.Image

Image

More...
Login or Register to Ask a Question

Previous Thread | Next Thread
Login or Register to Ask a Question
SQL::Statement::TermFactory(3)				User Contributed Perl Documentation			    SQL::Statement::TermFactory(3)

NAME
SQL::Statement::TermFactory - Factory for SQL::Statement::Term instances SYNOPSIS
my $termFactory = SQL::Statement::TermFactory->new($stmt); my $whereTerms = $termFactory->buildCondition( $stmt->{where_clause} ); my $col = $termFactory->buildCondition( $stmt->{col_obj}->{$name}->{content} ); DESCRIPTION
This package implements a factory to create type and operation based terms. Those terms are used to access data from the table(s) - either when evaluating the where clause or returning column data. The concept of a factory can be studied in Design Patterns by the Gang of Four. The concept of using polymophism instead of conditions is suggested by Martin Fowler in his book Refactoring. METHODS
buildCondition Builds a condition object from a given (part of a) where clause. This method calls itself recursively for predicates. AUTHOR AND COPYRIGHT
Copyright (c) 2001,2005 by Jeff Zucker: jzuckerATcpan.org Copyright (c) 2008-2010 by Jens Rehsack: rehsackATcpan.org Portions Copyright (C) 1998 by Jochen Wiedmann: jwiedATcpan.org All rights reserved. You may distribute this module under the terms of either the GNU General Public License or the Artistic License, as specified in the Perl README file. perl v5.12.1 2010-05-06 SQL::Statement::TermFactory(3)