Method loadGuildConfigs

internal/store/sqlite/store.go:207–254

(ctx context.Context)

}

func (s *Store) loadGuildConfigs(ctx context.Context) ([]GuildConfig, error) {
	rows, err := s.db.QueryContext(
		ctx,
		`SELECT guild_id, channel_id, thread_id, shown_assets, locale, mention_role_id, enabled, include_images
		 FROM guild_configs
		 ORDER BY guild_id`,
	)
	if err != nil {
		return nil, err
	}
	defer rows.Close()

	var result []GuildConfig
	for rows.Next() {
		var (
			record      GuildConfig
			channelID   sql.NullInt64
			threadID    sql.NullInt64
			roleID      sql.NullInt64
			shownAssets int
			enabled     int
			images      int
		)

		if err := rows.Scan(
			&record.GuildID,
			&channelID,
			&threadID,
			&shownAssets,
			&record.Locale,
			&roleID,
			&enabled,
			&images,
		); err != nil {
			return nil, err
		}

		record.ChannelID = nullInt64Ptr(channelID)
		record.ThreadID = nullInt64Ptr(threadID)
		record.MentionRoleID = nullInt64Ptr(roleID)
		record.ShownAssets = shownAssets != 0
		record.Enabled = enabled != 0
		record.IncludeImages = images != 0
		result = append(result, record)
	}

	return result, rows.Err()
}

func (s *Store) loadUserProfiles(ctx context.Context) ([]UserProfile, error) {
	rows, err := s.db.QueryContext(