org.sequalite.utils
Class DAOUtils

java.lang.Object
  extended by org.sequalite.utils.DAOUtils

public class DAOUtils
extends java.lang.Object


Field Summary
static boolean createORmap
           
 
Constructor Summary
DAOUtils()
           
 
Method Summary
static java.lang.String arrayToString(java.lang.Object[] objects)
          array To String
static java.util.List clone(java.util.List list, SequaliteMapper mapper)
          Clone a list of objects
static java.lang.Object clone(java.lang.Object base, SequaliteMapper mapper)
          Clone the object
static SequaliteMapper constructPackageMetaData(java.lang.Class pojoClass)
           
static java.lang.Class createClass(SequaliteMapper sqm, java.lang.String className)
          create Class
static java.lang.Object createObject(java.lang.Class cls)
          create Object from Class
static void dumpObject(java.io.PrintStream out, java.lang.Object obj)
          prints the Object to a stream
static void dumpResultset(java.io.PrintStream out, java.sql.ResultSet rs)
          prints the resultset to a stream
static void freeResources(java.lang.Object[] objects)
          close jdbc objects or files
static ChildMapper getChildMapperByColumnName(ClassMapper ptm, java.lang.String columnName)
          Retrieves ChildMapper from ClassMapper using columnName
static ChildMapper getChildMapperByName(ClassMapper ptm, java.lang.String javaName)
          Retrieves ChildMapper from ClassMapper using javaName
static java.lang.Object getChildObject(java.lang.Object obj, ChildMapper child)
          gets Child Object
static java.util.List getChildObjectList(java.lang.Object obj, ChildMapper child)
          get Child Object List
static ClassMapper getClassMapper(SequaliteMapper sqm, java.lang.String className)
          Retrieves ClassMapper from SequaliteMapper
static java.lang.String getColumns(ClassMapper table)
          retrieve comma separated columns
static java.sql.Connection getConnection(java.sql.Driver driver, java.lang.String jdbcURL, java.lang.String user, java.lang.String password)
          creates database connection
static java.sql.Connection getConnection(java.lang.String context, java.util.Properties prop)
          creates database connection
static java.lang.String getCountSQL(java.lang.String query)
          creates the Count SQL for pagination using named SQL
static java.lang.String getDeleteSQL(ClassMapper table)
          get Delete SQL
static java.lang.String getDeleteSQL(ClassMapper table, java.lang.String criteria, java.lang.Object[] cValues)
          get Delete SQL
static java.lang.String getDeleteSQLWithoutPK(ClassMapper table, java.lang.Object object, java.util.List valueList)
          Create DeleteSQL without PrimaryKey
static FieldMapper getFieldMapperByColumnName(ClassMapper ptm, java.lang.String columnName)
          Retrieves FieldMapper from ClassMapper using columnName
static FieldMapper getFieldMapperByName(ClassMapper ptm, java.lang.String javaName)
          Retrieves FieldMapper from ClassMapper using javaName
static java.lang.Object getFieldValue(java.lang.Object obj, FieldMapper field)
          get Field Value
static java.lang.String getFindSQL(ClassMapper table, java.lang.String filter, java.lang.Object[] cValues, java.lang.String orderBy)
           
static java.lang.String getIdSQL(ClassMapper table, java.lang.String criteria, java.lang.Object[] cValues, java.lang.String sortBy)
          Gets the ID SQL
static java.lang.String getInsertSQL(ClassMapper table, boolean autoIncrement)
          get Insert SQL
static SequaliteMapper getPackageMetaData(java.lang.Class pojoClass)
          Reads the sequalite-mapper.xml metadata file for a package
static java.lang.String getPaginationSQL(java.lang.String query, int page, int rowsPerPage, java.lang.String driver)
          creates the pagination SQL
static java.lang.Object getPrimaryKeyValue(java.lang.Object obj, ClassMapper table)
          get PrimaryKey Value
