mysql

Documentation

Index

• func DB() (*sql.DB, error)
• func Refresh()
• type MyTable
  • func New() *MyTable
  • func (myTable *MyTable) AddColumn(names ...string) *MyTable
  • func (myTable *MyTable) AutoInsert(value []string) *MyTable
  • func (m *MyTable) Clone() *MyTable
  • func (myTable *MyTable) Create() error
  • func (myTable *MyTable) CustomPrimaryKey(primaryKeyCode string) *MyTable
  • func (myTable *MyTable) FlushInsert() error
  • func (myTable *MyTable) SelectAll() (*sql.Rows, error)
  • func (myTable *MyTable) SetTableName(name string) *MyTable
  • func (myTable *MyTable) Truncate() error

Functions

func DB

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

func Refresh

func Refresh()

Types

type MyTable

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

************************ MySQL Output *************************** // sql conversion structure

func New

func New() *MyTable

func (*MyTable) AddColumn

func (myTable *MyTable) AddColumn(names ...string) *MyTable

set the form column

func (*MyTable) AutoInsert

func (myTable *MyTable) AutoInsert(value []string) *MyTable

Smart insert data, one line at a time

func (*MyTable) Clone

func (m *MyTable) Clone() *MyTable

func (*MyTable) Create

func (myTable *MyTable) Create() error

generate a "create a form" statement, before implementation to ensure that SetTableName (), AddColumn () has been implemented

func (*MyTable) CustomPrimaryKey

func (myTable *MyTable) CustomPrimaryKey(primaryKeyCode string) *MyTable

set the primary key statement (optional)

func (*MyTable) FlushInsert

func (myTable *MyTable) FlushInsert() error

Add sqlCode "insert data" statement, before implementation to ensure that Create (), AutoInsert () has been implemented

func (*MyTable) SelectAll

func (myTable *MyTable) SelectAll() (*sql.Rows, error)

Get all the data

func (*MyTable) SetTableName

func (myTable *MyTable) SetTableName(name string) *MyTable

set the table name

func (*MyTable) Truncate

func (myTable *MyTable) Truncate() error

Empty the form before execution to ensure that SetTableName () has been executed