db

package

v0.0.0-...-d17e1d7 Latest Latest Go to latest Published: Mar 22, 2020 License: MIT Imports: 9 Imported by: 0

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

Database interaction package.

View Source

const SCHEMA = `` /* 389-byte string literal not displayed */

SQL Queries to create the schemas.

View Source

var DB *sqlx.DB

func Begin() (*sqlx.Tx, error)

func Close() error

func Exec(query string, args ...interface{}) (sql.Result, error)

func Get(dest interface{}, query string, args ...interface{}) error

func GetBalance(id, guild string) int64

func GetPrefix(id string) string

func MustBegin() *sqlx.Tx

func MustExec(query string, args ...interface{}) sql.Result

func Query(query string, args ...interface{}) (*sql.Rows, error)

func QueryRow(query string, args ...interface{}) *sql.Row

func SetPrefix(guild, prefix string) error

type Bot struct {
	ID  string `db:"id"`
	PSA struct {
		Text string `db:"text"`
		Date int64  `db:"date"`
	} `db:"psa"`
}

func GetBotData() (*Bot, error)

type Guild struct {
	ID     string `db:"id"`
	Prefix string `db:"prefix"`
}

func GetGuild(id string) (*Guild, error)

type Member struct {
	ID     string `db:"id"`
	Guild  string `db:"guild"`
	Points int64  `db:"points"`
	Level  int    `db:"level"`
}