static java.lang.String getSelectSQL(ClassMapper table)
          get Select SQL
static SqlMapper getSQL(ClassMapper table, java.lang.String sqlName)
          get Named SQL
static java.lang.String getUpdateSQL(ClassMapper table)
          get Update SQL
static java.lang.String getUpdateSQL(ClassMapper table, java.lang.String setter, java.lang.String criteria, java.lang.Object[] cValues)
           
static void initDriver(java.lang.String driverClass)
          Initializes the driver class
static java.lang.Class[] loadDrivers(java.lang.String[] jarPath)
          Loads the driver class
static javax.sql.DataSource lookupDataSource(java.lang.String jndiName)
          Looks up the datasource
static SequaliteMapper lookupMappings(java.lang.Class pojoClass)
          initialize OR mappings
static void main(java.lang.String[] st)
           
static void populateChild(java.lang.Object obj, SequaliteMapper sqm, ClassMapper table, java.lang.String columnName, java.lang.Object value)
          populate Single Child
static void populateChildren(java.lang.Object obj, ClassMapper table, java.lang.String columnName, java.util.List valueList)
          populate Multiple Child
static void populateField(java.lang.Object obj, ClassMapper table, java.lang.String columnName, java.lang.Object value)
          populate Field
static void populateFieldFromResultSet(java.sql.ResultSet rs, java.lang.Object obj, ClassMapper table, FieldMapper field)
          populates Field From ResultSet
static int populateInsertPSParamsWithFieldValues(java.sql.PreparedStatement ps, int psCount, java.lang.Object object, ClassMapper table)
          populate Insert Prepared Statement Params With Field Values
static int populateInsertPSParamsWithFieldValues(java.sql.PreparedStatement ps, int psCount, java.lang.Object object, ClassMapper table, java.lang.StringBuffer sb)
          populate Insert Prepared Statement Params With Field Values
static void populateObjectFromResultSet(java.sql.ResultSet rs, java.lang.Object obj, ClassMapper table, Session session, SequaliteMapper sequaliteMapper)
          populates an Object from resultset
static java.util.List populateObjects(Session session, java.sql.ResultSet rs, java.lang.Class cls, ClassMapper table, SequaliteMapper mapper)
          Creates a list of objects from Resultset
static void populatePrimaryKey(java.sql.ResultSet rs, java.lang.Object obj, ClassMapper table)
          populate Primary Key
static void populateProxyObjectFromResultSet(java.sql.ResultSet rs, java.lang.Object obj, ClassMapper table, java.lang.String columnName, java.lang.String rsColumnName)
          populates proxy object
static java.util.List<SeQuaLiteModel> populateProxyObjects(Session session, java.sql.ResultSet rs, java.lang.Class cls, ClassMapper table)
          Creates a list of objects from Resultset
static void populatePSParams(java.sql.PreparedStatement ps, boolean insert, boolean autoIncrement, java.lang.Object object, SequaliteMapper sqm, ClassMapper table, java.lang.StringBuffer sb)
          populates preparedStatement parameters from Object
static void populatePSParams(java.sql.PreparedStatement ps, java.lang.String sql, java.lang.Object[] values, java.util.logging.Level sqlLevel)
          populate Prepared Statement Params
static int populatePSParamsWithChildPKValues(java.sql.PreparedStatement ps, int psCount, java.lang.Object object, SequaliteMapper sqm, ClassMapper table)
          populate Prepared Statement Params With Child PriamryKey Value
static int populatePSParamsWithChildPKValues(java.sql.PreparedStatement ps, int psCount, java.lang.Object object, SequaliteMapper sqm, ClassMapper table, java.lang.StringBuffer sb)
          populate Prepared Statement Params With Child PriamryKey Value
static void populateSeQuaLiteModelFromResultSet(java.sql.ResultSet rs, SeQuaLiteModel obj, ClassMapper table, Session session, SequaliteMapper mapper)
          populates an Object from resultset
