gomysql

gomysql package

When I make some of my projects, I use a MySQL database. I realized I ended up writing very similar code for each project to connect to the database, execute queries, and handle results. To avoid this repetition, I created the gomysql package. It utilizes go's reflect package to handle different types of structs to create tables, and execute a basic insert, select, update, delete, and list operations.

Usage

To use the gomysql package, you need to import it in your Go project. Here's a basic example of how to use it:

import "github.com/z46-dev/gomysql"

Now, let's create a struct that represents a table in the database. This package uses custom struct tags to define table structure, and its fields. Here's an example of a struct that represents a User table:

type User struct {
    Username string     `gomysql:"username,primary,unique"`
    Password string     `gomysql:"password"`
    Email    string     `gomysql:"email,unique"`
    CreatedAt time.Time `gomysql:"creation"`
}

Now, we should register this struct to set up the database tables:

func main() {
    var (
        handle *gomysql.RegisteredStruct[User]
        err    error
    )

    if err = gomysql.Begin(":memory:"); err != nil {
        panic(err)
    }

    if handle, err = gomysql.Register(User{}); err != nil {
        panic(err)
    }
}

You can now call functions on the handle to perform database operations.

Contributing

This was thrown together in a few hours, so there are likely many improvements that can be made. If you have suggestions or improvements, feel free to open an issue or submit a pull request. I would love to see this package grow.