db

package

v0.0.0-...-61c4a81 Latest Latest Go to latest Published: Aug 23, 2017 License: Unlicense Imports: 7 Imported by: 0

Details

Valid go.mod file
Redistributable license
Tagged version
Stable version
Learn more about best practices

Repository

github.com/20170824LGG/STS

Links

Open Source Insights

Documentation ¶

Index ¶

Constants
Variables
func Connect(dsn string) (*sql.DB, error)
func CreateSchema(db *sql.DB) error
func PlayerGet(q squirrel.Queryer, playerID string) (*core.Player, error)
func PlayerGetForUpdate(q squirrel.Queryer, playerID string) (*core.Player, error)
func PlayerInsert(e squirrel.Execer, player *core.Player) error
func PlayerSelectForUpdate(q squirrel.Queryer, playerIDs []string) (map[string]*core.Player, error)
func PlayerUpdate(e squirrel.Execer, player *core.Player) error
func RecreateDB(dsn string) error
func TournPlayerGet(q squirrel.Queryer, tournamentID int, playerID string) (*core.TournPlayer, error)
func TournPlayerInsert(e squirrel.Execer, tp *core.TournPlayer) error
func TournPlayerSelect(q squirrel.Queryer, d queryDecorator) ([]core.TournPlayer, error)
func TournamentGet(q squirrel.Queryer, tournamentID int) (*core.Tournament, error)
func TournamentGetForUpdate(q squirrel.Queryer, tournamentID int) (*core.Tournament, error)
func TournamentInsert(e squirrel.Execer, t *core.Tournament) error
func TournamentUpdate(e squirrel.Execer, t *core.Tournament) error
func TournamentWinnerInsert(e squirrel.Execer, tp *core.TournWinner) error
func Transaction(db *sql.DB, body func(*sql.Tx) error) error

Constants ¶

View Source

const (
	TinyTextMaxLength   int = (1 << 8) - 1  // Max size of TINYTEXT, TINYBLOB fields
	TextMaxLength       int = (1 << 16) - 1 // Max size of TEXT, BLOB fields
	MediumTextMaxLength int = (1 << 24) - 1 // Max size of MEDIUMTEXT, MEDIUMBLOB fields
)

Maximum sizes for MySQL/MariaDB text fields

Variables ¶

View Source

var ErrAlreadyExists = errors.New("db: already exists")

View Source

var ErrNotFound = errors.New("db: not found")

Functions ¶

func Connect ¶

func Connect(dsn string) (*sql.DB, error)

func CreateSchema ¶

func CreateSchema(db *sql.DB) error

func PlayerGet ¶

func PlayerGet(q squirrel.Queryer, playerID string) (*core.Player, error)

func PlayerGetForUpdate ¶

func PlayerGetForUpdate(q squirrel.Queryer, playerID string) (*core.Player, error)

func PlayerInsert ¶

func PlayerInsert(e squirrel.Execer, player *core.Player) error

func PlayerSelectForUpdate ¶

func PlayerSelectForUpdate(q squirrel.Queryer, playerIDs []string) (map[string]*core.Player, error)

func PlayerUpdate ¶

func PlayerUpdate(e squirrel.Execer, player *core.Player) error

func RecreateDB ¶

func RecreateDB(dsn string) error

func TournPlayerGet ¶

func TournPlayerGet(q squirrel.Queryer, tournamentID int, playerID string) (*core.TournPlayer, error)

func TournPlayerInsert ¶

func TournPlayerInsert(e squirrel.Execer, tp *core.TournPlayer) error

func TournPlayerSelect ¶

func TournPlayerSelect(q squirrel.Queryer, d queryDecorator) ([]core.TournPlayer, error)

func TournamentGet ¶

func TournamentGet(q squirrel.Queryer, tournamentID int) (*core.Tournament, error)

func TournamentGetForUpdate ¶

func TournamentGetForUpdate(q squirrel.Queryer, tournamentID int) (*core.Tournament, error)

func TournamentInsert ¶

func TournamentInsert(e squirrel.Execer, t *core.Tournament) error

func TournamentUpdate ¶

func TournamentUpdate(e squirrel.Execer, t *core.Tournament) error

func TournamentWinnerInsert ¶

func TournamentWinnerInsert(e squirrel.Execer, tp *core.TournWinner) error

func Transaction ¶

func Transaction(db *sql.DB, body func(*sql.Tx) error) error

Types ¶

This section is empty.

Source Files ¶

View all Source files

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL