mysql

Documentation

Index

• Constants
• type Column
  • func NewColumn(n string, v string) *Column
• type ColumnDefinition
  • func NewColumnDefinition(n string, dt string, pk bool) *ColumnDefinition
• type MySQL
  • func (this *MySQL) Close()
  • func (this *MySQL) ConnectServer()
  • func (this *MySQL) CreateDB(dbName string)
  • func (this *MySQL) CreateDBSetChar(dbName string, charType string)
  • func (this *MySQL) CreateTable(tableName string, columns []ColumnDefinition)
  • func (this *MySQL) Delete(tableName string, whereColumn string, whereValue string)
  • func (this *MySQL) FetchAll(qSql string) [][]interface{}
  • func (this *MySQL) Insert(tableName string, columns []Column)
  • func (this *MySQL) Query(qSql string) *sql.Rows
  • func (this *MySQL) QueryRow(qSql string) *sql.Row
  • func (this *MySQL) Update(tableName string, setColumn string, setValue string, whereColumn string, ...)
  • func (this *MySQL) UseDB(dbName string)

Constants

const Pass = ""

const Port = "3306"

const User = "root"

起動前に変更

Types

type Column

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

func NewColumn

func NewColumn(n string, v string) *Column

type ColumnDefinition

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

func NewColumnDefinition

func NewColumnDefinition(n string, dt string, pk bool) *ColumnDefinition

type MySQL

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

func (*MySQL) Close

func (this *MySQL) Close()

func (*MySQL) ConnectServer

func (this *MySQL) ConnectServer()

func (*MySQL) CreateDB

func (this *MySQL) CreateDB(dbName string)

func (*MySQL) CreateDBSetChar

func (this *MySQL) CreateDBSetChar(dbName string, charType string)

func (*MySQL) CreateTable

func (this *MySQL) CreateTable(tableName string, columns []ColumnDefinition)

func (*MySQL) Delete

func (this *MySQL) Delete(tableName string, whereColumn string, whereValue string)

func (*MySQL) FetchAll

func (this *MySQL) FetchAll(qSql string) [][]interface{}

func (*MySQL) Insert

func (this *MySQL) Insert(tableName string, columns []Column)

func (*MySQL) Query

func (this *MySQL) Query(qSql string) *sql.Rows

func (*MySQL) QueryRow

func (this *MySQL) QueryRow(qSql string) *sql.Row

func (*MySQL) Update

func (this *MySQL) Update(tableName string, setColumn string, setValue string, whereColumn string, whereValue string)

func (*MySQL) UseDB

func (this *MySQL) UseDB(dbName string)