api-docs / org.ktorm.support.mysql / MySqlFormatter

MySqlFormatter

open class MySqlFormatter : 
    SqlFormatter,
    MySqlExpressionVisitor

(source code)

SqlFormatter implementation for MySQL, formatting SQL expressions as strings with their execution arguments.

Constructors

Name	Summary
<init>	`MySqlFormatter( database: Database, beautifySql: Boolean, indentSize: Int)` SqlFormatter implementation for MySQL, formatting SQL expressions as strings with their execution arguments.

Inherited Properties

Name	Summary
_builder	`val _builder: StringBuilder`
_depth	`var _depth: Int`
_parameters	`val _parameters: <ERROR CLASS><ArgumentExpression<*>>`
beautifySql	`val beautifySql: Boolean` mark if we should output beautiful SQL strings with line-wrapping and indentation.
database	`val database: Database` the current database object used to obtain metadata such as identifier quote string.
indentSize	`val indentSize: Int` the indent size.
isIdentifier	`val String.isIdentifier: Boolean`
isIdentifierStart	`val Char.isIdentifierStart: Boolean`
isMixedCase	`val String.isMixedCase: Boolean`
parameters	`val parameters: List<ArgumentExpression<*>>` return the SQL execution parameters after the visit completes.
quoted	`val String.quoted: String`
removeBrackets	`val SqlExpression.removeBrackets: Boolean`
sql	`val sql: String` return the executable SQL string after the visit completes.

Functions

Name	Summary
visit	`open fun visit(expr: SqlExpression): SqlExpression` Dispatch different type of expression nodes to their specific `visit*` functions. Custom expression types that are unknown to Ktorm will be dispatched to visitUnknown.
visitBulkInsert	`open fun visitBulkInsert( expr: BulkInsertExpression ): BulkInsertExpression` Function that visits a BulkInsertExpression.
visitDefaultValue	`open fun <T : Any> visitDefaultValue( expr: DefaultValueExpression<T> ): DefaultValueExpression<T>` Function that visits a DefaultValueExpression.
visitInsertOrUpdate	`open fun visitInsertOrUpdate( expr: InsertOrUpdateExpression ): InsertOrUpdateExpression` Function that visits an InsertOrUpdateExpression.
visitMatchAgainst	`open fun visitMatchAgainst( expr: MatchAgainstExpression ): MatchAgainstExpression` Function that visits a MatchAgainstExpression.
visitNaturalJoin	`open fun visitNaturalJoin( expr: NaturalJoinExpression ): NaturalJoinExpression` Function that visits a NaturalJoinExpression.
visitQuerySource	`open fun visitQuerySource( expr: QuerySourceExpression ): QuerySourceExpression` Function that visits a QuerySourceExpression.
visitSelect	`open fun visitSelect( expr: SelectExpression ): SelectExpression` Function that visits a SelectExpression.
writePagination	`open fun writePagination(expr: QueryExpression): Unit`

Inherited Functions

