de.unibayreuth.bayceer.bayeos.xmlrpc.handler.inf

Interface IMassenTableHandler

public interface IMassenTableHandler

Manage timeseries based measurement value (secured)

Author:

oliver

Method Summary

Methods

Modifier and Type	Method and Description
java.lang.Boolean	addByteRows(byte[] b) Add multiple measurements as a byte array, existing records with same sampling time and series id are skipped
java.lang.Boolean	addRow(java.lang.Integer id, java.util.Date von, java.lang.Double wert, java.lang.Integer status) Add one row to a series.
java.util.Vector	getMatrix(java.util.Vector ids, java.util.Vector timeFilter, java.util.Vector statusFilter, java.lang.Boolean withStatus) Get Matrix of series values
java.util.Vector	getRows(java.lang.Integer id, java.util.Vector timeFilter, java.util.Vector statusFilter) Get rows of a series by status and time filter definition
java.lang.Boolean	importById(java.util.Hashtable values) Import many measurements grouped by series identifier
java.lang.Boolean	importByTime(java.util.Hashtable values) Import many measurements grouped by time
java.lang.Boolean	importFlat(java.lang.Integer Id, java.util.Vector rows, boolean shortCols) Import a Vector of time value pairs into one series
java.lang.Boolean	removeAllRows(java.lang.Integer id) Remove all measurement values
java.lang.Boolean	removeRows(java.lang.Integer id, java.util.Vector vonDates) Remove many rows of a series by sampling date.
java.lang.Boolean	removeRowsByInterval(java.lang.Integer id, java.util.Date startDate, java.util.Date endDate) Remove many rows of a series by date interval.
java.lang.Boolean	updateRow(java.lang.Integer id, java.util.Date old_von, java.lang.Integer statId, java.lang.Double wert, java.util.Date new_von) Update one row of a series.
java.lang.Boolean	updateRows(java.lang.Integer id, java.util.Vector vonDates, java.lang.Integer statId) Update status flag of several rows of a series.
java.lang.Boolean	upsertByteRows(byte[] b) Add multiple measurements as a byte array, existing records with same sampling time and series id are updated

Method Detail

addByteRows

java.lang.Boolean addByteRows(byte[] b)
                              throws org.apache.xmlrpc.XmlRpcException

Add multiple measurements as a byte array, existing records with same sampling time and series id are skipped

Parameters:

b - byte array composed of

1. series id as four bytes integer, high byte first
2. sampling time in number of milliseconds since January 1, 1970, 00:00:00 GM as eight bytes long, high byte first.
3. measurement value as 4-byte float quantity according to the IEEE 754 floating-point "single format" bit layout

Returns:

Boolean

Throws:

org.apache.xmlrpc.XmlRpcException

Since:

1.7

See Also:

floatToRawIntBits

upsertByteRows

java.lang.Boolean upsertByteRows(byte[] b)
                                 throws org.apache.xmlrpc.XmlRpcException

Add multiple measurements as a byte array, existing records with same sampling time and series id are updated

Parameters:

b - byte array composed of

1. series id as four bytes integer, high byte first
2. sampling time in number of milliseconds since January 1, 1970, 00:00:00 GM as eight bytes long, high byte first.
3. measurement value as 4-byte float quantity according to the IEEE 754 floating-point "single format" bit layout

Returns:

Boolean

Throws:

org.apache.xmlrpc.XmlRpcException

Since:

1.8

See Also:

floatToRawIntBits

addRow

java.lang.Boolean addRow(java.lang.Integer id,
                       java.util.Date von,
                       java.lang.Double wert,
                       java.lang.Integer status)
                         throws org.apache.xmlrpc.XmlRpcException

Add one row to a series.

Parameters:

id - series identifier

von - sampling time

wert - measurement value

status - quality tag of measurement value

Returns:

success

Throws:

org.apache.xmlrpc.XmlRpcException

See Also:

ILookUpTableHandler.getStatus()

updateRow

java.lang.Boolean updateRow(java.lang.Integer id,
                          java.util.Date old_von,
                          java.lang.Integer statId,
                          java.lang.Double wert,
                          java.util.Date new_von)
                            throws org.apache.xmlrpc.XmlRpcException

Update one row of a series.

Parameters:

id - series identifier

old_von - old sampling time

statId - status quality tag of measurement value

wert - measurement value

new_von - new sampling time

Returns:

success

Throws:

org.apache.xmlrpc.XmlRpcException

See Also:

ILookUpTableHandler.getStatus()

updateRows

java.lang.Boolean updateRows(java.lang.Integer id,
                           java.util.Vector vonDates,
                           java.lang.Integer statId)
                             throws org.apache.xmlrpc.XmlRpcException

Update status flag of several rows of a series.

Parameters:

id - series identifier

vonDates - sampling times

statId - status quality tag of measurement values

Returns:

success

Throws:

org.apache.xmlrpc.XmlRpcException

See Also:

ILookUpTableHandler.getStatus()

removeRows

java.lang.Boolean removeRows(java.lang.Integer id,
                           java.util.Vector vonDates)
                             throws org.apache.xmlrpc.XmlRpcException

Remove many rows of a series by sampling date.

Parameters:

id - series id

vonDates - Vector of Date

Returns:

success

Throws:

org.apache.xmlrpc.XmlRpcException

removeRowsByInterval

java.lang.Boolean removeRowsByInterval(java.lang.Integer id,
                                     java.util.Date startDate,
                                     java.util.Date endDate)
                                       throws org.apache.xmlrpc.XmlRpcException

Remove many rows of a series by date interval.

Parameters:

id - series id

startDate - Date of first measurement

endDate - Date of last measurement

Returns:

success

Throws:

org.apache.xmlrpc.XmlRpcException

Since:

1.7

getRows

java.util.Vector getRows(java.lang.Integer id,
                       java.util.Vector timeFilter,
                       java.util.Vector statusFilter)
                         throws org.apache.xmlrpc.XmlRpcException

Get rows of a series by status and time filter definition

Parameters:

id -

timeFilter - vector of values

1. start as Date
2. end as Date

statusFilter - vector of status values as int

Returns:

vector composed of two elements

1. vector of column metadata
2. vector of row values, a row is composed as a 9 byte array:

   [0,3] sampling time in number of milliseconds since January 1, 1970, 00:00:00 GM /1000 as int

   [4,8] value as float

   [9] status as short

element 1 is a byte array composed of rows, byte array format: Sampling Time/1000 as Integer, measurement value as Float, status quality flag as Byte

Throws:

org.apache.xmlrpc.XmlRpcException

See Also:

ILookUpTableHandler.getStatus()

importById

java.lang.Boolean importById(java.util.Hashtable values)
                             throws org.apache.xmlrpc.XmlRpcException

Import many measurements grouped by series identifier

Parameters:

values - hashtable with series identifier as key and Array of Strings as values. A value is composed of sampling time, quality flag and measurement value in the following format: DD.MM.YYYY hh:mm:ss;##;####.###

Sample XML Request:

 <?xml version="1.0"?>
 <methodCall>
 <methodName>MassenTableHandler.importById</methodName>
 <params>
  <param>
  <value>
   <struct>
   	<member><name>17845</name>
   	<value><array><data>
   	<value>17.06.2002 11:10:00;00;12.0</value>
   	<value>01.03.2003 12:00:00;0;13766.7941930617</value>
   	<value>01.03.2003 12:05:00;7;5634.50514870746</value>
   	<value>01.03.2003 12:10:00;6;16467.3786470724</value>
   	</data></array></value>
   	</member>
    </struct>
   </value>
  </param>
 </params>
 </methodCall>
 
 

Returns:

success

Throws:

org.apache.xmlrpc.XmlRpcException

importByTime

java.lang.Boolean importByTime(java.util.Hashtable values)
                               throws org.apache.xmlrpc.XmlRpcException

Import many measurements grouped by time

Parameters:

values - hashtable with sampling time as as key and array of Strings as values, a key is a String value of sampling time formated by DD.MM.YYYY hh:mm:ss.

a value is composed of series id, quality flag and measurement value separated by semicolon

Sample XML Request:

 <?xml version="1.0"?>
 <methodCall>
 <methodName>MassenTableHandler.importByTime</methodName>
 <params>
  <param><value><struct>
   <member><name>17.06.2002 11:10:00</name>
    <value><array><data>
     <value>14478;00;0.00</value>
     <value>14479;00;0.00</value>
     <value>14480;00;0.00</value>
     <value>2701;00;0.00</value>
     </data></array>
    </value>
   </member>
   <member><name>17.06.2002 11:20:00</name>
    <value><array><data>
     <value>14478;00;12.88</value>
     <value>14479;00;13.73</value>
     <value>14480;00;11.78</value>
     <value>14481;00;9.98</value>
     <value>2701;00;39.49</value>
    </data></array></value>
   </member>
  </struct></value></param>
 </params>
 </methodCall>
 
 

Returns:

success

Throws:

org.apache.xmlrpc.XmlRpcException

removeAllRows

java.lang.Boolean removeAllRows(java.lang.Integer id)
                                throws org.apache.xmlrpc.XmlRpcException

Remove all measurement values

Parameters:

id - series identifier

Returns:

Boolean

Throws:

org.apache.xmlrpc.XmlRpcException

Since:

1.7

getMatrix

java.util.Vector getMatrix(java.util.Vector ids,
                         java.util.Vector timeFilter,
                         java.util.Vector statusFilter,
                         java.lang.Boolean withStatus)
                           throws org.apache.xmlrpc.XmlRpcException

Get Matrix of series values

Parameters:

ids - vector of series identifiers as int

timeFilter - vector of values

1. start as Date
2. end as Date

statusFilter - vector of status values as int

withStatus - flag to export status information

Returns:

vector

Throws:

org.apache.xmlrpc.XmlRpcException

Since:

1.7

importFlat

java.lang.Boolean importFlat(java.lang.Integer Id,
                           java.util.Vector rows,
                           boolean shortCols)
                             throws org.apache.xmlrpc.XmlRpcException

Import a Vector of time value pairs into one series

Parameters:

Id - series id

rows - vector of Strings

shortCols - format flag; true:short vector row format -> [timestamp;value] as [DD.MM.YYYY hh:mm:ss;%f] false:long vector row format -> [timestamp;value;status] as [DD.MM.YYYY hh:mm:ss;%f;%d]

Returns:

Boolean

Throws:

org.apache.xmlrpc.XmlRpcException