org.openscience.nmrshiftdb.om
Class DBMoleculePeer

java.lang.Object
  org.apache.torque.util.BasePeer
      org.openscience.nmrshiftdb.om.BaseDBMoleculePeer
          org.openscience.nmrshiftdb.om.DBMoleculePeer

All Implemented Interfaces:

java.io.Serializable

public class DBMoleculePeer
extends BaseDBMoleculePeer

You should add additional methods to this class to meet the application requirements. This class will only be generated as long as it does not already exist in the output directory.

Author:

shk3

See Also:

Serialized Form

Field Summary

Fields inherited from class org.openscience.nmrshiftdb.om.BaseDBMoleculePeer

CAS_NUMBER, CLASS_DEFAULT, CLASSNAME_DEFAULT, COMMENT, DATABASE_NAME, DATE, DBE, FP0, FP1, FP10, FP11, FP12, FP13, FP14, FP15, FP2, FP3, FP4, FP5, FP6, FP7, FP8, FP9, MOLECULAR_WEIGHT, MOLECULE_ID, numColumns, SAR, SMILES_STRING, SMILES_STRING_CHIRAL, SSSR, TABLE_NAME, USER_ID

Fields inherited from class org.apache.torque.util.BasePeer

DEFAULT_MAP_BUILDER, IGNORE_CASE, log, ORDER_BY

Constructor Summary

DBMoleculePeer()

Method Summary

static java.util.List	doSelectByChemicalName(java.lang.String chemName) Method returns molecules with a certain chemical name and at least one spectrum reviewed as true.
static DBMolecule	doSelectByInchi(java.lang.String inchi) Method returns molecules with a certain smiles and at least one spectrum reviewed as true.
static java.util.List	doSelectBySmiles(java.lang.String smiles, java.lang.String smilesChiral, boolean unequal) Method returns molecules with a certain smiles and at least one spectrum reviewed as true.

Methods inherited from class org.openscience.nmrshiftdb.om.BaseDBMoleculePeer

addSelectColumns, buildCriteria, buildCriteria, doDelete, doDelete, doDelete, doDelete, doDelete, doDelete, doInsert, doInsert, doInsert, doInsert, doSelect, doSelect, doSelect, doSelectJoinNmrshiftdbUser, doSelectVillageRecords, doSelectVillageRecords, doUpdate, doUpdate, doUpdate, doUpdate, getMapBuilder, getOMClass, getTableMap, populateObject, populateObjects, resultSet2Objects, retrieveByPK, retrieveByPK, retrieveByPK, retrieveByPKs, retrieveByPKs, row2Object

Methods inherited from class org.apache.torque.util.BasePeer

createPreparedStatement, createQueryString, deleteAll, deleteAll, doPSSelect, doPSSelect, doUpdate, doUpdate, executeQuery, executeQuery, executeQuery, executeQuery, executeQuery, executeQuery, executeStatement, executeStatement, executeStatement, getMapBuilder, getSelectResults, getSelectResults, getSelectResults, getSelectResults, handleMultipleRecords, hashtableToByteArray, initColumnNames, initCriteriaKeys, initTableColumns, initTableSchema, initTableSchema

Methods inherited from class java.lang.Object

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

Constructor Detail

DBMoleculePeer

public DBMoleculePeer()

Method Detail

doSelectByChemicalName

public static java.util.List doSelectByChemicalName(java.lang.String chemName)
                                             throws java.lang.Exception

Method returns molecules with a certain chemical name and at least one spectrum reviewed as true.

Parameters:

chemName - The chemical name.

Returns:

A vector of DBMolecules.

Throws:

java.lang.Exception - Something wrong with the DB.

doSelectByInchi

public static DBMolecule doSelectByInchi(java.lang.String inchi)
                                  throws java.lang.Exception

Method returns molecules with a certain smiles and at least one spectrum reviewed as true.

Parameters:

smiles - The smiles.

smilesChiral - The chiral smiles.

unequal - true=choose spectra with other chiral smiles, false=same chiral smiles.

Returns:

A vector of DBMolecules.

Throws:

java.lang.Exception - Something wrong with the DB.

doSelectBySmiles

public static java.util.List doSelectBySmiles(java.lang.String smiles,
                                              java.lang.String smilesChiral,
                                              boolean unequal)
                                       throws java.lang.Exception

Method returns molecules with a certain smiles and at least one spectrum reviewed as true.

Parameters:

smiles - The smiles.

smilesChiral - The chiral smiles.

unequal - true=choose spectra with other chiral smiles, false=same chiral smiles.

Returns:

A vector of DBMolecules.

Throws:

java.lang.Exception - Something wrong with the DB.