package users
import (
"database/sql"
"fmt"
_ "/ziutek/mymysql/godrv"
)
const (
DB_NAME = "mysql_database_name"
DB_USER = "mysql_user"
DB_PASS = "mysql_password"
)
type User struct {
Id int `json:"id"`
Name string `json:"name"`
Alias string `json:"alias"`
}
func OpenDB() * {
db, err := ("mymysql", ("%s/%s/%s", DB_NAME, DB_USER, DB_PASS))
if err != nil {
panic(err)
}
return db
}
func UserById(id int) User {
db := OpenDB()
defer ()
row := ("SELECT `id`, `name`,`alias` FROM `users` WHERE id=?", id)
user := new(User)
(&, &, &)
return user
}
import (
"database/sql"
"fmt"
_ "/ziutek/mymysql/godrv"
)
const (
DB_NAME = "mysql_database_name"
DB_USER = "mysql_user"
DB_PASS = "mysql_password"
)
type User struct {
Id int `json:"id"`
Name string `json:"name"`
Alias string `json:"alias"`
}
func OpenDB() * {
db, err := ("mymysql", ("%s/%s/%s", DB_NAME, DB_USER, DB_PASS))
if err != nil {
panic(err)
}
return db
}
func UserById(id int) User {
db := OpenDB()
defer ()
row := ("SELECT `id`, `name`,`alias` FROM `users` WHERE id=?", id)
user := new(User)
(&, &, &)
return user
}