jp.ac.tokushima_u.db.common

Class PgRDB

java.lang.Object

jp.ac.tokushima_u.db.common.SharableResource

jp.ac.tokushima_u.db.common.PgRDB

Direct Known Subclasses:

ErdRDB, ExtRDB, T73RDB

public class PgRDB
extends SharableResource

Class for Accessing to PostgreSQL Server. $Id: PgRDB.java,v 1.39 2022/10/19 05:57:58 alex Exp $

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	PgRDB.Cluster<R extends PgRDB>
static class	PgRDB.Column
static class	PgRDB.Condition
static class	PgRDB.DeleteInsert
static class	PgRDB.Exists
static class	PgRDB.Fields
static class	PgRDB.From
static class	PgRDB.GroupBy
static class	PgRDB.Limit
static class	PgRDB.Logic
static class	PgRDB.NotExists
static class	PgRDB.OrderBy
protected static class	PgRDB.Phrase
static interface	PgRDB.RDBCreator<R>
static class	PgRDB.Select
static interface	PgRDB.SQLPhrase
static interface	PgRDB.SQLText
static class	PgRDB.Table
static class	PgRDB.Value
static class	PgRDB.Where
static class	PgRDB.Word

Field Summary

Fields

Modifier and Type	Field and Description
protected Connection	connection
static String	CT_Boolean
static String	CT_Double
static String	CT_Integer
static String	CT_Long
static String	CT_Real
static String	CT_String
(package private) String	database_url
protected static String	PG_TABLES
protected static String	PG_TABLES_tablename
protected static PgRDB.Table	PgTables
protected static PgRDB.Column	PgTables_tablename

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

renewRequested

Constructor Summary

Constructors

Constructor and Description
PgRDB(String url)

Method Summary

Modifier and Type	Method and Description
void	close() Close resource (free resource).
int	count(PgRDB.From table, PgRDB.Where where)
int	count(PgRDB.Table table)
static <R extends PgRDB> PgRDB.Cluster<R>	createCluster(PgRDB.RDBCreator<R> creator, String url, int num, long ttp)
String	createIndex(PgRDB.Table table, boolean unique, PgRDB.Column... columns)
String	createIndex(PgRDB.Table table, PgRDB.Column ct, boolean unique)
void	createTable(PgRDB.Table table, Collection<PgRDB.Column> columns)
void	createTable(PgRDB.Table table, PgRDB.Column... columns)
void	deleteAndInsert(PgRDB.Table table, PgRDB.Where where, Collection<PgRDB.Value> cvs)
void	deleteAndInsert(PgRDB.Table table, PgRDB.Where where, PgRDB.Value... cvs)
void	deleteAndMultipleInsert(PgRDB.Table table, PgRDB.Where where, Collection<? extends Collection<PgRDB.Value>> cvss)
void	deleteFrom(PgRDB.Table table)
void	deleteFrom(PgRDB.Table table, PgRDB.Where where)
void	dropTable(PgRDB.Table table)
boolean	executeBatch(CharSequence... cmds)
boolean	executeBatch(List<CharSequence> cmds)
(package private) boolean	executeCommand(CharSequence cmd)
boolean	executeCommandOutsideOfTransaction(CharSequence cmd)
boolean	exists(PgRDB.Table table)
Connection	getConnection()
protected PgRDB	getRDB()
void	grantTableTo(PgRDB.Table table, String privilege, String to)
void	insertInto(PgRDB.Table table, Collection<PgRDB.Value> cvs)
void	insertInto(PgRDB.Table table, PgRDB.Value... cvs)
boolean	isAvailable() Resource is already ready to be used.
String	max(PgRDB.Column c, PgRDB.Table table)
String	min(PgRDB.Column c, PgRDB.Table table)
void	multipleDeleteAndInsert(PgRDB.Table table, Collection<PgRDB.DeleteInsert> delins)
void	multipleInsertInto(PgRDB.Table table, Collection<Collection<PgRDB.Value>> cvss)
boolean	open() Open resource (setup ready to be used).
static void	printSQLError(PrintStream err, String n, SQLException ex)
static void	printSQLError(PrintWriter err, String n, SQLException ex)
List<List<String>>	select(CharSequence query)
List<List<String>>	select(PgRDB.SQLPhrase... phrases)
List<String>	select1(CharSequence query)
List<String>	select1(PgRDB.SQLPhrase... phrases)
List<String>	select1row(CharSequence query) Select single-row (find first) and multi-fields
List<String>	select1row(PgRDB.SQLPhrase... phrases) Select single-row (find first) and multi-fields
protected static String	textToLiteral(String s)
protected static String	textToLiteral(String[] s)
protected String	textToLiteral(URI uri)
boolean	vacuum()
boolean	vacuum(PgRDB.Table table)

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

PG_TABLES

protected static final String PG_TABLES

See Also:

Constant Field Values

PgTables

protected static final PgRDB.Table PgTables

PG_TABLES_tablename

protected static final String PG_TABLES_tablename

See Also:

Constant Field Values

PgTables_tablename

protected static final PgRDB.Column PgTables_tablename

database_url

String database_url

connection

protected Connection connection

CT_Integer

public static final String CT_Integer

See Also:

Constant Field Values

CT_Long

public static final String CT_Long

See Also:

Constant Field Values

CT_Real

public static final String CT_Real

See Also:

Constant Field Values

CT_Double

public static final String CT_Double

See Also:

Constant Field Values

CT_String

public static final String CT_String

See Also:

Constant Field Values

CT_Boolean

public static final String CT_Boolean

See Also:

Constant Field Values

Constructor Detail

PgRDB

public PgRDB(String url)

Method Detail

