database

package

Go to main page

Versions in this module

v1

v1.1.25

Jan 11, 2025

v1.1.24

Jul 4, 2024

v1.1.23

Jun 29, 2024

v1.1.22

Dec 22, 2023

Changes in this version

type Clip

+ IsFeatured bool

v1.1.21

Oct 10, 2023

v1.1.20

Jul 18, 2023

Changes in this version

type User

+ IsBrandedContent bool

+ UnparsedCCLs string

v1.1.19

Apr 21, 2023

v1.1.18

Apr 11, 2023

v1.1.17

Apr 5, 2023

v1.1.17-prerelease.1

Mar 20, 2023

v1.1.16

Feb 28, 2023

Changes in this version

type Ban

+ CreatedAt string

type CLIDatabase

+ func (c CLIDatabase) NewQueryWithDefaultLimit(r *http.Request, max_limit int, default_limit int) *Query

type Category

+ IGDB string

+ type ChatSettings struct

+ BroadcasterID string

+ EmoteMode *bool

+ FollowerMode *bool

+ FollowerModeDuration *int

+ NonModeratorChatDelay *bool

+ NonModeratorChatDelayDuration *int

+ ShieldModeIsActive bool

+ ShieldModeLastActivated string

+ ShieldModeModeratorID string

+ ShieldModeModeratorLogin string

+ ShieldModeModeratorName string

+ SlowMode *bool

+ SlowModeWaitTime *int

+ SubscriberMode *bool

+ UniqueChatMode *bool

type Clip

+ VodOffset int

type DropsEntitlement

+ LastUpdated string

type Query

+ func (q *Query) AddVIP(p UserRequestParams) error

+ func (q *Query) DeleteBan(p UserRequestParams) error

+ func (q *Query) DeleteVIP(broadcaster string, user string) error

+ func (q *Query) GetChatSettingsByBroadcaster(broadcaster string) (*DBResponse, error)

+ func (q *Query) GetVIPsByBroadcaster(broadcaster string) (*DBResponse, error)

+ func (q *Query) InsertChatSettings(s ChatSettings) error

+ func (q *Query) UpdateChatSettings(s ChatSettings) error

type SearchChannel

+ Tags []string

type Stream

+ Tags []string

type User

+ ChatColor string

+ type VIP struct

+ BroadcasterID string

+ CreatedAt string

+ UserID string

v1.1.15

Jan 19, 2023

v1.1.14

Dec 4, 2022

v1.1.13

Dec 2, 2022

v1.1.12

Oct 29, 2022

v1.1.11

Oct 21, 2022

v1.1.10

Oct 20, 2022

v1.1.9

Oct 18, 2022

v1.1.8

Sep 19, 2022

v1.1.7

Aug 26, 2022

v1.1.6

Apr 7, 2022

v1.1.5

Dec 7, 2021

v1.1.3

Dec 3, 2021

v1.1.2

Dec 3, 2021

Changes in this version

+ const BAN_ADD

+ const BAN_REMOVE

+ const MOD_ADD

+ const MOD_REMOVE

+ const SEP_AND

+ const SEP_OR

+ func DatabaseErrorIs(err error, sqliteError error) bool

+ type AuthenticationClient struct

+ ID string

+ IsExtension bool

+ Name string

+ Secret string

+ type Authorization struct

+ ClientID string

+ ExpiresAt string

+ ID int

+ Scopes string

+ Token string

+ UserID string

+ type Ban struct

+ ExpiresAt *string

+ ModeratorID string

+ ModeratorUserLogin string

+ ModeratorUserName string

+ Reason string

+ UserID string

+ UserLogin string

+ UserName string

+ type BanActionEvent struct

+ BroadcasterID string

+ BroadcasterLogin string

+ BroadcasterName string

+ ExpiresAt *string

+ ModeratorID string

+ ModeratorUserLogin string

+ ModeratorUserName string

