dm

README

GORM DM8 Driver

达梦数据库gorm驱动

Quick Start

import (
  "github.com/Leefs/gorm-driver-dm"
  "gorm.io/gorm"
)

// https://github.com/Leefs/gorm-driver-dm
dsn := "dm://SYSDBA:SYSDBA@127.0.0.1:5236?autoCommit=true"
db, err := gorm.Open(dm.Open(dsn), &gorm.Config{})

达梦数据库用户名即模式名

入门

• clone本项目到本地，进入项目目录，打开dm_test.go
• 修改dsn调整为本地正确信息
• 运行go test -v
• 如果无报错，参考dm_test.go使用即可

注意事项

• 超过4096长度字符串，需要使用dmSchema.Clob，不超过使用string即可
• 列名不要使用达梦关键字，否则会出现错误

修改BUG

• 解决达梦双单引号转义问题

Documentation

Index

• Variables
• func ConvertNameToFormat(x string) string
• func Create(db *gorm.DB)
• func ExplainSQL(sql string, numericPlaceholder *regexp.Regexp, escaper string, ...) string
• func IsReservedWord(v string) bool
• func New(config Config) gorm.Dialector
• func Open(dsn string) gorm.Dialector
• func RefClone(inter interface{}) interface{}
• func RefInclude(inter interface{}, inc []string) interface{}
• func ReplacementQuote(value string)
• func TB(db *gorm.DB)
• type BuildIndexOptionsInterface
• type Config
• type Dialector
  • func (d Dialector) BindVarTo(writer clause.Writer, stmt *gorm.Statement, v interface{})
  • func (d Dialector) ClauseBuilders() map[string]clause.ClauseBuilder
  • func (d Dialector) DataTypeOf(field *schema.Field) string
  • func (d Dialector) DefaultValueOf(*schema.Field) clause.Expression
  • func (d Dialector) DummyTableName() string
  • func (d Dialector) Explain(sql string, vars ...interface{}) string
  • func (d Dialector) Initialize(db *gorm.DB) (err error)
  • func (d Dialector) Migrator(db *gorm.DB) gorm.Migrator
  • func (d Dialector) Name() string
  • func (d Dialector) QuoteTo(writer clause.Writer, str string)
  • func (d Dialector) RewriteLimit(c clause.Clause, builder clause.Builder)
  • func (d Dialector) RewriteWhere(c clause.Clause, builder clause.Builder)
  • func (d Dialector) RollbackTo(tx *gorm.DB, name string) error
  • func (d Dialector) SavePoint(tx *gorm.DB, name string) error
• type Migrator
  • func (m Migrator) AddColumn(value interface{}, field string) error
  • func (m Migrator) AlterColumn(value interface{}, field string) error
  • func (m Migrator) CreateConstraint(value interface{}, name string) error
  • func (m Migrator) CreateIndex(value interface{}, name string) error
  • func (m Migrator) CreateTable(values ...interface{}) error
  • func (m Migrator) CurrentDatabase() (name string)
  • func (m Migrator) DropColumn(value interface{}, name string) error
  • func (m Migrator) DropConstraint(value interface{}, name string) error
  • func (m Migrator) DropIndex(value interface{}, name string) error
  • func (m Migrator) DropTable(values ...interface{}) error
  • func (m Migrator) HasColumn(value interface{}, field string) bool
  • func (m Migrator) HasConstraint(value interface{}, name string) bool
  • func (m Migrator) HasIndex(value interface{}, name string) bool
  • func (m Migrator) HasTable(value interface{}) bool
  • func (m Migrator) RenameIndex(value interface{}, oldName, newName string) error
  • func (m Migrator) RenameTable(oldName, newName interface{}) (err error)
  • func (m Migrator) TryQuotifyReservedWords(values ...interface{}) error
  • func (m Migrator) TryRemoveOnUpdate(values ...interface{}) error
