fr.profi.mzdb.io.reader

Class MzDbReaderQueries

java.lang.Object

fr.profi.mzdb.io.reader.MzDbReaderQueries

public class MzDbReaderQueries
extends Object

Allows to manipulates data contained in the mzDB file.

Author:

David

Constructor Summary

Constructors

Constructor and Description
MzDbReaderQueries()

Method Summary

Modifier and Type	Method and Description
static byte[]	getBoundingBoxData(int bbId, com.almworks.sqlite4java.SQLiteConnection connection) Gets the bounding box data.
static int	getBoundingBoxesCount(int runSliceId, com.almworks.sqlite4java.SQLiteConnection connection) Gets the bounding box count.
static int	getBoundingBoxesCount(com.almworks.sqlite4java.SQLiteConnection connection) Gets the bounding box count.
static long	getBoundingBoxFirstSpectrumId(long spectrumId, com.almworks.sqlite4java.SQLiteConnection connection) Gets the bounding box first spectrum index.
static float	getBoundingBoxMinMz(int bbId, com.almworks.sqlite4java.SQLiteConnection connection) Gets the bounding box min mz.
static float	getBoundingBoxMinTime(int bbId, com.almworks.sqlite4java.SQLiteConnection connection) Gets the bounding box min time.
static int	getBoundingBoxMsLevel(int bbId, com.almworks.sqlite4java.SQLiteConnection connection) Gets the bounding box ms level.
static int	getCyclesCount(com.almworks.sqlite4java.SQLiteConnection connection) Gets the cycle count.
static int	getDataEncodingsCount(com.almworks.sqlite4java.SQLiteConnection connection) Gets the data encoding count.
static float	getLastTime(com.almworks.sqlite4java.SQLiteConnection connection) Gets the last time.
static int	getMaxMsLevel(com.almworks.sqlite4java.SQLiteConnection connection) Gets the max ms level.
static String	getModelVersion(com.almworks.sqlite4java.SQLiteConnection connection)
static int[]	getMzRange(int msLevel, com.almworks.sqlite4java.SQLiteConnection connection) Gets the mz range.
static String	getPwizMzDbVersion(com.almworks.sqlite4java.SQLiteConnection connection)
static int	getRunSlicesCount(com.almworks.sqlite4java.SQLiteConnection connection) Gets the run slice count.
static int	getSpectraCount(int msLevel, com.almworks.sqlite4java.SQLiteConnection connection) Gets the spectra count for a given MS level.
static int	getSpectraCount(com.almworks.sqlite4java.SQLiteConnection connection) Gets the spectra count.
static int	getTableRecordsCount(String tableName, com.almworks.sqlite4java.SQLiteConnection connection) Gets the table records count.

Methods inherited from class java.lang.Object

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

Constructor Detail

MzDbReaderQueries

public MzDbReaderQueries()

Method Detail

getModelVersion

public static String getModelVersion(com.almworks.sqlite4java.SQLiteConnection connection)
                              throws com.almworks.sqlite4java.SQLiteException

Returns:

Throws:

com.almworks.sqlite4java.SQLiteException

getPwizMzDbVersion

public static String getPwizMzDbVersion(com.almworks.sqlite4java.SQLiteConnection connection)
                                 throws com.almworks.sqlite4java.SQLiteException

Throws:

com.almworks.sqlite4java.SQLiteException

getLastTime

public static float getLastTime(com.almworks.sqlite4java.SQLiteConnection connection)
                         throws com.almworks.sqlite4java.SQLiteException

Gets the last time.

Returns:

float the rt of the last spectrum

Throws:

com.almworks.sqlite4java.SQLiteException - the sQ lite exception

getMaxMsLevel

public static int getMaxMsLevel(com.almworks.sqlite4java.SQLiteConnection connection)
                         throws com.almworks.sqlite4java.SQLiteException

Gets the max ms level.

Returns:

the max ms level

Throws:

com.almworks.sqlite4java.SQLiteException - the sQ lite exception

getMzRange

public static int[] getMzRange(int msLevel,
                               com.almworks.sqlite4java.SQLiteConnection connection)
                        throws com.almworks.sqlite4java.SQLiteException

Gets the mz range.

Parameters:

msLevel - the ms level

Returns:

runSlice min mz and runSlice max mz

Throws:

com.almworks.sqlite4java.SQLiteException - the sQ lite exception

getBoundingBoxesCount

public static int getBoundingBoxesCount(com.almworks.sqlite4java.SQLiteConnection connection)
                                 throws com.almworks.sqlite4java.SQLiteException

Gets the bounding box count.

Returns:

int, the number of bounding box