static int populateUpdatePSParamsWithFieldValues(java.sql.PreparedStatement ps, int psCount, java.lang.Object object, ClassMapper table)
          populate Update Prepared Statement Params With Field Values
static int populateUpdatePSParamsWithFieldValues(java.sql.PreparedStatement ps, int psCount, java.lang.Object object, ClassMapper table, java.lang.StringBuffer sb)
          populate Update Prepared Statement Params With Field Values
static void setPrimaryKeyValue(java.lang.Object obj, ClassMapper table, java.lang.Object value)
          set PrimaryKey Value
static java.lang.String translateToOrderByClause(ClassMapper clazz, java.lang.String sql)
          traslates a sql to orderby clause
static java.lang.String translateToSQL(ClassMapper clazz, java.lang.String sql)
          traslates a sql
static java.lang.String translateToWhereClause(ClassMapper clazz, java.lang.String sql, java.lang.Object[] values)
          traslates a sql to where clause
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

createORmap

public static boolean createORmap
Constructor Detail

DAOUtils

public DAOUtils()
Method Detail

arrayToString

public static java.lang.String arrayToString(java.lang.Object[] objects)
array To String

Parameters:
objects -
Returns:
String

clone

public static java.util.List clone(java.util.List list,
                                   SequaliteMapper mapper)
                            throws SeQuaLiteException
Clone a list of objects

Parameters:
list -
mapper -
Returns:
Throws:
SeQuaLiteException

clone

public static java.lang.Object clone(java.lang.Object base,
                                     SequaliteMapper mapper)
                              throws SeQuaLiteException
Clone the object

Parameters:
base -
mapper -
Returns:
Throws:
SeQuaLiteException

constructPackageMetaData

public static SequaliteMapper constructPackageMetaData(java.lang.Class pojoClass)

createClass

public static java.lang.Class createClass(SequaliteMapper sqm,
                                          java.lang.String className)
                                   throws SeQuaLiteException
create Class

Parameters:
sqm -
className -
Returns:
Class
Throws:
SeQuaLiteException

createObject

public static java.lang.Object createObject(java.lang.Class cls)
                                     throws SeQuaLiteException
create Object from Class

Parameters:
cls -
Returns:
object
Throws:
SeQuaLiteException

dumpObject

public static void dumpObject(java.io.PrintStream out,
                              java.lang.Object obj)
prints the Object to a stream

Parameters:
out -
obj -

dumpResultset

public static void dumpResultset(java.io.PrintStream out,
                                 java.sql.ResultSet rs)
prints the resultset to a stream

Parameters:
out -
rs -

freeResources

public static void freeResources(java.lang.Object[] objects)
                          throws SeQuaLiteException
close jdbc objects or files

Parameters:
objects -
Throws:
SeQuaLiteException

getChildMapperByColumnName

public static ChildMapper getChildMapperByColumnName(ClassMapper ptm,
                                                     java.lang.String columnName)
                                              throws SeQuaLiteException
Retrieves ChildMapper from ClassMapper using columnName

Parameters:
ptm -
columnName -
Returns:
child
Throws:
SeQuaLiteException

getChildMapperByName

public static ChildMapper getChildMapperByName(ClassMapper ptm,
                                               java.lang.String javaName)
                                        throws SeQuaLiteException
Retrieves ChildMapper from ClassMapper using javaName

Parameters:
ptm -
javaName -
Returns:
child
Throws:
SeQuaLiteException

getChildObject

public static java.lang.Object getChildObject(java.lang.Object obj,
                                              ChildMapper child)
gets Child Object

Parameters:
obj -
child -
Returns:
childObject

getChildObjectList

public static java.util.List getChildObjectList(java.lang.Object obj,
                                                ChildMapper child)
get Child Object List

Parameters:
obj -
child -
Returns:
list

getClassMapper

public static ClassMapper getClassMapper(SequaliteMapper sqm,
                                         java.lang.String className)
                                  throws SeQuaLiteException
Retrieves ClassMapper from SequaliteMapper

Parameters:
sqm -
className -
Returns:
classMapper
Throws:
SeQuaLiteException

getColumns

public static java.lang.String getColumns(ClassMapper table)
retrieve comma separated columns

Parameters:
table -
Returns:
string

getConnection

public static java.sql.Connection getConnection(java.sql.Driver driver,
                                                java.lang.String jdbcURL,
                                                java.lang.String user,
                                                java.lang.String password)
                                         throws SeQuaLiteException
creates database connection

Parameters:
driver -
jdbcURL -
user -
password -
Returns:
Throws:
SeQuaLiteException

getConnection

public static java.sql.Connection getConnection(java.lang.String context,
                                                java.util.Properties prop)
                                         throws SeQuaLiteException
creates database connection

Parameters:
context -
prop -
Returns:
dbConnection
Throws:
SeQuaLiteException

getCountSQL

public static java.lang.String getCountSQL(java.lang.String query)
                                    throws SeQuaLiteException
creates the Count SQL for pagination using named SQL

Parameters:
query -
Returns:
Throws:
SeQuaLiteException

getDeleteSQL

public static java.lang.String getDeleteSQL(ClassMapper table)
get Delete SQL

Parameters:
table -
Returns:
string

getDeleteSQL

public static java.lang.String getDeleteSQL(ClassMapper table,
                                            java.lang.String criteria,
                                            java.lang.Object[] cValues)
                                     throws SeQuaLiteException
get Delete SQL

Parameters:
table -
criteria -
Returns:
string
Throws:
SQLSyntaxException
SeQuaLiteException

getDeleteSQLWithoutPK

public static java.lang.String getDeleteSQLWithoutPK(ClassMapper table,
                                                     java.lang.Object object,
                                                     java.util.List valueList)
                                              throws SeQuaLiteException
Create DeleteSQL without PrimaryKey

Parameters:
table -
object -
valueList -
Returns:
Throws:
SeQuaLiteException

getFieldMapperByColumnName

public static FieldMapper getFieldMapperByColumnName(ClassMapper ptm,
                                                     java.lang.String columnName)
                                              throws SeQuaLiteException
Retrieves FieldMapper from ClassMapper using columnName

Parameters:
ptm -
columnName -
Returns:
field
Throws:
SeQuaLiteException

getFieldMapperByName

public static FieldMapper getFieldMapperByName(ClassMapper ptm,
                                               java.lang.String javaName)
                                        throws SeQuaLiteException
Retrieves FieldMapper from ClassMapper using javaName

Parameters:
ptm -
javaName -
Returns:
Throws:
SeQuaLiteException

getFieldValue

public static java.lang.Object getFieldValue(java.lang.Object obj,
                                             FieldMapper field)
                                      throws SeQuaLiteException
get Field Value

Parameters:
obj -
field -
Returns:
Throws:
SeQuaLiteException

getFindSQL

public static java.lang.String getFindSQL(ClassMapper table,
                                          java.lang.String filter,
                                          java.lang.Object[] cValues,
                                          java.lang.String orderBy)
                                   throws SeQuaLiteException
Parameters:
table -
filter -
orderBy -
Returns:
Throws:
SeQuaLiteException

getIdSQL

public static java.lang.String getIdSQL(ClassMapper table,
                                        java.lang.String criteria,
                                        java.lang.Object[] cValues,
                                        java.lang.String sortBy)
                                 throws SeQuaLiteException
Gets the ID SQL

Parameters:
table -
criteria -
sortBy -
Returns:
Throws:
SQLSyntaxException
SeQuaLiteException

getInsertSQL

public static java.lang.String getInsertSQL(ClassMapper table,
                                            boolean autoIncrement)
get Insert SQL

Parameters:
table -
Returns:

