MySQL query builder for Golang
WARNING: Not ready for production yet
- Building SQL queries
- Executing SQL queries
package main
import (
"fmt"
"github.com/mitoteam/mysqlann"
"database/sql"
)
func main(){
//creating query
q := mysqlann.Select("mt_user", "u", "Role", "UserName").
Where("ID", 67).
Limit(1)
fmt.Println("SQL:")
fmt.Println(q.Sql())
//initialize connection pool
db, _ := sql.Open("mysql", "user:password@tcp(webdev4.test)/test") //use your own DSN
mysqlann.SetDB(db)
//run query
row_values, _ := q.QueryRowMap()
fmt.Println("Result: ", row_values)
}Will produce
SQL:
SELECT `u`.`Role` AS `Role`,
`u`.`UserName` AS `UserName`
FROM `mt_user` u
WHERE (ID = 67)
LIMIT 1
Result: map[Role:admin UserName:TestUser]
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent