dialectquery

package
v3.24.1 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Jan 7, 2025 License: MIT Imports: 2 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

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 added in v3.21.0 

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 added in v3.21.0 

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

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 added in v3.21.0 

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 added in v3.23.1 

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 added in v3.23.1 

type QueryController struct{ Querier }

func NewQueryController added in v3.23.1 

func NewQueryController(querier Querier) *QueryController

NewQueryController returns a new QueryController that wraps the given Querier.

func (*QueryController) TableExists added in v3.23.1 

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 added in v3.21.0 

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 added in v3.21.0 

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 added in v3.21.0 

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 added in v3.23.0 

type Starrocks struct{}

func (*Starrocks) CreateTable added in v3.23.0 

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

func (*Starrocks) DeleteVersion added in v3.23.0 

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

func (*Starrocks) GetLatestVersion added in v3.23.0 

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

func (*Starrocks) GetMigrationByVersion added in v3.23.0 

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

func (*Starrocks) InsertVersion added in v3.23.0 

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

func (*Starrocks) ListMigrations added in v3.23.0 

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 added in v3.21.0 

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 added in v3.18.0 

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 added in v3.21.0 

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 added in v3.16.0 

type Ydb struct{}

func (*Ydb) CreateTable added in v3.16.0 

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

func (*Ydb) DeleteVersion added in v3.16.0 

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

func (*Ydb) GetLatestVersion added in v3.21.0 

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

func (*Ydb) GetMigrationByVersion added in v3.16.0 

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

func (*Ydb) InsertVersion added in v3.16.0 

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

func (*Ydb) ListMigrations added in v3.16.0 

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

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.