schema

Documentation

Overview

TODO: Normalize implicit things in input first, and then compare

This package has SQL parser, its abstraction and SQL generator. Never touch database.

Index

• Constants
• func GenerateIdempotentDDLs(mode GeneratorMode, desiredSQL string, currentSQL string) ([]string, error)
• type AddForeignKey
  • func (a *AddForeignKey) Statement() string
• type AddIndex
  • func (a *AddIndex) Statement() string
• type AddPrimaryKey
  • func (a *AddPrimaryKey) Statement() string
• type Column
• type ColumnKeyOption
• type CreateIndex
  • func (c *CreateIndex) Statement() string
• type CreateTable
  • func (c *CreateTable) Statement() string
• type DDL
• type ForeignKey
• type Generator
• type GeneratorMode
• type Index
• type IndexColumn
• type Table
• type Value
• type ValueType

Constants

const (
	ValueTypeStr = ValueType(iota)
	ValueTypeInt
	ValueTypeFloat
	ValueTypeHexNum
	ValueTypeHex
	ValueTypeValArg
	ValueTypeBit
)

const (
	ColumnKeyNone = ColumnKeyOption(iota)
	ColumnKeyPrimary
	ColumnKeySpatialKey
	ColumnKeyUnique
	ColumnKeyUniqueKey
	ColumnKey
)

const (
	GeneratorModeMysql = GeneratorMode(iota)
	GeneratorModePostgres
)

Functions

func GenerateIdempotentDDLs

func GenerateIdempotentDDLs(mode GeneratorMode, desiredSQL string, currentSQL string) ([]string, error)

Parse argument DDLs and call `generateDDLs()`

Types

type AddForeignKey

type AddForeignKey struct {
	// contains filtered or unexported fields
}

func (*AddForeignKey) Statement

func (a *AddForeignKey) Statement() string

type AddIndex

type AddIndex struct {
	// contains filtered or unexported fields
}

func (*AddIndex) Statement

func (a *AddIndex) Statement() string

type AddPrimaryKey

type AddPrimaryKey struct {
	// contains filtered or unexported fields
}

func (*AddPrimaryKey) Statement

func (a *AddPrimaryKey) Statement() string

type Column

type Column struct {
	// contains filtered or unexported fields
}

type ColumnKeyOption

type ColumnKeyOption int

type CreateIndex

type CreateIndex struct {
	// contains filtered or unexported fields
}

func (*CreateIndex) Statement

func (c *CreateIndex) Statement() string

type CreateTable

type CreateTable struct {
	// contains filtered or unexported fields
}

func (*CreateTable) Statement

func (c *CreateTable) Statement() string

type DDL

type DDL interface {
	Statement() string
}

type ForeignKey

type ForeignKey struct {
	// contains filtered or unexported fields
}

type Generator

type Generator struct {
	// contains filtered or unexported fields
}

This struct holds simulated schema states during GenerateIdempotentDDLs().

type GeneratorMode

type GeneratorMode int

type Index

type Index struct {
	// contains filtered or unexported fields
}

type IndexColumn

type IndexColumn struct {
	// contains filtered or unexported fields
}

type Table

type Table struct {
	// contains filtered or unexported fields
}

type Value

type Value struct {
	// contains filtered or unexported fields
}

type ValueType

type ValueType int