helpers

Documentation

Index

• Variables
• func CheckPasswordHash(password, hash string) bool
• func Connect() (*sql.DB, error)
• func HashPassword(password string) (string, error)
• func Headers(w *http.ResponseWriter)
• type Response
  • func ResponseMsg(status bool, body interface{}) *Response

Variables

var Query = map[string]string{
	"login":          "SELECT * FROM users WHERE email = ?",
	"register":       "INSERT INTO users (name, email, password) VALUES (?, ?, ?)",
	"getContact":     "SELECT id, name, email, profile_img, about FROM users WHERE NOT id=? ORDER BY name DESC LIMIT 10",
	"getUser":        "SELECT id, name, email, profile_img, about FROM users WHERE id=?",
	"updateUser":     "UPDATE users SET name=?, email=? WHERE id = ?",
	"latestMessages": "SELECT messages.id, messages.receiver_id, messages.sender_id, users.name as sender_name, users.profile_img, messages.message, messages.created_at FROM messages INNER JOIN users ON users.id=messages.sender_id WHERE messages.id IN (SELECT MAX(id) FROM messages WHERE messages.receiver_id=? GROUP BY messages.sender_id) ORDER BY created_at DESC",
	"conversation":   "SELECT * FROM messages WHERE sender_id=? && receiver_id=? OR sender_id=? && receiver_id=? ORDER BY id",
	"postMessage":    "INSERT INTO messages (sender_id, receiver_id, message) VALUES (?, ?, ?)",
}

Functions

func CheckPasswordHash

func CheckPasswordHash(password, hash string) bool

func Connect

func Connect() (*sql.DB, error)

func HashPassword

func HashPassword(password string) (string, error)

func Headers

func Headers(w *http.ResponseWriter)

Types

type Response

type Response struct {
	Status bool        `json:"status"`
	Body   interface{} `json:"body"`
}

func ResponseMsg

func ResponseMsg(status bool, body interface{}) *Response