package dialectquery

import "github.com/pressly/goose/v3/internal/dialect/dialectquery"

Index

Types

type Clickhouse 

type Clickhouse struct{}

func (*Clickhouse) CreateTable 

func (c *Clickhouse) CreateTable(tableName string) string

func (*Clickhouse) DeleteVersion 

func (c *Clickhouse) DeleteVersion(tableName string) string

func (*Clickhouse) GetLatestVersion 

func (c *Clickhouse) GetLatestVersion(tableName string) string

func (*Clickhouse) GetMigrationByVersion 

func (c *Clickhouse) GetMigrationByVersion(tableName string) string

func (*Clickhouse) InsertVersion 

func (c *Clickhouse) InsertVersion(tableName string) string

func (*Clickhouse) ListMigrations 

func (c *Clickhouse) ListMigrations(tableName string) string

type Mysql 

type Mysql struct{}

func (*Mysql) CreateTable 

func (m *Mysql) CreateTable(tableName string) string

func (*Mysql) DeleteVersion 

func (m *Mysql) DeleteVersion(tableName string) string

func (*Mysql) GetLatestVersion 

func (m *Mysql) GetLatestVersion(tableName string) string

func (*Mysql) GetMigrationByVersion 

func (m *Mysql) GetMigrationByVersion(tableName string) string

func (*Mysql) InsertVersion 

func (m *Mysql) InsertVersion(tableName string) string

func (*Mysql) ListMigrations 

func (m *Mysql) ListMigrations(tableName string) string

func (*Mysql) TableExists 

func (m *Mysql) TableExists(tableName string) string

type Postgres 

type Postgres struct{}

func (*Postgres) CreateTable 

func (p *Postgres) CreateTable(tableName string) string

func (*Postgres) DeleteVersion 

func (p *Postgres) DeleteVersion(tableName string) string

func (*Postgres) GetLatestVersion 

func (p *Postgres) GetLatestVersion(tableName string) string

func (*Postgres) GetMigrationByVersion 

func (p *Postgres) GetMigrationByVersion(tableName string) string

func (*Postgres) InsertVersion 

func (p *Postgres) InsertVersion(tableName string) string

func (*Postgres) ListMigrations 

func (p *Postgres) ListMigrations(tableName string) string

func (*Postgres) TableExists 

func (p *Postgres) TableExists(tableName string) string

type Querier 

type Querier interface {
	// CreateTable returns the SQL query string to create the db version table.
	CreateTable(tableName string) string

	// InsertVersion returns the SQL query string to insert a new version into the db version table.
	InsertVersion(tableName string) string

	// DeleteVersion returns the SQL query string to delete a version from the db version table.
	DeleteVersion(tableName string) string

	// GetMigrationByVersion returns the SQL query string to get a single migration by version.
	//
	// The query should return the timestamp and is_applied columns.
	GetMigrationByVersion(tableName string) string

	// ListMigrations returns the SQL query string to list all migrations in descending order by id.
	//
	// The query should return the version_id and is_applied columns.
	ListMigrations(tableName string) string

	// GetLatestVersion returns the SQL query string to get the last version_id from the db version
	// table. Returns a nullable int64 value.
	GetLatestVersion(tableName string) string
}

Querier is the interface that wraps the basic methods to create a dialect specific query.

type QueryController 

type QueryController struct{ Querier }

func NewQueryController 

func NewQueryController(querier Querier) *QueryController

NewQueryController returns a new QueryController that wraps the given Querier.

func (*QueryController) TableExists 

func (c *QueryController) TableExists(tableName string) string

TableExists returns the SQL query string to check if the version table exists. If the Querier does not implement this method, it will return an empty string.

Returns a boolean value.

type Redshift 

type Redshift struct{}

func (*Redshift) CreateTable 

func (r *Redshift) CreateTable(tableName string) string

func (*Redshift) DeleteVersion 

func (r *Redshift) DeleteVersion(tableName string) string

func (*Redshift) GetLatestVersion 

func (r *Redshift) GetLatestVersion(tableName string) string

func (*Redshift) GetMigrationByVersion 

func (r *Redshift) GetMigrationByVersion(tableName string) string

func (*Redshift) InsertVersion 

func (r *Redshift) InsertVersion(tableName string) string

func (*Redshift) ListMigrations 

func (r *Redshift) ListMigrations(tableName string) string

type Sqlite3 

type Sqlite3 struct{}

func (*Sqlite3) CreateTable 

