Versions in this module Expand all Collapse all v0 v0.4.0 Jul 19, 2020 Changes in this version + func Tx(db *sql.DB, txFunc func(*sql.Tx) error) (err error) + type DB struct + func Open(dataSource string, pingRetries int) (*DB, error) + func (db *DB) Autocomplete(q string, limit, offset int) ([]*shimmie.Autocomplete, error) + func (db *DB) CountAlias() (int, error) + func (db *DB) CountUsers() (int, error) + func (db *DB) CreateAlias(alias *shimmie.Alias) error + func (db *DB) CreateImage(ctx context.Context, img shimmie.Image) (int64, error) + func (db *DB) CreatePM(pm *shimmie.PM) error + func (db *DB) CreateTag(t *shimmie.Tag) error + func (db *DB) CreateTagHistory(ctx context.Context, th shimmie.TagHistory) (int64, error) + func (db *DB) CreateUser(u *shimmie.User) error + func (db *DB) DeleteAlias(oldTag string) error + func (db *DB) DeleteTag(name string) error + func (db *DB) DeleteUser(id int64) error + func (db *DB) FindAlias(oldTag, newTag string) ([]shimmie.Alias, error) + func (db *DB) GetAlias(oldTag string) (*shimmie.Alias, error) + func (db *DB) GetAllAlias(limit, offset int) ([]shimmie.Alias, error) + func (db *DB) GetAllTags(limit, offset int) ([]*shimmie.Tag, error) + func (db *DB) GetAllUsers(limit, offset int) ([]shimmie.User, error) + func (db *DB) GetCommon() (*shimmie.Common, error) + func (db *DB) GetConfig(keys ...string) (map[string]string, error) + func (db *DB) GetContributedTagHistory(imageOwnerUsername string) ([]shimmie.ContributedTagHistory, error) + func (db *DB) GetImage(id int) (*shimmie.Image, error) + func (db *DB) GetImageTagHistory(imageID int) ([]shimmie.TagHistory, error) + func (db *DB) GetPMs(from, to string, choice shimmie.PMChoice) ([]*shimmie.PM, error) + func (db *DB) GetRatedImages(username string) ([]shimmie.RatedImage, error) + func (db *DB) GetTag(oldTag string) (*shimmie.Tag, error) + func (db *DB) GetTagHistory(id int) (*shimmie.TagHistory, error) + func (db *DB) GetUser(userID int64) (*shimmie.User, error) + func (db *DB) GetUserByName(username string) (*shimmie.User, error) + func (db *DB) Log(section, username, address string, priority int, message string) (*shimmie.SCoreLog, error) + func (db *DB) LogRating(imgID int, imgRating, username, userIP string) error + func (db *DB) MostImageUploads(limit int) ([]shimmie.UserScore, error) + func (db *DB) MostTagEdits(limit int) ([]shimmie.UserScore, error) + func (db *DB) RateImage(id int, rating string) error + func (db *DB) Verify(username, password string) (*shimmie.User, error) + func (db *DB) WriteImageFile(w io.Writer, path, hash string) error + type Schema struct + func NewSchemer(dataSource string, pingRetries int) (*Schema, error) + func (db Schema) Create() error + func (db Schema) TruncateTables(ctx context.Context) error