mysql

package

v0.0.0-...-ebc8d01 Latest Latest Go to latest Published: Jan 13, 2019 License: MIT Imports: 3 Imported by: 1

Details

This section is empty.

This section is empty.

func CreateDatabase(db *sql.DB) error

CreateDatabase create database sms.

func CreateTable(db *sql.DB) error

CreateTable create sms.msg table.

func Delete(db *sql.DB, sign string) error

Clear delete a msg.

func GetCode(db *sql.DB, sign string) (string, error)

GetCode return sms date and nil or "0"and err.

func GetDate(db *sql.DB, sign string) (int64, error)

GetDate return sms date(unixtime) and nil if no err,or (0,err).

func GetMobile(db *sql.DB, sign string) (string, error)

GetMobile return User's mobile like ID or "0" and err

func Insert(db *sql.DB, mobile string, date int64, code string, sign string) error

Insert Insert a new sms.

type Message struct {
	Mobile string `db:"mobile"`
	Date   int64  `db:"date"`
	Code   string `db:"code"`
	Sign   string `db:"sign"`
}

func GetMessage(db *sql.DB, sign string) *Message

GetMessage return msg