com.northconcepts.datapipeline.sql.mysql (Data Pipeline JavaDoc)

package com.northconcepts.datapipeline.sql.mysql

Generate SQL code for the MySQL database.

Class

Description

CreateForeignKey

Generates an ALTER TABLE...ADD CONSTRAINT statement to add a foreign key constraint in MySQL.

CreateIndex

Generates a CREATE INDEX statement for MySQL.

CreateMySqlDdlFromSchemaDef

Generates MySQL DDL from SchemaDef

CreateTable

Generates a CREATE TABLE statement for MySQL.

CreateTableColumn

Generates a column definition for a CREATE TABLE statement for MySQL.

DropTable

Generates a DROP TABLE statement for MySQL.

DropTableConstraint

Generates a ALTER TABLE...DROP CONSTRAINT statement for MySQL.

ForeignKeyAction

Referential action written in the ON DELETE and ON UPDATE clauses of a CreateForeignKey.

Insert

Generates an INSERT INTO statement for MySQL.

InsertRow

A row of values in an Insert or Upsert; each value is written as-is, so it must already be an SQL literal.

InsertValue

A column name and value pair in an InsertRow.

MySqlInsertWriter

Generates MySQL insert statement from records.

MySqlPart

Base class for the MySQL statement builders; identifiers are quoted with backticks.

MySqlUpsertWriter

Generates MySQL upsert statement from records.

TableColumn

A table column's name and TableColumnType.

TableColumnType

MySQL column data types for CreateTableColumn, noting which accept a length, a scale or AUTO_INCREMENT.

Upsert

Generates an upsert statement for MySQL.