Package org.pgcodekeeper.core

Class WorkDirs

java.lang.Object

org.pgcodekeeper.core.WorkDirs

public final class WorkDirs
extends Object

Provides directory structure definitions and path resolution utilities for different database types (PostgreSQL, Microsoft SQL, ClickHouse). Manages the organization of database objects in filesystem directories.

Field Summary

Fields

Modifier and Type	Field	Description
static final String	CH_DATABASE
static final String	MS_ROLES
static final String	MS_SCHEMAS
static final String	MS_SECURITY
static final String	MS_USERS
static final String	OVERRIDES
static final String	PG_SCHEMA

Method Summary

Modifier and Type	Method	Description
static String	getDirectoryNameForType(DatabaseType databaseType, DbObjType type)	Gets the directory name for a specific database object type
static List<String>	getDirectoryNames(DatabaseType databaseType)	Gets the list of top-level directory names for the specified database type
static Set<DbObjType>	getDirLoadOrder()	Gets the loading order for PostgreSQL object types
static Path	getRelativeFolderPath(PgStatement st, Path baseDir)	Gets the relative filesystem path for a database statement
static boolean	isInMsSchema(String dirSub)	Checks if a Microsoft SQL Server subdirectory belongs to a schema

Methods inherited from class java.lang.Object

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

Field Details

OVERRIDES

public static final String OVERRIDES

See Also:

• Constant Field Values

PG_SCHEMA

public static final String PG_SCHEMA

MS_SECURITY

public static final String MS_SECURITY

See Also:

• Constant Field Values

MS_SCHEMAS

public static final String MS_SCHEMAS

See Also:

• Constant Field Values

MS_USERS

public static final String MS_USERS

See Also:

• Constant Field Values

MS_ROLES

public static final String MS_ROLES

See Also:

• Constant Field Values

CH_DATABASE

public static final String CH_DATABASE

Method Details

getDirectoryNames

public static List<String> getDirectoryNames(DatabaseType databaseType)

Gets the list of top-level directory names for the specified database type

Parameters:

databaseType - the database type (PG, MS, or CH)

Returns:

list of directory names

getDirectoryNameForType

public static String getDirectoryNameForType(DatabaseType databaseType,
 DbObjType type)

Gets the directory name for a specific database object type

Parameters:

databaseType - the database type

type - the database object type

Returns:

directory name for the object type, or null if the object type doesn't have a dedicated directory

Throws:

IllegalStateException - if the object type is not supported

getRelativeFolderPath

public static Path getRelativeFolderPath(PgStatement st,
 Path baseDir)

Gets the relative filesystem path for a database statement

Parameters:

st - the database statement

baseDir - the base directory path

Returns:

relative path where the statement should be stored

Throws:

IllegalStateException - if the object type is not supported

isInMsSchema

public static boolean isInMsSchema(String dirSub)

Checks if a Microsoft SQL Server subdirectory belongs to a schema

Parameters:

dirSub - the subdirectory name

Returns:

true if the directory is schema-related, false otherwise

getDirLoadOrder

public static Set<DbObjType> getDirLoadOrder()

Gets the loading order for PostgreSQL object types

Returns:

set of database object types in loading order