bench

Documentation

Index

• Constants
• func InsertUser(db *sql.DB, query string, v *User) error
• func SliceUser(v *User) []interface{}
• func UpdateUser(db *sql.DB, query string, v *User) error
• type User
  • func ScanUser(row *sql.Row) (*User, error)
  • func ScanUsers(rows *sql.Rows) ([]*User, error)
  • func SelectUser(db *sql.DB, query string, args ...interface{}) (*User, error)
  • func SelectUsers(db *sql.DB, query string, args ...interface{}) ([]*User, error)

Constants

const CreateUserEmailStmt = `
CREATE UNIQUE INDEX IF NOT EXISTS user_email ON users (user_email)
`

const CreateUserNameStmt = `
CREATE UNIQUE INDEX IF NOT EXISTS user_name ON users (user_name)
`

const CreateUserStmt = `` /* 210-byte string literal not displayed */

const DeleteUserEmailStmt = `
DELETE FROM users 
WHERE user_email=?
`

const DeleteUserNameStmt = `
DELETE FROM users 
WHERE user_name=?
`

const DeleteUserPkeyStmt = `
DELETE FROM users 
WHERE user_id=?
`

const InsertUserStmt = `
INSERT INTO users (
 user_name
,user_pass
,user_email
,user_active
,user_created
,user_updated
) VALUES (?,?,?,?,?,?)
`

const SelectUserCountStmt = `
SELECT count(1)
FROM users 
`

const SelectUserEmailStmt = `
SELECT 
 user_id
,user_name
,user_pass
,user_email
,user_active
,user_created
,user_updated
FROM users 
WHERE user_email=?
`

const SelectUserNameStmt = `
SELECT 
 user_id
,user_name
,user_pass
,user_email
,user_active
,user_created
,user_updated
FROM users 
WHERE user_name=?
`

const SelectUserPkeyStmt = `
SELECT 
 user_id
,user_name
,user_pass
,user_email
,user_active
,user_created
,user_updated
FROM users 
WHERE user_id=?
`

const SelectUserRangeStmt = `
SELECT 
 user_id
,user_name
,user_pass
,user_email
,user_active
,user_created
,user_updated
FROM users 
LIMIT ? OFFSET ?
`

const SelectUserStmt = `
SELECT 
 user_id
,user_name
,user_pass
,user_email
,user_active
,user_created
,user_updated
FROM users 
`

const UpdateUserEmailStmt = `` /* 137-byte string literal not displayed */

const UpdateUserNameStmt = `` /* 136-byte string literal not displayed */

const UpdateUserPkeyStmt = `` /* 134-byte string literal not displayed */

Functions

func InsertUser

func InsertUser(db *sql.DB, query string, v *User) error

func SliceUser

func SliceUser(v *User) []interface{}

func UpdateUser

func UpdateUser(db *sql.DB, query string, v *User) error

Types

type User

type User struct {
	ID      int64  `sql:"pk: true, auto: true"   meddler:"user_id,pk"   db:"user_id"`
	Name    string `sql:"unique: user_name"      meddler:"user_name"    db:"user_name"`
	Pass    string `sql:""                       meddler:"user_pass"    db:"user_pass"`
	Email   string `sql:"unique: user_email"     meddler:"user_email"   db:"user_email"`
	Active  bool   `sql:"index:  user_active"    meddler:"user_active"  db:"user_active"`
	Created int64  `sql:""                       meddler:"user_created" db:"user_created"`
	Updated int64  `sql:""                       meddler:"user_updated" db:"user_updated"`
}

func ScanUser

func ScanUser(row *sql.Row) (*User, error)

func ScanUsers

func ScanUsers(rows *sql.Rows) ([]*User, error)

func SelectUser

func SelectUser(db *sql.DB, query string, args ...interface{}) (*User, error)

func SelectUsers

func SelectUsers(db *sql.DB, query string, args ...interface{}) ([]*User, error)