public class PostgreSQLDriver extends DatabaseDriver
DatabaseDriver.ExplainResult
dataSource
Constructor and Description |
---|
PostgreSQLDriver(String databaseName,
boolean clearDatabase) |
PostgreSQLDriver(String connectionString,
String databaseName,
boolean clearDatabase) |
PostgreSQLDriver(String host,
String port,
String databaseName,
boolean clearDatabase) |
PostgreSQLDriver(String host,
String port,
String user,
String password,
String databaseName,
boolean clearDatabase) |
Modifier and Type | Method and Description |
---|---|
void |
bulkCopy(String path,
String delimiter,
boolean hasTruth,
PredicateInfo predicateInfo,
Partition partition)
Perform a bulk copy operation to load the file directly into the database.
|
protected void |
clearDatabase()
Clear the context database of any existing tables/data.
|
void |
dropColumnDefault(String tableName,
String columnName)
Remove the default value for a column.
|
DatabaseDriver.ExplainResult |
explain(String queryString)
Get query planing statistics for the given select statement.
|
String |
finalizeCreateTable(com.healthmarketscience.sqlbuilder.CreateTableQuery createTable)
Gives the driver a chance to perform any final
manipulations to the CREATE TABLE statement.
|
String |
getDoubleTypeName()
Get the type name for a double type.
|
String |
getStringAggregate(String columnName,
String delimiter,
boolean distinct)
Get a string aggregating expression (one that
would appear in the SELECT clause of a grouping query.
|
String |
getSurrogateKeyColumnDefinition(String columnName)
Get the SQL definition for a primary, surrogate (auto-increment) key
for use in a CREATE TABLE statement.
|
TableStats |
getTableStats(PredicateInfo predicate)
Get some statistics for a table.
|
String |
getTypeName(ConstantType type)
Get the type name for each argument type.
|
String |
getUpsert(String tableName,
String[] columns,
String[] keyColumns)
Get the SQL for an upsert (merge) on the specified table and columns.
|
void |
setColumnDefault(String tableName,
String columnName,
String defaultValue)
Set a default value for a column.
|
boolean |
supportsBulkCopy()
Returns whether the underline database supports bulk copying operations.
|
void |
updateDBStats()
Make sure that all the database-level stats are up-to-date.
|
void |
updateTableStats(PredicateInfo predicate)
Make sure that all the table statistics are up-to-date.
|
close, getConnection
public PostgreSQLDriver(String databaseName, boolean clearDatabase)
public PostgreSQLDriver(String host, String port, String databaseName, boolean clearDatabase)
public PostgreSQLDriver(String host, String port, String user, String password, String databaseName, boolean clearDatabase)
protected void clearDatabase()
DatabaseDriver
clearDatabase
in class DatabaseDriver
public boolean supportsBulkCopy()
DatabaseDriver
supportsBulkCopy
in class DatabaseDriver
public void bulkCopy(String path, String delimiter, boolean hasTruth, PredicateInfo predicateInfo, Partition partition)
DatabaseDriver
bulkCopy
in class DatabaseDriver
public void setColumnDefault(String tableName, String columnName, String defaultValue)
public void dropColumnDefault(String tableName, String columnName)
public String getTypeName(ConstantType type)
DatabaseDriver
getTypeName
in class DatabaseDriver
public String getSurrogateKeyColumnDefinition(String columnName)
DatabaseDriver
getSurrogateKeyColumnDefinition
in class DatabaseDriver
public String getDoubleTypeName()
DatabaseDriver
getDoubleTypeName
in class DatabaseDriver
public String getUpsert(String tableName, String[] columns, String[] keyColumns)
DatabaseDriver
getUpsert
in class DatabaseDriver
public String finalizeCreateTable(com.healthmarketscience.sqlbuilder.CreateTableQuery createTable)
DatabaseDriver
finalizeCreateTable
in class DatabaseDriver
public String getStringAggregate(String columnName, String delimiter, boolean distinct)
DatabaseDriver
getStringAggregate
in class DatabaseDriver
public TableStats getTableStats(PredicateInfo predicate)
DatabaseDriver
getTableStats
in class DatabaseDriver
public void updateDBStats()
DatabaseDriver
updateDBStats
in class DatabaseDriver
public void updateTableStats(PredicateInfo predicate)
DatabaseDriver
updateTableStats
in class DatabaseDriver
public DatabaseDriver.ExplainResult explain(String queryString)
DatabaseDriver
explain
in class DatabaseDriver
Copyright © 2022 University of California, Santa Cruz. All rights reserved.