Package org.pgcodekeeper.core.database.pg.schema

Class PgUserMapping

java.lang.Object
org.pgcodekeeper.core.database.base.schema.AbstractStatement
org.pgcodekeeper.core.database.pg.schema.PgAbstractStatement
org.pgcodekeeper.core.database.pg.schema.PgUserMapping
All Implemented Interfaces:
IOptionContainer, IStatement, PgForeignOptionContainer, IHashable
public class PgUserMapping extends PgAbstractStatement implements PgForeignOptionContainer
PostgreSQL user mapping implementation. User mappings define how to authenticate as a specific user when accessing foreign servers, typically storing connection credentials and options for foreign data wrappers.

  • Constructor Details

    • PgUserMapping

      public PgUserMapping(String user, String server)
      Creates a new PostgreSQL user mapping.
      Parameters:
      user - user name for this mapping
      server - foreign server name

  • Method Details

    • getStatementType

      public DbObjType getStatementType()
      Description copied from interface: IStatement
      Gets the type of this database object.
      Specified by:
      getStatementType in interface IStatement
      Returns:
      the database object type

    • getCreationSQL

      public void getCreationSQL(SQLScript script)
      Description copied from interface: IStatement
      Generates the SQL statements needed to create this database object. This is an abstract method that must be implemented by subclasses to provide the specific CREATE SQL for each object type.
      Specified by:
      getCreationSQL in interface IStatement
      Parameters:
      script - the SQL script to append creation statements to

    • appendAlterSQL

      public ObjectState appendAlterSQL(IStatement newCondition, SQLScript script)
      Description copied from interface: IStatement
      Fill script with object changes and return change type
      Specified by:
      appendAlterSQL in interface IStatement
      Parameters:
      newCondition - new object state
      script - script to collect changes
      Returns:
      object change type

    • getDropSQL

      public void getDropSQL(SQLScript script, boolean generateExists)
      Description copied from interface: IStatement
      Generates DROP SQL for this statement.
      Specified by:
      getDropSQL in interface IStatement
      Overrides:
      getDropSQL in class AbstractStatement
      Parameters:
      script - the SQL script to append the DROP statement to
      generateExists - whether to include "IF EXISTS" in the DROP statement

    • getAlterHeader

      public String getAlterHeader()
      Description copied from interface: PgForeignOptionContainer
      Returns the ALTER statement header for this object.
      Specified by:
      getAlterHeader in interface PgForeignOptionContainer
      Returns:
      ALTER statement prefix (e.g., "ALTER FOREIGN TABLE table_name")

    • getServer

      public String getServer()
      Gets the foreign server name for this mapping.
      Returns:
      server name

    • getQualifiedName

      public String getQualifiedName()
      Description copied from interface: IStatement
      Gets the fully qualified name of this statement.
      Specified by:
      getQualifiedName in interface IStatement
      Overrides:
      getQualifiedName in class AbstractStatement
      Returns:
      fully qualified (up to schema) dot-delimited object name. Identifiers are quoted.

    • addOption

      public void addOption(String key, String value)
      Description copied from interface: IOptionContainer
      Adds an option to this container.
      Specified by:
      addOption in interface IOptionContainer
      Parameters:
      key - the option key
      value - the option value

    • getOptions

      public Map<String,String> getOptions()
      Description copied from interface: IOptionContainer
      Gets all options for this container.
      Specified by:
      getOptions in interface IOptionContainer
      Returns:
      a map of option keys to values

    • getQuotedName

      public String getQuotedName()
      Specified by:
      getQuotedName in interface IStatement
      Returns:
      the quoted name

    • computeHash

      public void computeHash(Hasher hasher)
      Description copied from interface: IHashable
      Computes the hash of the implementing object using the provided hasher. The implementation should call appropriate put methods on the hasher for all fields that should contribute to the hash value.
      Specified by:
      computeHash in interface IHashable
      Parameters:
      hasher - the hasher instance to use for hash computation

    • compare

      public boolean compare(IStatement obj)
      Description copied from class: AbstractStatement
      This method does not account for nested child PgStatements. Shallow version of AbstractStatement.equals(Object)
      Specified by:
      compare in interface IStatement
      Overrides:
      compare in class AbstractStatement