getPackageMetaData

public static SequaliteMapper getPackageMetaData(java.lang.Class pojoClass)
                                          throws SeQuaLiteException
Reads the sequalite-mapper.xml metadata file for a package

Parameters:
pojoClass -
Returns:
Throws:
SeQuaLiteException

getPaginationSQL

public static java.lang.String getPaginationSQL(java.lang.String query,
                                                int page,
                                                int rowsPerPage,
                                                java.lang.String driver)
                                         throws SeQuaLiteException
creates the pagination SQL

Parameters:
query -
page -
rowsPerPage -
driver -
Returns:
Throws:
SeQuaLiteException

getPrimaryKeyValue

public static java.lang.Object getPrimaryKeyValue(java.lang.Object obj,
                                                  ClassMapper table)
                                           throws SeQuaLiteException
get PrimaryKey Value

Parameters:
obj -
table -
Returns:
Throws:
SeQuaLiteException

getSelectSQL

public static java.lang.String getSelectSQL(ClassMapper table)
get Select SQL

Parameters:
table -
Returns:

getSQL

public static SqlMapper getSQL(ClassMapper table,
                               java.lang.String sqlName)
                        throws SeQuaLiteException
get Named SQL

Parameters:
table -
sqlName -
Returns:
Throws:
SeQuaLiteException

getUpdateSQL

public static java.lang.String getUpdateSQL(ClassMapper table)
get Update SQL

Parameters:
table -
Returns:

getUpdateSQL

public static java.lang.String getUpdateSQL(ClassMapper table,
                                            java.lang.String setter,
                                            java.lang.String criteria,
                                            java.lang.Object[] cValues)
                                     throws SeQuaLiteException
Throws:
SeQuaLiteException

initDriver

public static void initDriver(java.lang.String driverClass)
                       throws java.lang.Exception
Initializes the driver class

Parameters:
driverClass -
Throws:
java.lang.Exception

loadDrivers

public static java.lang.Class[] loadDrivers(java.lang.String[] jarPath)
                                     throws SeQuaLiteException
Loads the driver class

Parameters:
jarPath -
Returns:
Throws:
SeQuaLiteException

lookupDataSource

public static javax.sql.DataSource lookupDataSource(java.lang.String jndiName)
                                             throws SeQuaLiteException
Looks up the datasource

Parameters:
jndiName -
Returns:
Throws:
SeQuaLiteException

lookupMappings

public static SequaliteMapper lookupMappings(java.lang.Class pojoClass)
                                      throws SeQuaLiteException
initialize OR mappings

Parameters:
pojoClass -
Returns:
Throws:
SeQuaLiteException

main

public static void main(java.lang.String[] st)

populateChild

public static void populateChild(java.lang.Object obj,
                                 SequaliteMapper sqm,
                                 ClassMapper table,
                                 java.lang.String columnName,
                                 java.lang.Object value)
                          throws SeQuaLiteException
populate Single Child

Parameters:
obj -
table -
columnName -
value -
Throws:
SeQuaLiteException

populateChildren

public static void populateChildren(java.lang.Object obj,
                                    ClassMapper table,
                                    java.lang.String columnName,
                                    java.util.List valueList)
                             throws SeQuaLiteException
populate Multiple Child

Parameters:
obj -
table -
columnName -
valueList -
Throws:
SeQuaLiteException

populateField

public static void populateField(java.lang.Object obj,
                                 ClassMapper table,
                                 java.lang.String columnName,
                                 java.lang.Object value)
                          throws SeQuaLiteException
populate Field

Parameters:
obj -
table -
columnName -
value -
Throws:
SeQuaLiteException

populateFieldFromResultSet

public static void populateFieldFromResultSet(java.sql.ResultSet rs,
                                              java.lang.Object obj,
                                              ClassMapper table,
                                              FieldMapper field)
                                       throws SeQuaLiteException
populates Field From ResultSet

