Package ca.uhn.fhir.jpa.migrate.util

Class SqlUtil

java.lang.Object

ca.uhn.fhir.jpa.migrate.util.SqlUtil

public class SqlUtil
extends Object

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static class	SqlUtil.AlterTableAddConstraint
static class	SqlUtil.CreateTablePrimaryKey

Method Summary

Modifier and Type	Method	Description
static Optional<SqlUtil.AlterTableAddConstraint>	parseAlterTableAddConstraintConstraintForeignKey(String theStatement)	Accepts a DDL statement containing ALTER TABLE [IF EXISTS]? table_name ADD CONSTRAINT constraint_name FOREIGN KEY (column_list) and returns the parsed details.
static Optional<SqlUtil.CreateTablePrimaryKey>	parseCreateTableStatementPrimaryKey(String theStatement)	Accepts a SQL statement and parses it as a SQL CREATE TABLE statement, returning details about the table name and primary key.
static List<String>	splitSqlFileIntoStatements(String theSql)

Methods inherited from class java.lang.Object

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

Method Details

splitSqlFileIntoStatements

@Nonnull
public static List<String> splitSqlFileIntoStatements(String theSql)

parseCreateTableStatementPrimaryKey

@Nonnull
public static Optional<SqlUtil.CreateTablePrimaryKey> parseCreateTableStatementPrimaryKey(String theStatement)

Accepts a SQL statement and parses it as a SQL CREATE TABLE statement, returning details about the table name and primary key. This method has only been tested for Postgresql DDL format!

Parameters:

theStatement - A single SQL statement

Returns:

Returns details about the table name and PK columns if the SQL statement contains a valid CREATE TABLE statement, returns null otherwise.

parseAlterTableAddConstraintConstraintForeignKey

@Nonnull
public static Optional<SqlUtil.AlterTableAddConstraint> parseAlterTableAddConstraintConstraintForeignKey(String theStatement)

Accepts a DDL statement containing ALTER TABLE [IF EXISTS]? table_name ADD CONSTRAINT constraint_name FOREIGN KEY (column_list) and returns the parsed details.