DbUtils Class

Show Source

Provides static methods used to initialize a database, copy data from one database to another, find/remove duplicates records, etc.

Constructors

There are no public constructors.

Static Methods

initSchema( Database database, String schema ) returns void

Show Source

initSchema( Database database, String schema, String tableSpace ) returns boolean

Used to execute SQL statements and populate a database with table, views, triggers, etc. If the target database does not exist, an attempt is made to create a new database. Currently only supports PostgreSQL and H2.

database	Connection info for the database
schema	String containing SQL statements. Assumes individual statements are delimited with a semicolon.
tableSpace	Default tablespace used to store tables, views, etc. If null, will use the default database tablespace. This option only applies to PostgreSQL

Show Source

getColumns( String tableName, Database sourceDB ) returns LinkedHashMap<String, Boolean>

Show Source

executeBatch( ArrayList<String> statements, Connection conn ) returns void

Show Source

copyTable( String tableName, String where, Database sourceDB, Database destDB, int pageSize, int numThreads ) returns void

Used to transfer records between 2 databases for a given table.

Show Source

findMismatch( String tableName, Database sourceDB, Database destDB, int pageSize, long offset, AtomicLong rowID ) returns void

Used to find mismatched between the 2 databases for a given table.

Show Source

deleteDuplicates( String tableName, Database database, Long startRow, Long endRow, int pageSize, int numThreads ) returns void

Used to find and delete duplicates in a given table.

Show Source

getJson( Recordset rs ) returns JSONObject

Returns a JSON representation of a record in a Recordset. Column names are used as keys and the corresponding value is used as the value. Note that the column names are represented using camel case. If there are duplicate column names in the Recordset (e.g. "select user.id, contact.id from ...") the first column name and value is used (e.g. "user.id" column).

Show Source

getJson( javaxt.sql.Record record ) returns JSONObject

Show Source

getJson( javaxt.sql.Field[] fields ) returns JSONObject

Show Source

getJson( String sql, Connection conn, boolean separateRowsAndColumns ) returns String

Show Source