Parameters:
rs -
obj -
table -
field -
Throws:
SeQuaLiteException

populateInsertPSParamsWithFieldValues

public static int populateInsertPSParamsWithFieldValues(java.sql.PreparedStatement ps,
                                                        int psCount,
                                                        java.lang.Object object,
                                                        ClassMapper table)
                                                 throws java.sql.SQLException,
                                                        SeQuaLiteException
populate Insert Prepared Statement Params With Field Values

Parameters:
ps -
psCount -
object -
table -
Returns:
Throws:
java.sql.SQLException
SeQuaLiteException

populateInsertPSParamsWithFieldValues

public static int populateInsertPSParamsWithFieldValues(java.sql.PreparedStatement ps,
                                                        int psCount,
                                                        java.lang.Object object,
                                                        ClassMapper table,
                                                        java.lang.StringBuffer sb)
                                                 throws java.sql.SQLException,
                                                        SeQuaLiteException
populate Insert Prepared Statement Params With Field Values

Parameters:
ps -
psCount -
object -
table -
sb -
Returns:
Throws:
java.sql.SQLException
SeQuaLiteException

populateObjectFromResultSet

public static void populateObjectFromResultSet(java.sql.ResultSet rs,
                                               java.lang.Object obj,
                                               ClassMapper table,
                                               Session session,
                                               SequaliteMapper sequaliteMapper)
                                        throws java.sql.SQLException,
                                               SeQuaLiteException
populates an Object from resultset

Parameters:
rs -
obj -
Throws:
java.sql.SQLException
SeQuaLiteException
SQLSyntaxException

populateObjects

public static java.util.List populateObjects(Session session,
                                             java.sql.ResultSet rs,
                                             java.lang.Class cls,
                                             ClassMapper table,
                                             SequaliteMapper mapper)
                                      throws java.sql.SQLException
Creates a list of objects from Resultset

Parameters:
rs -
cls -
Returns:
Throws:
java.sql.SQLException

populatePrimaryKey

public static void populatePrimaryKey(java.sql.ResultSet rs,
                                      java.lang.Object obj,
                                      ClassMapper table)
                               throws java.sql.SQLException,
                                      SeQuaLiteException
populate Primary Key

Parameters:
rs -
obj -
table -
Throws:
java.sql.SQLException
SeQuaLiteException

populateProxyObjectFromResultSet

public static void populateProxyObjectFromResultSet(java.sql.ResultSet rs,
                                                    java.lang.Object obj,
                                                    ClassMapper table,
                                                    java.lang.String columnName,
                                                    java.lang.String rsColumnName)
                                             throws SeQuaLiteException
populates proxy object

Parameters:
rs -
obj -
table -
columnName -
rsColumnName -
Throws:
SeQuaLiteException

populateProxyObjects

public static java.util.List<SeQuaLiteModel> populateProxyObjects(Session session,
                                                                  java.sql.ResultSet rs,
                                                                  java.lang.Class cls,
                                                                  ClassMapper table)
                                                           throws java.sql.SQLException
Creates a list of objects from Resultset

Parameters:
rs -
cls -
Returns:
Throws:
java.sql.SQLException

populatePSParams

public static void populatePSParams(java.sql.PreparedStatement ps,
                                    boolean insert,
                                    boolean autoIncrement,
                                    java.lang.Object object,
                                    SequaliteMapper sqm,
                                    ClassMapper table,
                                    java.lang.StringBuffer sb)
                             throws java.sql.SQLException,
                                    SeQuaLiteException
populates preparedStatement parameters from Object

Parameters:
ps -
insert -
autoIncrement -
object -
sqm -
table -
sb -
Throws:
java.sql.SQLException
SeQuaLiteException

populatePSParams

public static void populatePSParams(java.sql.PreparedStatement ps,
                                    java.lang.String sql,
                                    java.lang.Object[] values,
                                    java.util.logging.Level sqlLevel)
                             throws java.sql.SQLException
