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 DB2V8
class Derby10
class H2
class MySQL5
class Oracle10g
class Oracle12c
trait Engine

Value members

Abstract methods

def alterTableAddColumn(table: Table, col: Column): List[String]
def alterTableAddPrimaryKey(table: Table, pk: PrimaryKey): 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 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 parameters:
offset

is 0 based

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