store

package
v0.0.0-...-dfaed9c Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Aug 19, 2022 License: MIT Imports: 6 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func InitDB

func InitDB(configuration *config.Configuration) (*sql.DB, error)

func ReplaceSticker

func ReplaceSticker(db *sql.DB, s MixinSticker) error

func ReplaceStickers

func ReplaceStickers(db *sql.DB, stickers []MixinSticker) error

func Save

func Save(db *sql.DB, album *MixinAlbum) error

func UpdateMixinStickerID

func UpdateMixinStickerID(db *sql.DB, stickerID string, mixinStickerID string) (bool, error)

func UpdateStickerIDAndUrl

func UpdateStickerIDAndUrl(db *sql.DB, albumID, stickerID, stickerUrl string) (bool, error)

Types

type MixinAlbum

type MixinAlbum struct {
	ID          string    `json:"id,omitempty"`
	AlbumID     string    `json:"album_id"`
	Name        string    `json:"name"`
	IconUrl     string    `json:"icon_url"`
	UserID      string    `json:"user_id,omitempty"`
	Category    string    `json:"category,omitempty"`
	Description string    `json:"description,omitempty"`
	Banner      string    `json:"banner,omitempty"`
	StickerID   string    `json:"sticker_id"`
	StickerUrl  string    `json:"sticker_url"`
	CreatedAt   time.Time `json:"created_at,omitempty"`
}

func FindAlbums

func FindAlbums(db *sql.DB, limit int, page int) ([]MixinAlbum, error)

func FindStickerIDByName

func FindStickerIDByName(db *sql.DB, name string) (*MixinAlbum, error)

type MixinSticker

type MixinSticker struct {
	StickerID   string    `json:"sticker_id"`
	AlbumID     string    `json:"album_id"`
	Name        string    `json:"name"`
	AssetUrl    string    `json:"asset_url"`
	AssetType   string    `json:"asset_type"`
	AssetWidth  int       `json:"asset_width"`
	AssetHeight int       `json:"asset_height"`
	CreatedAt   time.Time `json:"created_at"`
}

func FindByMixinAlbumName

func FindByMixinAlbumName(db *sql.DB, albumName string) ([]MixinSticker, error)

type Sticker

type Sticker struct {
	StickerID      string `json:"sticker_id,omitempty"`
	Url            string `json:"url"`
	StickerName    string `json:"sticker_name"`
	AlbumID        string `json:"album_id"`
	AlbumName      string `json:"album_name"`
	LocalUrl       string `json:"local_url,omitempty"`
	MixinStickerID string `json:"mixin_sticker_id,omitempty"`
}

func FindByAlbumName

func FindByAlbumName(db *sql.DB, albumName string, forApi bool) ([]Sticker, error)

func FindByUrl

func FindByUrl(db *sql.DB, url string) (*Sticker, error)

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL