mysql

package

v0.0.0-...-2feb83d Latest Latest Go to latest Published: Apr 30, 2024 License: Apache-2.0 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

Package mysql provides a MySQL client to interact with a MySQL server.

View Source

const (
	// User is the username used for authentication
	User = "root"
	// Pass is the password used for authentication
	Pass = "root"
)

This section is empty.

func RunServer(t testing.TB, serverAddr, serverPort string) error

RunServer runs a MySQL server in a docker container

type Client struct {
	DB *sql.DB
	// contains filtered or unexported fields
}

Client is a MySQL client.

func NewClient(opts Options) (*Client, error)

NewClient returns a new MySQL client.

func (c *Client) AlterTable() error

AlterTable alters the table.

func (c *Client) CreateDB() error

CreateDB creates a database.

func (c *Client) CreateTable() error

CreateTable creates a table.

func (c *Client) DeleteFromTable(name string) error

DeleteFromTable deletes a row from the table.

func (c *Client) DropDB() error

DropDB drops the database.

func (c *Client) DropTable() error

DropTable drops the table.

func (c *Client) InsertIntoTable(name string, population int) error

InsertIntoTable inserts a row into the table.

func (c *Client) SelectAllFromTable() error

SelectAllFromTable select all rows from the table.

func (c *Client) SelectFromTable(name string) (int, error)

SelectFromTable selects a row from the table.

func (c *Client) UpdateTable(srcName, newName string, newPopulation int) error

UpdateTable updates a row in the table.

type Options struct {
	ServerAddress string
	Username      string
	Password      string
	DatabaseName  string
	Dialer        *net.Dialer
}

Options contains the options to connect to a MySQL server.