Package org.pgcodekeeper.core.database.ch.schema

Class ChUser

java.lang.Object
org.pgcodekeeper.core.database.base.schema.AbstractStatement
org.pgcodekeeper.core.database.ch.schema.ChAbstractStatement
org.pgcodekeeper.core.database.ch.schema.ChUser
All Implemented Interfaces:
IStatement, IHashable
public class ChUser extends ChAbstractStatement
Represents a ClickHouse user account with authentication and authorization settings. It supports hosts restrictions, role assignments, default database, and grantee configurations.

  • Constructor Details

    • ChUser

      public ChUser(String name)
      Creates a new ClickHouse user with the specified name.
      Parameters:
      name - the name of the user

  • Method Details

    • getStatementType

      public DbObjType getStatementType()
      Description copied from interface: IStatement
      Gets the type of this database object.
      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.
      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
      Parameters:
      newCondition - new object state
      script - script to collect changes
      Returns:
      object change type

    • setDefaultDatabase

      public void setDefaultDatabase(String defaultDatabase)

    • addDefRole

      public void addDefRole(String defRole)
      Adds a default role for this user.
      Parameters:
      defRole - the role name to add as default

    • addExceptRole

      public void addExceptRole(String exceptRole)
      Adds a role to the EXCEPT list for default roles.
      Parameters:
      exceptRole - the role name to exclude from defaults

    • addGrantee

      public void addGrantee(String grantee)
      Adds a grantee role for this user.
      Parameters:
      grantee - the grantee role name to add

    • addExGrantee

      public void addExGrantee(String exGrantee)
      Adds a role to the EXCEPT list for grantees.
      Parameters:
      exGrantee - the grantee role name to exclude

    • hasHosts

      public boolean hasHosts()
      Checks if this user has host restrictions.
      Returns:
      true if no host restrictions are defined, false otherwise

    • addHost

      public void addHost(String host)
      Adds a host restriction for this user.
      Parameters:
      host - the host pattern to add

    • setStorageType

      public void setStorageType(String storageType)

    • 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.
      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