+ Reason string

+ UserID string

+ UserLogin string

+ UserName string

+ type BanEvent struct

+ EventTimestamp string

+ EventType string

+ EventVersion string

+ ID string

+ type Block struct

+ UserID string

+ UserLogin string

+ UserName string

+ type CLIDatabase struct

+ DB *sqlx.DB

+ func NewConnection() (CLIDatabase, error)

+ func (c CLIDatabase) IsFirstRun() bool

+ func (c CLIDatabase) NewQuery(r *http.Request, max_limit int) *Query

+ type Category struct

+ BoxartURL string

+ ID string

+ Name string

+ ViewerCount int

+ type ChannelPointsRedemption struct

+ BroadcasterID string

+ BroadcasterLogin string

+ BroadcasterName string

+ ID string

+ RealUserInput *string

+ RedeemedAt string

+ RedemptionStatus string

+ RewardID string

+ UserID string

+ UserInput sql.NullString

+ UserLogin string

+ UserName string

+ type ChannelPointsRedemptionRewardInfo struct

+ Cost int

+ ID string

+ RewardPrompt string

+ Title string

+ type ChannelPointsReward struct

+ BackgroundColor string

+ BroadcasterID string

+ BroadcasterLogin string

+ BroadcasterName string

+ CooldownExpiresAt sql.NullString

+ Cost int

+ ID string

+ IsEnabled *bool

+ IsInStock bool

+ IsPaused bool

+ IsUserInputRequired bool

+ RealCooldownExpiresAt *string

+ RealRewardImage *string

+ RedemptionsRedeemedCurrentStream *int

+ RewardImage sql.NullString

+ RewardPrompt string

+ ShouldRedemptionsSkipQueue bool

+ Title string

+ type Clip struct

+ BroadcasterID string

+ BroadcasterName string

+ CreatedAt string

+ CreatorID string

+ CreatorName string

+ Duration float64

+ EmbedURL string

+ EndedAt string

+ GameID string

+ ID string

+ Language string

+ StartedAt string

+ ThumbnailURL string

+ Title string

+ URL string

+ VideoID string

+ ViewCount int

+ type DBResponse struct

+ Cursor string

+ Data interface{}

+ Limit int

+ Total int

+ type DefaultImage struct

+ URL1x string

+ URL2x string

+ URL4x string

+ type DropsEntitlement struct

+ BenefitID string

+ GameID string

+ ID string

+ Status string

+ Timestamp string

+ UserID string

+ type Editor struct

+ CreatedAt string

+ UserID string

+ UserLogin string

+ UserName string

+ type EventCacheParameters struct

+ Event string

+ FromUser string

+ ID string

+ JSON string

+ Timestamp string

+ ToUser string

+ Transport string

+ type EventCacheResponse struct

+ Event string

+ ID string

+ JSON string

+ Timestamp string

+ Transport string

+ type Follow struct

+ BroadcasterID string

+ BroadcasterLogin string

+ BroadcasterName string

+ FollowedAt string

+ ViewerID string

+ ViewerLogin string

+ ViewerName string

+ type GlobalCooldown struct

+ GlobalCooldownEnabled bool

+ GlobalCooldownSeconds int

+ type InternalCursor struct

+ Limit int

+ Offset int

+ type InternalPagination struct

+ PaginationCursor string

+ SQL string

+ type MaxPerStream struct

+ StreamMaxCount int

+ StreamMaxEnabled bool

+ type MaxPerUserPerStream struct

+ StreamMUserMaxCount int

+ StreamUserMaxEnabled bool

+ type Moderator struct

+ UserID string

+ UserLogin string

+ UserName string

+ type ModeratorAction struct

+ EventTimestamp string

+ EventType string

+ EventVersion string

+ ID string

+ type ModeratorActionEvent struct

+ BroadcasterID string

+ BroadcasterLogin string

+ BroadcasterName string

+ UserID string

+ UserLogin string

+ UserName string

+ type Poll struct

+ BitsPerVote int

+ BitsVotingEnabled bool

+ BroadcasterID string

+ BroadcasterLogin string

+ BroadcasterName string

+ ChannelPointsPerVote int

+ ChannelPointsVotingEnabled bool

+ Choices []PollsChoice

+ Duration int

+ EndedAt string

+ ID string

+ StartedAt string

+ Status string

+ Title string

+ type PollsChoice struct

+ BitsVotes int

+ ChannelPointsVotes int

+ ID string

+ PollID string

+ Title string

+ Votes int

+ type Prediction struct

+ BroadcasterID string

+ BroadcasterLogin string

+ BroadcasterName string

+ EndedAt *string

+ ID string

+ LockedAt *string

+ Outcomes []PredictionOutcome

+ PredictionWindow int

+ StartedAt string

+ Status string

+ Title string

+ WinningOutcomeID *string

+ type PredictionOutcome struct

+ ChannelPoints int

+ Color string

+ ID string

+ PredictionID string

+ Title string

+ TopPredictors []*PredictionPrediction

+ Users int

+ type PredictionPrediction struct

+ Amount int

+ AmountWon int

+ OutcomeID string

+ PredictionID string

+ UserID string

+ UserLogin string

+ UserName string

+ type Query struct

+ Cursor string

+ DB *sqlx.DB

+ Limit int

+ func (q *Query) AddBlock(p UserRequestParams) error

+ func (q *Query) AddEditor(p UserRequestParams) error

+ func (q *Query) AddFollow(p UserRequestParams) error

+ func (q *Query) AddModerator(p UserRequestParams) error

+ func (q *Query) CreateAuthorization(a Authorization) (Authorization, error)

+ func (q *Query) DeleteAllStreamTags(userID string) error

+ func (q *Query) DeleteBlock(from_user string, to_user string) error

+ func (q *Query) DeleteChannelPointsReward(id string) error

+ func (q *Query) DeleteFollow(from_user string, to_user string) error

+ func (q *Query) DeleteSegment(id string, broadcasterID string) error

+ func (q *Query) DeleteVideo(id string) error

+ func (q *Query) GetAuthenticationClient(ac AuthenticationClient) (*DBResponse, error)

+ func (q *Query) GetAuthorizationByToken(token string) (Authorization, error)

+ func (q *Query) GetBanEvents(p UserRequestParams) (*DBResponse, error)

+ func (q *Query) GetBans(p UserRequestParams) (*DBResponse, error)

+ func (q *Query) GetBlocks(p UserRequestParams) (*DBResponse, error)

+ func (q *Query) GetCategories(cat Category) (*DBResponse, error)

+ func (q *Query) GetChannelPointsRedemption(cpr ChannelPointsRedemption, sort string) (*DBResponse, error)

+ func (q *Query) GetChannelPointsReward(cpr ChannelPointsReward) (*DBResponse, error)

+ func (q *Query) GetChannels(u User) (*DBResponse, error)

+ func (q *Query) GetClips(c Clip, startDate string, endDate string) (*DBResponse, error)

+ func (q *Query) GetDropsEntitlements(de DropsEntitlement) (*DBResponse, error)

+ func (q *Query) GetEditors(u User) (*DBResponse, error)

+ func (q *Query) GetEventByID(id string) (EventCacheResponse, error)

+ func (q *Query) GetFollowedStreams(userID string) (*DBResponse, error)

+ func (q *Query) GetFollows(p UserRequestParams) (*DBResponse, error)

+ func (q *Query) GetModerationActionsByBroadcaster(broadcaster string) (*DBResponse, error)

+ func (q *Query) GetModeratorEvents(p UserRequestParams) (*DBResponse, error)

+ func (q *Query) GetModerators(p UserRequestParams) (*DBResponse, error)

