package user

import "database/sql"

func Delete(db *sql.DB, id int) (sql.Result, error) {
	result, err := db.Exec("DELETE FROM users WHERE id = ?;", id)
	if err != nil {
		return result, err
	}

	rowsAffected, err := result.RowsAffected()
	if err != nil {
		return result, err
	}
	if rowsAffected == 0 {
		return result, sql.ErrNoRows
	}

	return result, nil
}