package main import ( "github.com/coralproject/shelf.internal/platform/db" ) func main() { config := db.Config{ Host: "localhost", Port: 3306, DbName: "mydatabase", User: "myuser", Password: "mypassword", Type: db.TypeMySQL, } conn, err := db.NewConnection(config) if err != nil { panic(err) } defer conn.Close() // Use the connection here... }
package main import ( "fmt" "github.com/coralproject/shelf.internal/platform/db" ) func main() { config := db.Config{ Host: "localhost", Port: 3306, DbName: "mydatabase", User: "myuser", Password: "mypassword", Type: db.TypeMySQL, } conn, err := db.NewConnection(config) if err != nil { panic(err) } defer conn.Close() // Querying data from MySQL database rows, err := conn.Query("SELECT name, age FROM users") if err != nil { panic(err) } defer rows.Close() for rows.Next() { var name string var age int err = rows.Scan(&name, &age) if err != nil { panic(err) } fmt.Println("Name:", name, "Age:", age) } }Both examples demonstrate the simplicity and ease of use of the github.com/coralproject.shelf.internal.platform.db DB package library. This package library provides a unified interface for accessing various types of databases, which means that the same code can be used for multiple databases with minimal changes.