Throws:

com.almworks.sqlite4java.SQLiteException - the sQ lite exception

getBoundingBoxesCount

public static int getBoundingBoxesCount(int runSliceId,
                                        com.almworks.sqlite4java.SQLiteConnection connection)
                                 throws com.almworks.sqlite4java.SQLiteException

Gets the bounding box count.

Parameters:

runSliceId - the run slice id

Returns:

the number of bounding box contained in the specified runSliceId

Throws:

com.almworks.sqlite4java.SQLiteException - the sQ lite exception

getCyclesCount

public static int getCyclesCount(com.almworks.sqlite4java.SQLiteConnection connection)
                          throws com.almworks.sqlite4java.SQLiteException

Gets the cycle count.

Returns:

the cycle count

Throws:

com.almworks.sqlite4java.SQLiteException

getDataEncodingsCount

public static int getDataEncodingsCount(com.almworks.sqlite4java.SQLiteConnection connection)
                                 throws com.almworks.sqlite4java.SQLiteException

Gets the data encoding count.

Returns:

the data encoding count

Throws:

com.almworks.sqlite4java.SQLiteException - the sQ lite exception

getSpectraCount

public static int getSpectraCount(com.almworks.sqlite4java.SQLiteConnection connection)
                           throws com.almworks.sqlite4java.SQLiteException

Gets the spectra count.

Returns:

int the number of spectra

Throws:

com.almworks.sqlite4java.SQLiteException - the sQ lite exception

getSpectraCount

public static int getSpectraCount(int msLevel,
                                  com.almworks.sqlite4java.SQLiteConnection connection)
                           throws com.almworks.sqlite4java.SQLiteException

Gets the spectra count for a given MS level.

Returns:

int the number of spectra

Throws:

com.almworks.sqlite4java.SQLiteException - the SQLite exception

getRunSlicesCount

public static int getRunSlicesCount(com.almworks.sqlite4java.SQLiteConnection connection)
                             throws com.almworks.sqlite4java.SQLiteException

Gets the run slice count.

Returns:

int the number of runSlice

Throws:

com.almworks.sqlite4java.SQLiteException - the sQ lite exception

getTableRecordsCount

public static int getTableRecordsCount(String tableName,
                                       com.almworks.sqlite4java.SQLiteConnection connection)
                                throws com.almworks.sqlite4java.SQLiteException

Gets the table records count.

Parameters:

tableName - the table name

Returns:

the int

Throws:

com.almworks.sqlite4java.SQLiteException - the sQ lite exception

getBoundingBoxData

public static byte[] getBoundingBoxData(int bbId,
                                        com.almworks.sqlite4java.SQLiteConnection connection)
                                 throws com.almworks.sqlite4java.SQLiteException

Gets the bounding box data.

Parameters:

bbId - the bb id

Returns:

the bounding box data

Throws:

com.almworks.sqlite4java.SQLiteException - the sQ lite exception

getBoundingBoxFirstSpectrumId

public static long getBoundingBoxFirstSpectrumId(long spectrumId,
                                                 com.almworks.sqlite4java.SQLiteConnection connection)
                                          throws com.almworks.sqlite4java.SQLiteException

Gets the bounding box first spectrum index.

Parameters:

spectrumId - the spectrum id

Returns:

the bounding box first spectrum index

Throws:

com.almworks.sqlite4java.SQLiteException - the sQ lite exception

getBoundingBoxMinMz

public static float getBoundingBoxMinMz(int bbId,
                                        com.almworks.sqlite4java.SQLiteConnection connection)
                                 throws com.almworks.sqlite4java.SQLiteException

Gets the bounding box min mz.

Parameters:

bbId - the bb id

Returns:

the bounding box min mz

Throws:

com.almworks.sqlite4java.SQLiteException - the sQ lite exception

getBoundingBoxMinTime

public static float getBoundingBoxMinTime(int bbId,
                                          com.almworks.sqlite4java.SQLiteConnection connection)
                                   throws com.almworks.sqlite4java.SQLiteException

Gets the bounding box min time.

Parameters:

bbId - the bb id

Returns:

the bounding box min time

Throws:

com.almworks.sqlite4java.SQLiteException - the sQ lite exception

getBoundingBoxMsLevel

public static int getBoundingBoxMsLevel(int bbId,
                                        com.almworks.sqlite4java.SQLiteConnection connection)
                                 throws com.almworks.sqlite4java.SQLiteException

Gets the bounding box ms level.

Parameters:

bbId - the bb id

Returns:

the bounding box ms level

Throws:

com.almworks.sqlite4java.SQLiteException - the sQ lite exception