SqlUtils

package
v0.0.0-...-e7f2ee2 Latest Latest
Warning

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

Go to latest
Published: Nov 17, 2024 License: Apache-2.0 Imports: 6 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type ClickHouseDatabase

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

func NewClickHouseDatabase

func NewClickHouseDatabase(user, password, address, port string) (*ClickHouseDatabase, error)

func (*ClickHouseDatabase) ExecuteSql

func (c *ClickHouseDatabase) ExecuteSql(sql string) (map[string]interface{}, error)

todo clickhouse impl 未完成

func (*ClickHouseDatabase) GetSourceDatabases

func (c *ClickHouseDatabase) GetSourceDatabases() ([]string, error)

func (*ClickHouseDatabase) GetSourceTableColumns

func (c *ClickHouseDatabase) GetSourceTableColumns(database, table string) ([]Column, error)

func (*ClickHouseDatabase) GetSourceTables

func (c *ClickHouseDatabase) GetSourceTables(database string) ([]string, error)

type Column

type Column struct {
	Field   string         `json:"name"`
	Type    string         `json:"type"`
	Null    string         `json:"-"`
	Key     string         `json:"-"`
	Default sql.NullString `json:"-"`
	Extra   string         `json:"-"`
}

type IColumn

type IColumn struct {
	Name  string `json:"name"`
	Type  string `json:"type"`
	Value string `json:"value"`
}

type IDatabase

type IDatabase interface {
	GetSourceDatabases() ([]string, error)
	GetSourceTables(database string) ([]string, error)
	GetSourceTableColumns(database string, table string) ([]Column, error)
	ExecuteSql(sql string) (map[string]interface{}, error)
}

func GetDatabaseInstance

func GetDatabaseInstance(dbType, user, password, address, port string) (IDatabase, error)

type MysqlDatabase

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

func NewMysqlDatabase

func NewMysqlDatabase(user, password, address, port string) (*MysqlDatabase, error)

func (*MysqlDatabase) ExecuteSql

func (m *MysqlDatabase) ExecuteSql(sqlSentence string) (map[string]interface{}, error)

func (*MysqlDatabase) GetSourceDatabases

func (m *MysqlDatabase) GetSourceDatabases() ([]string, error)

func (*MysqlDatabase) GetSourceTableColumns

func (m *MysqlDatabase) GetSourceTableColumns(database string, table string) ([]Column, error)

func (*MysqlDatabase) GetSourceTables

func (m *MysqlDatabase) GetSourceTables(database string) ([]string, error)

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL