Package org.pgcodekeeper.core.database.ms.loader

Class MsJdbcLoader

java.lang.Object

org.pgcodekeeper.core.database.base.loader.AbstractLoader<T>

org.pgcodekeeper.core.database.base.loader.AbstractJdbcLoader<MsDatabase>

org.pgcodekeeper.core.database.ms.loader.MsJdbcLoader

All Implemented Interfaces:

IJdbcLoader, ILoader

public final class MsJdbcLoader
extends AbstractJdbcLoader<MsDatabase>

JDBC-based database schema loader for Microsoft SQL Server databases. Reads database schemas, tables, functions, procedures, views, types, assemblies, roles, users and other objects from a Microsoft SQL Server database. Extends JdbcLoaderBase to provide Microsoft SQL Server-specific loading functionality.

Constructor Summary

Constructors

Constructor	Description
MsJdbcLoader(IJdbcConnector connector, DiffSettings diffSettings)	Creates a new Microsoft SQL Server JDBC loader with the specified parameters.

Method Summary

Modifier and Type	Method	Description
static String	getMsType(AbstractStatement statement, String schema, String dataType, boolean isUserDefined, int size, int precision, int scale)
static String	getMsType(AbstractStatement statement, String schema, String dataType, boolean isUserDefined, int size, int precision, int scale, boolean quoteSysTypes)
MsDatabase	loadInternal()
void	preLoad()
void	setPrivileges(AbstractStatement st, List<MsXmlReader> privs)
<T> void	submitMsAntlrTask(String sql, Function<TSQLParser,T> parserCtxReader, Consumer<T> finalizer)

Methods inherited from class org.pgcodekeeper.core.database.base.loader.AbstractJdbcLoader

getConnection, getCurrentLocation, getRunner, getSchema, getSchemas, getStatement, getVersion, putSchema, setComment, setCurrentObject, setCurrentOperation, setOwner, setVersion

Methods inherited from class org.pgcodekeeper.core.database.base.loader.AbstractLoader

addError, getDatabase, getDatabaseName, getErrors, getMonitor, getSettings, isAllowedSchema, load, loadAndAnalyze

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.pgcodekeeper.core.database.api.loader.ILoader

getDatabase, getDatabaseName, getErrors, getSettings, load, loadAndAnalyze

Constructor Details

MsJdbcLoader

public MsJdbcLoader(IJdbcConnector connector,
 DiffSettings diffSettings)

Creates a new Microsoft SQL Server JDBC loader with the specified parameters.

Parameters:

connector - the JDBC connector for establishing database connections

diffSettings - unified context object containing settings, ignore list, and error accumulator

Method Details

preLoad

public void preLoad()

loadInternal

public MsDatabase loadInternal()
                        throws IOException,
InterruptedException

Throws:

IOException

InterruptedException

submitMsAntlrTask

public <T> void submitMsAntlrTask(String sql,
 Function<TSQLParser,T> parserCtxReader,
 Consumer<T> finalizer)

getMsType

public static String getMsType(AbstractStatement statement,
 String schema,
 String dataType,
 boolean isUserDefined,
 int size,
 int precision,
 int scale)

getMsType

public static String getMsType(AbstractStatement statement,
 String schema,
 String dataType,
 boolean isUserDefined,
 int size,
 int precision,
 int scale,
 boolean quoteSysTypes)

setPrivileges

public void setPrivileges(AbstractStatement st,
 List<MsXmlReader> privs)