Name	Summary
newLine	`fun newLine(indent: SqlFormatter.Indentation): Unit`
removeLastBlank	`fun removeLastBlank(): Unit`
shouldQuote	`open fun shouldQuote(identifier: String): Boolean`
visitAggregate	`open fun <T : Any> visitAggregate( expr: AggregateExpression<T> ): AggregateExpression<T>` Function that visits an AggregateExpression.
visitArgument	`open fun <T : Any> visitArgument( expr: ArgumentExpression<T> ): ArgumentExpression<T>` Function that visits an ArgumentExpression.
visitBetween	`open fun visitBetween( expr: BetweenExpression ): BetweenExpression` Function that visits a BetweenExpression.
visitBinary	`open fun <T : Any> visitBinary( expr: BinaryExpression<T> ): BinaryExpression<T>` Function that visits a BinaryExpression.
visitBulkInsertAssignments	`open fun visitBulkInsertAssignments( assignments: List<List<ColumnAssignmentExpression<>>> ): List<List<ColumnAssignmentExpression<>>>` Helper function for visiting insert assignments of BulkInsertExpression.
visitCaseWhen	`open fun <T : Any> visitCaseWhen( expr: CaseWhenExpression<T> ): CaseWhenExpression<T>` Function that visits a CaseWhenExpression.
visitCasting	`open fun <T : Any> visitCasting( expr: CastingExpression<T> ): CastingExpression<T>` Function that visits a CastingExpression.
visitColumn	`open fun <T : Any> visitColumn( expr: ColumnExpression<T> ): ColumnExpression<T>` Function that visits a ColumnExpression.
visitColumnDeclaring	`open fun <T : Any> visitColumnDeclaring( expr: ColumnDeclaringExpression<T> ): ColumnDeclaringExpression<T>` Function that visits a ColumnDeclaringExpression.
visitColumnDeclaringAtSelectClause	`fun <T : Any> visitColumnDeclaringAtSelectClause( expr: ColumnDeclaringExpression<T> ): ColumnDeclaringExpression<T>`
visitDelete	`open fun visitDelete( expr: DeleteExpression ): DeleteExpression` Function that visits a DeleteExpression.
visitExists	`open fun visitExists( expr: ExistsExpression ): ExistsExpression` Function that visits an ExistsExpression.
visitExpressionList	`open fun <T : SqlExpression> visitExpressionList( original: List<T>, subVisitor: (T) -> T ): List<T>` Helper function for visiting a list of expressions.
visitFunction	`open fun <T : Any> visitFunction( expr: FunctionExpression<T> ): FunctionExpression<T>` Function that visits a FunctionExpression.
visitInList	`open fun visitInList( expr: InListExpression ): InListExpression` Function that visits an InListExpression.
visitInsert	`open fun visitInsert( expr: InsertExpression ): InsertExpression` Function that visits an InsertExpression.
visitInsertFromQuery	`open fun visitInsertFromQuery( expr: InsertFromQueryExpression ): InsertFromQueryExpression` Function that visits an InsertFromQueryExpression.
visitJoin	`open fun visitJoin(expr: JoinExpression): JoinExpression` Function that visits a JoinExpression.
visitOrderBy	`open fun visitOrderBy( expr: OrderByExpression ): OrderByExpression` Function that visits an OrderByExpression.
visitTable	`open fun visitTable(expr: TableExpression): TableExpression` Function that visits a TableExpression.
visitUnary	`open fun <T : Any> visitUnary( expr: UnaryExpression<T> ): UnaryExpression<T>` Function that visits an UnaryExpression.
visitUnion	`open fun visitUnion(expr: UnionExpression): UnionExpression` Function that visits an UnionExpression.
visitUnknown	`open fun visitUnknown(expr: SqlExpression): SqlExpression` Function that visits an unknown expression.
visitUpdate	`open fun visitUpdate( expr: UpdateExpression ): UpdateExpression` Function that visits an UpdateExpression.
visitWindowFrameBound	`open fun visitWindowFrameBound( expr: WindowFrameBoundExpression ): WindowFrameBoundExpression` Function that visits a WindowFrameBoundExpression.
visitWindowFunction	`open fun <T : Any> visitWindowFunction( expr: WindowFunctionExpression<T> ): WindowFunctionExpression<T>` Function that visits a WindowFunctionExpression.
visitWindowSpecification	`open fun visitWindowSpecification( expr: WindowSpecificationExpression ): WindowSpecificationExpression` Function that visits a WindowSpecificationExpression.
write	`fun write(value: String): Unit`
writeColumnAssignments	`fun writeColumnAssignments( original: List<ColumnAssignmentExpression<*>> ): Unit`
writeInsertColumnNames	`fun writeInsertColumnNames( columns: List<ColumnExpression<*>> ): Unit`
writeInsertValues	`fun writeInsertValues( assignments: List<ColumnAssignmentExpression<*>> ): Unit`
writeKeyword	`fun writeKeyword(keyword: String): Unit`

Extension Functions

Name	Summary
eq	`infix fun <T : Any> T.eq( expr: ColumnDeclaring<T> ): BinaryExpression<Boolean>` Equal operator, translated to `=` in SQL.
neq	`infix fun <T : Any> T.neq( expr: ColumnDeclaring<T> ): BinaryExpression<Boolean>` Not-equal operator, translated to `<>` in SQL.
notEq	`infix fun <T : Any> T.notEq( expr: ColumnDeclaring<T> ): BinaryExpression<Boolean>` Not-equal operator, translated to `<>` in SQL.