ms_access

Documentation

Index

• func AddField(table string, f Field) string
• func AlterField(table string, f Field) string
• func CreateTable(name string, fields ...Field) string
• func DeleteRow(table string, where map[Field]any) string
• func DropField(table, field string) string
• func DropTable(name string) string
• func InsertRow(table string, values map[Field]any) string
• func InsertRows(table string, fields []Field, rows [][]any) (string, error)
• func QuoteString(s string) (sql string)
• func UpdateRow(table string, values map[Field]any, where map[Field]any) string
• type Connection
  • func NewConnection(dsn, passwd string) *Connection
  • func (m *Connection) Close() error
  • func (m *Connection) Open() error
• type Field
  • func (f Field) Sql() string
• type Type

Functions

func AddField

func AddField(table string, f Field) string

func AlterField

func AlterField(table string, f Field) string

func CreateTable

func CreateTable(name string, fields ...Field) string

CreateTable creates a table

func DeleteRow

func DeleteRow(table string, where map[Field]any) string

DeleteRow deletes a row

func DropField

func DropField(table, field string) string

func DropTable

func DropTable(name string) string

DropTable removes a table

func InsertRow

func InsertRow(table string, values map[Field]any) string

InsertRow inserts a row

func InsertRows

func InsertRows(table string, fields []Field, rows [][]any) (string, error)

InsertRows inserts several rows, the order and length of the fields and each row must match

func QuoteString

func QuoteString(s string) (sql string)

func UpdateRow

func UpdateRow(table string, values map[Field]any, where map[Field]any) string

UpdateRow updates a row

Types

type Connection

type Connection struct {
	DSN string
	PW  string
	UID string
	DB  *sql.DB
}

func NewConnection

func NewConnection(dsn, passwd string) *Connection

NewConnection creates a new ODBC connection

func (*Connection) Close

func (m *Connection) Close() error

Close closes the ODBC connection

func (*Connection) Open

func (m *Connection) Open() error

Open opens the odbc connection

type Field

type Field struct {
	Name string
	Type Type
	Null bool
	Size [2]int
}

func (Field) Sql

func (f Field) Sql() string

type Type

type Type string

var (
	Type_COUNTER  Type = "COUNTER"
	Type_BYTE     Type = "BYTE"
	Type_SMALLINT Type = "SMALLINT"
	Type_INTEGER  Type = "INTEGER"
	Type_REAL     Type = "REAL"
	Type_FLOAT    Type = "FLOAT"
	// Type_DECIMAL(18,5) FieldType = "DECIMAL(18,5)"
	Type_MONEY            Type = "MONEY"
	Type_VARCHAR          Type = "VARCHAR"
	Type_MEMO             Type = "MEMO"
	Type_DATETIME         Type = "DATETIME"
	Type_BIT              Type = "BIT"
	Type_IMAGE            Type = "IMAGE"
	Type_UNIQUEIDENTIFIER Type = "UNIQUEIDENTIFIER"
)