Documentation
¶
Index ¶
- Variables
- type Postgres
- func (pg *Postgres) Categories() ([]*category.Category, error)
- func (pg *Postgres) Close() error
- func (pg *Postgres) Init() error
- func (pg *Postgres) SessionBasicByToken(token string) (*session.Basic, error)
- func (pg *Postgres) SessionInsertSession(sess *session.Session) error
- func (pg *Postgres) UserAuthByEmail(email string) (*user.Auth, error)
- func (pg *Postgres) UserAuthByUID(uid int32) (*user.Auth, error)
- func (pg *Postgres) UserBasicByUID(uid int32) (*user.Basic, error)
- func (pg *Postgres) UserBasicByUsername(username string) (*user.Basic, error)
- func (pg *Postgres) UserByUID(uid int32) (*user.User, error)
- func (pg *Postgres) UserByUsername(username string) (*user.User, error)
- func (pg *Postgres) UserEmailExists(email string) (bool, error)
- func (pg *Postgres) UserInsertUser(u *user.User) (int32, error)
- func (pg *Postgres) UserInsertUserAuth(auth *user.Auth) error
- func (pg *Postgres) UserInsertUserProfile(profile *user.Profile) error
- func (pg *Postgres) UserProfileByUID(uid int32) (*user.Profile, error)
- func (pg *Postgres) UserUIDByUsername(username string) (int32, error)
- func (pg *Postgres) UserUpdateAdmin(uid int32, admin int16) error
- func (pg *Postgres) UserUpdateDeltaElectrons(uid int32, delta int32) error
- func (pg *Postgres) UserUpdateDisabled(uid int32, disabled bool) error
- func (pg *Postgres) UserUpdateElectrons(uid int32, electrons int32) error
- func (pg *Postgres) UserUpdateEmail(uid int32, email string) error
- func (pg *Postgres) UserUpdateLocked(uid int32, locked bool, till sqlnull.Time) error
- func (pg *Postgres) UserUpdatePassword(uid int32, hashed []byte) error
- func (pg *Postgres) UserUpdateProfile(uid int32, profile *user.Profile) error
- func (pg *Postgres) UserUpdateSecurityEmail(uid int32, se sqlnull.String) error
- func (pg *Postgres) UserUpdateUsername(uid int32, username string) error
- func (pg *Postgres) UserUsernameExists(username string) (bool, error)
Constants ¶
This section is empty.
Variables ¶
View Source
var SQLInitSession = `` /* 277-byte string literal not displayed */
View Source
var SQLInitUser = `` /* 793-byte string literal not displayed */
View Source
var SQLSessionBasicByToken = `SELECT token, uid, mode, expire FROM session WHERE token = $1;`
View Source
var SQLSessionInsertSession = `INSERT INTO
session (token, uid, mode, ua, ip, created, expire)
VALUES ($1, $2, $3, $4, $5, $6, $7);`
View Source
var SQLUserAuthByUID = `SELECT uid, email, password, security_email, two_factor, locked, locked_till, disabled FROM user_auth WHERE uid = $1;`
View Source
var SQLUserBasicByUID = `SELECT uid, username, admin FROM "user" WHERE uid = $1;`
View Source
var SQLUserBasicByUsername = `SELECT uid, username, admin FROM "user" WHERE lowercase = $1;`
View Source
var SQLUserByEmail = `SELECT uid, email, password, security_email, two_factor, locked, locked_till, disabled FROM user_auth WHERE email = $1;`
View Source
var SQLUserByUID = `SELECT uid, username, electrons, admin, created, deleted FROM "user" WHERE uid = $1;`
View Source
var SQLUserByUsername = `SELECT uid, username, electrons, admin, created, deleted FROM "user" WHERE lowercase = $1;`
View Source
var SQLUserEmailExists = `SELECT exists(SELECT uid FROM user_auth WHERE email = $1);`
View Source
var SQLUserInsertUser = `` /* 183-byte string literal not displayed */
View Source
var SQLUserInsertUserAuth = `` /* 167-byte string literal not displayed */
View Source
var SQLUserInsertUserProfile = `` /* 153-byte string literal not displayed */
View Source
var SQLUserProfileByUID = `SELECT uid, name, bio, location, birthday, email, social FROM user_profile WHERE uid = $1;`
View Source
var SQLUserUIDByUsername = `SELECT uid FROM "user" WHERE lowercase = $1;`
View Source
var SQLUserUpdateAdmin = `UPDATE "user" SET admin = $2 WHERE uid = $1;`
View Source
var SQLUserUpdateDeltaElectrons = `UPDATE "user" SET electrons = electrons + $2 WHERE uid = $1;`
View Source
var SQLUserUpdateDisabled = `UPDATE user_auth SET disabled = $2 WHERE uid = $1;`
View Source
var SQLUserUpdateElectrons = `UPDATE "user" SET electrons = $2 WHERE uid = $1;`
View Source
var SQLUserUpdateEmail = `UPDATE user_auth SET email = $2 WHERE uid = $1;`
View Source
var SQLUserUpdateLocked = `UPDATE user_auth SET locked = $2, locked_till = $3 WHERE uid = $1;`
View Source
var SQLUserUpdatePassword = `UPDATE user_auth SET password = $2 WHERE uid = $1;`
View Source
var SQLUserUpdateProfile = `` /* 139-byte string literal not displayed */
View Source
var SQLUserUpdateSecurityEmail = `UPDATE user_auth SET security_email = $2 WHERE uid = $1;`
View Source
var SQLUserUpdateUsername = `UPDATE "user" SET username = $2, lowercase = $3 WHERE uid = $1;`
View Source
var SQLUserUsernameExists = `SELECT exists(SELECT uid FROM "user" WHERE lowercase = $1);`
Functions ¶
This section is empty.
Types ¶
type Postgres ¶
type Postgres struct {
// contains filtered or unexported fields
}
func (*Postgres) SessionBasicByToken ¶
func (*Postgres) SessionInsertSession ¶
func (*Postgres) UserAuthByEmail ¶
func (*Postgres) UserBasicByUID ¶
func (*Postgres) UserBasicByUsername ¶
func (*Postgres) UserByUsername ¶
func (*Postgres) UserInsertUserProfile ¶
func (*Postgres) UserProfileByUID ¶
func (*Postgres) UserUIDByUsername ¶
func (*Postgres) UserUpdateAdmin ¶
func (*Postgres) UserUpdateDeltaElectrons ¶
func (*Postgres) UserUpdateDisabled ¶
func (*Postgres) UserUpdateElectrons ¶
func (*Postgres) UserUpdateEmail ¶
func (*Postgres) UserUpdateLocked ¶
func (*Postgres) UserUpdatePassword ¶
func (*Postgres) UserUpdateProfile ¶
func (*Postgres) UserUpdateSecurityEmail ¶
func (*Postgres) UserUpdateUsername ¶
Source Files
Click to show internal directories.
Click to hide internal directories.