org.apache.ojb.broker.util
Class SqlHelper

java.lang.Object
  extended byorg.apache.ojb.broker.util.SqlHelper

public class SqlHelper
extends java.lang.Object

Helper class for all SQL related stuff.

Version:
$Id: SqlHelper.java,v 1.24.2.1 2005/01/14 21:11:31 brj Exp $
Author:
Armin Waibel

Nested Class Summary
static class SqlHelper.PathInfo
          Helper Class for a split column
ie: sum (distinct amount) as theAmount
 
Constructor Summary
SqlHelper()
           
 
Method Summary
static java.lang.String cleanPath(java.lang.String aPath)
          remove functions and () from path
ie: avg(amount) -> amount
ie: sum (accounts.amount) -> accounts.amount
ie: count(distinct id) as theCount-> id
static SqlHelper.PathInfo splitPath(java.lang.String aPath)
          Split a path into column , prefix and suffix, the prefix contains all info up to the column
ie: avg(amount) -> amount , avg( , )
ie: sum (accounts.amount) as theSum -> accounts.amount , sum( , ) as theSum
ie: count( distinct id ) as bla -> id , count(distinct , ) as bla
Supports simple expressions ie: price * 1.05 TODO: cannot resolve multiple attributes in expression ie: price - bonus
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

SqlHelper

public SqlHelper()
Method Detail

cleanPath

public static java.lang.String cleanPath(java.lang.String aPath)
remove functions and () from path
ie: avg(amount) -> amount
ie: sum (accounts.amount) -> accounts.amount
ie: count(distinct id) as theCount-> id

Parameters:
aPath - the path to the attribute

splitPath

public static SqlHelper.PathInfo splitPath(java.lang.String aPath)
Split a path into column , prefix and suffix, the prefix contains all info up to the column
ie: avg(amount) -> amount , avg( , )
ie: sum (accounts.amount) as theSum -> accounts.amount , sum( , ) as theSum
ie: count( distinct id ) as bla -> id , count(distinct , ) as bla
Supports simple expressions ie: price * 1.05 TODO: cannot resolve multiple attributes in expression ie: price - bonus

Parameters:
aPath -
Returns:
PathInfo


(C) 2002 - 2004 Apache Software Foundation
All rights reserved. Published under the Apache License 2.0.
http://db.apache.org/ojb
Version: 1.0.3, 2005-04-2