com.screenscraper.datamanager.sql.util

Class PSBuilder

java.lang.Object

com.screenscraper.datamanager.sql.util.PSBuilder

public class PSBuilder
extends java.lang.Object

Constructor Summary

Constructors

Constructor and Description
PSBuilder()

Method Summary

Modifier and Type	Method and Description
static DmPreparedStatement	getInsert(java.sql.Connection con, DataNode n, java.lang.String quote, java.lang.String schemaName, boolean autoincrement) Builds an insert statement
static DmPreparedStatement	getSelect(java.lang.String vendor, java.sql.Connection con, DataNode n, java.lang.String quote, java.lang.String schemaName)
static DmPreparedStatement	getUpdate(java.sql.Connection con, DataNode n, java.lang.String quote, java.lang.String schemaName) Generate update query based on data in node.

Methods inherited from class java.lang.Object

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

Constructor Detail

PSBuilder

public PSBuilder()

Method Detail

getUpdate

public static DmPreparedStatement getUpdate(@NotNull
                                            java.sql.Connection con,
                                            @NotNull
                                            DataNode n,
                                            java.lang.String quote,
                                            @Nullable
                                            java.lang.String schemaName)
                                     throws java.sql.SQLException

Generate update query based on data in node. Preconditions: n must have primary key data set.

Parameters:

con - The connection the statement is for

n - The node to build a statement for

quote - The type of quote for escaping column names

schemaName - The schema name (for things like PostgreSQL)

Returns:

The prepared statement

Throws:

java.sql.SQLException - On error creating the statement

getInsert

public static DmPreparedStatement getInsert(@NotNull
                                            java.sql.Connection con,
                                            @NotNull
                                            DataNode n,
                                            java.lang.String quote,
                                            @Nullable
                                            java.lang.String schemaName,
                                            boolean autoincrement)
                                     throws java.sql.SQLException

Builds an insert statement

Parameters:

con - The connection the statement is for

n - The node to build a statement for

quote - The type of quote for escaping column names

schemaName - The schema name (for things like PostgreSQL)

autoincrement - True is auto-generated columns should be returned

Returns:

The prepared statement

Throws:

java.sql.SQLException - On error building the statement

getSelect

@Nullable
public static DmPreparedStatement getSelect(@NotNull
                                                       java.lang.String vendor,
                                                       @NotNull
                                                       java.sql.Connection con,
                                                       @NotNull
                                                       DataNode n,
                                                       java.lang.String quote,
                                                       @Nullable
                                                       java.lang.String schemaName)
                                                throws java.io.UnsupportedEncodingException,
                                                       java.sql.SQLException

Parameters:

vendor - The database vendor

con - The connection the statement is for

n - The node to build a statement for

quote - The type of quote for escaping column names

schemaName - The schema name (for things like PostgreSQL)

Returns:

The prepared statement

Throws:

java.sql.SQLException - On error building the statement

java.io.UnsupportedEncodingException - On error decoding/encoding the values