populate Prepared Statement Params

Parameters:
ps -
sql -
values -
sqlLevel -
Throws:
java.sql.SQLException

populatePSParamsWithChildPKValues

public static int populatePSParamsWithChildPKValues(java.sql.PreparedStatement ps,
                                                    int psCount,
                                                    java.lang.Object object,
                                                    SequaliteMapper sqm,
                                                    ClassMapper table)
                                             throws java.sql.SQLException,
                                                    SeQuaLiteException
populate Prepared Statement Params With Child PriamryKey Value

Parameters:
ps -
psCount -
object -
sqm -
table -
Returns:
Throws:
java.sql.SQLException
SeQuaLiteException

populatePSParamsWithChildPKValues

public static int populatePSParamsWithChildPKValues(java.sql.PreparedStatement ps,
                                                    int psCount,
                                                    java.lang.Object object,
                                                    SequaliteMapper sqm,
                                                    ClassMapper table,
                                                    java.lang.StringBuffer sb)
                                             throws java.sql.SQLException,
                                                    SeQuaLiteException
populate Prepared Statement Params With Child PriamryKey Value

Parameters:
ps -
psCount -
object -
sqm -
table -
sb -
Returns:
Throws:
java.sql.SQLException
SeQuaLiteException

populateSeQuaLiteModelFromResultSet

public static void populateSeQuaLiteModelFromResultSet(java.sql.ResultSet rs,
                                                       SeQuaLiteModel obj,
                                                       ClassMapper table,
                                                       Session session,
                                                       SequaliteMapper mapper)
                                                throws java.sql.SQLException,
                                                       SeQuaLiteException
populates an Object from resultset

Parameters:
rs -
obj -
Throws:
java.sql.SQLException
SeQuaLiteException
SQLSyntaxException

populateUpdatePSParamsWithFieldValues

public static int populateUpdatePSParamsWithFieldValues(java.sql.PreparedStatement ps,
                                                        int psCount,
                                                        java.lang.Object object,
                                                        ClassMapper table)
                                                 throws java.sql.SQLException,
                                                        SeQuaLiteException
populate Update Prepared Statement Params With Field Values

Parameters:
ps -
psCount -
object -
table -
Returns:
Throws:
java.sql.SQLException
SeQuaLiteException

populateUpdatePSParamsWithFieldValues

public static int populateUpdatePSParamsWithFieldValues(java.sql.PreparedStatement ps,
                                                        int psCount,
                                                        java.lang.Object object,
                                                        ClassMapper table,
                                                        java.lang.StringBuffer sb)
                                                 throws java.sql.SQLException,
                                                        SeQuaLiteException
populate Update Prepared Statement Params With Field Values

Parameters:
ps -
psCount -
object -
table -
sb -
Returns:
Throws:
java.sql.SQLException
SeQuaLiteException

setPrimaryKeyValue

public static void setPrimaryKeyValue(java.lang.Object obj,
                                      ClassMapper table,
                                      java.lang.Object value)
                               throws SeQuaLiteException
set PrimaryKey Value

Parameters:
obj -
table -
value -
Throws:
SeQuaLiteException

translateToOrderByClause

public static java.lang.String translateToOrderByClause(ClassMapper clazz,
                                                        java.lang.String sql)
traslates a sql to orderby clause

Parameters:
clazz -
sql -
Returns:

translateToSQL

public static java.lang.String translateToSQL(ClassMapper clazz,
                                              java.lang.String sql)
traslates a sql

Parameters:
clazz -
sql -
Returns:

translateToWhereClause

public static java.lang.String translateToWhereClause(ClassMapper clazz,
                                                      java.lang.String sql,
                                                      java.lang.Object[] values)
                                               throws SeQuaLiteException
traslates a sql to where clause

Parameters:
clazz -
sql -
Returns:
Throws:
SQLSyntaxException
SeQuaLiteException