func (s *Sqlite3) CreateTable(tableName string) string

func (*Sqlite3) DeleteVersion 

func (s *Sqlite3) DeleteVersion(tableName string) string

func (*Sqlite3) GetLatestVersion 

func (s *Sqlite3) GetLatestVersion(tableName string) string

func (*Sqlite3) GetMigrationByVersion 

func (s *Sqlite3) GetMigrationByVersion(tableName string) string

func (*Sqlite3) InsertVersion 

func (s *Sqlite3) InsertVersion(tableName string) string

func (*Sqlite3) ListMigrations 

func (s *Sqlite3) ListMigrations(tableName string) string

type Sqlserver 

type Sqlserver struct{}

func (*Sqlserver) CreateTable 

func (s *Sqlserver) CreateTable(tableName string) string

func (*Sqlserver) DeleteVersion 

func (s *Sqlserver) DeleteVersion(tableName string) string

func (*Sqlserver) GetLatestVersion 

func (s *Sqlserver) GetLatestVersion(tableName string) string

func (*Sqlserver) GetMigrationByVersion 

func (s *Sqlserver) GetMigrationByVersion(tableName string) string

func (*Sqlserver) InsertVersion 

func (s *Sqlserver) InsertVersion(tableName string) string

func (*Sqlserver) ListMigrations 

func (s *Sqlserver) ListMigrations(tableName string) string

type Starrocks 

type Starrocks struct{}

func (*Starrocks) CreateTable 

func (m *Starrocks) CreateTable(tableName string) string

func (*Starrocks) DeleteVersion 

func (m *Starrocks) DeleteVersion(tableName string) string

func (*Starrocks) GetLatestVersion 

func (m *Starrocks) GetLatestVersion(tableName string) string

func (*Starrocks) GetMigrationByVersion 

func (m *Starrocks) GetMigrationByVersion(tableName string) string

func (*Starrocks) InsertVersion 

func (m *Starrocks) InsertVersion(tableName string) string

func (*Starrocks) ListMigrations 

func (m *Starrocks) ListMigrations(tableName string) string

type Tidb 

type Tidb struct{}

func (*Tidb) CreateTable 

func (t *Tidb) CreateTable(tableName string) string

func (*Tidb) DeleteVersion 

func (t *Tidb) DeleteVersion(tableName string) string

func (*Tidb) GetLatestVersion 

func (t *Tidb) GetLatestVersion(tableName string) string

func (*Tidb) GetMigrationByVersion 

func (t *Tidb) GetMigrationByVersion(tableName string) string

func (*Tidb) InsertVersion 

func (t *Tidb) InsertVersion(tableName string) string

func (*Tidb) ListMigrations 

func (t *Tidb) ListMigrations(tableName string) string

type Turso 

type Turso struct {
	Sqlite3
}

type Vertica 

type Vertica struct{}

func (*Vertica) CreateTable 

func (v *Vertica) CreateTable(tableName string) string

func (*Vertica) DeleteVersion 

func (v *Vertica) DeleteVersion(tableName string) string

func (*Vertica) GetLatestVersion 

func (v *Vertica) GetLatestVersion(tableName string) string

func (*Vertica) GetMigrationByVersion 

func (v *Vertica) GetMigrationByVersion(tableName string) string

func (*Vertica) InsertVersion 

func (v *Vertica) InsertVersion(tableName string) string

func (*Vertica) ListMigrations 

func (v *Vertica) ListMigrations(tableName string) string

type Ydb 

type Ydb struct{}

func (*Ydb) CreateTable 

func (c *Ydb) CreateTable(tableName string) string

func (*Ydb) DeleteVersion 

func (c *Ydb) DeleteVersion(tableName string) string

func (*Ydb) GetLatestVersion 

func (c *Ydb) GetLatestVersion(tableName string) string

func (*Ydb) GetMigrationByVersion 

func (c *Ydb) GetMigrationByVersion(tableName string) string

func (*Ydb) InsertVersion 

func (c *Ydb) InsertVersion(tableName string) string

func (*Ydb) ListMigrations 

func (c *Ydb) ListMigrations(tableName string) string

Source Files

clickhouse.go dialectquery.go mysql.go postgres.go redshift.go sqlite3.go sqlserver.go starrocks.go tidb.go turso.go vertica.go ydb.go

Version
v3.24.2 (latest)
Published
Mar 28, 2025
Platform
js/wasm
Imports
2 packages
Last checked
27 minutes ago –

Tools for package owners.