beangle-data-jdbc/org.beangle.data.jdbc.engine/Dialect

Dialect

trait Dialect

RDBMS Dialect Focus on ddl and dml sql generation.

class Object
trait Matchable
class Any
class DB2
class Derby
class H2
class HSQL
class MySQL
class Oracle
class SQLServer
trait Engine

Value members

Abstract methods

def alterTableAddColumn(table: Table, col: Column): List[String]
def alterTableAddPrimaryKey(table: Table, pk: PrimaryKey): String
def alterTableAddUnique(fk: UniqueKey): String
def alterTableDropColumn(table: Table, col: Column): String
def alterTableDropConstraint(table: Table, name: String): String
def alterTableDropPrimaryKey(table: Table, pk: PrimaryKey): String
def alterTableModifyColumnDefault(table: Table, col: Column, v: Option[String]): String
def alterTableModifyColumnSetNotNull(table: Table, col: Column): String
def alterTableModifyColumnType(table: Table, col: Column, sqlType: SqlType): String
def alterTableRenameColumn(table: Table, col: Column, newName: String): String
def commentOnColumn(table: Table, column: Column, comment: Option[String]): Option[String]
def commentOnTable(table: String, comment: Option[String]): Option[String]
def commentsOnTable(table: Table, includeMissing: Boolean): List[String]
def createIndex(i: Index): String
def createSequence(seq: Sequence): String
def createTable(table: Table): String
def dropIndex(i: Index): String
def dropSequence(seq: Sequence): String
def dropTable(table: String): String
def insert(table: Table): String
def limit(query: String, offset: Int, limit: Int): (String, List[Int])

generate limit sql

generate limit sql

Value Params
offset

is 0 based

def query(table: Table): String
def supportSequence: Boolean