DatabaseSyntax

java.lang.Object

de.julianweinelt.datacat.dbx.database.DatabaseSyntax

public abstract class DatabaseSyntax extends Object

Defines which syntax different SQL databases use.

Since:: 1.0.0
Version:: 1.0.0
Author:: Julian Weinelt

Field Summary

Fields

Modifier and Type

Field

Description

static DatabaseSyntax

MSSQL

static DatabaseSyntax

MYSQL
Constructor Summary

Constructors

Constructor

Description

DatabaseSyntax()
Method Summary

Modifier and Type

Method

Description

abstract String

getType()

Defines how this database it's type.

abstract String

getVersion()

Defines how this database it's version.

abstract String

showDatabases()

Defines how this database queries database schemas.

abstract String

showFunctions()

Defines how this database queries functions.

abstract String

showTables()

Defines how this database queries tables.

abstract String

showTriggers()

Defines how this database queries triggers.

abstract String

showViews()

Defines how this database queries views.

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details
- MSSQL
  
  public static DatabaseSyntax MSSQL
- MYSQL
  
  public static DatabaseSyntax MYSQL
Constructor Details
- DatabaseSyntax
  
  public DatabaseSyntax()
Method Details
- showTables
  
  public abstract String showTables()
  
  Defines how this database queries tables.
  
  Returns:
  
  The SQL statement for viewing tables.
- showDatabases
  
  public abstract String showDatabases()
  
  Defines how this database queries database schemas.
  
  Returns:
  
  The SQL statement for viewing schemas.
- showViews
  
  public abstract String showViews()
  
  Defines how this database queries views.
  
  Returns:
  
  The SQL statement for viewing database views.
- showFunctions
  
  public abstract String showFunctions()
  
  Defines how this database queries functions.
  
  Returns:
  
  The SQL statement for viewing functions.
- showTriggers
  
  public abstract String showTriggers()
  
  Defines how this database queries triggers.
  
  Returns:
  
  The SQL statement for viewing triggers.
- getType
  
  public abstract String getType()
  
  Defines how this database it's type.
  
  Returns:
  
  The SQL statement for getting the database engine's name.
- getVersion
  
  public abstract String getVersion()
  
  Defines how this database it's version.
  
  Returns:
  
  The SQL statement for getting the database engine's version.