getRDB

protected PgRDB getRDB()

getConnection

public Connection getConnection()

open

public boolean open()

Open resource (setup ready to be used).

Specified by:

open in class SharableResource

Returns:

success to ready to be used.

close

public void close()

Close resource (free resource).

Specified by:

close in class SharableResource

isAvailable

public boolean isAvailable()

Resource is already ready to be used.

Specified by:

isAvailable in class SharableResource

Returns:

is available.

textToLiteral

protected static String textToLiteral(String s)

textToLiteral

protected String textToLiteral(URI uri)

textToLiteral

protected static String textToLiteral(String[] s)

executeCommand

boolean executeCommand(CharSequence cmd)
                throws SQLException

Throws:

SQLException

executeCommandOutsideOfTransaction

public boolean executeCommandOutsideOfTransaction(CharSequence cmd)
                                           throws SQLException

Throws:

SQLException

executeBatch

public boolean executeBatch(CharSequence... cmds)
                     throws SQLException

Throws:

SQLException

executeBatch

public boolean executeBatch(List<CharSequence> cmds)
                     throws SQLException

Throws:

SQLException

vacuum

public boolean vacuum()
               throws SQLException

Throws:

SQLException

vacuum

public boolean vacuum(PgRDB.Table table)
               throws SQLException

Throws:

SQLException

exists

public boolean exists(PgRDB.Table table)
               throws SQLException

Throws:

SQLException

createTable

public void createTable(PgRDB.Table table,
                        Collection<PgRDB.Column> columns)
                 throws SQLException

Throws:

SQLException

createTable

public void createTable(PgRDB.Table table,
                        PgRDB.Column... columns)
                 throws SQLException

Throws:

SQLException

dropTable

public void dropTable(PgRDB.Table table)
               throws SQLException

Throws:

SQLException

grantTableTo

public void grantTableTo(PgRDB.Table table,
                         String privilege,
                         String to)
                  throws SQLException

Throws:

SQLException

createIndex

public String createIndex(PgRDB.Table table,
                          PgRDB.Column ct,
                          boolean unique)
                   throws SQLException

Throws:

SQLException

createIndex

public String createIndex(PgRDB.Table table,
                          boolean unique,
                          PgRDB.Column... columns)
                   throws SQLException

Throws:

SQLException

select

public List<List<String>> select(CharSequence query)
                          throws SQLException

Throws:

SQLException

select

public List<List<String>> select(PgRDB.SQLPhrase... phrases)
                          throws SQLException

Throws:

SQLException

select1row

public List<String> select1row(CharSequence query)
                        throws SQLException

Select single-row (find first) and multi-fields

Parameters:

query - query

Returns:

List of result strings. If row was not found, return null.

Throws:

SQLException - Error

select1row

public List<String> select1row(PgRDB.SQLPhrase... phrases)
                        throws SQLException

Select single-row (find first) and multi-fields

Parameters:

phrases - query phrases

Returns:

List of result strings. If row was not found, return null.

Throws:

SQLException - Error

select1

public List<String> select1(CharSequence query)
                     throws SQLException

Throws:

SQLException

select1

public List<String> select1(PgRDB.SQLPhrase... phrases)
                     throws SQLException

Throws:

SQLException

count

public int count(PgRDB.From table,
                 PgRDB.Where where)
          throws SQLException

Throws:

SQLException

count

public int count(PgRDB.Table table)
          throws SQLException

Throws:

SQLException

max

public String max(PgRDB.Column c,
                  PgRDB.Table table)
           throws SQLException

Throws:

SQLException

min

public String min(PgRDB.Column c,
                  PgRDB.Table table)
           throws SQLException

Throws:

SQLException

insertInto

public void insertInto(PgRDB.Table table,
                       Collection<PgRDB.Value> cvs)
                throws SQLException

Throws:

SQLException

insertInto

public void insertInto(PgRDB.Table table,
                       PgRDB.Value... cvs)
                throws SQLException

Throws:

SQLException

multipleInsertInto

public void multipleInsertInto(PgRDB.Table table,
                               Collection<Collection<PgRDB.Value>> cvss)
                        throws SQLException

Throws:

SQLException

deleteFrom

public void deleteFrom(PgRDB.Table table,
                       PgRDB.Where where)
                throws SQLException

Throws:

SQLException

deleteFrom

public void deleteFrom(PgRDB.Table table)
                throws SQLException

Throws:

SQLException

deleteAndInsert

public void deleteAndInsert(PgRDB.Table table,
                            PgRDB.Where where,
                            Collection<PgRDB.Value> cvs)
                     throws SQLException

Throws:

SQLException

deleteAndInsert

public void deleteAndInsert(PgRDB.Table table,
                            PgRDB.Where where,
                            PgRDB.Value... cvs)
                     throws SQLException

Throws:

SQLException

deleteAndMultipleInsert

public void deleteAndMultipleInsert(PgRDB.Table table,
                                    PgRDB.Where where,
                                    Collection<? extends Collection<PgRDB.Value>> cvss)
                             throws SQLException

Throws:

SQLException

multipleDeleteAndInsert

public void multipleDeleteAndInsert(PgRDB.Table table,
                                    Collection<PgRDB.DeleteInsert> delins)
                             throws SQLException

Throws:

SQLException

printSQLError

public static void printSQLError(PrintStream err,
                                 String n,
                                 SQLException ex)

printSQLError

public static void printSQLError(PrintWriter err,
                                 String n,
                                 SQLException ex)

createCluster

public static <R extends PgRDB> PgRDB.Cluster<R> createCluster(PgRDB.RDBCreator<R> creator,
                                                               String url,
                                                               int num,
                                                               long ttp)