+ func (q *Query) GetModeratorsForBroadcaster(broadcasterID string, userID string) (*DBResponse, error)

+ func (q *Query) GetPolls(p Poll) (*DBResponse, error)

+ func (q *Query) GetPredictions(p Prediction) (*DBResponse, error)

+ func (q *Query) GetSchedule(p ScheduleSegment, startTime time.Time) (*DBResponse, error)

+ func (q *Query) GetStream(s Stream) (*DBResponse, error)

+ func (q *Query) GetStreamMarkers(sm StreamMarker) (*DBResponse, error)

+ func (q *Query) GetStreamTags(id string) (*DBResponse, error)

+ func (q *Query) GetSubscriptions(s Subscription) (*DBResponse, error)

+ func (q *Query) GetTags(t Tag) (*DBResponse, error)

+ func (q *Query) GetTeam(t Team) (*DBResponse, error)

+ func (q *Query) GetTeamByBroadcaster(broadcasterID string) (*DBResponse, error)

+ func (q *Query) GetTopGames() (*DBResponse, error)

+ func (q *Query) GetUser(u User) (User, error)

+ func (q *Query) GetUsers(u User) (*DBResponse, error)

+ func (q *Query) GetVacations(p ScheduleSegment) (ScheduleVacation, error)

+ func (q *Query) GetVideos(v Video, period string, sort string) (*DBResponse, error)

+ func (q *Query) InsertBan(p UserRequestParams) error

+ func (q *Query) InsertCategory(category Category, upsert bool) error

+ func (q *Query) InsertChannelPointsRedemption(r ChannelPointsRedemption) error

+ func (q *Query) InsertChannelPointsReward(r ChannelPointsReward) error

+ func (q *Query) InsertClip(c Clip) error

+ func (q *Query) InsertDropsEntitlement(d DropsEntitlement) error

+ func (q *Query) InsertIntoDB(p EventCacheParameters) error

+ func (q *Query) InsertMutedSegmentsForVideo(vms VideoMutedSegment) error

+ func (q *Query) InsertOrUpdateAuthenticationClient(client AuthenticationClient, upsert bool) (AuthenticationClient, error)

+ func (q *Query) InsertPoll(p Poll) error

+ func (q *Query) InsertPrediction(p Prediction) error

+ func (q *Query) InsertPredictionPrediction(p PredictionPrediction) error

+ func (q *Query) InsertSchedule(p ScheduleSegment) error

+ func (q *Query) InsertStream(p Stream, upsert bool) error

+ func (q *Query) InsertStreamMarker(sm StreamMarker) error

+ func (q *Query) InsertStreamTag(st StreamTag) error

+ func (q *Query) InsertSubscription(s SubscriptionInsert) error

+ func (q *Query) InsertTag(t Tag) error

+ func (q *Query) InsertTeam(t Team) error

+ func (q *Query) InsertTeamMember(tm TeamMember) error

+ func (q *Query) InsertUser(u User, upsert bool) error

+ func (q *Query) InsertVideo(v Video) error

+ func (q *Query) RemoveModerator(broadcaster string, user string) error

+ func (q *Query) SearchCategories(query string) (*DBResponse, error)

+ func (q *Query) SearchChannels(query string, live_only bool) (*DBResponse, error)

+ func (q *Query) UpdateChannel(id string, u User) error

+ func (q *Query) UpdateChannelPointsRedemption(r ChannelPointsRedemption) error

+ func (q *Query) UpdateChannelPointsReward(r ChannelPointsReward) error

+ func (q *Query) UpdateDropsEntitlement(d DropsEntitlement) error

+ func (q *Query) UpdatePoll(p Poll) error

+ func (q *Query) UpdatePollChoice(p PollsChoice) error

+ func (q *Query) UpdatePrediction(p Prediction) error

+ func (q *Query) UpdateSegment(p ScheduleSegment) error

+ type Schedule struct

+ Segments []ScheduleSegment

