Class CacheDatabaseMeta

    • Constructor Detail

      • CacheDatabaseMeta

        public CacheDatabaseMeta()
    • Method Detail

      • getDriverClass

        public String getDriverClass()
        Description copied from interface: DatabaseInterface
        Obtain the name of the JDBC driver class that we need to use!
        Specified by:
        getDriverClass in interface DatabaseInterface
        Returns:
        the name of the JDBC driver class for the specific database
      • getURL

        public String getURL​(String hostname,
                             String port,
                             String databaseName)
        Specified by:
        getURL in interface DatabaseInterface
        Parameters:
        hostname - the hostname
        port - the port as a string
        databaseName - the database name
        Returns:
        the URL to use for connecting to the database.
      • getAddColumnStatement

        public String getAddColumnStatement​(String tablename,
                                            ValueMetaInterface v,
                                            String tk,
                                            boolean useAutoinc,
                                            String pk,
                                            boolean semicolon)
        Generates the SQL statement to add a column to the specified table
        Specified by:
        getAddColumnStatement in interface DatabaseInterface
        Parameters:
        tablename - The table to add
        v - The column defined as a value
        tk - the name of the technical key field
        useAutoinc - whether or not this field uses auto increment
        pk - the name of the primary key field
        semicolon - whether or not to add a semi-colon behind the statement.
        Returns:
        the SQL statement to add a column to the specified table
      • getDropColumnStatement

        public String getDropColumnStatement​(String tablename,
                                             ValueMetaInterface v,
                                             String tk,
                                             boolean useAutoinc,
                                             String pk,
                                             boolean semicolon)
        Generates the SQL statement to drop a column from the specified table
        Specified by:
        getDropColumnStatement in interface DatabaseInterface
        Overrides:
        getDropColumnStatement in class BaseDatabaseMeta
        Parameters:
        tablename - The table to add
        v - The column defined as a value
        tk - the name of the technical key field
        useAutoinc - whether or not this field uses auto increment
        pk - the name of the primary key field
        semicolon - whether or not to add a semi-colon behind the statement.
        Returns:
        the SQL statement to drop a column from the specified table
      • getModifyColumnStatement

        public String getModifyColumnStatement​(String tablename,
                                               ValueMetaInterface v,
                                               String tk,
                                               boolean useAutoinc,
                                               String pk,
                                               boolean semicolon)
        Generates the SQL statement to modify a column in the specified table
        Specified by:
        getModifyColumnStatement in interface DatabaseInterface
        Parameters:
        tablename - The table to add
        v - The column defined as a value
        tk - the name of the technical key field
        useAutoinc - whether or not this field uses auto increment
        pk - the name of the primary key field
        semicolon - whether or not to add a semi-colon behind the statement.
        Returns:
        the SQL statement to modify a column in the specified table
      • getFieldDefinition

        public String getFieldDefinition​(ValueMetaInterface v,
                                         String tk,
                                         String pk,
                                         boolean useAutoinc,
                                         boolean addFieldName,
                                         boolean addCr)
        Description copied from interface: DatabaseInterface
        Describe a Value as a field in the database.
        Specified by:
        getFieldDefinition in interface DatabaseInterface
        Parameters:
        v - The value to describe
        tk - The field that's going to be the technical key
        pk - The field that's going to be the primary key
        useAutoinc - Use autoincrement or not
        addFieldName - Add the fieldname to the definition or not
        addCr - Add a cariage return at the end of the definition or not.
        Returns:
        a value described as a field in this database.