org.esupportail.portal.channels.CStockage.channelAction.classic.sharing
Class QueriesManagement

java.lang.Object
  extended byorg.esupportail.portal.channels.CStockage.channelAction.classic.sharing.QueriesManagement

public class QueriesManagement
extends java.lang.Object

Id: QueriesManagement.java,v 1.0 8 mars 2005 Copyright (c) 2005 Esup Portail (www.esup-portail.org) Classes: QueriesManagement Original Author: Yohan Colmant This class manage the access to the queries from the configuration file


Field Summary
static java.lang.String ADD_STORAGE_AVAILABLE_SPACE
          The "add.storage_available_space" property value
static java.lang.String ADD_STORAGE_USERS_PREFERENCES
          The "add.storage_users_preferences" property value
static java.lang.String DEL_STORAGE_AVAILABLE_SPACE
          The "del.storage_available_space" property value
static java.lang.String DEL_STORAGE_USERS_PREFERENCES
          The "del.storage_users_preferences" property value
static java.lang.String DEL_STORAGE_USERS_PREFERENCES_FOR_USER
          The "del.storage_users_preferences_for_user" property value
static java.lang.String GET_AVAILABLE_SPACES_FOR_TARGET
          The "get.available_spaces_for_target" property value
static java.lang.String GET_ID_OF_SPACE_FROM_PREFERENCES
          The "get.id_of_space_from_preferences" property value
static java.lang.String GET_ID_OF_SPACES_WITH_PATH
          The "get.id_of_spaces_with_path" property value
static java.lang.String GET_TARGET_OF_AVAILABLE_SPACE
          The "get.targets_of_available_space" property value
static java.lang.String IS_ALREADY_AVAILABLE_FOR_TARGET
          The "is.already_available_for_target" property value
static java.lang.String IS_ALREADY_IN_PREFERENCES_FOR_A_USER
          The "is.already_in_preferences_for_a_user" property value
protected static Log log
          Logger object
private static java.lang.String MYSQL_DRIVER
          The mysql driver
private static java.lang.String ORACLE_DRIVER
          The oracle driver
private static java.lang.String POSTGRES_DRIVER
          The postgres driver
private static java.util.Properties properties
          The properties object
private static java.lang.String propertiesPath
          The path of the properties directory
private static java.lang.String SQL_QUERIES_FILE_NAME
          The sql queries file
static java.lang.String UPDATE_LABEL_AVAILABLE_SPACE
          The "update.label_available_space" property value
static java.lang.String UPDATE_PATH_OF_SHARING
          The "update.path_of_sharing" property value
static java.lang.String UPDATE_READ_AND_WRITE_AND_MANAGE_SPACE
          The "update.read_and_write_and_manage_space" property value
 
Constructor Summary
QueriesManagement()
          Constructor
 
Method Summary
 java.util.Properties getProperties()
          Constructor Initialize the parameters for a connexion to the database
static java.lang.String getQuery(java.lang.String queryName)
          Get a query from the properties file
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

log

protected static final Log log
Logger object


MYSQL_DRIVER

private static java.lang.String MYSQL_DRIVER
The mysql driver


ORACLE_DRIVER

private static java.lang.String ORACLE_DRIVER
The oracle driver


POSTGRES_DRIVER

private static java.lang.String POSTGRES_DRIVER
The postgres driver


SQL_QUERIES_FILE_NAME

private static java.lang.String SQL_QUERIES_FILE_NAME
The sql queries file


propertiesPath

private static java.lang.String propertiesPath
The path of the properties directory


ADD_STORAGE_AVAILABLE_SPACE

public static java.lang.String ADD_STORAGE_AVAILABLE_SPACE
The "add.storage_available_space" property value


DEL_STORAGE_AVAILABLE_SPACE

public static java.lang.String DEL_STORAGE_AVAILABLE_SPACE
The "del.storage_available_space" property value


GET_TARGET_OF_AVAILABLE_SPACE

public static java.lang.String GET_TARGET_OF_AVAILABLE_SPACE
The "get.targets_of_available_space" property value


IS_ALREADY_AVAILABLE_FOR_TARGET

public static java.lang.String IS_ALREADY_AVAILABLE_FOR_TARGET
The "is.already_available_for_target" property value


UPDATE_LABEL_AVAILABLE_SPACE

public static java.lang.String UPDATE_LABEL_AVAILABLE_SPACE
The "update.label_available_space" property value


UPDATE_READ_AND_WRITE_AND_MANAGE_SPACE

public static java.lang.String UPDATE_READ_AND_WRITE_AND_MANAGE_SPACE
The "update.read_and_write_and_manage_space" property value


GET_AVAILABLE_SPACES_FOR_TARGET

public static java.lang.String GET_AVAILABLE_SPACES_FOR_TARGET
The "get.available_spaces_for_target" property value


ADD_STORAGE_USERS_PREFERENCES

public static java.lang.String ADD_STORAGE_USERS_PREFERENCES
The "add.storage_users_preferences" property value


IS_ALREADY_IN_PREFERENCES_FOR_A_USER

public static java.lang.String IS_ALREADY_IN_PREFERENCES_FOR_A_USER
The "is.already_in_preferences_for_a_user" property value


GET_ID_OF_SPACE_FROM_PREFERENCES

public static java.lang.String GET_ID_OF_SPACE_FROM_PREFERENCES
The "get.id_of_space_from_preferences" property value


DEL_STORAGE_USERS_PREFERENCES_FOR_USER

public static java.lang.String DEL_STORAGE_USERS_PREFERENCES_FOR_USER
The "del.storage_users_preferences_for_user" property value


DEL_STORAGE_USERS_PREFERENCES

public static java.lang.String DEL_STORAGE_USERS_PREFERENCES
The "del.storage_users_preferences" property value


GET_ID_OF_SPACES_WITH_PATH

public static java.lang.String GET_ID_OF_SPACES_WITH_PATH
The "get.id_of_spaces_with_path" property value


UPDATE_PATH_OF_SHARING

public static java.lang.String UPDATE_PATH_OF_SHARING
The "update.path_of_sharing" property value


properties

private static java.util.Properties properties
The properties object

Constructor Detail

QueriesManagement

public QueriesManagement()
Constructor

Method Detail

getQuery

public static java.lang.String getQuery(java.lang.String queryName)
                                 throws DataBaseException
Get a query from the properties file

Parameters:
queryName - the name of the query we want to get
Returns:
the SQL query
Throws:
DataBaseException

getProperties

public java.util.Properties getProperties()
                                   throws DataBaseException
Constructor Initialize the parameters for a connexion to the database

Throws:
DataBaseException