com.openkm.util

Class DatabaseMetadataUtils

java.lang.Object

com.openkm.util.DatabaseMetadataUtils

public class DatabaseMetadataUtils
extends Object

DatabaseMetadataUtils

Author:

pavila

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	DatabaseMetadataUtils.LenComparator custom comparator for sorting strings by length (in descending order)

Constructor Summary

Constructors

Constructor and Description
DatabaseMetadataUtils()

Method Summary

Methods

Modifier and Type	Method and Description
static String	buildDelete(String table, String filter) Build a query
static String	buildQuery(String table, String filter) Build a query
static String	buildQuery(String table, String filter, String order) Build a query
static String	buildUpdate(String table, String values, String filter) Build a query
static DatabaseMetadataValue	getDatabaseMetadataValueByMap(Map<String,String> map) Obtain a DatabaseMetadataValue from a Map
static Map<String,String>	getDatabaseMetadataValueMap(DatabaseMetadataValue value) Obtain a Map from a DatabaseMetadataValue.
static Calendar	getDate(DatabaseMetadataValue value, String column) Get virtual column date value
static String	getString(DatabaseMetadataValue value, String column) Get virtual column string value
static String	getString(String table, String filter, String column) Get value from id.
static String	replaceVirtual(List<String> tables, String query) Replace virtual columns by real ones

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

DatabaseMetadataUtils

public DatabaseMetadataUtils()

Method Detail

buildQuery

public static String buildQuery(String table,
                String filter,
                String order)
                         throws DatabaseException

Build a query

Throws:

DatabaseException

buildQuery

public static String buildQuery(String table,
                String filter)
                         throws DatabaseException

Build a query

Throws:

DatabaseException

buildUpdate

public static String buildUpdate(String table,
                 String values,
                 String filter)
                          throws DatabaseException

Build a query

Throws:

DatabaseException

buildDelete

public static String buildDelete(String table,
                 String filter)
                          throws DatabaseException

Build a query

Throws:

DatabaseException

getString

public static String getString(DatabaseMetadataValue value,
               String column)
                        throws DatabaseException,
                               IllegalAccessException,
                               InvocationTargetException,
                               NoSuchMethodException

Get virtual column string value

Throws:

DatabaseException

IllegalAccessException

InvocationTargetException

NoSuchMethodException

getString

public static String getString(String table,
               String filter,
               String column)
                        throws DatabaseException,
                               IllegalAccessException,
                               InvocationTargetException,
                               NoSuchMethodException

Get value from id. This is a shortcut method.

Throws:

DatabaseException

IllegalAccessException

InvocationTargetException

NoSuchMethodException

getDate

public static Calendar getDate(DatabaseMetadataValue value,
               String column)
                        throws DatabaseException,
                               IllegalAccessException,
                               InvocationTargetException,
                               NoSuchMethodException

Get virtual column date value

Throws:

DatabaseException

IllegalAccessException

InvocationTargetException

NoSuchMethodException

getDatabaseMetadataValueMap

public static Map<String,String> getDatabaseMetadataValueMap(DatabaseMetadataValue value)
                                                      throws DatabaseException,
                                                             IllegalAccessException,
                                                             InvocationTargetException,
                                                             NoSuchMethodException

Obtain a Map from a DatabaseMetadataValue.

Throws:

DatabaseException

IllegalAccessException

InvocationTargetException

NoSuchMethodException

getDatabaseMetadataValueByMap

public static DatabaseMetadataValue getDatabaseMetadataValueByMap(Map<String,String> map)
                                                           throws DatabaseException,
                                                                  IllegalAccessException,
                                                                  InvocationTargetException

Obtain a DatabaseMetadataValue from a Map

Throws:

DatabaseException

IllegalAccessException

InvocationTargetException

replaceVirtual

public static String replaceVirtual(List<String> tables,
                    String query)
                             throws DatabaseException

Replace virtual columns by real ones

Throws:

DatabaseException