com.brotherlogic.simplestore.postgres

Class PgRunner

java.lang.Object

com.brotherlogic.simplestore.postgres.PgRunner

public class PgRunner
extends Object

Constructor Summary

Constructors

Constructor and Description
PgRunner(String url) Constructor.

Method Summary

Methods

Modifier and Type	Method and Description
protected void	checkAndCreateTable(String tableName)
protected String	getColumnType(Class<?> objClass)
protected PreparedStatement	getPreparedStatement(String command, Object[] values)
Set<String>	getTableColumns(String tableName) Gets the columns in the table.
boolean	insert(String command, Object[] values) Runs an insert command.
Map<String,Object>	retrieveOne(String command, Object[] values, Map<String,Class<?>> colTypes) Retrieves a single object from the DB.

Methods inherited from class java.lang.Object

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

Constructor Detail

PgRunner

public PgRunner(String url)

Constructor.

Parameters:

url - The database url to connect to.

Method Detail

getTableColumns

public Set<String> getTableColumns(String tableName)

Gets the columns in the table.

Parameters:

tableName - The name of the table

Returns:

A set of the column names for this table

insert

public boolean insert(String command,
             Object[] values)

Runs an insert command.

Parameters:

command - The command to run

values - the values to add to the command

Returns:

true if successful, false otherwise

retrieveOne

public Map<String,Object> retrieveOne(String command,
                             Object[] values,
                             Map<String,Class<?>> colTypes)

Retrieves a single object from the DB.

Parameters:

command - The command to run

values - The values to fill

colTypes - The types of each column

Returns:

Object mapping

checkAndCreateTable

protected void checkAndCreateTable(String tableName)

getColumnType

protected String getColumnType(Class<?> objClass)

getPreparedStatement

protected PreparedStatement getPreparedStatement(String command,
                                     Object[] values)