jp.ac.tokushima_u.db.logistics

Class ExtRDB

java.lang.Object

jp.ac.tokushima_u.db.common.SharableResource

jp.ac.tokushima_u.db.common.PgRDB

jp.ac.tokushima_u.db.logistics.ExtRDB

public class ExtRDB
extends PgRDB

Handle RDB data retrieved from External Database.

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	ExtRDB.CommonValues
static class	ExtRDB.ExtRDBColumn
static class	ExtRDB.ExtRDBTable

Nested classes/interfaces inherited from class jp.ac.tokushima_u.db.common.PgRDB

PgRDB.Cluster<R extends PgRDB>, PgRDB.Column, PgRDB.Condition, PgRDB.DeleteInsert, PgRDB.Exists, PgRDB.Fields, PgRDB.From, PgRDB.GroupBy, PgRDB.Limit, PgRDB.Logic, PgRDB.NotExists, PgRDB.OrderBy, PgRDB.Phrase, PgRDB.RDBCreator<R>, PgRDB.Select, PgRDB.SQLPhrase, PgRDB.SQLText, PgRDB.Table, PgRDB.Value, PgRDB.Where, PgRDB.Word

Field Summary

Fields

Modifier and Type	Field and Description
static PgRDB.Column	c_age milliseconds from epoch at register on RDB
static PgRDB.Column	c_retr milliseconds from epoch at retrieved from external database

Fields inherited from class jp.ac.tokushima_u.db.common.PgRDB

connection, CT_Boolean, CT_Double, CT_Integer, CT_Long, CT_Real, CT_String, PG_TABLES, PG_TABLES_tablename, PgTables, PgTables_tablename

Constructor Summary

Constructors

Constructor and Description
ExtRDB(String url)

Method Summary

Modifier and Type	Method and Description
protected static Collection<PgRDB.Value>	addCommonValues(long now, long retr, Collection<PgRDB.Value> values) Add common column values
static UTLF	extrdbRetrieveContentAsEncapsulatedUTLF(UTLFId id, String title, ExtRDB.ExtRDBTable table, PgRDB.Column c_content, PgRDB.Condition condition, String mimetype, String scope) ExtRDBからコンテンツを得る．

Methods inherited from class jp.ac.tokushima_u.db.common.PgRDB

close, count, count, createCluster, createIndex, createIndex, createTable, createTable, deleteAndInsert, deleteAndInsert, deleteAndMultipleInsert, deleteFrom, deleteFrom, dropTable, executeBatch, executeBatch, executeCommandOutsideOfTransaction, exists, getConnection, getRDB, grantTableTo, insertInto, insertInto, isAvailable, literalToTextArray, max, min, multipleDeleteAndInsert, multipleInsertInto, open, printSQLError, printSQLError, select, select, select1, select1, select1row, select1row, textToLiteral, textToLiteral, textToLiteral, vacuum, vacuum

Methods inherited from class jp.ac.tokushima_u.db.common.SharableResource

idlingTime, isReserved, isReservedByMe, release, renew, reserve, tryReserve

Methods inherited from class java.lang.Object

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

Field Detail

c_age

public static PgRDB.Column c_age

milliseconds from epoch at register on RDB

c_retr

public static PgRDB.Column c_retr

milliseconds from epoch at retrieved from external database

Constructor Detail

ExtRDB

public ExtRDB(String url)

Method Detail

addCommonValues

protected static Collection<PgRDB.Value> addCommonValues(long now,
                                                         long retr,
                                                         Collection<PgRDB.Value> values)

Add common column values

Parameters:

now - registration timestamp (milliseconds from epoch).

retr - retrieval timestamp (milliseconds from epoch).

values - table specific values.

Returns:

collection of values added common column values.

extrdbRetrieveContentAsEncapsulatedUTLF

public static UTLF extrdbRetrieveContentAsEncapsulatedUTLF(UTLFId id,
                                                           String title,
                                                           ExtRDB.ExtRDBTable table,
                                                           PgRDB.Column c_content,
                                                           PgRDB.Condition condition,
                                                           String mimetype,
                                                           String scope)

ExtRDBからコンテンツを得る．

Parameters:

id - UTLFのId

title - UTLFのタイトル

table - ExtRDBのテーブル

c_content - ExtRDBのカラム

condition - ExtRDBのレコードの条件式

mimetype - コンテンツのMimeType

scope - コンテンツのスコープ

Returns:

Encapsulated UTLF