queries

package
v0.0.0-...-0815edb Latest Latest
Warning

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

Go to latest
Published: Mar 7, 2024 License: BSD-3-Clause Imports: 8 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type AnnouncementQueries

type AnnouncementQueries struct {
	*sqlx.DB
}

func (*AnnouncementQueries) CreateAnnouncement

func (q *AnnouncementQueries) CreateAnnouncement(v *models.Announcement) error

func (*AnnouncementQueries) DeleteAnnouncement

func (q *AnnouncementQueries) DeleteAnnouncement(id int) error

func (*AnnouncementQueries) GetAllAnnouncements

func (q *AnnouncementQueries) GetAllAnnouncements() ([]models.Announcement, error)

func (*AnnouncementQueries) GetAnnouncement

func (q *AnnouncementQueries) GetAnnouncement(userId int) (models.Announcement, error)

func (*AnnouncementQueries) GetAnnouncements

func (q *AnnouncementQueries) GetAnnouncements() ([]models.Announcement, error)

func (*AnnouncementQueries) UpdateAnnouncement

func (q *AnnouncementQueries) UpdateAnnouncement(v *models.Announcement) error

type CivilQueries

type CivilQueries struct {
	*sqlx.DB
}

func (*CivilQueries) GetAddressFromDak

func (q *CivilQueries) GetAddressFromDak(provinceId int, regencyId int, districtId int, villageId int) (models.AddressFromDak, error)

func (*CivilQueries) GetDistrict

func (q *CivilQueries) GetDistrict(id int, provinceId int, regencyId int) (models.District, error)

func (*CivilQueries) GetDistricts

func (q *CivilQueries) GetDistricts(provinceId int, regencyId int) ([]models.District, error)

func (*CivilQueries) GetProvince

func (q *CivilQueries) GetProvince(id int) (models.Province, error)

func (*CivilQueries) GetProvinces

func (q *CivilQueries) GetProvinces() ([]models.Province, error)

func (*CivilQueries) GetRegencies

func (q *CivilQueries) GetRegencies(provinceId int) ([]models.Regency, error)

func (*CivilQueries) GetRegency

func (q *CivilQueries) GetRegency(id int, provinceId int) (models.Regency, error)

func (*CivilQueries) GetVillages

func (q *CivilQueries) GetVillages(provinceId int, regencyId int, districtId int) ([]models.Village, error)

type GetTrademarkByUser

type GetTrademarkByUser struct {
	models.Trademark
}

type JWTQueries

type JWTQueries struct {
	*redis.Client
}

func (*JWTQueries) CreateAuth

func (q *JWTQueries) CreateAuth(userId uuid.UUID, td *models.JwtTokenDetails) error

func (*JWTQueries) DeleteAuth

func (q *JWTQueries) DeleteAuth(uuid uuid.UUID) (int64, error)

func (*JWTQueries) FetchAuth

func (q *JWTQueries) FetchAuth(authD *utils.JWTAccess) (uint64, error)

type LogQueries

type LogQueries struct {
	*sqlx.DB
}

func (*LogQueries) CreateLog

func (q *LogQueries) CreateLog(userId uuid.UUID, action string)

func (*LogQueries) GetLogs

func (q *LogQueries) GetLogs() ([]models.Log, error)

func (*LogQueries) GetLogsLoginByMonth

func (q *LogQueries) GetLogsLoginByMonth(year int, month int) ([]models.LogUserMonth, error)

func (*LogQueries) GetLogsLoginByYear

func (q *LogQueries) GetLogsLoginByYear(year int) ([]models.LogUserYear, error)

func (*LogQueries) GetLogsTrademarksByMonth

func (q *LogQueries) GetLogsTrademarksByMonth(year int, month int) ([]models.LogMonth, error)

func (*LogQueries) GetLogsTrademarksByYears

func (q *LogQueries) GetLogsTrademarksByYears(year int) ([]models.LogYear, error)

type TrademarkQueries

type TrademarkQueries struct {
	*sqlx.DB
	LogQueries
}

func (*TrademarkQueries) CreateTrademark

func (q *TrademarkQueries) CreateTrademark(t *models.Trademark) error

func (*TrademarkQueries) DeleteTrademark

func (q *TrademarkQueries) DeleteTrademark(id string) error

func (*TrademarkQueries) GetClass

func (q *TrademarkQueries) GetClass(id int) (models.TrademarkClass, error)

func (*TrademarkQueries) GetClasses

func (q *TrademarkQueries) GetClasses() ([]models.TrademarkClass, error)

func (*TrademarkQueries) GetStatus

func (q *TrademarkQueries) GetStatus() ([]models.TrademarkStatus, error)

func (*TrademarkQueries) GetTrademark

func (q *TrademarkQueries) GetTrademark(id string) (models.Trademark, error)

func (*TrademarkQueries) GetTrademarks

func (q *TrademarkQueries) GetTrademarks() ([]models.Trademark, error)

func (*TrademarkQueries) GetTrademarksByName

func (q *TrademarkQueries) GetTrademarksByName(name string) ([]models.Trademark, error)

func (*TrademarkQueries) GetTrademarksByUser

func (q *TrademarkQueries) GetTrademarksByUser(userId uuid.UUID) ([]models.Trademark, error)

func (*TrademarkQueries) UpdateTrademark

func (q *TrademarkQueries) UpdateTrademark(v *models.Trademark) error

func (*TrademarkQueries) UpdateTrademarkStatus

func (q *TrademarkQueries) UpdateTrademarkStatus(v *models.Trademark) error

type UserQueries

type UserQueries struct {
	*sqlx.DB
	LogQueries
}

func (*UserQueries) Auth

func (q *UserQueries) Auth(username string) (models.User, error)

func (*UserQueries) CheckDuplicateUsers

func (q *UserQueries) CheckDuplicateUsers(column string, value string) (bool, error)

func (*UserQueries) CreateUser

func (q *UserQueries) CreateUser(b *models.User) error

func (*UserQueries) DeleteUser

func (q *UserQueries) DeleteUser(id string) error

func (*UserQueries) GetUser

func (q *UserQueries) GetUser(id string) (models.User, error)

func (*UserQueries) GetUserRoles

func (q *UserQueries) GetUserRoles() ([]models.UserRoles, error)

func (*UserQueries) GetUsers

func (q *UserQueries) GetUsers() ([]models.User, error)

func (*UserQueries) UpdateUserPassword

func (q *UserQueries) UpdateUserPassword(v *models.User) error

func (*UserQueries) UpdateUserProfile

func (q *UserQueries) UpdateUserProfile(v *models.User) error

func (*UserQueries) UpdateUserRoles

func (q *UserQueries) UpdateUserRoles(v *models.User) error

Jump to

Keyboard shortcuts

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