org.tango.jhdb

Class MySQLSchema

java.lang.Object

org.tango.jhdb.HdbReader

org.tango.jhdb.MySQLSchema

public class MySQLSchema
extends HdbReader

MySQL database access

Field Summary

Fields

Modifier and Type	Field and Description
static int	DEFAULT_DB_PORT
static String	DEFAULT_DB_URL_PREFIX

Fields inherited from class org.tango.jhdb.HdbReader

MODE_CORRELATED, MODE_FILLED, MODE_IGNORE_ERROR, MODE_NORMAL

Constructor Summary

Constructors

Constructor and Description
MySQLSchema(String host, String db, String user, String passwd, short port) Connects to a MySQL HDB.

Method Summary

Methods

Modifier and Type	Method and Description
void	disconnect()
HdbDataSet	findErrors(String attName, String start_date, String stop_date) This method finds the errors occurred inside a time interval for the specified attribute
String[]	getAttributeList() Retrieves the list of all archived attributes (fully qualified name eg: tango://hostname:port/domain/family/member/attname).
String[]	getDomains(String host) Returns the domain list for the specified host.
String[]	getFamilies(String host, String domain) Returns the family list for the specified host/domain.
String[]	getHosts() Returns the list hostname.
String	getInfo() Returns information on this connection.
HdbSigParam	getLastParam(HdbSigInfo sigInfo) Return last known configurations of the specified attribute
String[]	getMembers(String host, String domain, String family) Returns the member list for the specified host/domain/family.
String[]	getNames(String host, String domain, String family, String member) Returns the name list for the specified host/domain/family/member.
ArrayList<HdbSigParam>	getParams(HdbSigInfo sigInfo, String start_date, String stop_date)
ArrayList<HdbSigParam>	getParams(String attName, String start_date, String stop_date) Return history of configurations of the specified attribute
HdbSigInfo	getSigInfo(String attName) Returns signal info

Methods inherited from class org.tango.jhdb.HdbReader

addProgressListener, checkDates, disableExtraPoint, enableExtraPoint, getData, getData, getData, getData, getExtraPointLookupPeriod, getLastParam, getSigInfo, hasProgressListener, isExtraPointEnabled, removeProgressListener, setExtraPointLookupPeriod

Methods inherited from class java.lang.Object

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

Field Detail

DEFAULT_DB_URL_PREFIX

public static final String DEFAULT_DB_URL_PREFIX

See Also:

Constant Field Values

DEFAULT_DB_PORT

public static final int DEFAULT_DB_PORT

See Also:

Constant Field Values

Constructor Detail

MySQLSchema

public MySQLSchema(String host,
           String db,
           String user,
           String passwd,
           short port)
            throws HdbFailed

Connects to a MySQL HDB.

Parameters:

host - MySQL hostname

db - Database name (default is "hdb")

user - MySQL user name

passwd - MySQL user password

port - MySQL databse port (pass 0 for default Mysql port)

Throws:

HdbFailed - in case of failure

Method Detail

disconnect

public void disconnect()

Specified by:

disconnect in class HdbReader

getInfo

public String getInfo()
               throws HdbFailed

Description copied from class: HdbReader

Returns information on this connection.

Specified by:

getInfo in class HdbReader

Throws:

HdbFailed

getAttributeList

public String[] getAttributeList()
                          throws HdbFailed

Description copied from class: HdbReader

Retrieves the list of all archived attributes (fully qualified name eg: tango://hostname:port/domain/family/member/attname).

Specified by:

getAttributeList in class HdbReader

Throws:

HdbFailed - In case of failure

getHosts

public String[] getHosts()
                  throws HdbFailed

Description copied from class: HdbReader

Returns the list hostname.

Specified by:

getHosts in class HdbReader

Throws:

HdbFailed

getDomains

public String[] getDomains(String host)
                    throws HdbFailed

Description copied from class: HdbReader

Returns the domain list for the specified host.

Specified by:

getDomains in class HdbReader

Throws:

HdbFailed

getFamilies

public String[] getFamilies(String host,
                   String domain)
                     throws HdbFailed

Description copied from class: HdbReader

Returns the family list for the specified host/domain.

Specified by:

getFamilies in class HdbReader

Throws:

HdbFailed

getMembers

public String[] getMembers(String host,
                  String domain,
                  String family)
                    throws HdbFailed

Description copied from class: HdbReader

Returns the member list for the specified host/domain/family.

Specified by:

getMembers in class HdbReader

Throws:

HdbFailed

getNames

public String[] getNames(String host,
                String domain,
                String family,
                String member)
                  throws HdbFailed

Description copied from class: HdbReader

Returns the name list for the specified host/domain/family/member.

Specified by:

getNames in class HdbReader

Throws:

HdbFailed

getSigInfo

public HdbSigInfo getSigInfo(String attName)
                      throws HdbFailed

Description copied from class: HdbReader

Returns signal info

Specified by:

getSigInfo in class HdbReader

Parameters:

attName - The fully qualified tango attribute name (eg: tango://hostname:port/domain/family/member/attname)

Returns:

The signal identifier

Throws:

HdbFailed - In case of failure

getLastParam

public HdbSigParam getLastParam(HdbSigInfo sigInfo)
                         throws HdbFailed

Description copied from class: HdbReader

Return last known configurations of the specified attribute

Specified by:

getLastParam in class HdbReader

Parameters:

sigInfo - Signal info

Returns:

Throws:

HdbFailed

getParams

public ArrayList<HdbSigParam> getParams(String attName,
                               String start_date,
                               String stop_date)
                                 throws HdbFailed

Description copied from class: HdbReader

Return history of configurations of the specified attribute

Specified by:

getParams in class HdbReader

Parameters:

attName - The fully qualified tango attribute name (eg: tango://hostname:port/domain/family/member/attname)

start_date - Beginning of the requested time interval (as string eg: "10/07/2014 10:00:00")

stop_date - End of the requested time interval (as string eg: "10/07/2014 12:00:00")

Returns:

Throws:

HdbFailed

getParams

public ArrayList<HdbSigParam> getParams(HdbSigInfo sigInfo,
                               String start_date,
                               String stop_date)
                                 throws HdbFailed

Specified by:

getParams in class HdbReader

Throws:

HdbFailed

findErrors

public HdbDataSet findErrors(String attName,
                    String start_date,
                    String stop_date)
                      throws HdbFailed

Description copied from class: HdbReader

This method finds the errors occurred inside a time interval for the specified attribute

Specified by:

findErrors in class HdbReader

Parameters:

attName - The fully qualified tango attribute name (eg: tango://hostname:port/domain/family/member/attname)

start_date - Beginning of the requested time interval (as string eg: "10/07/2014 10:00:00")

stop_date - End of the requested time interval (as string eg: "10/07/2014 12:00:00")

Throws:

HdbFailed - In case of failure