 Documentation
      ¶
      Documentation
      ¶
    
    
  
    
  
    Index ¶
Constants ¶
      View Source
      
  
    const CreateUserEmailStmt = `
CREATE UNIQUE INDEX IF NOT EXISTS user_email ON users (user_email)
`
    
      View Source
      
  
    const CreateUserNameStmt = `
CREATE UNIQUE INDEX IF NOT EXISTS user_name ON users (user_name)
`
    
      View Source
      
  
    const CreateUserStmt = `` /* 210-byte string literal not displayed */
    
      View Source
      
  
    const DeleteUserEmailStmt = `
DELETE FROM users 
WHERE user_email=?
`
    
      View Source
      
  
    const DeleteUserNameStmt = `
DELETE FROM users 
WHERE user_name=?
`
    
      View Source
      
  
    const DeleteUserPkeyStmt = `
DELETE FROM users 
WHERE user_id=?
`
    
      View Source
      
  
    const InsertUserStmt = `
INSERT INTO users (
 user_name
,user_pass
,user_email
,user_active
,user_created
,user_updated
) VALUES (?,?,?,?,?,?)
`
    
      View Source
      
  
    const SelectUserCountStmt = `
SELECT count(1)
FROM users 
`
    
      View Source
      
  
    const SelectUserEmailStmt = `
SELECT 
 user_id
,user_name
,user_pass
,user_email
,user_active
,user_created
,user_updated
FROM users 
WHERE user_email=?
`
    
      View Source
      
  
    const SelectUserNameStmt = `
SELECT 
 user_id
,user_name
,user_pass
,user_email
,user_active
,user_created
,user_updated
FROM users 
WHERE user_name=?
`
    
      View Source
      
  
    const SelectUserPkeyStmt = `
SELECT 
 user_id
,user_name
,user_pass
,user_email
,user_active
,user_created
,user_updated
FROM users 
WHERE user_id=?
`
    
      View Source
      
  
    const SelectUserRangeStmt = `
SELECT 
 user_id
,user_name
,user_pass
,user_email
,user_active
,user_created
,user_updated
FROM users 
LIMIT ? OFFSET ?
`
    
      View Source
      
  
    const SelectUserStmt = `
SELECT 
 user_id
,user_name
,user_pass
,user_email
,user_active
,user_created
,user_updated
FROM users 
`
    
      View Source
      
  
    const UpdateUserEmailStmt = `` /* 137-byte string literal not displayed */
    
      View Source
      
  
    const UpdateUserNameStmt = `` /* 136-byte string literal not displayed */
    
      View Source
      
  
const UpdateUserPkeyStmt = `` /* 134-byte string literal not displayed */
    Variables ¶
This section is empty.
Functions ¶
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"`
}
     Click to show internal directories. 
   Click to hide internal directories.