database

Documentation

Index

• type Command
• type ICursor
• type ISqlDatabase
• type ISqlSchema
• type ISqlTransaction
• type Iterator
• type Parameter
• type SqlTransactionHandler

Types

type Command

type Command = string

type ICursor

type ICursor interface {
	Scan(...Parameter) error
}

type ISqlDatabase

type ISqlDatabase interface {
	Initialize() error
	GetName() string
	GetSchema() ISqlSchema
	RunScript(string, string) error
	Query(Iterator, Command, ...Parameter) error
	QuerySingle(Iterator, Command, ...Parameter) error
	Execute(Command, ...Parameter) (int64, error)
	ExecuteAtomic(ISqlTransaction, Command, ...Parameter) (int64, error)
	ExecuteBatch(Command, int64, ...Parameter) (int64, error)
	InsertSingle(Command, ...Parameter) error
	InsertSingleAtomic(ISqlTransaction, Command, ...Parameter) error
	UpdateSingle(Command, ...Parameter) error
	UpdateSingleAtomic(ISqlTransaction, Command, ...Parameter) error
	DeleteSingle(Command, ...Parameter) error
	DeleteSingleAtomic(ISqlTransaction, Command, ...Parameter) error
	InsertAll(Command, int64, ...Parameter) error
	Count(Command, ...Parameter) (int, error)
	WithTransaction(SqlTransactionHandler) error
	OnChanged(func(...string))
}

type ISqlSchema

type ISqlSchema interface {
	GetTables() []string
	GetColumns(table string) []string
	GetTriggers() []string
	HasTable(table string) bool
	HasHistoryTable(table string) bool
	HasColumn(table, column string) bool
	HasTrigger(trigger string) bool
}

type ISqlTransaction

type ISqlTransaction interface {
	OnCommit(func())
}

type Iterator

type Iterator func(ICursor) error

type Parameter

type Parameter = interface{}

type SqlTransactionHandler

type SqlTransactionHandler func(transaction ISqlTransaction) error