java.lang.Object
com.k_int.OpenRequest.helpers.DBHelper
- public class DBHelper
- extends java.lang.Object
Title: DBHelper
|
Field Summary |
private static LoggingContext |
cat
|
|
Method Summary |
static com.k_int.OpenRequest.db.ILLTransactionGroup |
createOrFindExistingTG(com.k_int.OpenRequest.db.Location.Location location,
java.lang.String original_requester,
java.lang.String tgq,
Session session,
com.k_int.OpenRequest.isoill.gen.ISO_10161_ILL_1.ILL_APDU_Base base_info)
|
static com.k_int.OpenRequest.db.StateTransition |
findTransition(Session session,
long model_id,
long current_state_id,
java.lang.String transition)
|
static java.util.List |
getLiveTransactions(Session session,
long location_id)
|
static com.k_int.OpenRequest.db.ILLTransactionGroup |
lookupGAR(Session session,
long id)
|
static com.k_int.OpenRequest.db.Location.LocationSymbol |
lookupLocation(Session session,
java.lang.String auth_symbol)
Look up location symbol information for the supplied string given a specific database session. |
static com.k_int.OpenRequest.db.Location.LocationSymbol |
lookupLocation(Session session,
java.lang.String default_naming_authority,
java.lang.String auth_symbol)
|
static com.k_int.OpenRequest.db.Location.LocationType |
lookupLocationType(Session session,
java.lang.String code)
|
static com.k_int.OpenRequest.db.StateModel |
lookupStateModel(Session session,
java.lang.String code)
|
static com.k_int.OpenRequest.db.StatusCode |
lookupStatusCode(Session session,
java.lang.String code)
|
static com.k_int.OpenRequest.db.ILLTransaction |
lookupTransaction(Session session,
long id)
|
static com.k_int.OpenRequest.db.ILLTransaction |
lookupTransaction(Session session,
long location_id,
java.lang.String initial_requester,
java.lang.String tgq,
java.lang.String tq)
|
static com.k_int.OpenRequest.db.ILLTransaction |
lookupTransaction(Session session,
long location_id,
java.lang.String initial_requester,
java.lang.String tgq,
java.lang.String tq,
java.lang.String stq)
|
| Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
cat
private static LoggingContext cat
DBHelper
public DBHelper()
lookupLocation
public static com.k_int.OpenRequest.db.Location.LocationSymbol lookupLocation(Session session,
java.lang.String auth_symbol)
throws java.sql.SQLException,
cirrus.hibernate.HibernateException
- Look up location symbol information for the supplied string given a specific database session.
Requires:
- A valid Session connection to the ILL Transaction Store Database
- A location symbol in the format "NamingAuthority:LocationSymbol" for example NATLIB:NHATS
Provides:
- An Instance of the java class that acts as a proxy for LocationSymbol objects taken from the
database. From the LocationSymbol you can navigate to the canonical location details and other
information.
lookupLocation
public static com.k_int.OpenRequest.db.Location.LocationSymbol lookupLocation(Session session,
java.lang.String default_naming_authority,
java.lang.String auth_symbol)
throws java.sql.SQLException,
cirrus.hibernate.HibernateException
lookupTransaction
public static com.k_int.OpenRequest.db.ILLTransaction lookupTransaction(Session session,
long id)
throws java.sql.SQLException,
cirrus.hibernate.HibernateException
lookupTransaction
public static com.k_int.OpenRequest.db.ILLTransaction lookupTransaction(Session session,
long location_id,
java.lang.String initial_requester,
java.lang.String tgq,
java.lang.String tq,
java.lang.String stq)
throws HelperException
lookupTransaction
public static com.k_int.OpenRequest.db.ILLTransaction lookupTransaction(Session session,
long location_id,
java.lang.String initial_requester,
java.lang.String tgq,
java.lang.String tq)
throws HelperException
lookupGAR
public static com.k_int.OpenRequest.db.ILLTransactionGroup lookupGAR(Session session,
long id)
throws java.sql.SQLException,
cirrus.hibernate.HibernateException
createOrFindExistingTG
public static com.k_int.OpenRequest.db.ILLTransactionGroup createOrFindExistingTG(com.k_int.OpenRequest.db.Location.Location location,
java.lang.String original_requester,
java.lang.String tgq,
Session session,
com.k_int.OpenRequest.isoill.gen.ISO_10161_ILL_1.ILL_APDU_Base base_info)
throws java.sql.SQLException,
cirrus.hibernate.HibernateException
getLiveTransactions
public static java.util.List getLiveTransactions(Session session,
long location_id)
throws java.sql.SQLException,
cirrus.hibernate.HibernateException
findTransition
public static com.k_int.OpenRequest.db.StateTransition findTransition(Session session,
long model_id,
long current_state_id,
java.lang.String transition)
throws java.sql.SQLException,
cirrus.hibernate.HibernateException
lookupStateModel
public static com.k_int.OpenRequest.db.StateModel lookupStateModel(Session session,
java.lang.String code)
throws java.sql.SQLException,
cirrus.hibernate.HibernateException
lookupStatusCode
public static com.k_int.OpenRequest.db.StatusCode lookupStatusCode(Session session,
java.lang.String code)
throws java.sql.SQLException,
cirrus.hibernate.HibernateException
lookupLocationType
public static com.k_int.OpenRequest.db.Location.LocationType lookupLocationType(Session session,
java.lang.String code)
throws java.sql.SQLException,
cirrus.hibernate.HibernateException