+ UserID string

+ UserLogin string

+ UserName string

+ Vacation *ScheduleVacation

+ type ScheduleSegment struct

+ CanceledUntil *string

+ Category *SegmentCategory

+ CategoryID *string

+ CategoryName *string

+ EndTime string

+ ID string

+ IsCanceled *bool

+ IsRecurring bool

+ IsVacation bool

+ StartTime string

+ Timezone string

+ Title string

+ UserID string

+ type ScheduleVacation struct

+ EndTime string

+ ID string

+ StartTime string

+ type SearchChannel struct

+ CategoryID *string

+ CategoryName *string

+ DisplayName string

+ ID string

+ IsLive bool

+ Language string

+ StartedAt *string

+ TagIDs []string

+ ThumbNailURL string

+ Title string

+ UserLogin string

+ type SegmentCategory struct

+ CategoryName *string

+ ID *string

+ type Stream struct

+ CategoryID sql.NullString

+ CategoryName sql.NullString

+ ID string

+ IsMature bool

+ Language string

+ RealCategoryID string

+ RealCategoryName string

+ StartedAt string

+ StreamType string

+ TagIDs []string

+ ThumbnailURL string

+ Title string

+ UserID string

+ UserLogin string

+ UserName string

+ ViewerCount int

+ type StreamMarker struct

+ BroadcasterID string

+ CreatedAt string

+ Description string

+ ID string

+ PositionSeconds int

+ URL string

+ VideoID string

+ type StreamMarkerUser struct

+ BroadcasterID string

+ BroadcasterLogin string

+ BroadcasterName string

+ Videos []StreamMarkerVideo

+ type StreamMarkerVideo struct

+ Markers []StreamMarker

+ VideoID string

+ type StreamTag struct

+ TagID string

+ UserID string

+ type Subscription struct

+ BroadcasterID string

+ BroadcasterLogin string

+ BroadcasterName string

+ CreatedAt string

+ GifterID *sql.NullString

+ GifterLogin *sql.NullString

+ GifterName *sql.NullString

+ IsGift bool

+ PlanName string

+ Tier string

+ UserID string

+ UserLogin string

+ UserName string

+ type SubscriptionInsert struct

+ BroadcasterID string

+ CreatedAt string

+ GifterID *sql.NullString

+ IsGift bool

+ Tier string

+ UserID string

+ type Tag struct

+ ID string

+ IsAuto bool

+ Name string

+ type Team struct

+ BackgroundImageUrl *string

+ Banner *string

+ CreatedAt string

+ ID string

+ Info string

+ TeamDisplayName string

+ TeamName string

+ ThumbnailURL string

+ UpdatedAt string

+ Users []TeamMember

+ type TeamMember struct

+ TeamID string

+ UserID string

+ UserLogin string

+ UserName string

+ type User struct

+ BroadcasterType string

+ CategoryID sql.NullString

+ CategoryName sql.NullString

+ CreatedAt string

+ Delay int

+ DisplayName string

+ Email string

+ ID string

+ Language string

+ ModifiedAt string

+ OfflineImageURL string

+ ProfileImageURL string

+ Title string

+ UserDescription string

+ UserLogin string

+ UserType string

+ ViewCount int

+ type UserRequestParams struct

+ BroadcasterID string

+ CreatedAt string

+ UserID string

+ type Video struct

+ BroadcasterID string

+ BroadcasterLogin string

+ BroadcasterName string

+ CategoryID *string

+ CreatedAt string

+ Duration string

+ ID string

+ MutedSegments []VideoMutedSegment

+ PeriodDate string

+ PublishedAt string

+ StreamID *string

+ ThumbnailURL string

+ Title string

+ Type string

+ URL string

+ VideoDescription string

+ VideoLanguage string

+ ViewCount int

+ Viewable string

+ type VideoMutedSegment struct

+ Duration int

+ VideoID string

+ VideoOffset int

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