• type Namer
  • func (n Namer) CheckerName(table, column string) (name string)
  • func (n Namer) ColumnName(table, column string) (name string)
  • func (n Namer) IndexName(table, column string) (name string)
  • func (n Namer) JoinTableName(table string) (name string)
  • func (n Namer) RelationshipFKName(relationship schema.Relationship) (name string)
  • func (n Namer) TableName(table string) (name string)
• type STable
  • func Table(table ...interface{}) *STable
  • func (stb *STable) AutoMigrate(dst ...interface{}) error
  • func (stb *STable) ClausesAssignmentColumns(name string, doUpdates []string) error
  • func (stb *STable) Create() error
  • func (stb *STable) DB() (*sql.DB, error)
  • func (stb *STable) Delete() error
  • func (stb *STable) DropTable(dest ...interface{}) error
  • func (stb *STable) Get(dest interface{}, conds ...interface{}) error
  • func (stb *STable) GetAll(dest interface{}) error
  • func (stb *STable) GetWhere(dest interface{}) error
  • func (stb *STable) HasTable(dest interface{}) bool
  • func (stb *STable) Model() *gorm.DB
  • func (stb *STable) Update(dest interface{}) error

Variables

var ReservedWords = hashset.New(funk.Map(ReservedWordsList, func(s string) interface{} { return s }).([]interface{})...)

var ReservedWordsList = []string{}/* 142 elements not displayed */

Functions

func ConvertNameToFormat

func ConvertNameToFormat(x string) string

func Create

func Create(db *gorm.DB)

func ExplainSQL

func ExplainSQL(sql string, numericPlaceholder *regexp.Regexp, escaper string, avars ...interface{}) string

ExplainSQL generate SQL string with given parameters, the generated SQL is expected to be used in logger, execute it might introduce a SQL injection vulnerability

func IsReservedWord

func IsReservedWord(v string) bool

func New

func New(config Config) gorm.Dialector

func Open

func Open(dsn string) gorm.Dialector

func RefClone

func RefClone(inter interface{}) interface{}

func RefInclude

func RefInclude(inter interface{}, inc []string) interface{}

func ReplacementQuote

func ReplacementQuote(value string)

func TB

func TB(db *gorm.DB)

Types

type BuildIndexOptionsInterface

type BuildIndexOptionsInterface interface {
	BuildIndexOptions([]schema.IndexOption, *gorm.Statement) []interface{}
}

type Config

type Config struct {
	DriverName        string
	DSN               string
	Conn              *sql.DB
	DefaultStringSize uint
}

type Dialector

type Dialector struct {
	*Config
}

func (Dialector) BindVarTo

func (d Dialector) BindVarTo(writer clause.Writer, stmt *gorm.Statement, v interface{})

func (Dialector) ClauseBuilders

func (d Dialector) ClauseBuilders() map[string]clause.ClauseBuilder

func (Dialector) DataTypeOf

func (d Dialector) DataTypeOf(field *schema.Field) string

func (Dialector) DefaultValueOf

func (d Dialector) DefaultValueOf(*schema.Field) clause.Expression

func (Dialector) DummyTableName

func (d Dialector) DummyTableName() string

func (Dialector) Explain

func (d Dialector) Explain(sql string, vars ...interface{}) string

func (Dialector) Initialize

func (d Dialector) Initialize(db *gorm.DB) (err error)

func (Dialector) Migrator

func (d Dialector) Migrator(db *gorm.DB) gorm.Migrator

func (Dialector) Name

func (d Dialector) Name() string

func (Dialector) QuoteTo

func (d Dialector) QuoteTo(writer clause.Writer, str string)

func (Dialector) RewriteLimit

func (d Dialector) RewriteLimit(c clause.Clause, builder clause.Builder)

func (Dialector) RewriteWhere

func (d Dialector) RewriteWhere(c clause.Clause, builder clause.Builder)

func (Dialector) RollbackTo

