com.knowgate.dataxslt.db
Class PageSetDB

java.lang.Object
  com.knowgate.dataobjs.DBPersist
      com.knowgate.dataxslt.db.PageSetDB

All Implemented Interfaces:

java.util.Map

Direct Known Subclasses:

Survey

public class PageSetDB
extends DBPersist

PageSet database index

Nested Class Summary

Nested classes/interfaces inherited from interface java.util.Map

java.util.Map.Entry<K,V>

Field Summary

static short

ClassId

Fields inherited from class com.knowgate.dataobjs.DBPersist

AllVals, sAuditCls, sAuditUsr, sTransactId

Constructor Summary

PageSetDB()

PageSetDB(JDCConnection oConn, java.lang.String sPageSetGUID)

Method Summary

boolean	delete(JDCConnection oConn) Delete a register from database The deleted register will be the one matching this DBPersist primary key, as set at constructor or load() method.
static boolean	delete(JDCConnection oConn, java.lang.String sPageSetGUID)
boolean	existsFile()
static java.lang.String	filePath(JDCConnection oConn, java.lang.String sPageSetGUID) Get relative path to XML data file Relative path is readed from field path_data of table k_pagesets.
boolean	load(JDCConnection oConn, java.lang.Object[] aPK) Load the internal value set from a register at a database table
void	setPage(JDCConnection oConn, java.lang.String sIdPage, int iPgPage, java.lang.String sTlPage, java.lang.String sPathPage)
boolean	store(JDCConnection oConn) Store a register at database representing this instance of DBPersist Insertions and updates : The store method automatically manages register insertions and updates.

Methods inherited from class com.knowgate.dataobjs.DBPersist

allcaps, allcaps, changelog, clear, clone, containsKey, containsValue, entrySet, exists, get, get, getAuditClassName, getCreationDate, getDate, getDateFormated, getDateShort, getDateTime, getDateTime24, getDecimal, getDecimalFormated, getDecimalFormated, getDouble, getDoubleFormated, getFloat, getFloatFormated, getInt, getInteger, getIntervalPart, getItemMap, getItems, getMoney, getShort, getSQLDate, getSQLTime, getString, getStringNull, getTable, getTable, getTableName, getTime, getTimeOfDay, getTimestamp, getUIdFromName, isEmpty, isNull, iterator, keySet, load, parseXML, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, putAll, putAll, remove, remove, replace, replace, replace, replace, replace, replace, replace, setAuditTransact, setAuditUser, size, toLowerCase, toUpperCase, toXML, toXML, toXML, toXML, values

Methods inherited from class java.lang.Object

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

Methods inherited from interface java.util.Map

equals, hashCode

Field Detail

ClassId

public static final short ClassId

See Also:

Constant Field Values

Constructor Detail

PageSetDB

public PageSetDB()

PageSetDB

public PageSetDB(JDCConnection oConn,
                 java.lang.String sPageSetGUID)
          throws java.sql.SQLException

Throws:

java.sql.SQLException

Method Detail

load

public boolean load(JDCConnection oConn,
                    java.lang.Object[] aPK)
             throws java.sql.SQLException

Description copied from class: DBPersist

Load the internal value set from a register at a database table

Overrides:

load in class DBPersist

Parameters:

oConn - Database Connection

aPK - Primary key values in order of appearance

Returns:

true if a register was found, false if no register was found with such primary key.

Throws:

java.sql.SQLException

store

public boolean store(JDCConnection oConn)
              throws java.sql.SQLException

Description copied from class: DBPersist

Store a register at database representing this instance of DBPersist

Insertions and updates : The store method automatically manages register insertions and updates. If the stored object already exists at database then it is updated, if it does not exists then it is inserted. A primary key violation error is never thrown so ther is no need to call delete() method before re-writing an existing object.

NULL fields : All values not set calling put() methods for DBPersist will be assumed to be NULL. If a not nullable field is not set then an SQLException will be raised.
On storing an already existing object all values will we overwrited, so is a DBPersist is not fully loaded before storing it, values not set by calling put() methods that already were present at database will be lost.

Overrides:

store in class DBPersist

Parameters:

oConn - Database Connection

Returns:

boolean true if register was stored for the first time, false if register already existed.

Throws:

java.sql.SQLException

delete

public boolean delete(JDCConnection oConn)
               throws java.sql.SQLException

Description copied from class: DBPersist

Delete a register from database

The deleted register will be the one matching this DBPersist primary key, as set at constructor or load() method.

Overrides:

delete in class DBPersist

Parameters:

oConn - Database connection

Returns:

true if register was successfully erased, false if not.

Throws:

java.sql.SQLException

existsFile

public boolean existsFile()

setPage

public void setPage(JDCConnection oConn,
                    java.lang.String sIdPage,
                    int iPgPage,
                    java.lang.String sTlPage,
                    java.lang.String sPathPage)
             throws java.sql.SQLException

Throws:

java.sql.SQLException

filePath

public static java.lang.String filePath(JDCConnection oConn,
                                        java.lang.String sPageSetGUID)
                                 throws java.sql.SQLException

Get relative path to XML data file

Relative path is readed from field path_data of table k_pagesets.
For example: domains/2049/workareas/c0a801ccf90ee54e40100000ffd3af4f/apps/Mailwire/data/Basic (Dec 8 2003 11.00.01 PM).xml

Parameters:

oConn - Database Connection

sPageSetGUID - GUID of PageSet witch data file relative path is to be retrieved

Returns:

Relative path to XML metadata file or null if no Microsite with such GUID was found at k_microsites table.

Throws:

java.sql.SQLException

delete

public static boolean delete(JDCConnection oConn,
                             java.lang.String sPageSetGUID)
                      throws java.sql.SQLException

Throws:

java.sql.SQLException