/*
 * Amsterdam Web Communities System
 * Copyright (c) 2025-2026 Erbosoft Metaverse Design Solutions, All Rights Reserved
 *
 * This Source Code Form is subject to the terms of the Mozilla Public
 * License, v. 2.0. If a copy of the MPL was not distributed with this
 * file, You can obtain one at https://mozilla.org/MPL/2.0/.
 *
 * SPDX-License-Identifier: MPL-2.0
 */
// The database package contains database management and storage logic.
package database

import (
	"context"
	"database/sql"
)

/* AmIsEmailAddressBanned returns true if the given E-mail address is on the "banned" list.
 * Parameters:
 *     ctx - Standard Go context value.
 *     address - The E-mail address to be checked.
 * Returns:
 *     true if the address is banned, false if not.
 *     Standard Go error status.
 */
func AmIsEmailAddressBanned(ctx context.Context, address string) (bool, error) {
	var uid int32
	err := amdb.GetContext(ctx, &uid, "SELECT by_uid FROM emailban WHERE address = ?", address)
	switch err {
	case nil:
		return true, nil
	case sql.ErrNoRows:
		return false, nil
	}
	return false, err
}