func (d Dialector) RollbackTo(tx *gorm.DB, name string) error

func (Dialector) SavePoint

func (d Dialector) SavePoint(tx *gorm.DB, name string) error

type Migrator

type Migrator struct {
	migrator.Migrator
}

func (Migrator) AddColumn

func (m Migrator) AddColumn(value interface{}, field string) error

func (Migrator) AlterColumn

func (m Migrator) AlterColumn(value interface{}, field string) error

func (Migrator) CreateConstraint

func (m Migrator) CreateConstraint(value interface{}, name string) error

func (Migrator) CreateIndex

func (m Migrator) CreateIndex(value interface{}, name string) error

func (Migrator) CreateTable

func (m Migrator) CreateTable(values ...interface{}) error

func (Migrator) CurrentDatabase

func (m Migrator) CurrentDatabase() (name string)

func (Migrator) DropColumn

func (m Migrator) DropColumn(value interface{}, name string) error

func (Migrator) DropConstraint

func (m Migrator) DropConstraint(value interface{}, name string) error

func (Migrator) DropIndex

func (m Migrator) DropIndex(value interface{}, name string) error

func (Migrator) DropTable

func (m Migrator) DropTable(values ...interface{}) error

func (Migrator) HasColumn

func (m Migrator) HasColumn(value interface{}, field string) bool

func (Migrator) HasConstraint

func (m Migrator) HasConstraint(value interface{}, name string) bool

func (Migrator) HasIndex

func (m Migrator) HasIndex(value interface{}, name string) bool

func (Migrator) HasTable

func (m Migrator) HasTable(value interface{}) bool

func (Migrator) RenameIndex

func (m Migrator) RenameIndex(value interface{}, oldName, newName string) error

https://docs.dm.com/database/121/SPATL/alter-index-rename.htm

func (Migrator) RenameTable

func (m Migrator) RenameTable(oldName, newName interface{}) (err error)

func (Migrator) TryQuotifyReservedWords

func (m Migrator) TryQuotifyReservedWords(values ...interface{}) error

func (Migrator) TryRemoveOnUpdate

func (m Migrator) TryRemoveOnUpdate(values ...interface{}) error

type Namer

type Namer struct {
	schema.NamingStrategy
}

func (Namer) CheckerName

func (n Namer) CheckerName(table, column string) (name string)

func (Namer) ColumnName

func (n Namer) ColumnName(table, column string) (name string)

func (Namer) IndexName

func (n Namer) IndexName(table, column string) (name string)

func (Namer) JoinTableName

func (n Namer) JoinTableName(table string) (name string)

func (Namer) RelationshipFKName

func (n Namer) RelationshipFKName(relationship schema.Relationship) (name string)

func (Namer) TableName

func (n Namer) TableName(table string) (name string)

type STable

type STable struct {
	Conn  *gorm.DB
	Table interface{}
}

func Table

func Table(table ...interface{}) *STable

func (*STable) AutoMigrate

func (stb *STable) AutoMigrate(dst ...interface{}) error

func (*STable) ClausesAssignmentColumns

func (stb *STable) ClausesAssignmentColumns(name string, doUpdates []string) error

func (*STable) Create

func (stb *STable) Create() error

func (*STable) DB

func (stb *STable) DB() (*sql.DB, error)

func (*STable) Delete

func (stb *STable) Delete() error

func (*STable) DropTable

func (stb *STable) DropTable(dest ...interface{}) error

func (*STable) Get

func (stb *STable) Get(dest interface{}, conds ...interface{}) error

func (*STable) GetAll

func (stb *STable) GetAll(dest interface{}) error

func (*STable) GetWhere

func (stb *STable) GetWhere(dest interface{}) error

func (*STable) HasTable

func (stb *STable) HasTable(dest interface{}) bool

func (*STable) Model

func (stb *STable) Model() *gorm.DB

func (*STable) Update

func (stb *STable) Update(dest interface{}) error